Are you a sole trader or landlord with more than one income stream? This is the MTD for Income Tax spreadsheet built specifically for you.

Most MTD spreadsheets assume you have one income source. This one doesn't. Designed by a qualified bookkeeper, this Excel spreadsheet handles up to three separate income streams, perfect for anyone combining self-employment, a second trade, and property income.

──────────────────────────────

WHAT IT DOES

──────────────────────────────

✔ Tracks income and expenses separately for each income stream

✔ Automatically calculates quarterly totals for Q1, Q2, Q3 and Q4

✔ Apportions shared costs (phone, home office etc.) across income streams using your own percentage split

✔ Consolidates all streams into one summary for easy quarterly submission

✔ Switches between Cash and Accruals accounting basis at the click of a dropdown

✔ Built-in HMRC expense categories, SA103F for self-employment, SA105 for property

✔ 100 transaction rows per income stream per quarter, more than enough space

✔ Full instructions tab included, no bookkeeping experience needed

──────────────────────────────

WHY THIS SAVES YOU MONEY

──────────────────────────────

MTD accounting software subscriptions can cost £15–£30 per month. That's up to £360 a year, every year. This spreadsheet is a one-off purchase that works with free or low-cost HMRC-recognised bridging software (such as My Tax Digital, which is completely free). Keep working in Excel — just submit digitally.

──────────────────────────────

WHAT'S INCLUDED

──────────────────────────────

• Instructions tab - step by step guide

• Settings tab - enter client details, accounting basis and shared cost splits once

• 3 Income Stream tabs - one per business or income type

• Shared Costs tab - log shared expenses and apportion automatically

• Quarterly Submissions tab - all four quarters summarised in one place, ready for bridging software

──────────────────────────────

MANDATORY FROM APRIL 2026

──────────────────────────────

Making Tax Digital for Income Tax is now mandatory for sole traders and landlords with qualifying income over £50,000 (expanding to £30,000 from April 2027 and £20,000 from April 2028). This spreadsheet keeps you compliant without the learning curve or monthly fees of full accounting software.

──────────────────────────────

HOW TO USE IT

──────────────────────────────

1. Download the Excel file

2. Open the Settings tab and enter your details

3. Record transactions on each income stream tab throughout the quarter

4. Use the Quarterly Submissions tab to read off your totals

5. Submit via your chosen free HMRC-recognised bridging software

We recommend saving one copy per quarter, clearly labelled (e.g. Q1 2026-27).

──────────────────────────────

IMPORTANT NOTES

──────────────────────────────

• Compatible with Microsoft Excel (Windows and Mac)

• Requires HMRC-recognised bridging software to submit to HMRC, this spreadsheet does not submit directly

• This is a digital download, no physical product will be posted

• Licensed for use by one business

Any questions? Please message us before purchasing and we will be happy to help.