PayoutParse

Coutts statement to Xero

Upload the PDF statement Coutts gives you and download a file Xero 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
coutts-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 Coutts statements

PDF statements with a running balance. 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 Xero

In Xero go to Accounting > Bank accounts > Manage account > Import a statement and choose the downloaded file. Xero's Stripe feed only records fees automatically for invoices paid through Xero. For everything else you post the payout journal yourself; PayoutParse produces it in Xero's manual journal CSV format (Accounting > Manual journals > Import).

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

Coutts to QuickBooks Online, Coutts to Sage Accounting, Coutts to FreeAgent, Coutts to CSV.