Reconciling Your Payroll To The Bank File
Of course the balance of the file you are sending to the bank should equal your payroll reconciliation but if it doesn't it can be a messy business to work out why.
Accordingly The Acolyte is pleased to release a utility that will analyse a bank file and reconcile it to your Oracle payroll reconciliation report and, what's more, it's free.
Simple select the location of the bank file and a file containing the equivalent payroll reconciliation and click "Go"
The utility caters for multiple bank accounts and multiple entries on the payroll rec. (which occurs when you have multiple active assignments).
After loading the two files the utility displays a list of discrepancies.Click on one of these then click "Details" and you will see the transactions on the bank tape and the entries in the payroll reconciliation that differ.
It is currently configured for Australia payroll. If you would like a copy email me and I will send you one. You will need a copy of MSAccess installed on your PC to run it.