Convert NatWest statements to QuickBooks.
Checked against the printed balances first.
NatWest's transaction export offers OFX for Money, Quicken and Sage and CSV for Excel, not a QuickBooks file, and it carries no printed opening or closing balance.
Drop your bank statements here
One file or a whole year. PDF, scanned image, CSV, QIF or OFX. Up to 12 files at a time; long PDFs are split for you.
Not ready to upload your own? See a sample result
5 pages free, no account. The QuickBooks download appears on the results page.
Download the statement from NatWest
- Log in to NatWest (or Royal Bank of Scotland) Online Banking and select 'Statements' from the top menu. Business customers see it as 'Statements & transactions'.
- Choose the account, then the statement you want from the list. NatWest holds up to seven years online.
- Click 'View' to open it, then the download or save icon to keep the PDF.
- In the app: tap the account, then 'Statements', pick the month and tap the share icon to save the PDF.
Then drop the file above. Several months at once is fine; each statement comes back as its own .qbo file.
Before you upload: is the PDF password-protected?
NatWest and RBS statement PDFs are not password-protected. The same applies to Ulster Bank statements produced on the NatWest Group platform.
NatWest and QuickBooks
NatWest's transaction export offers OFX for Money, Quicken and Sage and CSV for Excel, not a QuickBooks file, and it carries no printed opening or closing balance. A converted .qbo keeps the Type codes such as D/D and BAC at the front of the description, which QuickBooks bank rules can match on.
From the transactions screen you can search by date and then 'Export', with OFX offered for Money, Quicken and Sage, and CSV for Excel. There is no PDF-to-CSV of the statement itself; the export is the transaction search result, so it lacks the printed opening and closing balances and the descriptions are often cut shorter than on the statement. Credit card transactions can only be viewed and exported for the last three months. When the numbers have to agree with a statement, or you need the full reference on a Faster Payment, converting the statement PDF is the better option.
Import into QuickBooks
- Drop the statement on the home page. Fix any flagged row (or swap debit/credit if the bank prints them reversed) until the badge is green.
- Click QuickBooks (.qbo).
- QuickBooks Online: Transactions → Bank transactions → Link account ▾ → Upload from file → choose the .qbo → pick the account → Next.
- QuickBooks Desktop: File → Utilities → Import → Web Connect Files → choose the .qbo → select the account.
- Review the imported transactions in the For Review tab and add them.
What usually goes wrong
- Multi-line descriptions are merged into one row; the row count is checked against the printed number of transactions.
- Reversed signs: money out imported as deposits. The most common complaint about statement converters. We show you the totals and let you swap before export.
- Duplicate transactions on re-import because the FITID changes each time. Ours is derived from the row content, so the same statement always produces the same IDs.
- "QuickBooks found an error" on upload, usually from a missing INTU.BID, unescaped ampersands or a bad date. Check any .qbo with our free QBO checker.
None of this is bank-specific configuration. The balance check catches these cases for every bank; this list just explains what you will see on a NatWest file.
Already have a .qbo that QuickBooks rejects?
Run it through the free QBO checker. It reads the file in your browser (nothing is uploaded) and lists exactly what QuickBooks will object to: missing INTU.BID, duplicate FITIDs, bad dates, unescaped ampersands, sign mismatches.
NatWest and QuickBooks questions
What do NatWest abbreviations like D/D, BAC, OTR and POS stand for?
D/D is a direct debit, S/O a standing order, BAC a BACS credit or debit, OTR an online or telephone transfer, POS a debit card purchase, C/L a cash withdrawal, CHG a bank charge and INT interest. stmtai keeps the code from the Type column at the front of the description so you can filter on it later.
Why are Paid in and Withdrawn the wrong way round compared with my other banks?
They are not wrong, just NatWest's order. Columns are read by their headings rather than their position, so credits land in Money in and debits in Money out regardless of which the bank prints first. The output has the same column order for every bank, which makes it easier to stack several accounts into one workbook.
Does it work with QuickBooks Online and Desktop?
Yes. The .qbo is OFX 1.02 with the INTU.BID QuickBooks requires, which both accept. Desktop imports via Web Connect.
What if QuickBooks rejects the file?
Run it through the QBO checker at /tools/qbo-checker; it explains what QuickBooks objects to. If the issue is with a file we produced, email support with the conversion ID and we fix the reader.
Can I get NatWest transactions into QuickBooks without the bank's own export?
Yes. Download the statement PDF from NatWest, drop it on this page and wait for the balance check, which compares the rows with the balances printed on the statement. Then download the QuickBooks file and import it with the steps above. No NatWest template is involved; the statement is read the way a person reads it, and the balance check is what tells you the rows are complete.