Import broker statement
Upload a broker statement to automatically populate your transaction history.
Last reviewed
Screenshot, for illustration only




Supported formats
Before you upload, the import page asks “What kind of statement?” with five options: Auto-detect, Transaction history, Current holdings, Combined statement and Lending statement. Leaving it on Auto-detect is fine: the answer records what the file contains, and the reader works out the layout from the file itself either way.
Transaction history
These list individual buy, sell, and dividend transactions with dates, quantities, and prices. This is what every broker CSV and spreadsheet reader produces, and it is the best way to build a complete history.
Current holdings
These show your positions as a snapshot rather than a list of trades. Only the Indian consolidated account statement (CAS) is read this way: each holding becomes a transfer-in row dated today, priced at the statement’s valuation. A detailed mutual fund CAS that also lists each scheme’s transactions is read as a history instead. A holdings-only export from any other broker has no trades to read, so import a transaction history instead where your broker offers one.
Lending statement
These come from a peer-to-peer lending or crowdfunding platform and list loan parts, repayments, interest and yearly totals rather than share trades.
Which files work
Each upload is one file of up to the size shown on the import page.
File types and plans
CSV
Every plan. Read without AI by the dedicated reader for your broker. Columns separated by commas, semicolons, tabs or bars, and files saved as UTF-8, UTF-16 (Excel "Unicode text") or Windows text, are all read.
Excel (XLSX, XLS)
Plans that include spreadsheet, PDF and photo imports. Read without AI.
Bank and broker files (OFX, QFX, QIF, Interactive Brokers Flex XML)
Plans that include spreadsheet, PDF and photo imports. Read without AI.
Plans that include spreadsheet, PDF and photo imports. Read by our AI, except the Indian CAS, which is read without AI.
Photos and screenshots (JPG, PNG, HEIC, HEIF, WebP)
Plans that include spreadsheet, PDF and photo imports. Read by our AI.
Plans that do not include spreadsheets, PDFs and photos still import CSV files. See pricing for what each plan includes.
Which statement to download
- For your history: a transaction or activity statement, which lists every buy, sell and dividend.
- For a starting point: a holdings or valuation statement, which shows what you own on one date. We compare it with your history and show any differences.
- For the best result: both. The history builds your records and the holdings statement checks them.
Bank and broker export files
Many banks and brokers offer a download for money-management software, often labelled OFX, QFX, Quicken, Money or QIF. These files are read without AI, whichever broker you picked at upload.
- OFX and QFX: both the older text layout and the newer XML layout are read. Buys, sells, dividends, reinvested dividends and their fees and taxes are imported.
- QIF: the investment sections are imported. Where the file never shows which number in a date is the day and which is the month, the row is set aside rather than guessed.
- Interactive Brokers Flex Query (XML): trades, dividends and withholding tax are imported. Any other XML file is not read and the import stops with “This file is not an OFX, QFX, QIF or Interactive Brokers Flex Query file we can read”.
How to import
The importer runs in three steps, shown as Upload, Review and Confirm across the top of the page.
- Open Import statements in the sidebar, under Estate & assets → Portfolio
- Answer “What kind of statement?” and pick the broker or app the file came from
- Drop your file on the upload area or click to browse (the accepted formats and size shown on the import page); the upload starts as soon as you choose a file, with no separate upload button
- Watch the progress rows: scanning for viruses, reading your statement, extracting holdings, matching securities, ready for review
- Review the parsed transactions and resolve anything flagged for attention
- Press the confirm button, which names the count it will create, for example “Confirm 42 transactions”
A copy of every statement you upload is kept in your document vault, under Financial → Broker statements. Each import under Recent imports, and the result of uploading a statement in Add securities, shows a Saved to your vault link that opens that copy.
Supported brokers
You do not have to tell us the layout. Each of these brokers has a dedicated reader that recognises its export from the column headings, whichever broker you picked at upload. Each name below links to a step-by-step export guide.
CSV exports
- Interactive Brokers: Activity statement CSV
- Trading 212: transaction history CSV
- Freetrade: activity CSV
- IG: share dealing history CSV
- interactive investor: transaction history CSV
- Hargreaves Lansdown: transaction history CSV
- Fidelity: transaction history CSV
- Charles Schwab: transaction history CSV
- Zerodha: tradebook CSV
- AJ Bell: transaction history CSV
Spreadsheet exports
Spreadsheet readers do not assume the headings sit on the first row. They scan the top of the sheet for the real heading row, so an export with a title block above the table still reads correctly.
PDF statements
The Indian CDSL and NSDL consolidated account statement has a dedicated PDF reader, including password-protected files. Any other PDF, or a photo of a statement, is read by our self-hosted document extraction system. Your financial documents never leave our servers without your approval.
Portfolio trackers and crypto exchanges
CSV exports from portfolio trackers and crypto exchanges have dedicated readers too, each with its own guide: Sharesight, Delta, Coinbase, Kraken, Binance and Bybit (USDT perpetuals). Anything else is covered by importing from another broker.
Guides for brokers read by AI
These brokers have no dedicated reader, so their files are read by AI extraction. Each guide says which file to download:
- Vanguard UK: transactions download or statement PDFs
- Degiro: transactions CSV and account statement
Which asset classes we read
Statements are not limited to shares. The reader also recognises these, and each row appears in the review table with its own transaction type:
- Crypto exchange and wallet exports, including very small dust balances
- CFDs, spread bets, FX margin, futures and crypto perpetuals, with their financing charges
- Multi-currency wallets and broker currency conversions, recorded as both currency legs
- Bonds, gilts and funds: coupons, accrued interest, redemptions, calls, notional distributions and equalisation
- Options and warrants (exercise, assignment, expiry) and employee share plans (vests, sell-to-cover, ESPP purchases)
- Bullion vault and dealer statements, and exchange-traded commodities
- Private company holdings from crowdfunding and angel statements, share certificates and cap-table exports, including funding rounds, conversions, exits and write-offs
Some rows carry a short note after their type: a coupon paid after you bought the bond with accrued interest reads “incl. accrued interest”, an option that expired with nothing paid reads “Expired worthless”, and a funding round shows its price per share. The statement summary also counts income rows, derivatives closed and company events, when the statement has any.
Password-protected files
If a PDF or spreadsheet needs a password to open, the upload pauses and asks for it in “Document is password-protected”. We unlock the file on our servers and keep the unlocked copy, so you are not asked again for this import.
- Saving the password: the box to save it is ticked by default, and the password is stored encrypted against the broker you picked. Next time the window says “Using your saved password”. If you did not pick a broker, nothing is saved.
- Managing saved passwords: view or delete them on Saved broker passwords. Showing one is recorded.
- Wrong password: the window says “Incorrect password. Try again.” If a saved password no longer works, it says so and asks you to type it.
- Files that only restrict printing or editing: a PDF that opens without a password is read straight away and you are not asked for one.
Password-protected spreadsheets, PDFs and photos follow your plan’s file rules: if your plan imports CSV files only, you see the upgrade message before any password prompt.
Screenshots and phone photos
A screenshot or a photo of a paper statement is read by our AI, like a PDF. JPG, PNG, HEIC, HEIF and WebP all work: iPhone HEIC photos are turned upright and converted for you, so you do not need to change the format first.
- Photograph the whole page, flat and in good light, with the figures sharp enough to read.
- Keep the column headings and any totals in the shot; they help us check what we read.
- Each upload is one image. For a statement that runs over several pages, upload the PDF if you have it, or one photo per page.
Number and date formats
Numbers
We read numbers written the way your statement writes them: 1,234.56 or 1.234,56, Swiss 1’234.56, spaced groups, Indian 1,23,456.00, and negatives shown in brackets or with a trailing minus. Where a number could be read either way, we use the rest of the column and your broker’s country to decide.
A number we cannot read is never booked as zero. The row is set aside with the note “A number on this row could not be read”, so you can check it and add it by hand, and the review lists it under Rows skipped.
Dates
To tell whether 03/04 means 3 April or 4 March, we first look for a date in the same statement that can only be read one way, such as 30/06. If there is none, we use your broker’s country: day first everywhere except the United States and a few countries that follow it. If neither settles it, we do not guess; a row whose date cannot be read is set aside and not imported, with the note “Date could not be read”.
Currencies
Each transaction keeps the currency printed on its row, checked against the security’s identifier. A row with no currency we can work out is flagged in the review for you to choose one.
Your statement’s exchange rate and ours
When a statement prints the exchange rate it used, we book the trade at that rate. If it differs noticeably from our rate for the same day, the review shows “The exchange rate on your statement differs from ours” and lists both rates for each trade, so you can check them. Nothing is blocked.
The “Paid” figure
If you buy a US share from a sterling account, the trade is in dollars but the money that left your account was in pounds. When the statement prints that amount, we keep it. Your transactions list then shows it under the trade amount, for example “Paid £790.00 at 1 USD = 0.7900 GBP, from your statement”. A sale or dividend reads “Received” instead. The words after the rate say where it came from: your statement, our rate for that day, or a rate you entered yourself.
Gains and costs in your home currency use this figure when it is in that currency, so they match what you actually paid. Rows without it, including transactions imported before we kept it, use our exchange rate for the trade date instead.
Pence and other minor units
Some UK brokers quote share prices in pence. Freetrade and Trading 212 exports are converted to pounds as they are read. Prices we look up for shares listed in agorot (Tel Aviv) or South African cents (Johannesburg) are converted to shekels and rand the same way.
Review and troubleshooting
Confidence indicators
A confidence badge appears only on rows that need you to look at them, so a review screen with no badges needs no attention. Where it appears it reads green “High”, amber “Medium” or red “Low”, and a low score usually means the security could not be matched with certainty.
Duplicate detection
Rows are checked against your existing transactions three ways: by the broker’s own reference number, by a fingerprint of the security, date, quantity and price, and against other statements you have uploaded but not yet confirmed. Matches are flagged and left out of the count on the confirm button. If a match is not really a duplicate, select the rows and override the flag to bring them back in.
Unresolved securities
If a security symbol from your statement cannot be matched to our database, it will be flagged as “unresolved”. You can manually select the correct security during the review step.
Cash and unrecognised rows
Statements carry rows that are not trades: cash interest, deposits, and actions we do not recognise. These are set aside rather than dropped, and the review step lists them with the reason, so you can see exactly what was left out.
Return of capital and scrip dividends
A return of capital on your statement is imported as its own row type. It is not counted as dividend income; it lowers the cost of the shares you already hold. A scrip dividend, where you took shares instead of cash at a stated price, is imported as a dividend reinvestment at that price. A stock dividend printed with a ratio and no cash value is applied like a bonus issue. Splits, mergers and other corporate actions in a statement are listed in their own section on the review step. See corporate actions for how each one changes your holding.
Cash
We keep a ledger of the cash in each account: every deposit, withdrawal, dividend, interest payment, fee, tax withheld and the money each trade paid or received. On an account’s page, the Cash section shows the figure for each currency; choose “View movements” to see every movement it is built from, newest first, with the statement each one came from.
The opening movement
The first time you import a statement into an account that already has a cash figure, we record that figure as an opening movement. Your cash total does not change when the ledger starts; later imports add their movements on top of it. Undoing an import removes its movements with it.
Editing cash by hand
You can still change a cash figure yourself. The difference is recorded as a manual edit in the movements list, so the ledger always adds up to the figure shown.
The closing-cash check
When a statement prints its closing cash, we compare it with our ledger for the same date. If they differ by more than a small rounding amount, the review shows “Your statement’s closing cash differs from ours” with both figures, so you can check them. Nothing is blocked: you can still confirm the import.
Checking your import
Printed totals
Where your statement prints a grand total, we add up the rows we read and compare the two, allowing for small rounding differences. A larger gap shows “Reconciliation gap detected” with both figures and the rows to look at; a gap in the charges block shows “Charges gap detected”. A statement with no grand total says so, and you check the per-security totals yourself before you confirm.
If some pages could not be read, the review says how many and offers Retry unread pages. If the document was too long to read in one pass, it says some trades may be missing.
Holdings differences
When a holdings statement does not match the history you already have, the import shows “Your statement shows different holdings from your history” with a table of what the statement shows, what your history shows and the difference. The import is listed as Completed with differences. A trade may be missing from your history, or still waiting to settle.
Missing periods
We compare the dates your completed imports cover for each account. A gap of more than a week shows “Statements missing for” the dates concerned, so you can import those statements and keep the history complete.
Duplicates and overlapping imports
Uploading a file you have uploaded before opens “You’ve already uploaded this file”, where you can open the earlier import or upload anyway. Inside an import, matching rows are badged Duplicate or Pending duplicate and can be kept anyway. Recent imports are labelled “Identical to” or “Overlaps with” another file.
When you confirm, we check the rows against your other completed imports once more. If some are already in your portfolio, confirming stops and a dialogue names the earlier file and its dates. Choose “Skip rows and confirm” to add only the rest, so the same trade is never booked twice.
Undoing an import
A completed import can be reversed for a limited time, which removes the transactions it created. You are asked for a reason, and you can restore it afterwards. After that window the import is archived and the undo option disappears.
- Choose Undo on the import in your recent imports and pick the reason, for example wrong broker, wrong account or wrong period. A note is optional.
- The undo screen shows how many days you have left.
- If later imports include the same securities, the undo screen lists them first. Their transactions stay, and your holdings for those securities are worked out again without this import.
- An import whose transactions you have edited since can no longer be undone, because undoing it would lose your edits.
- A reversed import can be restored within the window, unless a later import now covers the same securities; reverse that one first.
Fixing problems
Each heading below is the message the import page shows, shortened where it is long, followed by why it appears and what to do.
When you upload
Unsupported file type
Why: The file is not one of the types listed under "Which files work". What to do: Export the statement again as CSV, Excel or PDF, or take a photo of it.
File too large
Why: The file is bigger than the upload limit. What to do: Export a shorter date range, or split the statement and upload each part.
File contents do not match the declared file type
Why: The file was renamed, so its name says one type and its contents another. What to do: Download the statement from your broker again instead of renaming the file.
We couldn’t read this photo. Save it as a JPEG or PNG and upload it again
Why: The photo file is damaged or in a form we cannot open. What to do: Save it as a JPEG or PNG and upload it again.
Your plan supports CSV broker statements only. Upgrade to import PDF, image and spreadsheet statements
Why: Your plan imports CSV files only. What to do: Export a CSV from your broker, or upgrade your plan.
An upgrade message saying you have used this month’s statements
Why: You have used this month’s statement uploads for your plan. What to do: Wait for the allowance to reset on the first of the month, or upgrade.
You’ve used your AI credits for this month. Top up or upgrade
Why: Reading a PDF or photo uses AI credits, and none are left. If your plan has none at all, the message says your plan does not include AI credits. What to do: Upload a CSV or Excel export instead, or top up or upgrade.
AI features are switched off for your account
Why: A PDF or photo needs AI to read, and your AI setting is off. What to do: Choose "Use AI for this file" where offered, or upload a CSV or Excel export.
Incorrect password. Try again
Why: The password did not open the file. If it was your saved password, the message says it did not unlock this file. What to do: Type the password the broker gave you for this document.
No saved password is stored for this broker
Why: There is no saved password for the broker you picked. What to do: Type the password instead.
This file could not be decrypted. It may be damaged or use an unsupported type of encryption
Why: The file is damaged or locked with encryption we cannot open. What to do: Download it again from your broker, or open it yourself and save an unlocked copy.
You’ve already uploaded this file
Why: The same file is already in your imports. What to do: Open that import, or upload anyway if you really mean to.
We couldn’t securely store your statement just now. Please try again shortly
Why: Our secure document storage is briefly unavailable. Saving a statement’s unlock password can fail the same way. What to do: Try again in a few minutes.
While we read the file
We could not read the PDF. The document may be image-only, password-protected, or too low-resolution
Why: The pages could not be turned into text. What to do: Download a clearer copy, or use your broker’s CSV export.
We could not open this PDF. It may be corrupt, so please re-export from your broker
Why: The PDF file is damaged. What to do: Download the statement from your broker again.
We were unable to extract data from this statement
Why: The document was read but no transactions could be taken from it. What to do: Upload your broker’s CSV export if it offers one.
We could not work out what kind of statement this is
Why: The statement type was left on Auto-detect and the file did not make it clear. What to do: Pick a statement type at the top of the page and try again.
This file is not an OFX, QFX, QIF or Interactive Brokers Flex Query file we can read
Why: The file ends in .ofx, .qfx, .qif or .xml but its contents are not in that format; an XML file is only read when it is an Interactive Brokers Flex Query. What to do: Download the file again from your bank or broker, or use its CSV export.
We are having trouble running our document reader (or extraction service)
Why: Our reading service is briefly unavailable; your file is fine. What to do: Try again in a few minutes.
This is taking longer than expected
Why: A long statement is still being read, or the reading stalled. What to do: Wait a little; if it has not finished, contact us.
We could not parse this statement
Why: Something else went wrong while reading the file. What to do: Try a different file, or contact support.
When you confirm
N row(s) need resolution before this import can be confirmed
Why: Some rows still need a security, currency or other answer from you. What to do: Use "Jump to first unresolved" and resolve or skip each row.
N row(s) in this import are already in your portfolio from an earlier import
Why: Those trades were booked by the earlier import the dialogue names, with the dates it covers. What to do: Check that import. If it already holds these trades, choose "Skip rows and confirm" to add only the rest; if it was the wrong file, cancel, undo that import and confirm this one.
The detected broker is not recognised. Pick your broker from the list to continue
Why: We could not match the broker on the statement to one we know. What to do: Pick your broker from the list and confirm again.
Import is not ready for confirmation
Why: The import is still being read, or was already confirmed or cancelled. What to do: Wait for the review step, or open the import from your recent imports.
A message about an invalid row value, such as "Invalid date"
Why: An edit on the review screen did not save in the expected form. What to do: Reload the page and make the edit again.
Only failed or cancelled imports can be retried
Why: The import is not in a state that can be retried. What to do: Open the import to see where it is; start a new upload if needed.
When you undo or restore
The undo window for this import has expired
Why: The import is older than the undo window allows. What to do: Edit or delete the transactions it created one by one.
Some transactions from this import have been edited since it was processed
Why: Undoing it would lose your edits. What to do: Change the transactions themselves instead.
This import has already been reversed. Use Restore if you want to bring it back
Why: It was undone earlier. What to do: Use Restore within the window if you want it back.
Only completed imports can be undone, and this one is not in a completed state
Why: The import was never confirmed, so nothing from it is in your portfolio. What to do: There is nothing to undo.
A later import touches the same securities. Reverse that one first, then try restoring this import again
Why: Restoring would book the same securities twice. What to do: Undo the later import first, then restore this one.
A completed import cannot be deleted. Use Undo to reverse it
Why: Deleting would leave its transactions behind. What to do: Use Undo instead.
You do not have permission to undo this import
Why: The import belongs to someone else. What to do: Ask the account owner to undo it.
Tax documents
You can upload a tax document from your broker or fund house to check it against your portfolio. We recognise these types from what the document says, not from its file name:
- US Form 1099-B, 1099-DIV and 1099-INT, and a composite 1099 that combines them
- UK consolidated tax certificates
- Indian CAS capital gains statements
- MiFID annual costs and charges statements
A tax document is stored against its account and tax year. It never adds transactions or holdings. The review shows Your tax document compared with your portfolio: each figure on the document, such as dividends, interest, sale proceeds, gains, withholding or costs, next to the same figure from the transactions you have imported for that year and account. Each line is marked Matches, Differs or Not in our data.
The comparison shows figures only. It does not tell you what to file or claim, or which figure is right. A difference can mean a transaction is missing from your imports. For questions about a figure on the document, contact the provider that issued it.
P2P lending accounts
Lending platform statements import like any other statement. We read three kinds:
- Loan book exports: each loan part with its amount, rate and dates, and the interest, repayments, fees and losses booked against it.
- Annual statements: a platform’s yearly totals, saved as a platform total for that tax year.
- US information returns: Form 1099-INT, 1099-OID and 1099-B from a lending platform.
Import them into a P2P lending or Innovative Finance ISA account. If you pick another kind of account, the import stops before anything is saved and asks you to change the account’s type or pick a lending account. Borrower names on a statement are never saved. You can also add loans, cash flows and platform totals by hand on the lending account’s page.
If AI is switched off
If you have switched AI features off in your AI settings, we cannot read a PDF or a photo of a statement, so the upload is refused. CSV and Excel files are still read without AI, and the Indian CAS is read without AI too.
When the upload is refused, you can choose one of two things for the file you just chose:
- Use AI for this file: our AI reads this one file. It is read privately on our own servers and is not sent to a third-party AI. Your setting stays off, so the next PDF or photo you upload is refused again and you choose again.
- Cancel: the file is deleted and nothing is read.
We keep a record of each file you allowed AI for. More about how AI processes your documents.
How many statements you can import
Statement uploads are counted per calendar month and reset on the first of each month:
- Free: 2 statements a month
- Silver: 10 statements a month
- Gold: unlimited
- Platinum: unlimited
Reading a PDF or a photo also draws on your AI credit balance, which is shown above the upload area. Every statement counts towards the monthly total, including one that fails to parse, so check the file opens correctly before you upload it.
Every plan can import CSV files. Spreadsheets, PDFs and photos are included on some plans only; if yours does not include them, the upload shows an upgrade prompt instead of reading the file. Reading a PDF or photo also needs AI features switched on in your settings, except for the Indian CAS, which is read without AI.
Can’t find what you’re looking for?
Our support team is here to help. Contact us and we’ll get back to you as soon as possible.
Contact us
