Report and source mappings
The reporting model linked figure occurrences in Word to their approved workbook sources, original values and display conventions.
RepDate · Controlled financial reporting
Recurring Word reports meant carrying approved Excel figures across tables and coordinating checks across versions. RepDate connected the figures, source evidence and independent review decisions, with the team estimating around 70% less repetitive preparation time.
The challenge
What we built
The recurring Word report and approved Excel workbook belong to the same cycle. Confirmed figure mappings connect them; new or changed mappings require separate verification before use.
Each mapped report occurrence links to the original workbook value, source range and display basis. Material movements, source exceptions and failed reconciliations enter focused review.
Source confirmation, commentary and preparation decisions stay with the entry. An eligible checker independently inspects the work; the last editor cannot clear their own change.
A clean Word report, tracked redline and Excel review workbook provide connected views of the reporting cycle. Output fidelity and final release requirements remain specific to the report family.
How we delivered it
The reporting model linked figure occurrences in Word to their approved workbook sources, original values and display conventions.
The workspace brought material movements and source exceptions into review, required separate verification for changed mappings and reopened affected checks after edits.
Clean Word reports, tracked redlines and Excel review workbooks provided distinct views of the same reporting cycle. Output fidelity and release requirements remain specific to the report family.
Impact
Team-estimated reduction in repetitive workbook-to-report preparation, including mapped updates and review preparation.
A clean Word report, tracked Word redline and Excel review workbook stay connected to the same reporting cycle.
Preparation and checking remain distinct. The last person to change an entry cannot independently clear their own work.
The preparation-time reduction is an approximate estimate reported by the Dotnitron team. Output views and independent checking describe the delivered workflow; actual preparation effort depends on the report family and review requirements.
Approved values had to be carried into report tables, with mappings and display conventions checked around the update.
Confirmed mappings connect workbook values to their report occurrences, with original values and displayed precision available to inspect.
Reviewers returned to source workbooks and separate notes to understand movements or differences.
Material movements, source exceptions and failed reconciliations are brought into focused review with the supporting evidence beside the figure.
Source confirmation and reviewer decisions had to be coordinated across people and report versions.
Preparation and checking remain separate, with named decisions retained. Overrides and content edits reopen the relevant downstream work for review.
The readable report, change comparison and review evidence served different needs and could become separated.
A clean report, tracked redline and review workbook provide three connected views of the reporting cycle.
The control model distinguishes unresolved, prepared, checked and approved states. Material open items, failed reconciliations and unresolved commentary remain visible; output fidelity and final release requirements are confirmed for the report family.
The figure. The source. The decision. Source values, displayed precision, material movements and the review record stay connected to the reporting cycle.
What remained with the team
Approved workbook values remain the numerical source. Preparation, independent checking and report approval have distinct responsibilities. Output availability, fidelity and release requirements are confirmed for the report family during setup; final report-release transitions remain part of V1 completion.
About this project
Approved workbook values supply the figures. RepDate connects their report occurrences to the original values, source locations and display basis. Optional AI assistance cannot calculate figures, approve work or advance review states.
The workbook location, original value, surrounding source range, displayed precision, period movement, exceptions and retained review decisions stay available for inspection.
The last person to change an entry cannot independently clear it. New or changed mappings require separate verification, and overrides or content edits reopen the relevant downstream review work.
The reporting cycle provides a clean Word report, a tracked Word redline and an Excel review workbook. Output availability and fidelity are confirmed for the report family; final release-state transitions remain part of V1 completion.
Yes. AI availability and provider configuration are controlled by the organisation, and assistance can be switched off for the reporting cycle. Source tracing, preparation and independent checking remain the core workflow.
Have something in mind?