Diagnostic formats

The format of a diagnostic document defines the focus of the diagnostic report.

Mapping Structure diagnostic

Code Error Description
W300 Field TYPE does not match mapping structure The Type property for the specified account number is different from the Type property specified for the corresponding map number.
W301 Field SIGN does not match mapping structure The Sign property for the specified account number is different from the Sign property specified for the corresponding map number.
W302 Field L/S does not match mapping structure The L/S number (group1) assigned to the specified account number is different from the L/S number specified for the corresponding map number.
W303 Field CLASS does not match mapping structure The ratio class assigned to the specified account number is different from the ratio class assigned to the corresponding map number.
W304 Field TAX CODE does not match mapping structure The tax code assigned to the specified account number is different from the tax code assigned to the corresponding map number.

W305, W306, W307, W308, W309, W310, W311, W312, W313

 Field GROUP x does not match mapping structure The specified account number and the corresponding map number are each assigned to different group numbers from grouping x.

To resolve a Mapping Structure error:

Complete one of the following:

  • Manually modify the account number to match the map number.
  • Synchronize the properties of the Mapping database with the properties of the client's chart of accounts by using the Autofill feature.

Setup diagnostic

Code Error Description Resolution
W1 Missing information for name and address Name and address information is missing in the Name and Address section of the Engagement Properties. Enter the relevant name and address information in the Engagement Properties dialog.
C1 Missing information for year end date The year end date of the client file is missing. Enter the year end date of the client file in the Engagement Properties dialog.
W3 Missing or invalid % denominator The account number specified as the denominator for calculating percentages of sales is either invalid or is missing.

  1. On the ribbon, click Account | Trial Balance | Settings.

  2. Enter a Control account number to be used as the denominator for Calculating % of sales.
C3 Missing or invalid retained earnings account The account number used to close out the Income Statement at year end is invalid or missing.

Specify Opening retained earnings account in the Settings for Reports dialog.
C4 Invalid multiple retained earnings accounts The accounts making up the year end distribution of retained earnings (typically used for partnerships) do not add up to 100%, meaning that a portion of the retained earnings at the end of the year will be unaccounted for.
  1. On the ribbon, click Engagement | Year End Close.
  2. Click Multiple in the Roll Forward Options section.
  3. Check the account numbers specified for multiple retained earnings distribution in the Multiple Account Distribution dialog.
W5 Multiple retained earnings accounts do not add to 100% The accounts making up the year end distribution of retained earnings (typically used for partnerships) do not add up to 100%, meaning that a portion of the retained earnings at the end of the year will be unaccounted for.
  1. On the ribbon, click Engagement | Year End Close.
  2. Click Multiple in the Roll Forward Options section.
  3. Check the account numbers specified for multiple retained earnings distribution in the Multiple Account Distribution dialog.
W6 Missing or invalid draft Balance Sheet rounding account The account number used for rounding the draft Balance Sheet is either invalid or missing. In the Settings for Reports dialog, type or select the correct Balance Sheet rounding account in the applicable field.
W7 Missing or invalid draft Income Statement rounding account The account number used for rounding the draft Income Statement is either invalid or missing. In the Settings for Reports dialog, type or select the correct Income Statement rounding account in the applicable field.
W8 Missing or invalid draft cash flow rounding account The account number used for rounding the draft Statement of Cash Flow is either invalid or missing. In the Settings for Reports dialog, type or select the correct Statement of Cash Flow rounding account in the applicable field.
W9 Missing information for ratios involving shares Information for calculating ratios involving shares is missing from the Settings for Analytical Review dialog. Locate the financial ratios document and click the Settings button. Complete the market price per share and outstanding shares fields for each of active and prior years as applicable.

Out of Balance Entries diagnostic

Code Error Description Resolution
C40

Adjusting entry number XX out of balance by value.

The adjusting entry with reference number XX is out of balance by the specified amount.

Complete one of the following:

  • Access the entry in the Adjusting Entries dialog to investigate.
  • Repost the client file. Navigate to Tools | Repair File, check Repost all entries, then click OK.
C41

Journal entry number XX out of balance by value.

The journal XX is out of balance by the specified amount.

Complete one of the following:

  • Access the entry in the Adjusting Entries dialog to investigate.
  • Repost the client file. Navigate to Tools | Repair File, check Repost all entries, then click OK.
W40

Out-of-balance adjusting entry posted to Cash Flow items and Performance Measure items.

An erroneous adjusting entry has been posted to a Cash Flow or Performance Measure item.

Examine the adjusting entry and correct any numerical errors.

Account Structure Balances diagnostics

Code Error Description Resolution
W50 Missing type (For example, B, I or S) Account number XX is missing a Type designation. Check the account properties in the Trial Balance.
E50 Missing sign (For example, D or C) Account number XX is missing a Sign designation. In the Trial Balance, enter either a D or C as the normal sign for the account.
E51 Incorrectly considered as posting Account number XX has been considered as a Prime Posting account rather than a consolidated account. This normally occurs when using a divisional client file. Ensure that this account has a C in the Division column of the Report Setup.
E52 Missing class number Account number XX is missing a ratio class in the Trial Balance. The ratio class is used for calculating financial ratios, conducting analytical review, and preparing the schedule of unadjusted errors. Enter the relevant ratio class in the Trial Balance.
W53 Division should be blank; profile specifies none This error occurs if the client file contains divisional account numbers (For example, one-100) and the client file is not considered a divisional file with additional companies.

Complete one of the following:

  • If you intend to use additional companies or divisions and this account should actually be a divisional account, you must change the structure of the file to be divisional by entering additional divisions or companies in the Trial Balance settings.

  • If you do not intend to use additional companies or divisions, remove the divisional portion of the number from the Div column in the Report Setup. This enables you to use a divisional account number that does not roll up to a consolidated account number.
C50 Control number does not exist The Control account number XX, referred to in the CTL column of the Report Setup, does not exist. Create the Control account in the Report Setup or remove references to it from the CTL column of the Report Setup.
C51 Numbers in CS and DS columns do not exist The Statement of Cash Flow account number SXX, referred to in either the DS or CS columns of the Report Setup, does not exist.

Do one of the following:

  1. Create the account in the in the Statement of Cash Flow portion of the Report Setup.
  2. Select relevant Statement of Cash Flow accounts in the DS and CS columns of the Report Setup.
C53 Prime account for this account number not found This error occurs if the client file contains additional companies or divisions. It indicates that the combined account for a divisional account or sub-account does not exist. The consolidated financial statement could be incorrect.
  1. On the ribbon, click Account | Trial Balance. In the trial balance, click the Report tab.
  2. Create the combined account for the divisional or sub-account.
  3. Enter a C in the Div column to indicate that this is a combined non-posting account.
C54 Prime account should be combined account This error occurs if the client file contains additional companies or divisions. It indicates that this account is incorrectly considered a posting account. A prime account of a divisional or sub-account automatically combines the balance of the divisional or sub-account. Therefore, prime accounts should always be non-posting accounts.
  1. On the ribbon, click Account | Trial Balance. In the trial balance, click the Report tab.
  2. Locate the account and enter a C in the Div column of the Report Setup.
E53 Invalid Print Code of Control (CT) account Account XX has an invalid print code or Control account.
  1. On the ribbon, click Account | Trial Balance. In the trial balance, click the Report tab.
  2. Locate the account and then click Properties on the Trial Balance toolbar.
  3. To modify the Control account number, click Account. To modify the print code, click Format and select a new print code in the Print Features box.
W54 Uses an unlisted tickmark for reference Referencing applied to an account number is using a tickmark that is not listed in the tickmark library.

Complete one of the following:

E57 Duplicate Control account The Report Setup contains two account numbers using the same Control account as the account number.
  1. On the ribbon, click Account | Trial Balance. In the trial balance, click the Report tab.
  2. Locate the Control account number you want to modify in the Account Number column and create a new Control account number. Any accounts referenced to that Control account number in the CTL column will have to be updated accordingly.
W58 Missing map number Account number XX is not assigned to a map number.
  1. On the ribbon, click Account | Assign Mappings.
  2. Perform account mapping.
W59 Has no tax code Account number XX is missing a tax code in the Trial Balance. This error applies only to US client files.
  1. On the ribbon, click Account | Trial Balance. In the trial balance, click the Tax tab.
  2. Enter the relevant tax code.
E59 Has an invalid tax code Account XX is assigned to an invalid tax code. When exporting data to the applicable tax package, this account will be represented incorrectly.
  1. On the ribbon, click Account | Trial Balance. In the trial balance, click the Tax tab.
  2. Locate the account number and assign a new tax code.
W60 Has balance but no reference Account number XX in the Trial Balance has a balance and no referencing.

Enter the applicable referencing for the account.
W61 Is referenced to a non-applicable document Account number XX in the Trial Balance is referenced to a document that does not exist on the Document Manager.

Enter a relevant document reference for the account.
W51 Missing leadsheet or grouping number Account number XX is missing a Leadsheet number in the Trial Balance. Enter the relevant leadsheet reference.
E55 Credits (c) do not match Debits (d) in print column If you are generating draft financial statements, the net income account on the Balance Sheet could be incorrect.
  1. On the ribbon, click Account | Trial Balance. In the trial balance, click the Report tab.
  2. In the print column, ensure that any Ds have corresponding Cs.
C80 Opening preliminary entries not in balance The preliminary column of the Trial Balance, which includes opening balances plus any transactions, is not in balance.
  • Run the Out of Balance Entries diagnostic to see if there are any entries that are out of balance.
  • Repost the client file. On the ribbon, click Tools | Repair File. Check Repost all entries and then click OK.
C81 Active period Balance Sheet does not balance The active period Balance Sheet is not in balance.
  • Run the Out of Balance Entries diagnostic to see if there are any entries that are out of balance.
  • Repost the client file. On the ribbon, click Tools | Repair File. Check Repost all entries and then click OK.
C82 Active YTD Balance Sheet does not balance The active year-to-date Balance Sheet is not in balance.
  • Run the Out of Balance Entries diagnostic to see if there are any entries that are out of balance.
  • Repost the client file. On the ribbon, click Tools | Repair File. Check Repost all entries and then click OK.
C83 Budget period Balance Sheet does not balance The budget period Balance Sheet is not in balance.
  • Run the Out of Balance Entries diagnostic to see if there are any entries that are out of balance.
  • Repost the client file. On the ribbon, click Tools | Repair File. Check Repost all entries and then click OK.
C84 Budget YTD Balance Sheet does not balance The budget year-to-date Balance Sheet is not in balance.
  • Run the Out of Balance Entries diagnostic to see if there are any entries that are out of balance.
  • Repost the client file. On the ribbon, click Tools | Repair File. Check Repost all entries and then click OK.
C85 Prior period Balance Sheet does not balance The prior period Balance Sheet is not in balance.
  • Run the Out of Balance Entries diagnostic to see if there are any entries that are out of balance.
  • Repost the client file. On the ribbon, click Tools | Repair File. Check Repost all entries and then click OK.
C86 Prior YTD Balance Sheet does not balance The prior year-to-date Balance Sheet is not in balance.
  • Run the Out of Balance Entries diagnostic to see if there are any entries that are out of balance.
  • Repost the client file. On the ribbon, click Tools | Repair File. Check Repost all entries and then click OK.
C87 Active period net income incorrect on Balance Sheet The active period net income is incorrect on the Balance Sheet. The Net Income account is a Working Papers account that automatically calculates the net income using a fixed account number (NETINC) that cannot be changed. This value is calculated by accumulating all type I (Income Statement) accounts.

  • Run the Out of Balance Entries diagnostic to see if there are any entries that are out of balance.

  • Repost the client file. On the ribbon, click Tools | Repair File. Check Repost all entries and then click OK.

  • In the Print column of the Report Setup, ensure that any Cs have corresponding Ds.

  • If using control accounts to flip account balances, make sure all lines referencing the same Control account number have the same statement type (For example, B, I, or S).
E60 Split-up account not attached to a Financial account The top-level account (e.g. 102) has been deleted or the account number changed but there exist split-up accounts (e.g. 102.01 and 102.02). Contact technical support for assistance in correcting this error.
W62 Balance of account changed since last Split-up An entry has been made to an account that was split-up without reflecting the change in the sub-accounts formed by the split. Open the Split-up Account dialog and balance the split-up accounts so that their total equals the balance of the top-level account.
W63 Split-up accounts unbalanced The difference between the top-level account's balance and the sum of the Split-up account balances is not zero. Open the Split-up Account dialog and balance the split-up accounts so that their total equals the balance of the top-level account.

Role Completion diagnostic

Code Error Description Resolution
W200, W201, W202, W203, W200A, W200B, W200C, W200D Missing user role completion A user has not completed or initialed the document. Enter initials and corresponding date for the user in the document properties.
W204, W205, W206, W207, W204A, W204B, W204C, W204D Assigned user does not match actual user Indicates that the document was completed (initialed) by a user other than the user assigned to the document when the work was allocated. Enter initials and corresponding date for this user in the document properties.
W208, W209, W210, W211, W208A, W208B, W208C, W208D Actual user does not have an assigned user Indicates that the document was checked off as completed, but not initialed. Open the Assign Users dialog and select a user for role 2. Ensure that this user matches the entry in the Roles tab of the document properties.

Tax Structure diagnostic

Code Error What it means How to solve
W201 Has no balances and no tax linkage An account number has no balance and is also missing a tax code in the Trial Balance. Enter the applicable tax code in the Trial Balance.
W200 Has a balance, but no tax linkage An account number has a balance but is missing a tax code in the Trial Balance. Enter the applicable tax code in the Trial Balance.

Note: If you do not complete the Tax Code column in the Tax Setup of the Trial Balance, the account balance will not be included when exporting the Trial Balance to tax packages.