Home / Convert / Macquarie

Convert Macquarie Bank statements to Excel

Drop in a Macquarie PDF and download a clean Excel file in seconds. Built for Australian bookkeepers and accountants.

About Macquarie statements

Macquarie Bank is Australia's fifth-largest bank and the country's premier digital-first banking option for high-income professionals, premium home loan customers, and self-managed super fund operators. Macquarie's online banking platform exports PDF statements with one of the cleanest layouts in Australian banking — a clear table with Date, Description, Debit, Credit, and Balance, generous whitespace, and consistent typography that parses near-perfectly first time. This makes Macquarie statements among the easiest to convert, though their high-value customer base creates a different challenge: statements often contain large international transfers, foreign currency transactions, and multi-account consolidated views that require careful handling of FX rates and account separation. Bookkeepers and accountants serving SMSF clients, medical professionals, and investment property owners regularly process Macquarie statements for tax planning, capital gains tracking, and BAS preparation. Our converter handles Macquarie's clean format with high accuracy, preserves foreign currency amounts in a separate column alongside the AUD equivalent, separates linked accounts in consolidated statements into individual sheets, and produces immaculate Xero, MYOB, and QuickBooks imports. Whether you're managing an SMSF cash account, a Macquarie home loan offset, or a transaction account, you'll get clean data every time.

Catching up on Macquarie statements?

A backlog of Macquarie PDFs — a new client who's behind, or the months before a bank feed starts — is the job Ledger Pilot is built for.

• Months or years of statements at once

  Upload up to 50 PDFs in one batch on the Business plan and get a separate result for each statement, each with its own reconciliation check.

• Combined PDFs split for you

  When a file holds several statements, we can split it where each one prints its own statement period and convert them separately. If the boundaries aren't clear, we tell you rather than guess.

• Scanned statements

  If our standard parser can't verify a statement — a scan, or a layout we don't recognise yet — it can be read with AI-assisted extraction (PDFs up to 30 pages). We only use that result if it adds up, and we tell you when it was used.

• Checked to the cent

  Every statement is checked from its opening balance to its closing balance. If the numbers don't add up — a missing page, say — you see it before anything reaches your ledger.

Bigger backlog than your monthly pages? One-off catch-up packs add 2,000 or 5,000 page credits without changing your plan. Step-by-step help is in our guides, and how statement data is handled is on our Security page.

Frequently asked questions

Where do I find Macquarie PDF statements?

In Macquarie Online Banking or the Macquarie mobile app, go to "Documents", select the account, choose the period, and download. Statements are available indefinitely.

Does this handle Macquarie SMSF cash account statements?

Yes. SMSF cash account statements parse cleanly and export to Xero, BGL Simple Fund 360, and Class Super-compatible formats.

How are foreign currency transactions shown?

Foreign currency transactions are preserved with both the source currency amount and the AUD equivalent. Macquarie's exchange rate (where shown) is captured in an FX Rate column.

Can I convert a Macquarie consolidated statement with multiple accounts?

Yes. Consolidated statements are split into separate sheets or files — one per account — with each clearly labelled by account name and number.

Can I convert multiple Macquarie statements at once?

Yes — batch upload is available on the Business plan. Upload up to 50 Macquarie PDFs in one go (15 MB each, one bank per batch) and get a separate converted file for each statement, with a reconciliation check per file.

Is there a file size limit for Macquarie statements?

Yes. You can upload Macquarie PDF statements up to 15 MB. Almost all Macquarie statements — even multi-page or scanned ones — fall comfortably within this limit.