| Legler Systems Company | | | CR Menu | | | Contact Us | | | Help | | | Home | | |
The latest version of the Check Reconciliation System menu from Legler Systems identifies 16 separate check reconciliation (CR) computer procedures that can be run by the user, provided the user has access to that procedure. Access control is specified in the User Control Record (DB08). Each CR user procedure corresponds to a separate computer program.
A sample Check Reconciliation System menu screen is shown below and followed by a definition of each user procedure.
--------------------------------------------------------------------------- | CHECK RECONCILIATION SYSTEM MENU (2010) 07-02-2010 13:23 | |===========================================================================| | | | No Procedure Name No Procedure Name | | -- ------------------------------- -- ----------------------------- | | 01 - Enter Check Records 08 - Process CR Batch Input | | 02 - Clear Check Records 09 - Import/export Pc-Ascii File | | 03 - Print Check Register 10 - Inquire Check History By Mo | | 04 - Print Outstanding Checks Report 11 - Print Check Analysis Report | | 05 - Inquire Payee Check History 12 - Print Check Records List | | 06 - Process Bank Input File 13 - Inquire By Check Amount/Payee | | 07 - Purge Old CR Records 92 - Redefine System Printer | | 94 - Search CR System | | 99 - End CR Menu | | | | Enter CR Procedure Number.......[ ] | | | |===========================================================================| | F1=Help F2=Enter F9=Print F10=Exit | ---------------------------------------------------------------------------
Procedure CR01 is used to enter vendor and payroll checks and update the status of existing checks in the CR System. Normally, when vendor checks are printed by AP06 in the AP System and payroll checks are printed by PR05 in the PR System, a Check Record (CR01) is automatically created in the CR System for each check printed. Computer procedure CR01 is run as needed.
Procedure CR02 is used to clear a group of checks that have been paid by the bank, as shown on the monthly bank statement. A Control Report (CR02) is printed identifying all checks that have been cleared. Computer procedure CR02 is done at the end of the month.
Procedure CR03 is used to print the Check Register of all checks in the CR System, including those issued by the AP System and PR System. The Check Register (CR03) is used to balance to the bank statements.
Procedure CR04 prints the Outstanding Checks Report identify all checks that have not cleared the bank (e.g. paid by the bank) as of a specific date. The Outstanding Checks Report (CR04) is used to balance to the bank statement. Computer procedure CR04 can be run at any time.
Procedure CR05 displays a window of all checks associated with a specific payee. Computer procedure CR05 can be performed at any time.
Procedure CR06 reads a special Bank Input File of cleared checks and reformats them to the Check Record format in the CR System. Computer procedure CR06 is optional.
Procedure CR07 purges old Check Records (CR01) and is infrequently run by supervisory personnel. A control report (CR07) is printed identifying the number of records in the CR System, as well as the numbr of records purged, fi any.
Procedure CR08 processes a group of issued or cleared checks in the Transfer File and creates new Check Records (CR01) or updates existing Check Records that were created by another computer system or procedure. Program edits are performed on each record, similar to online procedure CR01, before processing. A Control Report (CR08) is printed identifying any errors and record counts for audit control.
Procedure CR09 imports check data from a comma separated file and reformats the data to the Check Record format. Also, procedure CR09 can export selected check data to a comma separated file for use by other computer software. A Control Report (CR09) is printed for audit control. Imported checks must be processed by procedure CR08 to update the online database.
Procedure CR10 displays a window showing the total check payments by month for the last 5 years made to vendors or employees. This CR user procedure can be run at any time to display check history.
Procedure CR11 prints a one-page Check Analysis Report summarizing check information by the amount of the check, elapsed days between issue date and clear date and payee state. The Check Analysis Report (CR11) is used for management purposes.
Procedure CR12 prints the Check Records List containing three columns of check numbers when print an audit report of checks in the CR System. Any missing check numbers are identified in the Check Records List (CR12). Procedure CR08 is similar to procedure CR08.
Procedure CR13 selects and displays a window showing checks by check amount or the payee code entered by the user. The CR94 search differs only in how the results are displayed. Computer procedure CR13 can be run at any time.
Redefine system printer procedure CR92 allows the user to redefine where the reports are to be printed. If a disk file is specified, the report is written to disk from which it can be displayed in a pop-up report window (92V) and then printed on paper by pressing function key F9. The computer program associated with procedure CR92 is the same for all accounting modules. Computer procedure CR92 can be done at any time.
Procedure CR94 is used to search the CR System for any dollar amount, code or text in the last x months and display a window of the search results. The computer program associated with procedure CR94 is the same for all accounting modules. This CR user procedure can be started at any time to look for any employee or vendor check information.
Procedure CR99 closes the Check Reconciliation System menu and displays the main financial menu. To switch to another system procedure, just enter the System-ID and procedure number, rather than CR99.
To request additional information on the CR software, please e-mail Bill Legler in the SF Bay Area, California or go to the Check Reconciliation System main page.