Cash Flow
The Cash Flow workbook presents a standard cash flow statement that explains how your cash balance changed over a selected period. It groups activity into the usual sections (Operating, Investing, and Financing) and shows results period-to-date and year-to-date.
Selection page
When you open the workbook, the Selection Page appears. It lets you choose what you want to see before the cash flow report loads. The Run As Date and Reporting Book fields are required (shown in grey) and must be completed before you can confirm. All other filters are optional and help you narrow the results.
- Run As Date – (mandatory) the "as of" date for the cash flow.
- Reporting Book – (mandatory) the primary reporting book used for cash flow amounts.
- Adjustment Book
- Location – (required for multi-currency) select a single location to avoid mixing currencies.
- Department
- Project
- Customer
- Product Line
- Class
Cash Flow
The report shows cash movement for the period you selected, with two main 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 shows the key dates and settings it used to generate the Cash Flow (as-of date, comparison periods, books, and any filters). Review these values to make sure they match your selection. If something looks incorrect, return to the Selection Page, adjust your choices, and open the workbook again. Only the blue cells can be edited and all other values come from the selection page.
| Report 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, the workbook combines the Reporting Book and Adjustment Book results into a single set of cash flow amounts. |
| Statistical Accounts | Controls whether statistical (non-financial) accounts are included. These accounts don't represent GL transactions and often store quantities or other operational values used for reporting. Options: Exclude (default), Include, Only. |
For each dimension filter (Location, Department, Project, etc.), you can choose whether to include sub-dimensions. Turn this on when you want the selection to include all child values under the dimension you chose (for example, a parent department and all of its sub-departments). If a dimension doesn't show a sub-dimension toggle, it means there is no hierarchy available for that dimension in Sage Intacct.
Mapping
The Cash Flow is organized into sections and line items (Net Income, working capital changes, capital expenditures, financing activity, and beginning/ending cash). Each line is linked to a Sage Intacct Account Group, which determines which accounts are included and how totals are calculated. You typically update this mapping only if your Intacct Account Groups are different from the default setup, or if you notice accounts showing up in the wrong place.
| 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 |