Interpret Match Status for Cash Reconciliation

The Cash Recon first matches previously unmatched activity with all new cash activity, comparing different sets of data sources and inspecting designated field differences for acceptable tolerances. Each set of matched cash activity records is assigned a status, based on the severity of the field differences, if any. The status is determined by examining the status of each field reconciled. The most severe status for any field is the overall status for the matched set of records.

For example, a cash reconciliation for a set of fields is considered out of balance if any of the fields are out of balance. Conversely, the cash reconciliation is considered in balance only if all fields are in balance.

The cash activity statuses assigned during reconciliation follow:

  • Unmatched (Status 0). Record has not yet been successfully matched.
  • Auto Recon (Status 1). Matched records are the same for all fields reconciled.
  • Auto Recon With Tolerance (Status 2). Matched records have at worst only records that differ within tolerances.
  • Out-of-Balance (Status 4). Matched records have one or more fields that equal or exceed the tolerance for that field.
  • Manual Recon (Status 5). Manually match record (Local only). Unmatched records that were manually matched using the manual reconciliation process.

The automated reconciliation process assigns all statuses except Manual Recon.