Convert a NatWest PDF statement to QuickBooks
Drop your NatWest PDF below and get the three-column CSV layout QuickBooks accepts for a manual bank upload — date, description and a single signed amount. Your statement never leaves your computer.
Drop your statement here
or choose a file — nothing is uploaded
Transactions found
| Date | Description | Out | In | Balance |
|---|
These appear on your statement but couldn't be read safely, so they've been left out rather than guessed at. Enter them by hand from your PDF.
What you get
The download is a .csv file with these columns, in this order:
DateDescriptionAmount
Worth knowing. This is a CSV, not a .qbo Web Connect file. QuickBooks accepts both for a manual upload, but they are different things — choose the CSV option on the upload screen, not the Web Connect one.
How to download your NatWest statement as a PDF
- Log in to NatWest online banking or the app.
- Select the account and open statements.
- Choose the period you need.
- Download the PDF.
Banking apps rename their menus from time to time, so the exact wording may differ slightly. You are looking for the original PDF statement rather than a printout or a screenshot — a printed copy sometimes loses the table structure the converter reads.
How to import it into QuickBooks
- In QuickBooks, go to the banking or transactions area.
- Choose the option to upload transactions from a file rather than linking a bank.
- Select the downloaded CSV and pick the account it belongs to.
- Confirm the three columns are read as Date, Description and Amount.
- Finish the import and categorise the transactions.
Accounting packages move their menus around between releases, so these are written to describe what you are looking for rather than an exact path.
Notes for NatWest statements
Some statements mark amounts with CR and DR instead of a minus sign; where that happens the converter reads the suffix rather than the sign. NatWest has not yet been checked against a real file — the balance check will tell you whether yours came out right.
Why the conversion happens in your browser
A bank statement lists your income, your address, your spending and your account number. Most converters ask you to upload that to their servers and keep it there. This one reads the file locally instead, so there is no copy of your statement anywhere but your own machine — and nothing that can be breached later.
Common questions
Can I get a .qbo file instead?
No — this tool writes CSV, not QBO. QuickBooks accepts a three-column CSV for manual bank uploads, which is what you get here, and it is the route that does not require your bank to support Web Connect.
Why is there only one amount column?
QuickBooks' three-column layout expects a single signed amount, so money out is written as a negative number and money in as a positive one.
Is my NatWest statement uploaded to convert it?
No. The PDF is read by JavaScript running in your own browser, and there is no endpoint on this site that can receive it. You can watch your browser's network tab while it converts and see that nothing carrying the file leaves.
How do I know the figures are right before I import them?
Where your NatWest statement prints a running balance, every amount is re-checked against it and you are told how many rows that covered. Anything that could not be read safely is listed separately and left out of the file rather than guessed at. Check both before importing into QuickBooks.
What does it cost?
One page credit converts one page, and five are free on your first visit. If a statement is longer than your balance covers, the opening pages convert free as a preview so you can see whether it reads your layout before paying. Nothing is charged when a conversion fails.
Other formats for a NatWest statement
- NatWest statement to CSV or Excel
- NatWest PDF to Excel
- NatWest PDF to Xero
- NatWest PDF to FreeAgent
- NatWest PDF to QIF
QuickBooks imports for other banks
Simple pricing
One credit converts one page, so you pay for what you actually convert — a two-page statement costs two. Five credits are yours to start with.
Free
£0
- 5 page credits to start
- Full export, every format
- No account needed
Enough to check a short statement end to end.
Page credits
£9.99
- 50 page credits
- Credits never expire
- One-off — nothing recurring
About four twelve-page statements.
Pro
£24.99/mo
- 500 page credits a month
- Tops up automatically
- Cancel anytime
For bookkeepers running client statements monthly.