Setup & prior-year carryover
Cover · Export · Export Map
Holds file metadata and maps the prior-year Taxprep export. Rollover election workbooks (s. 85(1), s. 85(2), s. 97(2)) carry no prior-year export and open cleanly at Group 2.
TaxWorkbooks Engineering Standard
Every TaxWorkbooks file shares a single structural grammar with zero password locks and no obfuscated logic. Any practitioner who understands one template navigates the rest immediately.
01 · Workbook taxonomy
Workbook separation keeps raw inputs confined to Group 2 while Groups 3 and 4 isolate reconciliation diagnostics and Taxprep export formatting.
Cover · Export · Export Map
Holds file metadata and maps the prior-year Taxprep export. Rollover election workbooks (s. 85(1), s. 85(2), s. 97(2)) carry no prior-year export and open cleanly at Group 2.
Questionnaire · TB · GIFI · Returns
Houses the intake questionnaire, trial balance, GIFI statements (SCH100/125/141), and primary CRA and Revenu Québec schedules.
Checks · Filing Calendar · Variance
Cross-checks balance-sheet continuity, net-income adjustments, CCA pools, and slip totals on one centralized Checks summary.
Import Map · Import · 2-Column Export
Formats validated output under exact Taxprep cell identifiers with plain-text auditability prior to import.
Rates · Notes · GL Map · Disclaimer
Preserves statutory rate tables, structured preparer/reviewer notes, GL-to-GIFI mapping dictionaries, and documented scope boundaries.
02 · Visual cell grammar
Reviewers immediately separate rare manual entries (amber) from computed schedules (blue) and locked comparatives (grey). Role semantics remain identical across the suite.
TWB - InputLight amber fill (#FFF2CC). Reserved strictly for engagement-specific manual entries. In the T2 sample, only 17% (2,638 cells) require input.
TWB - CalculatedSoft blue fill (#D9E1F2). Plain Excel formulas derived from inputs, rate tables, and rollovers (11,359 cells in the T2 workbook).
TWB - Prior YearNeutral grey fill (#E7E7E7). Opening balances and comparative figures loaded from the prior return (1,776 cells in T2).
TWB - TitleDeep forest slate header band (#304747) establishing worksheet identity and filing scope.
TWB - Section HeaderStone section banner (#F4F4F0) delimiting calculation blocks without fragile merged-cell layouts.
TWB - Cross-Sheet LinkDotted forest navigation links tracing cross-sheet totals directly to upstream source schedules.
03 · Complete auditability
Every worksheet ships without password protection or active sheet locks. Calculations use readable native Excel syntax — avoiding opaque wrappers — so a reviewer, audit team, or Microsoft Copilot can inspect every formula back to its source cells. VBA modules for import/export and workbook navigation remain completely open in the Visual Basic Editor.
04 · Built-in diagnostics
Every anomaly bubbles up to a single Checks register. In the T2 workbook alone, 1,180 automated diagnostics verify continuity across schedules prior to export.
Blocking integrity mismatches requiring resolution before Taxprep import: out-of-balance GIFI statements, triggered missing schedules, or broken rollovers.
Review flags highlighting year-over-year variances, unusual zero balances, or approaching statutory thresholds.
Informational completeness confirmations documenting active elections, reconciliation ties, and sign-off status.
Alongside the Checks tab included in every workbook, the T2 workbook carries a dedicated 40-rule .Rules tab specifying layout conventions and structural integrity constraints for reviewers and Microsoft Copilot: 37 static specification rules paired with 3 live Excel-formula assertions.