AU
Upload a Macquarie statement PDF and every transaction comes back as clean rows — date, description, debit, credit and the running balance — checked so the closing figure ties out. Export to Excel, CSV, or an import file for Xero, MYOB or QuickBooks.
Macquarie runs its everyday banking almost entirely through its app, and it's a favourite among contractors, investors and anyone who likes clean data. The statements reflect that — the transaction descriptions are detailed. But a PDF is still a PDF: rich detail you can read isn't the same as data you can sort, and at tax time you need the sortable version.
What a Macquarie statement looks like
A Macquarie transaction account statement uses these columns:
Column | What's in it |
|---|---|
Date | `DD Mon YYYY`, Australian format |
Description | The payee, payment method and reference |
Debit | Money out |
Credit | Money in |
Balance | Running balance after the transaction |
Macquarie tends to write a fuller Description than most — a card purchase can carry the merchant, the channel and a reference, and a transfer its counterparty and detail. That's useful for working out what a payment was, but the longer the line, the more likely it wraps onto a second row, which a rough export reads as a separate entry. The converter keeps the whole description on the one transaction. If you use Macquarie's transaction account as the offset against a Macquarie home loan, the interest-offset movements sit in the same statement and stay on their correct side too.
Where to download your Macquarie statement
- Macquarie Online Banking: log in at macquarie.com.au, choose the account, open Statements, select the period and download the PDF.
- Macquarie app: tap the account, go to Statements, pick a statement and save the PDF.
A statement downloaded this way is a digital PDF with selectable text, so the conversion is exact. If you only have a scan or a photo, the converter reads it with OCR — that just takes a little longer.
Getting the numbers where you need them
- Excel or Google Sheets — a clean `.xlsx` or CSV, one row per transaction, ready to total and filter.
- Xero or MYOB — an import-ready bank file so the lines arrive as statement entries to reconcile.
- QuickBooks, Zoho and others — the same data in each one's format.
The figures are reconciled before download: opening balance, plus credits, minus debits, must reach the closing balance. On an account that many people use for investments or an offset, keeping that balance exact is what makes the numbers safe to hand to an accountant.
Common snags with Macquarie statements
- Detailed descriptions wrap. A long merchant or transfer line is joined back into one transaction.
- Offset movements. If the account offsets a home loan, those entries stay on the correct side rather than skewing your spending.
- Business accounts. Macquarie business transaction-account statements use the same layout, so the same conversion works.
Frequently asked questions
Can I convert a Macquarie statement to Excel for free?keyboard_arrow_down
Yes. Upload the PDF and get a clean Excel or CSV back free to start, with the running balance checked so the import lines up.
Where do I download my Macquarie statement?keyboard_arrow_down
In Macquarie Online Banking or the Macquarie app: choose the account, open Statements, pick the period and download the PDF. That digital PDF converts cleaner than a scan.
Can I import it into Xero or MYOB?keyboard_arrow_down
Yes. Export an import-ready bank file and the transactions arrive as statement lines you reconcile as usual in Xero, MYOB or QuickBooks.
Does it keep Macquarie's detailed transaction descriptions?keyboard_arrow_down
Yes. Macquarie writes a fuller description than most — merchant, channel and reference — and the converter keeps that whole detail on the transaction instead of trimming it to a bare amount.
Will it read a scanned Macquarie statement?keyboard_arrow_down
Yes, with OCR. A PDF downloaded from Online Banking will always convert faster and cleaner than a scan.
