PnL Book
Start journaling

Broker import

Every account you trade, one import screen

Import supported broker files or map CSV and Excel columns yourself. Automatic header suggestions, worksheet preview, date formats and a review before saving.

Paper statements organised into a charcoal folder with an orange tab.
From a statement to your journalUpload a file, match its columns, then review the trades before adding them to your journal.

Your file, your column names

Choose Any broker — map CSV or Excel for an unfamiliar export. Select a worksheet and header row, check suggested matches, and map the remaining fields. Choose the date format, decimal separator and statement timezone before parsing.

Indian tradebooks use individual executions. Forex and crypto mapping requires closed positions with reported gross P&L in the account currency. Files support up to 10,000 rows and 8MB; save older .xls workbooks as .xlsx. Nothing enters your journal until you confirm the review.

Import availability and evidence

Support depends on the exact report format, market and account currency. Automated fixture tests check parser behavior; they do not certify every live broker export. Compare trade counts, gross P&L and fees with your original statement before committing.

Indian broker tradebooks
Zerodha, Groww, Upstox, Fyers and Angel One file adapters, plus configured Indian broker connections. Review every batch and check symbol and fee handling against your statement.
MetaTrader 4 / MetaTrader 5
HTML closed-position statements. Choose the broker statement timezone explicitly, including its daylight-saving rules. Use account-currency reported P&L; a price derived from that P&L is not shown as an actual execution.
cTrader, DXtrade and TradeLocker — field mapping
Use “Any broker — map CSV or Excel” for a complete closed-position report. Explicitly map gross P&L and fees, and check that the amounts use your account currency. Native CSV adapters are paused until source currency and cost fields can be validated against real statements.
Binance, Bybit and Coinbase CSV — beta
Limited complete closed histories; Binance CSV currently supports spot only. Overlapping same-symbol positions are unsupported. Unsupported fee currencies, inverse contracts, incomplete positions or unsupported price precision are rejected. Real export reconciliation is still pending. USD, USDT and USDC are not converted using a market exchange rate.
Forex and crypto API sync, screenshots and manual fills
Unavailable while quantity, contract and currency reconciliation is completed. Use supported statements or mapped closed-position files.
US stocks, options and futures
No dedicated validated adapter yet. Generic column mapping does not establish support for contract multipliers, fractional shares or option-symbol conventions.

Check the numbers before saving

  1. Match the account currency and statement timezone.
  2. Review trade counts, gross results, fees and net results against the original file.
  3. Resolve rejected rows and duplicate warnings. Do not fill missing execution prices with a P&L-derived estimate.
  4. Keep the original statement for reconciliation and export the journal with currency and market metadata.

Create a journal, compare plans or ask about your report format.

Frequently asked questions

Which brokers and platforms can I import from?

Indian broker adapters and MetaTrader statements are available alongside generic CSV/Excel mapping. cTrader, DXtrade and TradeLocker use explicit field mapping while native adapters are paused. Binance, Bybit and Coinbase file adapters are beta and still need real-statement reconciliation. Forex and crypto API sync, screenshots and manual fills are currently unavailable; see the availability table for exact limits.

Zerodha and Upstox handle symbols differently — does that break anything?

No, but it's worth knowing: Zerodha's Console export stores the option/futures symbol exactly as its exchange feed does, while Upstox and Angel One normalise the symbol format before you download it. PnL Book's parser accounts for each broker's own convention, so trades from either come in correctly paired regardless of which raw format the broker used.

What if my broker or exchange isn't on the list?

Choose Any broker — map CSV or Excel. PnL Book suggests column matches; confirm or change them, choose the date format and timezone, then review the parsed rows. Indian accounts accept execution rows; forex and crypto accounts require closed positions with reported gross P&L in account currency. Screenshots are available for Indian-market accounts only, with every extracted row reviewed before saving.

Is anything saved automatically when I import?

File and screenshot uploads require review and confirmation. Connected broker synchronization follows its configured sync workflow. Check the account currency, units, timestamps and fees against your statement; duplicate detection does not establish accuracy.