Entitlement reporting

Hi there,

I have discovered some of our payroll categories (allowances etc) have been calculating leave entitlements on them, whereas the entitlements should only be calculated based on the base salary categories. (Calculated as a % of gross hours)

Therefore, I need to go through and work out the adjustments required to the holiday, sick and LSL entitlement hours - is there a report that will easily show me the base hours the entitlements have been calculated on for each pay? I would like to export to excel to allow me to calculate the correction and show the staff in a way that is easy for them to understand. I'm looking for a report that lists:

• Pay run date
• Payroll category
• hours worked in each payroll category
• entitlement hours accrued for each payroll category per pay run

I can find a report that shows the entitlement hours accrued each pay run but not one that includes the hours entered fro each pay category.

I am assuming there isn't an easier way for me to process this correction short of reversing all the pay runs and reprocessing?

Thanks