Account worksheet

Use this worksheet to set up the chart of accounts and enter opening, prior, and budget balances.

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

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

Enter unique account number containing up to 40 alphanumeric characters. In the Account worksheet, you can only add posting accounts.

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

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.
Sign Select whether the account is typically a Credit or Debit balance.
L/S Select a leadsheet number where you want to display the account and amount.
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 client accounting assignments (displayed in the general ledger) and the preliminary balance for working paper assignments (displayed in the Trial Balance and leadsheets).
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 from the Adjusting Entries or Other Entries worksheets.

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.