MTD Record Keeping With Spreadsheets: What Is Allowed

Many sole traders and small landlords have run their books in a spreadsheet for years, and it has worked fine. Making Tax Digital for Income Tax changes what counts as acceptable. You can still use a spreadsheet as part of your records, but it must be connected to HMRC in the right way. This guide explains what a spreadsheet can and cannot do under MTD, and how to set one up sensibly.

Key takeaways

• A spreadsheet can be your digital record, but you cannot submit directly from it without compatible software.
• Bridging software links your spreadsheet to HMRC so you can send quarterly updates.
• Digital links matter: manual re-keying between parts of your records can break the rules.
• A well-structured spreadsheet is far safer than a messy one, but errors are still your responsibility.
• Check the current requirements on GOV.UK before relying on any set-up.

What MTD record keeping means

Under Making Tax Digital, you keep your business records digitally and send updates to HMRC using compatible software. For Income Tax, that means summaries of your income and expenses at set points in the year, followed by an end-of-period statement and final declaration. The records you keep underneath are the same transactions you have always recorded: sales, purchases, mileage and so on. What changes is the format and the way the information reaches HMRC. You can read the official overview on GOV.UK's guidance on using software to send Income Tax updates. To check whether you are in scope, see our guide to MTD for Income Tax eligibility.

Can a spreadsheet be MTD compliant?

Yes, but with a condition. A spreadsheet on its own does not talk to HMRC. To send quarterly updates, you need software that connects to HMRC through its approved route. Bridging software does this: it reads the totals from your spreadsheet and submits them for you. The spreadsheet is then your record, and the bridging tool is the connector.

The wording and detail of the rules on digital links are specific. If your records move between two programs, those transfers should be automatic rather than typed or pasted by hand. Because this area can change, check the current guidance before you rely on any particular workflow.

Setting up a spreadsheet properly

If you decide to stay with a spreadsheet, structure it so it is reliable.

• One row per transaction. Include the date, a description, the amount and a category for each line.
• Separate income and expenses. Use separate sheets or a clear column for each, so totals are easy to read.
• Use consistent categories. Map them to the categories HMRC expects, such as vehicle costs, phone and travel.
• Keep source evidence. Store receipts, invoices and statements digitally, and use a clear file naming system.
• Lock formulas and keep a backup. Protect total cells and save copies regularly.

Our article on bookkeeping service vs doing it yourself helps you decide how much of this you want to run yourself.

Spreadsheet versus accounting software

Worked example (illustrative)

"Marcus", an illustrative example, is a sole-trader courier with a few dozen transactions each month. He keeps one spreadsheet with a sheet for income and a sheet for expenses, uses bridging software to send his quarterly update, and files receipt photos in a folder named by month. Once a month he compares his sheet to his bank statement. His set-up is cheap and manageable.

"Sofia", another illustrative example, has several income streams and hundreds of transactions. She finds the spreadsheet slow and error-prone, and switches to software with a bank feed. Neither choice is wrong. The right one depends on volume, confidence and how much time you want to spend.

Choosing categories that match what HMRC asks for

When you send a quarterly update, you report totals under headings such as turnover and different kinds of expense. If your spreadsheet already uses categories that line up with those headings, producing the totals is straightforward. If your categories are your own invention, you will spend time translating them each quarter, and mistakes creep in. Start by looking at the categories used in the Self Assessment return for sole traders, and set up your columns to match. A drop-down list in the category column stops typos and keeps your totals consistent.

Checking your spreadsheet for errors

Spreadsheets do exactly what you tell them, including the wrong thing. Common problems include a formula that stops one row short of the data, dates stored as text so they sort badly, and a deleted row that silently drops a transaction. Build in a few checks. Add a total of all transactions and compare it with the bank statement each month. Count the rows so you notice if one disappears. Add a simple "check" cell that turns red when the figures do not agree. These small habits take minutes and prevent the kind of error that leads to an incorrect submission.

Our guide to MTD eligibility helps you decide whether you need to be ready now, and the MTD accountant cost article explains what professional help typically involves.

Timing and quarterly updates

Whichever tool you use, the point is to be ready for each quarterly deadline. Keep your sheet current rather than catching up in a rush. Our guide to MTD quarterly update deadlines explains the schedule, and it is worth setting a monthly reminder to update your records well ahead of each one.

Handling receipts and evidence digitally

Digital record keeping is not only about the spreadsheet. The evidence behind each line, such as a fuel receipt, a supplier invoice or a platform earnings statement, should also be stored in a form you can find again. Photograph paper receipts the day you get them, because thermal paper fades. Save them into folders by month and name the files with the date and supplier. Then, if HMRC asks about a particular figure, you can trace it from the spreadsheet row back to the original document in a minute or two. Our guide to how long to keep business records explains how long to hold on to them.

When to move from a spreadsheet to software

There is no shame in starting with a spreadsheet, and no rule that says you must leave it. But some signs suggest that it is time to change. You spend more than an hour or two each month entering transactions. You have found a formula mistake after the fact. You have multiple income sources or more than one bank account to track. You find yourself dreading the quarterly update. Any of these suggests the time cost of the spreadsheet now outweighs its low price. Moving mid-year is possible, but it is easier to switch at the start of a tax year, with a clean opening position and a tidy import of your existing figures.

Whichever you choose, check that the product is listed as compatible with HMRC's requirements, and ask what happens to your data if you stop paying for it. You want to be able to export your records, because you have to keep them for years.

Common mistakes

• Assuming the spreadsheet is enough. You still need compatible software to send the updates.
• Re-typing totals by hand. Manual transfers between programs can cause errors and may not meet the digital link rules.
• Mixing personal and business transactions. It makes your totals unreliable. A separate business account helps.
• Leaving it all until the deadline. Update regularly.
• Not backing up. A corrupted file can cost you your records.

For official wording on record keeping, see GOV.UK's guidance on keeping records for the self-employed.

Unsure whether your spreadsheet will pass muster? Our MTD compliance team can review your set-up and help you choose between a spreadsheet with bridging and full software. You can contact us for a no-pressure chat.