Running Reconciliation Manager

Reconciliation Manager (RCM) is used to reconcile or match two sets of transactions. The two sets can be from the same business unit, from different business units, or if you use multiple databases they can be from different SunSystems databases. Multiple Reconciliation Manager profiles can be run simultaneously by different users within the same business unit, as well as different business units. However, you cannot reconcile the same transactional information within the same business unit, therefore you must ensure the reconciliation profiles and reconciliation accounts do not contain the same information. Before you can run a reconciliation:

The following steps are required to perform a reconciliation:

  1. Select Reconciliation Manager (RCM).
  2. Enter the reconciliation requirements on the Reconciliations - Select form and click OK.
  3. From theAction menu select Extract to extract the transactions and display them on the Reconciliations form.
  4. You can sort the transactions in either grid on the window, if required.
  5. To perform an automatic reconciliation, from the Action menu select AutoReconcile. The Fully Rec box is set automatically on any transactions in each set that meet the matching criteria.
    If there are any duplicate transactions in either transaction grid, these are ignored by the reconciliation process, unless the Consolidate Amounts option is set for the reconciliation profile. A message appears if duplicates are found, and the Duplicate box is set to identify these transactions.
  6. From the Action menu select Find to find a particular transaction.
  7. To manually reconcile transactions, check or uncheck the Fully Rec check box to the left of a transaction in each set of transactions, to reconcile or unreconcile the transaction.
    When you check (or uncheck) the Fully Rec check box, the transaction is not immediately selected (or deselected) for reconciliation. To ensure your selection takes effect, click on another transaction record in either grid, and verify that the relevant total at the top of the form is adjusted correctly for your selection.
  8. To reconcile part of a transaction, you can use the Allow Split option.
  9. To generate a transaction, you can use the Generate and Generate Balance options.
  10. To print the contents of the transaction grids, from the Action menu select Report.
  11. From the Action menu select Post to save the reconciliation results.
    If the reconciled transactions, that is the reconciliation totals displayed at the top of the form are the same, the transactions are passed to Ledger Import for validation and posting.

    If any validation warnings are identified, you are given the option to print the Ledger Import Validation Report or to continue with the posting process. If any errors are identified, the Ledger Import Validation Report is produced and the posting process is stopped.

    If you selected the Hide action before manually or automatically reconciling the transactions, the reconciled transactions are removed from the list automatically. You can select Show from the Action menu to redisplay them.