CHECK RECONCILIATION PROCESS
Back to current versionRestore this version

METHODS OF CHECK RECONCILIATION#

There are several methods of Check Reconciliation:
  1. Company Does Reconciliation
    Bank Supplies File With Cleared Checks
    1. Run LMTD to load a flat file to populate the Loaded_Cleared_Checks table.
    2. Use Maintain Loaded Cleared Checks (IPCFB) to make any corrections necessary
    3. Run Load Cleared Checks (UPCFB) to update the o/s check table with ‘cleared’ checks.
      • For any errors encountered on the report, you can either go to the IPCFB to change the data being cleared or IPCR to manually clear the checks
      • The checks are NOT physically removed but are removed from view in the Maintain Checks (IPCH) and Reconcile Outstanding Checks (IPCR) forms.
    4. Run Check Reconciliation (UPREC) <OPTIONAL>
      • Run in ‘Trial’ mode. This is a report of the statuses/balance of the checks
      • Run in ‘Update’ mode - The checks whose issued amount match the cleared amount will then be flagged as reconciled in the database. They do not get physically removed from the database.
  2. Manual Reconciliation
    1. Clear checks through the Outstanding Checks (IPCR) form.
  3. Bank Does Reconciliation
    1. Supply the bank with a file of ‘issued’ checks, also known as ‘Positive Pay’. (This list is sent each pay cycle.)

MANAGE LOADED CLEARED CHECKS#

Checks loaded into the Loaded_Cleared_Checks table through the SqlLoader may be viewed or corrected through the Manage Loaded Cleared Checks IPCFB form.

You may make use of the conversion function IVLOAD to load lines (records) from an outside flat file to Wiki tables. Type ‘IVLOAD’ into the command line and a small dialogue box will appear asking for the control file, F_loaded_cleared_checks.ctl. Enter the name of the control file, either from the working directory or prefixed by the fully qualified path. The control file must contain the path and name of the data file. This functionality can be used to load pay lines, cleared check records, or time clock entries.


LOAD CLEARED CHECKS#

If everything is fine with the loaded cleared checks, then they need to be loaded into the Outstanding Check form to update the checks that have cleared. The checks may be loaded through the Load Cleared Checks (UPCFB) form.

Cleared checks from the payroll banks must be loaded into the ‘Loaded Cleared Checks’ table (Via SqlLoader) before this function is run.

Checks are selected for one payroll bank per run and only outstanding checks on the check file can be cleared.

The cleared amount must match the check amount. If these amounts differ, then the check must be cleared manually. The record will be rejected with an error message.


RECONCILE O/S CHECKS#

All checks created through the UPDISB process will be displayed in the Reconcile O/S Checks (IPCR) form. These checks may be maintained manually or through loaded cleared checks.

You may store these checks through the Reconcile O/S Checks (IPCR) form.

Checks can be manually reconciled through the following process:

  1. Enter in total amount of checks cleared from bank statement in the Given $ field
  2. Manually enter each check amount from the bank statement for the appropriate check number. You may also double click on the field to have the system carry over the Issued Amount to the Cleared Amount column.
  3. When the Actual $ field equals the Given $ field, then the Reconcile button will become available.
  4. If you wish to actually perform the reconciliation, you need only to click on the Reconcile button and all the cleared checks will be removed. The reconciliation may also be cancelled through the Cancel Reconcile button. This will remove any amounts from the Cleared Amount column.
  5. Only outstanding checks are displayed.

REPORT CHECK RECONCILIATION#

Once you have completed the check reconciliation, you may produce a report through the Report Check Reconciliation (UPREC) form. This function is just a report in trial mode but will mark cleared checks as ‘reconciled’ when run in Update mode.

POSITIVE PAY#

Positive Pay is the process of periodically sending a list (via transmission file) of all issued and voided checks. This information allows the bank to reject attempts to cash checks not issued by the sending agent.

This service is not provided by all US banks and is not always called ‘Positive Pay’, however if the intent is the same, then Wiki will provide the functionality through the Generate Check File To Bank (UPPOSPAY) form. Wiki does not support the numerous banks out there, but can accommodate the support of other banks if required.

All checks that have been either issued or voided within the date range provided since the last time UPPOSPAY was executed are picked up and recorded in the output file.

Once UPPOSPAY is completed, the check record will be updated with the execution id of the UPPOSPAY run. The field is MEX_ID_SENT from the P2K_PR_CHECKS table.

All checks with a non-null MEX_ID_SENT will be bypassed on subsequent processing of the UPPOSPAY program.

Replacement checks as well as the associated void check are included.

Manual checks and manually voided checks are also included.

This function can be used to supply the bank with a list of issued checks if the bank is providing a reconciliation service.


CHECK REPLACEMENT#

Manual Check Replacement#

If you need to replace a check from a manual range of numbers, you may do so directly through the IPCH form by clicking the Replace in Manual Range button.

Once you have clicked the button, you will be presented with the following screen.

The Check # field will display the current check number, you will enter the replacement check number in the Replace with Check # field.

Once you have entered the replacement number, you may click the OK button to complete the process.

The IPCH screen will now display the change you’ve made. In the Number field, you will see the new check number. In addition, on the right hand side of the screen, in the Replaced # field, you can see the old check number.

Be sure to enter the correct check number here since correcting a mistake beyond this point requires DBA assistance.

At this point, you will need to go to UPSTUBC and ‘reprint’ the replacement check


Check Replacement With Next Check Number#

If an employee loses their check, you can create a replacement check within Personality.

Go to the Maintain Checks (IPCH) form and find the check number that has been lost.

Click on the Replace with Next button

Enter the next manual check number available, then click the OK button.

The original check will now be identified with the following:

A new line will have been created for the replacement check with the new check number, the original issue date, person code, name, and amount. This new check will be identified with the following: