Variance analysis
Every material variance flagged. Every explanation attached. Every reviewer signed off.
WorkTiles holds the structure of your variance analysis - period-over-period and budget-vs-actual, calculated from the same trial balance driving the rest of the close. Materiality thresholds flag what matters. Comments attach to the line that moved. The close package writes itself.
Balance sheet variance analysis
Explain material movements vs the prior period.
| Month-on-month | Year-on-year | ||||||
|---|---|---|---|---|---|---|---|
| Account | Name | Mar 2026 | Feb 2026 | Δ | Mar 2026 | Mar 2025 | Δ |
| Assets | 232,979,055 | 221,292,326 | +11,686,730 | 232,979,055 | 231,035,422 | +1,943,633 | |
| 1220 | Equipment, accumulated | 9,284,823 | 9,284,823 | 0 0.0% | 9,284,823 | 10,958,860 | -1,674,037 -15.3% |
| 1221 | Equipment, acquisitions | 14,218 | 14,218 | 0 0.0% | 14,218 | 376,827 | -362,608 -96.2% |
| 1229 | Accumulated depreciation, equipment | -6,989,955 | -6,989,955 | 0 0.0% | -6,989,955 | -7,695,160 | +705,206 +9.2% |
| 1230 | Depreciation, current period | -155,118 | -104,699 | -50,419 -48.2% | -155,118 | -237,475 | +82,357 +34.7% |
| 1510 | Accounts receivable | 4,387,219 | 3,902,114 | +485,105 +12.4% | 4,387,219 | 3,712,408 | +674,811 +18.2% |
| 1930 | Operating account, SEB | 6,802,119 | 7,940,326 | -1,138,207 -14.3% | 6,802,119 | 5,118,902 | +1,683,217 +32.9% |
Month-on-month and year-on-year side by side - material variances flagged, explanations attached at the line.
How this flow runs in WorkTiles
- 01
Variances surface from the same trial balance
Period-over-period and budget-vs-actual deltas are calculated from the same numbers driving the rest of the close. No separate workbook, no exports, no version drift.
- 02
Materiality thresholds flag the lines that matter
Set a threshold once - by absolute value, by percentage, or both. Lines that exceed it get flagged automatically. Lines that don't stay quiet.
- 03
Comments attach to the line that moved
When a variance needs an explanation, the comment lives on the line - not in a footnote, not in an email. The next person who opens the period sees what happened and why.
- 04
Reviewers approve the explanation
Variance explanations follow the same approval flow as reconciliations. The reviewer sees the delta, the comment, and signs off. The audit trail captures everything.
- 05
Variance commentary feeds the close package
When the period closes, every flagged variance and every explanation lands in the close package. The board and the auditor see the same story you wrote during the close.
What's different about running it here
Same trial balance, no exports
Variance lives next to the data it explains. When a reconciled balance changes, the variance updates. No re-running a workbook, no chasing the latest version.
Explanations attached to lines
The comment is on the row that moved, not in a separate document. Anyone reviewing the period sees the explanation in context.
Materiality you can defend
Thresholds are explicit, applied uniformly, and visible in the audit trail. The auditor doesn't have to take your word for what was material - they can see it.
Built into the close, not bolted on
Variance analysis isn't a separate phase. It runs alongside reconciliation, with the same approvals, the same evidence model, the same audit trail.
Run finance with less friction.
And more control.
Book a 30-minute demo. We'll show you the close, the recurring work, and how onboarding actually goes.