Q2 Is Here: Fix Your Messy Records Now Before November

It's late September or early October. Your Q2 quarterly update deadline is 7 November. And if you're honest with yourself, your records are a mess. Maybe you've been meaning to sort them since August. Maybe you had a busy summer. Maybe you just didn't get around to it. Whatever the reason, you now have a few weeks to turn a pile of bank statements, vague notes, and half-remembered receipts into something you can actually file with HMRC. This guide is not about starting fresh or building a perfect system. It's about fixing what you have, fast, and getting to "good enough" before the deadline.

Step One: Do a Quick Audit Before You Touch Anything

Before you start sorting anything, spend 20 minutes working out what you actually have and what's missing. Trying to fix records without knowing the gaps first is how people waste hours going in circles.

Open a blank document or grab a piece of paper. Answer these four questions:

1. Do you have a complete record of income for Q2 (6 July to 5 October)? This means every payment you received for your work or rental income, not just what's sitting in your bank.
2. Do you have bank or card statements covering the full quarter? Online banking usually lets you download these as PDFs or CSVs going back months. Do this now if you haven't.
3. Do you have receipts or invoices for your main business expenses? You don't need every coffee receipt, but anything significant should have some kind of backup.
4. Have you mixed personal and business spending in the same account? If yes, flag it - you'll need to work through that account line by line.

This audit isn't about making you feel bad. It's about knowing what you're working with. Once you know what's there and what isn't, you can stop worrying about the unknown and start working through the actual list.

The Fastest Way to Categorise Transactions You've Neglected

This is usually the biggest job. You've got weeks of bank transactions sitting there uncategorised. Here's how to get through them without redoing everything from scratch.

Start with your bank CSV, not your memory

Download your bank statement as a CSV file (a plain spreadsheet file that most banks offer). Do not try to work from PDFs or paper statements if you can avoid it - they're harder to sort and easier to lose track of.

Once you have the CSV, open it in a spreadsheet and add a simple column called "Category". Your goal is to work through every transaction and mark it as one of three things:

• Business income - money that came in from clients or tenants
• Business expense - money that went out for your work or property
• Personal - ignore these for MTD purposes

Don't overthink the expense categories at first pass. Just get everything sorted into those three buckets. You can refine the categories afterwards.

Use AI categorisation if your software supports it

Affordable MTD lets you import a CSV and use AI to suggest categories for your transactions. This is much faster than doing it manually. The AI won't get everything right, but it gets the routine stuff right quickly - regular suppliers, utilities, subscriptions - and flags the uncertain ones for you to decide. See the CSV import and AI categorisation guide for how to format your file correctly before uploading.

Batch similar transactions together

If you have 12 months of Amazon purchases and you're trying to work out whether each one was business or personal, don't do them one by one. Sort the spreadsheet by description, find all the Amazon rows together, and deal with them as a group. Same for fuel, postage, software subscriptions, and anything else that repeats.

Don't go back and rebuild what you already filed

If you filed Q1 (covering 6 April to 5 July), leave those records alone. You're only fixing Q2 records now. Mixing the two up will cause confusion and won't help your November filing. If you think you made errors in Q1, that's a separate issue - see whether to amend your Q2 quarterly update after filing.

What "Good Enough" Actually Means for HMRC

This is where a lot of people waste time: trying to make their records perfect when HMRC doesn't require perfection. Here's what actually matters.

Your income figures need to be accurate

There's very little wiggle room on income. Every payment you received for your business or rental income during Q2 needs to be included. If you're unsure whether something counts, check what qualifies as income for MTD. Understating income - even accidentally - is the thing most likely to cause problems later.

Your expense categories need to be reasonable, not forensic

HMRC's MTD quarterly update doesn't ask for a transaction-by-transaction breakdown. It asks for totals in broad categories - things like "office costs", "travel", "repairs and maintenance". That means as long as your expenses are in roughly the right buckets and add up correctly, you're compliant. You don't need a receipt for every £3 purchase.

What you do need is to be able to explain large or unusual expenses if asked. A £2,000 equipment purchase needs a receipt. A £4 parking fee does not. See what proof HMRC actually needs for expenses for a sensible breakdown.

Estimate where you genuinely have no record

If you paid cash for something and have no receipt, and the expense was genuinely for your business, you can still claim it - but you need to make a reasonable estimate and note your reasoning. Don't claim things you can't justify at all. But don't skip legitimate expenses just because you've lost the receipt. What sole traders actually need to keep explains this more clearly.

Mixed personal and business accounts

If you've been running business and personal spending through the same bank account, you need to work through it line by line. There's no shortcut here. But you only need to do it once for Q2. Every business expense on that account is still claimable - it just requires more manual work to separate. Once Q2 is filed, seriously consider opening a dedicated business account for Q3. It makes everything simpler.

Handling Specific Problem Areas Quickly

Missing invoices from clients

If a client paid you but you can't find the original invoice, use the bank statement as your primary record. The payment is the evidence. You can recreate an invoice number retroactively for your own records if needed, but the bank transaction is what matters for HMRC. See how to handle late receipts and missing invoices for guidance on which quarter they go in.

Rental income with deposits or irregular payments

Deposits are not income - they're liabilities until a deduction is made. If a tenant paid a deposit in Q2, don't include it as rental income. Regular rent payments go in as income in the quarter they were received. For more detail on landlord-specific issues, Q2 rental income reconciliation covers this clearly.

Mileage you forgot to log

If you use simplified mileage rates for your vehicle (which most sole traders do), and you haven't logged your business mileage properly, you'll need to reconstruct it from diaries, calendar appointments, or maps. An estimate based on reasonable evidence is acceptable. A completely invented number is not. See how mileage allowances work in MTD.

Home working expenses

If you work from home and haven't claimed anything for it, you may be missing a straightforward deduction. You can use HMRC's flat rate (£10 a month for 25-50 hours worked from home, £18 for 51-100 hours and £26 for 101 hours or more) without needing to calculate exact proportions. Grey-area MTD expenses covers home working and other common uncertain areas.

Getting Your Numbers into MTD Format

Once you've categorised your transactions, you need to turn them into totals that match the categories HMRC expects in your quarterly update. This means adding up all your expenses by category and your total income figure for Q2.

If you're using a spreadsheet, this usually means a SUMIF formula or just manually totalling each category. If you're using Affordable MTD, the software will do this for you once your transactions are categorised.

The detailed guide to calculating your quarterly update numbers from bank statements walks through exactly how to go from raw transactions to the figures you actually submit. It's worth following this closely to avoid putting numbers in the wrong boxes.

Before you file, run a quick bank reconciliation - cross-check your categorised totals against your actual bank balance. If the numbers don't tally, something has been missed or doubled up. Reconciling your bank account before filing explains how to do this without it becoming a multi-hour job.

A Simple System to Stop Q3 Becoming the Same Mess

The best time to set up a sensible system is right after you've suffered through fixing a bad one. Q3 runs from 6 October to 5 January, with a filing deadline of 7 February. You have time to make it easier.

Here's the minimum that actually works:

• Download your bank statement once a week. It takes two minutes. Doing it weekly means you're never staring at 13 weeks of transactions at once.
• Photograph receipts the same day you spend. Your phone camera is fine. Keep them in a single folder - either a physical folder or a folder on your phone. Don't sort them yet, just capture them.
• Set a 15-minute slot once a week to categorise. Friday afternoon or Monday morning works well for most people. 15 minutes on 13 transactions is manageable. 3 hours on 250 transactions is not.
• Keep income and expense separate from the start. Even in a simple spreadsheet, two separate tabs for income and expenses prevents confusion later.

If you want a more structured version of this, the Q2 record-keeping weekly system is worth reading after you've filed your November update - it's designed specifically for people who've already learned this lesson the hard way.

What If You Miss the 7 November Deadline?

For 2026-27, HMRC won't issue penalty points for late quarterly updates, so missing 7 November 2026 won't cost you a point or a fine. That said, it's not a reason to be relaxed about it - you still have to file, and from 2027-28 points accumulate, with a £200 penalty at 4 points. See what happens if you miss an MTD deadline for the full picture.

If you genuinely cannot get your records in order before 7 November, file what you have rather than nothing. An imperfect submission is better than a missed one. You can amend your quarterly update after submission if you discover errors later.

Pulling It Together

You don't need perfect records to meet your 7 November deadline. You need complete income figures, reasonably categorised expenses, and totals that match what your bank statements show. Start with an honest audit of what you have. Use your bank CSV as the backbone. Batch and categorise transactions in groups rather than one by one. Lean on AI categorisation tools if your software supports them. Estimate where you have no alternative, but document your reasoning. And once you've filed, use the discomfort of this experience to set up something simpler for Q3 - even 15 minutes a week will mean you never face this scramble again.