13 Using the Reconciliation Balancing Report

After you've completed the matching process for reconciliations, you are ready to create the balancing report which is a reconciliation snapshot.

To create the balancing report:

  1. In Transaction Matching, select Matching, and then select a reconciliation from the list.
    match overview reconciliation list
  2. From Actions, select Open.
    screenshot of Reconciliation overview tab showing intercompany reconciliation

    The Balancing panel shows how the sources reconcile as of the selected date. The As-Of calculations automatically subtract transactions in one of three following categories in order to come to an adjusted balance. The adjusted balances should always be equal assuming you have accounted for all transactional activity in the account and the loaded balances are accurate.

    If the adjusted balances are not equal and the difference is not zero, try these troubleshooting tips:

    • Ensure all transactions for that account have been loaded into Transaction Matching for the period, and the Accounting Date accurately reflects the period the transactions occurred in.
    • Ensure the period-end balances supplied are accurate.
    • Ensure any adjustments created during the period have been posted to the source system.

    Note:

    You can now drill down within each of these categories on the Balancing panel to view details about the transactions that make up the category. Click the link to view detailed information on Unmatched Transactions, Unmatched Supported Transactions, or Matched In-Transit Transactions.

    Note:

    If you have a single source reconciliation type, it only shows a single column, and the difference calculation is not necessary since a single source should always have an adjusted balance of zero.

    The balance for each data source is shown followed by the following information:

    • Less Unmatched is the net total of unmatched transactions that are not supported along with any transactions that are in suggested match state. An example is shown to demonstrate how the transactions are evaluated by the system and put into this category:

      Table 13-1 Less Unmatched Category Example (assuming the Period End Date is Nov 30)

      Source Rec ID/Account Accounting Date Amount Include/Exclude Match Date
      A 123456 30-Nov 1,000.00 Include N/A
      A 123456 1-Dec 800.00 Exclude N/A
    • Less Unmatched Supported is the net total of unmatched transactions that are supported. An example is shown to demonstrate how the transactions are evaluated by the system and put into this category:

      Table 13-2 Less Unmatched Supported Category Example (assuming the Period End Date is Nov 30)

      Source Rec ID/Account Accounting Date Amount Include/Exclude Match Date
      A 123456 30-Nov 1,000.00 Include N/A
      A 123456 1-Dec 750.00 Exclude N/A
    • Less Matched In-Transit is the net total of matched transactions that are deemed "unmatched" As-Of the period-end date. An example is shown to demonstrate how the transactions are evaluated by the system and put into this category:

      Table 13-3 Less Matched In-Transit Category Example 1

      Source Rec ID/Account Accounting Date Amount Include/Exclude Match Date
      A 123456 30-Nov 900.00 Include 2-Dec
      B 123456 1-Dec 900.00 Exclude 2-Dec

      Table 13-4 Less Matched In-Transit Category Example 2

      Source Rec ID/Account Accounting Date Amount Include/Exclude Match Date
      A 123456 30-Nov 900.00 Include 2-Dec
      B 123456 1-Dec 890.00 Exclude 2-Dec
      A (Adjustment) 123456 2-Dec (10.00) Exclude 2-Dec
  3. Select the time period and click Balance Report to generate the report. This example shows a balance report with a Difference of zero which is the goal.
    example of a balance report with difference of zero.
  4. You can view the reconciliation now in Reconciliation Compliance. You can attach the balancing report from Transaction Matching and submit the reconciliation to the reviewer.