Converting Payment Summary To A Text File
Need to convert your ATO Payment Summary Data file to a text file. Here is a little utiltiy to do it for you.
June 26, 2007
April 07, 2006
Oracle Pay Reconciliation In a Spreadsheet
Fancy having your Oracle Payroll reconciliation in a spreadsheet in a usable form. Here is a spreadsheet to do it.
Simply open the spreadsheet. You will be promped for the location of the payroll reconciliation report produced by Oracle PAY. It is loaded with one row per person and one column per field.
March 19, 2006
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.