Overview of Timesheets
Selecting Payroll | Payrun | Timesheets opens this facility within the Data Explorer function.
If you are not familiar with the Data Explorer function, please see The Data Explorer Desktop for more information on this environment.
There are four different types of timesheets within the Selection area:
Consolidated Timesheets
This is a display only selection. It will list all the daily timesheets (Worked Hours) and their associated details.
Weekly Timesheets
This is an editable timesheet, which means you may make adjustments to existing Weekly Timesheets (e.g. those created in kiosk), or create new timesheets.
Worked Hours
This is the default selection.
This hours:minutes timesheet is editable, which means you may make adjustments to existing timesheets (e.g. those created in kiosk), or create new timesheets.
Worked Hours Decimal
This timesheet is editable and is a decimal version of the Worked Hours timesheet. It allows you to make adjustments to existing timesheets, or create new timesheets.
Viewing the Timesheets
Once you have made your Selection (to specify what type of timesheet you want to view), go to the Criteria section to specify the company (or companies) required and Timesheet Dates, etc. Then in Select Destination ensure Report Grid is selected and click Run Query to display the results in the Results Panel.
For each of these timesheet types, applying the Grouping Columns option may be useful.
Include Zero Allocation Records
In the Criteria section this option is selected by default:
By having this selected, any timesheet day(s) without allocated times will display in the results.
Example one: it may be that there are no timesheets with employees working on a Saturday or Sunday, i.e. every timesheet shows these days with zeros in each field. These days will still appear as rows in the report grid for every timesheet listed.
Example two: throughout the timesheets for the specified period there may be no instances of hours listed under a certain Pay Item (e.g. P03). This Pay Item column will still be included in the report grid.
If you choose a new Selection, ensure you click Run Query again even if nothing is changed in the Criteria section.