What is a value rule?
A value rule determines how Profit & Loss values are calculated in the Fathom forecast main grid. They comprise the rules, formulas, or methods for ensuring that numbers are presented on the forecast accurately.
In Fathom, value rules can be set on the overall classification, heading, or individual account level. You’ll initially set up the default value rules when you first create your forecast, but these rules can also be edited or changed at any time in the main grid.
Types of value rules
Value rule type
A custom value entered into the forecast grid. This value can come from Excel formulas, other calculation methods, or can simply be a ballpark figure. These are typed into individual value cells.
Link to previous period
Use actuals from last month, last quarter or actuals from the same month last year. Increase / Decrease by a percentage or dollar amount (% / $).
Smart Prediction uses statistical prediction of future values (3/6/12/24 month linear regression) or a rolling average to calculate forecast values. Smart Prediction includes an option for seasonal adjustments when the regression or average is based on 12 or 24 months of data. Using the rolling average to forecast also allows you to incorporate a monthly, quarterly, or yearly increase or decrease into the calculation.
A repeating value that may or may not be increased or decreased at a constant rate each period.
Launches a formula builder to allow you to customise your calculation, and include drivers/other account values.
Link to Budget
The value for this account is directly linked to the budget uploaded to the company settings.
Creating a Value Rule
To create a value rule in the main grid,
💡Pro Tip: To type in a value for a cell, simply double-click on the cell. This will create a direct entry. Then, you can use the 'Tab' option to move to the next cell.
❗Note: Value rules can only be applied to Profit & Loss headings, subheadings, and accounts. Balance Sheet values are set according to timing profiles, journals, and schedules. Any P&L accounts derived from the Balance Sheet (e.g. Interest, depreciation, etc.) will also be calculated according to journals and schedules.
Continue the 'Forecast Creation & Setup Workflow' by choosing from one of the next steps below:
What you want to do:
Where to go next:
Import or create drivers to use as variables in formula value rules
Forecast AR, AP, Unearned/Deferred Revenue, and Prepaid Expenses
Set up taxes and account linkages and your forecast
Set up loans, depreciation, and inventory in your forecast