Tax and GST

Year-end total of allowable costs: a UK self-employed worked method

A step-by-step year-end method for UK self-employed people to total business costs in pounds: categories, a mixed-use column, a check against bank lines and SUMIFS.

Editorial illustration for Year-end total of allowable costs: a UK self-employed worked method

The year-end question is simple: what did I spend on the business, by type? The method is just as simple. Put every transaction in one sheet, label it, apportion the mixed ones, and total by label. Then prove the total by adding everything back to your bank statements. Do this monthly, and the year end is a ten-minute task, not a weekend.

A layout that works for most sheets

  • Column A: date
  • Column B: what it was
  • Column C: type, from a short list
  • Column D: amount in pounds
  • Column E: business percentage, as a decimal
  • Column F: business amount, which is =D2*E2

Your accounting year may not run from January to December. Check the dates that apply to you and set the sheet to them. The rules for what counts are your tax authority's, and they change, so confirm with your accountant.

How do I handle mixed-use costs?

Decide the percentage once, write down how you got it, and apply it consistently. If you worked 30 of 120 waking hours of a month in a spare room, that logic needs a record you can show. Make a small second sheet that lists each shared cost, the percentage, the date you set it and the reason, and refer to it.

A worked year, quarter by quarter

Say your costs by quarter are as below. Each row shows the business amount after any share has been applied.

QuarterTravelSoftwareHome workingQuarter total
First£140£210£63£413
Second£95£210£63£368
Third£230£240£63£533
Fourth£120£240£63£423
Year£585£900£252£1,737

Check the rows: 140 plus 210 plus 63 is 413. Check the columns: travel is 140 plus 95 plus 230 plus 120, which is 585, software 210 plus 210 plus 240 plus 240 is 900, and home working 4 times 63 is 252. Add 585, 900 and 252 and you reach 1,737, which equals 413 plus 368 plus 533 plus 423. Cross-checking rows against columns catches typing errors.

Which formula totals one type for a date range?

=SUMIFS($F$2:$F$600,$C$2:$C$600,"Travel",$A$2:$A$600,">="&DATE(2026,4,6),$A$2:$A$600,"<="&DATE(2027,4,5)) totals travel between two dates. Replace the dates with your own period. The ranges stop at row 600 rather than using a whole column, so the formula is quick and you can see what it covers.

How do I check nothing is missing?

  1. Total all debits in your bank and card statements for the period.
  2. Total your sheet's business amounts and your private amounts.
  3. Compare the two. A gap means untagged or unlisted lines.
  4. Look for refunds, which should reduce a cost, and for transfers between your own accounts, which are not costs at all.

What if I only have a pile of receipts?

Then the receipts are your starting point. Sort them by month, enter each into the sheet with its date, amount and type, and then compare the monthly totals with your bank statement to find purchases that were paid but have no receipt. For those, look in email and in the supplier's account area for a copy. Anything you cannot document goes on a separate list for your accountant. It is better to show the list than to hide the gap.

When should I do this?

Do a light version every month: add the new lines, tag them and compare the sheet's total debits with the statement balance change. Do the full check at the end of each quarter, and the full reconciliation once at year end. That rhythm turns a daunting annual job into small tasks. If you ever fall months behind, start with the current month and work backwards rather than aiming for a perfect catch-up.

Last checks

  • Each shared cost has a written reason for its percentage
  • Each type's total ties to the sheet
  • Receipts exist for the larger items
  • Foreign-currency items show the pounds that left your account
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports