Sole traders usually face January with twelve PDFs and a prayer. HMRC requires records kept for five years after the deadline, and reconstructing allowable expenses from a PDF viewer in deadline week is how claims get missed or invented. The calmer method is monthly conversion: each statement to Excel while transactions are still memorable, one Category column, and a reconciliation check against the closing balance before the file is archived.
The free Bank Statement Converter preserves each bank's original columns — Barclays, HSBC, Lloyds, NatWest, Monzo, and Starling layouts all reduce to dated rows with amounts and running balances — so one categorisation template serves every account including the business one. Transfers between own accounts get marked as such immediately, which prevents the classic error of declaring moved money as income.
Quarterly totals then write themselves: income by month, expense categories summed, and a running estimate of profit against payments on account. Anything ambiguous gets a note column entry while the receipt still exists, not a guess in January.
Before filing, run the year's PDFs through the free Bank Statement Analyser as a second pair of eyes: recurring-income totals to cross-check declared turnover, cash-intensity flags where cash deposits need explaining, and balance reconciliation on every file. File the return, keep the Excel plus PDFs for the five-year window, and start next February calm.