How to Create a Cash Flow Statement

Cash flow statement

Create cash flow report

Cash flow analysis

Report sets cash flow

Generate cash flow report

Create a statement of cash flows

A cash flow statement tracks the movement of cash in and out of a business across operating, investing, and financing activities. To build a cash flow statement, do the following:

1. Navigate to Reports.

2. Click the New icon, and then select Dynamic Report.

3. Select Financial as the Reporting Area, and then click OK.

4. Set up the report structure:

   1. Drag and drop the Company dimension to the Page axis. This allows filtering using specific entities.

   2. Drag and drop the Account dimension to the Row axis. This allows pulling data from specific general ledgers containing cash flow data. Cash flow statements generally include three key sections: Cash from Operations, Investing, and Financing activities. However, this structure varies based on the general ledger configuration in the organization.

   3. Drag and drop the Time dimension to the Column axis. This allows selecting the time period (year, quarter, or month) for which the cash flow statement is needed.
      

5. Click the Show Header & Footer icon to configure headers for the cash flow statement, and then click OK.
   

6. Click the Run icon and preview the statement.
   

7. Click the Save icon to store the report for future use.

Using Reports Sets to Create a Cash Flow Statement

Organizations define row report sets for cash flow statements to speed up the reporting process. To use a row report set, drag and drop the relevant report set to the Row axis.

In the example below, Cash Flow Detailed Rowset is a predefined row used to generate cash flow statements for different companies and time periods based on requirements. Click here to learn more about creating report sets.