How to Convert Bank Statements to Xero CSV: Australian Bookkeeper's Guide
Upload a bank statement PDF to ReckonFlow and download a balance-verified CSV that imports directly into Xero. The CSV uses Xero’s expected column order (Date, Amount, Payee, Description, Reference) with DD/MM/YYYY dates and properly formatted amounts. Import via Banking → Import → Bank statement CSV.
When the Bank Feed Works and When It Doesn't
Direct bank feeds are great when they work. But they have gaps:
- Not every bank is supported. Some smaller Aussie lenders don't have a feed
- The client hasn't set it up yet. You're waiting on them to flick the switch
- You need historic data. Last month's PDF isn't going to appear in a feed
- The feed breaks. The bank changes something on their end and you're stuck
When the feed drops, you need a CSV that Xero will actually accept. One wrong column and it's reject, fix, re-import.
What Xero CSV Format Actually Looks Like
Xero has a specific CSV format for bank statement imports:
| Field | Description | Required |
| *Date | DD/MM/YYYY | Yes |
| *Amount | Negative for debits, positive for credits | Yes |
| Payee | Who the transaction was with | No |
| Description | What the transaction was for | No |
| Reference | Cheque number or reference | No |
| Transaction Type | Credit Card, EFTPOS, etc | No |
| Cheque Number | Cheque ref | No |
Date format is the one that trips people up. If you use MM/DD/YYYY (which Excel loves to default to), Xero will reject the file. Always DD/MM/YYYY.
Why Balance Verification Saves Time
The most common mistake in manual CSV prep is a transcription error. A digit flipped, a line skipped, a transfer classified as income instead of a transfer.
The check is just primary school arithmetic:
Opening balance + credits − debits = closing balance
If that doesn't match the PDF, the CSV has an error somewhere. Finding it before import beats trying to reverse-engineer a reconciliation that's already out by $500.
That's the bit that saves the most time. Upload a PDF, get a CSV that's been checked against the bank's own totals. If it doesn't add up, you know before you import.
How the Conversion Works
Step 1: Get the Statement PDF
Pull the PDF from the bank's online portal or grab it from the client.
Supported Aussie banks:
- CBA (Commonwealth Bank)
- ANZ
- Westpac
- NAB
- Macquarie
Each bank lays out their PDF differently: different date columns, different table layouts, different ways of marking pending vs cleared transactions.
Step 2: Extract the Transactions
By hand: Copy each line into a spreadsheet. For a 50-line statement, budget 15-20 minutes. Then proof every row.
With ReckonFlow: Drag the PDF onto the upload page. The tool reads the transactions, figures out credits vs debits, and builds the CSV. Takes about 30 seconds.
Step 3: Check the Balance
Before you export, do the math:
```
Opening: $12,450.00
+ Credits $8,230.50
− Debits $3,115.75
= Closing: $17,564.75
```
If it matches the statement PDF, the CSV is clean. If not, track down the error before importing.
Step 4: Export and Import
Download the CSV. The columns and date format already match Xero's expectations.
In Xero:
1. Accounting > Bank Accounts
2. Select the account
3. Import Statement
4. Pick the CSV
5. Review the summary
6. Confirm
Xero will match imported transactions against existing ones and flag anything that doesn't reconcile.
Things That Go Wrong
Xero rejects the CSV
- Date format is wrong: use DD/MM/YYYY
- Amounts are flipped: debits should be negative
- Blank rows snuck in
Balance doesn't add up
- Missing opening balance
- Uncleared transactions got mixed in
- PDF has pages you didn't capture
Client can't get the feed working
- Share Xero's bank feed setup guide
- Use PDF import to stay current in the meantime
- Reconcile the imported data once the feed connects
Bottom Line
Converting bank statements to Xero CSV is just part of the job for Australian bookkeepers. When the feed isn't available, the safest workflow is extract → verify → import, with a balance check between each step. Skip the check and you're trusting that nothing got lost in translation.
If you're processing more than a couple of statements a month, the copy-paste time adds up. A tool that extracts and verifies in one pass turns a 20-minute task into a 30-second upload.
Try it with a CBA PDF. Free, no sign-up, no card. If the balance checks out, import it. If it doesn't, you'll know before it touches your books.
---
Convert any bank statement to Xero CSV in seconds
Upload a PDF from CBA, ANZ, Westpac, NAB, or Macquarie and get a Xero-ready CSV with verified balances. Free for 30 statements per month.