Spreadsheet bridging
Figures copied out of the accounts into a spreadsheet, then bridged into HMRC — every manual hop is a chance for the return to drift from the ledger.
A VAT return in DataFlow follows one path: reconcile the VAT journal, check EC Sales and Intrastats where they apply, submit the nine-box VAT 100 to HMRC under Making Tax Digital, then store the receipt and record the payment. Each step squares against the ledger before you move on.
If the VAT figures live outside the ledger, every quarter turns into a rebuild — and a risk.
Figures copied out of the accounts into a spreadsheet, then bridged into HMRC — every manual hop is a chance for the return to drift from the ledger.
Tallying the VAT control accounts against the return by hand is slow, and it is never quite clear whether the numbers agree until the afternoon is gone.
Without the obligations in front of you, a period slips — and a late or missed submission is exactly the kind of avoidable exposure MTD was meant to close.
When HMRC queries a return months later, there is no stored copy of the exact figures or the submission receipt, so you rebuild the whole quarter from memory to answer them.
The return is a review of the ledger, not a reconstruction of it.

VAT control accounts reconciled to the VAT due for the period. The return is built from ledger figures, not a spreadsheet.

EC Sales Lists and Intrastat declarations are separate submissions. They are not part of the Making Tax Digital return.

Open HMRC obligations loaded and matched to your closed DataFlow VAT period. The nine-box VAT 100 shown for review, then submitted.

HMRC receipt number stored against the period for audit. HMRC payment recorded in the Cash Book when the bank settles.
Automating our finance and reporting routines saves us in the region of ten days of work every month.
Filing a VAT return is one of the workflows built straight from the ledger — explore the other capabilities that lead into it.
The VAT period closes at the end of the ordered month-end sequence, leaving the return ready to reconcile and file.
Explore moduleEvery sales invoice posts debtors, sales and VAT together, so the VAT behind the return is already in the control accounts.
Explore moduleThe HMRC payment you record in the Cash Book reconciles against the bank like any other, once it settles.
Explore moduleEach company files its own VAT return from its own ledger, while the group still runs on one shared installation.
Explore moduleNo. In this workflow Making Tax Digital covers the VAT return only. EC Sales Lists and Intrastat declarations are separate submissions handled on their own, where they apply to you — they are not part of the MTD return.
The nine-box VAT 100. The MTD Submission window loads your open HMRC obligations, matches your closed DataFlow VAT period and shows the nine-box VAT 100 for you to review before you Submit.
You reconcile the VAT journal for the period first, so the VAT control accounts agree with the VAT due before you file. The return is built from ledger figures rather than a spreadsheet.
HMRC returns a receipt number that is stored against the period for audit. When the bank settles the HMRC payment, you record it in the Cash Book.
Thank you
Your request has been received.