Hello,
I was just informed that our payroll department are calculating manually (instead of system based) the base pay differences when:
1) an employee starts mid month - eg. if the employee starts in Jan 6th - they would pay the full month minus 6 days).
then they calculate (number of days in month - minus 6 divided total month days *salary - to see how much is due)
*****If an employee started in the same month at the payroll - then the number of days not worked is deducted
*****If an employee started in the month before the payroll - then the number of days worked is added.
2) if an employee leaves mid month -e.g leaving on the Jan 16th- the employee would get 16/(months days)*salary).
I would like to see if I can automated the process to see how much each person should receive.
I have added a excel file - where you will see the column for adj amounts of the base pay - this is the column that I want to know
how to calculate quickly and automatically for 1000s of staff. - there are months with different days... so I am stuck.
thanks
Bookmarks