Published July 2026 by BalanceExtract Team
NatWest is one of the "big four" UK retail banks, and unlike some competitors, it already offers a genuinely capable native export — CSV, Excel, and even a Sage Line 50-compatible OFX file, straight from online banking. That makes NatWest one of the better cases for using a bank's own export first. This guide covers exactly what that export contains, a real formatting issue worth knowing about before it wastes your afternoon, and how to convert the PDF statements the export can't reach.
Getting NatWest transactions into your books without manual entry usually starts with NatWest's own export — it genuinely covers CSV, Excel, and OFX directly from online banking, often the fastest route if you can log in. The real gaps: current-account history export goes back up to 7 years, but credit card transaction export is limited to about 3 months, and the CSV's comma-delimited version has a documented Excel-opening issue (NatWest's own fix: try the tab-delimited download instead). For anything older, a closed account, or a scanned statement, convert the PDF with BalanceExtract instead of typing it in by hand.
Sign in at onlinebanking.natwest.com, or use the NatWest mobile app.
Select the account you want, then open its transaction view rather than the statement/PDF view.
Pick CSV, Excel, OFX, or PDF. If you plan to import into accounting software, OFX is usually the cleaner fit; CSV or Excel are better for manual review.
If the comma-delimited CSV opens with everything crammed into one column, re-download using the tab-delimited option instead — a known Excel delimiter-detection issue, not bad data.
The NatWest export contains six columns, using the same paid-in/paid-out split several UK banks favor over a single signed amount column.
| Column | What It Contains |
|---|---|
| Date | The transaction date, in DD/MM/YYYY format |
| Type | A short transaction-mechanism code (debit card, direct debit, standing order, etc.) |
| Description | The payee or merchant name |
| Paid In | Populated only for credits — empty for debit rows |
| Paid Out | Populated only for debits — empty for credit rows |
| Balance | The running balance after that transaction |
For anything the native export can't reach — an old credit card statement past the 3-month window, a closed account, or a paper statement someone scanned — convert the PDF directly.
Log in, open the account, and download each statement as a PDF from the Statements section.
Drop your NatWest PDFs into the converter — batch upload works, and each statement is processed on its own.
BalanceExtract detects NatWest's layout automatically and shows every extracted transaction with a confidence score before you export. Export to CSV, Excel, Tally XML, or IIF.
QuickBooks Desktop: QuickBooks Desktop has no native CSV import for transactions. Export IIF from BalanceExtract instead — File > Utilities > Import > IIF Files reads it directly.
Excel: If NatWest's own CSV opens with everything in one column, that's the tab-delimiter issue above, not a problem with BalanceExtract's own CSV or Excel export, which opens correctly either way.
Google Sheets: Use File, then Import, and let Sheets detect the separator automatically.
Use NatWest's own export for recent activity, and BalanceExtract for everything else. Free to try.
Honest side-by-side write-ups, including where each of them is the better choice.
How Lloyds' native export compares, and converting older PDFs.
For accounting software that prefers a real transaction feed over a spreadsheet.
Turn any CSV export into a QuickBooks Desktop-ready IIF file.
Every bank guide and format converter BalanceExtract offers.