How it works
Three small steps.
Type in rent and bills
Pick the quarter
Copy the totals across
What you get
The totals HMRC asks for, done.
Inside the sheet

Example data shown is made up. Next quarterly update deadline: 7 November 2026 (gov.uk). This sheet gets the numbers ready; your MTD software sends them.
Price
Blank sheet, a filled example and a short guide, for the 2026 to 2027 tax year. Download right after you pay.
Questions
Good to know.
Does it send my numbers to HMRC?
No. It gets your totals ready in HMRC’s 13 property categories. You copy them into MTD-compatible software, which sends them. It is not HMRC-recognised software and not tax advice.
When is the next update due?
7 November 2026, for 6 April to 5 October (standard periods), per gov.uk. The sheet lists all four deadlines for the year.
Excel or Google Sheets?
Both. Excel 2016 or newer, Excel on the web, or Google Sheets. Made-up example data is included so you can see it filled in.
