How to export a Macquarie Bank statement as CSV for your BAS
Macquarie is popular with contractors and consultants, and both its online banking and app export transactions by date range. CSV, OFX and QIF are offered, and some accounts can schedule a regular export from the Documents area.
Steps checked 17 September 2026. Menu names change; if the label differs, look for Export, Download or Statements.
In Macquarie Online Banking (browser)
- 1Log in to Macquarie Online Banking and open the account.
- 2Go to Transactions and set the period.
- 3Select Download and choose CSV (OFX and QIF are also available).
- 4Save the file. On some accounts you can also schedule regular exports from the Documents area.
In the Macquarie app
- 1Open the Macquarie app and tap the account.
- 2Tap the transactions menu and select Export.
- 3Choose CSV and the date range, then save or share the file.
Menu names change; if the label differs, look for Export, Download or Statements.
Which format to pick
Choose CSV when it is offered. Macquarie also provides OFX, QIF and PDF statements; the PDF statements are fine for FlowFi, while OFX and QIF are for other accounting packages and are not needed.
Which dates to pick
Export the whole BAS quarter in one file (1 July to 30 September, 1 October to 31 December, 1 January to 31 March, or 1 April to 30 June) so nothing falls between two exports. For a first upload, start from 1 July so your year-to-date figures are complete. Not sure which quarter you are in? See the BAS due dates.
After you export
Open the file once and check it has a date, a description and an amount for every line, and that it covers the whole period. Then upload it to FlowFi and your quarter is categorised in two minutes: every transaction gets a category and a confidence score, you review only the uncertain ones, GST is flagged per line, likely deductions are marked, and the BAS labels are prepared for you to copy into ATO Online.
Got the file? Upload it and see the quarter sorted
Then upload it to FlowFi and your quarter is categorised in two minutes, with GST flagged and every BAS label ready to copy.
Start 14-day free trial14 days of Pro free. No credit card. Then $29 a month or $290 a year.
Frequently asked questions
Is exporting a Macquarie statement safer than connecting a bank feed?
It avoids sharing your Macquarie login or granting ongoing access to the account. FlowFi never asks for bank credentials and never touches your money; you export the file yourself and upload it. The trade-off is a minute or two per account each month or quarter.
What if Macquarie only gives me a PDF statement?
Upload the PDF. FlowFi reads the transaction table out of PDF statements. CSV is preferred because every line is a clean row, but a monthly PDF statement works, and you can upload all three months of a quarter together.
How far back should I export?
For a first upload, go back to 1 July so your year-to-date income, GST and deductions are complete. After that, export each quarter as it ends, or each month if you like to keep on top of it.