• Was this page helpful?
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
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
239
dh5dKemeyr346iacfA8pyY
Subscribe RSS
candeleros
candeleros
Questions asked: 7
Questions answered: 2
Points earned: 2
candeleros
candeleros
Questions asked: 7
Questions answered: 2
Points earned: 2
New Member
03/15/10 8:24am PDT
Viewed by asker 05/24/10 11:14am PDT

build assemblies vs add inventory

US QuickBooks Premier : 2010: Manufacturing and Wholesale

So sorry for asking so many questions, but I am having a VERY difficult time understanding all this.  I make salsa (among having a restaurant and making sauce and chips as well so I use classes - one for product line and one for restaurant).

I created each product as an item assembly.  I do not build items, but want to add more to inventory to sell.  Here is how I am set up:

I have produce and dry goods as 2 items in my COG category.  The salsa is made up of both of these items.  When I create the item, I enter a cost of produce, dry, label, jar, lid in the cost section. 

When I get an invoice for produce and dry goods from my purveyors, I enter these bills from enter bills and enter the appropriate amounts in produce, dry, dairy, etc - separating by class.

When I sell salsa, I create an invoice and believe that the invoice will reduce the inventory on hand by what is ordered.  When I make new salsa, I want to be able to enter more inventory into qb and make my on hand bigger.  I don't build assemblies as I don't use the bill of materials - we don't track the dollar cost of produce and dry by the each. 

Please help - am I creating double cost by entering the cost of the dry and produce and the cost is entered on the inventory item? 

Also, how do I add additional inventory?

Thanks so much.  Hope I am being understood - all my other answers seem to be given with an assumption that I know what I am doing in the first place.  I have spent 15 years using qb as a restaurant and all items were service items.  I recently upgraded to premier and have to make my old items (service) inactive and create all new items as assembly and begin using the inventory. 

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
2 Replies
gusb83
gusb83
Questions asked: 5
Questions answered: 341
Points earned: 1001
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Allstar
Allstar
Advisory council of community power users.
gusb83
gusb83
Questions asked: 5
Questions answered: 341
Points earned: 1001
Allstar
03/18/10 2:07am PDT

Unfortunately the only way to do this properly IS to use the Bill of Materials but here is a work around that might help you. The key is to be able to track and capitalize the cost and not expense it. By transferring the value from the expense into the asset you will be able to do this. Keep in mind that you may only have ONE Cost of Goods Sold, Salsa Cost of Goods Sold, that is it, if you want to track 10 different COGS based on your purchases its not possible. You can run a report based on your item purchases that is about it. With that said, here is how to do it:

1) Create two Asset Accounts: Raw Materials and Finished Goods

2) Create one inventory item that is going to represent your finished good, Call it "Salsa" make the expense go to your "Salsa Cost of Goods Sold" the Income to your "Salsa Income" and the Asset account to your FInished Goods.

3) When you purchase the materials that make up the salsa, don't put it into your Salsa COGS, put it into your Raw Materials Inventory otherwise you will be making your inventory negative and you will not have any accurate values in your COGS.

4) Now here is the tricky part that confuses people: Press the button that says "Adjust Quantity on Hand" and click on the check mark that says "value adjustment" and make the adjustment account "Raw Materials." Increase the quantity by the amount of salsa you just made and for the value type in how much it cost you to make it. If you can estimate how much it cost you then type in that amount.

5) When you sell that salsa to customers or at stores, put this item on your invoices and it will decrease the quantity on hand and accurately transfer the value to the Cost of Goods Sold.

The key to making this work is step 4, finding a unit cost. You have to sit down and think about how much it is costing you to make ONE jar of salsa from all of the raw materials and this amount will be your average cost. If you can come up with an amount and have that be your cost of goods sold then this will work and you should not have any problems.

Remember, inventory is a one way street. You either track it or you don't. If you do decide to track it, you must play by the rules of inventory: 1) Don't sell more than what you have by making your inventory negative, 2) Create an inventory item for every item that you keep in stock otherwise throw it into your purchases expense, 3) Include every item that you sell on your invoices and 4) If there is no possible way to track it in inventory DONT!!! If it is easier to put it into your purchases COGS then do it, do not try to reinvent the wheel if you dont have to.

For the simple answer to your question, all you have to do is click on the adjust quantity on hand button and increase it by the amount that you made. Because you do not use these items on your purchases there will be nothing in the COGS section, only income will transfer over, it is like creating a service item with an amount. 

Feel free to email me with any questions that you might have. Good luck with everything and I hoped this helped.

 

Hope this helps. If so please mark as SOLVED and rate the answer. If you live in LA look me up on the ProAdvisor website.
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
 
 
 
Rustler
Rustler
Questions asked: 129
Questions answered: 41389
Points earned: 102566
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
Rustler
Rustler
Questions asked: 129
Questions answered: 41389
Points earned: 102566
Allstar
03/18/10 5:05am PDT
Latest post

From what you say you should have the following as inventory items

produce
dry
label
jar
lid

Stock the produce and dry at the lowest quantity that you use, if you use it by the ounce then stock it as ounces.

Create an assembly, the BOM should be
produce        qty=#ounces
dry                  qty=#ounces
label              qty=1
jar                   qty=1
lid                   qty=1

When you build one of the assembly, QB will take the qty of each item out of the inventory items and combine them into one assembly item. The costs of the items in the BOM will be totaled and that total will be the cost of the jar of salsa.

Sell the assembly item.

If I've helped, mark it solved.

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

When the majority, who cannot think for themselves, overwhelm the minority who can, you get ... convention.
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
JOBNEWTON
12 mins ago
JOBNEWTON
posted
I WANT TO MAKE A LIST OF TH...
Biscotti
24 mins ago
Biscotti
replied to
Date and Time Stamp Problems
mmanju
46 mins ago
mmanju
replied to
Add vendor terms
kbello1210
49 mins ago
kbello1210
posted
Relationship and Calculatio...
dbrownstein
50 mins ago
dbrownstein
replied to
Date and Time Stamp Problems
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