Trading Journal CSV Import: A Reconciliation Checklist
Prepare completed round trips for our canonical CSV and keep an audit trail when moving records between trading journals.
Raw fills are not completed trades
A broker export may contain orders, cancellations, fills, transfers, dividends and funding. This tool expects one completed round trip per row. Combine partial fills and allocate commissions outside this tool using a documented method. We do not guess a FIFO or average-cost matching policy.
Required schema and units
Download the invented sample. Keep the exact header order: id, openDate, closeDate, symbol, side, quantity, entry, exit, multiplier, fees, risk, setup, notes. IDs, symbols and setup tags must be single-line text without tabs. Dates must be YYYY-MM-DD. Use Long or Short and plain dot decimals without currency symbols or thousands separators. Quantity, prices and multiplier allow six decimals; fees and planned risk allow two. Planned risk, setup and notes may be blank; other fields are required.
One currency per dataset
All price-times-quantity values, fees and planned risk must already be in the selected reporting currency. A multiplier is a linear contract multiplier, not an FX exchange rate or leverage setting. Do not mix currency accounts. Changing currency only relabels amounts; clear the dataset before selecting a new currency.
Preview before replacing
CSV is strict UTF-8, up to 2 MB and 5,000 trades. JSON backups allow 16 MB; every accepted dataset is checked against that backup limit. IDs must be unique exactly as entered; different IDs can still describe duplicate trades and require your own statement reconciliation. A failed row rejects the import rather than silently dropping it. Preview then explicitly replace the entire tab dataset; keep a JSON backup first.
Safe exports and private backups
Filtered CSV includes only selected trades and prefixes spreadsheet-formula-like text with an apostrophe. That protective change can remain if CSV is imported again. Full JSON preserves exact original text and all trades and recalculates results on restore. No file is uploaded by the journal. The site may use existing infrastructure analytics, so do not infer anonymous network browsing.
Open the free closed-trade journal ยท Compare selected providers