WinTeam contains formats for the following agencies when selecting to outsource payroll. If you require a different format, please contact TEAM.
Note: The Outsource Payroll formats export the Job Numbers using the same capitalization that is set up in the Job Master File.
ADP - Oregon
All ADP export file formats have been updated to include accrued, used, and balance information for benefits to support the ADP requirements for the state of Oregon.
ADP Enterprise V5
ADP - FQM
ADP - IPSV18.5
ADP – RITEWAY
ADP – SETEC
ADP - Upload
ADP - Vantage
ADP – Windows
Three formats are available for the ADP PR Check print export:
- Format that includes Gross Pay requires Custom Setting:
| Section | Item | Value |
|---|---|---|
| LaserPRCheck | ADPNewFormat | Yes |
- Preprinted with TK detail – this includes gross pay – This is used if Include TK details on check is selected in PAY: Defaults.
- Preprinted – If the above Custom Setting is not in place or TK details are not included, then this format is used. This was the original format.
Filenames created during the payroll process:
- PR<Company Code>EPI.csv for Time
- PR<Company Code>EMP.csv for Employees…
Advantage/ABA
The Advantage/ABA Employee export will pull the Tax State from the Tax Info tab and not the resident state.
BBSI
Time - Payroll Data & .XLS
Employees - Employee Data.XLS
CBS Payroll
Centro
Ceridian
CompuPay-Old
CyberPay
Heartland
Inrinium/Ultipro
iSolved
You can use the PayrollExport | iSolvedFormat | True custom setting to add the following fields to the iSolved payroll outsource file:
- EXCL PAY
- RETRO SPSL
- SPSL22
Note: These fields must also be added to the Export Code in the Hours Types Defaults window to display in the file.
ISS
Marksman
Oneida
PAYCHEX-Old
PAYCHEX-RAPIDPC
PayChex - SPI
PayChex - Strategic
Paycom
Paycom - Paramount
Paycor
This timekeeping export is very similar to the outsource option called Payroll1. This export was developed for clients who use a Kronos interface for their payroll processing. The Export code that is set up with each of WinTeam’s Hours Types are used to identify each hours record that goes into this file. It is important that these Export codes are set up correctly in the Hours Types table in order for these to be translated properly through the interface.
PayMaxx
Payroll Network
Payroll1
Payroll Office America
PCPAY
Prestige/Zurick
PrimePay
Questco
The file name format is "CompanyCode"Questco.CSV
Columns in this format are: Employee Number, Hours description, Pay Rate, Hours (for salary), Bank Column, Job Number.
QuickBooks™
Sanitors
SFS - Paychex
Wells Fargo
Workforce1
To use this payroll outsource file format, the following custom settings must be enabled:
- CPWIZ | MJV | True
- CPWIZ | UseEmployeeNumber | True
| Column | Value | Notes |
|---|---|---|
| A | Employee ID | WinTeam Employee Number |
| B | Pay Statement Type | Always populate the values in the column as 'Regular' |
| C | E/D/T | Same as column B in Millennium file |
| D | E/D/T Code |
Any type of hours code (Reg, Vac, OT, Sick, etc.) Same as column C in Millennium file Hours Type Defaults: Export Code |
| E | E Hours | Number of hours based on the employee's E/D/T Code |
| F | E/D/T Amount | Leave these values blank/empty |
| G | E Base Rate |
Only pulls values from WinTeam if the regular rate is being overridden through the schedule or Timekeeping Leave these values blank/empty (not 0) |
| H | cC3 | WinTeam Job Number Same as column H in Millennium file |
| I | cC4 |
GL Code Same info that is used in Column I in the Millennium file Show the first letter appearing in the Job Number |
| J | Mode | Always populate the values in the column as 'Add' |