Your Quarterly MTD IT Workflow: From Spreadsheets to HMRC Submission

The path from now until the 7th of August is predictable. Now, you’re spending time to review and reconcile, and in August you’ll submit. If you master a quarterly rhythm now, the August deadline should feel routine. However, if you get your quarterly workflow wrong now, every quarterly deadline could be chaos.

Here’s a quarterly MTD IT workflow blueprint that you can apply to every quarter (and not just the first one that’s three weeks away), and how our practice management software, BrightManager by Bright, can help.

This blog is part of our series on your MTD IT survival guide: Be ready for the August 7th deadline.

What should accountants have done June for MTD IT readiness?

June was collection month. During this month, you should have issued client data requests. If clients sent over spreadsheets and PDFs, you imported them into your system. If clients uploaded to a portal, you configured the portal and it pulled clean data automatically. Automated data pulling beats email attachments every time. June should also have been compliance verification month, where you confirmed all clients had HMRC-compatible software installed, understood the 7th of August deadline, and knew what data to provide to you by when. This briefing document would’ve ideally been sent to all of you clients by mid-June.

If you haven’t done this preparation work already, there is a soft landing for quarterly updates for just this tax year. So, going into next quarter, this preparation work should ideally be done by mid-September, as it helps prevent panic the following month.

How do I manage the July review and reconciliation phase?

July is validation month. Import quarterly data into your accounting software and run reconciliation checks. Automated systems flag missing invoices, duplicate entries, misclassified expenses, and data errors. Manual reviews take weeks and introduce human error. Integrated workflows complete reconciliation in days. July is also testing month. Run a software test to make sure your software integrates with HMRC. Don’t discover problems in August. Treat July as your practice run to discover and fix any underlying issues. August is then your live run.

For any other readiness gaps you think your firm may be facing, check out our article on common MTD IT readiness gaps (and how to fix them before August).

What happens in the August submission window?

From the 1st of August, shift into submission mode. Practices with integrated workflows file submissions within days. Practices relying on manual workarounds struggle through to get updates submitted. By the 7th of August, all first quarterly updates must be filed. Ideally, aim to send final data requests by the 1st of August. By the 3rd of August, all data should be in your system. The 4th to the 7th of August is your submission window. If you’re still collecting data by the 5th of August, you’re in crisis mode. August is execution, not preparation.

Timeline checkpoint: June to collect + verify → July to review + test → August to submit. Miss a phase, and you’re playing catch-up in August.

How should I communicate this timeline to clients?

Send a brief to all clients that explains:

• Quarterly submission is mandatory the 7th of August

• What date you need data by

• When they’ll hear from you if something’s missing

• When they’ll receive confirmation of quarterly update submitted

Clear milestones prevent surprises and last-minute data scrambles. Include deadlines in the briefing, such as ‘We need your data by the 30th of June, sharp’, ‘You’ll hear from us by the 20th of July if anything is missing’, and ‘Final submission is between the 1st and 7th of August’. Specificity is clarity.

What role does practice management software play in this workflow?

Practice management software automates and keeps you on top of the entire MTD IT timeline. If you set deadline reminders in June deadline, it would’ve triggered and sent data requests to your MTD IT clients automatically. Automated client communication sends briefings, chasing emails, and confirmations without human intervention. The workflow that takes manual practices weeks to coordinate happens automatically in integrated systems. Your team focuses on exceptions, not coordination.

What should I do after the 7th of August to prepare for November?

Document what worked and what failed. Did clients provide data on time? Did your software handle the submission? Did your team have capacity? Were there edge cases or errors? Feedback loops improve the next deadline. November won’t be a surprise if you use August as a learning cycle. Create a post-August debrief, like which processes worked, which didn’t, and what will we change for November. The practices that excel at the November deadline are those that applied lessons from August.

For a more thorough approach to MTD IT, check out the four pillars of MTD IT readiness and our compliance checklist.

Template your quarterly workflow using practice management automation. Automate timelines, eliminate manual coordination, and make your MTD IT quarterly updates routine. For further information, check out BrightManager’s MTD IT features that transform practice management.

This content may have been developed with the assistance of AI tools. Content is reviewed by a member of the Bright team before publication. Guidance on legislation can be obtained from your industry body.