How to Use Bank Statement CSVs for Self-Assessment (2026)

If you're self-employed, a freelancer, or a landlord in the UK, self-assessment is unavoidable. What is avoidable is the hours of manual data entry that most people endure when pulling together their tax return. The key is getting your bank statements into CSV format early — and building a simple workflow that makes tax season feel less like a punishment.

Why CSV Files Make Self-Assessment Easier

HMRC requires you to report all income and claim allowable expenses for the tax year (6 April to 5 April). Most people collect this information from bank statements, but PDF statements are static documents — you can't sort, filter, or categorise transactions in a PDF.

A CSV file, on the other hand, opens in Excel or Google Sheets and immediately becomes workable data. You can filter transactions by type, sum up expense categories, identify income sources, and produce the totals you need for your SA103 or SA105 form. What takes hours with a PDF and a calculator takes minutes with a well-organised spreadsheet.

Step 1: Gather Your Statements

Start by downloading all bank statements covering the tax year. For the 2025/26 return, you need transactions from 6 April 2025 to 5 April 2026.

If your bank offers CSV exports directly, use those. If not — and many UK banks only provide PDF statements — convert the PDFs to CSV using BankToFile. Upload your PDF statements, select CSV as the output, and download clean spreadsheet files. This works with all major UK banks including Barclays, HSBC, Lloyds, NatWest, Nationwide, Santander, Monzo, Starling, and Revolut.

Make sure you gather statements from every account used for business activity, including current accounts, savings accounts, and credit cards.

Step 2: Organise by Category

Once your transactions are in a spreadsheet, add a "Category" column and start classifying each expense. Common self-assessment expense categories include:

• Office costs (stationery, printing, postage)
• Travel (fuel, train tickets, parking — not commuting)
• Clothing (uniforms or protective clothing only)
• Staff costs (salaries, subcontractor payments)
• Professional fees (accountant, legal, insurance)
• Marketing (website, advertising, subscriptions)
• Telephone and internet (business proportion)
• Premises costs (rent, utilities, business rates)

For income, mark each payment received from clients or customers. If you have a separate business bank account, this is straightforward. If you mix personal and business transactions in one account, you'll need to identify which transactions are business-related.

Step 3: Sum the Totals

With categories assigned, use spreadsheet formulas to generate the totals HMRC needs. A simple SUMIF formula does the job:

=SUMIF(CategoryColumn, "Travel", AmountColumn)

This gives you the total for each expense category, which maps directly to the boxes on your self-assessment form. Your accountant (or your accounting software) will use these same totals, so getting them right at the CSV stage saves time downstream.

Step 4: Reconcile and Cross-Check

Before submitting anything, reconcile your spreadsheet against the original PDF statements. Check that the opening and closing balances match, that no transactions are missing, and that your categorisation makes sense. Common mistakes include classifying personal expenses as business costs, missing income from less frequent clients, and double-counting transactions that appear in both a current account and a credit card statement.

Using BankToFile in Your Tax Workflow

The biggest time sink in self-assessment preparation is getting the raw data out of bank PDFs and into a usable format. BankToFile eliminates that step entirely. Convert a full year of PDF statements into CSV files in minutes, then spend your time on the analysis and categorisation that actually matters.

This is especially valuable if you bank with institutions that don't offer CSV exports — HSBC, for example, only provides PDF monthly statements for personal accounts. Rather than typing transactions manually, upload the PDFs to BankToFile and have spreadsheet-ready data immediately.

Tips for a Smoother Tax Season

Convert statements monthly, not annually. Don't wait until January to tackle a year's worth of PDFs. Set a monthly reminder to download and convert your statements. Twelve small tasks are far less daunting than one enormous one.

Keep a separate business account. This is the single most effective thing you can do for easier self-assessment. When every transaction in an account is business-related, categorisation becomes trivial.

Retain original PDFs for five years. HMRC requires you to keep financial records for at least five years after the 31 January submission deadline. Store your PDF statements securely alongside the working CSV files.

Use accounting software if your volume justifies it. If you have more than a few dozen transactions per month, tools like Xero, QuickBooks, or FreeAgent can import your CSVs and handle categorisation, reconciliation, and even SA103 form generation. The CSV from BankToFile imports cleanly into all of these platforms.

Don't forget Making Tax Digital. From April 2026, MTD for Income Tax applies to self-employed individuals earning over £50,000. You'll need MTD-compatible software to submit quarterly summaries. Getting comfortable with CSV workflows now prepares you for that transition.

Conclusion

Self-assessment doesn't have to be a January nightmare. The foundation of a stress-free tax return is clean, categorised bank data — and the fastest way to get there is converting your PDF statements to CSV at the start of the process rather than the end.

Start with BankToFile's free converter to turn your bank statement PDFs into spreadsheets, then organise, categorise, and submit with confidence.