Banks · Australia
Macquarie transaction-account PDFs are usually a clean table: Date, Description, Debit, Credit, and Balance, with day/month/year dates. Card purchases and direct debits are debits. Transfers in, including savings sweeps, are credits. The file rarely needs section headings.
A text-based Macquarie PDF is read in your browser. The file is not uploaded. If the columns on your copy differ from the notes below, change the mapping in the preview before you download.
Macquarie wrap and investment statements are not this table. Those list holdings and trades. Convert the transaction account PDF when you want a bank register, and leave the investment report alone.
Typical columns: Date, Description, Debit, Credit, Balance. Date order: day/month/year. Currency on the statement: AUD.
In Macquarie online banking, open statements for the transaction account, not the investment report, and save the PDF.
Date, Description, Debit, Credit, Balance. Set DMY.
You can filter the spreadsheet on the description. Do not delete sweeps before you check the closing balance.
Download XLSX if you want both amount columns preserved.