I need to check that holidays hours are correct for past years

  • 1
  • Question
  • Updated 1 year ago
  • Answered
I need to check that the correct amount of holiday hours have been paid for previous years for an employee - is there a report i can run to check how many hours have been during a year or time period?  help would be appreciated so I don't have to go back & manually check
Photo of Susan ODonnell

Susan ODonnell

  • 242 Points 100 badge 2x thumb
  • frustrated

Posted 1 year ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,632 Points 5k badge 2x thumb
Go to your Payroll Item list - right click on the Holiday pay item you want to check - choose fast report - set the date range and also add the column for QTY - then you can sort by Employee, send to excel and do some sums..  Cheers Linda
Photo of Susan ODonnell

Susan ODonnell

  • 242 Points 100 badge 2x thumb
Do you mean in reports Linda?
Photo of Susan ODonnell

Susan ODonnell

  • 242 Points 100 badge 2x thumb
i'm just not sure where to go for Payroll item list?
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,632 Points 5k badge 2x thumb
Go to Lists - then choose Payroll Item list - then right click on the holiday pay item and choose Fast Report... then modify as per my comments above...
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 40,760 Points 20k badge 2x thumb
Susan the Payroll sumnary report does this
Photo of smls finance

smls finance

  • 90 Points 75 badge 2x thumb
Hi Susan, further to Linda's comment, once you have opened the FastReport, you can modify this by adding Hours worked so in your spreadsheet you can apply a formula to check the payrate for each holiday.
Ta,
Create a custom summary report,
Display
dates - all or enter specific dates
columns by - Employee
Display rows by - Payroll Item Detail.
Display  Columns for - Select Qty or
Filters
Account - All income/expense accounts
Transaction Type - Paycheque
Name - select employee (if left blank will show all employees)
Header/Footer - change the report title ie "Staff hours by Payroll Item"
Click OK
If this satisfies your requirements then memorise it! 
Should look something like this.

(Edited)