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 Modulus Data 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@modulusdata.com for assistance.
Data Fields for Turnkey Integration for New Hires and Employee Updates
- Job Profile
Hire Date
Rehire Date
Release Date
Title
Supervisor
Subsidiary
Department
Location
Home Work Location - Personal Email
Email - Personal Mobile
Home Mobile - Personal/Home and Line Phones
Phone
Home Phone - Legal/Home Address
Address 1
Address 2
City
State
Country
ZipCode - Demographics
Gender
Marital
Ethnicity - Name
First Name
Middle Name
Last Name - Employment Information
Is In Active - Employee IDs
External ID
Entity ID - In the turnkey version, the following field values are automatically shared between Netsuite and ADP:
Custom Integration Details
Based on use case, Modulus Data’s NetSuite with ADP connector comes in four flavors: New Hires from NetSuite to ADP, employee updates from NetSuite to ADP, employee updates from ADP to NetSuite, and Journal Entries from ADP payroll to NetSuite general ledger. Depending on your organizational needs, you can choose to have more than one integration for maximum synchronization between systems. You pay only for the use case or connections that you need.
Custom versions, tailored to the specific needs of your business, are available for all four use cases. Lower-priced turnkey versions are available for new hires and employee updates.
ADP Applications Integrated
- ADP TotalSource®
- ADP Workforce Now® Essential Time
- ADP Vantage HCM®
- ADP Vantage HCM
- ADP Workforce Now
ADP Vantage HCM
NetSuite Journal Entries
his 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 Essential Time by ADP (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.