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

#__Company Does Reconciliation__ \\Bank Supplies File With Cleared Checks
## Run [LMTD] to load a flat file 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’ ([UPPOSPAY]). (This list is sent each pay cycle.)
----
!!MANAGE LOADED CLEARED CHECKS
Checks loaded into the [P2K_PR_LOADED_CLEARED_CHECKS] table through [LMTD] may be viewed or corrected through the Manage Loaded Cleared Checks [IPCFB] form. The [LMTD] function is used to load external data from a flat file into the [{$applicationname}] tables.


----
!!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 [LMTD]) 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 $|DRV_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 $|DRV_ACTUAL] field equals the [Given $|DRV_GIVEN] field, then the [Reconcile button|ACT_RECONCILE] will become available.
#If you wish to actually perform the reconciliation, you need only to click on the [Reconcile button|ACT_RECONCILE] and all the cleared checks will be removed. The reconciliation may also be cancelled through the [Cancel Reconcile button|ACT_CANCEL_RECONCILE]. 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.
----
!!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|ACT_REPLACE_CHECK_MANUAL].

[CHECK RECONCILIATION PROCESS/ReplaceManual.JPG]

Once you have clicked the button, you will be presented with the following dialog [MPRCM] screen. 

[CHECK RECONCILIATION PROCESS/ReplaceCheckManual.JPG]

The [Check #|CHECK_NUMBER] 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 in the [Replace with Check #|DRV_REPLACE_CHECK_MANUAL] field, you may click the OK button to complete the process.

The [IPCH] screen will now display the change you’ve made. In the [Number|CHECK_NUMBER] field, you will see the new check number. In addition, on the right hand side of the screen, in the [Replaced #|CHECK_NUMBER] 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 [{$applicationname}].

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

Click on the [Replace with Next|ACT_REPLACE_CHECK_WITH_NEXT] button: 

[CHECK RECONCILIATION PROCESS/ReplaceNext.JPG]

Once you have clicked the button, you will be presented with the [MPRCN] dialog screen.
 
[CHECK RECONCILIATION PROCESS/ReplaceNextCheck.JPG]

The application will populate the [Replace with Check #|DRV_REPLACE_NEXT_CHECK_NUMBER] field with the next check in the range. If you are happy with the check number press OK, or Cancel to cancel the replacement. 

The original check will now be identified with the following:
*[Check Status|CHECK_STATUS] - Replaced Check
*[Check Type|CHECK_TYPE] - Void Check
*[Replaced #|CHECK_NUMBER] - the next check number used
*[Printed|CHECK_PRINTED] - this toggle will be set ON (if not already) to prevent it from being printed again.

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:
*[Check Status|CHECK_STATUS] -  Outstanding
*[Check Type|CHECK_TYPE] - Replacement Check
*[Replaced #|CHECK_NUMBER] - the original check number
*[Printed|CHECK_PRINTED] - this toggle will be set ON to prevent it from being printed automatically.


[{If var='loginstatus' contains 'authenticated'

----
![Discussion|Edit:Internal.CHECK+RECONCILIATION+PROCESS] 	
[{InsertPage page='Internal.CHECK+RECONCILIATION+PROCESS' default='Click to create a new discussion page'}] 	

}]