Check Reconciliation Features:
The primary objective of the Check Reconciliation (CR) System from Legler Systems
is to process check information in an online environment, so specific online
procedures are performed in seconds rather than the hours required by
traditional batch methods of computer processing. This CR System performs the
basic check reconciliation objectives by providing a complete and accurate
record of all company check transactions affecting each vendor and employee.
Specific Check Reconciliation features and objectives of this software are
highlighted below:
- Maintain a separate Check Record by check number containing dollar
amounts paid to vendors, employees and others. Check-Status code,
date issued and date cleared (paid by the bank) are also in the
Check Record.
- Identify the outstanding checks as of a specific date to balance to
the bank statement.
- Print accounting reports, such as Check Register, Check Records List
and Outstanding Check Report, so adequate audit control is
maintained.
- Automatically calculate the average number of elapsed days between
the check issue date and the date the check clears the bank for
cash management analysis.
- Interface with the Accounts Payable System and Payroll System to
automatically accept Check Records from these systems when checks
are printed (issued). This check reconciliation feature minimizes
clerical data entry operations.
- Handle the entry of manually issued checks at the time vendor invoices
or employee labor records are entered online into the AP System or
the PR System.
- Provide inquiry capability (displaying information on a terminal)
to identify which checks have been issued to a specific payee
(vendor in the AP System or employee in the PR System).
- Automatically identify missing check numbers (gaps in the check
number range) in the Check Register report when the check number
option is specified.
- Accept bank input file of canceled checks (paid) to update Check Records
as cleared, rather than manually run procedure CR02 or CR14.
- Handle multiple bank accounts, however the check numbers must be
unique within each Bank-ID.
- Provide auxiliary input capability for importing issued checks and
cleared checks created by other computerized systems.
- Provide the capability to create custom CR reports where the user
defines the data fields to be selected, sorted and printed (procedure DB12).
- Provide import and export capability (CR09) using any PC ASCII file
(comma separated fields) containing issued or paid checks.
- Automatically display a detail record (Check Record) when function
key F7 is pressed from inquiry procedure CR05. This
check reconciliation objective enables the operator to quickly
drill down to more information.
- Define an Active Flag for the Bank-ID code to prohibit the online entry
of new check information for an inactive Bank-ID and Location Code,
yet reference those old codes for historical reporting purposes.
- Handle any fiscal year for accounting purposes, even one different
from the calendar year, through the use of a separate accounting
period number (YRMO) field.
- Verify the check amount is greater than zero (positive) during data entry
procedure CR01.
- Verify the state code and ZIP code (first 3 digits) associated with
the payee address. The Canadian province code is validated when
the ZIP code is not numeric.
- Update multiple checks at one time as cleared by specifying a check
number range in procedure CR02 to speed manual data entry. A new
procedure (CR14) displays all unpaid checks so the operator can flag
just those checks paid by the bank, as shown on the bank statement.
Both online procedures (CR02 and CR14) change the value of the
Check-Status code to "C" (cleared) for improved clerical productivity.
- Provide source document control over input check transactions to the
computer by establishing batch numbers.
- Provide system options in the Company Control Record to handle
6-digit or 8-digit dates for user preference.
- In addition to online processing, batch job processing is supported where
CR report requests are entered online for later batch processing.
As computer checks are issued to vendors, employees and others during
the accounting period, they are also entered into the Check Reconciliation
System automatically by the Accounts Payable System and the Payroll System
when System-Option-20 (DB03) is set to "1". Otherwise, issued checks are
entered online using procedure CR01 or by batch input using procedure CR08
with the Check-Status code set to "I" (issued).
The CR System procedures that can be run by the user are identified in the
Check Reconciliation Menu document.
Check Record:
Information on each check issued to a vendor or employee, including payee
name, date, Check-Status code and dollar amount is stored in a Check Record.
Online procedure CR01 is used to add, change (modify), query and delete
Check Records. Procedure CR02 or CR14 is used to clear a group of checks by
updating each Check Record paid by the bank.
The primary key of the Check Record is the Record-Type code, Bank-ID and
check number.
More Information on Check Reconciliation Objectives:
For additional information on this online Check Reconciliation software,
please e-mail Bill Legler in the SF Bay Area, California
or go to the main Check Reconciliation System page.
Version 7.11 - Copyright 2010 by Legler Systems Company. All rights reserved.