Why Bank Reconciliation Matters Right Now

You are now two to three weeks into Q2. Income has been coming in, expenses have been going out, and you have been logging them - or at least meaning to. This is the moment when small recording errors start to show up, and if you leave them another six weeks, they become much harder to untangle. Bank reconciliation is the process of checking that what you have recorded in your MTD software matches what actually left or entered your bank account. It sounds simple, but it is where most compliance problems quietly begin.

This post explains how to reconcile your Q2 records properly, what to look for, and what to do when your figures do not match your bank statements. Getting this right now means your Q2 quarterly update - due by 5 November 2026 - will reflect reality rather than guesswork.

What Bank Reconciliation Actually Means for MTD

Bank reconciliation is not a new concept. Accountants have done it for decades. But under Making Tax Digital for Income Tax, it takes on extra weight. The figures you submit in each quarterly update form the basis of your eventual tax bill. If those figures drift from your actual bank activity, you risk underpaying or overpaying tax - and you leave yourself exposed if HMRC ever looks more closely at your records.

The basic principle is this: every income and expense entry in your MTD records should correspond to a real transaction in your bank account. The date, the amount, and the category should all line up.

HMRC does not currently require you to submit bank statements alongside your quarterly updates. But they do require you to keep records that support what you have filed. If your records and your bank tell different stories, that is a problem - even if nobody notices it immediately.

For a fuller picture of what HMRC expects you to keep, see our post on HMRC Record-Keeping Standards for MTD: What You Must Keep.

How to Run a Q2 Bank Reconciliation

Step 1 - Pull Your Bank Statement for 6 July to Today

Start with your bank statement. Download or print every transaction from 6 July up to today. If you use multiple accounts for your business - a current account and a savings account for tax, for example - you need statements for all of them. If income or expenses have gone through a personal account, you need those records too.

Do not rely on your memory or your accounting app alone. The bank statement is the ground truth.

Step 2 - Compare Line by Line Against Your MTD Records

Open your records in AffordableMTD and go through each transaction you have logged since 6 July. For each one, find the matching entry on your bank statement. Check:

Tick off each transaction as you go. Any line on either side that has no match is a discrepancy that needs investigating.

Step 3 - Check Your Opening Position

Before you focus purely on July transactions, it is worth confirming that any late Q1 items have been handled correctly. If an invoice dated in Q1 was paid into your account in July, it belongs in Q1, not Q2. Similarly, an expense you paid in June but recorded in July should sit in Q1.

This is a common source of confusion. The quarter for MTD purposes is determined by when the income was received or the expense was paid, not when you got around to recording it.

If you are unsure how Q1 wrapped up, our post on Final-Week Q1 Reconciliation: Mixed Income Check Before August covers the crossover period in detail.

Note: For cash basis accounting - which most sole traders and landlords use - income is recorded when it is received and expenses when they are paid. This is the date the money moves, not the invoice date.

Common Discrepancies and What Causes Them

Missing Transactions

The most common issue is simply forgetting to record something. A subscription renews automatically, a client pays by bank transfer, or you fill the car with petrol and the receipt goes in the bin. After a few weeks, these gaps add up.

Go through your bank statement and highlight every debit or credit that is not yet in your MTD records. Add them now, with the correct date and category.

Duplicate Entries

If you imported a bank feed and also entered transactions manually, you may have the same item recorded twice. Duplicates inflate your income or expense figures and will throw off your tax position. Look for identical amounts on the same or nearby dates.

Transactions in the Wrong Category

A business meal logged as office supplies. A mileage claim mixed in with fuel costs. A rental deposit treated as income. These errors do not change your bank balance, but they affect which expense categories you are claiming and whether those claims are defensible under HMRC rules.

If you are uncertain which category an expense belongs to, our post on Allowable Expenses for MTD: What You Can Claim as a Sole Trader or Landlord gives a clear breakdown.

Personal and Business Transactions Mixed Together

This is especially common for sole traders who use a single bank account for everything. If a personal purchase has crept into your business records, it needs to come out. If a genuine business expense went through your personal account, it needs to go in - but with a clear note that it was a business cost.

The cleaner your separation between personal and business money, the easier reconciliation becomes. If this is still a problem for you, it is worth reading our earlier post on Q2 MTD Week 1: Get Your Records Right From Today (6 July 2026).

Timing Differences

Sometimes a transaction appears on your bank statement on a different date to when you expected it. A payment sent on a Friday might not clear until Monday. An invoice you sent on 30 June might have been paid on 7 July. These timing differences are normal, but they can cause confusion if you are not careful about which quarter each item belongs to.

Warning: Do not adjust the date of a transaction just to make it fit a quarter more neatly. Record things as they actually happened. Altering dates to manage your tax position - even accidentally - creates records that contradict your bank statements, which is exactly what HMRC looks for when reviewing compliance.

Special Cases for Landlords

Rent Payments That Arrive Late or in Advance

Rental income is received when the money hits your account - not when it was due. If a tenant pays late, the income sits in the quarter when it actually arrives. If a tenant pays two months in advance, both months are income in the quarter they are received, unless you are using accruals basis accounting (which most landlords do not).

This creates reconciliation complications if you are expecting rent on the first of each month but it is arriving on variable dates. Keep a simple log of expected versus actual receipt dates and check it against your bank each month.

Our post on Q2 Rental Income Reconciliation: Managing Deposits and Allowances goes into more detail on the specific complications landlords face in this quarter.

Deposits

Security deposits held in your own account are not income. They are a liability - money you are holding on behalf of the tenant. Do not record them as rental income. If you see a deposit payment on your bank statement and it has crept into your income records, remove it.

Mixed Income Situations

If you are both a sole trader and a landlord, your reconciliation covers two income streams. Keep them clearly separated in your records. Mixing self-employment income with rental income will cause errors in your quarterly updates and may affect how your allowances are calculated.

See our guide on Multiple Income Sources and MTD: Self-Employed and Landlord Together if you are managing both.

What to Do When Your Records Do Not Match

Find the Source of the Difference First

Before changing anything, work out where the gap came from. Is the total in your records higher or lower than your bank? By how much? Knowing the size and direction of the discrepancy helps you search for the cause. A missing expense entry will make your recorded costs lower than your bank debits. A duplicate income entry will make your recorded income higher than your bank credits.

Correct the Record, Not the Bank

Your bank statement cannot be changed. Your MTD records can. Once you have identified the problem, make the correction in AffordableMTD. Add missing transactions, remove duplicates, correct categories, and adjust dates where you have recorded something against the wrong quarter.

If you have already submitted a Q1 update that contained an error, that is a separate process. You can amend a submitted quarterly update - our step-by-step guide at Amending Your Q1 MTD Update Before 7 August: Step-by-Step explains how.

Make a Note of What You Changed and Why

Keep a brief log of any corrections you make during reconciliation. This does not need to be formal - a simple note in a spreadsheet or document is fine. If HMRC ever asks why your Q2 records differ from an earlier draft or estimate, having a clear explanation of your corrections shows you have been careful and transparent.

This is part of what good record-keeping looks like in practice. For more on preparing for potential HMRC enquiries, see After Your Q1 MTD Filing: Prepare Records for HMRC Enquiries.

How Often Should You Reconcile in Q2?

Monthly is the realistic minimum. Weekly is better, especially if your business has a lot of transactions. The more time passes between reconciliations, the harder it becomes to remember what individual transactions were for and whether they belong in your records.

A simple routine works well. At the end of each month - so at the end of July and August, and then again before your Q2 quarterly update deadline in November - spend an hour going through your bank statement line by line against your MTD records. Fix anything that does not match. Save your corrected records.

If you set this up as a recurring calendar reminder now, you will not find yourself doing three months of reconciliation in a panic in late October.

What Good Records Look Like After Reconciliation

After a proper reconciliation, your Q2 records should show:

That is the standard HMRC expects. It is not a high bar, but it does require consistency throughout the quarter - not just a scramble before the deadline.

For a reminder of what supporting records you should be holding on to - receipts, invoices, mileage logs - see our post on Q1 Record-Keeping: What HMRC Actually Needs. The same principles apply to Q2.

Note: AffordableMTD lets you import transactions from a CSV export of your bank statement. This can significantly reduce manual entry errors and makes reconciliation faster. If you have not used this feature yet, it is worth trying for the remainder of Q2.

Keeping It Manageable for the Rest of Q2

The period from now until your Q2 quarterly update deadline on 5 November 2026 is enough time to get this right - if you stay on top of it. The worst outcome is leaving reconciliation until the final days of October and discovering a significant mismatch you cannot explain.

A few practical habits make the rest of Q2 easier:

None of this is complicated. It is just consistency applied over time.

Bringing It Together

Bank reconciliation is the process that keeps your MTD records honest. It is not an extra burden - it is the check that confirms your quarterly update will reflect reality when you come to submit it. At two to three weeks into Q2, discrepancies are still small and easy to fix. The longer you wait, the more they compound. Take an hour this week to compare your records against your bank statements. Correct what needs correcting. Build the habit now and the rest of Q2 looks after itself.

Keep Q2 records clean from the start

AffordableMTD makes it straightforward to import transactions, categorise expenses, and check your figures before you submit. Try it free and see how much easier reconciliation becomes when everything is in one place.

Get Started Free