TaxWorkbooks Engineering Standard

The technical standard behind every workbook

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.

Tab groups
5 (1 → 5)
Cell style roles
6 · TWB - *
T2 / T5013 checks
1,180 / 199
T2 .Rules tab
40 (37 + 3)

01 · Workbook taxonomy

Five numbered tab groups, in the same order every time

Workbook separation keeps raw inputs confined to Group 2 while Groups 3 and 4 isolate reconciliation diagnostics and Taxprep export formatting.

1

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.

2

Source data & core schedules

Questionnaire · TB · GIFI · Returns

Houses the intake questionnaire, trial balance, GIFI statements (SCH100/125/141), and primary CRA and Revenu Québec schedules.

3

Summary, reconciliations & audit trail

Checks · Filing Calendar · Variance

Cross-checks balance-sheet continuity, net-income adjustments, CCA pools, and slip totals on one centralized Checks summary.

4

Mapping & software import

Import Map · Import · 2-Column Export

Formats validated output under exact Taxprep cell identifiers with plain-text auditability prior to import.

5

Rates, notes & governance

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

Six named TWB - * styles identify every cell’s role on sight

Reviewers immediately separate rare manual entries (amber) from computed schedules (blue) and locked comparatives (grey). Role semantics remain identical across the suite.

TWB - Input

Light amber fill (#FFF2CC). Reserved strictly for engagement-specific manual entries. In the T2 sample, only 17% (2,638 cells) require input.

TWB - Calculated

Soft blue fill (#D9E1F2). Plain Excel formulas derived from inputs, rate tables, and rollovers (11,359 cells in the T2 workbook).

TWB - Prior Year

Neutral grey fill (#E7E7E7). Opening balances and comparative figures loaded from the prior return (1,776 cells in T2).

TWB - Title

Deep forest slate header band (#304747) establishing worksheet identity and filing scope.

TWB - Section Header

Stone section banner (#F4F4F0) delimiting calculation blocks without fragile merged-cell layouts.

TWB - Cross-Sheet Link

Dotted forest navigation links tracing cross-sheet totals directly to upstream source schedules.

03 · Complete auditability

Glass-box engineering: unlocked formulas & open VBA

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

Three-tier ERROR / WARN / INFO validation

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.

ERROR

667 T2 checks

Blocking integrity mismatches requiring resolution before Taxprep import: out-of-balance GIFI statements, triggered missing schedules, or broken rollovers.

WARN

513 T2 checks

Review flags highlighting year-over-year variances, unusual zero balances, or approaching statutory thresholds.

INFO

0 T2 checks

Informational completeness confirmations documenting active elections, reconciliation ties, and sign-off status.

The T2 .Rules machine-readable contract

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.

40T2 .Rules total
37Static rules
3Formula assertions