The Cash Forecasting feature in Edge is designed to help customers gauge their financials based on historical trends on your Profit and Loss statement.
Skip Ahead To
Cash Forecasting: A Definition
Cash Forecasting estimates projected cash flow based on your brand, historical financial performance, and point of sale reports. Actual results will vary based on factors such as increased spending, unexpected one-time inflow/outflow, or higher than normal membership cancellation rates.
What is the Method to Building My Forecast?
Ceterus takes three key figures into account while building your forecast:
- Projected Inflow
- Projected Outflow
- Today's Bank Balance
Only months with closed books will be taken into account. If you've come across an Open Month that you weren't aware of, please contact Ceterus Support.
The result ends up showing your projected balance.
|- Projected Outflow|
The Cash Forecasting feature requires one full closed period of financials for data to populate. If you are a new Ceterus customer, you may not have full access to this feature until the close of your first month's financials.
Where to Find the Cash Forecasting Page in Edge
- Log into Ceterus Edge
- Navigate to the Benchmarks page on the left hand navigation menu
- Choose to view the projected cash flow under the Summary or Detail View
- Summary View: Includes the summary of all locations
- Detail View: Displays details of each projection with locations separated
- Select a projected timeline. This can either be a period of 7 or 30 days starting with today. You can modify your projection by selecting the Projection tab and modifying to reflect your preferred date range.
The Summary view will break down the data into a snapshot between all locations you own. The columns are broken out as follows:
Action to Edit
The Action to Edit is an important feature within this view, as this allows the user to update the beginning bank balance for the calculations. This feature is key to understand if you know there is a large amount of money being deposited or withdrawn from your bank account but hasn’t yet come through.
To adjust your beginning balance, simply click the "Edit" button on the far right of the row you want to alter. Once complete, hit "Save" and your forecast will adjust accordingly
The Detail View will break down the data in a detailed form that will include the accounts the data is coming from. The Detail View will show one location at a time so you will need to select the projection time and location.
The Detail View breaks out the sections as follows:
Accounts data may vary for different concepts
Exporting Cash Forecasting Data
You can download the Detail View’s data by selecting the projection time period and location then selecting the blue download button. This will download the data to your computer in an Excel format.