Automatic document formats and settings

Displays accounts in account and date order and provides monthly subtotals.

Displays accounts in map and date order and provides monthly subtotals.

Select the entity within the consolidated entity structure as context for the document. Only available in consolidated files.

• Only: Select to use only the parent entity as context for the document.

From Account / To Account

From Map / To Map

Specify a range of accounts or map numbers to include in the document.

Specify a date range for the document. Any period outside the range will not display.

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

Specify an amount range for the document. Any balances outside the range will not display.

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

Used when detailed transactions have been entered in the general ledger. Details for items not recorded in the ledger but included in the statement can be added to this document.

Note: You must complete the other Account reconciliation document before you can create this document.

Reconciliation document - manual

Select the entity within the consolidated entity structure as context for the document. Only available in consolidated files.

• Only: Select to use only the parent entity as context for the document.

Select the account number to reconcile. You can only create the Reconciliation document - manual format without selecting an account number.

Specify a date range for the document. Any period outside the range will not display.

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

Select the entity within the consolidated entity structure as context for the document. Only available in consolidated files.

• Only: Select to use only the parent entity as context for the document.

Select a balance to display specific 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 in the Balance Source dialog.

Select a balance type to define which balance display in the document:

• Unadjusted: Client balance without adjusting entries.
• Adjusted: Client balance with normal adjusting entries.
• Report: Client balance with adjusting entries and reclassifying entries.
• Consolidated: Report balance with eliminating entries.
• Tax Federal: Consolidated balance with federal adjusting entries.
• Tax State: Consolidated balance with state adjusting entries.
• Tax City: Consolidated balance with city adjusting entries.

Order / group the document by the selected item.

Select a structure to apply to the document. For more information, see Define structures.

From Account / To Account

From Group / To Group

Specify a range of accounts or group numbers to include in the document.

Enter a threshold amount to set a limit based on the amount change for accounts in the document. For example, to view account amounts that have changed more than $5000, enter 5000 as the threshold amount. If the threshold amount is set to zero, the defaults set in the Threshold Defaults dialog will be used.

• And: Select to display accounts or group numbers only if both the amount change and the percentage change values exceed the threshold criteria specified.
• Or: Select to display accounts or group numbers if either the amount change or the percentage change values exceed the threshold criteria specified.

Enter a threshold percentage to set a limit based on the percentage change for accounts in the document. For example, to view account amounts that have changed more than 5%, enter 5 as the threshold percentage. If the threshold percentage is set to zero, the defaults set in the Threshold Defaults dialog will be used.

• Defaults...: Enter the threshold defaults to use if no other value is set.

Select to display period balances for:

• Balance Sheet accounts (year-to-date)
• Income Statement accounts (specified period)
• Retained Earnings accounts (as specified in Trial Balance | Settings)

Select to arrange group or map numbers in numerical order. You can further arrange the group or map numbers using the Order / Grouping option.

Select the entity within the consolidated entity structure as context for the document. Only available in consolidated files.

• Only: Select to use only the parent entity as context for the document.

From Account / To Account

From Map / To Map

Specify a range of accounts or map numbers to include in the document.

Specify an amount range for the document. Any balances outside the range will not display.

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

Specify a range of map numbers to include in the document.

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

Mapping Structure

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

Setup

Used to prepare warning, critical and error diagnostics for the preparation of working papers in the file.

Out of Balance Entries

Displays any out-of-balance journal entries.

Account Structure / Balances

Used to prepare warning, critical and error diagnostics for the setup of accounts, groupings, map numbers, ratios, and account references.

Role Completion

Displays all the documents that are missing initials or dates in the Document Properties | Role Options section.

Tax Structure

Displays all documents that report errors concerning tax linkage codes and balances for export to tax applications.

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

Displays the year to date balances of the active period for the current year and prior year, with variances calculated by amount and percentage.

Use this format for typical Statement of Cash Flow reports.

Select the entity within the consolidated entity structure as context for the document. Only available in consolidated files.

• Only: Select to use only the parent entity as context for the document.

Order the document by the selected item.

Select a rounding method to apply to the numbers in the document. For documents with subtotals, rounding is applied to the individual lines, not to the subtotal.

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase flter.

Select the entity within the consolidated entity structure as context for the document. Only available in consolidated files.

• Only: Select to use only the parent entity as context for the document.

Specify a range of accounts to include in the document.

Specify a date range for the document. Any period outside the range will not display.

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

Specify an amount range for the document. Any balances outside the range will not display.

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

Specify a date range for the document. Any period outside the range will not display.

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

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

Created By

Displays all issues, sorted by the user who created them.

Assigned To

Displays all issues, sorted by the user who is assigned to them.

Order the document by the selected item.

Specify a date range for the document. Any period outside the range will not display.

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

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

Select which issue type you want to display issues from, or select All to display issues of all types.

Normal adjusting

Displays only normal adjusting entries in the document.

Reclassifying

Displays only reclassifying entries in the document.

Displays only unrecorded - factual entries in the document.

Unrecorded - judgmental

Displays only unrecorded - judgmental entries in the document.

Eliminating

Displays only eliminating entries in the document.

Tax - Federal

Displays only tax - federal entries in the document.

Tax - State

Displays only tax - state entries in the document.

Tax - City

Displays only tax - city entries in the document.

Other basis

Displays only other basis adjustment entries in the document.

Prior period

Displays only prior period entries in the document.

Select the entity within the consolidated entity structure as context for the document. Only available in consolidated files.

• Only: Select to use only the parent entity as context for the document.

Select a misstatement type to display applicable entries in the document.

• Factual: Misstatements where there is no doubt and 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.

Order the document by the selected item.

Select a balance type to display applicable entries in the document.

Specify a date range for the document. Any period outside the range will not display.

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

Specify an amount range for the document. Any balances outside the range will not display.

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

Specify a range of accounts to include in the document.

Specify an amount range for the document. Any balances outside the range will not display.

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

Select the sorting method for other entries in the document.

Specify a range of accounts to include in the document.

Specify a date range for the document. Any period outside the range will not display.

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

Specify an amount range for the document. Any balances outside the range will not display.

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

Select the entity within the consolidated entity structure as context for the document. Only available in consolidated files.

• Only: Select to use only the parent entity as context for the document.

Select a balance to display specific 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 in the Balance Source dialog.

Select a balance type to define which balance display in the document:

• Unadjusted: Client balance without adjusting entries.
• Adjusted: Client balance with normal adjusting entries.
• Report: Client balance with adjusting entries and reclassifying entries.
• Consolidated: Report balance with eliminating entries.
• Tax Federal: Consolidated balance with federal adjusting entries.
• Tax State: Consolidated balance with state adjusting entries.
• Tax City: Consolidated balance with city adjusting entries.

Order / group the document by the selected item.

Select a rounding method to apply to the numbers in the document. For documents with subtotals, rounding is applied to the individual lines, not to the subtotal.

Select a structure to apply to the document. For more information, see Define structures.

Specify a range of group numbers to include in the document.

Specify a range of accounts to include in the document.

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

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

Select to display period balances for:

• Balance Sheet accounts (year-to-date)
• Income Statement accounts (specified period)
• Retained Earnings accounts (as specified in Trial Balance | Settings)

Select to arrange group or map numbers in numerical order. You can further arrange the group or map numbers using the Order / Grouping option.

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

Displays a spreadsheet with the following columns:

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

Displays a spreadsheet with the following columns:

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

Displays a spreadsheet with the following columns:

• Procedures
• Initials
• Reference
• Explanation
• Annotation

Displays a spreadsheet with the following columns:

• Procedures
• Initials
• Reference
• Explanation
• Annotation
• Time
• Est Time
• Staff

Displays a spreadsheet with the following columns:

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

Displays a spreadsheet with the following columns:

• Procedures
• Completeness (C)
• Existence (E)
• Allocation (A)
• Valuation (V)
• Presentation (P)
• Initials
• Reference
• Annotation
• Time
• Est. Time
• Level
• Custom column (for personal use)

Displays an analysis report using the following calculation:

• Accrued Prior + Paid - Expenses = Balance

Displays an analysis report using the following calculation:

• (Cost Prior + Additions - Disposals) - (Prior + Accumulated Amortization - Reductions) = NBV

Displays an analysis report using the following calculations:

• Principle Prior - Sales = Balance
• Accrued Prior + Received - Income = Balance
• Proc Sales - Sales = Gain (Loss) on Sales

Displays an analysis report using the following calculations:

• Principle Prior + Additions - Disposals = Balance
• Acc Int Prior + Additions - Payments = Balance

Displays an analysis report using the following calculation:

• Prior + Payments - Expenses = Balance

Displays an analysis report using the following calculation:

• Includes Description, No, Source, and Amount column.

Displays an analysis report using the following calculation:

• Amount 1 + Amount 2 = Total

Displays an analysis report using the following calculation:

• Beginning + Additions - Deductions = Balance

Displays an analysis report using the following calculation:

• Amount 1 + Amount 2 + Amount 3 +...Amount 12 = Total

Displays all details for both the Tax Line and the Sub-Line.

Note: This format uses the tax related to the original amount. For example, if an adjustment to 01A "Gross receipts or sales" updates M3217B "Cost of goods sold", the detail line will read "Adjustments to Gross receipts or sales" and not "Adjustments to cost of goods sold".

Displays all details for both the Tax Line and the Sub-Line, including summary subtotals for each Sub-Line.

Note: This format uses the tax related to the original amount. For example, if an adjustment to 01A "Gross receipts or sales" updates M3217B "Cost of goods sold", the detail line will read "Adjustments to Gross receipts or sales" and not "Adjustments to cost of goods sold".

Select the entity within the consolidated entity structure as context for the document. Only available in consolidated files.

• Only: Select to use only the parent entity as context for the document.

Select how to display the book balance:

• Unadjusted: Client balance without adjusting entries.
• Adjusted: Client balance with normal adjusting entries.
• Report: Client balance with adjusting entries and reclassifying entries.
• Consolidated: Report balance with eliminating entries.

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

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

Select the entity within the consolidated entity structure as context for the document. Only available in consolidated files.

• Only: Select to use only the parent entity as context for the document.

Select a balance to display specific 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 in the Balance Source dialog.

Select a balance type to define which balance display in the document:

• Unadjusted: Client balance without adjusting entries.
• Adjusted: Client balance with normal adjusting entries.
• Report: Client balance with adjusting entries and reclassifying entries.
• Consolidated: Report balance with eliminating entries.
• Tax Federal: Consolidated balance with federal adjusting entries.
• Tax State: Consolidated balance with state adjusting entries.
• Tax City: Consolidated balance with city adjusting entries.

Order / group the document by the selected item.

Select a rounding method to apply to the numbers in the document. For documents with subtotals, rounding is applied to the individual lines, not to the subtotal.

Select a structure to apply to the document. For more information, see Define structures.

Specify a range of accounts to include in the document.

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.

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

Select to display period balances for:

• Balance Sheet accounts (year-to-date)
• Income Statement accounts (specified period)
• Retained Earnings accounts (as specified in Trial Balance | Settings)

Select to arrange group or map numbers in numerical order. You can further arrange the group or map numbers using the Order / Grouping option.

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

Select the entity within the consolidated entity structure as context for the document. Only available in consolidated files.

• Only: Select to use only the parent entity as context for the document.

Specify a date range for the document. Any period outside the range will not display.

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

Enter a filter to print or view only the transactions, accounts, or balances that match the criteria you specify. For more information, see dBase filter.