| Legler Systems Company | | | CR System | | | Contact Us | | | Help | | | Home | | |
The Check Reconciliation System (CRS) from Legler Systems is based on the client-server model and supports many special features for handling the bank reconciliation function in small businesses 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 (vendor checks) and Payroll System (payroll checks). The Legler Check Reconciliation software utilitzes a character-based user interface with mouse support for fast data entry and optimum performance.
The 2012 CR software includes a new update procedure CR14 (Clear Bank Paid Checks), a new inquiry procedure CR96 (Inquire Latest CR Changes) plus other enhancements. The 2011 CR software update provided a real-time Cash Management Dashboard that shows the current cash account balance from the last GL closing, as described in the Version 10.2 Summary document. The 2010 CR software update included 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. The 2009 check reconciliation software update included mouse support (left mouse button) and large character-based window (80x50) 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. The newest check reconciliation software executes 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 online CR procedure can be run, the user must first sign-on by entering a valid User-ID and password. To display the Check Reconciliation menu, enter only "CR" on any financial menu. To start a specific CR procedure, enter the 2-digit number associated with that online procedure or single-click the left mouse button when pointing to the procedure name on the menu.
----------------------------------------------------------------------------- | CHECK RECONCILIATION SYSTEM MENU (2011) 11-05-2011 14:24 | |=============================================================================| | | | 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 13 - Inquire by Check Amount/Payee | | 07 - Purge Old CR Records 14 - Clear Bank Paid Checks | | 92 - Redefine System Printer | | 94 - Search CR System | | 96 - Inquire Latest CR Changes | | 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 (vendor checks) and PR System (payroll checks) are automatically posted to the CR system, however manual checks can be entered directly online using procedure CR01.
Clear check 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. Clear Bank Paid Checks procedure (CR14) is similar to CR02, except all outstanding checks are displayed for the user to flag just those checks that have been cleared (paid by) the bank without having to enter the check numbers. 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. Procedure CR13 allows you to search for a specific check amount. Inquire Latest CR Changes procedure (CR96) displays a list of the latest Check Records (CR01) in descending chronological date sequence.
Online reporting procedures CR03, CR04, CR11 and CR12 print management reports on a line printer (computer-size paper) or a laser printer (letter-size paper). Management reports can be displayed on the screen in a separate report window prior to printing a hardcopy. The Outstanding Checks Report (CR04) is used in balancing checking account dollar amounts to the bank statement. Each online reporting procedure displays a screen for the user to enter report selection parameters, such as dates, 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 online CR procedures identified on the Check Reconciliation menu are described in more detail 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 checking accounts are supported in the Legler CR System.
4. The Print Check Register procedure CR03 has an option to print all missing check numbers for audit review and comparison to the report printed by 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 online reporting procedures allow the user to request and print 25 different check reconciliation reports by specifying various report selection parameters. For example, the Outstanding Checks Report procedure CR04 prompts the user for the Bank-ID, ending date and sort option.
7. For real-time List Dashboard (No. 4), the oldest ten outstanding checks that have not cleared the bank are shown under the check reconciliation menu. Up to 4 different real-time dashboards can be displayed: two real-time Bar Chart Dashboards and two real-time List Dashboards.
8. Support batch job processing (optional), where report selection parameters are entered online for later batch processing by a separate job script.
9. Enable payee name lookup by name by entering "#" for the payee number and then enter part of the payee's name when prompted. When only one matching payee is found, the assoicated payee number automatically replaces the "#" character, so the user does not have to enter the payee number. This payee number lookup procedure can be done at any time where the Payee-Code prompt appears.
The online CR 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 the Bank-ID codes (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 file into the Check Record format used by procedure CR08 to load these Check Records into the CR System.
The CR software supports dynamic linking to data entry procedures (such as CR05 to CR01) with a single key stroke (function key F7) or double-click of the left mouse button.
The Check Reconciliation System operates on any x86 personal computer (pc) in the Command Prompt window using Microsoft Windows XP, Windows 7, Windows 98 and Windows 3.1. The pc can be connected in a local area network (LAN) with complete flexibility in specifying the disk location of master 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. In addition to the standard screen size (80x25), a larger character-based window of 80 characters wide by 50 rows is now supported for greater usefulness.
The Run Time Environment for Micro Focus COBOL support is included at no extra cost with the CR executable programs. The Windows check reconciliation programs are the same as the DOS check reconciliation programs for compatibility. For data archiving and historical reporting, the same CR executable programs can be run from a removable disk, such as a CD-ROM or USB flash drive; thereby eliminating the need to restore old check data and programs to a separate hard disk drive.
The Database Control System from Legler Systems Company is required to support the CR System and is included with the Check Reconciliation software. The CR source programs are written in COBOL, the most widely used business programming language. Each CR procedure corresponds to a separate COBOL program.
The CR System software cost is identified in the Software Price Sheet.
To request sample management reports and screen formats, General Information Manual or free pc demo on CD-ROM of this 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). Free e-mail and telephone support is available throughout the United States (USA).