Sole Trader Tax Spreadsheet UK

A sole trader often receives money through several routes: client invoices, card payments, online platforms, cash or bank transfer. Costs can be just as scattered across software subscriptions, mileage, tools, materials, payment fees and mixed-use household bills. Waiting until the Self Assessment deadline to reconstruct those movements is slow and makes omissions more likely. This workbook gives each transaction a consistent home, making it easier to see what happened during the tax year and which documents support the entry.

The dashboard turns the transaction log into a provisional view of gross business income, recorded costs and profit. “Provisional” matters. A spreadsheet cannot decide whether every cost is allowable, whether capital allowances apply, how losses should be treated or whether another accounting adjustment is required. Its value is in creating an organised, reviewable starting point. Clean records improve calculator estimates and make a conversation with an accountant more productive because the underlying figures can be traced.

The workbook follows the UK tax-year habit of keeping records from 6 April to 5 April. You can change the period if needed, but one workbook per tax year is the clearest approach. HMRC requires self-employed people to keep records of business sales and income, business expenses and evidence such as receipts or bank statements. The tracker is structured around those record types without pretending to be HMRC software.

Use the income rows for the full amount earned from the customer or platform, where the underlying reports allow you to identify it. A payment processor or marketplace may deduct fees before sending the balance to your bank. Recording only the net deposit can hide both part of the income and the related fee. A clearer record normally shows gross income as one entry and the processing or platform fee as a separate cost, supported by the same payout statement.

Include a useful description rather than a vague label. “May website project, invoice 1048” is easier to trace than “payment”. The client or source column helps when several income streams use the same bank account. Refunds should also be identified clearly rather than silently deleting the original sale. That preserves an audit trail and helps explain why platform totals and cash received may differ.

Do not add PAYE salary, personal transfers, loans or money moved between your own accounts as sole trader sales. The workbook is for business activity. Keeping non-business movements out of the transaction table prevents turnover from being overstated and makes reconciliation easier. If a bank account is used for both personal and business activity, take extra care to label only genuine business transactions.

HMRC describes allowable expenses as business costs that can be deducted when working out taxable profit. Personal spending is not an allowable business expense. Where a cost has both business and private use, only the business part is relevant. The workbook therefore includes a business-use percentage rather than assuming every entered purchase is fully deductible. For example, a phone or internet bill used for both work and home life should be considered on a reasonable basis.

Choose the closest category and explain unusual items in the notes. Categories are for organisation; they do not create tax entitlement. Equipment, vehicles, premises, finance costs, training and working-from-home costs can involve conditions or alternative methods. If the treatment is uncertain, record the payment and evidence but mark it for review instead of forcing a conclusion. This preserves the facts while leaving the tax decision to current guidance or professional advice.

Evidence references can be simple and consistent: “INV-2026-044”, “Bank Jul p3” or “Receipts/2026-08/software-12.pdf”. The file does not need to contain sensitive documents. It only needs to tell you where the supporting information is stored. Keep the documents securely and follow HMRC retention requirements. For Self Assessment records, HMRC generally says to retain them for at least five years after the 31 January submission deadline for the relevant tax year.

The £1,000 trading allowance relates to gross annual trading income before expenses. If gross trading income is £1,000 or less, the allowance can mean that income does not need to be reported in many circumstances, although exceptions exist. If gross trading income exceeds £1,000, check whether you need to tell HMRC and register for Self Assessment. Do not decide this from profit alone: £1,300 of income and £900 of costs is still more than £1,000 of gross income.

When income must be reported, a taxpayer may be able to deduct actual allowable expenses or use the trading allowance instead. HMRC says the trading allowance cannot be used as well as deducting those expenses for the same income. The dashboard provides a planning comparison so you can see which figure is larger, but it does not make the election or test every restriction. Keep records even when the allowance appears more favourable, because the income total and basis of the decision still need support.

If you have more than one small trade or miscellaneous income source, do not assume each receives a separate £1,000 allowance. HMRC’s guidance explains how the allowance is shared. Bring the relevant gross income together and check the official rules. The Side Hustle Tax Tracker may be more useful when you need to view several activities in one place.

Set a recurring date after the end of each month. Download bank, payment processor and platform statements; add missing entries; attach or file evidence; then compare the workbook totals with the source documents. Check for duplicated subscriptions, refunds, fees deducted before payout and cash payments that do not appear in the bank. A regular 20-minute review is usually more reliable than a long reconstruction after the tax year has closed.

Review the dashboard as a business tool as well as a tax record. Gross income shows activity, while provisional profit gives a clearer view of what may be available after recorded costs. The editable tax-pot percentage can help with cash-flow discipline, but it is not a tax calculation. The right amount to reserve depends on total taxable income, allowances, National Insurance, student loans, payments on account and personal circumstances.

At year end, lock down the period rather than continuing to edit old rows casually. Save a dated final copy and a backup. Compare totals with invoices and annual platform reports, check that the correct dates were used and flag questions before submitting a return. A clean year-end snapshot is easier to revisit if HMRC or an adviser asks how a number was produced.

The workbook does not calculate a final Income Tax or National Insurance liability. It does not apply Scottish Income Tax, student loan rules, capital allowances, loss relief, VAT, pension relief, High Income Child Benefit Charge or payments on account. It does not determine employment status, decide whether an activity is a trade or verify that a cost passes HMRC tests. Those limits are intentional: a record-keeping tool should not disguise assumptions as certainty.

For an estimate, take the checked income and expense totals to the Sole Trader Tax Calculator and include other income where the calculator requests it. For filing, use HMRC’s authorised route or suitable commercial software and rely on the final records. Seek qualified advice where there are large equipment purchases, losses, overseas income, VAT, multiple businesses, partnership income, property, company income or uncertainty about reporting.

This separation keeps the workflow honest. The workbook organises evidence, the calculator models a planning scenario and the tax return applies the filing rules. Using all three for their proper purpose is more useful than expecting one file to do everything.