{"product_id":"making-tax-digital-spreadsheet-uk","title":"Making Tax Digital Spreadsheet 2026\/27 – MTD Quarterly Update Tracker for Sole Traders \u0026 Landlords (UK)","description":"\u003cp\u003eMaking Tax Digital for Income Tax means a quarterly update to HMRC every three months. This spreadsheet keeps your records the way HMRC asks for them and adds up each update for you, so all your bridging software has to do is send it. The next update is due \u003cstrong\u003e7 November 2026\u003c\/strong\u003e.\u003c\/p\u003e\n\u003ch3\u003eHow it works\u003c\/h3\u003e\n\u003col\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLog as you go\u003c\/strong\u003e: date, amount and HMRC category for every payment in and every cost out. That's the record HMRC requires.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEach entry lands in its update period\u003c\/strong\u003e automatically (Q1 to Q4), using standard periods (6 April to 5 July…) or calendar periods (1 April to 30 June…).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eThe Quarterly Updates tab adds it up\u003c\/strong\u003e: year-to-date totals for every category, cumulative the way HMRC wants them, linked to your logs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eYour bridging software reads the file and sends it.\u003c\/strong\u003e No retyping: HMRC requires a digital link, and linked cells or a file import count.\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003ch3\u003eWhat's inside\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelf-employment income and expenses\u003c\/strong\u003e using the 14 expense categories from HMRC's full self-employment pages, with a column for any not-allowable part and a receipt check.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUK property\u003c\/strong\u003e for landlords: rent, premiums and the six property expense categories, with mortgage interest kept separate as HMRC requires.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQuarterly Updates\u003c\/strong\u003e: totals for all four updates, deadlines (7 Aug, 7 Nov, 7 Feb, 7 May), status (days left, overdue, sent) and a tick when it's done.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMileage log\u003c\/strong\u003e at the 2026\/27 flat rates: 55p a mile for the first 10,000 business miles, then 25p (motorcycles 24p), added to your travel costs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUse of home\u003c\/strong\u003e flat rate from your monthly hours (£10, £18 or £26), added to the right category.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDo I need MTD?\u003c\/strong\u003e checker: enter your turnover and rental income and see whether you start in April 2026, April 2027 (over £30,000) or April 2028 (over £20,000).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTax estimate and tax pot\u003c\/strong\u003e: Income Tax and Class 4 National Insurance at 2026\/27 rates, the trading and property allowance checks, and the % of each payment to put aside.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeadlines\u003c\/strong\u003e: every 2026\/27 date with a live countdown, up to the 31 January 2028 tax return.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProtected formulas\u003c\/strong\u003e, so you can't break the maths by accident.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eGood to know\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA spreadsheet can't send updates by itself. You'll need HMRC-recognised bridging software; some are free. Find one with \u003ca href=\"https:\/\/www.gov.uk\/guidance\/choose-the-right-software-for-making-tax-digital-for-income-tax\" target=\"_blank\" rel=\"noopener\"\u003eHMRC's software finder\u003c\/a\u003e.\u003c\/li\u003e\n  \u003cli\u003eTurnover under £90,000? You can send income and total expenses only. The categories are there if you want the detail.\u003c\/li\u003e\n  \u003cli\u003eHMRC won't give penalty points for late quarterly updates in 2026\/27, so it's a good year to get set up.\u003c\/li\u003e\n  \u003cli\u003eThis is a record-keeping and estimating tool, not tax advice and not HMRC software itself. The tax estimate uses rates for England, Wales and Northern Ireland.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eWorks with\u003c\/h3\u003e\n\u003cp\u003eMicrosoft Excel, Google Sheets (free) and Apple Numbers. Instant download. Doing your 2025\/26 return first? See the \u003ca href=\"\/products\/self-assessment-spreadsheet-uk\"\u003eSelf Assessment Spreadsheet\u003c\/a\u003e.\u003c\/p\u003e","brand":"Planner Season","offers":[{"title":"Default Title","offer_id":67644430451056,"sku":"MTD-UK-2026-27","price":12.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1036\/2758\/7952\/files\/mtd-uk-0.png?v=1791271718","url":"https:\/\/plannerseason.com\/products\/making-tax-digital-spreadsheet-uk","provider":"Planner Season","version":"1.0","type":"link"}