Inventory Tracking and Cost Allocation for Raw Materials Used to Make a Final Product.

kawaiwai · ‎August 17, 2017

We make drinks using syrup. We buy the syrup in bulk and each bottle can make 30 drinks for sale. Whats the best way to account for this in QB?

AliciaRoy · ‎August 24, 2017

Hi Kawaiwai,

I'd be happy to help you record these inventory assemblies.

How they're recorded is dependent upon the version of QuickBooks that you're using.

QuickBooks Online and QuickBooks Pro At this time, inventory assembly isn't a feature offered in these products. There are third party apps that integrate with these programs that can help you record the assemblies, and there are more details about that here: https://community.intuit.com/articles/1145954 https://desktop.apps.com/home.
QuickBooks Premier and QuickBooks Enterprise These products do allow you to assemble inventory items. The following article has more information on how this is done, and the various features that help you track the invenotry: https://community.intuit.com/articles/1501320.

Please feel free to reach back out if you have any further questions.

View solution in original post

AliciaRoy · ‎August 24, 2017

Hi Kawaiwai,

I'd be happy to help you record these inventory assemblies.

How they're recorded is dependent upon the version of QuickBooks that you're using.

QuickBooks Online and QuickBooks Pro At this time, inventory assembly isn't a feature offered in these products. There are third party apps that integrate with these programs that can help you record the assemblies, and there are more details about that here: https://community.intuit.com/articles/1145954 https://desktop.apps.com/home.
QuickBooks Premier and QuickBooks Enterprise These products do allow you to assemble inventory items. The following article has more information on how this is done, and the various features that help you track the invenotry: https://community.intuit.com/articles/1501320.

Please feel free to reach back out if you have any further questions.

citrusyoga · ‎October 31, 2018

I see this response is from 2017 - is this still the case?

I also have a client who assembles their product to create a final product, which they consider their inventory and which they sell.

We are using quickbooks online plus.

Please let me know

[email address removed]

Thanks

Paula

Candy21 · ‎October 31, 2018

Hello Paula,

I was wondering the same thing. If it is available now?

Thanks,

Candy

roy241 · ‎August 09, 2019

So, QBO Plus version now does have an inventory module, where you can use bundles to track your assemblies.

However, there is still no dedicated manufacturing module, in which case you should probably use an app like Katana. It will manage your material and finished goods inventory, manufacturing costs and order fulfillment process. Invoices/bills get pushed to your QBO account.

Topics

Training

Community

Resources

Inventory Tracking and Cost Allocation for Raw Materials Used to Make a Final Product.