Macquarie issues statements for its Transaction, Savings, Business Savings and Cash Management Accounts every six months, not every month. The statements arrive at the end of December and June, shortly after each statement period closes. An Australian financial year, 1 July to 30 June, therefore spans two statements per account: July to December of one year and January to June of the next.
Macquarie's own exports each stop somewhere. Personal Online Banking downloads transactions as CSV or QIF, on the web only, and only the transactions visible on screen. Macquarie Business Online can generate a CSV statement covering up to 10 years, but that CSV leaves out the opening and closing balances.
So getting a Macquarie bank statement to Excel for a full year means converting both half-year PDFs into one sheet, with the statement period and account number on every row, and checking each half against its printed opening and closing balance. The same applies when the end file is a CSV for an accounting import.
The Cash Management Account (CMA) is where this matters most. It is a common cash account for self-managed super funds, so Macquarie CMA statements reach accountants and SMSF auditors in volume, usually as PDFs sent by the client.
Why a Macquarie Financial Year Is Two Statements per Account
The six-month rule covers more than the deposit accounts. Home loan statements run on the same halves, 1 January to 30 June and 1 July to 31 December. Credit cards are the exception, with monthly statements. For statements more often than every six months, Macquarie's help page says to contact it through live chat.
Put real dates on it. For the 2025-26 financial year, each account produces:
- one statement for 1 July to 31 December 2025, available shortly after 31 December 2025
- one statement for 1 January to 30 June 2026, available shortly after 30 June 2026
That is two long PDFs per account for the year. A fund with a CMA and a separate transaction account has four, and a business with operating, tax and savings accounts has six.
BAS quarters fall inside the halves. The September and December quarters both sit in the July to December statement, and the March and June quarters in the January to June one. A quarter is never a whole document. It is a date range cut out of a six-month statement.
Timing matters too. A September quarter BAS is usually prepared in October, but the July to December statement it belongs to is not available until after 31 December. For the current half, the source is the Online Banking download or the Transaction report (on Macquarie Business Online, a statement generated for the quarter), all covered below, and the half-year statement replaces it later as the record.
Banks on monthly cycles do not work this way: there, a quarter is three statements and a year is twelve. Each bank has its own catch, though. St.George's is a three-month online window, set out in the guide to converting St.George, Bank of Melbourne and BankSA statements to Excel. Bendigo's is an 18-month export limit, with older years left to the PDFs, as the guide to getting a full Bendigo Bank history into Excel explains. Macquarie's is the long statement.
Once two half-years are joined into one sheet, the statement period column is what lets each half be checked against its own printed balances.
Getting Statements, Transactions and Reports from Macquarie Online Banking
A personal or CMA login gives three kinds of file: a transaction download, the statements, and a set of reports. Each covers a different stretch of time.
Transaction download. From the transaction search, Online Banking downloads transactions as .CSV or .QIF. Two rules on Macquarie's viewing and downloading past transactions page shape what you get. The download is "not available in the Macquarie Mobile Banking app", so it is a browser job. And "only the transactions that are visible on screen will be downloaded": the page tells you to scroll down to bring more into the download. For a year of a busy account, scroll until 1 July is on screen, then download, then check the first and last dates in the file before relying on it.
Statements. Macquarie's account statements page says you can view past statements "from the last 2-10 years", depending on the account. Its end-of-financial-year help puts it differently: Transaction and Savings Account statements available since the account was opened, and the CMA's previous 10 years free. The two pages do not agree, so look in the account itself before telling a client how far back their statements go. Statements for a closed account are requested through live chat, and Macquarie says "we may charge a fee".
Reports. Online Banking also produces tax and interest reports:
| Report | What Macquarie says it lists |
|---|---|
| Transaction report | Past transactions for a custom date range |
| Audit report | The account balance and interest paid over a period |
| Proof of balance report | The current balance available on the account |
| Financial year interest report | The interest earned and/or charged on the account |
| Tax transaction report | Past transactions tagged with the Tax tag |
| Tag transaction report | Past transactions tagged with your custom tags |
An account holder with their own login can pull a whole financial year from the Transaction report in one go, 1 July to 30 June, with no two statements to join. Macquarie's page does not say what format the report comes in or whether it shows balances, so open one before building a process on it.
The statements still carry the work for most accountants and auditors. They are what clients send when they do not hand over a login, and what an auditor asks to see. A transaction listing is not the statement of account, which is the bank's record of the period, with the printed opening and closing balances that prove it.
Macquarie Business Online: Generate PDF or CSV, and What the CSV Leaves Out
Business customers on Macquarie Business Online (MBO) get more than personal Online Banking offers, and a real CSV route. Macquarie's business bank statements help sets out how it works:
- Recurring statements can be downloaded for the last six months, which on a six-monthly cycle is often just the latest statement.
- Older periods are generated on demand. MBO will "Generate a bank statement with a custom date period of up to 10 years, for all your open accounts at once", as Generate PDF or Generate CSV. A custom period can be exactly 1 July to 30 June, so a business can produce a financial-year statement directly.
- The CSV has no balances. In Macquarie's words, "Your CSV export contains a list of transactions and doesn't include details such as account limits, facility details, or opening and closing balances."
- Several accounts share one file. Generating for more than one account produces "a statement for each account separately, within the one file". One PDF can hold the operating account, the tax account and the savings account back to back.
- Closed accounts can be generated if they closed within the last two years.
- Generated statements expire. They sit in the Statement Archive for 7 days, so download them when they are ready.
The transaction screen has its own export, as CSV or QIF, with two catches on Macquarie's export transactions page. Export is disabled once the results pass 30,000 transactions, and Macquarie's answer for that case is Generate a Statement as CSV instead. And the file only includes "the transactions that match your search or filter criteria". A filter left on from an earlier search exports fewer rows than the account holds. Check the date range and filters before exporting a period you mean to reconcile.
Older guides and old PDFs may refer to Active Banking. Macquarie switched Active Banking off on 1 June 2023 and moved transaction history, account statements and audit history across to MBO, so any walkthrough of Active Banking screens describes a platform that no longer exists. Statements already downloaded from it are still statements, and convert like any other.
When Macquarie's CSV Is Enough and When the PDF Is the Input
Start from the file that already holds what the job needs. Where Macquarie's CSV is enough, use it: converting a PDF to get the same rows adds nothing.
| Situation | Start from | Why |
|---|---|---|
| MBO access, and the job needs transactions only (a ledger import, a spend review) | The MBO CSV, generated for the period | It covers up to 10 years and the balances are not needed |
| Own login to a personal account or CMA, a custom date range needed | The Transaction report, or the download with the full range scrolled into view | One file for the whole range, no statements to join |
| The balances must be proved (year-end reconciliation, SMSF audit, a lender) | The PDF statements | The statements print the opening and closing balance; the MBO CSV drops them |
| A client's PDFs in hand and no login | The PDFs | Usually the accountant's and auditor's position, and nothing else is available |
| A multi-account MBO PDF that needs a sheet per account | The PDF | Converted with the account number on every row, it splits by account |
| An account closed more than two years ago | The statements already held | MBO only generates for accounts closed within the last two years |
A CMA's transaction CSV is the same on-screen download as any personal account's, with the same limits: it holds only what was visible when it was downloaded, and no row in it says which statement period it belongs to. For a fund's audit file, that makes it a working list for the current half, not the record for the year.
Worked Example: Two CMA Half-Years into One Financial-Year Sheet
The Harbourview Super Fund (an invented fund) keeps its cash in one Macquarie CMA. For the 2025-26 annual return, its accountant has two PDFs from the trustees: the statement for 1 July to 31 December 2025 and the statement for 1 January to 30 June 2026. There is no login, so the PDFs are the whole record.
Convert both halves in one task
Upload both statements as one task, regular PDFs or scans, and convert the bank statement PDFs to Excel with a prompt that describes the sheet you want:
One row per transaction. Columns: Account Number, Statement Period, Date, Description, Debit, Credit, Balance. Repeat the account number and statement period on each row. Format all dates as DD/MM/YYYY. Add each statement's printed opening and closing balance as two more columns on its rows.
An empty prompt box also offers a ready-made prompt for bank statements, which gives one row per transaction. It can be adjusted to the columns above and saved to the Prompt Library, so the next fund's statements get the same shape.
The result downloads as Excel, CSV or JSON. In Excel, numbers come through as numbers and dates as dates, so the totals below work straight away. After your columns, every row carries a Source File column with the file and page it came from, and a value or a row the panel of AI agents cannot agree on is flagged as Review Needed, with what to check.
An excerpt of the sheet, with invented values, and with the opening and closing balance columns and the rows in between omitted:
| Account Number | Statement Period | Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|---|---|
| XXX-123 | 01/07/2025 to 31/12/2025 | 15/08/2025 | Employer contribution | 2,450.00 | 86,920.15 | |
| XXX-123 | 01/07/2025 to 31/12/2025 | 29/08/2025 | Interest | 312.48 | 87,232.63 | |
| XXX-123 | 01/07/2025 to 31/12/2025 | 21/10/2025 | BPAY ATO | 1,280.00 | 85,952.63 | |
| XXX-123 | 01/01/2026 to 30/06/2026 | 16/01/2026 | Rent received | 3,100.00 | 94,506.20 | |
| XXX-123 | 01/01/2026 to 30/06/2026 | 27/02/2026 | Interest | 298.10 | 96,114.55 |
Check each half against its printed balances
Two checks prove the year. First, for each statement, the opening balance plus credits minus debits must equal the printed closing balance. A SUMIFS on the Statement Period column totals each half's credits and debits:
| Statement period | Opening balance | Plus credits | Less debits | Calculated closing | Printed closing |
|---|---|---|---|---|---|
| 1 July to 31 December 2025 | 84,470.15 | 18,906.40 | 11,970.35 | 91,406.20 | 91,406.20 |
| 1 January to 30 June 2026 | 91,406.20 | 17,230.85 | 9,644.10 | 98,992.95 | 98,992.95 |
Second, the December closing balance must equal the January opening balance, here 91,406.20 on both. If either check breaks, something is missing or misread: a page left out of the PDF, a transaction split across a page break, or a value to correct. The Source File column says which page to open, and the Review Needed column is the first place to look.
Cut the quarters and the interest
With the period and date on every row, a filter on the Date column gives each BAS quarter: 1 July to 30 September, 1 October to 31 December, and so on. For a fund or client that lodges a BAS, that quarter's rows feed the GST workpapers or the steps for preparing a BAS in Xero. A filter on the description gives the interest credits for the fund's return.
The multi-account MBO PDF
The same prompt works on a statement generated in MBO for several accounts at once. Macquarie prints each account's statement separately within the one file, and the Account Number column carries that separation into the sheet. Filter or pivot on it to give each account its own tab, then check each account's opening balance plus credits minus debits against its printed closing balance.
Macquarie Bank Feeds into Xero and MYOB, and the Gap They Leave
Personal Transaction and Savings Accounts connect to accounting software and the software is "Xero only", so these accounts have no MYOB feed. The account holder signs an authorisation form and approves it in the Macquarie Authenticator app, and Macquarie says to "wait approximately two business days" for the feed to populate.
Business accounts connect through Macquarie Connect, which shares data with business management software under consent given per facility and per entity. Consent is extended up to 12 months at a time, so a lapsed consent is a second place a gap can open.
Neither help page says how much history a new feed brings in. Do not assume it reaches back to 1 July. A fund or business that connects in, say, March may have nothing in Xero for July to February, and those months come from the half-year statements instead, converted and imported.
The converted sheet is an import file. Nothing posts into the ledger by itself. Import it a statement period at a time, check each import against that statement's closing balance, and leave out any dates the feed already covers so the transactions do not appear twice. The file formats and the steps for each package are in the guides to importing bank statements into Xero and importing bank statements into MYOB.
Macquarie Statements for an SMSF Audit
For a fund banking with Macquarie, the bank side of the audit file comes down to a few documents that agree with each other.
- One sheet per fund per financial year. Built from the two half-year statements for each account, with the account number and statement period on every row, and both balance checks from the worked example passing.
- The interest picked out. A filter or a category column on the interest credits, with the total agreed to the Financial year interest report for the same year before it goes into the return.
- The 30 June balance agreeing in three places. The last row of the sheet, the closing balance printed on the January to June statement, and the Audit report run for 1 July to 30 June, which lists the account balance and interest paid over the period. If the three agree, the auditor has the cash balance and its source in one place.
- The PDFs kept beside the sheet. The statements are the source documents. The sheet is the working paper built from them, and each of its rows points back to a page.
Cash is one part of the fund's records. Property expenses, rental statements and loan records have their own trail, set out in the guide to preparing an SMSF's records for the annual audit.