more-arw search

Q&A Forum

ADP GL Reconciliation to Payroll Cash Account

ADP reconciliation payroll cash accountHello, I was wondering if anyone on this forum has had experiencing working with the ADP GL interface of ADP to create your journal entries for payroll. My company uses ADP GL, but we have been having trouble reconciling to our cash account. We did go through the ADP payroll register vs. ADP GL and agreed it completely so we know we do not have a setup issue within ADP GL. The issue we are having is the Cash pulled from the bank is different than what is populating in ADP GL. Does anyone know the common issues associated with reconciling? It looks like the main issue is manual checks, but want to see if anyone else had thoughts. I have tried contacting ADP GL and they have not been very helpful.

Answers

Anonymous
(Controller) |

I have had simlar issues. We use ADP GL interface and although the cash deducted from the bank do reconcile, we have had issues reconciling employee deductions. The reporting that comes from the PayAtWork ADP system is not user friendly and I have also not found ADP support helpful either. I'm almost at a point where I am ready to start looking at other options. Hopefully someone here can help.

Ben Chang
Title: Director of Finance and Accounting
Company: Transportation & Logistics
(Director of Finance and Accounting, Transportation & Logistics) |

How is your GL organized? We would use a suspense account ("Payroll Clearing") as the credit side of the ADP interface totals. We would then reconcile the bank using the ADP payroll register (Grand totals Page?) debiting the Payroll Clearing account and crediting Cash. This should zero the Payroll Clearing every payperiod, and help you quickly see the differences.

Aaron Lowery
Title: Payroll Consultant
Company: Payday Payroll Resources
(Payroll Consultant, Payday Payroll Resources) |

Hello. What kind of accounting system do you use (ie Peachtree, Quickbooks) ?

Topic Expert
Patrick Dunne
Title: Chief Financial Officer
Company: Milk Source
(Chief Financial Officer, Milk Source) |

This is a common issue. ADP sends us transactions (faxes) of all "one time" transactions. We track these religiously in baking into our reconciliation process. Some of the more common problems you mentioned...including manual checks from A/P that need to get back into the system, tax payments that ADP may address that you have to account for. Tracking and recording all transactions from these (almost daily) reports from ADP is critical. Good luck.

Ken Stumder
Title: Finance Director / Controller
Company: Ken Stumder, CPA
(Finance Director / Controller, Ken Stumder, CPA) |

We use ADP's G/L interface and I have to say it works exactly as it should. The only thing I can imagine is that some of the employee related deductions are not mapped correctly and/or variable payroll/service fees (which are debited separately to our bank account) are deducted alongside the payroll related costs leaving you with this reconciliation issue.

Lynne Holloman
Title: Accounting Manager
Company: Woodside Equine Clinic
LinkedIn Profile
(Accounting Manager, Woodside Equine Clinic) |

I have found that if you have a check to a IRA account that they are sending, you will need to add that amount to the bank withdrawal on the journal entry.

10553 views
Topics

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.