EOFY Bank Statement Checklist for Xero Bookkeepers (2026)
The 2026 EOFY bank statement checklist for Xero bookkeepers covers seven steps: convert remaining PDF statements, verify balances, import into Xero, run reconciliation reports, check for gaps, confirm BAS timing, and archive. ReckonFlow’s free tier is uncapped during May–June for the EOFY period.
1. Collect all bank statements before June 30
Don't wait for clients to send them. Send a bulk request in the first week of June with clear instructions:
- Ask for PDF statements: not screenshots, not Excel exports, not "I'll just give you my online banking password." Native PDFs from the bank's statement download are the most parseable format.
- Specify the date range: July 1 to June 30. Some banks default to calendar month. Check every file covers the full financial year.
- Set a hard deadline: "I need these by June 25 to guarantee your BAS is lodged on time." The EOFY crunch compresses everything. Give yourself a buffer.
Pro tip: A growing number of bookkeepers now run client statements through a tool like ReckonFlow the moment they arrive, converting PDFs to Xero-ready CSV on the spot. Keeps the pipeline moving instead of batching 30 statements on June 29.
2. Verify every PDF is machine-readable not scanned
Not all PDFs are created equal. A statement downloaded from NetBank or NAB Online is a text PDF: the transaction rows are selectable and parsable. A scanned printout emailed from a client's phone is an image: you'll need OCR before you can do anything with it.
Quick check: Open the PDF and try to highlight a transaction row. If you can select individual characters, it's text-based. If the whole page highlights as one image, it's a scan.
| PDF type | What to do |
| Native bank PDF | Ready to process: download and convert |
| Scanned / image PDF | Run through OCR first (Google Drive, Smallpdf, or Adobe Acrobat) |
| Password-protected | Ask the client for the password: ReckonFlow will reject these |
| Corrupted / garbled | Download a fresh copy from the bank. If still garbled, request a paper statement |
3. Check opening and closing balances match
This is the step most manual processes skip: and the one that catches the most errors.
Every bank statement has three numbers: opening balance, total debits, total credits, and closing balance. Before you convert anything, verify that:
```
Opening balance + total credits - total debits = closing balance
```
If this equation doesn't balance, something is wrong: a missing transaction, a fee that wasn't listed, or an incorrect PDF export. Fix it before you import into Xero.
Why this matters for EOFY: A balance discrepancy found during June 30 reconciliation means backtracking through 12 months of transactions. A balance discrepancy caught before conversion means fixing one PDF. The time savings compound.
4. Normalise all dates to DD/MM/YYYY (or YYYY-MM-DD)
Australian bank statements use Australian date formats. But the moment you copy data into a spreadsheet or export from a bank feed tool, dates can silently flip to MM/DD/YYYY: and Xero's CSV importer is strict about format.
The safest approach:
- For manual CSV preparation: Use DD/MM/YYYY throughout. Xero's CSV import accepts this in Australian organisations.
- For direct QIF import (MYOB): Use DD/MM/YYYY. QIF is more forgiving but still expects Australian format.
- For ReckonFlow: All date conversion is handled automatically: just upload the PDF and the output is formatted correctly for your target accounting platform.
EOFY-specific warning: June 30 transactions sometimes post on July 1 (weekend processing, bank holidays). Check the actual transaction date, not the posted date. A June 30 transaction that posts July 2 could throw your EOFY reconciliation off by one day.
5. Categorise transaction types correctly
Different banks label transactions differently, but for EOFY purposes you need to distinguish:
- Debits (money out): Payments, withdrawals, fees, direct debits
- Credits (money in): Deposits, transfers received, interest, refunds
- Internal transfers: Moving money between the client's own accounts: these net out in reconciliation
- GST components: Not shown on most bank statements, but critical for BAS lodgement
Most manual errors at EOFY come from misclassifying a debit as a credit or vice versa. CBA uses separate debit/credit columns. ANZ and Westpac use a single amount column with DR/CR indicators. NAB and Macquarie use negative amounts for debits.
If you're converting manually: Double-check every row. If you're using a tool that auto-detects transaction types, verify a sample before trusting the batch.
6. Prepare export format for your accounting platform
Different destinations need different output formats:
| Platform | Best format | Date format | Key note |
| Xero | CSV | DD/MM/YYYY | Requires Date, Amount, Payee, Description, Reference columns in that order |
| MYOB | QIF | DD/MM/YYYY | More flexible column ordering. MYOB's QIF import handles AU dates natively |
| Excel / Google Sheets | CSV | DD/MM/YYYY | Be careful opening CSV files: Excel may auto-convert dates to MM/DD/YYYY depending on your regional settings |
| Banktivity / Quicken | QIF | DD/MM/YYYY | QIF has strict field definitions; malformed files will fail silently |
7. Reconcile before lodgement, not after
The EOFY checklist doesn't end at "import all statements." Build in a reconciliation window:
- Week 1-4 (June): Collect and convert all statements. Aim to have everything imported by June 25.
- Week 5 (June 26-30): Reconcile each account in Xero. Flag discrepancies immediately: don't tell yourself you'll fix them "after EOFY."
- Week 6 (July 1-7): Final check. Run the Xero reconciliation report for each client. Verify opening balances for the new financial year match closing balances from the previous year.
Frequently Asked Questions
What is an EOFY bank statement checklist?
An EOFY bank statement checklist is a step-by-step guide that bookkeepers follow when processing end-of-financial-year bank statements. It covers collection, verification, conversion, and reconciliation: ensuring no transaction is missed before BAS lodgement.
Can I convert bank statements to Xero CSV for free?
Yes. ReckonFlow offers a free tier that handles up to 5 bank statement conversions per month: enough for EOFY cleanup on a handful of small clients. Paid plans ($29/mo Solo, $79/mo Practice) remove the limit and add batch processing.
How long does it take to convert a bank statement PDF to CSV?
Manual conversion takes 5-15 minutes per statement depending on PDF quality. With a conversion tool like ReckonFlow, it takes about 30 seconds: upload the PDF, verify the balance, download the CSV or QIF file.
What if the bank statement PDF is password protected?
Password-protected PDFs cannot be processed automatically. You'll need the password from your client before uploading. ReckonFlow will reject these with a clear error message so you know exactly which statement needs attention.
Which Australian banks does ReckonFlow support for EOFY?
ReckonFlow currently supports CBA, ANZ, Westpac, NAB, and Macquarie: the five major Australian banks. Each bank's PDF format is parsed differently, and balance verification works across all five.
EOFY Checklist PDF
Download the one-page EOFY checklist PDF: print it, tick through it for each client, and close June without the stress.
Conclusion
EOFY doesn't have to mean 80-hour weeks. A repeatable process: collect early, verify balances, normalise dates, batch convert: turns June from a crisis into a workflow. The bookkeepers who prepare now are the ones who close June on time and take July off.
Start with the first client statement that lands in your inbox. Convert it. Reconcile it. One at a time.
Ready to speed up your EOFY processing? Try ReckonFlow free: upload a bank statement PDF and get a balance-verified CSV in 30 seconds. No credit card required.
---
Be ready for next EOFY
ReckonFlow converts June bank statements to Xero CSV in seconds. Batch-process CBA, ANZ, Westpac, NAB, and Macquarie PDFs with balance verification before import.