Selecting Transactions for Reconciliation

Reconciliation Manager (RCM) is used to reconcile or match two sets of transactions. There are two stages to the reconciliation process which use different, linked forms:

  • The Reconciliations - Select form is used to enter the selection details and then extract the transactions for reconciliation.
  • The Reconciliations form lists the extracted transactions and is used to reconcile the transactions both manually and automatically.

See 'Running Reconciliation Manager' for the detailed steps required to use these forms.

Note:  Before you can use Reconciliation Manager to perform a reconciliation you must have defined the transaction matching criteria using Reconciliation Profiles (RCP) and identified the source of each set of transactions using Reconciliation Accounts (RCA). You must also have imported or loaded into SunSystems the transactions to be reconciled, for example, using SunSystems Transfer Desk.

Reconciliations - Select (RCM)

Profile Code
The code that uniquely identifies the reconciliation profile as defined using Reconciliation Profiles (RCP).

Accounts

1st Business Unit
The business unit for which transactions will be displayed in the top grid of the reconciliation manager form.
1st Actual/Budget Marker
The letter representing the actuals ledger (A) or budget ledger (B to K) for which the transactions are to be displayed in the top grid of the reconciliation manager form.
1st Account Code
The account code for which transactions will be displayed in the top grid of the reconciliation manager form. If this code was not defined in Reconciliation Accounts (RCA) from the profile, you must enter the code here.
2nd Business Unit
The business unit for which transactions will be displayed in the bottom grid of the reconciliation manager form.
2nd Actual/Budget Marker
The letter representing the actuals ledger (A) or budget ledger (B to K) for which the transactions are to be displayed in the bottom grid of the reconciliation manager form.
2nd Account Code
The account code for which transactions will be displayed in the bottom grid of the reconciliation form. If this code was not defined in Reconciliation Accounts for the profile, you must enter the code here.
Currency Code
The transaction currency code for which transactions are extracted for reconciliation.
Note:  This is not required if the Reconciliation Profile being used reconciles by Third Amount, as this is defined in the business unit.
Transaction Date From/To
The range of dates for which transactions are to be extracted for reconciliation. For large volumes of data, we recommend setting up a selection criteria for the Transaction Date range to assist performance during the extract process.
Show Posted/Reconciled
Select this option to include transactions that have already been reconciled in the transaction grids. For example, you might want to reset the reconciliation flag on selected transactions.
Note: You can use the Hide action to remove these transactions from the reconciliation manager grids, and the Show action to redisplay them.

  • Reconciliation Manager Extract Form

    Select the form for which transactions are to be extracted for reconciliation. The following options are available:
  • Standard displays transaction details including Ledger Analysis and currency Values 1, 2, 3 and 4
  • Simple displays transaction details including Ledger Analysis and currency Values 1, 2 and 3
  • Extended displays transaction details including Ledger Analysis, currency Values 1, 2 and 3, General Descriptions and Ledger Extension Data.

Analysis information will only be displayed for analysis which is not prohibited and General Descriptions will only be displayed if they are setup for use.

Note:  These forms are only available for reconciliations in the same business unit. When reconciling in different business units, a variation of the standard form will automatically be used.

Selection

  • Using these fields you can specify a value, or range of values, for each selection criteria to determine the transactions selected for reconciliation. Transactions for the reconciliation accounts are only selected if they match these selection criteria, and they fall within the overall transaction date range and other criteria identified above.

    Selection criteria only appear if they have been defined for the profile using Reconciliation Profiles (RCP).

Note: If you are using a reconciliation profile in which Allocation Marker is one of the selection criteria, you can use a '-' (hyphen) in the From/To fields to extract only the unallocated transactions.