• Statement of Cash Flows Worksheet
  • Using the Statement of Cash Flows Worksheet
  • Naming an analysis item
  • Specifying worksheet settings
  • Setting the view preferences
  • Formatting the worksheet
  • Accessing Working Papers worksheets and dialogs
  • Accessing worksheet sections
  • Configuring tables
  • Specifying table properties
  • Entering data into the tables

Entering data into the tables

The following sections describe how to enter data in a cash flows activity table in the Statement of Cash Flows Worksheet.

Prerequisites

What do you want to do?

• Populating a line using the grouping information
• Typing an input amount and description into a line

Populating a line using the grouping/mapping drop-down

You can use the grouping/mapping drop-down to automatically populate the description and balances in a cash flows activity table line.

Procedure

1. Navigate to the cash flows activity table to be modified.
2. Locate the line to be populated.
3. From the grouping/mapping drop-down, select the group/map number to use.

4. From the property drop-down that now appears to the right of the grouping/mapping drop-down, select the calculation property to use. See Cash flow activity calculation properties for details on these properties.

   

Results

The line's description and balances are automatically populated.

Typing an input amount and description into a line

You can type the description and amounts directly into a line in a cash flow analysis table.

Procedure

1. Navigate to the cash flows activity table to be modified.
2. Locate the line to be populated.
3. From the grouping/mapping drop-down, select None if there is already a group/map number in place.
4. In the line, type the descriptive text and amounts.

Results

The text and amounts that you have provided are included in the analysis table.