Consolidated Statement of Cash Flow Report
Use the Consolidated Statement of Cash Flow Report screen to create a report that shows how changes in balance sheet accounts and income affect cash and cash equivalents for a specified period, consolidated for multiple companies. The report is created using the "indirect" method, which uses net income as a starting point, followed by adjustments that fall under headings for operating, investing, and financing activities. The adjustments are broken down further by cash flow reporting category. Account details can be included in the report if needed. You can print or save this report.
For general ledger accounts to be combined for multiple companies they must have the same account code, name, division, account type, and normal balance. If the companies do not have the same fiscal period dates, the Consolidated Statement of Cash Flow Report may include amounts from different date ranges. For each company selected, ProContractor includes general ledger amounts for each company's fiscal period that ends on the selected period end date.
To open the Consolidated Statement of Cash Flow Report screen, click
in the All Tasks pane.You can control the output of the Consolidated Statement of Cash Flow Report report by entering details in one or more of the following fields on the Options tab:
- Select Format - If you have modified the format and layout of this report on the Modify Reports screen, click
to select the version to use for this report. If you haven't modified the report, this field doesn't appear.
- Company - Click
to select one or more companies for the report. This field is required.
Consolidation Name - Enter the consolidation name to appear in the report header.
Division - Click to select one or more divisions for the report. If no divisions are selected, all divisions appear in the report.
Period End Date - Click to select the fiscal period and year for the report from a filtered list. If you know the period end date you want for the report, you can enter it, click
to select the date from a Date Picker, or click
to enter a Date Formulas. If you want to save the information in the date field when you save the report options, you must use a date formula. If you enter or select a date that is not a period end date, ProContractor clears the field. This field is required.
Include Pending Amounts - Select the checkbox to show both pending and posted activities in the report. Deselect the checkbox to show only posted activities in the report.
- Print By - Click
to select the account information to include in the report. Select Cash Flow Line to show a summary of cash flow for each cash flow reporting category. Select Account to show account detail rows for each cash flow reporting category.
- Print Subaccounts - If you selected to print by account, select the checkbox to group and sort the report by subaccount instead of account.
- Show Division Details - If you selected to print by account, select the checkbox to show the division for each account in the report.
- Print Account Number - If you selected to print by account, select the checkbox to show the account numbers in the report.Tip:
You can use the Modify Reports screen to customize the format and layout of this report.
For more information on running this report, see Run and Print Reports.