Digital links in VAT record-keeping

Digital links in VAT record-keeping concern how required information moves between parts of the accounting system. Review the complete path from original records to the submitted return and check the permitted linking methods under HMRC’s current guidance.

Manual copying and pasting totals should not be treated as a compliant digital link. A spreadsheet can be part of a suitable system only when the overall records and connections meet the requirements.

Map the complete VAT information path

List the applications and spreadsheets used from initial recording through to the VAT return. Identify which elements form the electronic account and where required data moves between them. Include a bookkeeper's or agent's working system if it receives records for reporting. A diagram of software names alone is insufficient; describe the actual transfer, such as an import file, linked cells or a manual total entered from a report.

HMRC's guidance explains digital links between components of functional compatible software. Electronic transfers can include supported imports and exports or linked spreadsheet cells, while copying and pasting values is not a digital link. The rules also distinguish circumstances involving initial capture and particular adjustments. Assess the real workflow against the guidance rather than claiming that every manual action in bookkeeping is automatically prohibited. ^[1]

Identify breaks in the routine process

Ask the person preparing the return to demonstrate the steps using a completed period. Note where data is retyped, copied or recalculated in another tool. A process description written when the software was installed may no longer reflect how staff work under deadline pressure. Focus on transfers of the relevant data and establish whether each step needs a digital link under the applicable rules.

Pay attention to spreadsheets supplied by branches, sales platforms or advisers. A file can be digital while the movement of its figures into another part of the electronic account is manual. Record the source, destination and method for each handover. This makes it possible to improve the particular connection that is missing instead of replacing an entire accounting system without understanding the actual compliance issue.

Use controlled connections that can be explained

Where an import or export is used, preserve the file format, mapping and reconciliation process. Check that the receiving system interprets dates, tax amounts and signs correctly. A digital link can transmit an error efficiently, so the technical connection still needs accounting controls. Keep a record of the totals before and after transfer and investigate differences rather than assuming that automation guarantees completeness.

For linked spreadsheets, protect the relevant formulas and define which cells users may edit. Avoid a routine in which formulas are replaced with pasted values to make a report look tidy. Keep a version history and review changes to the workbook structure. The person covering the usual bookkeeper should understand how the links work without rebuilding them from memory or introducing an unreviewed manual shortcut.

Document adjustments and exceptions separately

Some VAT calculations may be made outside the main software under the applicable guidance. Identify the adjustment, supporting calculation and how the result enters the VAT records. Do not use the existence of a permitted adjustment as a general justification for manually moving all sales and purchase totals. The review should explain why the particular treatment is appropriate to that part of the process. ^[1]

Keep unusual transactions visible for tax review, even where the data transfer itself is compliant. Property, partial exemption or a correction to an earlier return may require substantive advice beyond the digital-link question. A successful connection between systems does not decide the correct VAT treatment. Separating those questions allows the business to resolve both the technical record path and the underlying calculation without confusing one with the other.

Review the workflow when systems change

Reassess the data path when adding a sales channel, changing accountants or moving to another ledger. Confirm that new integrations preserve the required links and that old manual workarounds have been removed. Ask the provider to demonstrate the supported method rather than relying on a broad marketing claim that the product is 'MTD ready'. The complete combination of tools and procedures is what needs to work.

Use Moving from spreadsheets to accounting software for a migration from spreadsheets and Making Tax Digital readiness review to discuss the VAT record path. Provide a simple list of systems and the way figures move between them. An effective review can then identify the specific link, mapping or adjustment documentation requiring attention, giving the business a practical correction plan rather than an unexplained instruction to buy different software.

Retain one checked example of the full journey with the procedure, using appropriate access controls. Update it when the workflow changes. This provides a useful training reference and helps an adviser understand how the submitted figures connect to the electronic records without requesting unrestricted access to every unrelated business system.

Illustrative scenario

A business records sales in one system and prepares VAT in another. It replaces an undocumented manual totals step with an appropriate digital transfer and keeps the reconciliation supporting the return.

Preparation checklist

• Map the full data path
• Identify manual transfers
• Check permitted links
• Retain reconciliation evidence