• You've already voted on this page
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en Español QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
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 with Intuit Products   Intuit Payroll   QuickBooks Payroll (Desktop)  
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.
70
267
dICiH8eBir3zw9abTJhmjm
Subscribe RSS
Diogenes0214
Diogenes0214
Questions asked: 1
Questions answered: 3
Points earned: 3
Diogenes0214
Diogenes0214
Questions asked: 1
Questions answered: 3
Points earned: 3
New Member
03/07/08 6:44pm PST

Recording Year End Payroll Liabilities in cash basis accounting

How do you record unpaid year end payroll liabilities at the end of the year. I always thought even in a cash environment that you needed to balance the expensed gross payroll reported to the 940 & W3 amounts. If that isn't correct, what do you do with the liability?

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
12 Replies
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
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.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
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
Certified ProAdvisor - POS
Certified ProAdvisor - POS
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks POS experts
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
Allstar, Accountant Community AllStar
03/11/08 3:10am PDT

Sales tax, payroll tax, and credit card liabilities are all on your books at year end - whether cash or accrual basis.

Payroll is expensed on the actual check date. Unless your payroll taxes are impounded, you will have a payroll tax liability on your books at year end. If you are cash basis, you will not have accrued payroll on your books.

It is only the accounts payable/accounts receivable numbers that are 'reversed' for cash basis accounting.

This is my understanding. . .

Laura D

My motto:
Keep it as simple as you can. . .with only as much detail as you need.

When in doubt, make a backup first!!

*****
Laura Dion
Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com
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
 
 
 
teacherL
teacherL
Questions asked: 0
Questions answered: 4
Points earned: 4
teacherL
teacherL
Questions asked: 0
Questions answered: 4
Points earned: 4
New Member
03/11/08 7:50pm PDT

What do you mean by "reversing" accounts payable/accounts receivable? On the cash basis balance sheet - accounts payable (including sales tax payable & payroll tax payable) - shows up on the liabilities/equity side of equation.

As far as Accounts receivable - shouldn't Quickbooks know to take this out of net income instead of including this on a cash basis balance sheet?

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
 
 
 
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
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.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
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
Certified ProAdvisor - POS
Certified ProAdvisor - POS
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks POS experts
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
Allstar, Accountant Community AllStar
03/12/08 4:33am PDT

Just to clarify. ..

In QuickBooks, there are different types of liability accounts - accounts payable type, credit card type, and current liability type (for sales tax, payroll tax and short term loans) and long term liability type (for note balances not expected to be paid off in the ensuing year).

Accounts payable should be used for entering bills for purchases and services,
b not
for entering bills for liabilities like credit cards, sales tax, payroll tax, or for loan payments.

When you use the accounts payable for those types of 'bills' in QuickBooks, they will still show up on a cash basis report, but, instead of under 'current liabilities' as your accountant wants to see them, they remain under Accounts Payable, which isn't acceptable on a cash basis report.

As for Accounts Receivable, if you are entering Invoices (using items which point to your income account) any Open Invoices will not show up on your Cash basis report. If you have any amount in Accounts Receivable on a cash basis, you might have unapplied credits or prepayments from a customer. . or, perhaps, another issue. . .

The CPAs I work with prefer to keep the reports on an accrual basis and (manually) back out the a/p and a/r numbers for tax purposes.

Does this help?

Laura D

My motto:
Keep it as simple as you can. . .with only as much detail as you need.

When in doubt, make a backup first!!

*****
Laura Dion
Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com
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
 
 
 
teacherL
teacherL
Questions asked: 0
Questions answered: 4
Points earned: 4
teacherL
teacherL
Questions asked: 0
Questions answered: 4
Points earned: 4
New Member
03/13/08 8:38am PDT

Thanks for the helpful advice. So should I include Accounts payable on my tax return balance sheet? If I don't include it - it won't balance. So should I edit the name of Accounts Payable to "current liabilities" then? Unfortunately - my accounts receivable is negative on the cash basis balance sheet but postive & correct on the accrual basis balance sheet.

Shouldn't Accounts payable adjust the COGS acount?

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
 
 
 
Diogenes0214
Diogenes0214
Questions asked: 1
Questions answered: 3
Points earned: 3
Diogenes0214
Diogenes0214
Questions asked: 1
Questions answered: 3
Points earned: 3
New Member
03/28/08 1:35pm PDT

I guess my question was not clear. I expensed the gross payroll that balanced with the Gross payroll reported on the W3 and 940. A portion of that remained unpaid as of 12/31. The offset was reported as a payroll liability on the balance sheet. The company on is a cash basis. Do I need to back out the liability from the expense or is it ok to reduce taxable income by the unpaid portion of payroll taxes?

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
 
 
 
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
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.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
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
Certified ProAdvisor - POS
Certified ProAdvisor - POS
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks POS experts
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
Allstar, Accountant Community AllStar
03/29/08 10:40am PDT

Neither. . even though you are on cash basis, you will have a current liability account called Payroll Tax Liabilities as of year end.

Laura D

My motto:
Keep it as simple as you can. . .with only as much detail as you need.

When in doubt, make a backup first!!

*****
Laura Dion
Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com
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
 
 
 
Diogenes0214
Diogenes0214
Questions asked: 1
Questions answered: 3
Points earned: 3
Diogenes0214
Diogenes0214
Questions asked: 1
Questions answered: 3
Points earned: 3
New Member
03/29/08 4:03pm PDT

What is the other side of the double entry....payroll liability credit....where is the debit?

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
 
 
 
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
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.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
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
Certified ProAdvisor - POS
Certified ProAdvisor - POS
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks POS experts
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
Allstar, Accountant Community AllStar
03/29/08 4:35pm PDT

If your payroll entry was set up properly, you would have payroll tax liabilities on your books.

Debit>gross wages

Debit>employer expense

Credit>Payroll tax liabilities, which is the total of withholdings plus er expense

Credit>Net payroll (checking or accrued payroll, depending on how you enter your net checks)

If you still don't understand, I suggest that you hire someone to look at your file and correct the payroll accounts for year end and set you up with procedures for 2008.

Feel free to e-mail me at the address on my profile, if this is something you are interested in.

Hope this helps,

Laura D

My motto:
Keep it as simple as you can. . .with only as much detail as you need.

When in doubt, make a backup first!!

*****
Laura Dion
Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com
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
 
 
 
dliam75
dliam75
Questions asked: 0
Questions answered: 1
Points earned: 1
dliam75
dliam75
Questions asked: 0
Questions answered: 1
Points earned: 1
New Member
04/29/08 10:50am PDT

I have a question also, but first some background info.

I use assisted payroll and report taxes using cash-basis method. My first payroll date in 2008 was January 2nd with a payroll period ending December 31, 2007. The payroll was submitted on December 31st.

When I ran my Balance Sheet under Cash Basis for 2007, what I noticed was that QB made an entry for the Accrued Payroll Liabilities, Direct Deposit Deposit Liabilities and Accrued Payroll Taxes. Also I noticed that on the Income Statement under Cash Basis for 2007, QB did not make entries there.

I'm trying to understand how this happened and what I can do to prevent it from happening. My CPA does not like to see any other types of Liabilities on the Balance Sheet at year end for anything other than Credit Cards, Loans and other Long Term Debts.

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
 
 
 
Diogenes0214
Diogenes0214
Questions asked: 1
Questions answered: 3
Points earned: 3
Diogenes0214
Diogenes0214
Questions asked: 1
Questions answered: 3
Points earned: 3
New Member
04/29/08 12:12pm PDT

Thanks for your response. Everything was being recorded properly. I just wondered if it had to be reversed for income tax reporting purposes. We did report the accrued but unpaid taxes as our CPA confirmed that is how it should be done.

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
 
 
 
CDX49
CDX49
Questions asked: 3
Questions answered: 166
Points earned: 167
CDX49
CDX49
Questions asked: 3
Questions answered: 166
Points earned: 167
Contributor
05/18/08 8:45am PDT

....."Income Statement under Cash Basis for 2007, QB did not make entries there."

I think the reason QB did not post any entries on your Income Statement for the last payroll was because the check date was Jan 02, 2008, and that is when the company "recognized" the expense. Even if there is a processed date, the check date is what drives the expenses and liabilities.

CDX

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
 
 
 
Snooks
Snooks
Questions asked: 2
Questions answered: 0
Points earned: 0
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Snooks
Snooks
Questions asked: 2
Questions answered: 0
Points earned: 0
New Member
12/23/08 2:12pm PST
Latest post

I have an IRS auditor that is disallowing the Accrued Employer Payroll Taxes at yearend for a Cash Basis Taxpayer. It has been my understanding from here and elsewhere that this was allowed. What is my authority for doing so?

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
    Help other users find this post by tagging it
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
eaton
1 min ago
eaton
replied to
why is there is no option t...
Ampli899
23 mins ago
Ampli899
replied to
Why does quick books shut d...
QNE19638
23 mins ago
QNE19638
posted
error
Ampli899
29 mins ago
Ampli899
replied to
Wifi or 3G
Heidi4538
34 mins ago
Heidi4538
posted
Why does quick books shut d...
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