Turnkey Integration Details
This lowest-priced, prebuilt connector works with 28 fields of employee data using the standard data field names and syntax in both Netsuite and ADP Workforce Now.
Turnkey involves no custom fields in ADP or custom logic mapping from Flexspring experts.
Review the integration maps (also in the Netsuite with ADP Integration Guide pdf) before choosing the version (turnkey, or custom) that you require or contact sales@flexspring.com for assistance.
Data Fields for Turnkey Integration for New Hires and Employee Updates
- In the turnkey version, the following field values are automatically shared between Netsuite and ADP:
- Employee IDs
External ID
Entity ID - Employment Information
Is In Active - Name
First Name
Middle Name
Last Name - Demographics
Gender
Marital
Ethnicity - Legal/Home Address
Address 1
Address 2
City
State
Country
ZipCode - Personal/Home and Line Phones
Phone
Home Phone - Personal Mobile
Home Mobile - Personal Email
Email - Job Profile
Hire Date
Rehire Date
Release Date
Title
Supervisor
Subsidiary
Department
Location
Home Work Location
Custom Integration Details
Custom integration using the NetSuite connector is fast and relatively easy. Custom data-mapping creates a tailor-made connector for your business. No internal IT resources are needed to create or maintain your integration. The experts at Flexspring do all the integration work.
Flexspring focuses exclusively on HR data integration and is an ADP Platinum Marketplace Partner. Flexspring is also an Oracle “Built for NetSuite” Partner. No team knows more about how to integrate NetSuite with ADP than Flexspring.
With data integration from Flexspring, you only pay for the use case or use cases that you need.
ADP Applications Integrated
- ADP Workforce Now® (current version)
- ADP Workforce Now® Next Generation
- ADP Vantage HCM®
- ADP Workforce Now® Essential Time
- ADP TotalSource®
NetSuite Journal Entries
This integration extracts weekly or bi-weekly payroll data from ADP and automatically imports the payroll data into NetSuite. Specifically, this integration summarizes multiple lines of ADP payroll data—for example, earnings, deductions, and taxes, etc.—to create one journal entry per payroll run per subsidiary. Summary amounts can be grouped by department or location. The journal entry contains a summary of pay data and does not include details about individual employees’ pay. This integration also checks the balances of debits and credits and notifies if there are any errors.
The ADP Payroll to NetSuite Journal Entries use case comes in two flavors. The single subsidiary connector is for payrolls involving a single subsidiary. The multiple subsidiary connector is for payrolls that are mapped to multiple subsidiaries.
New Hires and Employee Updates to NetSuite
As soon as an employee is hired or updated in ADP, employee data automatically syncs in NetSuite in near real-time with the employee data needed for workforce management.
Expense Reimbursement from NetSuite
Takes all approved expense reimbursements from NetSuite that’s beyond regular compensations—for example, travel deductions, mileage, or cell phone—and imports the expense data into ADP’s pay data batch module.
NetSuite Projects to Labor Allocation Codes
Automatically takes NetSuite projects and shares them as labor allocation codes in ADP so that employees can put their time against these projects in ADP Workforce Now® Essential Time (timesheets) for accurate job costing. NetSuite projects can be brought over on a daily or hourly basis, depending on the client’s preference.
ADP Time Card Data to Netsuite
Time Card data entered into Essential Time by ADP is automatically returned to NetSuite to populate the corresponding work orders. With this integration, reports on job costing can be handled directly in NetSuite and accurately reflect the employee hours worked on each project.