This page (revision-26) was last changed on 26-Nov-2021 10:22 by RForbes

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
26 26-Nov-2021 10:22 7 KB RForbes to previous
25 26-Nov-2021 10:22 7 KB RForbes to previous | to last
24 26-Nov-2021 10:22 7 KB RForbes to previous | to last
23 26-Nov-2021 10:22 8 KB JEscott to previous | to last
22 26-Nov-2021 10:22 7 KB JEscott to previous | to last
21 26-Nov-2021 10:22 7 KB JEscott to previous | to last

Page References

Incoming links Outgoing links
CHECK RECONCILIATION PROCESS
CHECK RECONCILIATION PROCESS

Version management

Difference between version and

At line 1 added 2 lines
[{TableOfContents }]
!!METHODS OF CHECK RECONCILIATION
At line 4 changed one line
## Run SqlLoader to populate the Loaded_Cleared_Checks table.
## Run [LMTD] to load a flat file to populate the Loaded_Cleared_Checks table.
At line 15 changed one line
##Supply the bank with a file of ‘issued’ checks, also known as ‘Positive Pay’. (This list is sent each pay cycle.)
##Supply the bank with a file of ‘issued’ checks, also known as ‘Positive Pay’ ([UPPOSPAY]). (This list is sent each pay cycle.)
At line 18 changed one line
Checks loaded into the Loaded_Cleared_Checks table through the SqlLoader may be viewed or corrected through the Manage Loaded Cleared Checks [IPCFB] form.
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 Personality tables.
At line 20 changed one line
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.
At line 25 changed one line
Cleared checks from the payroll banks must be loaded into the ‘Loaded Cleared Checks’ table (Via SqlLoader) before this function is run.
Cleared checks from the payroll banks must be loaded into the ‘Loaded Cleared Checks’ table (via [LMTD]) before this function is run.
At line 37 changed one line
#Enter in total amount of checks cleared from bank statement in the Given $ field
#Enter in total amount of checks cleared from bank statement in the [Given $|DRV_GIVEN] field
At line 39 changed 2 lines
#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.
#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.
At line 48 added 71 lines
----
!!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 Personality will provide the functionality through the Generate Check File To Bank ([UPPOSPAY] or [UPPOSPAYW]) form. Personality 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 UPPOSPAYx was executed are picked up and recorded in the output file.
Once UPPOSPAYx is completed, the check record will be updated with the execution id of the UPPOSPAYx 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] or [UPPOSPAYW] 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.
----
![Notes|Edit:Internal.CHECK+RECONCILIATION+PROCESS]
[{InsertPage page='Internal.CHECK+RECONCILIATION+PROCESS' default='Click to create a new notes page'}]
This page (revision-26) was last changed on 26-Nov-2021 10:22 by RForbesTop