PayoutParse

Royal Bank of Scotland statement to FreeAgent

Upload the PDF statement Royal Bank of Scotland gives you and download a file FreeAgent imports as a bank statement. The lines are cast and checked against the statement's closing balance before you download.

First 5 pages free. No card, no account until you download.

payoutparse.com/app
rbs-statement.pdf Agrees with statement
Opening2,000.00
Movements2,818.86
Cast4,818.86
Statement4,818.86
DateDescriptionAmountBalance
02/06/2026STRIPE PAYMENTS UK LTD1,284.603,284.60
02/06/2026DD BRITISH GAS-96.403,188.20
03/06/2026CARD SCREWFIX 4412-212.992,975.21
04/06/2026FPI J PATEL INV 1042450.003,425.21
09/06/2026SO RENT UNIT 4-850.002,575.21
Xero CSVQuickBooks CSVOFXSageFreeAgentCSV

Example with synthetic figures.

About Royal Bank of Scotland statements

Same layout family as NatWest. PayoutParse reads the printed lines rather than relying on a fixed template, so older layouts and business account variants work the same way.

Importing into FreeAgent

In FreeAgent go to Banking > select account > Upload statement and choose the downloaded file. FreeAgent imports a 3 column CSV (date, amount, description). The payout split is provided as a separate journal CSV.

When you'd use this instead of a bank feed

Bank feeds cover the last 12 months at most and only from the day you connect them. Historic periods, closed accounts, accounts a client won't connect, and statements handed over as PDFs at year end all need a file import. That is what this is for.

Other formats

Royal Bank of Scotland to Xero, Royal Bank of Scotland to QuickBooks Online, Royal Bank of Scotland to Sage Accounting, Royal Bank of Scotland to CSV.