How to Convert Macquarie Bank Statements to Xero CSV (2026 Guide)
Upload your Macquarie PDF statement to ReckonFlow and download a balance-verified CSV ready for Xero import. Macquarie uses separate Debit and Credit columns with a DD MMM YYYY date format that includes the full year on each transaction line. The ReckonFlow parser maps these columns automatically. Takes about 10 seconds per statement. Free for up to 30 statements per month.
Note: Macquarie statement format has not been verified against real samples as of this writing. This guide is based on available sample statement data and may vary by account type or statement period. If your Macquarie statement looks different, ReckonFlow's auto-detection handles format variations across account types.
Macquarie Online Banking (CSV Export)
Macquarie's online banking platform allows you to export transactions directly to CSV. Here's how:
1. Log in to Macquarie Online Banking at macquarie.com.au
2. Go to Accounts and select the account you want to export
3. Click on "Statements" or "Transaction History"
4. Set your date range - Macquarie allows exports for most accounts going back up to 7 years
5. Look for the export or download option, it may be labelled "Download", "Export to CSV", or appear as a download icon
6. Choose CSV format if prompted. Some accounts also offer PDF
The exported CSV includes columns like Date, Description, Debit, Credit, and Balance. Macquarie's date format is DD MMM YYYY (e.g., "02 Jan 2024") with the full four-digit year on each transaction row, which is more explicit than some other AU banks that abbreviate or deduplicate dates.
Macquarie PDF Statements
If you only have PDF statements (common for paper-statement accounts or when a client sends you their statements), Macquarie's portal may not offer direct CSV export for all account types. In that case:
1. Download the PDF statement from Macquarie Online Banking under the Statements tab
2. Open it to check it is a full statement with all transaction rows visible
3. Use a PDF-to-CSV converter that understands Macquarie's statement layout
Macquarie PDFs use a layout similar to NAB with separate Debit and Credit columns, but without the Particulars column that NAB uses. Instead, Macquarie uses a standard Description column. The date format on PDF statements is DD MMM YYYY with the year shown on each transaction line, which differs from banks like CBA that use DD/MM/YYYY with year only in the statement header.
Common Problems with Macquarie CSV Exports
1. DD MMM YYYY Date Format with Year
Macquarie includes the full year (e.g., "02 Jan 2024") on every transaction line. Most Australian banks either omit the year from individual transaction rows (showing it only in the statement header) or use DD/MM/YYYY. When a converter expects DD/MM/YYYY and encounters "02 Jan 2024", it may fail to parse the date or treat it as a string instead of a date value, causing the entire row to be skipped during import.
2. Separate Debit and Credit Columns
Macquarie keeps debits and credits in distinct columns, unlike CBA which uses a single Amount column with negative values for debits. Xero's CSV import expects a single Amount column where debits are negative and credits are positive. If you import a CSV with separate Debit and Credit columns, Xero may read them as two separate columns or map them incorrectly, producing wrong amounts on every row.
3. Dollar Sign Formatting
Macquarie statements place the dollar sign ($) on the first transaction row of each column. Subsequent rows may have bare numbers (e.g., "85.40" instead of "$85.40"). Generic CSV converters that strip dollar signs handle the first row correctly but may misparse bare number rows, treating them as non-numeric and either skipping them or inserting zero values.
4. Multi-Line Transaction Descriptions
Macquarie transaction descriptions sometimes span multiple lines, especially for transactions with merchant details or reference numbers that overflow the Description column width. Generic CSV parsers treat each wrapped line as a separate row, creating phantom transactions with no amount and inflating your transaction count.
5. Running Balance Column Interference
Macquarie's CSV export includes a running balance column. Xero's CSV importer reads columns positionally and may interpret the balance column as an Amount column, which throws off every row after the first. This is the same problem that affects exports from CBA, Westpac, and NAB.
How to Fix Macquarie CSV Export Issues
For the Date Format
If your converter doesn't handle DD MMM YYYY dates, you need to convert them to DD/MM/YYYY format before importing into Xero. Most spreadsheet tools can do this with a custom date format formula. The conversion pattern is: "02 Jan 2024" becomes "02/01/2024". A purpose-built bank statement converter does this mapping automatically.
For Separate Debit/Credit Columns
Create a single Amount column where debits from the Debit column are entered as negative values and credits from the Credit column are entered as positive values. Then remove the original Debit and Credit columns. This gives Xero the single Amount column it expects. If you're handling multiple Macquarie accounts, check that the debit/credit assignment is consistent across all statements.
For the Dollar Sign
Check that your CSV parser treats both "$85.40" and "85.40" as valid amounts. Open the CSV in a text editor and look for rows that have a dollar sign on the first amount but not on subsequent ones. A robust converter normalises all amounts by stripping the $ prefix regardless of position.
For Multi-Line Descriptions
Open the CSV in a text editor and check for rows that have a Description value but no amount in the Debit or Credit columns. These are continuation lines from the previous transaction. Merge them back into the previous row's Description field before importing.
For Balance Column Interference
Remove the Balance column from your CSV before importing into Xero. Xero reads columns positionally: it expects Date, Amount (or Debit/Credit), Description, and optionally Reference. The running balance column in the wrong position can shift every subsequent column out of alignment.
A Simpler Option: ReckonFlow
If the manual export-and-fix process sounds familiar, ReckonFlow handles all of these steps automatically:
- Upload a Macquarie PDF or use the CSV you exported from Macquarie Online Banking
- ReckonFlow identifies the Macquarie format and maps the Description, Debit, and Credit columns correctly
- It converts DD MMM YYYY dates to DD/MM/YYYY format automatically
- It converts separate Debit and Credit columns into a single Amount column that Xero expects (debits negative, credits positive)
- It removes the running balance column and strips dollar sign prefixes
- It verifies the closing balance matches your statement before you import
The Macquarie parser covers Cash Accounts, Saver Accounts, and standard transaction accounts. Free for 30 statements per month.
Related Guides
- How to Convert CBA Bank Statements to Xero CSV: Commonwealth Bank export format explained
- How to Export ANZ Transactions to CSV: ANZ Internet Banking and ANZ Plus export guide
- How to Convert Westpac Bank Statements to Xero CSV: Westpac's distinct column layout guide
- How to Convert NAB Bank Statements to Xero CSV: NAB's five-column format with Particulars column
- Convert PDF Bank Statements to CSV: Australian Bank Guide: General guide covering all major AU banks
- Xero CSV Format Requirements: Column order, date format, and common import errors
---
Macquarie's format? Handled automatically
Upload your Macquarie PDF and ReckonFlow maps the columns, converts dates, and verifies the balance. No manual re-mapping needed.