Macquarie Bank customers usually hold more than a transaction account — cash management accounts, term deposits, and Macquarie Wrap investment portfolios all generate their own statements. Learning to convert Macquarie Bank statement PDF to Excel turns those scattered PDFs into one analyzable dataset where dividends, interest payments, fees, and cash movements sit side by side in clean columns.
This guide walks investors through the fastest conversion method, how to build a dividend and interest tracker in Excel, and the accuracy checks that matter when investment money is involved.
Why investors move Macquarie statements to Excel
Investment decisions run on aggregated data. A PDF tells you that a dividend arrived on a date; a spreadsheet tells you your total dividend income for the quarter, your effective yield, and how it compares to last year. Converting Macquarie statements to Excel is the step that makes that aggregation possible.
Macquarie customers with multiple products feel this most. Cash sitting in a Cash Management Account, interest from term deposits, and distributions from Wrap accounts each appear on separate statements. Convert each to Excel, stack the sheets into one workbook, and you have a consolidated view of your portfolio's cash flows — something no single PDF can show.
There is also a tax angle. Australian investors must report dividend and interest income, and the numbers on Macquarie statements feed directly into that. A clean spreadsheet of every distribution, with dates and amounts, makes the annual tax return a data exercise instead of a scavenger hunt.
Get your Macquarie statement PDF
Log in to Macquarie online banking or the Macquarie Mobile Banking app, choose the account or investment product, and open the statements view. You can download transaction-account statements as PDFs for any period, and Macquarie Wrap accounts provide periodic portfolio statements that also download as PDFs.
For a full financial-year view, download each product's statement for July to June in Australia's tax year. Name the files clearly — "Macquarie-CMA-FY2026.pdf", "Macquarie-Wrap-FY2026.pdf" — because investment statements all look alike in a Downloads folder and you will need to tell them apart later.
Convert in 3 steps
Step 1 — Upload. Drop the Macquarie PDF into Convert Statement. Investment statements are long and table-dense; they convert in the same pass as simple transaction statements, no extra setup needed.
Step 2 — Choose Excel. Select the Excel format. Dates become real date values, currency amounts stay numeric, and the description column preserves Macquarie's full transaction references — essential for matching distributions to holding statements.
Step 3 — Download. Save the .xlsx file and open it. Investment statements sometimes contain summary sections and disclaimers alongside the tables; the converter extracts the transaction tables and leaves the boilerplate behind.
New to the format? Our explainer on how PDF-to-Excel conversion works covers what happens to multi-section statements like Macquarie's.
Track dividends and investment income in Excel
Once converted, add a "Type" column and label each cash movement: Dividend, Interest, Distribution, Fee, Deposit, Withdrawal. This single column transforms the raw statement into an income ledger.
From there, build a simple summary. Filter the Type column to "Dividend" and sum the amounts for the financial year — that is your gross dividend income. Do the same for interest. Compare both against the annual statements Macquarie issues; the numbers should agree, and if they do not, you have caught a discrepancy early instead of at tax time.
Investors who track yield will want a "Holding" column too. Macquarie Wrap statements identify the underlying investment per distribution; label each row with the holding and you can compute per-holding income for the year, which is the foundation of any honest portfolio review.
Accuracy tips for Macquarie's statement layouts
Investment statements are more complex than transaction-account statements, so spend two minutes verifying. Compare the opening and closing balances in the spreadsheet against the PDF — matching balances prove every row converted correctly. Check that distribution amounts carry their full decimal precision; investment payments often include cents that matter in aggregate.
Watch for wrapped descriptions. Macquarie sometimes prints long investment names across two lines. A good converter stitches these back into one row, but if you see a row with an amount and no description, check whether it belongs to the row above. Converting one product at a time — rather than merging PDFs first — keeps each file's layout consistent and conversion clean.
For deeper background on keeping financial data safe during conversion, see our bank statement data security guide.
Frequently asked questions
Is it free to convert a Macquarie statement to Excel?
Yes — your first 8 pages are free with no credit card required. Longer investment statements convert in the same session.
Do Macquarie Wrap investment statements convert too?
Yes. The converter reads the transaction and distribution tables from Wrap statements the same way it reads cash-account tables.
Will the spreadsheet handle dividend reinvestment entries?
Yes. Dividend reinvestments appear as their own rows with amounts and dates, exactly as printed — you can tag them in your Type column to separate cash income from reinvested income.
Is it safe to upload investment statements?
Files are processed in memory and deleted immediately after conversion; nothing is stored. The Macquarie converter page documents the privacy handling in full.
Can I combine several Macquarie products in one workbook?
Yes. Convert each statement separately, then paste the sheets into one workbook or use Power Query to append them. Keep the product name in a column so you can filter by account.
Stop managing your investments from PDFs. Convert your Macquarie statement free — the first 8 pages cost nothing, and your dividend tracker will thank you.