UK Trades & Landlord Money Pack – Sole Trader & Landlord Spreadsheets 2026/27

Keep your money records tidy for the 2026/27 tax year. Two ready-made spreadsheets: an income & expense tracker for sole traders and tradespeople (with mileage, CIS and Making Tax Digital quarterly totals), and a rental tracker for landlords (with rent, arrears and gas safety, EICR and EPC due dates). Type in your figures and the totals, summaries and dashboard work themselves out. Works in Excel and Google Sheets. Black and gold design by S.H Decor.

WHAT'S INCLUDED

1. Sole Trader Income & Expense Tracker (.xlsx)

- Income log (up to 1,000 entries): gross amounts, including CIS work before deductions

- Expense log (up to 1,000 entries) with 17 categories based on GOV.UK's list of allowable expenses for the self-employed, plus a business-use % column for things that are partly personal

- Mileage log with the 2026/27 GOV.UK flat rates worked out for you (55p for the first 10,000 car/van miles, 25p after, 24p for motorcycles)

- CIS tab for subcontractors: labour, materials, 20% / 30% / 0% rate, expected deduction, the deduction on your statement and net paid, with a mismatch alert

- Monthly summary (tax months, 6th to 5th)

- Quarterly summary for the Making Tax Digital update periods, with deadlines and "tax year so far" totals

- Annual summary for your Self Assessment, with CIS and mileage checks

- Profit dashboard: income, expenses, income minus expenses, margin, CIS deducted, business miles, next MTD deadline and a monthly chart

2. Landlord Rental Tracker (.xlsx)

- Properties tab (up to 15 properties)

- Rent due (filled in from tenancy dates), rent received by month and arrears, with red alerts

- Expenses by property and category (based on GOV.UK's list for landlords). Mortgage interest and capital improvements are kept separate

- Safety certificate and deposit tracker: deposit protection deadline (30 days), gas safety (yearly), EICR (5-yearly or the interval on your report), EPC (10 years) and alarm checks. Red/amber/green colours show overdue and due-soon dates

- Annual summary per property and by category, with MTD quarterly totals and an alerts count

3. How-to-use guide (PDF, 12 pages)

- Step-by-step instructions with screenshots, a year-end checklist, help if something looks wrong, and the GOV.UK facts used, with links

FORMATS

- 2 × Excel workbooks (.xlsx). They also work in Google Sheets (upload to Drive, then File › Save as Google Sheets) and LibreOffice

- 1 × PDF guide (A4)

- Delivered as one .zip download

- Each workbook has one example row on each log, clearly marked, so you can see how it works. Type over it or clear it

PLEASE NOTE

- These are record-keeping templates, not tax, legal or financial advice. They add up the figures you type in. They don't work out tax or National Insurance, and they are not Making Tax Digital software: they can't send anything to HMRC. If you're in MTD, you'll need MTD-compatible software for your quarterly updates.

- Rates, thresholds and dates come from GOV.UK (checked October 2026) and are set for the 2026/27 tax year. Rules change, so check GOV.UK each tax year, and ask HMRC or an accountant if you're unsure.

- Safety and deposit rules in the landlord tracker are for England. Wales, Scotland and Northern Ireland have their own rules.

- Digital download. Nothing is posted. You'll get the files to download straight after payment. By buying, you agree to get the files straight away and understand you lose the 14-day cancellation right once the download starts.

- For use in your own business or lettings. Please don't resell or share the files.

Black and gold design by S.H Decor.