Hi there,    Instead of upgrading to a different QuickBooks  Desktop  package, have  yo u checked out the  QuickBooks App Store   for a 3 rd  party tool  so you can track your projects, raw material usage and costs in one app, and generate a bill/invoice for Q uickBooks to easily track your finances.    For example,  Katana  can integrate with your QuickBooks account so you can manage your entire business, from sales to manufacturing,  from one dashboard, and synchronize your inventory so  the levels are  up to date  on both accounts.    Katana allows you to use:    A Unique auto-booking engine – Katana can automatically track your raw material and finished good inventory, but not only that, Katana takes your available items and allocates it to your open orders.     Priority-based planning – If you need to reorganize your workflow, Katana allows you to easily do so, but will redistribute your items to allow you to fulfill the new production schedule as soon as possible.     ... View more

Hi there,    I assume you mean change the quantity of on-hand  inventory?  If so, I snatched this from another page which should help you:    Adjust an item   To adjust the item so it reflects zero quantity on hand:   Go to  Settings and  select Products and Services.   Locate the item to update.   From the Action column drop-down menu, select Edit.   In the Product/Service information panel, in the Quantity on hand section, next to Adjust, select the Quantity link.   In the Stock Quantity Adjustment  window,  New Qty column, enter 0.   Select Save and Close.   Alternatively , you could check out the  QuickBook s  App Store  for a solution to tracking your inventory  levels.  Which might be the better option for you to be honest since QBO has no manufacturing features.    Katana  smart manufacturing software can be integrated with your QuickBooks Online account, so you can centralize your sales point and synchronize y our  stock levels  on both apps.    But not only that, you can manage your production with its unique  auto -booking system which takes available raw material (based on your BOMs) and allocates it to  manufacturing orders, also giving you information on manufacturing costs.    You can essentially manage your entire business from Katana, generate invoices and bills to push over to QuickBooks so you can keep tracking your  finances  with your QBO account.  ... View more

Hi there,    Have you considered not storing your raw material as a non-inventory item and instead save it as a product, bundle them with other materials to represent your final product and track inventory and costs that way?   I only say this because QBO doesn’t have a feature for converting your raw material into a finish good and a lot of other businesses rely on 3rd party apps from the  QuickBooks App Store  for a solution.   For example, inventory manufacturing software like  Katana ,  allows you to use an auto-booking system to track your raw material inventory management  automatically, your finished goods, and  handle your sales.    So, when a sales order (or manufacturing order) Katana will automatically allocate available material or finished goods to your orders.   However, if you need to  fulfill a  sale  sooner , you can simply  reprioritize   your  orders  and   Katana   will   even  redistribute  your inventory  to help you complete the orders in the new workflow.    ... View more

Hi there,     You could do it in Excel, but it’s  prone  to mistakes (just simple human error) and is time-consuming to constantly update.      Have you checked out  the   QuickBooks App Store  for a 3rd party solution to your problem? There’s smart manufacturing software like  Katana  that can track the costs of your purchases (which you can easily edit at the point of order if the price changes).     It’s designed to be integrated with your QBO account and can synchronize your inventory levels, so any changes made in whatever account will be reflected in the other.     Yes, you can track your sales in the app, and it should be mentioned that it’s built for manufacturers looking to get more control over their inventory and manufacturing productions. ... View more

Hi there,     I see that the question has been solved, but I think for future reference I think the following is how you fix (at least) negative inventory.     To locate any negative inventory, you’ll need to run an Inventory Valuation Detail (IVD) report in QuickBooks:      On the QuickBooks Dashboard select  “Reports” and select  “Inventory Valuation Detail”      On the drop-down menu for  “Dates” select  “All”  to get an entire overview of your inventory movement.    Under the  QTY On Hand column, you’ll be able to see at which point negative inventory has occurred.    So, you’ve found when negative inventory has taken place, so let’s move onto how to fix it:      Select the negative inventory under the  “QTY On Hand”   If you’re legitimately able to do so, adjust the dates of the bills or invoices so that the bill date is set before the invoice dates  Alternatively, you could check out the  QuickBooks App Store  for a solution to tracking your raw material and finished goods. For example, Katana can integrate with your QuickBooks account, allowing you to manage your entire business (especially your manufacturing processes) in Katana, and simply push over your receipts and invoices back to Katana to keep on top of your finances.     ... View more

Hi there, I’m not sure I fully understand what you mean, I assume  you’re looking to find a 3 rd  party app that can help you manage inventory tracking of a  huge  number  of products?    I’d recommend simply checking out the inventory management app listed on the  QuickBooks App Store . Katana  is a smart manufacturing software designed by manufacturers, for scaling manufactur ers, that uses a unique auto-booking engine to help you manage your raw materials and finished goods. You can easily save your bill of materials and all your product variations  on the software, which will then allow Katana to redistribute your materials and finished goods  automatically to your orders, helping you speed up your f ulfillment rate. **EDIT** It does have integration, but only with QBO, though it can be used alongside for you inventory needs :)  ... View more

Hi there,    I see that another user has already answered your question, but I was going to suggest checking out the  QuickBooks App Store  for a  solution .    If you use an inventory management app like  Katana , you can easily separate your inventory  so when a third-party company is used to complete your manufacturing, you can easily track  their   processes from  your warehouse  and track those costs. Then, once the final product is completed, you can easily push your receipts and in voices back to QuickBooks to easily track your finances.  ... View more

Hi there,    I see the questions have already been answered, but perhaps this video,  QuickBooks Online 2019 Tutorial: Purchase Orders and Partial Receiving , will help you get more understanding on how to receive partial orders on QuickBooks.     However, have you tried checking out the  QuickBooks App Store  for an app that can help you manage your raw material deliveries , and push all of your receipts and invoices over easily back into QuickBooks.    Katana   can  integrate with your QuickBooks account and synchronizes your inventory levels so you can get up to date, real-time,  inventory readings on both accounts.    ... View more

Hi there,    I see others have answered your  question, but have you considered checking out the  QuickBooks App  Store.    This way you can easily separate your coffee beans into raw and roasted while generating invoices from a third-party app to push over to QuickBooks.    Katana  can integrate with your QuickBooks account and  synchronize  your inventory levels so any movements or changes will be updated, in real-time, on both apps.    ... View more

Hi there,    It’s fine to make the material/ components as single products and bundle them  all together  to track the costs as you sell.    But have you tried  taking a look  at the  QuickBooks Appstore  for a solution? Since QuickBooks Online  isn’t able to  take your raw material and convert that into finished goods.     That way you can find a tool that can help you get more control over your production operations  and then simply track the costs in the third-party app and transfer them to QuickBooks  to keep your finances together.   Like Katana, Connecting  Katana  and QuickBooks Online keeps your orders synchronized in both systems. Prevent situations where figures in different software's do not match. Your whole team will benefit, and your accountant will love it.   ... View more

Hi there,    I see that others have already answered your question. However, have you considered checking out the  QuickBooks Appstore ?    You could track your inventory (especially raw and have the tools to convert that raw material into a finished product) outside o f  QuickBooks and then import  all of  your financial details back  into Katana.    For example, like  Katana , when QuickBooks  is connected with  Katana, you can create invoices and bills in Katana, which will automatically update your QuickBooks account. Clicking the created invoice or bill in Katana opens the document in QuickBooks.   ... View more

Hi there,     Well, firstly you’ll need to make sure that you’re on the correct package so there’s a chance you’ll need to upgrade your software.     However, even if you do that, the manufacturing modules on QuickBooks aren’t up to speed for modern product making businesses.     Have you considered looking into the QuickBooks apps store for a solution to help you with the manufacturing aspect of your business? There are some apps, like Katana, which you can use to monitor your manufacturing capabilities, but still, manage your supply chain and different selling channels from one dashboard.     So, if you want to separate your inventory levels, bought goods and manufactured goods, you can easily track different levels of stock.     ... View more

Hi there,    I’m posting this directly from another page on the QB community  page,  but I will link so you can check for yourself :  https://quickbooks.intuit.com/blog/whats-new/improving-your-efficiency-introducing-quickbooks-bundles-for-easy-grouping-of-items/     “ A  bundle  is a group of items that you can sell and track in QuickBooks. For example, you can create a bundle called Garden Fountain Bundle, which consists of item Tradewind Fountain, and Fountain Pump.   Group items you often sell together into bundles so you can easily add multiple items to transactions.   Some other notes about bundles:   Bundles can have up to 50 items.   There is no additional markup or change in price for bundles. (Bundles aren’t assemblies.) The price of a bundle = The total price of all its items.   You can’t track quantity on hand for bundles. ”   And this following line of typing isn’t direct pasted, but an assembly is a part of a product. So if you make tables, but you also sell the parts to customers, an assembly could be the legs of that table.     I see that you mentioned that you’re using the manufacturing version, have you considered checking out the QuickBooks Appstore to avoid confusion in the future? There’re certain apps, such as Katana, which has been specifically built for manufactures that integrate with their QuickBooks account.     This will help you get on top of your manufacturing, scheduling, order fulfillment, and  manufacturing costs.    ... View more

Hi there,     Alternatively, have you considered looking into the QuickBooks app store for a solution to tracking and converting your green coffee into roasted? There are apps like Katana, which is built specifically for manufacturers, so you can track your manufacturing processes (automatically) and easily set the weights for the products accordingly.     It is primarily built for QuickBooks Online, which integrate with your account so you can synchronize stock levels and generate bills/invoices on Katana to be saved in QuickBooks. However, it does work independently alongside the desktop versions.     ... View more

Hi Rhonda,    It’s a pain, but I guess you could find all the evidence of purchases you can starting at the beginning of the financial year, then compare the current inventory of your components and to get a rough estimate on your COGS?    I’d recommend maybe checking out the QuickBooks app store for inventory management tools like Katana, which can help you automatically track finished goods and raw material inventory as QuickBooks desktop – even though it can – isn’t really cut out for the heavy lifting when it comes to  managing  manufacturing.    ... View more

Hi there,    Well, the cheapest option would certainly be to get set up with QuickBooks Online and then find a 3rd party tool to handle all your inventory needs. There’s a lot of solutions on the QuickBooks app store such as Katana, which is a smart workshop software  that:      Integrates with your QuickBooks account;   Synchronizes inventory to give you real-time level readings;    Generate bills and invoices in Katana and push it into QuickBooks; and   Helps you manage your finished and raw material inventory.    ... View more

Hi there,      Have you checked out  Katana  on the QuickBooks app store? It’s a Smart Workshop Software solution built by manufacturers, for manufacturers.      It can help you:   Track finished goods & material availability;   Store your bill of materials;    Get priority-based production planning;   Manage your multichannel sales support;   Get manufacturing floor-level control; and   Get automatic manufacturing cost calculations.     To be honest, it’s primarily been designed to integrate with a QuickBooks Online account (with the capability of synchronizing your inventory levels across your accounts), however, you can use it behind your QuickBooks Desktop account, generate bills/invoices and push them over to your QB account.     ... View more

Unfortunately, there isn’t a way of saving a  QuickBooks bill of materials  with the online version. However, this feature can be found on some of the desktop packages.    But it’s not the end of the world, and you don’t need to invest in the desktop versions! You can simply check out the QuickBooks App Store since there are 3rd party tools available which can synch with your QuickBooks and provide you with the ability to save your BOMs.    Katana is one of these tools which can give you a place to save your bill of materials, manage your finished  goods  and raw material inventory, schedule production, and help you with filling your SOs and  POs.   ... View more

Hi there,   It’s a bit complicated, but as someone else mentioned, but it could be better to save the Raw Almond and Roasted Almond as separate products. Which you should be doing anyway, since the products are different and have different costs.   Tracking inventory isn’t a strong suit of QuickBooks, you could consider looking into the app store for an inventory management system, like the one offered by  Katana , to try and bridge the gap with the inventory management.     ... View more

Hi there,    Do you mean a bill of materials (or product recipe)? Because unfortunately, QBO doesn't have that feature. However, there is inventory management software on the QuickBooks app store which can do that for you! Like  Katana , it’s a piece of inventory management software that helps you with stock control, saving product recipes, production scheduling, floor-level management, managing multiple sales channels across different locations and order fulfillment.      ... View more