Solved

Inventory - Food - Coffee Manufacturing

Forum|Forum|7 years ago
March 14, 2019
4 replies
0 views

I use QBO Plus for a Coffee Roasting Company.

I purchase Un-roasted coffee and then Roast it and package and label and then sell.

How would I use Inventory to keep track of Un-Roasted coffee counts. Then also keep track of Bags and labels as part of the finished product ?

Example. Un-Roasted Coffee COST = $3. Product Bag COST = 50 Cents, Label Cost = 10 cents. Finished COST = $3.60

Would I create Inventory for the Un-Roasted Coffee. Non-Inventory for the bag and label. Then use Bundle to create the Finished Product ?

QuickBooks Online

Best answer by MaryLandT

Hello there, @seion,

You can either sell the item separately or in bundle. The inventory COGS is affected when you sell inventory items on invoices and sales receipts.

When creating an invoice or sales receipt, run the Transaction Journal Report to see the Sales/Accounts Receivable and Inventory/COGS transactions. This credits the Inventory Asset account and debits the COGS account.

To create an invoice with the bundle item:

Click the Plus (+) icon at the top.
Select Invoice.
Enter the customer name you want to sell the item under the Customer drop-down menu.
Complete other details.
Select the date under the Service Date column.
Select the bundle item under the Product/Service column.
Click Save and close.

For additional information on how QuickBooks handle COGS, please check out this article: Understand Inventory Assets and COGS tracking.

Also, I've added a video tutorial to help you setup an inventory product in QBO.

This will answer your concerns for today.

Feel free to leave a comment if there's anything I can help you with the inventory tracking in QuickBooks. I'd be glad to help.

Regina_Lend_A_Hand_Accounting

Yes, you should create a unique inventory item for un-roasted coffee so that you can track this inventory separate from your finished good (roasted coffee). In theory, only the roasted coffee is sold to customers, so it should have it's own unique inventory item setup that is used on your customer invoices. When you purchase un-roasted coffee you should use that item on your vendor bill or expense entry, this will put the quantity into inventory. You will have to do a manual inventory adjustment to move inventory from un-roasted to roasted coffee that is for sale to your customers. The bags and labels can be setup as non-inventory, but they are also COGS (cost of goods sold)

S

seionAuthor

Would the label and the bag and the roasted coffee be bundled and sold or would they be separate and the labels and the bags just hit the COGS account?

Here is what I got so far.

MaryLandTAnswer

Hello there, @seion,

You can either sell the item separately or in bundle. The inventory COGS is affected when you sell inventory items on invoices and sales receipts.

When creating an invoice or sales receipt, run the Transaction Journal Report to see the Sales/Accounts Receivable and Inventory/COGS transactions. This credits the Inventory Asset account and debits the COGS account.

To create an invoice with the bundle item:

Click the Plus (+) icon at the top.
Select Invoice.
Enter the customer name you want to sell the item under the Customer drop-down menu.
Complete other details.
Select the date under the Service Date column.
Select the bundle item under the Product/Service column.
Click Save and close.

For additional information on how QuickBooks handle COGS, please check out this article: Understand Inventory Assets and COGS tracking.

Also, I've added a video tutorial to help you setup an inventory product in QBO.

This will answer your concerns for today.

Feel free to leave a comment if there's anything I can help you with the inventory tracking in QuickBooks. I'd be glad to help.

Simon_MRPeasy

There are really 3 options to do it.

Before going into the options, it is important to understand that expenses (i.e. COGS) can only be recognized at the time of sale (when you get the Income). This is called the matching principle in accounting and enforced in (most likely) every accounting standard like GAAP, IFRS.

Simply speaking, this means that "unroasted coffee" is not an expense, but an asset. And once it is roasted, the "unroasted coffee" will be converted to "roasted coffee", from the raw materials to finished goods, which is still an asset, but another item (which could possibly include direct expenses made for roasting, i.e. unroasted coffee becomes more valuable (i.e. manufacturing is adding value to products)). And when roasted coffee is sold, the value from the asset account is debited to the expense (COGS) account.

So, the options:

Option 1. Not tracking inventory (by piece) and using manual journals.

Recording production:
D Finished Goods
C Raw materials

Or, if you track WIP...
D Work in progress (when materials are used)
C Raw materials (when materials are used)
D Finished goods (when production is finished)
C Work in progress (when production is finished)
Once invoiced and shipped:
D Cost of goods sold
C Finished goods

(Or another workaround, which gets the same result, without using manual journals)

Option 2. Using Bundles.

This allows to credit the raw materials (unroasted coffee). But does not allow you to track the value of roasted coffee. I.e. bundles do not understand that you could roast the coffee and sell it at a different time, the functionality presumes that until the instant you sell the roasted coffee, you still possess the unroasted coffee.

Option 3. Choose an inventory or a manufacturing app, that can do it.

In the QuickBooks app store there are inventory apps that support light assembly (simply converting raw materials into finished goods), and several apps for manufacturing (in addition, calendar and capacity scheduling, MRP, shop-floor control, FIFO), like MRPeasy, depending on depth/complexity required. They sync automatically with QBO.

S

ScriptDawg

Hi there,

It’s been suggested already, but perhaps the easiest way of doing this could be to list everything as an individual item and bundle them together when selling. Although, this might appear on the customer's receipt too so be warned.

Alternatively, since QuickBooks isn’t the very best for manufacturers looking to track raw inventory and manage production, you could take a gander at the QuickBooks Appstore for a solution?

For example, Katana is an inventory management software that can integrate with your QuickBooks Online account which can bridge the gap when it comes to managing production, scheduling, handling manufacturing orders, converting raw material into finished goods, and calculating manufacturing costs, all automatically.