# Convert NatWest CSV to QuickBooks (.QBO)

_Canonical: https://qbomaker.com/banks/natwest.html_

NatWest does not export a QuickBooks Web Connect (.QBO) file. From NatWest Online Banking you can download your transactions in CSV format (the export menu lists it as Excel, Lotus, 123, Text (CSV file)), and that CSV is what you convert here. It is the standard UK bank layout, so it maps cleanly once you know the columns.A NatWest CSV uses six columns: Date, Type, Description, Paid In, Paid Out, and Balance. The important thing for QuickBooks is that money in and money out sit in two separate columns rather than one signed column. The converter handles this. You map Paid In as the credit column and Paid Out as the debit column, and it builds a single signed amount for the .QBO. Dates are in UK format, DD/MM/YYYY, so make sure the converter is reading day first and not month first.One practical limit: NatWest Online Banking usually only lets you search and export about three months of transactions at a time. For a full year you will download several files. Convert each one to .QBO separately, and because each .QBO carries transaction IDs, QuickBooks will catch any overlap so you do not import the same row twice.

## Steps

1. Export your transactions from NatWest online banking as CSV or Excel.
2. Open the QBO Maker converter and drop the file in.
3. Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
4. Choose .QBO as the output and click download.
5. In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.

**Does NatWest provide a .QBO or .OFX file?**
No. NatWest Online Banking exports CSV. To get a file QuickBooks Desktop can read, convert that CSV to .QBO with QBO Maker. The whole process runs in your browser.

**How do the Paid In and Paid Out columns get handled?**
NatWest splits credits and debits into two columns. In the converter you map Paid In as money in and Paid Out as money out, and it combines them into the single signed amount that .QBO and QuickBooks expect.

**Why can I only export three months at a time?**
That is a NatWest Online Banking limit, not a converter limit. Download each three month block, convert each to .QBO separately, and import them in order. Transaction IDs in the .QBO stop duplicates if any periods overlap.

**Is my NatWest data uploaded during conversion?**
No. The conversion is entirely client-side in your browser, so your bank data never leaves your computer. Convert your NatWest CSV now.

---
Convert free at https://qbomaker.com/#tool, runs entirely in your browser.