Import a CSV statement from any UK bank

The format is detected, not configured

Statement layouts differ by bank in ways that matter: some carry one signed amount column, others split money in and money out across two, and the column names are all different. Taxmo reads the header row and matches it against known layouts before asking you anything.

• Barclays, HSBC, Lloyds, NatWest and RBS, Starling, Monzo and Revolut are recognised by their own column names
• Anything unrecognised falls back to a generic mapping across the column names statements commonly use
• Single-amount and separate credit and debit layouts are both handled, so a blank cell is not read as a zero
• Date order is taken from the bank's own convention, including the year-first format Revolut exports

No window, no re-authorisation

An Open Banking connection returns a recent window and asks you to authorise at your bank each time. A statement you exported yourself has neither limit. That makes CSV the right tool for a late catch-up, a closed period, an account you have since shut, or a bank whose connection you would rather not set up at all.

Imported is not the same as counted

Rows arrive as pending. They are not in your profit figure and not in your VAT return until you approve them, and the pre-filing checklist blocks on an unreviewed batch. Categorisation rules you have set are applied as rows come in, so on a second or third import the review is mostly confirming rather than typing.

Duplicates when you mix routes

Importing the same period twice, or covering it once by connection and once by file, is a normal thing to do by accident. Imports are matched before they land rather than after, so overlapping a period does not silently double your expenses. It is still worth importing in whole periods rather than overlapping ranges, because a clean run is easier to check than a deduplicated one.

What a bank line is not

A statement line proves money moved. It does not prove what was bought, whether it was a business cost, or how much VAT it carried. For a VAT reclaim, the VAT invoice is the evidence HMRC wants, not the bank row. Import the statement to make sure nothing is missed, and keep the receipts to make the figures defensible.

Common questions