• You've already voted on this page
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
QuickBooks General Forum QuickBooks Payroll 3rd Party Apps that work with QuickBooks QuickBooks Accountant Edition QuickBooks Online for Accounting Professionals QuickBooks Enterprise Solutions QuickBooks Point of Sale
ProAdvisor Program & Certification
ProSeries DMS ProSeries Community
Lacerte DMS Lacerte Community
Intuit Tax Online Tax Research for Lacerte and ProSeries Tax Import for Lacerte and ProSeries Intuit Practice Management EasyACCT Intuit Statement Writer
Starting and Managing Your Practice Classifieds Intuit ProConnection Newsletter Intuit Academy Training Your Peers Recommend
  • QuickBooks & Payroll
  • ProAdvisors
  • Lacerte
  • ProSeries
  • Productivity Tools
  • Training & Resources
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help for Accountants   Training and Resources   Intuit ProConnection Newsletter   Accountant Community Allstars Forum   Getting Started   Intuit Academy Training   Starting and Managing Your Practice   QuickBooks and Payroll   QuickBooks General Forum  
hide
05/24/2012 at 04:51PM PDT
Important Announcement! A planned system-wide upgrade will take place over the Memorial Day Weekend in the US (From Thurs, May 24, 2012 at 6 pm PDT thru Tues, May 29, 2012 at 5 am PDT). This includes QuickBooks, QuickBooks Payroll, Point of Sale, & Salesforce.com. This is only for US based products. This does not affect QuickBooks Online customers! During this time, you can shop, but can’t place orders online, activate products or update account info. We apologize for the inconvenience & thank you for patience while we improve our infrastructure to better serve you. International versions are unaffected. For more info, see our community discussion.
1
60
b0LpFEFBir36uBacfA8pyY
Subscribe RSS
Alpha786
Alpha786
Questions asked: 5
Questions answered: 1
Points earned: 1
Alpha786
Alpha786
Questions asked: 5
Questions answered: 1
Points earned: 1
New Member
06/21/10 9:10pm PDT
Viewed by asker 06/27/10 6:42pm PDT

Quickbooks with ADP payroll

 

Hello, a small consulting company I am doing bookkeeping for gets payroll services from ADP. How do I update QuickBooks for employees/bank account/taxes, etc.?

Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
8 Replies
lynda
lynda
Questions asked: 6
Questions answered: 28309
Points earned: 78834
Advanced Certified ProAdvisor
Advanced Certified ProAdvisor
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks experts.
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Allstar
Allstar
Advisory council of community power users.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Intuit Moderator
Intuit Moderator
Mod/Co-mod
Certified ProAdvisor - ES
Certified ProAdvisor - ES
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient Enterprise Solutions experts
lynda
lynda
Questions asked: 6
Questions answered: 28309
Points earned: 78834
Allstar
06/22/10 4:27am PDT

Enter the J/E like this:

1. Set the file preferences to No Payroll.
2. Go to your chart of accounts and change the name on the default QuickBooks accounts: Payroll Liabilities-old and Payroll Expenses-old & make them inactive.
3. Create your own payroll accounts, Payroll Liabilities and Payroll Expenses
4. Set up a journal entry (and memorize it to use each paycheck date).
5. Debit_Gross Wages
6. Credit_Health (if applicable - employee contributes)
7. Credit Advances (if applicable - employee repays advance)
8. Credit Garnishments (if applicable - employee has wages garnished)
9. Debit Payroll tax expense (total Employer Paid to one account)
10. Credit Checking for Payroll tax liabilities (use your new Payroll tax liability account)
11. Debit Payroll service fee (for Paychex, ADP or other payroll service. invoice)
12. Credit Checking (Paychex ADP, etc. invoice withdrawal)
13. Credit Checking (direct deposit total)
14. Credit Checking Net payroll by entering the net paychecks for each of your employees.

Please mark this question as solved if it resolved your issue to close this thread. If not, please feel free to ask more questions. Clicking “thank you” does not close the thread.
 

If this answers your question, please mark this question as “SOLVED”. Also, please fill out the survey you will receive to help make the community better.

Lynda Artesani
Artesani Bookkeeping

www.artesanibookkeeping.com
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
1
 Report Abuse
 
 
 
MSBYRD
MSBYRD
Questions asked: 3
Questions answered: 5
Points earned: 15
New Member
09/08/10 11:15am PDT
Latest post

Hi Lynda,

How would you handle it if the outsourced payroll company paid your garnishments for you?

Thank you,

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
RekaUjj
RekaUjj
Questions asked: 2
Questions answered: 2938
Points earned: 8058
Allstar
Allstar
Advisory council of community power users.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
RekaUjj
RekaUjj
Questions asked: 2
Questions answered: 2938
Points earned: 8058
Allstar, Accountant Community AllStar
06/22/10 4:34pm PDT

Or just make the payment to ADP hit the Payroll Services Expenses account.

Reka

Please mark the post Solved or give me a "thumbs up" if I could help.
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
Haji_
Haji_
Questions asked: 11
Questions answered: 19
Points earned: 22
Haji_
Haji_
Questions asked: 11
Questions answered: 19
Points earned: 22
Contributor
06/23/10 4:07pm PDT

Thank you Reka and Lynda.

I followed Lynda's advice and I created NEW Payroll Liability (under other liabilities) and Payroll Expenses accounts. I entered Payroll Liability journal entry, when I paid the ADP/(employee wages ) from my bank account, the wages on P&L cancelled each other--journal entry was -ve and ADP Check was +v.
 
I am kind of lost here.

I have created:
      - Payroll Expenses
            - ADP Payroll Fees
            - Employer Payroll Taxes
            - Wages ( I don't need to break it up, because
                                 ADP will take care of net pay and taxes)

How can I enter Payroll Liability, and pay to ADP from my BANK account under listed above PAYROLL EXPENSES accounts. In my P&L I see wages paid in my expense section.

Thank you for your kind help.

Regards.

 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
lynda
lynda
Questions asked: 6
Questions answered: 28309
Points earned: 78834
Advanced Certified ProAdvisor
Advanced Certified ProAdvisor
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks experts.
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Allstar
Allstar
Advisory council of community power users.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Intuit Moderator
Intuit Moderator
Mod/Co-mod
Certified ProAdvisor - ES
Certified ProAdvisor - ES
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient Enterprise Solutions experts
lynda
lynda
Questions asked: 6
Questions answered: 28309
Points earned: 78834
Allstar
06/23/10 4:46pm PDT

Since you are using an outside service, you just need to make the journal entry described above for the payroll entry and also enter the net checks for your employees as well as a check to record the service charge for ADP.

 

If this answers your question, please mark this question as “SOLVED”. Also, please fill out the survey you will receive to help make the community better.

Lynda Artesani
Artesani Bookkeeping

www.artesanibookkeeping.com
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
1
Reply to this Answer
 Report Abuse
 
 
 
RekaUjj
RekaUjj
Questions asked: 2
Questions answered: 2938
Points earned: 8058
Allstar
Allstar
Advisory council of community power users.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
RekaUjj
RekaUjj
Questions asked: 2
Questions answered: 2938
Points earned: 8058
Allstar, Accountant Community AllStar
06/24/10 1:17pm PDT

To make it easier for you, here is an idea:

If ADP pays all the payroll taxes, medical insurances, retirement deductions/matches, etc and you pay one check per pay period to ADP:

Create the check with "split" lines (the total amount will be distributed to more than one account). Use the following lines:

Wages (total gross wages from the ADP bill - It can be Payroll Expenses, too)

Payroll Taxes (this would be only the company portion of the payroll taxes - you can separate them to FICA (= social security + Medicare), Federal Unemployment Taxes, and State Unemployment Taxes)

Workers Compensation (if you have any)

Employee Medical Benefits (the company portions of the health, dental, etc insurances)

Retirement Expenses (only the company portions of SIMPLE IRA, 401(k), or whatever retirement plan you have)

Employee Service Fees (ADP's fees)

The total amount should give the total due to ADP. All of these can be separate accounts (Wages, Payroll Taxes, Fed. Unempl. Taxes, State Unempl. Taxes, Workers Comp, Employee Medical Benefits, Retirement Expenses, Employee Service Fees). You can break it up as much as it makes sense for you. Or you can use one account for everything: Payroll Services Expenses. If you are not paying anything separately, but ADP takes care of all the payments, this is the way to go.

If you yourself (I mean your company) is paying for most of the payroll liabilities and ADP only calculates the payroll checks, it is a whole different story. In that case you might rather use the actual payroll checks mode, though you can use the "After the fact" feature because all the amounts are going to be given to you by ADP. If this is the case, please "Comment" it, then I will try to give you a solution for this scenario, too.

Reka

Please mark the post Solved or give me a "thumbs up" if I could help.
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
1
Reply to this Answer
 Report Abuse
 
 
 
Haji_
Haji_
Questions asked: 11
Questions answered: 19
Points earned: 22
Haji_
Haji_
Questions asked: 11
Questions answered: 19
Points earned: 22
Contributor
06/24/10 1:32pm PDT

Thank you again.

ADP will take care of payments, and the company will take care of ADP. Reka, you suggest that since ADP is making all the payment -- wages, taxes, etc., all I have to do is break the amount in various account and enter as PAYROLL EXPENSE. When I do this drill, I get P&L showing all the details. However, if I enter PAYROLL LIABILITY JOURNAL and breakup ADP invoice in to various accounts, then things get messy. I like to break up ADP invoice so that the company folks know how the funds were distributed in to various accounts.

Now, the question is, should I make entries in PAYROLL LIABILITY JOURNAL at all. This is first time I am messing up with PAYROLL as you can tell. I will give this forum a hard time, especially Lynda and Reka, but I will learn.

Once again, thank you for your kind help and BEST REGARDS.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
Alpha786
Alpha786
Questions asked: 5
Questions answered: 1
Points earned: 1
Alpha786
Alpha786
Questions asked: 5
Questions answered: 1
Points earned: 1
New Member
06/27/10 6:42pm PDT

I guess, I figured it out how to enter into QB using ADP payroll services.

I enter my payroll liabilities -- wages and employer portion of payroll into PAYROLL LIABILITIES journal. I can break up each employees wage and employer taxes separately. When I pay ADP, I can enter a check with PAYROLL LIABILITY account. This way, I cleared the liability and I have liability distributed into respective account. I can pay ADP for their services as a separate entry in PAYROLL EXPENSES -- like bill pay (not as a PAYROLL LIABILITY though).

Does this sound a reasonable approach.

Thansk.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
   
 
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
  • oursource payroll
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
Michelle Long CPA
1 min ago
Michelle Long CPA
replied to
Fixed Assets on the balance...
debra2112
19 mins ago
debra2112
replied to
Automatic conversion of QBA...
EricPOS
1 hr ago
EricPOS
replied to
wrong image being displayed...
sjrcpa
1 hr ago
sjrcpa
replied to
How do like Intuit Online Tax?
Michelle Long CPA
1 hr ago
Michelle Long CPA
replied to
Can I dumb it down for my c...
Product Resources
QuickBooks Tax Products Payroll ProAdvisor Program Training and Certification Feedback Survey
Resources: Find Local ProAdvisor Tax Almanac Practice Resources
Support: QuickBooks Lacerte ProSeries EasyACCT
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2012 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business