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
-
272 Points
- frustrated
Posted 2 years ago
Linda Putland, Accredited Partner
-
15,952 Points
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
Kevin Russell, Accredited Partner
-
52,824 Points
-
90 Points
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,
Ta,
Jacqui Allen - Professional Partner since 1994
-
3,316 Points
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.

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)
Related Categories
-
Accounts Hosted
- 5429 Conversations
- 1637 Followers
Susan ODonnell
Susan ODonnell
Linda Putland, Accredited Partner