If you are just getting started with MTD, a spreadsheet is the simplest way to track your income and expenses. Download our free MTD-compliant template — available for both Excel and Google Sheets — and you will have everything you need to prepare for your first quarterly update.

What is included

FeatureIncluded
Income tracker (by date and category)Yes
Expense tracker (by date and category)Yes
Quarterly summary sheetsYes
Self-employment income sectionYes
Property income sectionYes
Digital links sectionYes
Simple instructions includedYes

How to use this template

  1. Download the Excel or Google Sheets version
  2. Enter your income — add each payment received with date, amount, and category
  3. Enter your expenses — add each expense with date, amount, and category
  4. Check your quarterly summary — the template automatically calculates your totals
  5. Use the summary for your MTD submission — enter the totals into your MTD software or bridging tool

Need more than a spreadsheet?

This template is a starting point. As your business grows, you may want to upgrade to MTD-recognised software that automates the submission process. Check out our software reviews and free MTD software guide for recommendations.