Diagnostic formats
The format of a diagnostic document defines the focus of the diagnostic report.
- Mapping Structure diagnostic
- Setup diagnostic
- Out of Balance Entries diagnostic
- Account Structure Balances diagnostic
- Role Completion diagnostic
- Tax Structure diagnostic
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. |
|
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. |
|
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. |
|
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:
|
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:
|
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:
|
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:
|
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. |
|
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. |
|
E53 | Invalid Print Code of Control (CT) account | Account XX has an invalid print code or Control account. |
|
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. |
|
W58 | Missing map number | Account number XX is not assigned to a map number. |
|
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. |
|
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. |
|
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. |
|
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. |
|
C81 | Active period Balance Sheet does not balance | The active period Balance Sheet is not in balance. |
|
C82 | Active YTD Balance Sheet does not balance | The active year-to-date Balance Sheet is not in balance. |
|
C83 | Budget period Balance Sheet does not balance | The budget period Balance Sheet is not in balance. |
|
C84 | Budget YTD Balance Sheet does not balance | The budget year-to-date Balance Sheet is not in balance. |
|
C85 | Prior period Balance Sheet does not balance | The prior period Balance Sheet is not in balance. |
|
C86 | Prior YTD Balance Sheet does not balance | The prior year-to-date Balance Sheet is not in balance. |
|
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. |
|
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.