PricingAPIDocsAbout
Log In

Convert NAB statements to Excel or CSV

A NAB statement runs a line of dots from each description to its figures and marks every balance Cr or Dr. Upload the PDF here and download the transactions as a CSV for Excel or Google Sheets, one row per transaction.

Drop your bank statement PDF here, or choose it

PDF, up to 10 MB. Nothing is stored.

Where to find your NAB statement PDF

  1. Log in to NAB Internet Banking or the NAB app.
  2. Select Accounts and choose Account statements.
  3. Pick the account and date range, select Search, then Download.

How NAB statements are read

Balances are marked Cr or Dr

Amounts sit under Debits or Credits, and the running Balance carries Cr while the account is in credit and Dr when it is overdrawn. The table opens with a Brought forward row holding the balance from the last statement. The converter takes each row's direction from its column and reads Brought forward as the opening balance.

Dots between description and amount

NAB fills the gap between each row's Particulars and its figures with a line of dots. A long payer name takes the first line and its reference number starts the second, where the dots begin. The converter joins the two lines into one description and reads across the dots to the column the amount sits in.

Parse NAB statements in your own app

Send the PDF to the StatementBear API and get JSON back: every transaction with its direction and category, the account it belongs to, and a check that the totals reconcile. No bank login, no template per bank. The first 25 documents are free, then $0.49 each.

{
  "object": "document",
  "issuer": {
    "name": "NAB",
    "domain": "nab.com.au"
  },
  "currency": "AUD",
  "period": {
    "year": 2026,
    "month": 8
  },
  "accounts": [
    {
      "type": "bank",
      "last4": "2718",
      "primary": true,
      "totals": {
        "credits": 3120,
        "debits": 574.35
      },
      "transactions": [
        {
          "date": "2026-08-06",
          "description": "Fabrikam Pty Ltd Salary 104882",
          "amount": 3120,
          "direction": "credit",
          "category": "income"
        },
        {
          "date": "2026-08-08",
          "description": "Eftpos Debit Coles 0741 Melbourne",
          "amount": 74.35,
          "direction": "debit",
          "category": "groceries"
        },
        {
          "date": "2026-08-11",
          "description": "Internet Transfer To Reward Saver",
          "amount": 500,
          "direction": "debit",
          "category": "savings"
        }
      ]
    }
  ],
  "verification": {
    "reconciled": true,
    "issues": []
  }
}
Get an API keyRead the quickstart

Statements from other banks

CommBank

Westpac

ANZ

Your bank is not listed? Upload it anyway: the converter reads any bank, in any currency. All banks

Bank Statement to ExcelBank Statement to QuickBooksBank Statement to OFXBank Statement to JSON

Three simple steps

01

Download your NAB PDF

Log in to NAB Internet Banking or the NAB app. Select Accounts and choose Account statements. Pick the account and date range, select Search, then Download.

02

Upload it here

Drop the PDF on the box at the top of this page. It is read in under a minute and nothing is stored.

03

Download the CSV

One row per transaction with date, description, amount, direction and category. Opens in Excel, Google Sheets and Numbers.

Frequently asked questions

Want a complete spending analysis?

Upload your statement for a spending score, category breakdown and honest AI feedback.

Get Started Free