How to Convert NAB Bank Statements to Xero CSV (2026 Guide)
Upload your NAB PDF statement to ReckonFlow and download a balance-verified CSV ready for Xero import. NAB uses a five-column layout with separate Debit and Credit columns, an extra Particulars column, and a running balance with Cr/Dr suffix. The ReckonFlow NAB parser maps these columns automatically. Takes about 10 seconds per statement. Free for up to 30 statements per month, uncapped during EOFY.
NAB Online Banking (CSV Export)
NAB Internet Banking allows you to export transactions directly to CSV. Heres how:
1. Log in to NAB Internet Banking at nab.com.au
2. Go to Accounts and select the account you want to export
3. Click on "Statements" or "Transaction History"
4. Set your date range - NAB allows exports for most accounts going back up to 7 years
5. Look for the export or download option, it may be labelled "Download", "Export to CSV", or appear as a download icon
6. Choose CSV format if prompted. Some accounts also offer PDF
The exported CSV includes columns like Date, Particulars, Debit, Credit, and Balance. NABs date format is DD/MM/YYYY with the full four-digit year on each row, which is directly compatible with Xeros expected format.
NAB PDF Statements
If you only have PDF statements (common for paper-statement accounts or when a client sends you their statements), NABs portal may not offer direct CSV export for all account types. In that case:
1. Download the PDF statement from NAB Internet Banking under the Statements tab
2. Open it to check it is a full statement with all transaction rows visible
3. Use a PDF-to-CSV converter that understands NABs five-column statement layout
NAB PDFs use a format that differs from other Big 4 banks. The column headers are Date, Particulars, Debit, Credit, and Balance. Unlike CBA which uses a single Amount column or Westpac which combines description and reference, NAB keeps debits and credits in separate columns. The dollar sign appears on the first row of each column only. The running balance shows a "Cr" (credit balance) or "Dr" (debit balance) suffix to indicate whether the account is in credit or overdrawn.
Common Problems with NAB CSV Exports
1. Particulars Column Misalignment
NAB statements use the "Particulars" column header instead of "Description". When generic CSV converters look for a Description column, they may skip the Particulars column or mix it up with the Debit column. This pushes every column one position out of alignment when imported into Xero.
2. Same-Day Date Deduplication
NAB only shows the date once for transactions on the same day. Subsequent same-day rows have a blank Date cell. Most CSV converters treat blank cells as missing data and either skip the row or fill it with an error value. This inflates the number of import failures.
3. Balance Column with Cr/Dr Suffix
NABs running balance column includes a text suffix ("Cr" or "Dr") after the number. Xeros CSV importer reads all columns positionally and may interpret this suffix as a separate column, throwing off the column mapping. The balance column itself can also interfere with the Debit and Credit column detection if not removed before import.
4. Dollar Sign on First Row Only
NAB places the dollar sign ($) on the first transaction row only. Subsequent rows have bare numbers (e.g., "85.40" instead of "$85.40"). Generic converters that strip dollar signs work fine on rows that have them but may misparse the bare number rows, treating them as non-numeric.
5. Multi-Line Transaction Descriptions
NAB transaction descriptions sometimes span multiple lines, especially for transactions with reference numbers or merchant details. The Particulars column width can cause descriptions to wrap. Generic CSV parsers treat each wrapped line as a separate row, creating phantom transactions with no amount.
How to Fix NAB CSV Export Issues
For the Particulars Column
Rename the Particulars column to Description before import, or use a converter that recognises NABs column headers. Most spreadsheet tools can do this, but the column must be renamed in the actual file, not just the display.
For Date Deduplication
Fill in blank Date cells with the date from the row above before importing. In Excel, you can select the Date column, press Ctrl+G, select Blanks, then type "=" and reference the cell above. A purpose-built converter does this automatically.
For Balance Column Interference
Remove the Balance column and the Cr/Dr suffix before importing. The Cr and Dr suffixes can be stripped using a find-and-replace: replace " Cr" with "" and " Dr" with "". Then delete the balance column entirely.
For the Dollar Sign
If your converter strips dollar signs, check that bare number rows are being parsed correctly. A robust converter treats both "$85.40" and "85.40" as valid amounts. If you see rows being skipped, the converter may not handle mixed formatting.
For Multi-Line Descriptions
Open the CSV in a text editor and check for rows that have a Particulars value but no amount in the Debit or Credit columns. These are continuation lines from the previous transaction. Merge them back into the previous rows Particulars field.
A Simpler Option: ReckonFlow
If the manual export-and-fix process sounds familiar, ReckonFlow handles all of these steps automatically:
- Upload a NAB PDF or use the CSV you exported from NAB Internet Banking
- ReckonFlow identifies the NAB format and maps the Particulars, Debit, and Credit columns correctly
- It fills in deduplicated dates automatically
- It removes the balance column and strips Cr/Dr suffixes
- It converts the transaction data to a two-column (Debit/Credit) format that Xero expects
- It verifies the closing balance matches your statement before you import
Supported for NAB Internet Banking statements and NAB PDF formats. Free for 30 statements per month, uncapped during EOFY. With June already here, processing your NAB statements now avoids the EOFY scramble.
Related Guides
- How to Convert CBA Bank Statements to Xero CSV: Commonwealth Bank export format explained
- How to Export ANZ Transactions to CSV: ANZ Internet Banking and ANZ Plus export guide
- How to Convert Westpac Bank Statements to Xero CSV: Westpacs distinct column layout guide
- Convert PDF Bank Statements to CSV: Australian Bank Guide: General guide covering all major AU banks
- Xero CSV Format Requirements: Column order, date format, and common import errors
---
NABs five-column format? Handled automatically
Upload your NAB PDF and ReckonFlow maps the Particulars, Debit, and Credit columns, fills in deduplicated dates, strips Cr/Dr suffixes, and verifies the balance. No manual re-mapping needed.