Integration Details
The Dapt Job Costing solution integrates with ADP Workforce Now payroll Essential Time to synchronize your time tracking data for payroll processing and ADP payroll data to create accurate accounting entries for job costing.
Each pay period, you will use Dapt to push your payroll batch to ADP. Once payroll is complete, you will use Dapt to post your accounting entries into your accounting software.
ADP Applications Integrated
- ADP Workforce Now® Essential Time
Application Type
- • Bi-directional data exchange
• Single sign-on (practitioner and bookkeeper or accountant)
• Buy now
Integration Type
- Data connector and end user
Data Sync Frequency
- • Real time for ADP Workforce Now® Essential Time
• Data frequency of other synchronization will vary depending on platform
Data Fields
- The following fields will be sent via Dapt from your ADP timekeeping system to ADP payroll for each employee who has recorded time during the period:
• Time
• Time Type
• Job/Project (Optional)
• Location (Optional)
• Work Classification (Optional)
• Other Custom Fields (Optional)
• Employee ID (ADP File Number)
• Other earnings information (Per Diem, Paid Lunch, Mileage, etc.) - The following data may be read by Dapt from ADP for additional processing such as Certified Payroll:
• Position
• Pay Rate - The following data will be read by Dapt to create or update records in QuickBooks or other accounting platforms:
• Earnings
• Payroll Expenses
• Taxation information
• Deductions information
• Other Pay Items as appropriate
• Employee ID
Job and Project Synchronization
Dapt synchronizes job and project data from your accounting or job management system into your ADP timekeeping system.
Job lists remain aligned across systems so time entries reference current job, phase, and cost code structures.
Payroll Rule Processing
Dapt retrieves approved time data from your ADP timekeeping system and applies configured payroll rules before payroll is finalized. Once your rules are applied the processed payroll data is submitted to ADP for payroll execution.
Supported rule types include:
- Complex overtime scenarios – Easily handle different overtime scenarios and apply OT at any level – Person, Job, or Location.
- Shift differentials – Dapt handles all of the complexities of shift differential including overnight shifts
- State- or job-specific overtime rules – Many states now have additional requirements for overtime. Dapt handles them all including CA paid lunch requirements.
- Certified payroll variable rates – Dapt identifies when a PW job is being worked, retrieves the correct rate, and automatically adjust for company paid fringe benefits.
- FLSA blended rate calculations – Dapt automatically calculates the weekly blended rate for applying the correct FLSA premium for overtime calculations.
- Job-specific pay and allocation rules – Dapt’s preprocessing of time includes dynamic rate calculation and labor cost allocation by job.
- Union benefits and fringe calculations – Union workers often require a complex set of benefits and overtime rules. Dapt makes the application of the correct rate and benefits automatic.
Job Costing
Dapt maintains job and project identifiers as data moves from time tracking through ADP payroll and into your accounting system.
After payroll is completed, Dapt retrieves payroll results and generates job-level accounting entries based on configured labor allocation rules. Labor costs are posted to the appropriate job, phase, cost code, department, or location without manual re-entry.
Certified Payroll
For certified payroll jobs, Dapt applies prevailing wage and classification rules during payroll processing.
After payroll is completed, Dapt synchronizes earnings and paycheck data with time records to automatically generate certified payroll reports.
Flexible Accounting Setup
Dapt supports configurable labor cost allocation rules based on your accounting structure.
Payroll results can be differentiated by:
- Phase or cost code – Breakdown costs by the type of work being performed.
- Department – Include department designations on labor costs.
- Direct vs. indirect labor – Distinguish between direct labor cost (Cost of Goods Sold) and overhead (SG&A).
- Job, project or location – Allocate labor costs by Job, Project, or Location.
Tailored Reporting
Dapt includes a configurable reporting engine for generating customer-specific reports based on synchronized payroll and job cost data.
Dapt has successfully provided reports for:
- And others
- R&D tax credit reporting – Allocate labor costs by R&D and other functions automatically to simplify credit applications.
- Commissions calculations – Dapt can setup a systematic approach to commission making payroll and reporting easy.
- Invoicing – Automatically create invoices based on time and type of work performed. Includes invoicing based on fixed fee for service delivered.
- Workers’ compensation – Reporting to manage workers comp costs by task.
- Union reporting – Full union benefits accounting and reporting.
- Grant reporting – Cost allocation by grant for non-profits.