Skip to main content

Top Tip for Forecasting

See how your forecast decisions are impacting cash flow

Updated this week

Forecasting is included with Fathom Pro - the plan with access to all of Fathom's features. Companies on Portfolio can be upgraded to Fathom Pro at any time.

How is your cash forecast calculated?

The Balance Sheet Layer Detail lets you see the impacts of your forecasting decisions on a specific balance sheet account, like your main cash account.

It's similar to a direct cash flow statement. For each month of the forecast, it shows:

  • The account's opening balance
    ​

  • Profit & Loss movements impacting the account and their amounts
    ​

  • Balance Sheet movements (journals & schedules) impacting the account and their amounts
    ​

  • The account's closing balance

Our Top Forecasting Tip

🥇Our Top Tip:

The Magnifying Glass icon on the Balance Sheet reveals the movements impacting a chosen account, such as a cash account.

To view the Balance Sheet Layer Detail for an account:

  1. Select the Telescope icon from the left sidebar in your forecast
    ​
    ​

  2. Go to the Balance Sheet
    ​
    ​

  3. Click on a date cell for an account

    1. If you have microforecasts active on the account, ensure you select a date cell for the account's baseline
      ​
      ​

  4. Select the Magnifying Glass icon in the menu on the right

You will see how the value rules, timing profiles, and journals & schedules you set up are hitting the chosen account.

You can click on a cell in the Balance Sheet Layer Detail to see more details on how a movement is calculated.

Add a Balance Sheet Layer Detail table to a report to show all the movements hitting your Cash & Equivalents accounts, including the movements from microforecasts.

💡 Smart Tip: Want to audit more of the movements in your forecast? See our 'Audit a forecast' article.

Learn more

Did this answer your question?