Cash Flow - Forecast
The Cash Flow - Forecast workbook presents a full-year cash flow statement broken down by month, combining actual results for completed periods with forecast values for the months still ahead. It covers Operating Activities, Investing Activities, and Financing Activities, and gives you a forward-looking view of how cash is expected to move through the rest of the fiscal year.
Selection page
When you open the workbook, the Selection Page appears before the workbook loads. Fiscal Year and Fiscal Period are required fields and must be completed before you can proceed. You can also click the Selection Page sheet at any time to update your parameters directly.
- Fiscal Year – the fiscal year for the cash flow statement. (required)
- Fiscal Period – the period used as the cutoff between actuals and forecast. (required)
- Company
- Department
- Cost Center
Cash Flow
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 cash movements 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 cash movements for the full fiscal year.
- Variance: difference between Full Year Actual and Full Year Forecast.
Mapping
The cash flow statement is organized into sections covering operating, investing, and financing activity. Each Report Section is linked to a Report Code that determines which accounts are included and how totals are calculated. 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 cash flow sections and is refreshed manually when code assignments change in Sage 200.
| Report Section | Report Code |
|---|---|
| Accounts Receivable | KPI_AR |
| Inventory | KPI_INVENTORY |
| Other Current Asset | KPI_OTHER_CURRENT_ASSET |
| Amortisation | KPI_ANORTISATION |
| Accounts Payable | KPI_AP |
| Other Current Liabilities | KPI_OTHER_CURRENT_LIABILITIES |
| Fixed Asset | KPI_FIXED_ASSET |
| Other Assets | KPI_OTHER_ASSET |
| Long-Term Liabilities | KPI_LONG_TERM_LIABILITIES |
| Liabilities | KPI_LIABILITIES |
| Equity | KPI_EQUITY |
| Cash | KPI_CASH |
| Sales Revenue | KPI_REVENUE |
| Other Revenues | KPI_OTHER_REVENUE |
| Cost of Sales | KPI_COGS |
| Other Income and Expense | KPI_SUSP |
| Operating Expenses | KPI_OPERATING_EXPENSES |
| Fixed Charges | KPI_FIXED_CHARGES |
| Amortisation | KPI_AMORTISATION |
| Interest Expenses | KPI_INTEREST_EXPENSES |
The second table controls which report codes are extracted and feeds the cash flow dynamically. Update this table if specific account groupings need to be added or adjusted.
| Report Section | Report Code |
|---|---|
| Tax Payables | KPI_TAX_PAYABLE |
| Other Income and Expense | KPI_SUSP |
| Sales Return and Allowances | KPI_SRET |
| Discount | KPI_SDISC |
| Revenue | KPI_REVENUE |