Got a specific
QuickBooks question?

       Certified QuickBooks ProAdvisor

Didn't find the QuickBooks
tip you were looking for?
Email me so I can answer you directly and then write a blog about it.


Subscribe by Email

Your email:
cta-5-common-quickbooks-errors

Need some
Year End Help?

How to avoid Year End Bookkeeping Problems free eBook! Get it Today!
Read this case study and learn how end of year bookkeeping increased profits by 300%!
Got a question about Quickbooks or bookkeeping? Schedule a free call!
 

 

QuickBooks Tips Blog

Current Articles | RSS Feed RSS Feed

Video QuickBooks Tip: Properly Recording Outsourced Payroll

  
  
  

Many businesses outsource their payroll needs to companies such as ADP, Paychex, Qqest or some other company that handles payroll for businesses.  However, many businesses do not properly account for their outsourced payroll transactions, which will produce inaccurate financials.  In this video I will show you how to accurately record outsourced payroll in QuickBooks.

 

Understanding the difference between payroll liabilities and expenses

In short payroll liabilities are anything deducted from your employees check that will later be distributed.  Things such as employee payroll taxes, 401k, medical etc. should all be considered payroll liabilities if they are deducted out of your employee's checks.  The reason being you will withhold them from your employee's checks (setting up the liability) and later distribute them to some other entity (which zero's out the liability).

Payroll expenses are costs to the employer related to payroll.  Gross wages, employer payroll taxes and payroll service fees are all examples of payroll expenses.  

One common mistake we often see is that when an outsourced payroll company makes a deduction from a business banking account the bookkeeper automatically hits payroll expenses.  However, as you can see in the illustration above the transactions are actually made up of payroll liabilities and payroll expenses.  It is important to figure out what each transaction consists of by looking at the payroll reports provided to you from your outsourced payroll company.  

Use vendors or memorized transactions to record outsourced payroll

I like to break up outsourced payroll into 5 groups:

Actual paper payroll checks - these transactions would be for any employee that actually receives a paper check and is not set up on direct deposit.  It is important to find out from your payroll company if these will hit your bank account as a separate check or be grouped into the deduction the outsourced payroll company takes from your bank account.  If these checks will clear your bank account you need to enter the actual check with the correct check number.  This check will consist of gross wages (expense), employee payroll taxes (payroll liabilities) and any other deductions (payroll liabilities).

Direct deposits - any employee that is set up on direct deposit will fall into this category.  Typically all direct deposits are deducted from your checking account as one transaction.  This will consist of gross wages (expense), employee payroll taxes (payroll liabilities) and any other deductions (payroll liabilities).

Payroll taxes - your payroll taxes will consist of employee payroll taxes (payroll liabilities) and employer payroll taxes (payroll expenses).

Payroll fee - this is the fee your outsourced payroll company charges you for their services and should be coded as a payroll expense.  

Other outside agencies - these transactions would be checks for 401k contributions, ROTH IRA contributions, garnishments etc.  

The most important thing is to set up a vendor for each transaction that hits your business checking account from your outsourced payroll company.  You will have to communicate with your payroll company or look at your checking account activity to determine how they are deducting outsourced payroll related transactions.  I typically set up at least three vendors in QuickBooks: Payroll Wages, Payroll Taxes and Payroll fee.  The reason I set up vendors is that the account details of those transactions will automatically be recalled when you enter the next payroll.  Once you have a system down you just need to look at your payroll reports and plug in the correct numbers.

You can apply the same method by using QuickBooks memorized transactions.  You could memorize your checks for payroll wages, payroll taxes, payroll fee and any other transactions related to your outsourced payroll. 

Recording outsourced payroll in QuickBooks can be tricky at first.  The most important thing is to find out how the various transactions will hit your bank account and to mirror that activity in QuickBooks.  It is also important to understand the difference between payroll liabilities and expenses and how to properly record them in QuickBooks.  If you incorrectly record your outsourced payroll it will result in inaccurate financials.  

cta-5-common-quickbooks-errors

 

 

 

Follow us on Google+

Note: This blog does not claim credit for images posted on this site unless specified.  Images are copyright to their respectful owners.  If there is an image that appears on this blog that belongs to you and you do not wish for it to appear on this site please emailmatt@slcbookkeeping.com with a link to the image and it will be removed.

Comments

I just want to take the time out to thank you for this tutorial. It is the only one that has helped me after countless searches online. Surprising that such a simple process for common procedure/problem was so hard to find on the web. Thanks again.
Posted @ Wednesday, February 27, 2013 11:53 AM by Elaine
Love this tutorial....I am a visual person when it comes to learning so this works vs. trying to following what someone has written...awesome...thanks!
Posted @ Thursday, March 14, 2013 6:26 PM by michele
Wow, what a blessing you are! I have searched and searched for a direct answer to how to record my outsourced payroll. You are awesome. I am very nervous knowing now that my over paid accountant has not caught the way we have been recording things. All of our stuff either goes to COGS or Expense when it concerns payroll. I have known this was wrong all along but could never find the answer. I do have 2 questions 1) instead of having the vendor named Paychex on the check - I enter it just like you have shown and it does not matter for audit purposes ( if we were ever audited) ? 2) Even though my books have been reconciled through May and my bookeeper has 5 transactions per payroll (so that it will match with the debits) can I adjust these entries (each one separately) ? I am really wanting to show our true cost and I am up for the task.  
Let me say again how excited I am that I did not give up and I found your website. I too am a visual person and this just rocks!!! Please email me and let me know the answers and I will also check back to see if you have posted one on here. I hope I am in the right area to be doing this. I am using my phone :-).
Posted @ Thursday, July 04, 2013 2:46 AM by Jess
This tutorial was extremely helpful and right on point with what I was looking for direction on. Great resource- thanks for putting it out there.
Posted @ Saturday, September 21, 2013 1:07 PM by Rick
This is a great post about outsourced payroll. Those businesses that are engaged in such will surely find this as informative. Thank you for sharing.
Posted @ Monday, October 14, 2013 7:31 PM by Luetta Fox
Seems a bit long winded. Use a journal that comes from the payroll report and post bank payments to the control accounts.
Posted @ Monday, December 23, 2013 9:25 AM by scott
Post Comment
Name
 *
Email
 *
Website (optional)
Comment
 *

Allowed tags: <a> link, <b> bold, <i> italics