SuccessWare21/ADP Payroll
Export File Format Specification

The following specifications were designed in cooperation with and specifically for ADP. 
This information will guide your ADP Representative when setting up your ADP account for integration with SuccessWare21. 

** NOTE: The codes on your ADP account must be setup to match the coding specifications below.

Please print and share this ADP Payroll Export File Spec document with your ADP Representative.

General Description

1.         Columns
The SuccessWare21/ADP Payroll Export File is a ‘csv’ file.  The file includes and is limited to the following columns:

1.1.        Co Code len 3, alphanumeric

1.2.        Batch ID len 2, 1-99

1.3.        File #                                           len 6, 51-999999

1.4.        Temp Dept                                  len 3 or 6, Alphanumeric

1.5.        Temp Rate                                  Min: -405.0000, Max: 999.9999, Precision is 4

1.6.        Reg Earnings                               -40500.00-99999.99

1.7.        Reg Hours                                   -40500.00-99999.99

1.8.        O/T Hours,                                  -40500.00-99999.99

1.9.        Hours 3 Code                               len 1-2, Alphanumeric; A-Z, 0-79 (except 40, 50, 60, and 61), and blank

1.10.     Hours 3 Amount                          -40500.00-99999.99

1.11.     Hours 4 Code                               len 1-2, Alphanumeric; A-Z, 0-79 (except 40, 50, 60, and 61), and blank

1.12.     Hours 4 Amount                          -40500.00-99999.99

1.13.     Earnings 4 Code                          len 1-2, Alphanumeric; A-Z, 0-79 (except 40, 50, 60, and 61), and blank

1.14.     Earnings 4 Amount                     -40500.00-99999.99

If you work in multiple states or in localities with payroll tax withholding requirements, you may use the “ADP Payroll Service (with state and local tax codes)” format to include extra columns for the state and local tax code where work was performed.

1.15.     Temp State Code                        len 2, alphanumeric

1.16.     Temp Worked Local                    len 2, alphanumeric

 

2.         General Comments

2.1.        Employees can be listed more than once (in multiple rows).

2.2.        Salary entries are exported and included in the file.

2.3.        Commissions/Spiffs/Bonus will be included in the export for all employees in the same manner.

2.3.1.       Commissions will export as Earning3Code “C”

2.3.2.       Piecerate will export as Earnings3Code “P”

 

3.         Export Filename

3.1.        Format export filename as EPIcccAA.csv where

3.1.1.       ‘ccc’ is the alphanumeric company code supplied by ADP.

3.1.2.       ‘AA’

4.                  The last two digits of the SuccessWare21 Period ID will be used for the AA portion of the filename. 

5.                  This ensures a unique number for each period during the same cycle and throughout most of the year or more. 

6.                  This also allows for quick relation of a file back to it a recent corresponding period in SuccessWare21. 

7.                  The Period ID starts at 1 in SuccessWare21 and increments by one each time a period is created.  Periods can be deleted.  This means that gaps may exist between the existing Period IDs.

 

8.         Wage Types
Exporting different wage types

8.1.        Regular hourly wages will use RegHours and TempRate

8.2.        Salary wages will use RegEarnings.

8.3.        Overtime wages will use OTHours and TempRate

8.4.        Premium wages will use Hour3Code and Hours3Amount.

8.5.        Vacation, sick, personal, and holiday wages will use the Hours4Code and Hours4Amount.

8.6.        Commissions and piece rate will use the Earnings4Code and Earnings4Amount

Detailed Column Specification

 

Column Title

Spec

Description

Co Code

len 3, alphanumeric

This code is supplied to the customer by ADP.  It is configured in SW21 Setup as a part of the ADP configuration.

Batch ID

len 2, 1-99

The Batch ID is used to identify secondary files submissions for the same payroll period.  If the Batch ID is the same, the additional file will replace the original.  With a different Batch ID, the new file will be appended to the existing payroll period.

To compensate for the possibility of SW21 users possibly having multiple payroll periods to submit during the same week/cycle, this field can be set to a constant based on the period type.  SW21 users can only have two of four periods. 

The Batch ID values will be as follows:

BatchID

PeriodType

1

Weekly

2

Bi-weekly

3

Semi-monthly

4

Monthly

File #

len 6, 51-999999

This field will be completed using the SW21.EmployeeNo field.

ADP requires a numeric value be entered as 51-999999. 

Temp Dept

len 6, alphanumeric

SW21.GLAccount+SW21.Department (example: “4002S1”)

This requires that SW21.Department codes be setup as two characters codes.

Temp Rate

Min: -405.0000, Max: 999.9999, Precision is 4

This is the actual rate paid to the employee for regular or overtime hours.  For O/T hours this will include the O/T rate inflation.

For commissions and piece rate, leave blank.

Reg Earnings

-40500.00-99999.99

 

This is the actual amount earned for salary employees. 

For non-salary wages, leave blank.

Reg Hours

-40500.00-99999.99

Regular hours for non-premium hourly entries.

OT Hours

-40500.00-99999.99

 

O/T hours for premium ‘OT’ hourly entries.

Note: Premiums other than overtime (holiday, doubletime) will use the Hours 3 Code and amount.

Hours3Code

len 1-2, alphanumeric

 

A-Z, 0-79 (except 40, 50, 60, and 61), and blank

Used for premium wages other that O/T.  The codes here will corresponds to the appropriate premium multiplier.

Code

 

Multiplier

P1

1.5

P2

2.0

P3

2.5

P4

3.0

 

Note:  The Temp Rate used with this field will contain the actual rate paid include the premium inflation.

Hours3Amount

-40500.00-99999.99

 

Hours for premium non-OT hourly entries.

Hours4Code

len 1-2, alphanumeric

 

A-Z, 0-79 (except 40, 50, 60, and 61), and blank

This code corresponds to Vacation, Sick, or Personal time.

When the SW21.PayType start with “Vacation”, “Sick”, “Personal”, or “Holiday” the Hours3Code and Hours3Amount will be used. 

This field will have the appropriate ADP standard code for vacation, sick, personal or holiday time as follows:

Code

Time Type

VT

vacation time

ST

sick time

PT

personal time

HT

Holiday time

Hours4Amount

-40500.00-99999.99

Hours for vacation, sick, personal, and/or holiday time.

Earning4Code

len 1-2, alphanumeric

 

A-Z, 0-79 (except 40, 50, 60, and 61), and blank

For SW21.Misc wages; spiffs, commissions, bonus, and piece rate;

Code

Wage Type

C

commissions (this will include spiffs and bonuses in SuccessWare21)

P

piece rate

Earming4Amount

-40500.00-99999.99

Amount paid for commission or piece rate wages.

The following are included for multi-state and/or local payroll tax reporting. Use “ADP Payroll Service (with state and local tax codes)” export format…

Temp State Code

len 2, alphanumeric

Valid US postal state code

State where work was performed. 

Either job location state code, or Employee Setup payroll state ode, or Company Setup state code.

Temp Worked Local

len 2, alphanumeric

Local payroll tax code processing must be enabled. 

Per ADP standard, all local payroll tax codes must be 2 characters in length.

Either job location local tax code, or Employee Setup payroll local tax code.