Note: only one
person can be running any part of bank reconciliation at a time.
___ (One Time Only) On the
PC, create the following path for cancelled check files: C:\SKILTRAN\BNKREC
___ Receive the cancelled
check file from the bank and copy it into the C:\SKILTRAN\BNKREC directory,
renaming the file CHECKS.IN.
Note: getting the file from the bank to your PC is between your organization and your bank. SkilMatch will provide assistance if possible, but you may wish to work with your bank for optimum results.
___ After the file has been
received, open the ES session by double-clicking the ES icon on the PC desktop.
Note: it is NOT necessary to sign onto the ES session.
___ Go to the “Cancelled
Payroll Checks” menu as follows:
On the “PayBill Library
Master” menu, click [Bank Functions].
On the “PayBill Library
Bank Reconciliation” menu, click [Go To The Upload Cancelled Checks Menu].
___ Upload the file to the
IBM Server
On the “Cancelled Payroll
Checks Upload” menu, click [Upload].
(This
transfers/translates the PC file to the IBM Server)
___ Edit the uploaded file
On the “Cancelled Payroll
Checks Upload” menu, click [Reformat and List].
(This will adapt the file
to SkilMatch bank reconciliation format and will produce an edit).
Note: enter the bank account number of the checks
being uploaded when requested to do so.
This must be entered exactly
as it is in the Bank Account/GL Account cross-ref file. An edit listing will be produced which will
indicate errors in the uploaded records (invalid check#, differing check
amounts, etc.), and print total number of checks & amounts.
Note: keep this edit. The totals on
this report are what the bank processed. If you make corrections to any entries before updating the
SkilMatch bank rec file, journal
entries would be required to reflect the difference between the amount
processed by the bank (the amount on the report produced by Menu BRUPLD, Item
Reformat and List) and the amount that was recorded in SkilMatch (the amount on
the report produced by Menu PBBANK, Item Print).
___ List only uploaded checks in error
On the “Cancelled Payroll
Checks Upload” menu, click [Error].
Note: if a large number of checks have been uploaded, this option can be used to produce a listing of only error checks. Research and an action must take place before these records can be used by the SkilMatch bank reconciliation.
___ Add the uploaded file to the bank rec data
entry file
On the “Cancelled Payroll
Checks Upload” menu, click [Add].
Note: this will add ALL uploaded checks into the data entry file for bank rec, replacing the need for keying cancelled check data into the system.
___ Correct uploaded check
errors.
Note: after Item [Add] has been run, this option
will allow errors listed in Item
[Error] to be corrected. It is used to
access only checks that were entered by means of an upload. Checks entered through manual bank rec data
entry cannot be accessed by this option.
Note:
all errors listed in Item [Error] must be corrected before proceeding.
___ Go to the “PayBill Library Bank
Reconciliation” menu as follows:
On the “Cancelled Payroll
Checks Upload” menu, click [Go To The Payroll Bank Reconciliation Menu].
___ (OPTIONAL) If you have additional checks to
enter manually:
On the “PayBill Library
Bank Reconciliation” menu, click [Enter].
On the “PayBill Library
Bank Reconciliation” menu, click [Enter Range].
___ Print a list of outstanding, reconciled,
and voided checks.
On the “PayBill Library
Bank Reconciliation” menu, click [Print].
Note: review this list to verify that all checks are correctly recorded as outstanding, reconciled, voided, and/or deleted.
Note: journal entries would be
required to reflect the difference between the amount processed by the bank
(the amount on the report produced by Menu BRUPLD, Item Reformat and List) and
the amount that was recorded in SkilMatch (the amount on the report produced by
Menu PBBANK, Item Print).
___ (OPTIONAL) If you find errors on Item [Print],
make corrections.
On the “PayBill Library
Bank Reconciliation” menu, click [Add].
Note: this option allows you to change the status of an existing check in the bank rec file from/to: (O)utstanding; (R)econciled; (V)oided, (D)eleted. Make sure you are in CHANGE mode to make changes to existing checks in the bank rec file.
___ Update the check file
On the “PayBill Library
Bank Reconciliation” menu, click [Update].
Note: this option removes all checks (that have any status other than (O)utstanding) from the bank rec file.
___ (OPTIONAL) Print a list of outstanding,
reconciled, and voided checks.
On the “PayBill Library
Bank Reconciliation” menu, click [Print].
Note: if this option is processed immediately following Item [Update], every check remaining in the bank rec file should appear as (O)utstanding.