Completing the Cash Flow Statement
Unlike other areas of the financial statements, the cash flow statement is prepared using the cash flow worksheet. This worksheet is included with GASB Financials and is designed to automate as much of the data collection process as possible. Data that is not directly derived from trial balance information can be manually entered into the worksheet. The default presentation for the worksheet and statement is the direct method. All the work must be done in the worksheet which will automatically update the statement.
The cash flow worksheet is comprised of the following sections:
- Cash flow summary
- Cash flow activities
Cash Flow Summary
A summary section of the different activities within the cash flow worksheet. Enables you to keep track of whether the worksheet/statement is in balance to ending cash. This section is also a breakdown of the cash and cash equivalents components.
Cash Flow Activities
Comprised of the sections that form the cash flow statement including:
- Operating activities
- Investing activities
- Financing activities
- Noncapital financing activities
- Reconciliation of net income to net cash provided by operating activities
- Supplementary information
Each activity section is broken down into smaller activities. The totals to these smaller activities form the line items for the cash flow statement. The worksheet is defaulted to have many activities linked to the grouping, but you can add/remove activities as needed as well as add/remove lines within the activities.
Fundamental Topics
QuickVid
Adding activities
By default each cash flow section has 10 activities that link to the cash flow statement. For example, Operating activities has cash received from customers, cash paid to suppliers, etc. If you need to add new activities follow the steps outlined below:
Procedure- Select the section in the worksheet, i.e. Operating activities, where you would like to add the new activity.
- From the Table Tools tab, in the Operations group, click Insert | Activities.
- Enter the number of activities you would like to insert.
- From the Document Manager, open the Financial Statements and navigate to the Cash Flow Statement.
- Place your cursor in the section of the Cash Flow Statement where you added the activity(ies) in the worksheet.
- From the Table Tools tab, in the Operations group, click Insert| Rows.
- Select the number of rows to insert; this should be the same number of activities you added in the worksheet.
- Click OK.
- From the drop down to the left of the row, select the appropriate activity.
The activity is added to the appropriate section and linked to the Cash Flow Statement.
Adding content to the activities
As discussed, each activity represents a line on the cash flow statement. Many of the activities have been pre-populated based on the grouping and the balances come in from the trial balance. As an example, in operating activity 1, the details that comprise the balance for cash from customers uses the Special Purpose grouping to populate the accounts receivable details.
If you have added to the grouping, or the details don’t come from the trial balance, you can manually add rows as necessary to help complete the balance that needs to appear on the Cash Flow Statement.
Procedure- Select an applicable cash flow activity and then from the Table Tools tab select Insert|Rows.
- Enter the number of rows to add and then click OK.
-
From the far left drop down, select the grouping number if the value is to populate from the trial balance, otherwise type the description and balance necessary.
-
If the balance comes from the trial balance, then iIn the next drop-down, select an appropriate behaviour from the following:
Behaviour Options Description A Use the active period (closing) balance AN Reverse the active period (closing) balance P Use the prior period (opening) balance PN Reverse the prior period (opening) balance D Use the difference between the active and prior period balances DN Reverse the sign of the difference between the active and prior period balances