The ADP WorkforceNow Temp Cost Number Export is a downloadable CSV export containing regular, overtime, and double overtime information from ADP Payroll.
Navigation
To navigate to the ADP WorkforceNow Temp Cost Number Export, click 'My Reports' under 'Reports' in the left pane, then select 'Labor' in the top header of the reporting window. Find 'ADP WorkforceNow Temp Cost Number Export', then select 'Customize' next to the report. This will open up the Report Parameters that can be used to define the export.
Report Parameters
1) Filter By - A list of all filter categories
2) Filter - A list of filter options, based on the 'Filter By' category selected (#1)
3) Start - The beginning date of the export
4) End - The end date of the export
5) Job - List of Jobs available for the selected Filter (#2). Select one or more Jobs to filter by Job.
6) Download Button - Downloads the report
Report Columns
A) Co Code - Location's Payroll ID
B) Batch ID - Timestamp for the export
C) File # - Employee's Payroll ID
D) FLSA Workweek - 1 or 2, indicating the week of the pay period based on the start day of the Operational Calendar.
- Note: If the Pay Period stretches into a third week, the third week is marked '2'.
E) Regular Hours - Employee's total regular hours, reported as a decimal
F) O/T Hours - Employee's total overtime hours, reported as a decimal
G) Hours 3 Code - Used to report double overtime. The column will list 'DBT' if doubletime is being reported
H) Hours 3 Amount - Total double overtime hours, reported as a decimal
I) Temp Rate - Pay Rate
J) Temp Cost Number - Location Number and Job Code.
- Example: Location 226 and Job Code 203 will be listed as 000266-203
K) Earnings Code 3 - Manually-entered Earning Code. This column is left blank on download and is typically used for manual entry of earnings such as bonuses.
L) Earnings 3 Amount - Manually-entered amount of earnings. This column is left blank on download and is typically used for manual entry of earnings such as bonuses.