UK
About NatWest statements
NatWest is a long-standing UK high-street bank and part of the NatWest Group, alongside Royal Bank of Scotland. You grab the statement PDF from Online Banking or the app, under View statements — same as you would for any branch-based account.
The part a copy-paste can't handle is the layout. NatWest puts a Type column between the date and the description, carrying codes like BAC, DD, SO, POS, ATM and TFR for how each payment moved. The converter reads all of that into its own columns instead of losing it.
You keep GBP (pounds) amounts and DD/MM/YYYY dates end to end, so nothing needs re-checking after the import. Scanned or photographed PDFs work too: OCR reads them into the same columns, and the running balance is checked before anything downloads.
Once it's in Zoho Books, you reconcile the lines like any other import — the conversion just saves you the typing.
Why people convert NatWest to Zoho Books
If you're reconciling a client's NatWest account in Zoho Books, you'll hit months with no live feed. A converted CSV imports straight into Banking → Import Statement, so the gaps fill in without retyping.
It also saves the back-and-forth at year end. Instead of asking a client for a CSV their NatWest login may not even offer, you take the PDF they already have and convert it, so the numbers in Zoho Books match the statement line for line.
Import a NatWest statement into Zoho Books
Zoho Books imports a CSV — there's no separate Zoho file, so you use the clean CSV.
- Convert the PDF above and download the CSV.
- In Zoho Books: Banking → pick the account → Import Statement.
- Upload the CSV and map Date / Description / Amount.
- Import, then categorise the lines.
The totals are checked first
The totals are checked before you download. If a row is missing, the statement gets flagged right here — so a gap shows up before it reaches Zoho Books or your client, not after.
Frequently asked questions
How does the NatWest statement go into Zoho Books?expand_more
No special file — Zoho Books imports a plain CSV, so you use the clean CSV from here. Go to Banking → your account → Import Statement, then map Date, Description and Amount. There's a preview before it commits, so you can check the columns matched before the lines post.
How is a NatWest statement laid out?expand_more
NatWest puts a Type column between the date and the description, carrying codes like BAC, DD, SO, POS, ATM and TFR for how each payment moved. The converter reads each of those into its own column, so the Zoho-ready CSV imports into Zoho Books cleanly.
Where do I download the NatWest statement?expand_more
From Online Banking or the app, under View statements. Save the PDF, then drop it into the converter above — multi-page and multi-month statements are read in one go.
Can I use a photo of my NatWest statement?expand_more
Yes. Scanned or photographed PDFs are read with OCR into the same columns, and the balance check still runs, so a scan converts the same as a digital download.
Do I need to pay or sign in?expand_more
Yes — the CSV downloads with no login and no charge to start.