InnovataxAI Global Group · Consolidated Tax Provision

How the workbook flows

Every solid arrow is a real cross-sheet formula link, read straight from the built workbook; the dashed arrows on the far left are the external source files the import macros read. Source data enters on the left; it calculates rightward through the schedules and lands in the Note Disclosure. Click any sheet to trace its lineage: by default you see its immediate neighbours, and the trace-depth controls widen that to the second and third rings.

External source file (imported)

Data / machine layer (tables in)

Calculation & presentation (ranges out)

Final disclosure

Click a sheet to trace

Trace depth Downstream (feeds) 1st 2nd 3rd+ Upstream (fed by) 1st 2nd 3rd+ Immediate neighbours only by default; tick 2nd or 3rd+ to widen a trace.

The provision flows in eight stages, fed by two external files.

The tax package and financial statements workbooks arrive as files; the import macros land their data in the source tables and the financial input, which feed the financial statements and the support schedules (CCA, financing fees, losses, reserves).

Those cross into the book–tax bridge (Book-Tax Adjustments → Schedule 1), which splits two ways: current tax through CIT Consol, and temporary differences through the four DIT schedules into DIT Consol.

CIT and DIT converge on the Rate Reconciliation, Journal Entries, and the Note Disclosure — the page a head of tax reads first.

Entity_Config and the mapping tables feed many sheets; their links stay off by default and light only when you click the reference node itself. Review_Checks reads across the whole book and isn't drawn here.

Reference & mapping — used across many sheets

These carry the entity roster, chart-of-accounts mapping, and adjustment codes. Nearly every calculation sheet reads them, so their links stay hidden to keep the flow legible — click a reference tile to light just its own links and consumers.

Control & audit — outside the calc flow

Cover and Control are the operator surface; Automation_Log records macro runs; Named_Range_Map is the automation contract; Review_Checks ties the whole workbook (65 checks).

Generated from synthetic_tax_provision_demo.xlsx · 64 sheets · solid arrows = live formula references · dashed left arrows = declared import feeds