Home › Sole Trader Kit

Sole Trader Kit

A Making Tax Digital record-keeping workbook for the self-employed. Record your sales and costs; it totals every quarterly update in HMRC’s categories.

What’s inside

SheetWhat it does
Start HereA one-page walkthrough in plain English.
SetupEnter the tax year and choose standard (6 April) or calendar (1 April) update periods. Your four periods and deadlines are calculated.
IncomeDate, customer, amount, category. Room for 2,000 entries a year. Retailers can enter one line of daily gross takings.
ExpensesDate, supplier, amount and one of HMRC’s 13 expense categories from a drop-down.
MileageLog business journeys. The flat-rate claim is worked out, including the switch to the lower rate after 10,000 miles.
Quarterly UpdatesYear-to-date totals for each of your four updates, a quarter-by-quarter view, profit so far, a set-aside-for-tax reminder and a countdown to each deadline.

The categories, exactly as HMRC lists them

Turnover · Other business income · Cost of goods bought for resale or goods used · Construction industry – payments to subcontractors · Wages, salaries, and other staff costs · Car, van, and travel expenses · Rent, rates, power, and insurance costs · Repairs and maintenance of property and equipment · Phone, fax, stationery, and other office costs · Advertising · Business entertainment costs · Interest on bank and other loans · Bank, credit card and other financial charges · Accountancy, legal and other professional fees · Other business expenses.

Built-in safety checks

  • Rows with an amount but no date or category turn amber, so nothing is silently left out.
  • Entries dated outside the tax year are counted and flagged.
  • Each update is cumulative, the way HMRC wants it: from the start of the tax year to the end of the period.

What you need

  • Excel 2016 or later (Windows or Mac), or a free Google account for Google Sheets.
  • HMRC-recognised bridging software to send your updates. How that works.
Please note: QuarterKit is a record-keeping tool, not tax advice, and it does not send anything to HMRC. It is not suitable as your only tool if you are VAT registered and want to file VAT from the same place.