Video QuickBooks Tip: Properly Recording Outsourced Payroll

| 2 min read

Video QuickBooks Tip: Properly Recording Outsourced Payroll

Many businesses outsource their payroll needs to companies such as ADP or Paychex.  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 from 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.

Types of Outsourced Payroll

 

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.  

Click me

 

 

 

remote-bookkeeping2w

An Affordable Bookkeeping Alternative to a CFO

Outsourcing your bookkeeping is more affordable than you would think. We save you money the moment you hire us by cutting out the expensive cost of hiring an in-house CFO.

Working with a remote bookkeeping service will still provide you with all the value you could get from an in-office bookkeeper but at a fraction of the cost.

Learn more

Learn How We Can Impact Your Business Growth

You’ve got your company’s best interest in mind. Guess what? So do we! You can rest assured that we will work closely with you to create actionable business plans and accurate financial reporting. We offer our toolkit of financial intelligence that will be your greatest asset for business growth.

Contact an Advisor