NAB Bank Statement to Excel Converter

Converting NAB Statements to Excel

National Australia Bank statements list each transaction with its particulars, the amount in a debit or credit column, and a running balance. That layout is clear on the page but awkward in a spreadsheet: copying it usually merges the amount columns, splits long particulars over several rows and drags page headers into the data. Finlyzers reads the statement as a table and returns one row per transaction, ready for Excel, Google Sheets or your accounting software.

How a NAB Statement Is Typically Laid Out

• Header: account name, BSB and account number, and the statement period.
• Summary: an opening balance, total debits, total credits and a closing balance.
• Transaction table: often labelled Date, Particulars, Debits, Credits and Balance.
• Page breaks: longer statements may repeat a balance at the bottom of one page and the top of the next, sometimes worded as brought forward or carried forward. These are balances, not transactions, and are left out of the transaction list.

Everyday accounts such as NAB Classic Banking, savings accounts such as NAB Reward Saver and iSaver, and NAB business accounts broadly follow this pattern, though column labels and spacing can vary between account types and over time.

Common Wording in NAB Particulars

Descriptions on Australian statements use plain words for payment types. On NAB statements you will commonly see variations of:

• EFTPOS and card purchases: the merchant name and location, sometimes with a reference.
• BPAY: bill payments such as council rates, utilities and insurance, with the biller's name.
• Direct credits: salary, rent from a property manager, refunds or government payments, usually with the payer's name.
• Direct debits: regular amounts collected by businesses you have authorised.
• Transfers: money moved between your own accounts or to other people, including fast Osko or PayID payments where shown.
• Fees and interest: listed as separate lines, which makes them easy to total for tax purposes.

Because the full particulars stay in one cell, you can search or filter for a biller, a tenant's reference or a supplier across a whole year of statements.

When Converting the PDF Makes Sense

NAB Internet Banking can export recent transactions for accounts you can sign in to. The PDF route is usually needed for:

• Older periods that are no longer available to export.
• Closed accounts, including accounts of a deceased estate you are helping to administer.
• Client paperwork: accountants and bookkeepers often receive statements as PDF attachments rather than exports.
• Self-managed super funds: auditors and accountants commonly work from bank statements for the fund's account, and a spreadsheet makes it easier to match contributions, payments and investment income.
• Lender and broker requests: check your income and regular commitments in a spreadsheet before sending statements for a home loan application.

Using NAB Data in Australian Tools

• Xero and QuickBooks Online: download OFX or CSV and import it into the matching bank account.
• Desktop software: download QIF if your software still imports it.
• MYOB: check which bank statement formats your MYOB edition imports before choosing a download.
• BAS preparation: sort a quarter's transactions by particulars and code each one before working out GST.
• End of financial year: combine twelve monthly statements from July to June into one workbook for your tax return.

Whichever tool you use, make sure it is set to DD/MM/YYYY dates when importing CSV.

Other Australian Banks

If you also bank with ANZ or the Commonwealth Bank, the ANZ statement converter and the CommBank statement converter produce the same column layout, so accounts from different banks can sit side by side.

Converting a NAB credit card statement? Use the credit card converter. For paper statements you have scanned, try the scanned statement converter.