Automatic Document Formats and Settings

From Account/To Account or From/To Map

Specify a range to restrict the number of map numbers or accounts to be included in the document.

If applicable, enter a starting map or account number in the From Account field and an ending map or account number in the To Account field. Any map numbers or accounts outside the range will not be displayed or printed in the document. If you are using the mapping database with the format Map No and date order or Map No and date order with subtotals, you can restrict the number of map numbers to be included in the document by specifying a range.

Note: If a map number does not appear in the list, look it up in Engagement | Mapping and check the Behavior column. Map numbers set to Filtered are not available in the From/To Map fields.

Specify a range to restrict the period to be included in the document.

If applicable, enter a starting date in the From Date field and an ending date in the To Date field. For example, to view all activity from July 1st onwards, enter this date in the From Account field. To view all activity up to August 31st, enter this date in the To Date field.

Any period outside the range will not be displayed or printed in the report.

If blank, the From/To Date fields default to the beginning and ending dates of the active period as specified in the Engagement Properties.

Note: If setting a date range on a reconciliation document, the from date will be set to either the date chosen or the date of the earliest uncleared GL transaction in the file, whichever is earlier. If you find your report is dated earlier than you had set it, check the file for uncleared transactions.

Specify a range to restrict the number of balances to be included in the document by specifying a range of amounts. If applicable, enter minimum and maximum amounts for the account analysis.

To view all transactions greater than or equal to 1000.00, enter this amount in the From Amount field. To view all transactions less than or equal to 5000.00, enter this amount in the To Amount field. Any account or entry with a balance outside the range will not be displayed or printed in the report.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any records that do not meet the filter condition will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Reconciliation document - manual

Type or select the account number you want to reconcile.

Note: Only Reconciliation document - manual format can be created without selecting an account number. Balance per Ledger field is not completed on the reconciliation document. The Balance per Ledger field displays the ending balance of the current active period as specified in Engagement Properties.

Specify a range to restrict the period to be included in the document.

If applicable, enter a starting date in the From Date field and an ending date in the To Date field. For example, to view all activity from July 1st onwards, enter this date in the From Account field. To view all activity up to August 31st, enter this date in the To Date field.

Any period outside the range will not be displayed or printed in the report.

If blank, the From/To Date fields default to the beginning and ending dates of the active period as specified in the Engagement Properties.

Note: If setting a date range on a reconciliation document, the from date will be set to either the date chosen or the date of the earliest uncleared GL transaction in the file, whichever is earlier. If you find your report is dated earlier than you had set it, check the file for uncleared transactions.

Select a balance type to define which balance to include in the Analytical Review document:

• Unadjusted - client balance without adjusting entries.
• Adjusted - client balance plus normal adjusting entries.
• Report - client balance plus adjusting entries plus reclassifying entries.

Note: You can choose Report instead of Consolidatedfor the subsidiary companies in a consolidated file if you do not want to include eliminating entries in reports for those entities.

• Consolidated - report plus eliminating entries.
• Tax Federal - consolidated plus federal adjusting entries.
• Tax State - consolidated plus state adjusting entries.
• Tax City - consolidated plus city adjusting entries.

Select to display balances for accounts as follows:

• Balance sheet accounts display as year-to-date.
• Income statement accounts display for the period specified.
• Retained earnings accounts, as specified in the Settings for Report dialog (accessed by clicking the Settings button from the Working Trial Balance), will adjust for the net income of all previous periods.

Note: Income statement accounts' opening balances may not display if this option is selected.

Select from the following options to display specific balance columns in the document: 

• Active/Prior - Includes Preliminary, Adjusted, Reclassifying, Final, and Prior Year balances.
• Active/Preceding - Includes Preliminary, Adjusted, Reclassifying, Final, and Preceding period balances.
• Active/Budget - Includes Preliminary, Adjusted, Reclassifying, Final, and Budget Year balances.
• Active/Forecast - Includes Preliminary, Adjusted, Eliminating, Final and Forecast balances.
• Five Year - Includes Final, Prior 1, Prior 2, Prior 3, and Prior 4 balances.
• Five Year Budget - Includes Final, Prior 1, Prior 2, Prior 3, and Prior 4 budget numbers.
• Five Year Forecast - Includes are Final, Prior 1, Prior 2, Prior 3, and Prior 4 forecast numbers.
• User Defined - Includes Preliminary, Adjusted, Reclassifying, Final balances, and balances selected from the Balance source dialog. See Displaying Comparative Balances on Automatic Documents for more information.

Select from the following account type entries to display them in the document: 

• All Accounts
• Financial
• Cash Flow
• Performance
• Various groupings
• Review
• Mapping
• Tax Export code

Note: The options available vary by format.

Select a balance type to define which balance to include in the Analytical Review document:

• Unadjusted - client balance without adjusting entries.
• Adjusted - client balance plus normal adjusting entries.
• Report - client balance plus adjusting entries plus reclassifying entries.

Note: You can choose Report instead of Consolidated for the subsidiary companies in a consolidated file if you do not want to include eliminating entries in reports for those entities.

• Consolidated - report plus eliminating entries.
• Tax Federal - consolidated plus federal adjusting entries.
• Tax State - consolidated plus state adjusting entries.
• Tax City - consolidated plus city adjusting entries.

Select to order the document as follows:

• Account
• Report
• L/S
• Group 2 through 10
• Map No.
• Tax Export code
• M3 Code

Select to group the document as follows:

• Account
• Report
• L/S
• Group 2 through 10
• Map No.
• Tax Export code
• M3 Code

Select to apply a structure to the current document. See Applying Structures to Automatic Documents for more information.

Select to restrict the number map numbers or accounts to be included in the document by specifying a range. This option applies only to the formats Account balances with totals or Detailed entries with totals as these formats display the details for the map or account numbers on the document.

If applicable, enter a starting map or account number in the From Account field and an ending map or account number in the To Account field. Any map numbers or accounts outside the range will not be displayed or printed in the report.

Type a threshold amount to set a limit, based on the amount change, on which accounts to display in the document. The difference between the current and the period balances for each account or group number is represented by the amount change and is displayed in the amount change column. For example, to view only account amounts that have changed more than $5000, enter 5000 as the threshold amount. This threshold will be applied to each document to which you want the criteria applied.

Note: If the threshold amount is set to zero, Working Papers will use the defaults set in the Threshold Defaults Dialog dialog.

Type a threshold amount to set a limit, based on the percentage change, on which accounts to display in the document. The difference between the current and the prior balances for each account or group number is represented by the percentage change and is displayed in the percentage change column. For example, to view only account amounts that have changed more than 5%, enter 5 in the Threshold % field. This threshold will be applied to each document to which you want the criteria applied.

Note: If the threshold percentage is set to zero, Working Papers will use the defaults set in the Threshold Defaults Dialog dialog.

Select this check box to present group or map numbers in numerical order. When using the Order or Grouping property to present custom group numbers (L/S, Groups 2 through 10) or map numbers on a leadsheet or grouping schedule document, you can determine the order of the group numbers or map numbers on the document.

From Account/To Account or From/To Map

Specify a range to restrict the number of map numbers or accounts to be included in the document.

Enter a starting map or account number in the From Account field and an ending map or account number in the To Account field. Any map numbers or accounts outside the range will not be displayed or printed in the document.

Note: If a map number does not appear in the list, look it up in Engagement | Mapping and check the Behavior column. Map numbers set to Filtered are not available in the From/To Map fields.

Specify a range to restrict the number of balances to be included in the document by specifying a range of amounts. If applicable, enter minimum and maximum amounts for the account analysis.

To view all transactions greater than or equal to 1000.00, enter this amount in the From Amount field. To view all transactions less than or equal to 5000.00, enter this amount in the To Amount field. Any account or entry with a balance outside the range will not be displayed or printed in the report.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Specify a range to restrict the number of map numbers to be included in the document.

Enter a starting map number in the From Map field and an ending map or account number in the To Map field. Any map numbers or accounts outside the range will not be displayed or printed in the document.

Note: If a map number does not appear in the list, look it up in Engagement | Mapping and check the Behavior column. Map numbers set to Filtered are not available in the From/To Map fields.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Mapping structure

Ensures that the properties of map numbers in the mapping database correspond to the properties of accounts in the client's chart of accounts.

Setup

Prepares Warning, Critical, and Error diagnostics on the preparation of working papers in the client file.

Out of balance

Indicates which journal entries are out of balance.

Account structure/balances

Prepares Warning, Critical, and Error diagnostics on the setup of accounts, groupings, map numbers, ratios, and account referencing.

Role completion

Lists all documents missing initials or dates in the Role Options of the document properties.

Tax structure

Lists all documents that have errors concerning tax linkage codes or balances for export to tax applications.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Select to order the financial statement document depending on the report layout source (Trial Balance or Mapping) by account or map number.

Select to apply rounding to the numbers displayed in the document. Options are none, ones, thousands, or millions. When rounding, numbers are divided by the selected factor and then rounded to the closest integer. For example, the number 5662, when rounded by thousands, would be calculated as 5.662 and rounded to 6.

For documents with subtotals, rounding is applied to the individual lines, not to the subtotal. Rounding differences for the draft Balance Sheet, Income Statement, and the Statement of Cash Flow will be made to the rounding accounts as set in the Report Settings.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Select to order the financial statement document depending on the report layout source (Trial Balance or Mapping) by:

• Account
• Map number

Select to apply rounding to the numbers displayed in the document. Options are none, ones, thousands, or millions. When rounding, numbers are divided by the selected factor and then rounded to the closest integer. For example, the number 5662, when rounded by thousands, would be calculated as 5.662 and rounded to 6.

For documents with subtotals, rounding is applied to the individual lines, not to the subtotal. Rounding differences for the draft Balance Sheet, Income Statement, and the Statement of Cash Flow will be made to the rounding accounts as set in the Report Settings.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Select to order the financial statement document depending on the report layout source (Trial Balance or Mapping) by account or map number.

Select to apply rounding to the numbers displayed in the document. Options are none, ones, thousands, or millions. When rounding, numbers are divided by the selected factor and then rounded to the closest integer. For example, the number 5662, when rounded by thousands, would be calculated as 5.662 and rounded to 6.

For documents with subtotals, rounding is applied to the individual lines, not to the subtotal. Rounding differences for the draft Balance Sheet, Income Statement, and the Statement of Cash Flow will be made to the rounding accounts as set in the Report Settings.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Select from the following account type entries to display them in the document: 

• All Accounts
• Financial
• Cash Flow
• Performance
• Various groupings
• Review
• Mapping
• Tax Export Codes

Note: The options available vary by document format.

Specify a range to restrict the number of accounts to be included in the document.

Type a starting account number in the From Account field and an ending account number in the To Account field. Any map numbers or accounts outside the range will not be displayed or printed in the document.

Specify a range to restrict the period to be included in the document.

If applicable, enter a starting date in the From Date field and an ending date in the To Date field. For example, to view all activity from July 1st onwards, enter this date in the From Account field. To view all activity up to August 31st, enter this date in the To Date field.

Any period outside the range will not be displayed or printed in the report.

If blank, the From/To Date fields default to the beginning and ending dates of the active period as specified in the Engagement Properties.

Note: If setting a date range on a reconciliation document, the From Date will be set to the date chosen or the date of the earliest uncleared GL transaction in the file, whichever is earlier. If you find your report is dated earlier than you had set it, check the file for uncleared transactions.

Specify a range to restrict the number of balances to be included in the document by specifying a range of amounts. If applicable, enter minimum and maximum amounts for the account analysis.

To view all transactions greater than or equal to 1000.00, enter this amount in the From Amount field. To view all transactions less than or equal to 5000.00, enter this amount in the To Amount field. Any account or entry with a balance outside the range will not be displayed or printed in the document.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Specify a range to restrict the period to be included in the document.

If applicable, enter a starting date in the From Date field and an ending date in the To Date field. For example, to view all activity from July 1st onwards, enter this date in the From Account field. To view all activity up to August 31st, enter this date in the To Date field.

Any period outside the range will not be displayed or printed in the report.

If blank, the From/To Date fields default to the beginning and ending dates of the active period as specified in the Engagement Properties.

Note: If setting a date range on a reconciliation document, the From Date will be set to the date chosen or the date of the earliest uncleared GL transaction in the file, whichever is earlier. If you find your report is dated earlier than you had set it, check the file for uncleared transactions.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Created By

Listing of issues based on the user who created them.

Assigned to

Listing of issues based on the user to whom they have been assigned.

Select to order the issues document by:

• Assigned to - The user assigned to the issue.
• Created by - The user who created the issue.
• Created on - The date the issue was created.
• Due on - The due date for resolution of the issue.
• Status - The status of the issue.
• Subject - The subject of the issue.
• Document - The document associated with the issue.
• Completed by - The user who completed the issue.
• Cleared by - The user who cleared the issue.
• Number - The issue number.

Specify a range to restrict the period to be included in the document.

If applicable, enter a starting date in the From Date field and an ending date in the To Date field. For example, to view all activity from July 1st onwards, enter this date in the From Account field. To view all activity up to August 31st, enter this date in the To Date field.

Any period outside the range will not be displayed or printed in the report.

If blank, the From/To Date fields default to the beginning and ending dates of the active period as specified in the Engagement Properties.

Note: If setting a date range on a reconciliation document, the From Date will be set to the date chosen or the date of the earliest uncleared GL transaction in the file, whichever is earlier. If you find your report is dated earlier than you had set it, check the file for uncleared transactions.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Select from the following issue types to display:

• All
• None
• Client issue
• Considerations for next year
• Engagement issues

Normal adjusting

Displays only normal adjusting entries in the adjusting journal entry report.

Normal adjusting entries update all relevant Automatic documents on the Document Manager such as journals, ledgers, trial balance, financial statements, and leadsheets. When updating from one period to another including a year-end close, these entries are transferred from the adjustment column to the opening or preliminary balance column on the trial balance and leadsheet documents.

Reclassifying

Displays only reclassifying journal entries in the adjusting journal entry report.

When reclassifying entries are made in any period other than the last period of the fiscal year, reclassifying entries are excluded from the accounting records. In this case, the entries to non-consolidated balances do not have to be reversed. If you select either Consolidated or Report from the Update next year’s opening balance with: drop down menu during a year-end close, reclassifying entries made in the last period of the fiscal year are included in the next year’s opening balances. Those reclassifying entries do then have to be reversed.

Displays only unrecorded - factual journal entries in the adjusting journal entry report.

Unrecorded - factual entries represent factual misstatements that will not be recorded because of materiality or proposed entries that may be subsequently changed to a normal status.

Unrecorded - judgmental

Displays only unrecorded - judgmental journal entries in the adjusting journal entry report.

Unrecorded - judgmental entries represent judgmental misstatements that are unrecorded based on differences arising from the judgments of management concerning accounting estimates, or the selection or application of accounting policies that the auditor considers inappropriate or unreasonable.

Eliminating

Displays only eliminating entries in the adjusting journal entry report.

Eliminating entries are used to prepare combinations or consolidations of divisions or companies.

Note: Eliminating entries in a consolidated file made to a subsidiary entity with a fractional contribution are treated at 100% (the fractional contribution does not apply to eliminating entries).

Tax - federal

Displays only tax - federal adjusting journal entries in the adjusting journal entry report.

Federal tax entries adjust the federal tax balance. They are not recorded in the normal accounting records.

Note: Any Permanent or Temporary adjusting entry will be displayed in the Difference column of the report.

Tax - state

Displays only tax - state adjusting journal entries in the adjusting journal entry report.

State tax entries adjust the state tax balance. They are not recorded in the normal accounting records.

Tax - city

Displays only tax - city adjusting journal entries in the adjusting journal entry report.

City tax entries adjust the city tax balance. They are not recorded in the normal accounting records.

Other basis

Displays only other basis adjustment entries in the adjusting journal entry report.

Prior period

Displays only prior period adjusting journal entries in the adjusting journal entry report.

Select from the following account type entries to display them in the document:

• All Accounts
• Financial
• Cash Flow
• Performance
• Various groupings
• Review
• Mapping
• Tax Export Codes

Note: The options available vary by document format.

Select to display entries in the report that have an applicable misstatement.

Note: This option is only available when the adjusting entry type is set to Normal adjusting, Reclassifying, Eliminating, Tax, or Other basis.

Available misstatement types include:

• Factual - Misstatements where there is no doubt and where supporting documentation is available.
• Projected - The auditor's best estimate of misstatements in populations; usually derived from sampling.
• Judgmental - Differences arising from the judgments of management concerning accounting entries.

Select to display the adjusting journal entries by the order selected. Available options include:

• Account Number
• As Entered
• Debit/Credit

Select to display entries that have an applicable balance set. Types of balances that can be displayed are:

• N/A
• Budget
• Forecast

Specify a range to restrict the period to be included in the document.

If applicable, enter a starting date in the From Date field and an ending date in the To Date field. For example, to view all activity from July 1st onwards, enter this date in the From Account field. To view all activity up to August 31st, enter this date in the To Date field.

Any period outside the range will not be displayed or printed in the report.

If blank, the From/To Date fields default to the beginning and ending dates of the active period as specified in the Engagement Properties.

Note: If setting a date range on a reconciliation document, the From Date will be set to the date chosen or the date of the earliest uncleared GL transaction in the file, whichever is earlier. If you find your report is dated earlier than you had set it, check the file for uncleared transactions.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Specify a range to restrict the number of accounts to be included in the document.

If applicable, type a starting account number in the From Account field and an ending account number in the To Account field. Any map numbers or accounts outside the range will not be displayed or printed in the document.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Select to display to other journal entries by the order selected. Available options include:

• Reference Number
• Date
• Description
• Account Number

Specify a range to restrict the number of accounts to be included in the document.

If applicable, type a starting account number in the From Account field and an ending account number in the To Account field. Any map numbers or accounts outside the range will not be displayed or printed in the document.

Specify a range to restrict the period to be included in the document.

If applicable, enter a starting date in the From Date field and an ending date in the To Date field. For example, to view all activity from July 1st onwards, enter this date in the From Account field. To view all activity up to August 31st, enter this date in the To Date field.

Any period outside the range will not be displayed or printed in the report.

If blank, the From/To Date fields default to the beginning and ending dates of the active period as specified in the Engagement Properties.

Note: If setting a date range on a reconciliation document, the From Date will be set to the date chosen or the date of the earliest uncleared GL transaction in the file, whichever is earlier. If you find your report is dated earlier than you had set it, check the file for uncleared transactions.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

Select from the following options to display specific balance columns in the document: 

• Active/Prior - Includes Preliminary, Adjusted, Reclassifying, Final, and Prior Year balances.
• Active/Preceding - Includes Preliminary, Adjusted, Reclassifying, Final, and Preceding period balances.
• Active/Budget - Includes Preliminary, Adjusted, Reclassifying, Final, and Budget Year balances.
• Active/Forecast - Includes Preliminary, Adjusted, Eliminating, Final and Forecast balances.
• Five Year - Includes Final, Prior 1, Prior 2, Prior 3, and Prior 4 balances.
• Five Year Budget - Includes Final, Prior 1, Prior 2, Prior 3, and Prior 4 budget numbers.
• Five Year Forecast - Includes Final, Prior 1, Prior 2, Prior 3, and Prior 4 forecast numbers.
• User Defined - Includes Preliminary, Adjusted, Reclassifying, and Final balances, and balances selected from the Balance Source dialog. See Displaying Comparative Balances on Automatic Documents for more information.

Select a balance type to define which balance to include in the Analytical Review document:

• Unadjusted - client balance without adjusting entries.
• Adjusted - client balance plus normal adjusting entries.
• Report - client balance plus adjusting entries plus reclassifying entries.

Note: You can choose Report balance instead of Consolidated for the subsidiary companies in a consolidated file if you do not want to include eliminating entries in reports for those entities.

• Consolidated - report plus eliminating entries.
• Tax Federal - consolidated plus federal adjusting entries.
• Tax State - consolidated plus state adjusting entries.
• Tax City - consolidated plus city adjusting entries.

Documents in the Account balances with totals and Account balances with group subtotals formats can be ordered by:

• Account
• Mapping
• Report

Select to group the document as follows:

• Account
• Report
• L/S
• Group 2 through 10
• Map No.
• Tax Export code
• M3 Code

Specify a range to restrict the number of groups to be included in the trial balance. This option applies to the following document formats:

• Accounts balance with group subtotals
• Group summary
• Group heirarchy with subtotals
• Group heirarchy summary

When applicable, enter a starting group number in the From Group field and an ending group number in the To Group field. Any group with numbers outside the range will not be displayed in the document.

Specify a range to restrict the number of map numbers or accounts to be included in the leadsheet. This option applies only to the formats Account balances with totals or Detailed entries with totals as these formats display the details for the map or account numbers on the document.

If applicable, enter a starting map or account number in the From Account field and an ending map or account number in the To Account field. Any map numbers or accounts outside the range will not be displayed or printed in the report. The excluded map or accounts are hidden and may be returned to the report at any time by clearing the field(es) or entering different map or account numbers.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

For more information, see dBase Filter.

Select to view several entities at once. The view itemizes balances per entity as well as eliminating adjustments, consolidated balance, and prior year figures.

Note: Up to 49 entities can be displayed.

Select to display balances for accounts as follows:

• Balance sheet accounts display as year-to-date.
• Income statement accounts display for the period specified.
• Retained earnings accounts, as specified in the Settings for Report dialog (accessed by clicking the Settings button from the Working Trial Balance), will adjust for the net income of all previous periods.

See Year End Close or Settings for Reports for further details on setting a year-end rollover account.

Note: Income statement accounts' opening balances may not display if this option is selected.

Select this option to present adjusting journal entry and reclassifying journal entry balances in one column entitled Adjustments instead of in two separate columns. This option is unavailable if you are using the format Detailed entries with totals.

Note: If the Foreign Exchange check box is also selected, the combined adjustments will be included in the Report balance column.

Select to present group numbers or map numbers in numerical order. This option is available for the following document formats:

• Account balances with group subtotals
• Group summary
• Group heirarchy with subtotals
• Group heirarchy summary

Select to display adjusting entry details posted to a particular account. Detail is listed only for adjustments applicable to a report.

For example, details for eliminating entries appear only if the balance type is Consolidated. Details for federal tax entries appear only if the balance type is Tax Federal. Other basis entries appear only if the Include Other Basis Adjustments check box is selected.

In addition, adjustment detail is listed only if there is a column in the report that shows the detail. For example, if the Show Amount Change or Foreign Exchange check boxes are selected, there is no column that contains adjustments for most reports, so no detail is shown in those reports.

A spreadsheet with the following columns:

• Procedures
• Y/N (yes/no)
• Initials
• Reference (document reference)
• Explanation
• Annotation

A spreadsheet with the following columns:

• Procedures
• Y/N (yes/no)
• Reference (document reference)
• Explanation
• Annotation

A spreadsheet with the following columns:

• Procedures
• Initials
• Reference (document reference)
• Explanation
• Annotation

A spreadsheet with the following columns:

• Procedures
• Initials
• Reference (document reference)
• Explanation
• Annotation
• Time
• Est Time
• Staff

A spreadsheet with the following columns:

• Procedures
• Completeness (C)
• Existence (E)
• Allocation (A)
• Valuation (V)
• Presentation (P)
• Initials
• Reference (document reference)
• Annotation
• Time
• Est Time
• Level (user level)

A spreadsheet with all columns from the Program with Assertions format, plus one custom column (X) for your personal use.

Principle Prior - Sales = Balance

Accrued Prior + Received - Income = Balance

Proc Sales - Sales = Gain (Loss) on Sales

Principle Prior + Additions - Disposals = Balance

Acc Int Prior + Additions - Payments = Balance

Select to display the book balance as:

• Unadjusted - Client balance without adjusting entries.
• Adjusted - Client balance plus normal adjusting entries.
• Report - Client balance plus adjusting entries plus reclassifying entries.

Note: You can choose Report balance instead of Consolidated for the subsidiary companies in a consolidated file if you do not want to include eliminating entries in reports for those entities.

• Consolidated - Report plus eliminating entries.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

For more information, see dBase Filter.

Select from the following balances to display specific balance columns based on balance type selected in the document: 

For example, if Report is selected as a balance type, the following balances columns will display: 

• Active/Prior - Includes Preliminary, Adjusted, Reclassifying, Final, and Prior Year balances.
• Active/Preceding - Includes Preliminary, Adjusted, Reclassifying, Final, and Preceding period balances.
• Active/Budget - Includes Preliminary, Adjusted, Reclassifying, Final, and Budget Year balances.
• Active/Forecast - Included are Preliminary, Adjusted, Eliminating, Final and Forecast balances.
• Five Year - Included are Final, Prior 1, Prior 2, Prior 3, and Prior 4 balances.
• Five Year Budget - Includes Final, Prior 1, Prior 2, Prior 3, and Prior 4 budget numbers.
• Five Year Forecast - Includes are Final, Prior 1, Prior 2, Prior 3, and Prior 4 forecast numbers.
• User Defined - Includes Preliminary, Adjusted, Reclassifying, Final balances and balances selected from the Balance Source dialog. See Displaying Comparative Balances on Automatic Documents for more information.

Select from the following account type entries to display them in the document:

• All Accounts
• Financial
• Cash Flow
• Performance
• Various groupings
• Review
• Mapping
• Tax Export Codes

Note: The options available vary by document format.

Select a balance type to define which balance to include in the trial balance document:

• Unadjusted - client balance without adjusting entries.
• Adjusted - client balance plus normal adjusting entries.
• Report - client balance plus adjusting entries plus reclassifying entries.

Note: You can choose Report balance instead of Consolidated for the subsidiary companies in a consolidated file if you do not want to include eliminating entries in reports for those entities.

• Consolidated - report plus eliminating entries.
• Tax Federal - Consolidated plus federal adjusting entries.
• Tax State - Consolidated plus state adjusting entries.
• Tax City - Consolidated plus city adjusting entries.

Select to group the document as follows:

• Account
• Report
• L/S
• Group 2 through 10
• Map No.
• Tax Export code
• M3 Code

This property is not available for the Detailed entries with totals format.

Select to apply rounding to the numbers displayed in the document. Options are none, ones, thousands, or millions. When rounding, numbers are divided by the selected factor and then rounded to the closest integer. For example, the number 5662, when rounded by thousands, would be calculated as 5.662 and rounded to 6.

For documents with subtotals, rounding is applied to the individual lines, not to the subtotal. Rounding differences for the draft Balance Sheet, Income Statement, and the Statement of Cash Flow will be made to the rounding accounts as set in the Report Settings.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any records that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

For more information, see dBase Filter.

Select to view several entities at once.

The view itemizes balances per entity as well as eliminating adjustments, consolidated balance, and prior year figures.

Note: Up to 49 entities can be displayed.

This option is not available if the format is set to Detailed entries with totals, if the balance type is not set to report or consolidated, if a structure is specified or if the following options are selected:

• Include other basis adjustments
• Combined adjustments into one column
• Show amount change
• Adjusting entry detail

Select to display balances for accounts as follows:

• Balance sheet accounts display as year-to-date.
• Income statement accounts display for the period specified.
• Retained earnings accounts, as specified in the Settings for Report dialog (accessed by clicking the Settings button from the Working Trial Balance), will adjust for the net income of all previous periods.

Note: Income statement accounts' opening balances may not display if this option is selected.

Select this option to present adjusting journal entry and reclassifying journal entry balances in one column entitled Adjustments instead of in two separate columns. This option works with Report and consolidated balances but is unavailable if you are using the format Detailed entries with totals.

Note: If the Foreign Exchange option is also selected, the combined adjustments will be included in the Report balance column.

Select to display applicable adjusting entries details in the document. This allows you to see a report that groups accounts by map number or any other group while seeing the detail of the adjusting journal entries that are being posted against a particular account.

For example, details for eliminating entries appear only if the balance type is Consolidated. Details for federal tax entries appear only if the balance type is Tax Federal. Other basis entries appear only if the Include Other Basis Adjustments check box is selected. In addition, adjustment detail is listed only if there is a column in the report that shows the detail. For example, if the Show Amount Change or Foreign Exchange check boxes are selected, there is no column that contains adjustments for most reports, so no detail is shown in those reports.

In the document, you can drill-down from an adjusting journal entry detail line to open the applicable journal. You can annotate the detail line with both global and document annotations.

Specify a range to restrict the period to be included in the document.

If applicable, enter a starting date in the From Date field and an ending date in the To Date field. For example, to view all activity from July 1st onwards, enter this date in the From Account field. To view all activity up to August 31st, enter this date in the To Date field.

Any period outside the range will not be displayed or printed in the report.

If blank, the From/To Date fields default to the beginning and ending dates of the active period as specified in the Engagement Properties.

Note: If setting a date range on a reconciliation document, the From Date will be set to the date chosen or the date of the earliest uncleared GL transaction in the file, whichever is earlier. If you find your report is dated earlier than you had set it, check the file for uncleared transactions.

Apply a filter to print or view only those transactions, accounts, or balances that match criteria you specify. The filter usually takes the form of a condition. Any records that do not meet the filter will be excluded. Although a filter can be established for any field in the database, the most useful would be the General Ledger database where all detailed transactions are maintained.

Tip: If the format of the report is modified after the filter is written (for example, from balances with totals to one with group subtotals), the filter can be affected and may no longer work as expected. The filter may have to be modified to work correctly.

For more information, see dBase Filter.