Local broker tax workspace

Parse IBKR and Longbridge tax files inside your browser, set annual CNY FX rates, and generate Mainland China foreign-income review reports without uploading statements.

No login, no server upload, no cloud storage. Longbridge PDF binary parsing is not enabled in v1; export CSV or paste statement table text instead.

1. Select broker

2. Import files or pasted text

Longbridge CSV or copied statement table textChoose local fileCSV/XML files are parsed locally. PDF is documented but not parsed in browser v1.Paste statement text

3. Annual configuration

Tax yearAccount labelUSD to CNYHKD to CNY

Local-only. Files are read in this browser session and are not uploaded to TickerVal, PureToolkit, Cloudflare, or any backend API.

4. 2025 Report summary (CNY)

Import local files and generate a report to replace this preview.

Browser local

Realized gainsCapital transfer income candidateCN¥0.00

¥Dividend / interestInterest, dividend, and bonus incomeCN¥0.00

%Foreign tax paidWithholding tax candidateCN¥0.00

Candidate tax dueAfter foreign tax credit candidateCN¥0.00

Warnings and review items

Import warnings such as unclassified rows, missing cost basis, missing FX, or unknown source regions will appear here.

5. Local report downloads

Generate a report to download Markdown and CSV review files.

Guide

Required files

LBLongbridge

Use Longbridge CSV exports when available, or copy statement table text from monthly statements into the paste box.
Browser v1 does not decrypt or parse Longbridge PDF files directly.
Prepare the full tax year and avoid hand-merging rows unless you keep the original columns intact.
Include trades, cash dividends, interest, fees, and withholding-tax rows when available.

IBIBKR

Use Activity Statement, Flex Query XML, Flex CSV, PortfolioAnalyst CSV, or Chinese Activity Statement CSV.
Include Trades, Cash Transactions, Dividends, Interest, Withholding Tax, Fees, and Commissions.
Chinese Activity Statement CSV should include realized/unrealized performance, trades, dividends, interest, and withholding-tax sections.
Realized totals stay separate from unrealized P/L.

Mainland China Foreign-Income Rules

The calculations are candidate values for resident-individual review, not filing advice.

Resident individuals report China-sourced and foreign-sourced income by calendar tax year; foreign income is generally self-declared from March 1 to June 30 of the following year.
Foreign securities sales are treated as capital transfer income candidates: proceeds minus original cost and reasonable transfer expenses.
Dividends and interest are treated as interest, dividend, and bonus income candidates. Both categories use a 20% proportional rate in this workspace.
Only realized gains/losses are included. Unrealized positions are never included in candidate tax due.
Foreign tax paid is a credit candidate only. The credit is capped by the China tax payable on foreign income for the relevant country/region; excess credit may require separate five-year carry-forward review.
Foreign-currency amounts use manually supplied annual CNY rates. Replace missing or fallback rates before filing.

Official references

Individual Income Tax Law Implementation Regulations MOF/STA Announcement 2020 No. 3 Annual self-declaration Form B notes

Tips

Longbridge file guide IBKR file guide Mainland China rules FX rate notes

Deployment model

Cloudflare Access is not required for this version because no statement file is uploaded or stored on a server.

Review aid only

This workspace organizes broker statements for personal review. It is not tax, legal, or investment advice. Final filing should be checked against the tax bureau workflow and professional advice when needed.