Overview of Reconciliation Exceptions

A reconciliation exception occurs when the autoreconciliation program can't find an application transaction to match with a particular bank statement line.

Exceptions are classified as the following:

  • Ambiguous: This exception occurs when either there is more than one application transactions that could match to the line or the transaction could match to more than one statement line.

  • Date: This exception occurs when a system transaction meets all the matching criteria except the date of the transaction is out of the tolerance range.

  • Amount: This exception occurs when a system transaction meets all of the matching criteria except the amount of the transaction is outside the tolerance range

Automatic Reconciliation Exceptions

For each one to one automatic reconciliation rule, exceptions are looked for in the following order:

  1. Ambiguous

  2. Date

  3. Amount

If an exception type is found for a given bank statement line the program stops looking for other types of exceptions using the same rule.

The exceptions are presented to you in the context of the bank statement line so the appropriate matching system transaction can be selected and reconciled.

If an application transaction is an exception to more than one bank statement line it can only be selected to reconcile with one of the statement lines.