China Merchants Securities statements: how to export them and turn them into clean data

At China Merchants Securities (招商证券), one funds account holds a cash balance per currency, with your securities in the same account. The funds flow (资金流水) export lists every change to the cash balance. Selfirm reads it.

What China Merchants Securities provides, and what Selfirm reads

File	Format	In Selfirm
Funds flow export (资金流水)	Text (GBK, tab-separated)	Read
Trade records and holdings		Not read

How to export the funds flow

We have not confirmed the current steps against an official China Merchants Securities help page, so the following is general.

In the broker’s trading software, open the query area, choose the funds flow (资金流水) for a date range and use the export option to save it as a text file.

What the file looks like

GBK-encoded, tab-separated text. Opened as UTF-8, the Chinese column names and descriptions turn into garbled characters. Read it as GBK with tab as the separator.

Newest first. The most recent movement is at the top.

No account number. Nothing in the file says which account it belongs to.

The columns Selfirm uses are 成交日期 (date), 业务名称 (type of movement), 证券名称 (security name), 币种 (currency, written as 人民币, 美元, 港币), 发生金额 (signed amount) and 资金余额 (cash balance).

Dates have no separators: 20260305. Spreadsheets often read this as the number 20,260,305.

The amount is signed in one column: money out is negative.

Rows that move no money. 调整利息积数 adjusts the interest calculation base. It is printed like a movement but changes no balance.

Sales show cash only. When you sell, the row shows the cash received. Cost and gain or loss are not in the file.

What the common 业务名称 values mean, and how Selfirm proposes to classify them:

业务名称 contains	Meaning	Proposed as
银证转账, 银行转存, 银行转取	Money between your bank and the broker	Transfer
证券买入, 证券卖出	Buying and selling securities	Transfer between cash and holdings
股息, 红利	Dividends	Investment income
利息归本	Interest credited	Investment income
组合费	Stock Connect portfolio fee	Investment expense
调整利息积数	Interest base adjustment	Not a movement

Example

Fictional data, as the rows appear once the file is read correctly:

成交日期	业务名称	证券名称	币种	发生金额	资金余额
20260320	股息入账	示例股份	人民币	40.00	3,040.00
20260312	调整利息积数		人民币	0.00	3,000.00
20260306	证券买入	示例股份	人民币	-2,000.00	3,000.00
20260305	银行转存		人民币	5,000.00	5,000.00

Read oldest first:

Date	Description	Amount (CNY)	Balance	Proposed as
2026-03-05	银行转存	5,000.00	5,000.00	Transfer from your bank
2026-03-06	证券买入 · 示例股份	-2,000.00	3,000.00	Transfer to holdings
2026-03-20	股息入账 · 示例股份	40.00	3,040.00	Investment income

The 调整利息积数 row is kept as a note, not a movement.

Bringing it into Selfirm

Selfirm is in early access. You upload the text file as the broker produced it, or a folder of exports at once. Selfirm recognises the funds flow by its column names, handles the encoding and order, and keeps each currency’s balance separate.

Because the file has no account number, you tell Selfirm which account it is the first time. Later exports are placed by matching their balances with what is already there; if a file fits more than one account, Selfirm asks.

It checks that each balance runs correctly row by row and from one export to the next. Rows repeated across overlapping exports are counted once. For 银证转账 rows, Selfirm proposes a pairing with the bank side when the bank’s statement is also in Selfirm. Each movement is classified as income, expense or transfer for you to confirm, and every figure links back to the row of the file it came from.

Exporting to CSV or Beancount is planned, not available today. Join the waitlist to try it.

Other mainland China institutions Selfirm reads: China Merchants Bank, CICC Wealth Management, Bank of China, Bank of Communications, HSBC China.