Report worksheet
Use this worksheet to format draft financial statements from the client's chart of accounts. In the Mapping database, you can set up draft financial statements based on your organization's master chart of accounts. Since you can assign each client's chart of accounts to the same mapping database, you only have to set up one copy of each financial statement and schedule.
To access the Report worksheet, on the ribbon, click Account | Trial Balance. In the Trial Balance, click the Report 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. |
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. |
Type |
Select the type of financial statement where the account will display.
|
Account No |
Enter an unique account number. Account numbers can contain up to 40 alphanumeric characters. Note: You can only add posting accounts on the Account worksheet. |
Ctl (Control account) |
Select a control account from the drop-down menu. |
Sign | Select whether the account is typically a Credit or Debit balance. |
Accumulator |
Select an accumulator level to calculate the total or subtotal of the preceding lines. Each line with an accumulator adds up all preceding lines with smaller accumulator levels or no accumulator entered. 1 to 6 (Accumulator Level 1 to 6): Select an accumulator level. Using an accumulator of one adds all preceding accounts until a preceding accumulator is found. Using an accumulator of 2 adds any preceding accounts with accumulators less than two. Clear accumulators (C): Stop all accumulators above this line in the report. You can start accumulating again by selecting new accumulator codes on subsequent lines. |
L/S | Select a leadsheet number where you want to display the account and amount. |
Class | Displays the ratio class used for calculating financial ratios, conducting analytical review, and preparing the schedule of unadjusted errors (if applicable). |
Sub (Sub Account Number) |
Displays the sub-number of a prime account number (if applicable). Working Papers supports up to 99,999 sub-accounts for any prime account. Sub-accounts are useful for job costing and multiple breakdowns of key accounts such as selling and advertising expenses or accounts receivable. |
Div (Division Number) | Displays the division or company number if you are preparing a statement with multiple divisions or companies (if applicable). |
Col (Column Position) | Select a column number to indicate how far to indent the account balance on the statement. The column number is only applicable for Balance Sheet accounts. If you do not specify a number (N/A), the position is set to Column three by default. |
$ (Currency Sign) | Select to print a currency sign before the number. |
Underline | Select to underline the balance with either a Single or Double underline. |
Page | Select to print subsequent lines on a new line. |
Select how to restrict the conditions under which the line will print or display. This option affects balances in the Financial Statements, Leadsheet/Groupings and Trial Balance documents when the order is set to report.
|
|
Percent (%) | Select to specify more than one account number as the denominator for calculating percentages. This account number is used as denominator for all subsequent percentage calculations until another account number is specified. |
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:
|
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. |
Group 2-10 | Select a group number to display this account on the grouping schedule. The heading of the column displays the name entered for the group found in Tools | Options | Groupings. |
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. |