The detailed Employee Overtime Spreadsheet is a day-by-day account of your employees’ work hours. It shows how many hours an employee worked at each wage rate and in total during the date range. In addition, the Emp Total line shows the total hours the employee worked at each wage rate and overall for the entire date range.. For example, if the report were run for a pay period, this line would give you the total hours at each wage rate for the pay period. The last line includes grand totals for all reported employees. There are several wage rates you can set up in the Center Control File (1-6-1-1), including the following:
Use the following steps to set up and print a detailed Employee Overtime Spreadsheet:
Field | Definition | ||
---|---|---|---|
Range of Dates | Fill in the beginning and ending dates in the range you want to include on your report. Leave blank to print information from the present pay period through the current day. | ||
Employee ID | Employee ID or range of employee IDs that you want printed. Leave blank to print all employees. | ||
Print Time on Report | Printing the time helps you identify the most current report when the same report is printed more than once during a day. This field defaults to Y to print the time on the report. If you do not want the time to print on a report, type N. We recommend that you always print the time on a report. | ||
Summary Only | This field appears for reports with both detailed and summary versions. Enter N to print the detailed report. We recommend printing a detailed report only if you need detailed information. | ||
Duplex | This field appears for terminals that have report type 2 enabled in the Set Up Printer Controls screen. Duplex mode enables printing on both sides of the paper.
|
||
Landscape | This field appears for terminals that have report type 2 enabled in the Set Up Printer Controls screen. It prints horizontally on the paper. | ||
Number of Printed Lines per Page | This value tells the computer how many lines to print on each page of the report. A typical 11-inch page can contain up to 66 lines, but this field defaults to 60 to allow three-line margins at the top and bottom of the page.
|
||
Total Number of Lines per Page | This field indicates the length of the paper in the printer. A typical 11-inch page contains 66 lines. Your system interprets a 0 or 66 in this field to mean that standard 11-inch paper is loaded in the printer. Because a 66 causes a form feed to take more time, accepting the default, 0, is recommended. | ||
Print Report To | This field tells the computer where to send the report. The following list contains the different selections available for this field.
|
||
Command Line Options | The line at the bottom of the screen contains commands to print the report and to save or change the report settings.
|
Note: | In order for your system to calculate overtime hours, you must have overtime rates and daily/weekly limits set up on screen 3 of the Center Control File (1-6-1-1). In addition, you must have a Y in the Include OT on Reports field. |
You can also set up this report on the Set Up Closing Processes screen (1-6-3) to print during closing processes. We recommend you enter a P code in order to create a report for the payroll period during a payroll period closing. You can enter a D code for a daily report, but keep in mind that if you print the report for a month (M code), the information may not be as useful to you as the information contained in a payroll period report.
Callout | Item | Description |
---|---|---|
1 | Date Range | Range of dates for the report information. |
2 | Regular | Regular hours worked. |
3 | Over Time | Hours worked at overtime wage rate. |
4 | Double OT | Hours worked at double overtime wage rate. |
5 | Sunday | Hours worked on a Sunday at regular, overtime, and double overtime wage rates. |
6 | Holiday | Hours worked on a holiday at regular, overtime, and double overtime wage rates. |
7 | Sunday/Holiday | Hours worked on a Sunday holiday at regular, overtime, and double overtime wage rates. |
8 | Week | Hours worked at overtime rate if overtime is calculated on a weekly basis. |
9 | Total | Total of employee hours for the date range. |
10 | Employee ID | ID number and name of employee whose hours are reported. |
11 | Dates | List of dates for which hours are reported. |
12 | Emp Total | Range of dates for the report information. |
13 | Total | Regular hours worked. |
The Employee Overtime Spreadsheet is used to keep track of overtime hours worked by employees. Because the detailed version shows the exact breakdown by day, it is often printed to answer questions that arise on the summary report. For example, you can run the report for one employee to find out exactly how that employee accumulated overtime. The best time to run this report is at the payroll close. Run it as you need it to supplement the summary report. You should keep this report with your other timesheet records.
Note: | If this report is run for a day while employees are still clocked in, the information will be incomplete for those employees and a later report may show additional hours. Another way that hours can be changed is by editing the employee file through the Edit Employee Timesheet (1-5-4) function. To see if this has been done, run an Employee Timesheet Audit Report (1-5-2-6). |
To find employee wage and commission information, use the Employee Earnings Report (1-5-2-4). The overtime hours should be the same on both reports.
LubeSoft has been enhanced to calculate overtime hours, wages, and labor for your employees. These calculations are used on reports and for labor percentages.
In order for LubeSoft to know how to calculate overtime hours, wages, and labor, you have to specify the rates at which you pay your employees for regular overtime hours, extended overtime hours, Sunday hours, and holiday hours. You need to set up the values for these pay schedules and turn on the overtime option for your store. For detailed information on setting up overtime, see the article Setting Up the Center Control File.