| Legler Systems Company | | | CR System | | | Contact Us | | | Help | | | Home | | |
The Check Reconciliation System from Legler Systems supports multiple online users with special features for handling the bank reconciliation function in small and midsize enterprises. This customizable software can be run as a stand-alone accounting application or integrated with other financial modules, such as the Accounts Payable and Payroll Systems.
Online check reconciliation (CR) procedures are identified on the Check Reconciliation Menu shown below. Before any computer procedure can be run, the user must first sign-on by entering a valid User-ID and password. To start a specific CR procedure, enter the 2-digit number associated with that procedure.
CHECK RECONCILIATION MENU:
------------------------------------------------------------------------- | CHECK RECONCILIATION SYSTEM MENU (2005) 01-31-2005 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 92 - Redefine System Printer | | 07 - Purge Old CR Records 99 - End CR Menu | | | | Enter CR Procedure Number.......[ ] | | | |=========================================================================| | F1=Help F2=Enter F9=Print F10=Exit | -------------------------------------------------------------------------
Data entry procedure CR01 displays fields that comprise each check record and performs online file update functions (add, modify and delete). Generally, issued checks printed by the AP and PR Systems are automatically posted to the CR system, however manual checks can be entered directly online using this procedure.
Clear checks procedure CR02 enables the user to enter a single check number or a range of checks from the bank statement that have cleared the bank. For larger organizations, a magnetic tape or PC disk file of cleared checks received from the bank can be processed by procedure CR06 instead of using procedure CR02. Issued checks printed by other systems can be imported into the CR System using procedure CR08.
Inquiry procedure CR05 displays issued and cleared (paid by the bank) check information for a specific payee (vendor or employee), while CR10 displays a one-screen summary by month for 5 years of paid checks.
Reporting procedures CR03, CR04, CR11 and CR12 print reports on line printers (computer-size paper) or laser printers (letter-size paper). Each reporting procedure displays a screen for the user to enter selection criteria, report formatting and sorting options. Procedures CR02, CR06, CR07, CR08 and CR09 print a one-page control report showing the number of records processed for audit trail purposes.
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.
CHECK RECONCILIATION SYSTEM FEATURES:
In addition to the operational, security and technical features mentioned in the Accounting Software Summary, some key functional features of the check reconciliation module are highlighted below:
1. Automatic matching of paid or cleared checks against those issued by the company, including the automatic setting of a check status code to indicate the current status (issued, voided, cleared, etc.) of each check in the system.
2. Ability to import/export mass check information to/from the CR System is done using procedure CR09 where the user specifies the data fields to be processed.
3. Multiple bank accounts are supported in CR System.
4. The Print Check Register procedure CR03 has an option to print all missing check numbers for audit review by CR accounting procedure 04.
5. A batch date or bank statement date can be associated with each check cleared online to facilitate balancing checking accounts to bank statements.
6. Flexible reporting capability allows the user to request and print 25 different check reconciliation reports.
CHECK RECONCILIATION SYSTEM INTERFACE CAPABILITIES:
The online CR software references three records in the Database Control System to control basic system functions (Company Control Record), to verify User-IDs (User Control Record) and to validate Bank-IDs (Code Definition Records).
The CR System accepts check input directly from the Payroll System (optional) or the Accounts Payable System (optional) when computer checks are printed to avoid manual entry using procedure CR01.
The CR System software accepts a batch import file containing checks created by another computerized system (e.g. bank). Procedure CR09 is used to reformat a comma separated PC file into the check record format used by procedure CR08.
HARDWARE AND SOFTWARE REQUIREMENTS:
The Check Reconciliation System (CRS) runs on any compatible 386 or higher PC or UNIX based computer, such as the IBM RS/6000 with IBM 3151 terminals using the AIX operating system. The CRS software operates on personal computers running all versions of Windows from Windows 3.1 to Windows Vista in a local area network (LAN) using Microsoft BackOffice Server, NetWare or LANtastic with complete flexibility in specifying the location of all files on the client or server. The Run Time Environment for Micro Focus COBOL support is included at no extra cost with the DOS executable programs of the CRS COBOL software.
The Database Control System from Legler Systems Company is required to support the CR System. The CR source programs are written in COBOL for easy maintenance and portability. More bank reconciliation software is written in the COBOL language than any other programming language. All CR COBOL programs are Year 2000 compliant and allow the user to define different date formats (MO-DA-YR or YRMODA) for data entry and reporting purposes.
MORE INFORMATION AVAILABLE:
To request all sample reports and screen formats, a General Information Manual or PC demo on CD-ROM of the CR System, please e-mail Bill Legler in the San Francisco Bay Area, California.
New software features are described in the Version 8.0 Summary document.
The CR System software cost is identified in the Software Price Sheet.
Custom versions of the CRS software have been in day-to-day operation for the past 25 years.