These interactive spreadsheets allow the user to record budgeted and forecast figures for the specified financial year. These figures can then be used in CCTE for comparison reporting.
When Budgets and Forecasts area is expanded the spreadsheets and associated reports will be revealed.
It is recommended that the user works with an accountant to set up the figures in Budgets and Forecasts in order to successfully use this area.
Enter Figures
This area of the spreadsheet is where budget/forecast figures are recorded. The spreadsheet is divided into three tabs:
- Actuals (read only - figures are not entered here)
- Budget
- Forecast
Budget and Forecast Sheets
Click on the Enter Figures folder then select the default folder to open the window where figures can be entered.
Each sheet has a list of the Cashbook accounts available and the months contained within the year of the selected date range.
To use the sheet, click inside the cell where the account and month align and enter the figure.
Do not type symbols, (i.e. $). Each sheet may be printed when complete.
Actuals Sheet
The Actual figures for the specified range can be produced by clicking the Set Actuals button. The Actual accounting balances for the selected months are retrieved.
To exit this area, click the X on the lower CCTE screen.
Actuals/Budget/Forecast
These three individual spreadsheets are read only reports (of the Enter Figures spreadsheets). To print these reports click on the Headers button on the toolbar.
Each report can also be converted into an Excel spreadsheet using the Save As button.
Budgets: Quarters 1 to 4
Each of these sheets provides a comparison between the actual and budgeted figures for the three months of the quarter.
Forecast: Quarters 1 to 4
Each of these sheets provides a comparison between the actual and forecast figures for the three months of the quarter.