A spreadsheet with a row for every quarter
There is a sheet, usually called VAT tracker, with a row per client and columns for each quarter. Someone fills in the dates when a client joins. Some clients are on the March stagger, some on April, some on May, a few file monthly and one or two are on annual accounting.
It works until something changes. A client moves to monthly returns for cash flow reasons. Another deregisters. A new client's first period is irregular. The sheet does not know, and the next deadline is read from a row that is wrong.
Why VAT tracking breaks in a firm
The real obligations sit with HMRC and change when the client or HMRC changes them. The firm keeps a copy, and copies drift. The ledger holds a third version in its own VAT settings. When three sources disagree, people trust the one they happen to open.
Workload is the other half. With a spread of staggers, the busy weeks are predictable in principle, but only if someone lays every return against the person doing it. A single bookkeeper can end up with most of one stagger, which nobody notices until the week arrives.
What a missed or rushed VAT return costs
Late returns can bring penalties for the client and awkward conversations for you. Rushed returns carry more risk of errors. Clients who pay by direct debit are caught out when the figure appears later than expected. And each near miss makes the firm more cautious, which usually means more checking of the spreadsheet rather than fixing the source.
| Source | What it knows | Why it drifts |
|---|---|---|
| HMRC obligations | The actual periods and due dates | Nobody reads it routinely |
| Ledger VAT settings | Scheme and period for the return | Set up once, rarely checked |
| Firm spreadsheet | Who is doing it and status | Updated by hand |
How we build a VAT deadline view
- For clients where you act as agent, we read open VAT obligations through HMRC's Making Tax Digital interface, so periods and due dates come from the source.
- We compare them with each client's VAT settings in Xero or QuickBooks and with your practice records, and flag any mismatch, such as a stagger that differs or a period the ledger does not expect.
- Each obligation is linked to the assigned bookkeeper and reviewer from your practice tool.
- Status is read from the ledger: period reconciled, return drafted, submitted. Staff do not tick boxes to say what the system can see.
- A weekly load view shows returns due per person over the coming months, so you can move a client before a pile-up rather than during it.
- Reminders go to the bookkeeper and, where you want it, a short note goes to the client with the date and what you still need from them.
The view reports dates and status. It does not decide how a client should account for VAT; that stays with you and the client's adviser.
First periods for new clients and final periods for clients who deregister are the awkward cases, so they get their own flag. Those are the returns most often missed, because they do not follow the pattern everyone is used to.
Deadlines you can see coming
Nobody maintains the VAT tracker any more, because it maintains itself. Changes of frequency or scheme show up as a mismatch the week they happen. Managers can balance returns across the team months ahead. Bookkeepers see their own list for the week with what is ready and what is waiting, and the last-minute scramble becomes rare instead of routine.
Is your VAT tracking fragile?
- VAT dates live in a spreadsheet someone updates by hand.
- You have been caught out by a client changing frequency or stagger.
- One person ends up with most of the returns in one week.
- Status is known by asking, not by looking.
- Clients sometimes ask you when their return is due.