Accessing detail transaction reconciliation

Transaction interface records can be manually added or created from a third party source using Infor Spreadsheet Designer (ISD). After the interface transactions are available, you can perform detail transaction reconciliation from a reconciliation.

Use this procedure to open a reconciliation and start the detail transaction reconciliation process:

  1. Select Reconciliation > Reconciliations or Reconciliation > My Reconciliations.
  2. Open a period reconciliation record.
  3. Click Detail Transaction Reconciliation.

Reconciling detail transactions

  1. Click Load and Reconcile.
  2. Specify the period and click Submit.

    The match rules that are set up for detail reconciliation are applied. All Global Ledger transactions and interface transactions for the account are grouped into matched and unmatched.

  3. Optionally, click Refresh.
  4. On the Unmatched Transactions tab, you can perform these actions:
    • Select Transaction:

      Use to view the transaction on the Selected Transactions tab.

    • Create Distribution:

      Use to adjust journal entries. For example, write off of an item and amount.

    • Create Reconciling Item:

      Use to move transactions to the next period. All reconciling items remain in the reconciliation queue and are included in subsequent detail reconciliations for the account.

  5. On the Matched Transactions tab, verify whether the transaction is reconciled. Some transactions are matched but not reconciled because of the reconciled difference amount.

    If the reconciled difference is within the tolerance that is defined on the match rule, then a distribution is created to write off the difference. If the transaction is not reconciled, then you can perform these actions:

    • Reconcile Transaction
    • Unmatch Transaction
    • Create Distribution
    • Create Reconciling Item
  6. Click Save Detail Transaction Reconciliation.
  7. Specify the period and click Submit.