Macquarie Bank statement to Excel and CSV
Macquarie's transaction download only includes the transactions visible on screen, which makes it easy to end up with a partial export. The statement PDF is the complete record for its period. This page is for anyone who needs Macquarie Bank statements in Excel or CSV, whether for a client file, a tax return or a lender, without retyping a line.
Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.
Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your Macquarie Bank statement into Excel
-
Download the PDF statement from Macquarie Bank online banking
- Log in to Macquarie Online Banking or the Macquarie mobile app.
- Hover over (or select) your account in the account list, select 'I want to', and choose 'View account statements and reports' ('View account statements' in the app).
- Select the statement to download; in Online Banking it appears in your browser's download bar.
- Save the statement for the period you need as a PDF.
-
Upload it here
Scans and phone photos work too.
-
Download Excel, CSV, or QuickBooks and Xero CSV
Check the rows against the statement, then export.
Sample result
Your Macquarie Bank statement in Excel
Made-up sample rows, not a real statement.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 2,500.00 | 3,500.00 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 120.00 | 3,380.00 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 1,200.00 | 2,180.00 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 300.00 | 2,480.00 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 80.00 | 2,400.00 | |
| 2026-01-27 Card payment - Fictional Coffee Co | Card payment - Fictional Coffee Co | 15.00 | 2,385.00 |
Statement notes
What to know about Macquarie Bank statements
Downloads only include visible rows
Macquarie notes that a download includes only the transactions visible on screen. Filter too narrowly, or stop scrolling early, and the CSV or QIF comes up short. Converting the statement avoids that, and a dropped transaction would show up as a closing balance that doesn't reconcile.
History depends on the account
Past statements go back somewhere between 2 and 10 years, depending on the account. Check what is available before promising anyone several years of records. For the periods you can get, save the PDFs and convert them in one batch, so gaps between statements are flagged rather than discovered later.
Export is an Online Banking feature
Macquarie's transaction download sits in Online Banking, not the mobile app. Statements, on the other hand, are available in both. If you're working from a phone or were sent the PDFs by a client, converting the statement is the quicker path to a spreadsheet.
Columns and signs
Debits and credits print in separate columns next to the balance. The output uses one signed amount per transaction and keeps the description on a single row even when the statement wraps it, so the file sorts and filters cleanly in Excel.
Output and review
From Macquarie Bank PDF to your books
Accounting tip
Macquarie's download includes QIF, which MYOB can import as a statement file; MYOB doesn't take CSV statements. For periods you convert from PDFs, QuickBooks Online accepts the three-column QuickBooks-ready CSV, and Xero takes the Xero-ready file through its manual import.
-
Checked before export
Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.
-
Export formats
Excel, CSV, JSON, or QuickBooks and Xero CSV.
-
Private workspace
HTTPS uploads, kept private until you ask support to delete them.
FAQ
Macquarie Bank statement questions
My Macquarie CSV is missing transactions. Why?
How far back can I get Macquarie statements?
Can I import converted Macquarie Bank rows into QuickBooks or Xero?
Convert your Macquarie Bank statement to Excel
Page 1 free, no sign-up to see it; just an email to download.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by Macquarie Bank.