Cash Flow
The Cash Flow workbook presents a standard cash flow statement that shows how your cash balance changed over a selected period. Activity is grouped into the three standard sections: Operating, Investing, and Financing, with results shown both period-to-date and year-to-date.
Selection page
When you open the workbook, the Selection Page appears before the report loads. Run As Date and Reporting Book are required fields and must be completed before you can proceed. All other filters are optional and help you narrow the results.
- Run As Date – the "as of" date for the cash flow.(required)
- Reporting Book – the primary reporting book used for cash flow amounts. (required)
- Adjustment Book
- Location – select a single location to avoid mixing currencies. (required for multi-currency)
- Department
- Project
- Customer
- Product Line
- Class
Cash Flow
The report shows cash movement for the selected period across two columns.
- Period to Date Actual: net cash movement from the start of the period up to the Run As Date.
- Year to Date Actual: net cash movement from the start of the fiscal year up to the Run As Date.
Parameters and mapping
Parameters
The workbook displays the key dates and settings used to generate the cash flow statement, including the as-of date, books, and any active filters. Review these values to confirm they match your selection. If something looks incorrect, return to the Selection Page, adjust your choices, and reopen the workbook. Only blue cells are editable. All other values come directly from the selection page.
| Setting | Description |
|---|---|
| Reporting Book | The main book used to calculate cash flow amounts. Set on the selection page. |
| Adjustment Book | Optional adjustment book. Set on the selection page. |
| Combine Reporting and Adjustment | When enabled, combines the Reporting Book and Adjustment Book into a single set of cash flow amounts. |
| Statistical Accounts | Controls whether statistical accounts are included. These accounts store non-financial values such as quantities and do not represent GL transactions. Options: Exclude (default), Include, Only. |
For each dimension filter such as Location, Department, or Project, you can choose whether to include sub-dimensions. Enable this option when you want the selection to cover all child values under the selected dimension, for example a parent department and all of its sub-departments. If a sub-dimension toggle is not available, it means no hierarchy exists for that dimension in Sage Intacct.
Mapping
The cash flow statement is organized into sections and line items covering net income, working capital changes, capital expenditures, financing activity, and beginning and ending cash balances. Each line is linked to a Sage Intacct Account Group, which determines which accounts are included and how totals are calculated. You typically only need to update this mapping if your Intacct account groups differ from the default setup, or if accounts are appearing in the wrong section.
| Report Section | Account Group |
|---|---|
| Net Income / (Loss) | 117 |
| Depreciation | |
| Amortization | |
| Stock-based Compensation | |
| Changes in Accounts Receivable | 40 |
| Changes in Allowance for Doubtful Accounts | 34 |
| Change in Inventory | 32 |
| Changes in Prepaid Expenses and Other Assets | 31 |
| Changes to Accounts Payable | 30 |
| Changes to Sales and Used Tax Payable | |
| Changes to Accrued Liabilities and Other Liabilities | 28 |
| Changes to Accrued Income Taxes Liabilities | |
| Changes de Deferred Income Taxes Assets | |
| Change to Deferred Revenue | 25 |
| Changes to Intercompany Receivable | 24 |
| Changes to Intercompany Payable | 23 |
| Capital Expenditures | 20 |
| Net sales (purchases) of ST investements | |
| Purchase of long term investments and other assets | 18 |
| Investment in Subsidiary | |
| Changes in Debt Proceeds | 15 |
| Changes in Capital Stock | 14 |
| Cash at Beginning | 224 |
| Cash at End | 223 |