For Australian business owners
Clean Up Your Bank Statements Before Sending Them to Your Accountant
Last checked against Xero's documentation: 12 September 2026
Short answer
Short answer
Your accountant can work from PDF bank statements, but clean transaction data saves them from doing the most mechanical part first. Sort statements by entity and account, check every month is present, convert each account to its own CSV, review the transactions and suggested categories, then send the CSV files alongside the original PDFs.
This is useful when you are behind on bookkeeping, changing accountants, preparing an overdue return, or handing over records for a business that never had reliable bank feeds.
Make the handover easier to trust
A neat file is useful, but completeness matters more. Your accountant needs to know which account each CSV belongs to, what period it covers, whether any months are missing and whether the transaction totals agree with the statements.
Automatic categories can make the first review quicker. They are suggestions, not accounting advice. Correct the obvious items you recognise, flag anything unusual, and leave the final account coding and tax treatment to your accountant.
The safe workflow
- 01
Separate each entity
Do not mix personal, company, trust or partnership records in the same folder or spreadsheet.
- 02
Separate each account
Give every bank account and credit card its own statement set and output file.
- 03
Check the calendar
Confirm that each required month is present and that consecutive statements meet without gaps.
- 04
Convert and review
Create a CSV for each account, check it against the PDFs and correct categories you know are wrong.
- 05
Send both forms
Give the accountant the clean CSV for working data and the original PDFs for evidence and reconciliation.
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
- Files are named with the entity, bank account and date range.
- No account or card has been folded into another spreadsheet.
- Known missing months and unusual transactions are called out in a short note.
- The original statements accompany the converted data.
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
Will my accountant appreciate receiving CSV files?
Usually, if the files are complete, clearly named and checked against the statements. Ask whether they have a preferred format before doing a large conversion job.
Should I delete the original PDF statements after conversion?
No. Keep the original statements as source records and send them with the CSV if your accountant requests them.
Can I categorise transactions before sending them?
Yes. Review the suggested categories and correct transactions you understand. Do not guess tax treatment or hide uncertain items.
Should personal and business transactions be in one file?
Keep accounts separate. If business costs appear in a personal account, tell your accountant rather than silently moving or deleting rows.