Reconciliation Facility

Control-M/Analyzer includes a Reconciliation facility that can be used to

• reconcile data from two different sources

  Comparing data from two different sources (for example, files) is an integral aspect of data balancing. A typical example is check reconciliation: A check register, updated on-line by a clerk as each check is written, is periodically compared to an automatically generated bank statement. Two files are involved in the process:

  • check register – record of checks as they are issued
  • bank statement – record of checks that cleared the bank during the week or month

  Reconciliation is necessary to verify that the data from both sources match.

  The sequence of the two files is not identical. The check register is typically in check number order. The bank statement is typically in clearance date order.

  The Control-M/Analyzer Reconciliation facility verifies that each check that appears in one file also appears in the other and that the check amounts are identical. Control-M/Analyzer prints out non-matching checks.

• facilitate processing of large files by providing summary records

  A typical example involves a large sequential file that must be checked. Each record in the file belongs to one of a hundred categories. Control-M/Analyzer summarizes the records by category and prints out the total amount for each category.

  The Control-M/Analyzer Reconciliation facility is implemented by the CTBRECL program that is invoked through a DO CALLUSER statement. For a full description of the DO CALLUSER statement, see DO CALLUSER: Automated Balancing Statement.