You are here: Help Topics > Engagements > Automatic documents > Automatic document formats and settings

Automatic document formats and settings

Specify the format and settings of an automatic document to define the appearance and data that displays.

Account analysis

Formats

Format Description
Account and date order Displays accounts in account and date order.
Account and date order with subtotals

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

Map No and date order Displays accounts in map and date order.
Map No and date order with subtotals

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

Settings

Setting Description
Context

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.
Period Select the period for the document. The available periods vary based on the settings established in the Engagement Properties.
Accounts Select the account type to include in the document.

From Account / To Account

From Map / To Map

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

From Date / To Date

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.

From Amount / To Amount

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

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.

Account reconciliation

Formats

Format Description
Clear items for reconciliation Displays all transactions for the specified account that can be cleared.
Outstanding - debits and credits Displays all the outstanding debit and credit transactions for the specified account.
Outstanding - debits only Displays all the outstanding debit transactions for the specified account.
Outstanding - credits only Displays all the outstanding credit transactions for the specified account.
Reconciliation document - auto

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

Used when detailed transactions have not been entered in the general ledger. You must enter the entire reconciliation, including outstanding debits and credits, manually.

Settings

Setting Description
Context

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.
Account No.

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

From Date / To Date

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.

Analytical review

Formats

Format Description
Ratio analysis Displays all automatically calculated financial ratios in the file. Annotation is permitted in the amount column only.
Variance by account Displays all accounts, including the amount and percentage change calculated between the balances.
Variance by account with group subtotals Displays all accounts sorted by group number with group number subtotals, including the amount and percentage change calculated between the balances. Threshold criteria is applied to the individual accounts assigned to the group number.
Variance by group with group subtotals Displays all accounts sorted by group number with group number subtotal, including the amount and percentage change calculated between the balances. Threshold criteria is applied to the group number subtotal.
Variance by group summary Displays all grouping balances sorted by grouping order, including the amount and percentage change calculated between the balances. Double-click an item to view the accounts assigned to the group or map number.

Settings

Setting Description
Context

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.
Period Select the period for the document. The available periods vary based on the settings established in the Engagement Properties.
Balances

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.
Accounts Select the account type to include in the document.
Balance Type

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 / Grouping

Order / group the document by the selected item.

Structure

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.

Threshold Amount

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.
Threshold % (Percentage)

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.
Foreign Exchange Select to view balances in a foreign currency. For more information, see Enter foreign exchange rates.
Period Balances

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)
Auto Arrange

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

Show Splitups Select to display any associated split-up accounts in the document.
Include Other Basis Adjustments Select to display other basis adjustment entries in the document.

Chart of accounts

Formats

Format Description
Alphabetical order Displays the chart of accounts sorted alphabetically by account name.
Numerical order Displays the chart of accounts sorted numerically by account number.

Settings

Setting Description
Context

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.
Period Select the period for the document. The available periods vary based on the settings established in the Engagement Properties.
Accounts Select the account type to include in the document.

From Account / To Account

From Map / To Map

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

From Amount / To Amount

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

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.

Chart of mapping numbers

Formats

Format Description
Alphabetical order Displays the chart of mapping numbers sorted alphabetically by account name.
Numerical order Displays the chart of mapping numbers sorted numerically by account number.
Report order Displays the chart of mapping numbers sorted using the same method as the Report worksheet.

Settings

Setting Description
From Map / To Map

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

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.

Consolidation

Formats

Format Description
Normal Displays all the entities in the consolidation hierarchy.
Details Displays all the entities in the consolidation hierarchy, including the established properties for each entity.

Settings

Setting Description
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.

Diagnostics

Formats

Format Description

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.

Document index

Settings

Setting Description
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.

Document Manager

Formats

Format Description
Role completion only Displays all documents, including role completion details only.
Role completion with document properties Displays all documents, including properties and role completion details.

Settings

Setting Description
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.

Financial statements

Formats (Balance sheet)

Format Description
Active period / year to date Displays the year to date balances of the active period for the current year.
Active period / ytd with A/C # printed Displays the year to date balances of the active period for the current year, with account numbers.
Active period / budget period Displays the period balances of the active period for the current year and current budget year, with variances calculated by amount and percentage.
Active period / prior period Displays the period balances of the active period for the current year and prior year, with variances calculated by amount and percentage.
Active / prior period with year to date Displays both the period balances and year to date balances of the active period for the current year and prior year, with variances calculated by amount and percentage. The Actual (Current Period) column displays the combined total of transactions and adjustments from the Trial Balance, excluding the opening balance.
Active / budget / prior period with year to date Displays both the period balances and year to date balances of the active period for the current year, current budget year, and prior year, with percentage variances.
Active / budget period with year to date Displays the year to date balances of the active period for the current year and current budget year, with variances calculated by amount and percentage.
Draft active / prior year to date Displays the year to date balances of the active period for the current year and prior year, with variances calculated by amount and percentage.
Five year history Displays the year to date balances of the active period for the current and preceding four years, with percentage variances.
Active year to date / prior year to date Displays the year to date balances of the active period for the current year and prior year, with variances calculated by amount and percentage.

Formats (Income statement)

Format Description
Active period/year to date Displays both the period balances and year to date balances of the active period for the current year.
Active period/ytd with A/C # printed Displays both the period balances and year to date balances of the active period for the current year, with account numbers.
Active year to date Displays the year to date balances of the active period for the current year.
Active period/budget period Displays the period balances of the active period for the current year and current budget year, with variances calculated by amount and percentage.
Active period/prior period Displays the period balances of the active period for the current year and prior year, with variances calculated by amount and percentage.
Active/prior period with year to date Displays both the period balances and year to date balances of the active period for the current year and prior year, with variances calculated by amount and percentage.
Active/budget/prior period with year to date Displays both the period balances and year to date balances of the active period for the current year, current budget year, and prior year, with percentage variances.
Active/budget period with year to date Displays the year to date balances of the active period for the current year and current budget year, with variances calculated by amount and percentage.
Draft active/prior year to date Displays the year to date balances of the active period for the current year and prior year, with variances calculated by amount and percentage.
Five year history Displays the year to date balances of the active period for the current and preceding four years, with percentage variances.
Active year to date/prior year to date Displays the year to date balances of the active period for the current year and prior year, with variances calculated by amount and percentage.

Formats (Statement of cash flow)

Format Description
Active period/year to date Displays the year to date balances of the active period for the current year.
Active period/ytd with A/C # printed Displays the year to date balances of the active period for the current year with account numbers.
Active period/budget period Displays the period balances of the active period for the current year and current budget year, with variances calculated by amount and percentage.
Active period/prior period Displays the period balances of the active period for the current year and prior year, with variances calculated by amount and percentage.
Active/prior period with year to date Displays both the period balances and year to date balances of the active period for the current year and prior year, with variances calculated by amount and percentage.
Active/budget/prior period with year to date Displays both the period balances and year to date balances of the active period for the current year, current budget year, and prior year, with percentage variances.
Active/budget period with year to date Displays the year to date balances of the active period for the current year and current budget year, with variances calculated by amount and percentage.
Draft active/prior year to date

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.

Five year history Displays the year to date balances of the active period for the current and preceding four years, with percentage variances.
Active year to date/prior year to date Displays the year to date balances of the active period for the current year and prior year, with variances calculated by amount and percentage.

Settings

Setting Description
Context

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.
Period Select the period for the document. The available periods vary based on the settings established in the Engagement Properties.
Order

Order the document by the selected item.

Rounding

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.

Balance Select a custom balance to use in the document. For more information, see Create custom balances.
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 flter.

Foreign Exchange Select to view balances in a foreign currency. For more information, see Enter foreign exchange rates.

General ledger

Formats

Format Description
Account and date order Displays the general ledger in account number order, with all account activity displayed in date order.
Account and date order with subtotals Displays the general ledger in account number order, with all account activity displayed in date order with subtotals for each date.

Settings

Setting Description
Context

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.
Period Select the period for the document. The available periods vary based on the settings established in the Engagement Properties.
Accounts Select the account type to include in the document.
From Account / To Account

Specify a range of accounts to include in the document.

From Date / To Date

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.

From Amount / To Amount

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

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.

Show Tax Column Select to display a column for the tax amount (if applicable) in the document.

History

Formats

Format Description
Sign Out / In Displays all recorded events involving users signing a file in or out.
Adjusting Journal Entry Displays all recorded events involving the posting of adjusting journal entries.
File Access Displays all recorded events involving users accessing files.
Document Creation Displays all recorded events involving the creation of new documents.
Document Modification Displays all recorded events involving the modification of existing documents.
Check Out / In Displays all recorded events involving users checking a document in or out.
Role Completion Displays all recorded events involving role completion and sign-off.
Document Deletion Displays all recorded events involving the deletion of documents.
Issue Creation Displays all recorded events involving the creation of new issues.
Document Access Displays all recorded events involving users accessing documents.
All History Events Displays all recorded events.
Post Lockdown Events Displays all recorded events involving modification to a file after lock down.

Settings

Setting Description
From Date / To Date

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.

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.

Issues

Formats

Format Description

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.

Completed By Displays all issues, sorted by the user who completed them.
Cleared By Displays all issues, sorted by the user who cleared them.

Settings

Setting Description
Order

Order the document by the selected item.

Status Select the issue statuses to display in the document.
From Date / To Date

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.

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.

Created By, Assigned To, Completed By, or Cleared By Select which user group you want to display issues from, or select All to display issues for all users.
Issue Types

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

Journals

Formats (Adjusting journal entries)

Format Description

Normal adjusting

Displays only normal adjusting entries in the document.

Reclassifying

Displays only reclassifying entries in the document.

Unrecorded - factual

Displays only unrecorded - factual entries in the document.

Unrecorded - projected Displays only unrecorded - projected entries in the document.

Unrecorded - judgmental

Displays only unrecorded - judgmental entries in the document.

Eliminating

Displays only eliminating entries in the document.

All entries Displays all adjusting 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.

Settings (Adjusting journal entries)

Setting Description
Context

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.
Period Select the period for the document. The available periods vary based on the settings established in the Engagement Properties.
Accounts Select the account type to include in the document.
Misstatement

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

Order the document by the selected item.

Balance

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

From Reference / To Reference Specify a range of reference numbers to include in the document.
From Date / To Date

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.

From Amount / To Amount

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

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.

Combine Adjustments Into One Column Select to display adjusting and reclassifying journal entries in one column, rather than two separate columns.
Show Amount Change Select to display the amount change and percentage change columns.

Settings (Opening entries)

Setting Description
From Account / To Account

Specify a range of accounts to include in the document.

From Amount / To Amount

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

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.

Settings (All other journal types)

Setting Description
Order

Select the sorting method for other entries in the document.

From Account / To Account

Specify a range of accounts to include in the document.

From Date / To Date

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.

From Amount / To Amount

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

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.

Leadsheet/grouping

Formats

Format Description
Account balances with totals Displays all accounts in the Trial Balance assigned to the specified group number, including the grouping total.
Account balances with group subtotals Displays a summary for each of the groupings and assigned accounts in one document. You can specify which group numbers and accounts to display in the Group No. field.
Group summary Displays each grouping with a balance and a total.
Detailed entries with totals Displays detailed adjusting entries for each account assigned to a group number. You can use this format to support any account on a leadsheet.
Group hierarchy with subtotals Displays all associated accounts in one document, including the subtotals for each group. You can specify which group numbers and accounts to display in the Group No. field.
Group hierarchy summary Displays a summary for each of the groupings in one document (with no account detail). You can specify which group numbers and accounts to display in the Group No. field.

Settings

Setting Description
Context

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.
Period Select the period for the document. The available periods vary based on the settings established in the Engagement Properties.
Balances

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.
Balance Type

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 / Grouping

Order / group the document by the selected item.

Rounding

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.

Group No. Select a group number to correspond with the grouping type.
Structure

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

From Group / To Group

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

From Account / To Account

Specify a range of accounts to include in the document.

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.

Foreign Exchange Select to view balances in a foreign currency. For more information, see Enter foreign exchange rates.
Consolidated View

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.

Period Balances

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)
Combine Adjustments Into One Column Select to display adjusting and reclassifying journal entries in one column, rather than two separate columns.
Auto Arrange

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

Show Amount Change Select to display the amount change and percentage change columns.
Sign Select to use each account's normal sign for display purposes only.
Include Other Basis Adjustments Select to display other basis adjustment entries in the document.
Adjusting Entry Detail

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

Show Calculated Map / Group Breakdown Select to display a breakdown of calculated map or group numbers in a particular account.

Program/checklist

Formats

Format Description
Checklist - Format 1

Displays a spreadsheet with the following columns:

  • Procedures
  • Y/N (yes/no)
  • Initials
  • Reference
  • Explanation
  • Annotation
Checklist - Format 2

Displays a spreadsheet with the following columns:

  • Procedures
  • Y/N (yes/no)
  • Reference
  • Explanation
  • Annotation
Program - Format 1

Displays a spreadsheet with the following columns:

  • Procedures
  • Initials
  • Reference
  • Explanation
  • Annotation
Program - Format 2

Displays a spreadsheet with the following columns:

  • Procedures
  • Initials
  • Reference
  • Explanation
  • Annotation
  • Time
  • Est Time
  • Staff
Program with assertions

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
Program with assertions - Format 2

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)

Spreadsheet analysis

Formats

Format Description
Accrued expenses

Displays an analysis report using the following calculation:

  • Accrued Prior + Paid - Expenses = Balance
Capital assets

Displays an analysis report using the following calculation:

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

Displays an analysis report using the following calculations:

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

Displays an analysis report using the following calculations:

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

Displays an analysis report using the following calculation:

  • Prior + Payments - Expenses = Balance
Generic single column

Displays an analysis report using the following calculation:

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

Displays an analysis report using the following calculation:

  • Amount 1 + Amount 2 = Total
Generic triple column

Displays an analysis report using the following calculation:

  • Beginning + Additions - Deductions = Balance
Generic twelve column

Displays an analysis report using the following calculation:

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

Tax reconciliation

Formats

Format Description
Detail Tax Line & Sub-Line

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

Tax Sub-Line Summary Displays all details for the Tax Line and only summary information for the Sub-Line.
Tax Line Summary Displays only summary information for both the Tax Line and the Sub-Line.
Detail & Sub-Line with Main Tax Totals

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

Settings

Setting Description
Context

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.
Book Balance

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.
From Reference / To Reference Specify a range of reference numbers to include in the document.
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.

Exclude M3*A/M3*D Tax Codes (USA only) Select to exclude M3 Book Amount and M3 Tax Amount codes from the document.
Include Other Basis Adjustments Select to display other basis adjustment entries in the document.
Include OBA in Adjusted Tax Balance Select to include other basis adjustment entries in the adjusted tax balance.
Adjusting Entry Detail

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

Trial balance

Formats

Format Description
Account balances Displays all accounts, including adjusting entries, annotation and commentary.
Account final balance Displays all accounts, including final and prior balances only.
Account balances with group subtotals Displays all accounts, including subtotals of the map or group number.
Account balances with split-up Displays all accounts, including split-up accounts.
Group hierarchy with subtotals Displays all accounts, including subtotals by map or group number.
Group hierarchy summary Displays all grouped balances. Double-click an item to view the accounts assigned to the map or group number.
Group summary Displays all grouped balances with details. Double-click an item to view the accounts assigned to the map or group number.
Detailed entries with totals Displays the adjusting entries for each account.

Settings

Setting Description
Context

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.
Period Select the period for the document. The available periods vary based on the settings established in the Engagement Properties.
Balances

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.
Accounts Select the account type to include in the document.
Balance Type

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 / Grouping

Order / group the document by the selected item.

Rounding

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.

Structure

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

From Group / To Group Specify a range of group numbers to include in the document.
From Account / To Account

Specify a range of accounts to include in the document.

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.

Foreign Exchange Select to view balances in a foreign currency. For more information, see Enter foreign exchange rates.
Consolidated View

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.

Period Balances

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)
Combine Adjustments Into One Column Select to display adjusting and reclassifying journal entries in one column, rather than two separate columns.
Auto Arrange

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

Show Amount Change Select to display the amount change and percentage change columns.
Include Other Basis Adjustments Select to display other basis adjustment entries in the document.
Adjusting Entry Detail

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

Uncorrected misstatements

Settings

Setting Description
Context

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.
Period Select the period for the document. The available periods vary based on the settings established in the Engagement Properties.
From Date / To Date

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.

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.