• 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   Quickbooks Tasks   Inventory  
hide
04/19/2013 at 09:23AM PDT
HTML Generator Sample Page

Need to verify a charge from Intuit? You can now retrieve the last 90 days of your Intuit order history from the QuickBooks Support Site

We are working on making some changes to the forums, in an effort to make valuable information more accessible. If you have 10-15 minutes, we would love to get your input through this survey. 

70
239
b6B7gmnD8r346iacfA8pyY
Subscribe RSS
   
accountingnob
accountingnob
Questions asked: 5
Questions answered: 0
Points earned: 0
accountingnob
accountingnob
Questions asked: 5
Questions answered: 0
Points earned: 0
New Member
03/22/10 11:40am PDT
Viewed by asker 03/23/10 12:40pm PDT

cost of goods sold account and inventory adjustment

US QuickBooks Pro for Windows

question 1:

I followed QB's instruction to create a cost of goods account and enter inventory for my product(just one single product for now).
Should there be a transaction regarding to the initial inventory purchase in the cost of goods sold account? Right now I don't see any.


question 2:
I counted the 2009 year-end inventory and tried to do a inventory adjustment for 2009 year end by following the instructions.

I was going to use the cost of goods sold account as the adjustment account, but QB gave me a warning: "the account specified for the adjustment is neither an income or an expense account. Most people offset the change in inventory value to an income account if it's a gain, or an expense account if it's a loss"

I am confused what account I need to use and how I can keep cost of goods sold account updated.

Please advise.

 

Solved!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
This post is closed to new replies
6 Replies
Fretley
Fretley
Questions asked: 37
Questions answered: 646
Points earned: 1320
Allstar
Allstar
Advisory council of community power users.
Fretley
Fretley
Questions asked: 37
Questions answered: 646
Points earned: 1320
Allstar
03/22/10 12:36pm PDT
The solution

You can still use the COGS account while entering an adjustment to inventory, we do it all the time per our accountant's preference.  Just go ahead and ignore the warning. 

How did you "enter" your initial inventory item?  All info. added when adding new item to your item list or did you do via journal entry and if so to what accounts?

"if it ain't broke, enhance it"


If this answer is the solution, click ‘This Solved My Question’ or post back with more information. 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
 
 
 
accountingnob
accountingnob
Questions asked: 5
Questions answered: 0
Points earned: 0
accountingnob
accountingnob
Questions asked: 5
Questions answered: 0
Points earned: 0
New Member
03/22/10 12:44pm PDT

All info. were added when I added new item to my item list.

please answer my question 1 as well.  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
 
 
 
Fretley
Fretley
Questions asked: 37
Questions answered: 646
Points earned: 1320
Allstar
Allstar
Advisory council of community power users.
Fretley
Fretley
Questions asked: 37
Questions answered: 646
Points earned: 1320
Allstar
03/22/10 1:04pm PDT

When you add new item(s) to your item list along with a quantity on hand at the time QB will take the value of item(s) and post it to an open balance equity account by default.  Check your chart of accounts for the account balance and run a quick report to verify those transactions.

You can then do a journal entry now or at the end of the year to move that amount from open balance equity account to retained earnings. 

"if it ain't broke, enhance it"


If this answer is the solution, click ‘This Solved My Question’ or post back with more information. 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
 
 
 
accountingnob
accountingnob
Questions asked: 5
Questions answered: 0
Points earned: 0
accountingnob
accountingnob
Questions asked: 5
Questions answered: 0
Points earned: 0
New Member
03/22/10 1:56pm PDT

Got it.

QB puts the inventory adjustment transactions into the inventory asset account.

Another related question:

say I spend $1000(including shipping) ordering 100 items with my credit card,  how can I record the credit card transaction such that $1000 is tied to the inventory cost of $1000 and inventory count of 100 items?  I know $1000 cannot be counted as expense until goods are sold.

 

 

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
 
 
 
Fretley
Fretley
Questions asked: 37
Questions answered: 646
Points earned: 1320
Allstar
Allstar
Advisory council of community power users.
Fretley
Fretley
Questions asked: 37
Questions answered: 646
Points earned: 1320
Allstar
03/22/10 2:09pm PDT

all costs associated to bringing your item(s) is considered COGS.  You could create a freight in account type of cogs and use the expense tab.

OR

you can allocate the freight evenly over item(s) received within the items tab

OR

if other vendor costs associated with your item(s) are received at a later date you can add that to the value of your item(s) via inventory adjustment.  - see article below:

http://www.cpa911.com/read_art...

if this has answered your question(s), please rate and select solved to close the thread.  if it has not, please post back with more questions.

 

"if it ain't broke, enhance it"


If this answer is the solution, click ‘This Solved My Question’ or post back with more information. 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
 
 
 
Rustler
Rustler
Questions asked: 136
Questions answered: 54817
Points earned: 138290
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
Rustler
Rustler
Questions asked: 136
Questions answered: 54817
Points earned: 138290
Allstar
03/23/10 4:16am PDT
Latest post

say I spend $1000(including shipping) ordering 100 items with my credit card, how can I record the credit card transaction such that $1000 is tied to the inventory cost of $1000 and inventory count of 100 items? I know $1000 cannot be counted as expense until goods are sold.

When you use the enter credit card screen, click on the item tab, enter the items being ordered and the qty and cost.

When you use the items tab that tells QB to assign the costs to that item.

Retained Earnings is an account that is created on the first of the new year automatically.  Net Profit from last year is posted to Retained Earnings automatically so that current year net profit can be calculated starting from zero for that new year.

Opening balance equity is an account to hold the equity of items and cash that the books start with.  Opening balance equity should be rolled up to the owners equity account, then retained earnings is rolled up to owners equity account,  usually at the start of the new year.

If I've helped, mark it solved.

My QB tips Blog >> http://onsale-apparel.com/Rust...

Targeted Tutorials - one problem - one solution>> http://community.intuit.com/po...
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
 
 
 
   
 
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
Rustler
21 secs ago
Rustler
replied to
Vendor List
in: Vendors & Vendor Center
Eddyurena
3 mins ago
Eddyurena
replied to
Aprenda QuickBooks en Español
in: QuickBooks en Español
Rustler
3 mins ago
Rustler
replied to
Subtotal/Sales tax correcting
in: Journal Entries & Accountin...
Eddyurena
6 mins ago
Eddyurena
replied to
manual en español quickbooks
in: QuickBooks en Español
Rustler
6 mins ago
Rustler
replied to
Gift cards and tax consequence
in: Journal Entries & Accountin...
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
© 2013 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