• Was this page helpful?
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 Payroll  
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
57
dHnDrntr8r4yUOacwZ5xHE
Subscribe RSS
Swimster
Swimster
Questions asked: 28
Questions answered: 19
Points earned: 19
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Swimster
Swimster
Questions asked: 28
Questions answered: 19
Points earned: 19
Contributor
02/01/12 2:01pm PST
Viewed by asker 02/06/12 1:09pm PST

Grosssing Up Payroll to reflect manual payroll checks

US QuickBooks Pro for Windows : 2011

My client wrote 3 manual checks to his employee, before he purchased payroll, but I need to supply a W-2 with the correct info. There were no taxes taken out either. How do I perform that task?

Carrie Pavao
Certified QB ProAdvisor
Certified Public Bookkeeper
Solved!
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
7 Replies
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43429
Points earned: 106570
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43429
Points earned: 106570
Allstar, Accountant Community AllStar
02/02/12 1:45pm PST
The solution

Is this for 2011?

Those checks should be posted to Other Asset; treat them as employee loans.

Then create the payroll checks for 12/31/2011; gross up everything. Repay the loans. You can read in Help and in Payroll Setup how to do this on the paychecks.

Every paycheck Net should be $0, of course.

The finish all the liability payments, reports, late fees and penatlies, whatever applies for 2011.

If this post answers your question, please give a "thumbs up" or mark this Solved to let others know about it.

If you get an emailed Survey, please take a moment to follow up here, too. Thanks!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
10
 Report Abuse
 
 
 
Swimster
Swimster
Questions asked: 28
Questions answered: 19
Points earned: 19
Contributor
02/02/12 3:22pm PST

Yes. The checks were written in May and June of 2011. I've discussed your solution with the client's CPA and she likes this. Hopefully I'll get it right. Thanks so much for your 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
 
 
 
Swimster
Swimster
Questions asked: 28
Questions answered: 19
Points earned: 19
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Swimster
Swimster
Questions asked: 28
Questions answered: 19
Points earned: 19
Contributor
02/02/12 7:42pm PST

I'm really confused doing this process. I recategorized the 3 checks into the asset account. I went to payroll items and set up an employee loan item (it only allows me to do that as other item). Then I check on the net/gross  calculation but I can't figure out what the heck I'm doing wrong. It keeps wanting to use the main payroll item instead of the loan that I set up and at the botton of the screen it doesn't equal zero like you mentioned. I've searched the help section but it's not real clear either. Thank you in advance for your help.

Carrie Pavao
Certified QB ProAdvisor
Certified Public Bookkeeper
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
 
 
 
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43429
Points earned: 106570
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43429
Points earned: 106570
Allstar, Accountant Community AllStar
02/02/12 9:52pm PST

Your paycheck will look something like this.

Top left:

Regular pay item(s) and a value that is grossed up wages.

Let all taxes calculate. Net Paycheck is the total given out in 2011.

Now select, in the middle left:

Deduction item that has no tax tracking (NONE, not Other) and is a Net Pay deduction and is linked to the same Other Asset account. This is the Repayment item. This gets the Net Paycheck value.

This paycheck now = $0.

You need to give Pay, let taxes calculate, then deduct the amount that is "funds already paid out" to avoid paying them out again.

Now you have YTD wages, taxes, withholding, etc.

But no further payout of funds.

And the Loan account balance should = $0, so reconcile it.

If this post answers your question, please give a "thumbs up" or mark this Solved to let others know about it.

If you get an emailed Survey, please take a moment to follow up here, too. Thanks!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
Swimster
Swimster
Questions asked: 28
Questions answered: 19
Points earned: 19
Contributor
02/03/12 11:29am PST

I created the paycheck and it zeroed out. I'm not sure what you meant by "then deduct the amount that is "funds already paid out" to avoid paying them out again". The taxes now show up as a liability, as it should be and will be paid today, and the asset account is now zero.

If I missed something on the "funds already paid out" portion would be explain that to me? I really appreciate you taking the time to run through this. I've printed those string out so that I can file it for future reference (let's hope I don't need it) if required.

You saved the day!

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
 
 
 
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43429
Points earned: 106570
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43429
Points earned: 106570
Allstar, Accountant Community AllStar
02/03/12 1:04pm PST

You create a paycheck, entering as Pay the amounts that should have been Taxable Compensation.

You allow taxes to calculate and be withheld.

This results in a Net paycheck.

We don't want a Net paycheck. We arleady gave them the funds.

We want no further payout.

So, you use a net pay deduction item on the paycheck, to avoid paying out on a paycheck the same Net Pay that reflects the amount already given to them and not run through payroll.

Here:

I hand you a $100 bill as a bonus.

I create a year end paycheck. I gross up the wages, to be $100 plus whatever is required; to end, after all taxes calculate, with a Net Paycheck of $100.

But, wait: I already gave the $100 to you!

I write the $100 as an employee loan (other asset)

So, on the paycheck, I use a Net Pay, None tax tracking, Deduction item. This is -$100 and this payroll deduction item links to the Other Asset account.

Now, the paycheck total Net Pay (takehome) = $0.

Now, the taxes are calculated.

Now, the Other Asset account is $0 ($100 out and $100 recaptured). Reconcile it.

If this post answers your question, please give a "thumbs up" or mark this Solved to let others know about it.

If you get an emailed Survey, please take a moment to follow up here, too. Thanks!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
5
 Report Abuse
 
 
 
Swimster
Swimster
Questions asked: 28
Questions answered: 19
Points earned: 19
Contributor
02/06/12 1:09pm PST
Latest post

Perfect. Worked out seamlessly. Thanks so much for all your help I really appreciate it (as I'm sure my client does as well). Have a great week!

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
  • 2011
  • us quickbooks pro for w...
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
opacpa
10 mins ago
opacpa
replied to
Renewal fee increase 20% ?!...
Skimper13
14 mins ago
Skimper13
replied to
Too many users?
Skimper13
17 mins ago
Skimper13
replied to
validation code
TheDudeAbides
17 mins ago
TheDudeAbides
posted
Project Segmentation
Skimper13
20 mins ago
Skimper13
replied to
reset admin password
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