The APS Export is an export of labor data that allows users to add additional earning data for employees, if necessary. This will export as a .csv file.
Navigation
Navigate to the My Reports page.
Click the Labor tab.
Locate the APS Export.
Click Download.
Report Parameters
Field | Description |
|---|---|
Location | Filters the export to show data only for the selected location(s). |
Start Date | First date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for which data is generated. The report then displays data for all dates within the date range, including the start and end dates. |
End Date | Last date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for which data is generated. The report then displays data for all dates within the date range, including the start and end dates. |
Job | Filters the report to show data only for the selected job(s). |
Job Type | Filters the report to show data only for the selected job type(s), based on the Labor Operational Report Categories associated with the GL accounts assigned to jobs. |
Include Tips | If set to Yes, the Charge Tips and Declared Tips columns appear in the report, allowing users to view tip-based earnings. If set to No, tips are not included in the report. |
Run As | Determines whether the employees’ payroll details are summarized or broken out.
|
View Options | This section provides options to select, save, edit, or delete a report view. |
Download | Exports the report to a spreadsheet file and downloads the file to the default downloads location on the user’s device. |
Export Columns
Column | Description |
|---|---|
Employee Name | Employee's first and last name, as noted on the Employee record. |
Employee Number | R365 payroll ID of the employee. |
Department | Job department title of the employee. |
RegHr | Total regular hours worked for this employee within the date parameter selected. |
OvtHr | Total overtime (OT) hours worked for this employee within the date parameter selected. |
DbtHr | Total double time (DT) hours worked for this employee within the date parameter selected. |
BrkPrHr | Total break time worked for this employee within the date parameter selected. |
Splt$ | Total split shift earning dollars for this employee within the date parameter selected. |
TipsCC | Total charge tip dollars for this employee within the date parameter selected. |
Tips$ | Total declared tip dollars for this employee within the date parameter selected. |
CatTips | This column will be blank. |
MealPHr | Pulls any Break Penalty earnings in the system. |
PTOHr | Pulls any PTO earnings hours in the system. |
VacHr | Pulls any Vacation earnings hours in the system. |
HolHr | Pulls any Holiday earnings hours in the system. |
SickHr | Pulls any Sick earnings hours in the system. |
ReTimeHr | Pulls any Retro Time earnings hours in the system. |
SpofHr$ | Pulls any Spread of Hours earnings dollars in the system. |
Bonus$ | Pulls any Bonus earnings dollars in the system. |
Cell$ | This column will be blank. |
Retro$ | Any retro time earning dollars in the system. |