Home
Who's who
Imports from ESR
Copy Pay Advice
Pay Office Staff File
Consultancy
Links
Contact
ESR
connect
LTD
TM
-
Copy Pay Advice
Copy Pay Advice spreadsheet:-
Separate file imported from ESR for each pay period
Shows pay and deductions for each employee
Other fields e.g. payscale, organisation for analyses
“Total” line shows Gross, Total Deductions, Net Pay
Hyperlinks to automatically skip to previous and next period.
Supplementary payrolls, "no pay" periods handled automatically
Historical data can be loaded at any time
Generated spreadsheets:-
All columns have Excel “Auto filters”
For payclerk message / initials to show item has been checked
Spreadsheet saved for shared use – more than one clerk can be checking at the same time
Date & time when entries made are automatically recorded
For large organisations, Excel sheet overflow handled automatically
"Index" file lists all employees / pay periods, with hyperlinks to each period
Other facilities:-
Automatic hyperlinks from "Employee Run Results" spreadsheet for an instant breakdown of Gross, Net pay.
Extract all payslips for an employee over a period of time
Extract list of employees with specified payments / deductions
Both of these have "wild card" search facility
Extract list of employees who have not received pay for some time
Copyright © Paul Reade 2007 All Rights Reserved