How to Convert NAB Bank Statements to Excel

NAB Statements: Great for Filing, Terrible for Spreadsheets

National Australia Bank gives you nice, professional-looking PDF statements. They've got the red NAB star logo at the top, your account details clearly laid out, and a clean transaction table. If all you need to do is check your balance or file the statement for your records, they're perfectly fine.

But if you need that transaction data in Excel—for budgeting, tax prep, bookkeeping, loan applications, or anything that involves actually working with the numbers—you're in for a rough time. Let me explain why, and then show you the quick fix.

How NAB Formats Their PDF Statements

NAB's statement layout varies a bit by account type, but the general structure is consistent:

Transaction accounts (NAB Classic Banking, NAB Everyday Account):

• Account holder name and postal address
• BSB (NAB BSBs typically start with 08) and account number
• Statement period dates
• Transaction table with columns: Date | Transaction Description | Withdrawals | Deposits | Balance
• Opening and closing balance summary

Note that NAB uses "Withdrawals" and "Deposits" rather than "Debits" and "Credits." Same concept, different labels. This matters if you're trying to match column headers across statements from multiple banks.

Savings accounts (NAB iSaver, NAB Reward Saver):

• Fewer transactions, mostly transfers and interest credits
• Interest summary section showing rate and amount earned
• Same basic column structure

Credit cards (NAB StraightUp, NAB Low Rate):

• Completely different layout from transaction accounts
• Payment summary at top: closing balance, minimum payment, due date
• Transactions grouped by statement period
• Single amount column (purchases positive, payments/credits negative)
• International transactions show foreign currency details
• Interest charges and annual fees listed separately
• Reward points summary (for cards that have them)

Business accounts (NAB Business Everyday):

• Same core layout as personal transaction accounts
• Longer descriptions with more reference information
• Sometimes includes batch payment details
• May include separate sections for different transaction types

Downloading Statements from NAB Internet Banking

Here's how to get your PDFs:

1. Log in to NAB Internet Banking at nab.com.au
2. Go to your account by clicking on it from the accounts page
3. Select "Statements & documents" from the account menu
4. Find the statement you need. NAB organizes them by date, with the most recent at the top
5. Click to download the PDF
6. Save it to your computer

Via the NAB App: Open the app, tap your account, then look for Statements under the account options. You can download or share the PDF directly from the app.

Transaction export alternative: NAB Internet Banking also offers a "Download transactions" feature where you can export recent transactions as CSV, OFX, or QIF. This is different from the formal statement PDF—it covers a custom date range of recent transactions and is useful for quick imports into accounting software. But it doesn't replace the official statement if that's what you need.

Why Manual Copy-Paste Is a Waste of Your Time

I'll be honest: I spent an embarrassing amount of time trying to make copy-paste work with NAB statements before accepting that it just doesn't. Here's what goes wrong:

Text extraction is messy. NAB's PDFs use a layout that looks like a table but isn't structured as one in the underlying file. When you select text across the transaction area, you get a jumbled stream of text with no reliable column separation.

Description wrapping destroys rows. NAB transaction descriptions can be long. "NAB VISA PURCHASE CARD 5678 OFFICEWORKS MELBOURNE VIC 3000 AU" doesn't fit in one line, so it wraps. When you paste, that wrap creates a new row, splitting the transaction in two. Now you have orphaned description fragments mixed in with your data.

Numbers lose their identity. The withdrawal and deposit amounts paste as text, not numbers. They might include spaces or non-breaking characters that look invisible but stop Excel from recognizing them as numbers. You'll see cells that say "1,234.56" but won't work in formulas. Converting them back to numbers one by one is maddening.

Page breaks inject garbage. A typical NAB statement header repeats on every page: the logo, account info, column headers. All of that gets mixed into your pasted data when the statement runs to multiple pages. On a 6-page statement, that's 5 extra sets of header rows you need to manually find and delete.

The balance column drifts. Because the column alignment depends on text positioning in the PDF, the balance figures sometimes end up merged with the deposit/withdrawal amounts, or they shift into an adjacent column. Reconciling becomes impossible without manual corrections.

I've watched people spend 30-45 minutes cleaning up a single 4-page NAB statement. For one month. If you're doing a year's worth, that's an afternoon gone.

The Better Way: BankStatement2Excel

Step 1: Upload Your NAB Statement

Go to bankstatement2excel.com. Upload your NAB PDF by dragging it onto the page or clicking to browse. Multiple files? Upload them all at once.

Step 2: Pick Your Format

Choose between Excel (.xlsx) and CSV.

• Excel if you're doing budgeting, analysis, or want formatted output with proper column headers
• CSV if you're importing into Xero, MYOB, QuickBooks, Reckon, or another accounting package

Step 3: Download

Conversion takes 30-60 seconds. Your output file will have:

• Dates in proper Excel date format, with the year included (not just DD/MM)
• Descriptions properly merged—no more split rows from line wrapping
• Withdrawals and Deposits in separate columns as real numbers that work in formulas
• Balance column accurate and reconcilable
• All pages stitched together into one clean dataset

Open it, and it's ready to use. No cleanup required.

NAB-Specific Quirks You Should Know

"Withdrawals" and "Deposits" Column Labels

If you're combining statements from multiple banks (say, NAB and ANZ), be aware that NAB uses "Withdrawals/Deposits" while other banks use "Debits/Credits." The actual data is the same concept, but the headers differ. Our converter standardizes to Debit/Credit in the output, so multi-bank analysis is easier.

Date Formats Vary by Account Age

Older NAB statements (pre-2020) sometimes use "DD/MM/YYYY" in the date column. Newer ones tend to use "DD Mon" (like "15 Jan") without the year. The converter handles both formats and normalizes the output to a consistent Excel date format either way.

Credit Card Statement Differences

NAB credit card statements don't just have a different column layout—they also organize transactions differently:

• Purchases and cash advances are listed first
• Payments and credits come after
• Interest charges are in their own section
• The "balance" concept works differently (it's an outstanding balance, not a running account balance)

The converter recognizes NAB credit card format and parses it correctly. The output will clearly distinguish between purchases, payments, interest, and fees.

Direct Debit and BPAY Descriptions

NAB formats direct debit and BPAY transactions in a specific way that includes biller codes and reference numbers. For example: "BPAY TO: AGL ENERGY REF: 12345678." These long descriptions are common sources of the line-wrapping problem in copy-paste. The converter keeps them as single, complete descriptions.

Statements with Zero Transactions

It happens—a savings account with no activity for a month still generates a statement. The converter handles these gracefully (you'll get a file with just the header row and opening/closing balance).

Password-Protected Statements

Some NAB statement PDFs are password-protected when downloaded. The password is usually printed on the download page—commonly your account number or customer ID. You'll need to remove the protection before uploading, or enter the password when prompted.

Common Use Cases

The people converting NAB statements tend to need them for:

• End-of-financial-year tax prep — Pulling 12 months of transactions into one spreadsheet for your tax agent. This is by far the most common use case, and it peaks every June-August.
• Small business BAS — Sole traders and small business owners reconciling NAB business accounts for quarterly Business Activity Statements.
• Mortgage applications — Brokers asking for 3-6 months of bank statements in Excel format. It's increasingly common for lenders to want spreadsheets, not PDFs.
• Expense reporting — Pulling NAB credit card transactions into a format that matches your employer's expense system.
• Divorce and legal proceedings — Unfortunately common. Lawyers often need financial records in spreadsheet format for asset disclosure.

Security

Bank statements contain your most sensitive financial data. Here's how we handle that:

• 256-bit TLS encryption on all uploads
• No file storage — your PDF and converted file are deleted after download
• No data retention — we don't keep copies of your financial information
• No third-party sharing — your data never leaves our conversion servers

Pricing and Free Tier

Try it free: up to 10 pages per day, no credit card required. A typical NAB monthly statement is 2-4 pages, so the free tier covers 2-5 statements per day.

Need more? Plans start at $9.99/month for 400 pages. Most individuals and small businesses are well covered by the Starter plan. The Business plan at $49.99/month offers unlimited pages—popular with accountants processing multiple clients.

Convert Your NAB Statement →

---

Questions about NAB statement conversion? Reach out at [email protected]