Check Reconciliation System Reports by Legler Systems in CA

Legler Systems Company

CR Reports

Check Reconciliation System Reports

The check reconciliation reports can be requested at any time, sorted and printed on a standard line printer or a laser printer. Most check reconciliation reports are 120 characters wide (landscape), while some audit control reports are 80 characters wide (portrait). Also, the standard check reconciliation reports can be written to a temporary disk file for subsequent viewing in a separate report window by using procedure 92V or 92W.

A new 2018 option (Sys-Opt-44 in DB03) converts all uppercase letters to upper and lowercase letters when check reconciliation reports are printed for easier reading.

The standard check reconciliation reports are Check Register, Outstanding Checks Report, Check Analysis Report and Check Records Report. Each of these standard reports have several variations based on selection parameters entered online by the user. Some 24 accounting and management reports printed by the Check Reconciliation System from Legler Systems are identified below.

List of Check Reconciliation Reports:

     PROC S  B   Check Reconciliation Report name and description
      --  -  -   ---------------------------------------------------------
  1.  02  N  N   Cleared Checks Report by bank ID code.
  2.  03  N  Y   Check Register by accounting period range.
  3.  03  N  Y   Check Register by check date range.
  4.  03  N  Y   Check Register by check number range.
  5.  03  N  Y   Check Register by bank ID code (4).
  6.  03  N  Y   Check Register by check status code (4).
  7.  03  N  Y   Check Register by batch number (4).
  8.  03  N  Y   Check Register by location code (4).
  9.  03  N  Y   Check Register by payee code (4).
 10.  03  N  N   Check Register Summary by check status code and date (5).
 11.  04  Y  Y   Outstanding Checks Report by bank ID code (4).
 12.  06  N  N   Bank Input Report by bank ID code (4).
 13.  07  N  N   CRS Purge Control Report by period range - Counts only.
 14.  07  N  N   CRS Purge Control Report by period range - File update.
 15.  08  N  N   CRS Batch Input Report - Preliminary.
 16.  08  N  N   CRS Batch Input Report - Final.
 17.  09  N  N   Import Control Report.
 18.  09  N  N   Export Control Report.
 19.  11  N  Y   Check Analysis Report by check date range.
 20.  11  N  Y   Check Analysis Report by bank ID code (4).
 21.  12  Y  Y   Check Records Report by check date range.
 22.  12  Y  Y   Check Records Report by bank ID code (4).
 23.  12  Y  Y   Check Records Report by check status code (4).
 24.  12  Y  Y   Check Records Summary by check status code (5).

--------------------------------------------------------------------------
Notes:
 1.  Column "PROC" refers to the online procedure number on the CR menu.
 2.  Column "S" means sort by check number, check issue date or check
       clear date when 'Y', otherwise 'N' means no record sorting.
 3.  Column "B" indicates both online processing and batch job processing
       is available when 'Y', otherwise 'N' means no batch processing,
       only online processing.
 4.  These check reconciliation reports can be printed for a single bank-ID
       or all bank-ID codes.
 5.  Summary reports are printed when the 'Entry Correct' prompt = 'S'.
--------------------------------------------------------------------------

In addition to the standard check reconciliation reports identified above, custom check reconciliation reports can be created, sorted and printed by procedure DB12 in the Database Control System, where the user specifies the data content and report format.

The online procedures that print these check reconciliation reports are described in the Check Reconciliation Menu document.

More Information on the CR Software:

Any questions about these Check Reconciliation System reports, e-mail Bill Legler in the SF Bay Area, California or go to the Check Reconciliation System main page.