Macquarie Bank Statement to Excel Converter

ClearlyLedger converts Macquarie Bank (Australia) PDF statements into clean Excel and CSV files. This guide covers the common Macquarie pdf layout, DD MMM YYYY dates and AUD amounts. Exports are released only when verification checks pass. Most Macquarie statements (3–12 pages) finish in under 60 seconds with no signup required for your first file.

Last updated 2026-09-03

What does a Macquarie statement PDF look like?

Printed structure: PDF with Date, Transaction Description, Debit, Credit, Balance — Cash Management Account and transaction account layouts

Date notation: DD MMM YYYY. Money notation: A$ AUD. Observed statement size: 3–12 pages.

Amounts use a period decimal; Osko/PayID and BSB-linked narrations are kept intact.

What fields does Macquarie Bank print on each transaction row?

The profile uses the bank-specific observations below as review checkpoints. They describe the source document rather than making a generic promise about every PDF:

  • Macquarie checkpoint 1: Began as a merchant bank (Hill Samuel Australia) in 1969 and only became a licensed bank in 1985; unlike Australia's retail-heavy 'Big Four', Macquarie's business has historically leaned toward investment banking and asset management, earning it the nickname 'the Millionaires' Factory' for its executive pay
  • Macquarie checkpoint 2: Cash Management Account statements may include linked adviser or portfolio references above the transaction table
  • Macquarie checkpoint 3: Detailed transfer narrations can include BSB and partial account numbers that must remain text-safe in CSV export
  • Macquarie checkpoint 4: Interest and fee reversals often post on the same day as two separate rows with mirrored descriptions
  • Macquarie checkpoint 5: Macquarie marketplace and CMA sweep rows are treated as internal cash movements, not merchant spend

How do I check a Macquarie conversion before using it?

A typical Macquarie Bank file runs 3–12 pages. Confirm its DD MMM YYYY dates, AUD signs, first and final transactions, and page boundaries. Balance review is especially important on this layout. Began as a merchant bank (Hill Samuel Australia) in 1969 and only became a licensed bank in 1985; unlike Australia's retail-heavy 'Big Four', Macquarie's business has historically leaned toward investment banking and asset management, earning it the nickname 'the Millionaires' Factory' for its executive pay. The PDF remains the source; the spreadsheet is the reviewable working copy.

  1. Upload the Macquarie Bank PDF.
  2. Inspect the documented Macquarie row patterns.
  3. Reconcile the AUD transaction math.
  4. Download verified Macquarie Excel or CSV data.

Which accounting tools accept Macquarie Excel or CSV files?

Excel suits source-document review and coding. CSV suits mapped imports into Xero, MYOB, QuickBooks or Reckon. Those routes preserve the DD MMM YYYY interpretation and AUD values established from the Macquarie Bank source.

Is my Macquarie statement data kept private?

The Macquarie PDF is processed in memory and deleted after conversion. The Macquarie transaction data is not used to train AI models. TLS protects the upload in transit, while the workflow is designed around the Australian Privacy Act 1988 for Australia account holders.

Macquarie conversion FAQ

Which Macquarie statement layouts can ClearlyLedger convert?

Macquarie Bank statements typically arrive as PDF with Date, Transaction Description, Debit, Credit, Balance — Cash Management Account and transaction account layouts. ClearlyLedger's Macquarie profile reads that layout, plus scanned and password-protected exports, and reconstructs Date, Description, Debit, Credit and Balance columns.

How does ClearlyLedger handle Macquarie-specific quirks?

This guide highlights common Macquarie statement characteristics — for example: Began as a merchant bank (Hill Samuel Australia) in 1969 and only became a licensed bank in 1985; unlike Australia's retail-heavy 'Big Four', Macquarie's business has historically leaned toward investment banking and asset management, earning it the nickname 'the Millionaires' Factory' for its executive pay. The conversion is released only after its verification checks pass.

Can I import a converted Macquarie statement into Xero?

Yes. Export to CSV and import into Xero, MYOB, QuickBooks or any tool that accepts a transaction file. The DD MMM YYYY dates and AUD amounts are normalised so the import maps cleanly.

Related ClearlyLedger resources

Use these canonical pages to compare formats, verify data handling, and move from PDF extraction into accounting review.

Loading interactive converter… Try ClearlyLedger free