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:
If you've set the Type column to Statement of Cash Flow:
|
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:
If you've set the Type column to Statement of Cash Flow:
|