Statement of Financial Position - Forecast
This version of the balance sheet give you the ability to see the picture of the entire year by showing the actual in the previous month and the budget data (Forecast) in the future month to get an expected total for the year.
The month selected in the "Selection page" will be used as the cut-off month to define the actual versus the forecast.
Key metrics at a glance:
- Full Year Actual: This column shows the Total Acutal for the entire Year.
- Full Year Forecast: This column shows the Total Forecasted for the entire Year.
- Full Year Actual + Forecast: This column show the Total of the Forecast + Actual. All the values before the current period will be Actuals and all the other period will be Forecast value. The total of both will give a more real prevision for the entire year.
- Full Year Variance: This column show the variance between the Forecast and Actual value.
- YYYY-MM Actual/Forcast: All the YYYY-MM column will display the Actual or Forecast depending
Mapping and Filtering
Mapping
The following mapping needs to be changed accordingly in the "Mapping" Sheet of each reports
| Report Section | Account Group |
|---|---|
| Cash & Cash Equivalents | 1333 |
| Investments | 1503 |
| Accounts Receivable (Net) | 1293 |
| Inventory | 1335 |
| Fixed Assets (Net) | 1500 |
| Other Assets | 1501 |
| Short-term Liabilities | 1253 |
| Long-term Liabilities | 1256 |
| Other Liabilities | 1306 |
| Net Assets | 1219 |
| Operating Revenue | 1249 |
| Expenditures | 1438 |
Filtering
Selection Page:
- Company (Tenant ID)
- Year
- Month
- Parent Fund
- Fund
- Book
- Department
- Projects