Understanding Multisite Consolidation Integrity Reports

After you create the consolidated balances, you should run integrity reports to verify the information. Integrity reports supplement your internal balancing procedures. Integrity reports also help you locate potential balancing problems and data inconsistencies before you send the information to the target site.

Note: In addition to integrity reports, you can also generate a consolidated balance sheet and a consolidated income statement.

Review the available multisite consolidations integrity reports:

• Prior Period Balance Integrity (R10700):

  Identifies any consolidated balances from the prior period that have changed since the previous consolidation.

• UDC Value Control Exceptions (R107011:

  Identifies user-defined code values in the consolidation that are not recognized by the target company. You can run the UDC Value Control report to review a list of valid user-defined code values.

• Object/Subsidiary Value Control (R107021):

  Identifies objects and subsidiaries in the consolidation that are not recognized by the target company.

• BU/Accounts Monthly Comparison (R10701):

  Compares the business units and accounts in the source to those in the target. Run this report either at the source site prior to sending a consolidation or at the target site after you receive a consolidation.

• Consolidated Balance Sheet (R10150):

  Shows the assets, liabilities, and stockholders' equity of the consolidation that you are sending to the target company.

• Consolidated Income Statement (R10250):

  Shows the assets, liabilities, and stockholders' equity of the consolidation that you are sending to the target company.