You are here: Help Topics > Engagements > Accounts and balances > Cash Flow worksheet

Cash Flow worksheet

Use this worksheet to post cash flow balances. This worksheet only displays accounts that are not automatically updated from the Balance Sheet or Income Statement accounts.

To access the Cash Flow worksheet, on the ribbon, click Account | Trial Balance. In the Trial Balance, click the Cash Flow tab. To display hidden columns, right-click a column header and click Reorder Columns.

Note: To use cash flow settings for CaseView cash flow reports, you must enable the Client in CaseView option found on the CaseView ribbon under Tools | Options.

Column Description
Entity Select the entity where the account belongs. This column only displays in consolidated files.
Account No

Displays the Statement of Cash Flow account number as defined in the Report worksheet.

Click ... to split-up an account.

Name

Enter an account description to display on the Trial Balance, general ledger, draft financial statements, and all working paper documents that display the account. Click ... to enter an extended account description.

Lock Select to prevent changes to transactions, adjusting entries, account balances, and properties. Users can only create unrecorded adjusting entries using the account.
Map No

Select the applicable map number for the account. Entering a map number automatically completes the account's properties according to the characteristics assigned to the map number.

Type The type of financial statement where the account will display. In the Cash Flow worksheet, the type is always Statement of Cash Flow (S).
Sign Select whether the account is typically a Credit or Debit balance.
L/S

Represents the leadsheet number where the account and amount display. You can assign Statement of Cash Flow accounts to leadsheets and group numbers in the Grouping worksheet.

Tax Export Code

Select a tax export code to assign to the account.

M3 Code (USA only) Select an M3 code to assign to the account.
GIFI (Canada only)

Select a GIFI code to assign to the account.

Tax Entity Displays the tax entity assigned to the consolidated entity. You cannot modify this column directly, however you can change a consolidated entity's tax entity from the Entity Properties | Settings.
Class Displays the ratio class used for calculating financial ratios, conducting analytical review, and preparing the schedule of unadjusted errors (if applicable).
Opening Balance Enter the opening balance for the Statement of Cash Flow accounts.
Transactions

Displays the transaction amounts for year-to-date period balances or year-to-date other entries depending on the settings in the Engagement Properties.

Double-click a transaction to view the period breakdown.

Adjustments

Displays the total adjustments that will be used when calculating the final balance. You can change these balances by posting a Statement of Cash Flow type entry.

Double-click an adjustment to view all the adjustments, including those making up previous balances.

Final Displays the final balance after calculating all adjustments for that period.

Prior Year 1-4

Enter the prior year balance (for up to the last 4 years) if the file has a single period or is set to yearly. For multiple period files, press F9 to display all prior periods.

Double-click a prior year column to see any applicable adjusting entries.

Budget Year 1-5

Enter the budget balance (for up to the next 5 years) if the file has a single period or is set to yearly. For multiple period files, press F9 to display all budget periods.

Annotation Displays annotations for the account or line. Hover your cursor over an annotation for more information.

Tax Code

Select a tax code to assign to the account. Assigned tax codes are used for journals and adjusting entries. The account tax code overrides the tax code chosen for the journal.

You can create new tax codes from Tools | Options | Tax Codes or by clicking Customize...in the Adjusting Entries or Other Entries worksheets.

Map No Description Displays the name of the map number assigned to the account.
Map No (Flip)

Select the applicable map number to use if the account is flipped. Entering a map number (flip) automatically completes the account's L/S (flip) and Group 2-10 (flip) fields. If the account already has a map number assigned, the existing properties take precedence over the auto-fill values from the flip.

Map No (Flip) Description Displays the name of the flip map number assigned to the account.
L/S (Flip) Select a leadsheet number where you want to display the account and amount if it is flipped.
Group 2-10 Select a group number from the applicable grouping in order to display the account on the grouping schedule. You can also assign group numbers from the Groupings worksheet.
Group 2-10 (Flip)

Select a group number from the applicable grouping in order to display the account on the grouping schedule when it is flipped.

Forecast Year 1-5

Displays the forecast balance for each account (for up to the next 5 years).

Baseline Displays the baseline number to use with forecast balances.
CS (Credit Statement of Cash Flow)

Options in this column vary depending on the selection in the Type column.

If you've set the Type column to Balance Sheet or Income Statement:

  • The CS column represents a Statement of Cash Flow account number (account number format: S##). With this Statement of Cash Flow number intact, all credit amounts for the Balance Sheet or Income Statement account will automatically update the Statement of Cash Flow account.

If you've set the Type column to Statement of Cash Flow:

  • Active period (closing) balance (A): Calculate the balance using the active period (closing) balance of the Balance Sheet or Income Statement account.
  • Active period (closing) balance - negative (AN): Calculate the balance by reversing the active period (closing) balance of the Balance Sheet or Income Statement account.
  • Difference between active and prior period (D): Calculate the balance using the difference between the active and prior period balances of the Balance Sheet or Income Statement account.
  • Difference between active and prior period - negative (DN): Calculate the balance by reversing the sign of the difference between the active and prior period balances of the Balance Sheet or Income Statement account.
  • Prior period (opening) balance (P): Calculate the balance using the prior period (opening) balance.
  • Prior period (opening) balance - negative (PN): Calculate the balance by reversing the sign of the prior period (opening) balance
DS (Debit Statement of Cash Flow)

Options in this column vary depending on the selection in the Type column.

If you've set the Type column to Balance Sheet or Income Statement:

  • The DS column represents a Statement of Cash Flow account number (account number format S##). With this Statement of Cash Flow number intact, all debit amounts for the Balance Sheet or Income Statement account will automatically update the Statement of Cash Flow account.

If you've set the Type column to Statement of Cash Flow:

  • N/A: You must enter the opening balance for the Statement of Cash Flow account in the Cash Flow worksheet. You can make adjustments to these balances as adjusting entries with a Type set to Statement of Cash Flow.
  • Automatically updated from accounts (A): Select to automatically calculate the balance of the Statement of Cash Flow account using Balance Sheet or Income Statement accounts linked to the Statement of Cash Flow account.