Macquarie Statement to Excel Converter

In Macquarie Business Online, statements Macquarie has generated for you are downloadable for the last six months. For anything older, you generate a statement yourself for a custom period of up to ten years, as PDF or CSV.

A generated PDF for a whole financial year is one document; FlowParse reads all of it and proves it against the opening and closing balance of the period you chose.

For a closed personal account, Macquarie asks you to request statements through live chat; you need authority over the account, and a fee may apply. In Business Online, accounts closed within the last two years can still generate statements for up to ten years — one file containing a separate statement per account.

That multi-account file converts in one upload, each account's statement proved against its own balances.

A Macquarie statement lists transfers, BPAY and card payments, direct debits, interest and fees between an opening and a closing balance. FlowParse gives each line one row: date, description as printed, and a single signed amount.

Add the amount column and you have the period's net change — exactly what the two balances say it should be.

Before a statement is marked reconciled, FlowParse takes the opening balance, adds every signed transaction and compares the result with the closing balance. Where a running balance is printed, each row is checked against it too.

This is exactly the check Macquarie's CSV can't support. If a transaction was missed, the preview shows the gap and where it sits.

Macquarie's cash management accounts are widely used by financial advisers and SMSF trustees as the hub account for investments. Their statements carry a lot of movement: contributions, settlements, distributions, fees.

Converted, a year of statements becomes a ledger an adviser or an SMSF auditor can filter by counterparty and total by quarter — every row tied to a printed balance.

The ATO generally expects businesses to keep their records for five years. Macquarie's ten-year generated statements cover that for business customers; personal reach varies by account.

Generate or download the PDFs for the years you need, convert them once, and keep the workbook next to the originals.

Macquarie also provides tax, interest and other reports, and transaction and proof-of-balance reports. They summarise; they don't replace the statement.

When the accountant wants to know what made up the interest or which deposits came from where, the converted statement answers it.

Australian businesses mostly use Xero or MYOB. FlowParse exports to both, as well as CSV and QBO for QuickBooks.

Because each statement was proved against Macquarie's own balances first, a difference in the bank reconciliation points at the bookkeeping, not at the conversion.

Smart Merge takes up to 100 PDFs and lays them out in date order with the account and file name on every row. It checks the chain: each closing balance must be the next opening balance.

For a July-to-June year, a missing month breaks the chain at exactly that point.

The trustees of a self-managed super fund hold a Macquarie cash management account. The auditor needs the full year's transactions, reconciled to the statements. The figures here are an illustration.

The trustees download the statements for the financial year and upload them. FlowParse returns one proved workbook; contributions, settlements and fees filter by description, and the auditor gets both the PDFs and the sheet.

Check coverage: every period present, each closing balance equal to the next opening balance. Check the source: PDF statements, not a balance-less CSV, when proof matters. Check reconciliation: every statement proved before its totals are used.

Keep the PDFs. The spreadsheet is a working copy.

Businesses and families often hold several Macquarie accounts — transaction, savings, offset, cash management. Transfers between them appear on both sides.

Merged with the account on every row, they pair up and can be excluded in one filter. Statements from CommBank, Westpac, NAB or ANZ can join the same workbook.

Macquarie's transaction list filters by amount, category, date range, description and type. That's useful for finding one payment.

For a complete record, download the statement rather than a filtered list, and filter afterwards in the converted workbook — where you can see what you've excluded.

Excel and CSV keep the description Macquarie printed, so searches for a supplier, the ATO or a fund manager still work after import. Xero and MYOB exports go straight to the books.

The PDF stays the record; the workbook is how you use it.

Business customers choose the period when generating a statement — a quarter for a BAS, a financial year for the tax return, a custom range for a due-diligence request — up to ten years.

Generate the PDF for exactly the period you need and FlowParse proves it against that period's opening and closing balance, so the converted figures match what Macquarie itself reports for those dates.

Australian businesses lodge their BAS quarterly or monthly, and the bank statement is where GST-relevant receipts and payments are checked.

Converted, a quarter's statement becomes a list you can filter by supplier and customer, ready to compare with the figures in Xero or MYOB before lodging.

If you hold an offset account next to a home loan, its statements carry the household's everyday flows — salary in, bills out — and its balance reduces the interest charged on the loan.

Converted alongside the loan statements, the offset account shows how its balance moved through the year, which is the number that drives the interest saved. For investors with a rental property, the same workbook separates deductible loan interest from personal spending.