For the history your bank feed misses
When Hubdoc won’t turn your bank statements into CSV
A client sends six months of PDFs. Their Xero feed starts halfway through the last month. For bookkeepers in the UK, Australia, New Zealand, South Africa and Ireland, here is a way to prepare just the missing history for import.
Drop PDF statements here
Up to 10 files, 50 pages each. Nothing is uploaded until you press Convert.
- Several statements, one Xero CSV
- Choose the last day before the feed
- Keep Hubdoc for collecting receipts
Choose the boundary before importing
| Record | Date | What to include |
|---|---|---|
| Historical PDFs begin | 1 March 2026 | Start the CSV here if no earlier lines are missing |
| First line from the bank feed | 15 June 2026 | Leave this day to the feed |
| Last day in the CSV | 14 June 2026 | Set “Only include transactions to” to this date |
An illustrative date plan, not bank data. Check the first statement line already present in the client’s Xero account.
What the regional limitation means
Hubdoc’s help article is titled “Extract bank statement data (CA, US)”. Xero’s own PDF statement import is also limited to US and Canadian organisations. If you work elsewhere, an upload to those tools is not the same as having a statement CSV ready for import.
The Xero Product Ideas request “Hubdoc - Convert bank statement to csv file” was created on 31 May 2022 and had 304 votes when checked on 9 November 2026. A Xero community manager replied on 26 June 2026, with the status “Not in pipeline”, and described work focused on Smart Document Capture in Xero Files. The official links below let you check the current position.
From a folder of PDFs to the missing statement lines
The Xero import guide covers the import screens and column mapping. The Xero format page explains the CSV columns and when OFX is suitable.
- 1Upload the months of PDF statements for one account. The upload queue takes up to 10 files at once; each PDF can contain up to 50 pages.
- 2Open each result beside its PDF. Compare the dates and signed amounts, then check the printed opening and closing balances. A balanced total is a control, not a substitute for reading the rows.
- 3Tick the completed statements in the file list and choose Export together. Read the ordered periods and the balance connection between each pair. Investigate gaps and overlaps before importing.
- 4Choose Xero statement CSV. Set the end date to the day before the bank feed begins. Both date limits include the day you enter; the saved results keep all their rows.
- 5Download the CSV and import it into the matching account in Xero. Confirm the date format and compare the imported lines with what is already there before reconciling.
Read a connection warning before combining
“Balances join up” means one closing balance equals the next opening balance. A gap shows both figures. Where a printed balance is absent, the connection cannot be checked. An overlapping period gets its own warning even if the balances happen to match.
Export together keeps every row. It does not decide that two similar payments are duplicates: rent, subscriptions and card purchases can legitimately repeat. If periods overlap, compare the PDFs and the existing Xero lines yourself. A date boundary can separate historical uploads from a feed, but cannot resolve duplicates within the same day.
Use CSV or Excel for a partial period. Combined OFX and QBO exports require every balance connection to join, no overlapping periods and no date filter, because their closing balance describes a full statement.
Keep the collection workflow you already use
Hubdoc can stay in your workflow for collecting receipts. BalancedPDF handles the PDF-to-transaction step separately: upload here, review here and download a file for Xero. There is no Hubdoc connection or automatic transfer into Xero.
Before sending client documents, read the privacy notice and security details. Files and results are removed 24 hours after upload; you can delete them earlier. Try the free pages with a statement from the client before committing to the rest of the folder.
Sources
Checked on 9 November 2026 against each company’s own help. Software menus and limits change, so if a step looks different, follow the current help.
Questions
Is this part of Hubdoc or Xero?
No. BalancedPDF is independent and is not affiliated with Hubdoc or Xero. It does not connect to Hubdoc. You upload PDFs directly and import the downloaded CSV into Xero yourself.
Can I keep using Hubdoc for receipts?
Yes. This conversion step does not require you to change how you collect receipts in Hubdoc.
What if a bank feed starts partway through a month?
Find the first date already supplied by the feed. Set the CSV end date to the previous day, then inspect the proposed import for any remaining overlap. Dates alone cannot distinguish two sets of transactions on the same day.
Will it remove duplicate transactions?
No. Repeated rows stay in the export and overlapping periods are flagged. Review them against the source and the lines already in Xero before importing.
Can it read scanned statements?
Scans can be converted, but do not have row-by-row links back to the source. Compare their extracted values with the page image yourself.
How long are the PDFs kept?
Uploaded PDFs and conversion results are deleted after 24 hours. Delete a statement in the workspace to remove it sooner.
Related guides
Try it on one of your statements
No account needed. The file is deleted within 24 hours.