Limitación de responsabilidad por el uso del Traductor Google. Haga clic aquí .
Limitación de responsabilidad por el uso del Traductor Google.
La traducción de páginas en www.caseware.com puede ser llevada a cabo por el Traductor Google, un proveedor de servicios externo sobre el cual CaseWare no posee control alguno. Este servicio proporciona traducciones automatizadas que sólo representan una aproximación del contenido original, siendo proporcionado únicamente para su comodidad. Algunas aplicaciones, archivos, gráficos u otro material podrían no ser traducidos.
Estas traducciones no debieran ser consideradas como exactas pudiendo incluir expresiones incorrectas u ofensivas. CaseWare no garantiza la exactitud, confiabilidad y presentación oportuna de ninguna información traducida bajo este sistema siendo los usuarios del mismo los propios responsables de su uso. CaseWare no se hará responsable de ningún daño o pérdida incurrida con motivo de tal uso.
Working Trial Balance Tabs
The Working Trial Balance consists of seven tabs to assist in completing and reviewing the trial balance.
Access: On the Account tab, in the Balances group, Click Trial Balance.
Click on an area in the screen shot below to view its description
Account Tab
Use this tab to set up the chart of accounts and enter opening, prior, and budget balances. Only prime posting accounts are displayed in the Account tab.
Default Columns
Field | Description |
---|---|
Entity | Select the entity to which the account belongs.This column will only display in a consolidated file. |
Account No |
Type an unique account number that must be up to 40 digits(alphanumeric) and cannot be duplicated. You can only add posting accounts in the Account tab. Click to split up an account into several components. If an account has assigned split-ups, the symbol is shown beside the account name. |
Name |
Type an account description to be displayed on the trial balance, general ledger, draft financial statements, and all working paper documents that display the account. Click to enter an extended description for the account. This description does not appear on the automatic document. It is available for linking to alphanumeric cells in CaseView documents using the Linkage dialog. Accounts that have extended descriptions appear as in the Working Trial Balance. |
Lock | Select to prevent changes being made to the account. Once locked, transactions, adjusting journal entries, account balances, and properties can no longer be modified and only "Unrecorded/proposed" adjusting entries, which are for presentation purposes only, can be posted to the account. |
Map No |
Type or select the applicable map number for the account. Click to display the Select Map Number dialog. Once the map number is located, click the Select button to input the number in the Account tab. Note: If a map number does not appear in this list, look it up in the Engagement Mapping and check the Behavior column. Map numbers set to "Filtered" are not available in the Working Trial Balance. |
Type | Select a draft financial statement area to which the account is applicable. |
Sign | Select Credit if the account is normally a credit balance or select Debit if the account is normally a debit balance. Depending on the account balance, the amount will be displayed or printed with brackets. |
L/S | Type or select a leadsheet number and this account appear on the selected leadsheet or grouping schedule. When searching through the list of available leadsheets, click the L/S heading to view the list in leadsheet number order or click the Name heading to view the list of leadsheets by leadsheet description. |
Tax Export Code |
Click to access a list of tax codes to assign the account. You can also complete the Tax linkage by clicking the Tax tab in the Working Trial Balance. During update to the latest version of Working Papers, a prefix "DEL" is assigned to any tax codes that are no longer used. Any outdated codes will not be exported and should be updated or deleted. Working Papers can be customized to use tax codes predefined for each type of tax entity that you can set in Engagement Properties. See Tax for more information. |
M3 Code | Click to access a list of assign M3 codes for US tax entities (excluding Non-Profit) to the chosen account number. See Tax for more information. |
Class | If applicable, type or select the appropriate ratio class. The ratio class is used for calculating financial ratios, conducting analytical review, and preparing the schedule of unadjusted errors. |
Opening Balance | Type the opening balances for client accounting assignments and preliminary balances for working paper assignments. These balances become the opening balance when viewing the general ledger and the preliminary balance when viewing any trial balances or leadsheets. |
Transactions |
Displays the year-to-date other journal entries (when the Allow transaction entry option is turned on in the period balances tab of the Engagement Properties), or year-to-date period balances when the Allow entry of period balances option is on in the Engagement Properties. Double-click in the transactions column to drill down to the period breakdown (for example all 12 months when file is set to monthly, and 4 quarters when file is set to quarterly). The balances are read only when the Allow transaction entry option is selected, and read/write when the Allow entry of period balances option is selected. Depending on the settings of the Engagement Properties, balances entered in this drilldown can be either period amounts or year-to-date (YTD) amounts. Switch between the two options easily by adjusting the settings in the Engagement | Properties | Period Balances tab. |
Adjustments |
Displays the total adjustments for the account that will be used in arriving at the final balance. These balances cannot be changed in the Account tab and can be adjusted in the Adjusting Journal Entries or Other Journal Entries interface. Double-click in the Adjustments column to display all adjustments including those making up previous balances. While on a transaction amount in the Adjustments screen, double-click to view the detail making up the respective adjustment amount. |
Final | Displays the final balance for the account after all adjustments for that period have been calculated. |
GIFI (Canada only) |
If a GIFI number has not been automatically entered, type or select the applicable GIFI number for the account. Click the to display the Select GIFI Number dialog. Tip: Although mapping is not necessary to use the GIFI, using the mapping number database will cut a lot of work. For example, if this account is assigned to a map number and the mapping numbers have been assigned to codes in the GIFI numbers database, then the GIFI codes can be automatically assigned to all accounts in the chart of accounts with one button click. |
Prior Year 1 to 4 |
Type a balance if it is a single period or yearly file. If it is a multiple period file (as defined in the Dates section of the Engagement Properties), press F9 or double-click to display all prior periods. Double-click the prior year columns to see any adjustments. The Adjustments column shows the lump sum total from a year end close or manually entered adjustments. The PY Adjustments column shows any prior year adjustments made in Adjusting Journal Entries interface. Depending on the Engagement Properties settings, balances entered in this drilldown can be either period amounts or year-to-date (YTD) amounts and can be adjusted in the Engagement | Properties | Period Balances tab. |
Budget |
Displays the budget balance for the year. If this is a single period file, then the balance can be input in this column. If it is a multiple period file (as defined in the Dates section of the Engagement Properties), then pressing F9 or double-clicking in this column displays all budget periods. Depending on the settings of the Engagement Properties, balances entered in this drilldown can be either period amounts or year-to-date (YTD) amounts. If allowed in the Engagement Properties, the two options can be easily switched between by adjusting the settings in the Engagement | Properties | Period Balances tab. |
Tax Code |
Use this assign a Tax code to the chosen account number. Click to access a list of tax codes from which to choose. When you assign a tax code to an account, then that tax code is used for any journal or adjusting entry. The account tax code overrides the tax code chosen for the journal. Example:
When an entry is made to account 100 in the accounts payable journal, the GST is used. When making an entry to account 101 in the accounts payable journal, the PST is always used. Tax codes are created by in the Tools tab | Options| Lists | Tax Codes or can be accessed by clicking Customize... button on any Other Journal Entries Interface or the Adjusting Journal Entries Interface. |
Other Column Field Descriptions
Some columns are hidden by default in this screen. Right-click any heading to show any or all hidden columns.
Field | Description |
---|---|
Map No Description | Displays the Map Name for this account. |
Map No. (flip) |
Type or select the applicable map number for the account. Click the to display the Select Map Number dialog. Once the map number is located, click the Select button to input the number in the Account tab.
Note
|
Map No (Flip) Description | Displays the flip Map name for this account. |
L/S Flip | Type or select a leadsheet number to have this account appear on the selected leadsheet or grouping schedule if it is being flipped. |
Tax Entity | Displays the tax entity that has been assigned to the consolidated entity for the selected account. This column is read-only. To change a consolidated entity's tax entity, access the Entity Properties dialog and click Setting. |
Group 2 through 10 | Type or select a group number from the applicable grouping in order to display this account on the grouping schedule. Assignment of group numbers can also be completed using the Groupings tab in the Working Trial Balance. |
Group 2 through 10 (Flip) |
Type or select a group number from the applicable grouping in order to display this account on the grouping schedule when it is flipped. |
Budget (Prior years 1 to 4) | Displays the budget balance for the given prior year. |
F’cast year 1 to 5 |
Displays the forecast numbers for each account for each of five years. Depending on the settings of the engagement properties, balances entered in this drilldown can be either period amounts or year-to-date (YTD) amounts. If allowed in the engagement properties, the two options can be easily switched between by adjusting the settings in Engagement | Properties | Period Balances tab. |
Baseline | Displays the baseline number to be used with the forecast amounts. |
Report Tab
Use this tab to format Working Papers draft financial statements from the client’s chart of accounts. You can now set up draft financial statements based on your firm’s master chart of accounts using the mapping database. Because each client's chart of accounts can be assigned to the same mapping database, you only have to set up one copy of each financial statement and schedule.
Default Columns
Field | Description | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Entity | Select the entity to which the account belongs.This column will only display in a consolidated file. | ||||||||||||||
Name |
Type an account description to be displayed on the trial balance, general ledger, draft financial statements, and all working paper documents that display the account. Click to enter an extended description for the account. This description does not appear on the automatic document. It is available for linking to alphanumeric cells in CaseView documents using the Linkage dialog. Accounts that have extended descriptions appear as in the Working Trial Balance interface.
|
||||||||||||||
Type |
For each line in the report, select the type of financial statement that it will appear on.
|
||||||||||||||
Account No |
Type an unique account number that must be up to 40 digits(alphanumeric) and cannot be duplicated. You can only add posting accounts in the Account tab. Click to split up an account into several components. | ||||||||||||||
Ctl (Control account) |
Select a control account from the list of Control accounts available. >>More Info? |
||||||||||||||
Sign | Select Credit if the account is normally a credit balance or select Debit if the account is normally a debit balance. Depending on the account balance, the amount will be displayed or printed with brackets. | ||||||||||||||
Accumulator |
Type or select an accumulator level if the line in the report is to total or subtotal preceding lines. Each line with an accumulator selected 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) Select "Clear" or "C" where you want to clear all prior accumulators. This will stop all accumulators above that line in the report. You can start accumulating again by selecting new accumulator codes on subsequent lines. |
||||||||||||||
L/S | Select a leadsheet number where this account and amount will be displayed. When searching through the list of available leadsheets, click the L/S heading to view the list in leadsheet numerical order or click the Name heading to view the list by leadsheet description. | ||||||||||||||
Class | If applicable,displays the ratio class. The ratio class is used for calculating financial ratios, conducting analytical review, and preparing the schedule of unadjusted errors. | ||||||||||||||
Sub (Sub Account Number) |
If applicable, this displays the sub number of a prime account number. 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) | If applicable, displays the division or company number if preparing a statement with multiple divisions or companies. | ||||||||||||||
Col (Column Position) | Select a column position to indicate how far the account balance is to be indented when displayed on the statement. Up to three columns can be used. This column number is only applicable for Balance Sheet accounts. If no position is specified, (N/A), the default is position 3. | ||||||||||||||
$ (Currency Sign) | Select to print a currency sign before the number. | ||||||||||||||
Underline | Select to underline the selected balance. Enter an S to print a single underline and a D to print a double underline. | ||||||||||||||
Page | Select to print subsequent lines on a new line. This is useful if preparing schedules for a statement. Do not use this when changing the type of statement (For example, from B to I) as Working Papers automatically sends a new page form feed to the printer. If you choose this option as well, a blank page will result when printing your draft financial statements. | ||||||||||||||
If applicable, select to restrict the conditions under which the line will print or display.
The "Print" column affects balances in the Financial Statements automatic document and the Leadsheet/Groupings and Trial Balance documents when the order is set to report. It also affects the behavior of the CaseView CLASS() function.
|
|||||||||||||||
Percent (%) | Select to specify more than one account number as the denominator for calculating percentages in the Report tab. (The account number for calculating the percentage of sales is entered by clicking the Settings button while in the Working Trial Balance.) If you enter an account number in the Percent column, this alternate number will be used as denominator for all subsequent percentage calculations until another account number is specified. | ||||||||||||||
CS (Credit statement of cash flow) |
This column is used for the preparation of the draft Statement of Cash Flow. The meaning of the CS column is determined by the contents of the Type column. For Type B (Balance Sheet) and Type I (Income Statement) accounts, the CS column represents a statement of cash flow account number (an account number with the 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. For Type S (Statement of Cash Flow) accounts, the CS column offers the following options:
|
||||||||||||||
DS (Debit statement of cash flow) |
This column is used in the preparation of the draft Statement of Cash Flow. The meaning of the DS column is determined by the contents of the Type column. For Type B (Balance Sheet) and Type I (Income Statement) accounts, the DS column represents a statement of cash flow account number (an account number with the 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. For Type S (Statement of Cash Flow) accounts, the DS column offers the following options: N/A If the DS column is blank, then the opening balance for the Statement of Cash Flow account will have to be entered in the Cash Flow tab. Adjustments to these balances can be made as adjusting journal entries with a Type of Statement of Cash Flow. Automatically updated from accounts (A) If selected, Working Papers automatically calculates 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 |
Type or select the applicable map number for the account. Click the to display the Select Map Number dialog. Once the map number is located, click the Select button to input the number in the Account tab. Entering map numbers automatically completes account properties according to the characteristics assigned to the map number. This may be changed as necessary. (See Assign Mapping Numbers. |
||||||||||||||
Group 2 through 10 | Type or select a group number from the grouping in order to display this account on the selected grouping schedule. Assignment of group numbers can also be completed using the Groupings tab in the Working Trial Balance. The heading of the column displays whatever is entered on the Tools | Options | Groupings tab. | ||||||||||||||
GIFI |
If a GIFI number has not been automatically entered, type or select the applicable GIFI number for the account. Click the to display the Select GIFI Number dialog. |
||||||||||||||
M3 Code | Click to access a list of assign M3 codes for US tax entities (excluding Non-Profit) to the chosen account number. See Tax for more information. |
Other Column Field Descriptions
Some columns are hidden by default in this screen. Right-click any heading to show any or all hidden columns.
Field | Description |
---|---|
Tax Export Code |
Click to access a list of tax codes to assign the account. You can also complete the Tax linkage by clicking the Tax tab in the Working Trial Balance. During update to the latest version of Working Papers, a prefix "DEL" is assigned to any tax codes that are no longer used. Any outdated codes will not be exported and should be updated or deleted. |
Tax Entity | Displays the tax entity that has been assigned to the consolidated entity for the selected account. This column is read-only. To change a consolidated entity's tax entity, access the Entity Properties dialog and click Setting. |
Notes
-
If using CaseView in conjunction with Working Papers, the option to use cash flow settings for any CaseView cash flow reports must be enabled in CaseView. If these settings are not turned on, Working Papers values will not be applied in the CaseView document.
The option is located under Tool-> Options -> Client in CaseView.
Cash Flow Tab
Use this tab to post cash flow balances. Only those accounts that are not automatically updated from the Balance Sheet or Income Statement accounts (as indicated by an A in the DS column) are listed here.
Default Column Descriptions
Field | Description |
---|---|
Account No |
Displays the Statement of Cash Flow account number as defined in the Report tab. Statement of Cash Flow account numbers begin with an "S" followed by two numbers. Click to split up an account into several components. If an account has assigned split-ups, the symbol displays beside the account name. |
Entity | Select the entity to which the account belongs.This column will only display in a consolidated file. . |
Name |
Type an account description to be displayed on the trial balance, general ledger, draft financial statements, and all working paper documents that display the account. Click to enter an extended description for the account. This description does not appear on the automatic document. It is available for linking to alphanumeric cells in CaseView documents using the Linkage dialog. Accounts that have extended descriptions appear as in the Working Trial Balance interface. |
Map No |
Type or select the applicable map number for the account. Click the to display the Select Map Number dialog. Once the map number is located, click the Select button to input the number in the Account tab. Entering map numbers automatically completes account properties according to the characteristics assigned to the map number. This may be changed as necessary. (See Assign Mapping Numbers). |
Type | The Type is always S for Statement of Cash Flow while in the Cash Flow setup. |
Sign | Select Credit if the account is normally a credit balance or select Debit if the account is normally a debit balance. Depending on the account balance, the amount will be displayed or printed with brackets. |
L/S |
Represents the leadsheet number where the account and amount will be displayed. Click the Groupings tab to assign Statement of cash flow accounts to leadsheet and grouping numbers. |
Class | If applicable, type or select the appropriate ratio class. The ratio class is used for calculating financial ratios, conducting analytical review, and preparing the schedule of unadjusted errors. |
Opening Balance | Opening balances for Statement of Cash Flow accounts are entered here. |
Transactions |
Displays the transaction amounts for each account. These balances cannot be changed in the Statement of Cash Flow Screen. Transactions are year-to-date other journal entries (when the allow transaction entry option is turned on in the period balances tab of the engagement properties), or they are year-to-date period balances when the allow entry of period balances option is on in the engagement properties. |
Adjustments | Displays the total adjustments for the account that will be used in arriving at the final balance. These balances cannot be changed in the Statement of Cash Flow Screen. They can be adjusted only by inputting a journal entry of Type Statement of Cash Flow. |
Final | Displays the final balance for the account after all adjustments for that period have been calculated. |
GIFI (Canada only) | If a GIFI number has not been automatically entered, type or select the applicable GIFI number for the account. Click the to display the Select GIFI Number dialog. Once the GIFI number is located, click the Select button to input the number in the Cash Flow tab. |
Prior Year 1 to 4 | Displays the applicable prior year's balance. If this is a single period file, then the balance can be input in this column. If it is a multiple period file (as defined in the Dates section of the Engagement Properties), then double-clicking in this column displays all prior periods. |
Budget | Displays the budget balance for the year. If this is a single period file, then the balance can be input in this column. If it is a multiple period file (as defined in the Dates section of the Engagement Properties), then double-clicking in this column displays all budget periods. |
Tax Code |
Use this assign a Tax code to the chosen account number. Click to access a list of tax codes from which to choose. When you assign a tax code to an account, then that tax code is used for any journal or adjusting entry. The account tax code overrides the tax code chosen for the journal. Example:
When an entry is made to account 100 in the accounts payable journal, the GST is used. When making an entry to account 101 in the accounts payable journal, the PST is always used. Tax codes are created by in the Tools tab | Options| Lists | Tax Codes or can be accessed by clicking Customize... button on any Other Journal Entries Interface or the Adjusting Journal Entries Interface. |
Other Column Descriptions
Some columns are hidden by default in this screen. Right-click any heading to show any or all hidden columns.
Field | Description |
---|---|
Group (2 through 10) | Type or select a group number from the grouping in order to display this account on the selected grouping schedule. Assignment of group numbers can be completed using the Grouping tab in the Working Trial Balance. |
Note
: In order to use these cash flow settings in CaseView documents, the option to use the report tab properties, need to be turned on in CaseView. This option can be found in File | Document Settings | Client Options. If the option is not selected in CaseView, the Cash Flow settings are not used in the formulas flowing into the CaseView document.Groupings Tab Column Descriptions
Use this tab to assign groupings to the chart of accounts. Group numbers are used to group accounts together on leadsheets or grouping schedules. Working Papers permits several custom groupings: L/S, and Groups 2 through 10. An unlimited number of group numbers can be added to each grouping. Group numbers can be independent of the leadsheet or grouping schedule document numbers on which they appear. For example, document number 1000 could display group numbers from the L/S grouping ranging from A to ZZZ. Accounts in the chart of accounts or Mapping database can be assigned to one group number from each grouping. To add or modify group numbers, on the Engagement menu, click Groupings.
Field | Description |
---|---|
Entity | Select the entity to which the account belongs.This column will only display in a consolidated file. |
Account No |
Type an unique account number that must be up to 40 digits(alphanumeric) and cannot be duplicated. You can only add posting accounts in the Account tab. Click to split up an account into several components. |
Name |
Type an account description to be displayed on the trial balance, general ledger, draft financial statements, and all working paper documents that display the account. Click to enter an extended description for the account. This description does not appear on the automatic document. It is available for linking to alphanumeric cells in CaseView documents using the Linkage dialog. Accounts that have extended descriptions appear as in the Working Trial Balance interface. |
L/S | Type or select a leadsheet number to have this account appear on the selected leadsheet. When searching through the list of available leadsheets, click the L/S heading to view and order the list by the leadsheet number or click the Name heading to view the list of leadsheets by leadsheet description. |
L/S(Flip) | Type or select a leadsheet number to use if the assigned account is flipped. When searching through the list of available leadsheets, click the L/S heading to view and order the list by the leadsheet number or click the Name heading heading to view the list of leadsheets by leadsheet description. |
Group (2 through 10) | Type or select a group number into the Group (2 through 10) to display this account on the selected grouping schedule. |
Group (2 through 10) (Flip) | Type or select a group number into the Group (2 through 10) to display the account in the proper grouping schedule when its flipped. |
Performance Measures Tab
Use this tab to set up the accounts for performance indicators (waste management, employee expenditures, etc.). Corporations use many measures to track performance, especially for key indicators. Accounts set up as performance measure accounts allow the Working Papers trial balance and adjusting entry system to handle information regardless of the unit of measurement.
Default Columns
Field | Description |
---|---|
Entity | Select the entity to which the account belongs.This column will only display in a consolidated file. |
Account No |
Type an unique account number that must be up to 40 digits(alphanumeric) and cannot be duplicated. You can only add posting accounts in the Account tab. Click to split up an account into several components. If an account has assigned split-ups, the symbol is shown beside the account name. |
Name | Type an account description to be displayed on the trial balance, general ledger, draft financial statements, and all working paper documents that display the account. |
Lock | Select to prevent changes being made to the account. Once locked, transactions, adjusting journal entries, account balances, and properties can no longer be modified and only "Unrecorded/proposed" adjusting entries, which are for presentation purposes only, can be posted to the account. |
Map No |
Type or select the applicable map number for the account. Click the to display the Select Map Number dialog. Once the map number is located, click the Select button to input the number in the Account tab. Entering map numbers automatically completes account properties according to the characteristics assigned to the map number. This may be changed as necessary. (See Assign Mapping Numbers). |
L/S | Type or select a leadsheet number to have this account appear on the selected leadsheet. When searching through the list of available leadsheets, click the L/S heading to view the list in order of leadsheet number or click the Name heading to view the list of leadsheets by leadsheet description. |
Units | If applicable, type or select Units for the performance account. You can create units for performance measures accounts from the Tools Menu by selecting Options| Lists and clicking Units Tab. |
Opening Balance | Type the opening balances for client accounting assignments and preliminary balances for working paper assignments. These balances become the opening balance when viewing the general ledger and the preliminary balance when viewing any trial balances or leadsheets. |
Transactions |
Displays the transaction amounts for each account. These balances cannot be changed in the Performance Measures Setup. When you select to "Allow transaction entry option in Other Entries screen" in the Engagement Properties | period balances tab , the transactions would be considered year-to-date other journal entries. When you select to Allow entry of period balances in Working Trial Balance , the transactions would be considered year-to-date period balances. |
Adjustments |
Displays the total adjustments for the account that will be used in arriving at the final balance. These balances cannot be changed in the Performance Measures tab. They can be adjusted in the Adjusting Journal Entries or Other Journal entries screen. Double-click the Adjustments column to display all adjustments including those making up previous balances. While on a transaction amount in the Adjustments screen, double-click to view more details on the respective adjustment amount. |
Final | Displays the final balance for the account after all adjustments for that period have been calculated. |
Prior Year 1 to 4 |
Displays the balance for prior year 1, 2, 3, or 4. If this is a single period or yearly file, then the balance can be inputted in this column. If this is a multiple period file, pressing F9 or double-clicking the column displays all prior periods. |
Budget Year 1 to 5 | Displays the budget balance for the current and next 4 subsequent years. If this is a single period file, then the balance can be inputted in this column. If this is a multiple period file, pressing F9 or double-clicking the column displays all budget periods. |
Other Column Field Descriptions
Some columns are hidden by default in this screen. Right-click any heading to show any or all hidden columns.
Field | Description |
---|---|
Map No(Flip) |
Type or select the applicable map number to be used if the account is flipped.
|
Group (1 through 10) | Type or select a group number into the Group (2 through 10) to display this account on the selected grouping schedule. Assignment of group numbers can be completed using the Groupings Setup in the Working Trial Balance. |
Group (1 through 10)(Flip) | Type or select a group number into the Group (2 through 10) to display the account in the proper grouping schedule when its flipped. |
Tax Export Code | Use this column to assign tax linkage codes to the chosen account number. Click this column to access a list of tax codes from which to choose. You can also complete the Tax linkage by clicking the Tax tab in the Working Trial Balance. |
Forecast Year 1 to 4 | Displays the forecast balance for current and next 4 subsequent years. If this is a single period file, then the balance can be inputted in this column. If this is a multiple period file, pressing F9 or double-clicking the column will display all forecast periods. |
Units 2 | If applicable, type or select a second unit of measure for the performance account.You can create units for performance measures accounts from the Tools Menu by selecting Options| Lists and clicking Units Tab. |
Converted Balance | If applicable, displays the calculated amount of the balances times the exchange rate. |
Baseline | Displays the baseline number to be used with the forecast amounts. |
Tax Tab
Use this tab to link tax codes (for tax software) to the chart of accounts in the Working Papers working paper file. Once tax codes are assigned to the chart of accounts, the tax balances can be exported to various tax packages for more efficient tax return filing.
Field | Description |
---|---|
Entity | Select the entity to which the account belongs.This column will only display in a consolidated file. |
Account No |
Represents the Account Number, which can be up to 40 alphanumeric or numeric characters long. Account numbers must be unique and cannot be duplicated. |
Name |
Represents the Account description. Click to enter an extended description for the account. This description does not appear on printed documents. It is available for linking to alphanumeric cells in CaseView documents using the Linkage dialog. Accounts that have extended descriptions appear as while working in the Working Trial Balance. |
Tax Export Code |
Click to access a list of tax codes to assign the account. You can also complete the Tax linkage by clicking the Tax tab in the Working Trial Balance. During update to the latest version of Working Papers, a prefix "DEL" is assigned to any tax codes that are no longer used. Any outdated codes will not be exported and should be updated or deleted. |
M3 Code |
Click to access a list of assign M3 codes for US tax entities (excluding Non-Profit) to the chosen account number. See Tax for more information. Note: Account balances in the Trial Balance that are assigned M3 Codes are exported to tax software, except for CCH ProSystem fx. |
Tax Entity | Displays the tax entity that has been assigned to the consolidated entity for the selected account. This column is read-only. To change a consolidated entity's tax entity, access the Entity Properties dialog and click Setting. |
GIFI (Canada only) |
If a GIFI number has not been automatically entered, type or select the applicable GIFI number for the account. Click the to display the Select GIFI Number dialog.
Tip: Although mapping is not necessary to use the GIFI, using the mapping number database will cut a lot of work. For example, if this account is assigned to a map number and the mapping numbers have been assigned to codes in the GIFI numbers database, then the GIFI codes can be automatically assigned to all accounts in the chart of accounts with one button click. |
L/S | Displays the leadsheet number to which the account is assigned. |
Book Balance | Displays the "before tax" balances of the account. |
Foreign Exchange Tab
Use this tab to specify foreign exchange rates for the accounts in the trial balance.
Field | Description |
---|---|
Entity | In a consolidated file, the Entity column will appear in the Account setup screen of the Working Trial Balance. Select the name of the entity to which the account belongs. |
Account No |
Type an unique account number that must be up to 40 digits(alphanumeric) and cannot be duplicated. You can only add posting accounts in the Account tab. Click to split up an account into several components. If an account has assigned split-ups, the symbol is shown beside the account name. |
Name |
Type an account description to be displayed on the trial balance, general ledger, draft financial statements, and all working paper documents that display the account. Click to enter an extended description for the account. This description does not appear on the automatic document. It is available for linking to alphanumeric cells in CaseView documents using the Linkage dialog. Accounts that have extended descriptions appear as in the Working Trial Balance interface. |
Type | Displays the type of account. |
Rate Type |
Select the type of exchange rate to use, current or historical. Note: When accounts are newly created through importing, the default rate type is set according to account type:
|
Current Rate |
Enter the foreign exchange rate for the current year. Note: If a Custom Balance Identifier was added in the Custom Balances dialog, the corresponding rate is added in the Foreign Exchange tab. The current rate will be for the current period/ period date sequence. Double-click on the rate to view the opening rate and the rates for all periods for the current period date sequence. |
Prior Year Rate (Year 1 to 4) | Type the foreign exchange rate for the selected prior year. |
Budget Rate (Year 1 to 5) | Type the foreign exchange rate for the budget year. |
Forecast Rate (Year 1 to 5) | Type the foreign exchange rate for the selected forecast year. |
Units 2 | If applicable, type or select a second unit of measure for the performance account. To create units for performance measures accounts, from the Tools menu, select Options | Lists and then click the Units tab. |
Related Topics
-
Working Trial Balance