# External payroll integration and ADP **URL:** \ **Category:** Epicor ERP 10\ **Tags:** e10\ **Created:** [September 9, 2019, 1:46pm UTC](https://www.epiusers.help/t/external-payroll-integration-and-adp/59537 "2019-09-09T13:46:39Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Tim1](https://www.epiusers.help/user_avatar/www.epiusers.help/tim1/32/17954_2.png) [@Tim1](https://www.epiusers.help/u/Tim1)\ **Post date:** [September 9, 2019, 1:46pm UTC](https://www.epiusers.help/t/external-payroll-integration-and-adp/59537/1 "2019-09-09T13:46:39Z")
We are gathering time data through MES and creating a file through External Payroll integration. We can’t get ADP to provide us with the method to load this file into ADP Workforce Now. Is anybody doing a similar method? ---
**Author:** ![Devin.Draeger](https://www.epiusers.help/user_avatar/www.epiusers.help/devin.draeger/32/63726_2.png) [@Devin.Draeger](https://www.epiusers.help/u/Devin.Draeger)\ **Post date:** [September 10, 2019, 8:52pm UTC](https://www.epiusers.help/t/external-payroll-integration-and-adp/59537/2 "2019-09-10T20:52:16Z")
We actually are using adp as well but they added a module called time bank for us. We upload the file through time bank and update the information in workforce now. ---
**Author:** ![Tim1](https://www.epiusers.help/user_avatar/www.epiusers.help/tim1/32/17954_2.png) [@Tim1](https://www.epiusers.help/u/Tim1)\ **Post date:** [September 10, 2019, 9:00pm UTC](https://www.epiusers.help/t/external-payroll-integration-and-adp/59537/3 "2019-09-10T21:00:16Z")
So you’re creating the file through External Payroll Integration and loading it into time bank. Besides having ADP add the module do you have any other words of wisdom? ---
**Author:** ![Devin.Draeger](https://www.epiusers.help/user_avatar/www.epiusers.help/devin.draeger/32/63726_2.png) [@Devin.Draeger](https://www.epiusers.help/u/Devin.Draeger)\ **Post date:** [September 10, 2019, 9:04pm UTC](https://www.epiusers.help/t/external-payroll-integration-and-adp/59537/4 "2019-09-10T21:04:25Z")
we don’t have the external payroll module but we use a baq and export to excel. And we use the import option under utilities to upload the data. Not sure if that helps or not. ---
**Author:** ![BAWELCH49](https://www.epiusers.help/letter_avatar_proxy/v4/letter/b/41988e/32.png) [@BAWELCH49](https://www.epiusers.help/u/BAWELCH49)\ **Post date:** [October 5, 2021, 3:09pm UTC](https://www.epiusers.help/t/external-payroll-integration-and-adp/59537/5 "2021-10-05T15:09:21Z")
Saw your post RE: **ADP external Payroll.** You said you use a BAQ to extract data. ADP wants a ‘Punch File’ field layout: Company; EmpID; Date; Time (24 hrs); Type (Clock-in/out) Epicor LaborHead has Clock-in & Out of same record. How do you extract this to the ADP layout? Can you share your BAQ? All assistance is appreciated. ---
**Author:** ![BAWELCH49](https://www.epiusers.help/letter_avatar_proxy/v4/letter/b/41988e/32.png) [@BAWELCH49](https://www.epiusers.help/u/BAWELCH49)\ **Post date:** [October 5, 2021, 3:10pm UTC](https://www.epiusers.help/t/external-payroll-integration-and-adp/59537/6 "2021-10-05T15:10:07Z")
Tim - trying to build the BAQ to extract the punches. ---
**Author:** ![Devin.Draeger](https://www.epiusers.help/user_avatar/www.epiusers.help/devin.draeger/32/63726_2.png) [@Devin.Draeger](https://www.epiusers.help/u/Devin.Draeger)\ **Post date:** [October 5, 2021, 8:29pm UTC](https://www.epiusers.help/t/external-payroll-integration-and-adp/59537/7 "2021-10-05T20:29:30Z")
Here is the BAQ we are using. This is done in 10.2.700 If you have any questions let me know. We are only looking at the start of the day and end of day. [ADPClockData.baq](https://www.epiusers.help/uploads/short-url/c9thKZgGZcsRqRQk4vrY2lNXN0t.baq) (19.4 KB) ---
**Author:** ![BAWELCH49](https://www.epiusers.help/letter_avatar_proxy/v4/letter/b/41988e/32.png) [@BAWELCH49](https://www.epiusers.help/u/BAWELCH49)\ **Post date:** [October 5, 2021, 9:17pm UTC](https://www.epiusers.help/t/external-payroll-integration-and-adp/59537/8 "2021-10-05T21:17:02Z")
Glory be. Thank you ---
**Author:** ![BAWELCH49](https://www.epiusers.help/letter_avatar_proxy/v4/letter/b/41988e/32.png) [@BAWELCH49](https://www.epiusers.help/u/BAWELCH49)\ **Post date:** [October 6, 2021, 2:14pm UTC](https://www.epiusers.help/t/external-payroll-integration-and-adp/59537/9 "2021-10-06T14:14:17Z")
Devin Thank you for the BAQ. ADP is requesting a sperate record for Punch-in Punch-out Layout: ---
**Author:** ![Devin.Draeger](https://www.epiusers.help/user_avatar/www.epiusers.help/devin.draeger/32/63726_2.png) [@Devin.Draeger](https://www.epiusers.help/u/Devin.Draeger)\ **Post date:** [October 6, 2021, 3:03pm UTC](https://www.epiusers.help/t/external-payroll-integration-and-adp/59537/10 "2021-10-06T15:03:17Z")
You should be able to look labor detail table and you should be good. ---
**Author:** ![slorenz](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@slorenz](https://www.epiusers.help/u/slorenz)\ **Post date:** [December 10, 2021, 7:23pm UTC](https://www.epiusers.help/t/external-payroll-integration-and-adp/59537/11 "2021-12-10T19:23:24Z")
Babette, Would you be able to share the columns that are needed for your load? We are trying to load through a csv file and need to know the format that is needed. ---
**Author:** ![timshuwy](https://www.epiusers.help/user_avatar/www.epiusers.help/timshuwy/32/90122_2.png) [@timshuwy](https://www.epiusers.help/u/timshuwy)\ **Post date:** [December 10, 2021, 7:53pm UTC](https://www.epiusers.help/t/external-payroll-integration-and-adp/59537/12 "2021-12-10T19:53:03Z")
As an Epicor Product Manager, I am interested in any #Integration discussions.