Convert NatWest statements to Excel and CSV
To convert a NatWest statement to Excel or CSV, upload the PDF, scan or photo to statement.work and export the transactions with date, description, signed amount and running balance, ready for bookkeeping software or a spreadsheet.
Not affiliated with NatWest. statement.work is an independent tool. NatWest is a trademark of its owner and is named here only to describe the statements this page is about.
About NatWest statements
NatWest is one of the UK’s largest banks and part of NatWest Group, which also includes Royal Bank of Scotland and Ulster Bank. It has a large base of business customers, from sole traders to established firms, so NatWest business statements are common in UK bookkeeping.
What the statements typically contain
- Account details (sort code and account number) and the statement period.
- A brought-forward balance at the start.
- A table of transactions with date, description, paid out, paid in and balance.
- Day-first dates, often printed once for several transactions on the same day.
- For business accounts, charges and any account fees for the period.
Your own statements are the definitive reference; designs vary and change.
Common conversion problems
- Date carried down. When the date is printed only once per day, copied rows lose their date. statement.work fills every row.
- Split amount columns. Paid out and paid in become a single signed amount.
- Business charges. Account and transaction charges may be summarized for the period and applied as one debit. They are easy to miss and worth checking in our fees guide.
- Takings and settlements. Card takings typically arrive as batched settlements, so match them to your card provider’s reports, not individual sales.
How to convert it
- Download the PDF statement from online banking, or use a scan or photo.
- Upload it to statement.work.
- Review the transactions and categories.
- Export as CSV for import or Excel for review.
- Check that the closing balance matches.
For bookkeepers
When a client’s bank feed has gaps, converting the PDF statements fills them with data in a consistent layout. See statement.work for bookkeepers and the CSV import guide. Other UK banks such as Barclays and Santander UK convert to the same columns.
Questions
Do Royal Bank of Scotland statements convert the same way?
Royal Bank of Scotland is part of NatWest Group alongside NatWest. statement.work doesn't need a template per bank, so statements from any of these brands convert to the same columns.
Can I import the CSV into UK bookkeeping software?
Most bookkeeping software can import bank transactions from CSV. statement.work does not claim native integrations; see our CSV import guide for the general steps.
Is statement.work affiliated with NatWest?
No. statement.work is independent and is not affiliated with or endorsed by NatWest or NatWest Group.