Quickbooks Desktop Restaurant Inventory

easternmarine · ‎January 04, 2023

We have a restaurant that buys inventory items, that are components of an item sold. Sure sometimes, its a direct resell, but sometimes its not. An example of a component item: Cheeseburger. A cheeseburger is combined of the roll, the hamburger patty, the cheese slice and condiments such as lettuce and tomato. An example of a resell item: Ice Cream Sandwich. We buy it and resell it. Even a drink is a component item of the ounces of syrup and cup (water is negligible). All the articles I find about tracking restaurant inventory say, use Inventory Part drop down, then when you sell...blah blah blah. That certainly works for the ice cream sandwich, but it doesn't work for the component items. Yes I realize the details such that a tomato is different sizes and I can't perfectly account for 7 slices from every tomato. Those aren't things I care about and is the cost of doing business and will be covered in the over and short counts. But I do know every cheeseburger gets 1 slice of cheese and we buy a case of 1000 slices. We buy a case of 100 patties. We buy a bag of 20 rolls. So those I can easily account for.

So the bottom line question...how do I account for these items? We have quickbooks desktop pro. I am assuming I need to upgrade so that I can use an "assembly" item that I don't see in Pro. Then I create a Cheeseburger assembly item that is comprised of other single items I've already created - Roll, Patty, Cheese Slice, Tomato Slice, Lettuce Slice.

Please advise.

MJoy_D · ‎January 04, 2023

I can share some information with inventory and assembly tracking, @easternmarine.

Yes, you can build your products, then add your product’s bill of materials, and then assemble your products. However, you can do this in QuickBooks Desktop Premier, Enterprise, or Accountant. Check out this link for our plans and pricing: QuickBooks Desktop.

Once done, check out this article for more information about tracking the products you build using inventory parts: Track the products you manufacture.

From here, you can create a sales receipt to process the payments you've received.

Let me know if you have further questions about accounting for your inventory items. I'm always here to help. Have a wonderful day!

easternmarine · ‎January 05, 2023

Great, and to be clear you CAN NOT do this in quickbooks online, correct?

FateCandylaneT · ‎January 05, 2023

I appreciate your follow-up question, @easternmarine. Let me chime in and share additional details about building your inventory assembly in QuickBooks.

Yes, you're right. We can't do assembly tracking in QuickBooks Online (QBO). As mentioned by my colleague above, this would best work in your QuickBooks Desktop (QBDT) version. However, with QBO, you can use Bundles as a workaround.

Bundles are a collection of products and services you sell together. You'd use it if you don't need to transfer and track the finished products before its sold.

You can learn more about the bundle-type item in this article: Change product and service item types in QuickBooks Online. This way, you'll be able to categorize the products and services for better tracking.

I'm adding these helpful resources to track and run reports after receiving the payments you've received:

I'd be more than willing to assist you further if you have any additional queries about inventory assembly in QuickBooks, Easternmarine. You can always comment back in this thread. Stay safe!

Topics

Training

Community

Resources

Quickbooks Desktop Restaurant Inventory