National Australia Bank Statement to Excel Converter

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

Last updated 2026-09-03

What does a NAB statement PDF look like?

Printed structure: PDF with Date, Description, Withdrawals, Deposits, Balance — NAB and NAB Connect layouts

Date notation: DD/MM/YYYY. Money notation: A$ AUD. Observed statement size: 4–16 pages.

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

What fields does National Australia 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:

  • NAB checkpoint 1: Formed in 1982 through the merger of the National Bank of Australasia and the Commercial Banking Company of Sydney, one of Australia's 'Big Four' banks
  • NAB checkpoint 2: Headers use Withdrawals and Deposits instead of Debit and Credit — auto-mapped on export
  • NAB checkpoint 3: NAB Connect business statements often include long batch-payment narrations with payroll or supplier references
  • NAB checkpoint 4: BPAY reference and biller code can appear on the following line instead of the main description row
  • NAB checkpoint 5: Offset and redraw transactions for mortgage-linked accounts are flagged as internal transfers rather than spend

How do I check a NAB conversion before using it?

A typical National Australia Bank file runs 4–16 pages. Confirm its DD/MM/YYYY dates, AUD signs, first and final transactions, and page boundaries. Balance review is especially important on this layout. Formed in 1982 through the merger of the National Bank of Australasia and the Commercial Banking Company of Sydney, one of Australia's 'Big Four' banks. The PDF remains the source; the spreadsheet is the reviewable working copy.

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

Which accounting tools accept NAB 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/MM/YYYY interpretation and AUD values established from the National Australia Bank source.

Is my NAB statement data kept private?

The NAB PDF is processed in memory and deleted after conversion. The NAB 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.

NAB conversion FAQ

Which NAB statement layouts can ClearlyLedger convert?

National Australia Bank statements typically arrive as PDF with Date, Description, Withdrawals, Deposits, Balance — NAB and NAB Connect layouts. ClearlyLedger's NAB profile reads that layout, plus scanned and password-protected exports, and reconstructs Date, Description, Debit, Credit and Balance columns.

How does ClearlyLedger handle NAB-specific quirks?

This guide highlights common NAB statement characteristics — for example: Formed in 1982 through the merger of the National Bank of Australasia and the Commercial Banking Company of Sydney, one of Australia's 'Big Four' banks. The conversion is released only after its verification checks pass.

Can I import a converted NAB statement into Xero?

Yes. Export to CSV and import into Xero, MYOB, QuickBooks or any tool that accepts a transaction file. The DD/MM/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