Tax & Accounting — Automation Lab
Practical case · Tax for Audit

How to build a reusable and verifiable annual tax file

From the permanent client profile to the annual file: documents, tax calculation, tax returns, open points, conclusions and controlled roll-forward.

Tool available · TFA Client File v1.6.0

Separate permanent and annual data

An effective tax file distinguishes information that describes the client permanently — identity, group, regimes, options and controls — from information belonging to a specific year. This avoids rebuilding the same context every year and makes required updates explicit.

Centralised Information Request List

Requested documentation should not live across emails, notes and separate files. A centralised IRL links each document to area, status, owner, deadline, comment and impact on the work. File completion becomes measurable and reviewable.

Tax calculation and tax returns

The working paper should connect materiality, business changes, extraordinary transactions, tax assets, deferred tax, transfer pricing, tax returns and reconciliations. Missing elements remain visible as findings or open requests.

Open points and conclusions

An open point is more than a note. It should state the area, description, status, impact, response received, any adjustment and the conclusion. Commentary mode summarises the work; Analytical mode retains the detail.

Client archive and annual roll-forward

Roll-forward to the new year must be controlled: permanent data and configurations may be carried forward, while prior-year amounts, outcomes and conclusions must not be copied automatically without an explicit decision.

Outputs, limitations and responsibility

The tool produces Excel, PDF, JSON and HTML reports and stores data locally in the browser. It does not replace audit procedures, professional judgement or validation of tax conclusions.