Getting Payroll Data into Quickbooks
February 25th, 2009 by Michael Giuffrida
For 12 years in business I managed to avoid using an outsourced payroll service. I simply used QuickBooks for processing my payroll and while it was a little more costly per person than a large payroll house like ADP or Paychex, it was simple and all in one place.
As ForeSite has grown I decided I needed more help with my HR functions. I tried a small HR company but had nothing but issues with availability and consistency. I heard about ADP TotalSource which sounded like a dream come true. I could get a full scale HR department for a fraction of the actual cost, and get the advantage of scale when using their benefits. The only hitch was that I HAD to use their payroll services for this to work. I only had two requirements for this project: 1) The payroll transition had to be seamless for my employees, and 2) All of the information from a payroll run needed to be bought back into QuickBooks so I can run reports as I do today. ADP promised me that this was not a problem so I went ahead and signed up.
Unfortunately, they stretched the truth about getting data back into QuickBooks and I found myself out of luck after dealing with several levels of support at ADP. So as a software development shop, what did we do? We built it ourselves. I had our development team create an application that can take the simple tab delimited download report from ADP and create all of the proper journal entries so my accounting records are accurate. It works great and has solved my problem, but buyer beware if you are signing up for one of these payroll services. Getting data back into your accounting system is not as easy as they say it might be without having someone do additional work or having a program like the one we have built at ForeSite.
May 1st, 2009 at 6:52 pm
Looks like there’s a demand for this code. Hmmm…
November 10th, 2009 at 2:43 pm
It is a simple journal entry to record your ADP payroll in QuickBooks. It will take your bookkeeper less than 5 minutes. Much less than what it would take her or him to do the whole payroll. That entry is:
Debit:
Salaries & Wages the amount of the Gross Payroll
FICA expense the amount of Employer-paid FICA
Medicare expense the amount of Employer-paid Medicare
Credit:
Medical the amount of Employee Medical Deduction
401(k) the amount of Employee 401(k) Deduction
Other Deductions the amount of Any other Deductions made
Checking Account the amount of Net Payroll paid
November 12th, 2009 at 5:32 pm
Thanks for your feedback Diane. The issue we had doing the simple journal entry was that we lost the integrity of the data. This meant that we could no longer run our profit and loss reports by class, line of business, department, etc because all payroll expense was in one big bucket. I agree if the data integrity does not matter for reporting purposes, that is an easy way to get the bulk numbers in the system.
August 12th, 2010 at 7:47 am
Business, that’s easily defined - it’s other people’s money.