The Threshold Rules that are used for Variance Reporting are set by your organization. Variance Reporting is driven by these rules. The objective is that any account that exceeds the stated threshold rule for the reporting period, requires an explanation.
Waypoint Supports Four Types of Variance Rules:
- Fixed $ Only - Flags all variances over a specified dollar amount (Positive and Negative)
- Fixed % Only - Flags all variances over a specified percentage (Positive and Negative)
- $ AND % - Flags all variances over a specified dollar amount AND a specified percentage (Positive and Negative)
- $ OR % - Flags all variances over a specified dollar amount OR a specified percentage (Positive and Negative)
How do I see the threshold rule for my Property?
On the Variance Reporting Page, any Required Threshold Rule will be displayed next to the property. It is possible for a property to have more than one rule, but most organizations do not have more than one rule per property as part of their workflow. Clicking the Property Name will navigate you to the Property Variance Reporting Page.
On the Property Variance Reporting Page, the threshold rule is shown/reinforced in multiple locations.
Location 1) The bottom of the Report Header
Location 2) By hovering over the "Show Flagged Only" Button
Location 3) Hovering over the Flagged Account Icon
Are All Variances Over the Threshold Flagged?
No! We do not flag sub-totals or grand totals. We only flag the lowest-level accounts.
Example: If "Other Income" a Sub-total for Revenue is over the threshold rule, it will not be flagged, but any base-level account within "Other Income" that is over the threshold will be flagged and require an explanation.