第 20 章

匯入與匯出

到 管理 → 匯入匯出。

券商檔案匯入（CSV、Excel）

1. 在「券商檔案匯入」按「選擇檔案」，選券商 App 或網頁匯出的交易明細（CSV 或 .xlsx）。
2. 程式自己找表頭、猜每一欄是什麼。元大、國泰、永豐、富邦、凱基、群益金鼎、台新、統一、華南永昌、兆豐與三竹系統的格式已經內建。 確認成交日期、股票代號、買賣別、股數、成交價（必填），有手續費欄也選上；股數是張的話切成張。
3. 買賣別如果有沒認出的說法，加到「買進」或「賣出」那一格。

1. 選要匯到哪個證券帳戶，按「試算」：看會新增幾筆、哪些已經記過（會跳過）、哪些列有問題。
2. 沒問題再按「匯入」。這次的對應可以存起來（例如取名「元大」），下次直接套用。

重複匯入不會記兩次，所以每個月把最近一段期間整份丟進來就好。匯錯了按「撤銷這次匯入」，或展開「匯入紀錄」撤銷某一批。匯入期間的除權息到配息紀錄的公司行動提醒帶入。

集保證券存摺（PDF）

集保 e 手掌握匯出的「證券存摺」PDF：選檔案、輸入密碼（身分證字號，英文大寫）、選證券帳戶，按「讀取」。集保沒有成交價，買進、賣出會變成待補成本，照對帳單填成交價後按 ✓ 確認；庫存資料拿來和帳上的持股對帳。勾「記住密碼」會存在這台電腦的認證管理員。

股利對帳（財政部所得資料）

報稅時從綜所稅系統下載自己的所得資料，選檔案按「對帳」，逐家列出所得資料、帳上的金額和差額。只是對帳，不會新增或修改紀錄；ETF 第一次要選是哪一檔，之後會記住。

匯出

選要匯出的資料（預設全部 19 種）、格式（Excel 活頁簿一個 xlsx 每種一個分頁，或 CSV）、表頭語言，按「匯出」。匯出的檔案沒有加密，是完整的帳本，請收好。投資日誌只匯出文字，附圖只跟著雲端備份走。

匯入

選「整本 Excel」或「單一 CSV」，挑檔案，先按「試跑（不寫入）」只檢查格式，沒問題再按「確認匯入」。格式錯誤會整份擋下來，告訴你第幾列哪裡錯。先匯出一份當範本最省事。

Chapter 20

Import and export

Go to Manage → Import / Export.

Broker file import (CSV, Excel)

1. In “Broker file import”, click “Choose file” and pick the trade history exported from your broker's app or website (CSV or .xlsx).
2. The app finds the header row and guesses what each column is. Formats from Yuanta, Cathay, SinoPac, Fubon, KGI, Capital, Taishin, President, Hua Nan, Mega and Mitake-based systems are built in. Check trade date, symbol, buy/sell, shares and price (required), and pick the fee column too if there is one. If shares are in lots, switch to lots.
3. If some buy/sell wording isn't recognized, add it to the “Buy” or “Sell” box.

1. Choose which securities account to import into and click “Dry run”: see how many trades will be added, which are already recorded (they are skipped) and which rows have problems.
2. If all looks fine, click “Import”. You can save this column mapping (for example as “Yuanta”) and reuse it next time.

Importing the same file again never records trades twice, so each month you can simply drop in the whole recent period. If something went wrong, click “Undo this import”, or expand “Import history” to undo a particular batch. Ex-dividend events during the imported period are added from the corporate action reminders in Dividends.

TDCC securities passbook (PDF)

For the “securities passbook” PDF exported from the TDCC e-Passbook app (集保 e 手掌握): choose the file, enter the password (your national ID number, upper-case letter), pick the securities account and click “Read”. TDCC has no trade prices, so buys and sells become cost to fill in: enter the trade price from your statement and click ✓ to confirm. The holdings data is used to reconcile against the positions in your ledger. Tick “remember password” to store it in this computer's credential manager.

Dividend check (Ministry of Finance income records)

At tax time, download your income records from the individual income tax system, choose the file and click “Check”. It lists, payer by payer, the income records, the amounts in your ledger and the difference. It only compares and never adds or changes records. The first time, you choose which ETF each entry is; it is remembered after that.

Export

Choose what to export (all 19 kinds by default), the format (Excel workbook: one xlsx with a sheet per kind, or CSV) and the header language, then click “Export”. Exported files are not encrypted and contain your full ledger, so keep them safe. The journal exports text only; images are included only in cloud backups.

Import

Choose “Whole Excel workbook” or “Single CSV”, pick the file, and first click “Dry run” to check the format without writing anything. If all is fine, click “Import”. Format errors block the whole file and tell you which row is wrong and why. Exporting a file first to use as a template is the easiest way.