|
How timing profiles forecast the Balance Sheet
In Fathom, most Balance Sheet movements are forecasted from the Profit & Loss through timing profiles.
Timing profiles decide when and how much of a Profit & Loss value is allocated to Cash, Accounts Receivable, Accounts Payable, Deferred or Unearned Revenue, or Prepaid Expenses.
Example: A restaurant collects all revenue immediately from its patrons. A timing profile set to 100% of the revenue collected in the same month would indicate that 100% of the revenue should be deposited into the selected Cash account on the Balance Sheet in the same month it is recorded on the Profit & Loss.
Timing profiles enable you to make changes to Profit & Loss figures and immediately see the impact on the Balance Sheet without needing to create or redo several journals.
See how a timing profile works
You can see exactly how a timing profile forecasts the Balance Sheet by viewing the timing profile preview.
The preview will show you the:
|
Access the timing profile preview
To see the timing profile preview:
|
If there is a consumption or sales tax at play on the Profit & Loss account, then the amounts going toward sales tax liability will also be recorded if you have configured your Tax Settings.
💡Smart Tip: To see how the value for a Balance Sheet account was calculated, you can also view the 'Balance Sheet layer detail'.
Choose the impacted Balance Sheet accounts
Unless otherwise specified, the Profit & Loss amounts will hit the default Balance Sheet accounts set in the Forecast Settings.
You can change the Balance Sheet accounts impacted by an individual Profit & Loss account.
Example: A business pays the majority of expenses out of its 'Checking 1' account, but its 'Software Expenses' are paid from the 'Checking 2' account. For the 'Software Expenses' account, the account linkages are set up so the expense is paid from the 'Checking 2' account.
To change the account linkages for a Profit & Loss account:
|
You can choose a Balance Sheet account for each of the linkages:
Account Linkage | Type of account you might select... |
Pre-payments
|
|
Accrued Payments
|
|
Cash / final posting
|
📝 Note: Funds originally diverted to the selected Pre-payments and/or Accrued Payments accounts will eventually end up in this Balance Sheet account. |
In the settings, a chain icon is displayed next to each account linkage type.
If the chain icon is broken, the timing profile is set so the selected Balance Sheet account will not be impacted by the Profit & Loss. If the chain icon is intact, the selected Balance Sheet account will be impacted by the Profit & Loss values.
📝 Note: Want to forecast inventory? See our Forecast Inventory article.
What is the payment cadence?
Timing profiles can be set according to the following timing types:
Timing Type | When it might be used... |
Monthly
|
An art gallery and print shop offers extended payment options for some of its more expensive pieces. On average, approximately 90% of the Revenue from sales is received immediately from customers, while about 10% is paid over the next two months.
|
Bi-monthly (every two months)
|
A company pays the city for rubbish or garbage collection every two months.
A bi-monthly timing profile can be set so the Profit & Loss expense for the two months is paid all at once. |
Quarterly
|
A company pays its accountant for services once every quarter and recognises that expense on the Profit & Loss over all three months of the quarter.
A quarterly timing profile can be set so the Profit & Loss expense for 3 months is paid all at once.
|
Bi-annually (every 6 months)
|
A landscaping company receives payments from its larger customers for 6 months of work at a time.
A bi-annual timing profile can be set so the entire Revenue amount for the 6 months of work is received in one payment.
|
Annually
|
A company makes a one-time payment to use a software for an entire year.
An annual timing profile can be set so the Profit & Loss expense for the 12 months is paid all at once.
|
When you start a forecast with the Quick Start option, all timing profiles are set to a monthly cadence with 100% received/paid in the same month.
This means that all Revenue is forecasted to be received as Cash in the same month the Revenue is recorded, and all Expenses are paid in Cash the same month they’re recorded on the Profit & Loss.
You can easily change this by editing the existing timing profiles or applying new ones.
Set or edit a timing profile
Timing profiles can be set at the classification, heading, or individual account level on the Profit & Loss.
Example: A business pays most of its Office Expenses the same month they’re recorded on the Profit & Loss. They set a timing profile on the ‘Office Expenses’ heading in their Chart of Accounts for 100% of the expenses to be paid in the same month.
However, they have a deal with a cleaning company that offers a discount if they pay for three months of cleaning services at once. On the individual ‘Cleaning services’ account, they set a quarterly timing profile to reflect these payment terms.
To set up timing profiles quickly, you can apply one timing profile to a classification that the majority of accounts will use. Then, for any outlier accounts, override the classification's timing profile by creating a new profile for that account or heading.
📝 Note: When you set a timing profile for a heading, the profile will be applied to all accounts underneath that heading. The profile will not be applied to the heading itself.
How to create or edit timing profiles
To set a new or edit an existing timing profile:
|
When you create or edit a timing profile, you have the option to Add a note. You can type a brief note explaining the assumptions behind your choice of profile.
The assumptions note can be seen by others working on the forecast, so they understand why the timing profile was chosen. You can also opt to include the note in a report on the forecast, allowing stakeholders to understand and have confidence in the forecast.
Create new or edit existing? Choose the right option.
When changing a timing profile, you have the options of New profile or Edit existing profile. When you hover over the edit option, you’ll see cells on the Profit & Loss highlighted in light green.
If you edit the profile, you’ll edit it for all of the highlighted cells. If you only want to change the profile for a specific account, heading, or timeframe, click the New profile option instead of editing the existing profile.
Examples of how to forecast with timing profiles
Forecast Revenue received or Expenses paid as Cash is the same month
You may want to forecast:
|
In this case, you would:
|
If you want the amounts to go to or come from a different Cash account, you can change the selected Cash/final position account.
Forecast Unearned / Deferred Revenue or Prepaid Expenses
You may want to forecast:
|
Example (Monthly): You expect 50% of the Expense to be paid 1 month before it is recorded on the Profit & Loss and 50% to be paid the same month it is recorded on the Profit & Loss. For 1 month prior, you would type in 50%. For the same month, you would type in 50%. The month before the Profit & Loss amount is recorded, 50% of that amount will be sent to Unearned/Deferred Revenue.
Example (Non-monthly):
To forecast funds as Unearned/Deferred Revenue or Prepaid Expenses:
|
Your timing profile preview would then include funds going to Unearned/Deferred Revenue or Prepaid Expenses, depending on the month for which you're viewing the preview. Here is an example:
If you want the amounts to go to different Pre-payment or Cash/Final posting accounts on the Balance Sheet, you can change the selected accounts.
Forecast Accounts Receivable or Accounts Payable
You may want to forecast:
|
To forecast funds as Accounts Receivable or Accounts Payable:
|
Your timing profile preview would then include funds going to Accounts Receivable or Accounts Payable before hitting the Cash or Final Posting account, like these:
If you want the amounts to go to different Accrued Payments or Cash/Final posting accounts on the Balance Sheet, you can change the selected accounts.
Common Questions
Can you have multiple timing profiles on an account?
You can have different timing profiles on the same account at different times. This is useful if you want to forecast a future change in payment terms.
When you select a cell to apply a timing profile, that cell is the start date of the profile. Therefore, you can change the timing profile on an account for any period in the future.
Example: Your business is experiencing difficulties with its cash flow. You are renegotiating with one of your suppliers to pay half of the material cost 1 month after receiving the materials, rather than paying it all in the same month. This change will go into effect at the start of the next calendar year.
You go to the start of the next calendar year for the appropriate Cost of Sales account and set a new timing profile to reflect the upcoming change in payment terms.
It is not possible to have multiple timing profiles active simultaneously without the use of microforecasts and/or future accounts. To better understand those workarounds, you can see an example here.
How are actual or existing AR and AP amounts treated in the forecast?
You may have existing Accounts Receivable and Accounts Payable in your actuals. Those will be incorporated into the forecast, largely based on the timing profiles you choose. You can read more about the drawdown methodology in our ‘AR/AP Drawdown’ article.
How can I check to make sure a timing profile is working correctly?
The timing profile preview will show you how a timing profile is expected to work. You can also view the 'Balance Sheet Layer Detail' to see how a Balance Sheet account's balance is calculated in your forecast.
For additional ways to audit your forecast, see our ‘Audit your forecast’ article.
Next steps
🎉 Congratulations on taking a significant step in forecasting the baseline for your Balance Sheet!
To finish forecasting your Balance Sheet, set up journals and schedules:
Learn more