Export File Specifications

The Export Timesheets to Paychex process exports timesheet information in a CSV file format.

The process exports timesheet information with the following specifications.

Header Row

Column	Field Name	Max Field Length	Description	Value
1	Client ID	n/a	Header row value Left justified	"CLIENT ID"
2	Worker ID	n/a	Header row value Left justified	"WORKER ID"
3	Org	n/a	Header row value Left justified	"ORG"
4	Job Number	n/a	Header row value Left justified	"JOB NUMBER"
5	Pay Component	n/a	Header row value Left justified	"PAY COMPONENT"
6	Rate	n/a	Header row value Left justified	"RATE"
7	Rate #	n/a	Header row value Left justified	"RATE NUMBER"
8	Hours	n/a	Header row value Left justified	"HOURS"
9	Units	n/a	Header row value Left justified	"UNITS"
10	Line Date	n/a	Header row value Left justified	"LINE DATE"
11	Amount	n/a	Header row value Left justified	"AMOUNT"
12	Check	n/a	Header row value Left justified	"CHECK SEQ NUMBER"
13	Override State	n/a	Header row value Left justified	"OVERRIDE STATE"
14	Override Local	n/a	Header row value Left justified	"OVERRIDE LOCAL"
15	Override Local Jurisdiction	n/a	Header row value Left justified	"OVERRIDE LOCAL JURISDICTION"
16	Labor Override	n/a	Header row value Left justified	"LABOR ASSIGNMENT"

Detail Rows

Column	Field Name	Max Field Length	Description	Value
1	Client ID	8	Alphanumeric Must match the Client ID of the client that the user is logged into while performing the import.	Client ID
2	Worker ID	10	Alphanumeric Used as identifiable info for pay entry	Worker ID
3	Org	60	Based on 10 level maximum, 6 characters per level Pipe delimited For example, 246856|2543|26487|2485 (can have up to 60 digits only based on number of organization units)	Empty
4	Job Number	25	Valid Values: all active job numbers set up on the client	Empty
5	Pay Component	20	Must be the custom name of an active pay component as it is set up on the client. Case sensitive.	Pay Component
6	Rate	4	Range = 0.0001 <= 9999.9999 Overrides any loaded rate or rate # for the earning, if one exists. An earning can include only one of the following: Rate, Rate#, or Amount.	Empty
7	Rate #	1	Denotes which loaded pay rate # to use for the earning. Valid Values - 1, 2, 3, 4, 5, 6 Overrides any default rate # or rate for the earning, if one exists. 6 = 0.00 Track Memo Hours	Empty
8	Hours	7	Range = -999.99 through 999.99 An Earning can include either Hours or Units, not both.	Hours
9	Units	8	Range = -999,999 through 999,999	Empty
10	Lane Date	10	mm/dd/yyyy Only valid for earnings type pay components.	Empty
11	Amount	17	Range = -9999999999.99 through 9999999999.99	Amount If NULL, then this should be empty. If the Hours column is not NULL or not zero, then this should be empty.
12	Check	2	Valid Values: 1-99	Check
13	Override State	2	Valid 2 Digit State Code This must be set up on the worker.	Override State If NULL, then this should be empty.
14	Override Local	15	Local Regulation Abbreviation Names set up for the worker. Exclusions apply to some PA and OR locals.	Empty
15	Override Local Jurisdiction	2	Valid 2 Digit State Code This is required when there is a value for the Override Local	Empty
16	Labor Override	25	Override value for Labor Assignment for the earning	Empty