How to Set Up a Record-Keeping System for MTD Quarterly Updates

Why Your Record-Keeping System Matters Before You File

Most people think about record keeping when the quarterly update deadline is looming. That's the wrong time. By then, receipts are missing, bank transactions are a blur, and you're guessing at figures you should know. The better approach is to set up a simple system at the start of each quarter - before a single pound comes in or goes out. This guide walks you through exactly how to do that, in plain steps, whether you're a sole trader, freelancer, or landlord with no accounting background.

A good record-keeping system for MTD does two things: it makes your quarterly updates quick to prepare, and it makes the final declaration at the end of the tax year far less painful. Both depend on the same foundation - organised records from day one of each quarter.

Step 1: Understand What You're Actually Collecting

Before you set anything up, it helps to know what records MTD actually needs from you. For each quarterly update, HMRC wants to see:

• Your total income for that quarter (broken down by source if you have both self-employment and property income)
• Your allowable expenses for that quarter, categorised correctly

That's it for the quarterly update itself. The full list of what goes into a quarterly update is shorter than most people expect. You are not filing a full tax return every three months - just a summary of income and expenses. The detail behind those figures is what your records need to support.

For the final declaration at the end of the year, you will also need figures for things like pension contributions, Gift Aid donations, and any other income sources (such as employment income or savings interest). More on that later.

Step 2: Choose Where You'll Store Your Records

You need one place where everything lives. Not three folders on your desktop, not a pile of receipts in a drawer, and not a mix of photos on your phone and emails in your inbox. One place.

Your options are roughly:

• A spreadsheet - works well if you're comfortable with basic formulas. Free, flexible, and easy to export as a CSV for uploading to MTD software.
• A folder system on your computer or cloud storage - useful for storing receipt images and documents, but you'll still need somewhere to log the figures.
• MTD bridging software with built-in expense tracking - lets you log income and expenses directly, import bank transactions, and file your quarterly update from the same place. This removes the need for a separate spreadsheet.

Whatever you choose, the key is consistency. You will use this same system every quarter. If you're using a spreadsheet, keep a separate tab for each quarter. If you're using software, create a clear folder or label for each period.

If you haven't chosen your MTD software yet, the guide to choosing MTD software covers what to look for depending on your income type.

Step 3: Set Up Your Income Categories

MTD splits income by source. You need to track yours the same way.

If you're a sole trader or freelancer

You have one income category: self-employment income. Every payment you receive from clients or customers goes here. Log each payment with:

• The date you received it
• The amount
• Who paid you (client name or reference)
• What it was for (brief description)

If you have multiple self-employed businesses - for example, you do both photography and tutoring - each one is treated separately in MTD. You'll need a separate income log for each. See how MTD handles multiple self-employment businesses for more detail.

If you're a landlord

Your income is rental income from property. Log each payment received with the date, property address, tenant name, and amount. If you have more than one rental property, keep a row per payment and note which property it relates to. You may also receive other income connected to the property - such as charges for parking or storage - which usually counts as rental income too.

If you have both self-employment income and rental income, you need separate logs for each. They are reported separately in MTD. The guide to mixed income MTD explains which expenses belong where.

Step 4: Set Up Your Expense Categories

This is where most people get confused. MTD uses specific expense categories, and putting costs in the wrong category is one of the most common mistakes filers make. Getting this right from the start saves a lot of correction later.

Common sole trader expense categories

• Office costs (stationery, printer ink, postage)
• Travel and subsistence (fuel, train fares, accommodation for business trips)
• Clothing (uniforms or protective gear only - not ordinary clothing)
• Staff costs (wages, subcontractors)
• Resale stock or materials
• Legal and financial costs (accountant fees, business insurance)
• Marketing and advertising
• Training directly related to your current trade
• Premises costs (rent for business premises, utilities if applicable)
• Phone and internet (business proportion)

For a fuller breakdown of what you can and cannot claim, see self-employed business expenses in MTD.

Common landlord expense categories

• Repairs and maintenance (fixing things, not improving them)
• Letting agent fees
• Buildings and contents insurance
• Mortgage interest (subject to restrictions - this is a relief, not an expense)
• Ground rent and service charges
• Utility bills (if you pay them on the tenant's behalf)
• Accountant or legal fees related to the rental
• Cleaning between tenancies

For more on what landlords can claim, see what counts as a landlord expense in MTD. The distinction between repairs and capital improvements catches a lot of landlords out - the guide to repairs vs capital works explains the difference clearly.

Mixed-use expenses

Some expenses are partly business, partly personal - your home broadband, your mobile phone, your car. You can only claim the business proportion. Decide the split at the start of the quarter and apply it consistently. The guide to mixed-use expenses shows how to work this out.

Step 5: Build a Simple Weekly Habit

The single biggest reason people end up with messy records at deadline time is that they leave everything to the last few days of the quarter. The fix is simple: spend 10-15 minutes once a week keeping your records current.

Here's a basic weekly routine:

1. Log any income received that week (date, amount, source).
2. Log any business expenses paid that week (date, amount, category, what it was for).
3. Save or photograph any receipts and store them in your designated folder.
4. Check your bank statement matches what you've logged. If something doesn't match, investigate it now, not at the end of the quarter.

That weekly check is your main safeguard. It keeps your records accurate and means you're never more than a week behind.

If you receive a large or unusual payment - a late invoice from a client, a one-off repair bill from a contractor - log it the same day rather than waiting for the weekly review. Large items are the ones most likely to be forgotten or miscategorised if left.

Step 6: Keep Supporting Evidence

HMRC may ask you to substantiate any figure in your quarterly update or final declaration. That means you need more than a spreadsheet entry - you need the evidence behind it.

For every expense, keep:

• The receipt or invoice (a photo on your phone is fine, as long as it's legible and stored somewhere you can find it)
• Proof of payment (a bank statement entry is usually sufficient)

For income, keep:

• Invoices you've raised (for self-employed work)
• Rental statements or rent schedules (for landlords)
• Bank statements showing the payments received

Organise supporting documents by quarter - a folder labelled "Q1 April-June 2026" with subfolders for income and expenses works well. The guide to backup records for MTD covers this in more detail, including how long you need to keep everything.

Step 7: Prepare a Simple End-of-Quarter Checklist

Before you file each quarterly update, run through a short checklist to make sure your records are complete and accurate. Build this into your system from the start, so it becomes routine.

At the end of each quarter, check:

• Have you logged all income received during the quarter?
• Have you logged all business expenses paid during the quarter?
• Does your income log match your bank statement deposits?
• Does your expense log match your bank statement outgoings (for business accounts) or your annotated personal bank statement?
• Have you accounted for any cash payments (income or expenses)?
• Are all receipts and invoices saved and filed?
• Are any mixed-use expenses correctly split?
• Are mileage claims logged with dates, destinations, and business purpose? (See mileage allowances for MTD.)

Once you're satisfied, you're ready to file. The step-by-step guide to submitting your quarterly update walks through the filing process itself.

Step 8: Keep One Eye on the Final Declaration

Quarterly updates are not the end of the story. At the end of the tax year, you also need to complete a final declaration - this is where you confirm your figures, add any income not covered by quarterly updates (such as employment income or bank interest), and claim any allowances or reliefs.

The records you keep throughout the year feed directly into this. If your quarterly records are clean and complete, the final declaration becomes a straightforward check rather than a scramble. If they're not, you'll be trying to reconstruct months of transactions at the end of the year.

Start a separate running note from the beginning of the tax year for anything that affects the final declaration but doesn't appear in your quarterly updates:

• Pension contributions (personal contributions outside of your employer, if any)
• Gift Aid donations
• Bank interest or savings income
• Dividends (if you have investments)
• Employment income from a PAYE job (if you also have one)
• Student loan repayment details

For a full list of what you'll need to gather, see preparing for your MTD final declaration.

Step 9: Review and Improve After Each Quarter

After you've filed your first quarterly update, take 15 minutes to ask yourself: what was harder than it needed to be? Were there expense categories you weren't sure about? Did you lose any receipts? Was there income you almost forgot?

The guide to organising records between quarters has practical suggestions for what to fix before the next quarter starts. Small improvements after each quarter add up quickly.

If you made mistakes in your first quarterly update, it's worth knowing what's fixable and what isn't. The guide to amending a quarterly update after the deadline explains your options.

What a Good System Actually Looks Like in Practice

To make this concrete: here's a minimal but effective setup for a sole trader freelancer with no accounting background.

• A single spreadsheet with one tab per quarter, each with columns for: date, description, income amount, expense amount, expense category.
• A folder on Google Drive (or equivalent) labelled by tax year, with subfolders per quarter, containing photos of receipts and downloaded invoices.
• A note (phone or paper) for tracking mileage as each business journey happens.
• A 10-minute weekly slot - same day each week - to log that week's transactions.
• MTD bridging software for importing the spreadsheet and filing the quarterly update when the deadline approaches.

That's it. Nothing complicated. The goal is not an elaborate system - it's a consistent one.

If you'd prefer to skip the spreadsheet entirely, AffordableMTD lets you log income and expenses directly in the software, import transactions via CSV, and use AI categorisation to sort expenses into the right MTD categories automatically. The CSV import and AI categorisation guide explains how that works in practice.

Summary

A record-keeping system for MTD doesn't need to be complicated. It needs to be consistent. Decide where records will live, set up income and expense categories that match what MTD expects, build a weekly habit of logging transactions, keep supporting evidence, and run a short checklist before each quarterly update. Do that from the start of each quarter, and both your quarterly updates and your final declaration become a matter of checking and confirming - not hunting and guessing.