Skip to content
  1. OrderMate Help Guides
  2. Reporting
  3. Audit Reports

Timesheets Report

Summary of the Report

The Timesheet report is used to view time and attendance of each employee that has used the clock on/off feature in WaiterMate. This is one of the few reports where data can also be manually added or edited. The bookkeeper would usually enter this data into the accounting software to prepare the payroll.

Note: To find this report search 'Timesheets' in OfficeMate

Timesheets.png

Available Filters in the Report

  • Custom Date Range
  • User
  • Department

The Information in the Report

Label Description
Filters
  • Timesheets can be manually added by selecting the (+) new icon from the top of the screen
  • The data can be manually edited by selecting on the timesheet and selecting the 'Edit' icon (Time Punch Altered)
  • Timesheets can be exported to a CSV or to a MYOB compatible file by selecting the export options *Payroll ID required for MYOB
  • Select the custom date range to view the desired pay week
  • Select the desired report from the tabs across the top of the screen

DETAILED REPORT

Label Description
Name
  • The first and last name of the user for this (timesheet) entry
  • User name is assigned in the user setup screen
Payroll ID
  • The payroll ID for this user
  • Payroll ID is assigned in the user setup screen
  • This is a required field for MYOB export
Department
  • The department the user was clocked on to for this entry
  • Multiple departments can be assigned to the user in the user set up screen
  • To create new departments search 'Departments' in OfficeMate
Date
  • The date for this entry
  • Day, Date Month format ie. Thu, 01 Jul
Start Date
  • The START date for this entry
  • Date/Month/Year format ie. 01/07/2021
  • The edited date if the time punch has been altered
Start Time
  • The Clock ON time for this entry
  • 24 hour Time format ie. 17:00
  • The edited time if the time punch has been altered
End Date
  • The END date for this entry
  • Date/Month/Year format ie. 01/07/2021
  • The edited date if the time punch has been altered
End Time
  • The Clock OFF time for this entry
  • 24 Hour Time format ie. 21:00
  • The edited time if the time punch has been altered
Hours
  • The hours worked for this entry
  • Hours to 2nd decimal format ie. 3.75 (hours)
  • The edited hours if the time punch has been altered
Pay
  • The hours multiplied by the pay rate for this entry
  • Pay rates can be set in the user set up screen
  • Pay rates can be different per department for the same user

Time Punch Altered
  • YES or NO to indicate altered time punches

Total
  • The combined total of hours for all timesheets for THIS user
  • The combined total pay for THIS user

Grand Total
  • The combined total of hours for all timesheets for ALL users
  • The combined total pay for ALL users

SUMMARY REPORT

Label Description
Payroll ID
  • The payroll ID for this user
  • Payroll ID is assigned in the user setup screen
  • This is a required field for MYOB export
Name
  • The first and last name of the user for this timesheet
  • User name is assigned in the user setup screen
Hours
  • The total hours worked for this user (all departments)
  • Hours to 2nd decimal format ie. 3.75 (hours)
  • The edited hours if the time punch has been altered
Pay
  • The total hours multiplied by the pay rate(s) for this user
  • Pay rates can be set in the user set up screen
  • Pay rates can be different per department for the same user
Grand Total
  • The combined total of hours for all timesheets for ALL users
  • The combined total pay for ALL users

SUMMARY BY USER

Label Description
Name
  • The first and last name of the user for this timesheet
  • User name is assigned in the user setup screen
Payroll
  • The payroll ID for this user
  • Payroll ID is assigned in the user setup screen
  • This is a required field for MYOB export
Department
  • The department the user was clocked on to for this entry
  • Multiple departments can be assigned to the user in the user set up screen
  • To create new departments search 'Departments' in OfficeMate
Hours
  • The total hours worked for this user (per department)
  • Hours to 2nd decimal format ie. 3.75 (hours)
  • The edited hours if the time punch has been altered
Pay
  • The hours multiplied by the pay rate (per department)
  • Pay rates can be set in the user set up screen
  • Pay rates can be different per department for the same user
Total
  • The total hours worked for this user (all departments)
  • Hours to 2nd decimal format ie. 3.75 (hours)
  • The edited hours if the time punch has been altered
Grand Total
  • The combined total of hours for all timesheets for ALL users
  • The combined total pay for ALL users

Note: If a timesheets has been edited, the timesheet preview in WaiterMate will not be altered. This is so that the staff have access to their original time punches.

Articles in this section