CICC Wealth Management statements: how to export them and turn them into clean data

At CICC Wealth Management (中金财富), one funds account holds your cash per currency, your listed securities and your OTC wealth-management products together. The statement export lists every cash movement in that account. Selfirm reads it, with one important limit: the balance column in this file cannot be used to check the movements.

What CICC Wealth Management provides, and what Selfirm reads

File	Format	In Selfirm
Account statement export (对账单)	Text (GBK, fixed-width columns)	Read
Holdings and trade confirmations		Not read

How to export the statement

We have not confirmed the current steps against an official CICC Wealth Management help page, so the following is general.

In the broker’s trading software or app, open the account query area, choose the statement (对账单) or funds flow for a date range, and export it as a text file.

What the file looks like

Fixed-width text in GBK. The columns are lined up with spaces, not separated by commas or tabs. Opened as UTF-8 the Chinese text is garbled; split on spaces and any description that contains a space breaks the row. Read it as GBK and cut the columns by position under the header.

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

The columns Selfirm uses are 发生日期 (date, YYYY-MM-DD), 业务名称 (type of movement), 证券名称 (security name), 备注 (note), 币种 (currency, written as 人民币, 美元, 港币), 发生金额 (signed amount) and 资金本次余额 (balance).

The balance does not follow the amounts. On repo rows, OTC rows and some others, 资金本次余额 does not change by the row’s amount. Checking opening + in − out = closing on this column fails even when every movement is right. Selfirm reads the column but does not use it to check the rows.

Zero-amount reinvestment rows. OTC 现金宝分红再投 rows record dividends of the cash-management product being reinvested. Most of them have an amount of 0.

Many movements are transfers within the account. Repos, 现金宝 subscriptions and redemptions, fund subscriptions and OTC product flows move cash into another holding in the same account. They are not spending or income.

业务名称 contains	Meaning	Proposed as
质押回购, 拆出质押, 回购融券, 融券购回	Repo	Transfer between cash and holdings
现金宝申购, 现金宝赎回	Cash-management product in and out	Transfer between cash and holdings
OTC业务资金	OTC product cash	Transfer between cash and holdings
证券买入, 证券卖出	Buying and selling securities	Transfer between cash and holdings
银证转账, 银行转存, 银行转取	Money between your bank and the broker	Transfer
股息, 红利	Dividends	Investment income

Example

Fictional data, as the columns line up in the text file:

发生日期     业务名称            证券名称      币种     发生金额    资金本次余额
2026-03-05   银行转存                          人民币   10000.00    10000.00
2026-03-06   现金宝申购          示例现金宝    人民币   -8000.00    2000.00
2026-03-15   OTC现金宝分红再投   示例现金宝    人民币   0.00        2000.00
2026-03-20   质押回购            示例回购      人民币   -1000.00    2000.00

The last row moves 1,000.00 out of cash, but the printed balance stays at 2,000.00. That is the behaviour that makes the balance column unusable for checking.

Read as movements (the zero-amount reinvestment row is left out of this table; it moves no cash):

Date	Description	Amount (CNY)	Proposed as
2026-03-05	银行转存	10,000.00	Transfer from your bank
2026-03-06	现金宝申购 · 示例现金宝	-8,000.00	Transfer to holdings
2026-03-20	质押回购 · 示例回购	-1,000.00	Transfer to holdings

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 statement by its column names, handles the encoding and the fixed-width layout, and keeps each currency separate. Because the file has no account number, you tell Selfirm which account it is.

Because the balance column is not a running balance, Selfirm keeps it for reference only and does not check this statement’s rows against it the way it checks a bank statement, so it does not raise false mismatches. Rows repeated across overlapping exports are counted once. Bank-to-broker transfers are proposed as pairs 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 Securities, China Merchants Bank, Bank of China, Bank of Communications, HSBC China.