| Legler Systems Company | | | CR System | | | Contact Us | | | Help | | | Home | | |
The Check Reconciliation System from Legler Systems is based on the client-server model and supports many special features for handling the bank reconciliation function in small and midsize companies. This customizable software can be run as a stand-alone accounting application or integrated with other financial modules, such as the Accounts Payable System and Payroll System.
New 2010 features of the CR software support real-time dashboards for all check transactions and separate report windows that enable the user to view a report at the same time as performing data entry operations in the original window, as described in the Version 10.0 Summary document. These real-time dashboards are shown below the check reconciliation menu when using large screens. The 2009 check reconciliation software features include mouse support and large screen (50x80) support, as described in the Version 9.0 Summary document. This check reconciliation system can function with or without a mouse for greater user flexibility and productivity. Prior software enhancements are described in Version 8.0 Summary. The newest check reconciliation software features execute faster when running Microsoft Windows XP or Windows 7.
Custom versions of the online CRS software have been in day-to-day operation in small businesses in Northern California for over 25 years.
The online check reconciliation (CR) user procedures are identified on the Check Reconciliation menu shown below. Before any CR 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 user procedure.
---------------------------------------------------------------------------- | CHECK RECONCILIATION SYSTEM MENU (2010) 01-15-2010 13:34 | |============================================================================| | | | 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 Month | | 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 94 - Search CR System | | 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 System and PR System are automatically posted to the CR system, however manual checks can be entered directly online using procedure CR01.
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). The Oustanding Checks Report (CR04) is used in balancing checking account amounts to the bank statement. 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.
The CR procedures identified on the Check Reconciliation menu are described in the CR Menu Procedures document.
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 procedure CR04.
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, including the Outstanding Checks Report by procedure CR04.
7. For real-time dashboard 4, the oldest ten outstanding checks that have not cleared the bank are shown under the check reconciliation menu.
The online CRS software references three records in the Database Control System (required) 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 data entry using procedure CR01.
This bank reconciliation software accepts a batch import file containing issued or cleared 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 to load these check records into the CR System.
The Check Reconciliation System (CRS) operates on personal computers (pc) running Microsoft Windows XP, Windows 7, Windows 98 and Windows 3.1 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. Additionally, the CRS software can be run on a single stand-alone pc or on a UNIX based computer, such as the IBM RS/6000 with IBM 3151 terminals using the AIX operating system.
The Run Time Environment for Micro Focus COBOL support is included at no extra cost with the CRS executable programs. The Windows check reconciliation programs are the same as the DOS check reconciliation programs for compatibility and can be run also from a removable disk, such as a CD-ROM or USB flash drive.
The Database Control System from Legler Systems Company is required to support the CR System. The CR source programs are written in COBOL, the most widely used business programming language. All CR COBOL programs allow the user to define different date formats (MODAYR or YRMODA) for data entry and reporting purposes, as well as other system-wide options.
The CR System software cost is identified in the Software Price Sheet.
Other online accounting modules are listed in the Accounting Software Summary document.
To request sample reports and screen formats, General Information Manual or free pc demo on CD-ROM of the CR System, please e-mail Bill Legler in the San Francisco Bay Area, California.
Legler Systems Company, developer of the online Check Reconciliation software, is located in the East Bay of the SF Bay Area in Northern California and provides local on-site CRS software support in Alameda County (major cities are Oakland, Fremont, Hayward and Berkeley), Contra Costa County (major cities are Concord, Antioch and Walnut Creek) and other counties in California (CA). Telephone and e-mail support is available throughout the United States (USA).