AU
About Macquarie statements
Macquarie is better known as an investment bank, but its everyday transaction and savings accounts are popular and fully digital. You grab the statement PDF from the Macquarie app or online banking, under Statements — same as you would for any branch-based account.
It helps to know how the statement is put together. Macquarie writes an unusually full description — merchant, channel and reference — and offset-account movements sit in the same statement. A plain PDF export flattens that structure; the converter keeps each piece in its own column.
Dates come through as DD/MM/YYYY and the figures stay in AUD (Australian dollars), so the converted file matches what you'd expect locally. Scanned or photographed PDFs work too: OCR reads them into the same columns, and the running balance is checked before anything downloads.
You end up with a file Xero accepts on the first try, with the PDF-wrangling taken care of before it gets there.
Why people convert Macquarie to Xero
If you're catching up a set of books in Xero, or onboarding a client, you'll have Macquarie PDFs that never came through a feed. Converting them gives you an Import a Statement file for each gap, so the history lines up without manual entry.
It also saves the back-and-forth at year end. Instead of asking a client for a CSV their Macquarie login may not even offer, you take the PDF they already have and convert it, so the numbers in Xero match the statement line for line.
Import a Macquarie statement into Xero
Xero takes the CSV through its own Import a Statement screen.
- Convert the PDF above and download the Xero CSV.
- In Xero: Accounting → Bank accounts.
- Open the account, then Manage account → Import a statement.
- Upload the CSV — the date, description and amount columns line up.
- Reconcile the imported lines as usual.
The totals are checked first
The totals are checked before you download. If a row is missing, the statement gets flagged right here — so a gap shows up before it reaches Xero or your client, not after.
Frequently asked questions
Does the CSV go straight into Xero?expand_more
Yes — the CSV goes in through Xero's Import a Statement screen and the date, description and amount columns line up, so you go straight to reconciling. If Xero asks you to confirm the column mapping the first time, save it and later imports remember the layout.
How is a Macquarie statement laid out?expand_more
Macquarie writes an unusually full description — merchant, channel and reference — and offset-account movements sit in the same statement. The converter reads each of those into its own column, so the Xero-ready CSV imports into Xero cleanly.
Where do I download the Macquarie statement?expand_more
From the Macquarie app or online banking, under Statements. Save the PDF, then drop it into the converter above — multi-page and multi-month statements are read in one go.
What if my Macquarie PDF is just a scan?expand_more
Yes. Scanned or photographed PDFs are read with OCR into the same columns, and the balance check still runs, so a scan converts the same as a digital download.
Is it free?expand_more
Converting is free to start. Excel, CSV and JSON download with no login; the Xero file needs a free sign-in.