How to Convert an RBS PDF Bank Statement to CSV or Excel
RBS gives you more of your own data than most UK banks. The gaps are narrow, but they are exactly where bookkeepers end up working.
RBS exports more than most, with two catches
Royal Bank of Scotland runs on the same Digital Banking platform as NatWest and Ulster Bank, and it is one of the more generous UK banks with your own data. From Statements & transactions, then View transactions, you can search up to seven years of history and export what you find to Excel or PDF.
So for a current account the honest answer is that you may not need a converter at all. Two situations change that.
The card limit: RBS credit card transactions can be viewed and exported to Excel three months at a time. A year of card spending for the accounts means four exports and a merge, or twelve PDF statements converted in one batch.
The second is simpler. The file you have is often not the one the bank could give you. Lenders, letting agents, HMRC enquiries and new accountants all ask for statements, and statements are PDFs. If a client has sent you a year of RBS PDFs, asking them to log in and export it again is slower than converting what is already in your inbox.
Quick answer: RBS Digital Banking exports current account transactions to Excel or PDF, with up to seven years of history. Credit card transactions export three months at a time. For card statements, statements a client has already sent you as PDFs, or accounts you cannot log in to, convert the PDF statements instead.
When the PDF is the better source
Seven years of searchable history covers what HMRC expects for a current account. The converter earns its place in three narrower cases:
- Card statements beyond the three-month export window.
- Statements you already hold: PDFs a client has emailed, statements saved for a mortgage application, scans of paper statements.
- Accounts you have the paperwork for but not the login, which is the normal position when you take on a new client mid-year.
HMRC sets the floor for how long the records have to survive. A sole trader keeps them for at least five years after the 31 January filing deadline for the tax year, so a year's records can need keeping for nearly seven years. A limited company keeps them for six years from the end of the financial year they relate to. For an RBS current account the online history reaches that far. It is the card statements and the PDFs in someone's inbox that need converting.
Where each route stops
| Route | Formats | How far back |
|---|---|---|
| Digital Banking: current and savings accounts | Excel, PDF | Up to 7 years, if the account was open throughout |
| Digital Banking: credit cards | Excel | Three months per view and export |
| Statements | Up to 7 years | |
| Bankline (commercial) | Separate platform | Its own export rules |
Bankline, the NatWest Group commercial platform some larger RBS business customers use, is a separate system with its own export tools. Everything here is about Digital Banking, which is what most personal and small business customers have.
Converting the statements (4 steps)
- Download the PDF statements from RBS
Sign in to RBS Digital Banking, open Statements & transactions and download the PDF statements for the months you need. Each statement period is one PDF, so a year of a current account is twelve files. - Open the converter
Register free at reconcileiq.com/bank-statement-converter, then open Bank Reconciler and the PDF converter inside it. - Upload the statements together
Drag in several months at once. Each statement is read on its own and the transactions come back as one continuous set, so there is no stitching files together afterwards. - Check the output, then download
The extracted transactions appear on screen before you download anything. Check the first and last rows against each statement's opening and closing balance, then export as CSV.
Always check the balances: every RBS statement prints an opening and a closing balance. If the converted rows carry you from one to the other, nothing was missed. It takes ten seconds and it is the only real proof of completeness, from any tool, including this one.
What comes out
RBS prints money paid out and money paid in as separate columns. The converter turns them into one correctly signed amount, keeps the running balance in its own column so it never gets summed by accident, and rejoins descriptions that wrap onto a second line. Dates come out in one consistent order, so a spreadsheet set to US settings cannot read 03/04 as 4 March.
Page furniture is discarded: repeated column headers, page numbers, summary boxes and the small print on the last page. What you get is transactions and nothing else.
Convert Your RBS Statement
Upload the PDF, check the numbers on screen, download clean CSV. Your first statement of up to 10 pages converts free on a new account.
Convert your PDF now for freeFrequently Asked Questions
RBS Digital Banking exports transactions to Excel or PDF from Statements and transactions, then View transactions. The Excel file opens in any spreadsheet and can be saved as CSV. Credit card transactions export three months at a time.
Up to seven years in Digital Banking, provided the account was open throughout that period. Older statements have to be requested from the bank.
For card statements beyond the three-month export, for statements you have been sent as PDFs, and for accounts you have statements for but no login to. In those cases converting the PDF is quicker than getting a fresh export.
Yes. Personal and business current accounts, savings accounts and RBS credit card statements all convert, as do scans and photos of paper statements.
Your first statement of up to 10 pages converts free on a new account. Beyond that it runs on credits, and the cost per conversion is shown before anything is processed. Files are processed on our servers rather than in your browser, which is what lets scanned and photographed statements work as well as native PDFs.