The QuickBooks Specialists
  Ruth Perryman, MBA, CMA, CFE


The QB Specialists   
411 Manzanita Avenue   
Roseville, CA 95678   
PH: 800-707-0940   
FAX: 888-850-8860   
info@theqbspecialists.com   

  Subscribe to our monthly newsletter Subscribe to our  QuickBooks Tips & Tricks blog Follow us on Follow The QuickBooks Specialists on FaceBook Follow The QuickBooks Specialists on Twitter Follow The QuickBooks Specialists on LinkedIn  


Intuit Solutions Provider Advanced Quickbooks ProAdvisor

Quickbooks Enterprise ProAdvisor Quickbooks Point of Sale ProAdvisor

sitemap


 
.

QuickBooks Tip: How to Enter Payroll Prepared by an Outside Payroll Service in QuickBooks

by Ruth Perryman 18. October 2008 17:27

Even though QuickBooks offers several integrated payroll services, many businesses choose to continue using an outside payroll service like ADP or Paychex.  But this often leads to confusion about how to enter payroll into QuickBooks.  Some choose to re-enter the entire payroll in the Employee Center.  Others want to save time by entering it as a journal entry, but don't know how to enter it correctly.

The problem is that the amount deducted from your checking account for payroll never matches up to your total salaries paid.

  • If you  handle your own payroll taxes, the amount you pay your payroll provider is lower than your salary expense because of employee deductions. 
  • If your payroll service handles your payroll taxes, the amount you pay is higher because employer-paid payroll taxes are tacked on. 

The key to entering your payroll correctly is to understand the difference between gross and net payroll.  Gross payroll is the total amount you pay your employees before deductions.  This is your payroll expense.  Net payroll is what your employees are paid after deductions.  This is a mixture of payroll expense and payroll liabilities that need to be paid sometime in the future--things like state and federal payroll taxes, medical insurance, 401(k) contributions, etc.  These things are not payroll expenses because your employee is paying them rather than you.

Journal Entry if you Handle Payroll Taxes

Memorize the following journal entry and enter it each time you get a payroll report from your payroll service.  You will probably need to add a few accounts.  Salaries & Wages is an expense account, the accounts for the employee deductions are current liabilities:

 Account  Debit  Credit
 Salaries & Wages  Gross Payroll  
 Federal Income Tax    Federal Taxes Withheld
 FICA    FICA Withheld
 Medicare        Medicare Withheld
 State Income Tax        State Taxes Withheld
 Medical        Employee Medical Deduction
 401(k)        Employee 401(k) Deduction
 Other Deductions    Any other Deductions made
 Checking Account            Net Payroll paid

When you pay your payroll liabilities, you book the employee-paid portion to the associated payroll liability account and the portion you pay as a payroll expense.  For instance, when you pay your FICA taxes, you'd book half of the amount to the FICA payroll liability account and the other half as payroll tax expense.

Journal Entry if your Payroll Service Handles Payroll Taxes

Memorize the following journal entry and enter it each time you get a payroll report from your payroll service.  You will probably need to add a few accounts.  Salaries & Wages, FICA and Medicare are expense accounts, the accounts for employee deductions others are current liabilities:

 

 Account  Debit  Credit
 Salaries & Wages  Gross Payroll  
 FICA expense  Employer-paid FICA  
 Medicare expense  Employer-paid Medicare  
 Medical        Employee Medical Deduction
 401(k)        Employee 401(k) Deduction
 Other Deductions    Any other Deductions made
 Checking Account            Net Payroll paid

When you pay your payroll liabilities, you book the employee-paid portion to the associated payroll liability account and the portion you pay as a payroll expense.  For instance, when you pay your FICA taxes, you'd book half of the amount to the FICA payroll liability account and the other half as payroll tax expense.

Still confused?  Consider switching to one of the QuickBooks Payroll Solutions.  Contact me at ruth@theQBspecialists.com for a free consultation to see which one is right for you.

If we helped solve your problem, please consider spending a minute or two posting a review for us. ____________________________________________________________

Ruth Perryman - QuickBooks Specialist Written by Ruth Perryman, CMA, CFE, CFM, MBA, DPA (ABD)

Ruth is the president of The QB Specialists, an Intuit Solutions Provider that has helped thousands of businesses throughout the United States, Canada and even the Caribbean get the most out of QuickBooks since 1996. Ruth has over 20 years of industry experience, including 5 years as a Chief Financial Officer. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks Point of Sale and Enterprise.

For more QuickBooks Tips & Tricks, subscribe to her monthly newslettter.

Looking for QuickBooks Point of Sale or Enterprise? Call 800-707-0940 or email us to save up to 46% off!


Get help from Ruth Perryman!


Subscribe to our QuickBooks Tips & Tricks blogEnjoyed this post? Subscribe to QuickBooks Tips & Tricks via RSS Feed or via Email and receive free daily QuickBooks tips.

Tags:

Powered by BlogEngine.NET 1.4.5.0

 

QuickBooks Point of Sale QuickBooks Enterprise

Looking for QuickBooks
Point of Sale or Enterprise?

Call 800-707-0940 to save up to 46% off!


 

Read QuickBooks Tips & Tricks on Kindle


Web Searchflip camcorder

The QB Specialists
411 Manzanita Avenue
Roseville, CA 95678
PH: 800-707-0940 | FAX: 888-850-8860
Email: info@theqbspecialists.com

Intuit and QuickBooks are trademarks and service marks of Intuit Inc., registered in the United States and other countries.