| name | variance-analysis-setting-thresholds |
| description | Sub-skill of variance-analysis: Setting Thresholds (+2). |
| version | 1.0.0 |
| category | business |
| type | reference |
| scripts_exempt | true |
Setting Thresholds (+2)
Setting Thresholds
Materiality thresholds determine which variances require investigation and narrative explanation. Set thresholds based on:
- Financial statement materiality: Typically 1-5% of a key benchmark (revenue, total assets, net income)
- Line item size: Larger line items warrant lower percentage thresholds
- Volatility: More volatile line items may need higher thresholds to avoid noise
- Management attention: What level of variance would change a decision?
Recommended Threshold Framework
| Comparison Type | Dollar Threshold | Percentage Threshold | Trigger |
|---|
| Actual vs Budget | Organization-specific | 10% | Either exceeded |
| Actual vs Prior Period | Organization-specific | 15% | Either exceeded |
| Actual vs Forecast | Organization-specific | 5% | Either exceeded |
| Sequential (MoM) | Organization-specific | 20% | Either exceeded |
Set dollar thresholds based on your organization's size. Common practice: 0.5%-1% of revenue for income statement items.
Investigation Priority
When multiple variances exceed thresholds, prioritize investigation by:
- Largest absolute dollar variance — biggest P&L impact
- Largest percentage variance — may indicate process issue or error
- Unexpected direction — variance opposite to trend or expectation
- New variance — item that was on track and is now off
- Cumulative/trending variance — growing each period