[{TableOfContents }]
[{TableOfContents }]
!!METHODS OF CHECK RECONCILIATION
There are several methods of Check Reconciliation:

#__Company Does Reconciliation__ \\Bank Supplies File With Cleared Checks
## Run SqlLoader to populate the Loaded_Cleared_Checks table.
## Use Maintain Loaded Cleared Checks ([IPCFB]) to make any corrections necessary
## 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.
## 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.
# __Manual Reconciliation__
##Clear checks through the Outstanding Checks ([IPCR]) form.
# __Bank Does Reconciliation__
##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 [{$applicationname}] 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:
#Enter in total amount of checks cleared from bank statement in the Given $ field
#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.
#When the Actual $ field equals the Given $ field, then the Reconcile button will become available.
#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.
#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 [{$applicationname}] will provide the functionality through the Generate Check File To Bank ([UPPOSPAY]) form. [{$applicationname}] 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.