Convert a Starling Bank Statement to Excel

Starling Bank statement conversion for personal and business accounts, and what makes app-native statements easier to work with.

Starling statements are among the cleanest to convert of any UK bank, and Starling Business accounts are particularly common in conversion requests because so many UK sole traders bank there.

Business accounts and bookkeeping

A sole trader or small limited company banking with Starling typically needs the same thing every quarter: transactions in a spreadsheet, categorised, ready for a VAT return or a set of accounts.

Starling helps by including a reference field and, on business accounts, often a category. Both are worth keeping as columns rather than flattening into the description.

Reference versus description

On a business account these are genuinely different fields with different uses. The description is who the money went to or came from. The reference is what the payer typed — usually an invoice number.

For anyone matching payments against invoices, the reference is the more valuable of the two, and it needs to be its own column to be usable in a lookup.

Converting

Export the statement PDF from the Starling app Available per month or for a custom range.
Upload and convert Choose CSV if the file is going into accounting software.
Check the totals Starling prints period totals and a running balance, so full verification is available.
Match on reference For invoice reconciliation, the reference column is the field to match on.

A quarterly routine for a Starling business account

Export the quarter's statement as PDF From the Starling app, for the exact VAT or accounting period.
Convert and verify Confirm it reconciles before doing anything else with it.
Match credits against invoices on the reference column A VLOOKUP against your invoice list. Unmatched credits need investigating.
Categorise debits Using a lookup table on merchant name, built once and reused.
Check for missing invoices Any credit with no matching invoice is either unbilled work or personal money.

The unmatched rows are the point

It is tempting to treat categorisation as the work. It is not — the reconciliation is.

An unmatched credit means either an invoice you never raised, a duplicate payment from a client, or money that is not business income. All three matter, and none of them show up in a neatly categorised summary.

Frequently asked questions

Does Starling export CSV directly?

Yes, in-app. Converting the PDF is useful when you need older history, or a record that matches the official statement exactly.

How do I match payments to invoices?

Match on the reference column rather than the description. Where clients quote the invoice number as the payment reference, it is a single lookup.

Are Starling Spaces handled?

Yes. Transfers to and from Spaces appear as transactions, similar to Monzo Pots.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.