The ADP WorkforceNow Temp Cost Number Export is a downloadable CSV export that contains regular, overtime, and double overtime information from ADP Payroll.
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 ADP WorkforceNow Temp Cost Number Export.
- Select Customize to adjust the report parameters and run the report.
Report Parameters
Field | Description | |
Filter By | Location reporting category by which to filter the report. Note: 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. | |
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. Note: 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. | |
Start | First date to include in the report. The Start and End fields create a date range for which to include data in the generated report. | |
End | Last date to include in the report. The Start and End fields create a date range for which to include data in the generated report. | |
Job | Jobs for which to generate data. | |
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. | |
Download | Exports the report as a CSV file and downloads the file to the user's device. |
Report Columns
Column | Description |
Co Code | Number used to identify the location in the payroll system. |
Location Number | Number used to identify the location in R365. |
Batch ID | Timestamp for the export. |
File # | Number used to identify the employee for the purpose of processing payroll. |
FLSA Workweek | 1 or 2, indicating whether it is the first or second week of the pay period, based on the start day of the Operational Calendar. If the pay period stretches into a third week, the third week is marked 2. |
Reg Hours | Number of hours that the employee worked at a regular rate. Hours are reported as a decimal. Example: 4 hours and 15 minutes appears as 4.25. |
O/T Hours | Number of hours that the employee worked at an overtime rate. Hours are reported as a decimal. Example: 4 hours and 15 minutes appears as 4.25. |
Hours 3 Code | Used to report double overtime. If double time hours exist, 'DBT' appears in the column to indicate that double time is being reported. |
Hours 3 Amount | Number of hours that the employee worked at a double time rate. Hours are reported as a decimal. Example: 4 hours and 15 minutes appears as 4.25. |
Temp Rate | The employee's hourly rate of pay. |
Temp Cost Number | Location number and job code. For example, Location 226 and Job Code 203 will be listed as 000266-203. |
Earnings Code 3 | Code used to identify earnings that were entered into the system manually. This column is blank on download and is typically used for manual entry of earnings such as bonuses. |
Earnings 3 Amount | Amount for earnings that were entered into the system manually. This column is blank on download and is typically used for manual entry of earnings such as bonuses. |