The Minimum Wage Adjustment - Raw Data report pulls the pay information for each employee underneath a selected job type to see the pay each employee should receive versus how much they earned.
This report is similar to the previous report in that it is beneficial in seeing the amount of money needed to pay a worker if they did not reach the minimum wage required for the hours that they worked, but it also is presented in a plain layout without headers and columns to better export to a personal data system.
Article Topics
Navigation
- In the Reports section of the left navigation pane, select My Reports.
The My Reports screen appears. - At the top of the My Reports screen, select Labor.
The screen generates a list of reports in alphabetical order. - Locate Minimum Wage Adjustment - Raw Data.
- Select Customize to adjust the report parameters and run the report.
Report Parameters
| Field | Description | |
| 1 | Filter By | Location 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. |
| 2 | Filter | Allows 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. |
| 3 | Start | First date to include in the report. The Start and End date fields create a date range for which to generate data for the report. |
| 4 | End | Last date to include in the report. The Start and End date fields create a date range for which to generate data for the report. |
| 5 | Job | Jobs for which to generate data. Users can select one or more jobs to include in the report. |
| 6 | Job Type | Labor operational reporting categories associated with the GL accounts assigned to jobs. Users can select one or more Job Types by which to filter the report. |
| 7 | Sales Column | Displays sales information either in a detailed or in summed amounts. |
| 8 | OT On Own Line | If set to Yes, data from overtime hours is separated from the data from regular hours and appears on its own line in the report. |
| 9 | Other Pay | If set to Yes, an Other Pay column displays amounts owed to the employee for any reason not covered by regular pay, overtime pay, and penalty pay. |
| 10 | Identify Minors | If set to Yes, the word 'Minor' appears next to all employees who are under a certain age. |
| 11 | View options | Provides 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. |
| 12 | Download | Generates the report. The green arrow button opens a drop-down from which users can Export, Email, or Print the report.  |
Report Columns
| Column | Description |
| Date | Date when the punch data was recorded. |
| Employee | Name of the employee whose punch data is shown in the row. |
| Payroll ID | Identification number assigned to the employee for the purpose of processing payroll. |
| In | Time when the employee punched in to their shift. |
| Out | Time when the employee punched out of their shift. |
| Location | Name of the location where the punch data was recorded. |
| Loc Number | Number for the location where the punch data was recorded. |
| Job | Job that the employee worked. |
| Job Code | Number or shorthand code used to identify the job in the system. |
| Reg Hrs | Number 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 Hrs | Number 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 Hrs | Total number of hours that the employee worked. Hours are reported as a decimal. Example: 4 hours and 15 minutes appears as 4.25. |
| Payrate | Employee's hourly rate of pay. |
| Reg Pay | Amount to be paid to the employee for hours worked at a regular rate of pay on the specified date. |
| OT Pay | Amount to be paid to the employee for hours worked at an overtime rate of pay on the specified date. |
| Penalty Pay | Amount owed to the employee due to a break penalty, if any. |
| Other Pay | Amount owed to the employee for any reason not covered by regular pay, overtime pay, and penalty pay. |
| Total Pay | Total amount to be paid to the employee for the specified date, including regular pay, overtime pay, and penalty pay. |
| Gross Sales | Amount gained in gross sales from guest checks on the specified date. |
| Tips | Amount of tips gained based on the employee's gross sales. |
| Total Pay w/ Tips | Total amount to be paid to the employee, including regular pay, overtime pay, penalty pay, tips, and declared tips. |
| Min Wage Req | Minimum amount that the employee must receive based on minimum wage laws. |
| Min Wage Adj | Amount the employee must pay to meet minimum wage requirements. |