Most guides stop the moment you import your Royal Bank of Scotland statement into Xero. But the import is only half the job. The real payoff comes in the days after: setting up bank rules that auto-categorize every recurring payment, matching transfers between your RBS current and savings accounts without breaking a sweat, and building a monthly reconciliation routine that takes minutes instead of an afternoon. This guide walks through all of it, starting from the statement itself.
Step 1: Get your RBS statement out of the PDF
RBS, part of the NatWest Group, lets you download statements as PDFs from Digital Banking or the RBS mobile app. Log in, open the account you need, choose your statement period, and save the PDF to your computer. That PDF is the raw material. Xero imports transactions from CSV files with columns like Date, Description, and Amount, so the first task is converting the PDF into a clean spreadsheet.
This is where ConvertStatement's Royal Bank of Scotland converter does the heavy lifting: upload the RBS PDF, let it extract every transaction line, and download a CSV that Xero will accept. RBS statements are usually well structured, but multi-page PDFs with running balances and fee footnotes can trip up manual copy-paste work — a converter catches rows you'd miss. Check the CSV before you move on: dates should sit in one consistent format, amounts should carry their signs correctly (money out as negatives), and the description column should read exactly as RBS wrote it. A clean file here saves you detective work later, because Xero bank rules match on those description texts.
Step 2: Import the CSV into Xero the right way
In Xero, go to Accounting, then Bank accounts, find your RBS account, and choose Import a statement. Upload the CSV you just made. Xero will ask you to map the columns — Date to date, Description to description or payee, Amount to amount. Take thirty seconds to review this mapping screen instead of clicking through it. A mis-mapped column imports garbage quietly, and you only discover it during reconciliation.
One important choice: import the whole statement period in one file rather than dribbling in partial months. Xero's reconciliation view works best with continuous, gap-free history. Also make sure the Xero bank account currency matches the RBS account (sterling), and that the opening balance in Xero matches the opening balance on the statement. If your balances disagree from day one, nothing downstream will ever line up. For a deeper walkthrough of that balancing act, see our bank statement reconciliation guide.
Step 3: Build bank rules that do the work for you
Here is where life after the import gets good. Open your RBS transactions in Xero's bank reconciliation view and look at the recurring items: your council tax, your broadband bill, the software subscriptions, the monthly rent payment. Each of these repeats with a nearly identical description month after month, and that consistency is exactly what Xero bank rules exploit.
Create a rule by clicking on a transaction, then Create a rule. Tell Xero: whenever the description contains a certain phrase — say, the name of your electricity supplier — categorize it to your utilities account and assign the right tax rate. Save it, and Xero will apply that rule to every matching transaction, past and future. Do this once for each recurring payment and you will watch dozens of transactions reconcile themselves.
Start with the ten or twelve highest-frequency items. Common wins for RBS business customers: payroll runs (the description often carries a reference like "Salary"), direct debits for insurance and utilities, standing orders for rent, card-processing fees, and regular supplier payments. Use the most distinctive slice of the description text rather than the full string — RBS sometimes appends changing reference numbers, and a rule keyed on the stable core text keeps working while one keyed on the full line breaks. Then spot-check the first month: Xero shows which transactions were rule-matched, so scan for anything misfiled and tighten the rule.
Step 4: Handle transfers between your RBS accounts
Most businesses run more than one RBS account — a current account plus a savings or reserve account, sometimes several. Moving money between them creates a pair of transactions: money out of account A, money in to account B. If you import both statements into Xero and treat both sides as ordinary transactions, you will double-count and your books will never reconcile.
The correct approach is Xero's transfer matching. When you reconcile the outgoing transaction, create it as a transfer to the other bank account in Xero, and it will appear as a matching line on the other account's reconciliation screen. One transfer, recorded once, visible on both sides. Import both RBS statements for the same period so the two sides are available to match. A word of caution: bank rules should never fire on transfers. If a rule auto-categorizes a transfer as an expense, exclude it — the description of a recurring transfer (for example a monthly sweep into a savings account) can look deceptively regular. This is the kind of nuance that separates tidy books from messy ones, and our accountant-focused reconciliation guide covers the full playbook.
Step 5: The monthly reconciliation routine that stays easy
Once the rules are built and transfers are matched, your monthly routine becomes short. Each month, download the latest RBS PDF from Digital Banking or the app, convert it, and import the new CSV. Then open reconciliation: approve the rule-matched transactions in bulk, manually handle only the new or unusual items, and confirm the closing balance matches the statement's closing balance.
Keep a small discipline that pays off over time. Reconcile monthly, not quarterly — three months of unreconciled transactions turn a thirty-minute job into a forensic exercise. Review your bank rules twice a year and retire ones whose vendors changed names. And when a transaction lands that looks wrong, investigate it in the RBS app before it ages; a duplicate charge found in week one is a quick dispute, while the same charge found in month six is an awkward phone call.
Done consistently, this routine gives you books that are always current. Your accountant gets clean data instead of a shoebox of PDFs, your tax filings pull from numbers you actually trust, and you spot cash-flow problems while there is still time to act — which, for a small business, is the whole point.
Frequently asked questions
Does Xero connect directly to RBS with a live bank feed?
Xero supports direct bank feeds for many UK banks, but feed availability changes over time and feeds can miss periods. Importing your converted RBS statement CSV is the reliable method that always works, and it is the approach this guide covers.
What CSV format does Xero need for an RBS statement?
A simple file with Date, Description, and Amount columns works. Keep one transaction per row, consistent date formatting, and negative amounts for money leaving the account. The ConvertStatement export is built exactly this way.
Will bank rules miscategorize my transactions?
Rules fire on description text, so a rule keyed on too-short a phrase can catch the wrong payee. Use distinctive text, check the first month's auto-matches, and never let rules touch transfers between your own accounts.
How do I fix an opening balance mismatch in Xero?
Compare the opening balance on your first imported statement with Xero's opening balance for that account. Adjust Xero's opening balance to match the statement before importing anything else; trying to fix it mid-reconciliation is far more painful.
Can I re-import a statement if something goes wrong?
Yes. Delete the incorrectly imported statement lines in Xero first, fix the CSV, and import again. Never import the corrected file on top of the bad one — you will create duplicates.
Getting your RBS statements into Xero is the easy part; keeping the books effortless afterward is where the wins compound. Start by converting your latest Royal Bank of Scotland PDF with ConvertStatement — free for your first statements — import it, build your bank rules, and enjoy reconciliation that practically runs itself.