PayoutParse

Lloyds statement to Xero

Upload the PDF statement Lloyds 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
lloyds-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 Lloyds statements

PDF statements list Date, Payment type, Details, Paid out, Paid in, 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

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