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

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.

  • Balance Sheet (B): The map number is a Balance Sheet item.
  • Income Statement (I): The map number is an Income Statement item.
  • Statement of Cash Flow (S): The map number is a Statement of Cash Flow item.
  • Performance (P): Use the account to calculate Performance Measures.

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.
Print

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.

  • Credit (C): Print the line if the year-to-date balance is a credit.
  • Debit (D): Print the line if the year-to-date balance is a debit.
  • Header (H): If you've started a new page on the same line (designated in the Page column), then the description displays under the company name and is repeated at the top of every page in the Financial Statement document.
  • Justify (J): Center the line on the Balance Sheet. On the Income Statement, this option centers the line in the Name column.
  • Skip (S): Skip the line when printing or viewing the draft financial statements.
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:

  • 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.
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.