Cash Flow
The Cash Flow workbook presents a standard cash flow statement for a selected fiscal period, showing how cash moved in and out of the business across Operating Activities, Investing Activities, and Financing Activities. It displays actual cash movements and summarizes the net change in cash for the period, ending with the Cash at End balance.
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 "as of" date for the report. (required)
- Company
- Department
- Cost Center
Cash Flow
The report shows actual cash movements for the selected period, organized into the three standard sections of a cash flow statement. The report closes with the Net Increase (Decrease) in Cash and Cash Equivalents, the beginning Cash balance, and the Cash at End of the period.
- Operating Activities: cash generated or used by the core business operations, starting from net income and adjusting for working capital changes.
- Investing Activities: cash used for or received from capital expenditures and long-term investments.
- Financing Activities: cash flows related to debt, equity, and other financing transactions.
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 |
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 |