The Client
This leading UK investment management firm manages a VAT reporting obligation across multiple systems and business lines under HMRC’s Making Tax Digital requirements. Regulatory compliance in tax reporting carries direct financial and reputational risk, making the accuracy, timeliness, and auditability of every VAT submission non-negotiable.
The Challenge
The firm’s VAT reporting process was built on spreadsheets that could no longer satisfy HMRC’s digital record-keeping and API submission requirements under Making Tax Digital. With data spanning multiple systems and filing deadlines leaving no room for manual rework, the existing approach created compounding compliance, accuracy, and audit risk with every reporting cycle.
-
Spreadsheet-Based Reporting Incompatible with MTD Requirements:
UK VAT reporting relied on spreadsheets that did not meet HMRC’s Making Tax Digital (MTD) requirements for digital record-keeping or API submission.
-
Error-Prone Manual Preparation:
Manual VAT preparation introduced the risk of calculation errors and inconsistencies that were difficult to detect before filing and hard to audit.
-
No Digital Record-Keeping or API Submission:
HMRC’s MTD mandate required both digital records and direct API submission, neither of which the existing spreadsheet process could support.
-
Fragmented VAT Data:
VAT data spanned multiple systems with no consolidated, digital view, making accurate preparation dependent on manual aggregation across sources.
-
No Room for Rework:
Regulatory filing deadlines left no tolerance for manual errors or late discovery of data issues, making a reliable, repeatable submission process essential.
The Impact
- 100% MTD compliant.
- Zero Manual filing.
- Full Digital audit trail.
The Solution
Hoonartek built Ab Initio DevFac pipelines to source VAT data from the ERP finance system via secure managed file transfer, consolidating the fragmented data landscape into a single, reliable feed for VAT return preparation. VAT return preparation and API submission to HMRC were fully automated on scheduled runs, replacing the manual spreadsheet process with a straight-through digital workflow that meets all MTD requirements.
Validation controls were embedded directly into the pipeline to catch errors before filing, with independent tax-advisor confirmation added as a governance checkpoint prior to each submission. A full digital audit trail is maintained through Metadata Hub lineage, evidencing every figure from source to submission. The DevFac automated test framework was applied to regression-test submissions, ensuring each release can be validated quickly and consistently. Filings are now in steady-state run, with a reliable, repeatable process that meets HMRC deadlines without manual intervention.
Key Benefits
-
100% MTD Compliance:
Digital records and direct API filing to HMRC fully satisfy Making Tax Digital requirements across all VAT obligations.
-
Automated Submissions:
VAT returns are prepared and filed straight-through on scheduled runs, eliminating manual effort and the risk of errors or missed deadlines.
-
Accurate by Control:
Embedded validation catches errors before filing, with independent tax-advisor sign-off providing an additional governance checkpoint before each submission.
-
Digital Audit Trail:
Metadata Hub lineage evidences every figure from ERP source to HMRC submission, providing the digital record required for regulatory scrutiny.
-
Reliable BAU:
Steady-state run established, filings are repeatable, on schedule, and free of the manual rework that previously created deadline risk.