|
This feature is included with
What is a variance?
Many tools and reports in Fathom calculate and show a variance between two values. A variance could be comparing a KPI result against its target or budget or comparing the value for an account against the corresponding value in a prior period.
An example of variance values can be found in the KPI Results analysis tool:
Variance Calculation Method
Each KPI or account in Fathom has an associated 'Unit of Measure'. The unit of measure determines the variance calculation:
For an account, the unit of measure is always 'Currency', meaning the values will display with the currency symbol. The currency is set in 'Company Profile' in the company's Settings.
KPIs can have units of measure that can include percentages, currency, times, days, ratios or even a custom value.
Variance for currency results
The currency variance result is presented as a percentage change. To calculate the variance for currency amounts:
Variance = (current value - prior period value) / prior period value |
📝 Note: For the above equation, we compare the current period's result to a prior period. If comparing the current result to the budget or target, the target or budget would replace the 'Prior period value' in the equation.
There are a couple of instances when Fathom switches to the 'difference' method and the result is not presented as a percentage change:
If the result or comparison result (e.g. prior period value, target, or budget) is equal to or less than zero.
If the two variables do not have the same sign
Variance for other units of measure (%, times, days, :1, custom)
If the unit of measure is not currency, then the variance is calculated as the difference between the two values.
Variance = current value - prior value |
We do not calculate a percentage variance between percentage values.
Example: If January has a result of 10% and February has a result of 25%, the variance will be calculated as 15%.
Positive and negative variances in financial statements
For financial statements, Fathom uses a mixture of methodologies to decide whether a higher or lower account value is more favourable. The methodology used will depend on the classification of the account.
A favourable result is represented as green and an unfavourable one as red.
📝 Note: For the Statement of Cash Flows, only the 'cash flow approach' is used to determine positive or negative variance.
Cash flow approach
For accounts generally found under operating cashflows, Fathom favours the impact on cash flow when considering the variance for these account classifications.
Using this approach, any negative impacts on cash flow are coloured red and positive impacts on cash flow are coloured green.
Example: An increase in Accounts Receivable, Inventory, or Work in Progress (WIP) is regarded as a negative change and therefore is displayed red. This is because an increase in these results has a negative impact on cash flow for the business.
Business standpoint approach
For accounts that generally appear under investing or financing activities on the cash flow statement, such as Non-current assets or longer-term liability accounts (excluding Accounts Payable), Fathom favours a 'business standpoint' approach.
This approach looks at the overall position of the business, not just cash flow.
Example: While a decrease in accounts under the 'Tax Liability' classification would result in negative cashflows for the business, Fathom recognises this variance as a positive impact (coloured green), as tax liabilities and other long-term liabilities are more likely to incur interest expenses or other penalties at a higher balance or from lack of payment.
📝 Note: For the Statement of Cash Flows, only the 'cash flow approach' is used to determine positive or negative variance.
Positive and negative variances for KPIs
When creating a KPI, Fathom allows you to specify whether a higher or lower result is favourable. This is useful for metrics where a lower value may be more favourable, such as Operating Expenses. The colour of variance results for custom KPIs - green for positive and red for negative - will be based on your selection.
To designate whether a lower or higher result is favourable for a custom KPI: |
|
Turn off variance colours in financial statements and tables
If you prefer variances not to be coloured as either red or green within tables, you can turn off the variance colouring for tables in a report.
To turn variance colours in a table on or off: |
|
Learn more