The Minimum Wage Adjustment Report pulls pay information for each employee with a selected job type. With this information, users can easily compare the pay each employee should receive based on minimum wage requirements against the amount earned based only on hours worked. This report helps accounting and payroll departments budget for the amount of money needed to pay employees who did not reach the minimum wage required based on the hours that they worked.


Article Topics


  1. In the Reports section of the left navigation pane, select My Reports.
    The My Reports screen appears.
  2. At the top of the My Reports screen, select Labor.
    The screen generates a list of reports in alphabetical order.
  3. Locate the Minimum Wage Adjustment Report.
  4. Select Customize to adjust the report parameters and run the report.


Back to Top


Report Parameters



FieldDescription
1Filter ByLocation reporting category by which to filter the report.

Options in the Filter By menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories.
2FilterAllows users to apply one or more filter options from the location reporting category that they selected in the Filter By menu. The selected filters determine which locations appear in the generated report.

For example, if Filter By is set to Region, the Filter menu might include options such as North, South, East, and West. A user can select West to display all locations belonging to this reporting category.

Options that appear in the Filter menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories.
3StartFirst date to include in the report. The Start and End fields create a date range for which to include data in the generated report.
4EndLast date to include in the report. The Start and End fields create a date range for which to include data in the generated report.
5JobJob(s) for which to display data in the generated report.
6Job TypePay type for which to display data in the generated report, such as hourly, salaried or contract.
7Sales ColumnIf Summary is selected, sales information is shown at-a-glance.
If Detail is selected, sales information is shown in greater detail.
8OT On Own LineIf set to Yes, overtime earnings appear on a line separate from regular earnings.
9Other PayIf set to Yes, the report includes earnings that are not associated with a shift.
10Identify MinorsIf set to Yes, the word 'Minor' appears next to all employees who are under a certain age.
11Mask Payroll ID to Last 4 Digits
If set to Yes, only the last four digits of the Payroll ID are shown in the report.
12View optionsProvides the user with options to select, save, edit, or delete a report view.
For more information about these controls, see My Reports: Using My Reports.
13RunGenerates the report.
The green arrow button opens a drop-down from which users can Export, Email, or Print the report.


Back to Top


Report Columns


ColumnDescription
DateDate when the punch data was recorded.
EmployeeName of the employee whose punch data is shown in the row.
Payroll IDIdentification number assigned to the employee for the purpose of processing payroll.
InTime when the employee punched in to their shift.
OutTime when the employee punched out of their shift.
LocationName of the location where the punch data was recorded.
Loc NumberNumber for the location where the punch data was recorded. 
JobJob that the employee worked.
Job CodeNumber or shorthand code used to identify the job in the system.
Reg HrsNumber of hours that the employee worked at a regular rate of pay.

Hours are reported as a decimal. Example: 4 hours and 15 minutes appears as 4.25.

OT HrsNumber of hours that the employee worked at an overtime rate of pay.

Hours are reported as a decimal. Example: 4 hours and 15 minutes appears as 4.25.

Tot HrsTotal number of hours that the employee worked.

Hours are reported as a decimal. Example: 4 hours and 15 minutes appears as 4.25.

PayrateEmployee's hourly rate of pay.
Reg PayAmount to be paid to the employee for hours worked at a regular rate of pay on the specified date.
OT PayAmount to be paid to the employee for hours worked at an overtime rate of pay on the specified date.
Penalty PayAmount owed to the employee due to a break penalty, if any.
Other PayAmount owed to the employee for any reason not covered by regular pay, overtime pay, and penalty pay.
Total PayTotal amount to be paid to the employee for the specified date, including regular pay, overtime pay, and penalty pay.
Net SalesAmount gained in net sales from guest checks on the specified date.
This column appears if Detail is selected on the Sales Column parameter.
Gross SalesAmount gained in gross sales from guest checks on the specified date.
CC SalesAmount gained in sales from guest checks paid by credit card on the specified date.
This column appears if Detail is selected on the Sales Column parameter.
Cash SalesAmount gained in sales from guest checks paid with cash on the specified date.
This column appears if Detail is selected on the Sales Column parameter.
TipsAmount of tips gained based on the employee's gross sales.
Declared TipsAmount of cash tips declared by the employee.
Total Pay w/ TipsTotal amount to be paid to the employee, including regular pay, overtime pay, penalty pay, tips, and declared tips.
Min Wage ReqMinimum amount that the employee must receive based on minimum wage laws.
Min Wage AdjAmount the employee must pay to meet minimum wage requirements.


Back to Top


Email, Export, or Print the Report



This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.


Back to Top