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.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your Macquarie Bank statement into Excel

  1. 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.
    Go to Macquarie Bank Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. 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.

sample-statement-2026-01.xlsx Jan 2026 · AUD
Sample bank statement rows with made-up data, amounts in AUD
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 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.

    Files for QuickBooks Online

    Files for Xero

  • 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?
Macquarie's download only includes the transactions shown on screen when you click it, so a filter or an unloaded page leaves rows out. Either widen the search and download again, or convert the statement PDF for that period, which is complete and comes with balances to reconcile against.
How far back can I get Macquarie statements?
It depends on the account: Macquarie says past statements go back between 2 and 10 years. Whatever is available in Online Banking or the app can be saved as PDF and converted here, with dates written as YYYY-MM-DD and amounts signed.
Can I import converted Macquarie Bank rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your Macquarie Bank statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by Macquarie Bank.