Catch-up bookkeeping in Xero
Catch Up Xero Bookkeeping from PDF Bank Statements
Last checked against Xero's documentation: 12 September 2026
Short answer
Short answer
For catch-up bookkeeping, organise the PDFs by entity, account and month; convert each account's statements into chronological transaction data; verify totals and remove overlaps; then import the clean CSV files into the matching Xero accounts in controlled periods. Reconcile each period before moving to the next one.
This workflow is for the awkward handover where the bookkeeping starts with evidence rather than a live data connection: years-behind books, a new client, a closed account, an overdue return, or a folder of PDFs from several banks.
The job before the bookkeeping can begin
A bank feed is not a time machine. Catch-up work begins by turning the records that actually exist into a reliable transaction ledger. For many clients, those records are monthly PDF statements.
Keep extraction, checking and accounting as separate stages. Conversion should reproduce the statement. Categorisation can provide a useful first pass, but the bookkeeper or accountant still decides the correct account and tax treatment in Xero.
The safe workflow
- 01
Inventory the evidence
List every entity, bank account, card and statement month before converting anything.
- 02
Convert account by account
Batch statements from the same account and merge the transaction rows into chronological order.
- 03
Reconcile the extraction
Check balances, totals, continuity and debit or credit direction against the PDFs.
- 04
Review categories
Use automatic categories as a starting point, correct exceptions, and leave uncertain items for the accountant.
- 05
Import controlled periods
Load each file into the matching Xero account and reconcile before advancing to the next period.
The Xero actions above follow Xero's published CSV statement import instructions, including column mapping, date-format confirmation and transaction review.
Checks before you complete the import
- Every statement is assigned to the correct entity and account.
- Statement periods are complete and do not overlap.
- Converted rows reconcile to the source PDFs before accounting decisions are added.
- Categories and GST treatment are reviewed by the appropriate person rather than assumed from merchant names alone.
What Xero itself documents
Xero's manual-import guide says the standard workflow accepts OFX, QFX, QIF, CSV and QuickBooks formats, recommends OFX where available, and directs people with PDF-only statements towards a third-party conversion service.
Xero also documents manual imports for missing lines and transactions from before a feed starts. Its troubleshooting guide says CSV imports can fail because of invalid dates, spaces, blank lines, corrupt files or incorrectly prepared data. That is another reason to review the file before treating an import as finished.
Frequently asked questions
Can Xero catch up several years of bookkeeping automatically?
A feed may supply some history, but it does not guarantee a complete multi-year record. Older or missing periods generally need structured manual imports and reconciliation.
Should I merge all client bank accounts into one CSV?
No. Keep separate bank and card accounts separate for Xero import. You can merge multiple statements from the same account into one chronological file.
Can transaction categories be prepared before Xero?
Yes. AussieBankStatements adds rule-based categories and category totals that you can review before download. Final account coding and tax treatment should still be checked in the accounting workflow.
What is the fastest safe order for catch-up work?
Inventory first, convert second, reconcile the extracted data third, then categorise and import. That order catches missing or duplicated source data before it enters the ledger.