Balance Sheet - Forecast
The Balance Sheet - Forecast workbook presents a full-year balance sheet statement broken down by month, combining actual results for completed periods with forecast values for the months still ahead. It gives you a forward-looking view of your financial position across Assets, Liabilities, and Equity for the entire fiscal year in a single report.
Selection page
When you open the workbook, the Selection Page appears before the workbook loads. You can also click the Selection Page sheet at any time to update your parameters directly.
- Fiscal Year
- Fiscal Period
- Company
- Department
- Cost Center
Balance Sheet
The report includes four summary columns on the left, followed by a column for each month of the fiscal year. Months up to the selected period show Actual values, while the remaining months show Forecast values.
- Full Year Actual: total actual balance of each account across all posted periods in the fiscal year.
- Full Year Actual + Forecast: combined view of actual results to date and forecast amounts for the remaining months.
- Full Year Forecast: total forecasted balance of each account for the full fiscal year.
- Variance: difference between the Full Year Actual and the Full Year Forecast.
Mapping
The balance sheet is organized into sections such as Current Assets, Fixed Assets, Liabilities, and Equity. Each section is linked to an Account Grouping that determines which accounts appear in that section and how totals are calculated. Two mapping tables control this structure. Two mapping tables control this structure. In most cases, these tables should not be modified. Changes are typically only required if your Sage 200 account structure differs from the default setup or if accounts are appearing in the wrong section.
The first table defines the main balance sheet sections and is refreshed manually when account group assignments change in Sage 200.
| Accounts Grouping Description | Account Grouping |
|---|---|
| Current Assets | KPI_CURRENT_ASSETS |
| Fixed Asset | KPI_FIXED_ASSET |
| Current Liabilities | KPI_CURRENT_LIABILITIES |
| Long-Term Liabilities | KPI_LONG_TERM_LIABILITIES |
| Equity | KPI_EQUITY |
The second table controls which accounts are extracted and feeds the balance sheet dynamically. Update this table if specific account groupings need to be added or adjusted.
| Accounts Grouping Description | Account Grouping |
|---|---|
| Accrued Expenses | KPI_ACCRUED_EXPENSES |
| Amortisation | KPI_AMORTISATION |
| Accounts Payable | KPI_AP |
| Accounts Receivable | KPI_AR |
| Assets | KPI_ASSETS |