Spreadsheets and Making Tax Digital: the digital-links rule for driving instructors
Pupil, date, amount paid, a running total at the bottom: if that is how you keep your books, Making Tax Digital for Income Tax does not ban it. It does change what happens between the spreadsheet and HMRC.
MTD for Income Tax started on 6 April 2026 for sole traders with qualifying income over £50,000, and reaches £30,000 on 6 April 2027 (HMRC). Once you are in, your records have to be digital, and if you use more than one product, the path from those records to HMRC has to be digitally linked. That second part is where a spreadsheet plus hand-typed totals falls down.
What HMRC says
HMRC's digital records guidance sets out two cases:
- One software product for everything. If one product creates your digital records, sends your quarterly updates and submits your tax return, you do not need to link it to anything else.
- More than one product. You must digitally link your record-keeping software and the software that uses those records to make submissions to HMRC. Do it when you set up, or before you send an update or submit your tax return.
HMRC's examples of a digital link:
- linked cells in a spreadsheet, such as a formula in one sheet that mirrors a cell in another
- emailing a spreadsheet of digital records so it can be imported into another product
- moving digital records on a memory stick for someone to import
- XML or CSV import and export, and downloading and uploading files
- automated data transfer
- API transfer
Once a record has been sent to HMRC in a quarterly update, HMRC says you must not move it by hand, within your software or to other software. Its examples: writing the figure out again in another cell or program, and cut and paste or copy and paste.
Typing a lesson payment into your records in the first place is fine. HMRC lists manually entering income and expenses as one way software creates digital records (HMRC). And some software never needs linking: HMRC gives software that takes bookings, or a till that records sales, as examples, because they do not create your MTD digital records. Your diary app is not the problem. The spreadsheet-to-HMRC step is.
Where a spreadsheet goes wrong
A familiar year-end spreadsheet routine:
- Record income and expenses in a spreadsheet through the year.
- Total them with SUM formulas.
- Type the totals into the tax return.
Under MTD, step 3 leaves no digital link between your records and the submission. It does not matter how accurate the spreadsheet is.
The same gap can hide earlier. Say you keep a lesson log in one sheet and copy monthly totals by hand into a summary sheet that your bridging software reads. The copy step is manual, so the figures the bridging software sends are not linked to your lesson log. A formula that pulls the figure across instead, for example ='Lesson Log'!$F$100, is a linked cell, which HMRC lists as a digital link.
Three setups that work
1. One product for records, updates and the tax return
The least to think about. You log income and expenses in MTD software, and the same software sends the updates and the return, so there is nothing to link. Orbit is being built to work this way for lesson income and expenses: payments taken through Orbit are recorded as they happen and you log expenses on your phone. Orbit is built on HMRC's Making Tax Digital for Income Tax API and is completing HMRC's software recognition process; live submissions to HMRC open once HMRC approves it, and until then you need software on HMRC's compatible list to send updates. See how the MTD tools work, or compare other options in our ADI software guide.
2. Spreadsheet plus bridging software
HMRC describes bridging software as software that connects to records kept in spreadsheets or other tools and makes your submissions to HMRC. You keep your spreadsheet. Two checks before you commit:
- the bridging product should read your actual records through linked cells or an import, not a template you paste totals into
- HMRC notes that only some bridging products both send quarterly updates and submit the tax return, so confirm what yours covers
3. Spreadsheet plus accounting software
Keep the spreadsheet for day-to-day records and import it into MTD accounting software by CSV before each update. The import is the digital link. It works, but you are running two systems.
What the penalty rules say
An earlier version of this article said HMRC would take a "light touch" in year one and would treat a broken digital link the same as a late submission from April 2027. We could not find either statement in HMRC's guidance, so we have removed both.
What HMRC's penalties guidance does say:
- There are no penalties for missing a quarterly update deadline in the 2026 to 2027 tax year. You still have to send the updates before you can submit your tax return.
- From 2027-28, each missed quarterly update or tax return deadline earns a point. At 4 points you get a £200 penalty, and another £200 for each further missed deadline.
The guidance ties points to missed deadlines. It does not list broken digital links as a points trigger. The linking rule is still part of how HMRC tells you to keep records, so a chain with a manual step in it is a chain you will have to fix. Our penalty points guide covers the points system in full.
Moving off a hand-typed spreadsheet
1. Draw your data chain. Where does each figure start, and where does it go? Any arrow that means "I read this and type it there" needs replacing with a link.
2. Pick the setup. Not a spreadsheet person: option 1. Attached to your workbook: option 2. Already have an accountant working in an accounting package: option 3 may suit.
3. Start at the right date. If your accounts run to 5 April, HMRC says digital records start from 6 April of the tax year you join. For the £30,000 group, that is 6 April 2027.
4. Run both for a month. Record in the old and new systems side by side, then reconcile. It catches set-up mistakes before your first update.
5. Put the deadlines in your diary. Quarterly updates are due 7 August, 7 November, 7 February and 7 May (HMRC). Set a reminder a week before each.
For the full rules on who is in and when, read our guide to Making Tax Digital for driving instructors.
Disclaimer
This article is for general information and does not constitute tax, legal, or financial advice. UK tax rules change frequently and individual circumstances vary. Consult a qualified accountant, tax adviser, or HMRC directly for advice specific to your situation. Orbit (listed with HMRC as DrivePro) is built on HMRC's Making Tax Digital for Income Tax API and is completing HMRC's software recognition process; live submissions open once HMRC approves it. It does not provide personalised tax advice.