cancel
Showing results for 
Search instead for 
Did you mean: 
VTXtools
Level 2

Inventory vs. non-inventory and COGS

Currently I have two vendors that drop ship on our behalf. I have all the products that they ship set up as non-inventory. These products are not low value items. They can range from $100 to $10,000. In searching around the Q&A forums I found an answer that states "Then, you can choose to use non-inventory items only when the value of that stock is not significant, or if you are recording the stock value manually through accounts other than inventory."

 

The process is typically I receive an order via my ecommerce site. That order sits there until I mark it fulfilled at which point the order pushes over to QBO as an invoice. When I first received the order I created a PO that was then submitted to the vendor. All this seems to be working fine. 

 

My question is since these products are set up as non-inventory but are still high value am I approaching this correctly or should I be treating them as inventory? One issue I have is it becomes a bit of a pain to calculate my margins as COGS are not recorded. I do realize that the expense floats up but would be nice to see the COGS so as to easily be able to calc my margins. But that isn't a show stopper. 

 

What is everyone's recommendation? Treat these products as inventory item even though I never take physical possession or leave as non-inventory and just calculate the margins manually?

 

Thanks in advance.

9 Comments 9
Rainflurry
Level 14

Inventory vs. non-inventory and COGS

@VTXtools 

 

You are doing it properly.  The products are not inventory for you, they are inventory for your vendor.  Two businesses cannot claim inventory on the same product.  The bottom line is that if you do not have title to the products, they are not inventory.  You can still book the cost of them to a separate expense account and see your margin(s).  Just record the cost of the products to a dedicated expense account when billed from your vendor.  You will not have the QB inventory reporting features because they are non-inventory items, but it is the proper way to record it.

VTXtools
Level 2

Inventory vs. non-inventory and COGS

Just to make sure I understand correctly, I should set up a sub COGS account for the product and then link the product to that particular COGS account and that would allow me to track that product outside of just the general COGS. I must be missing something as even after I have isolated a non-inventory item to its own sub COGS expense account I still am not able to view a margin for it when I run a report for sales by product/service summary.

 

 

Rainflurry
Level 14

Inventory vs. non-inventory and COGS

@VTXtools 

 

COGS is an expense account used only when inventory items are sold.  You should use a non-COGS expense account(s) and calculate your margin manually.  You aren't missing anything - QB cannot connect the cost of the item to the sale of the item for non-inventory or service items and, therefore, cannot give you a profit margin for non-inventory and service items. 

nmballa
Level 2

Inventory vs. non-inventory and COGS

Since my non-inventory items have the cost account as COGS it should still dump the associated cost back in to COGS, correct? It's just not being applied to that particular item but just dumped in to the general pool of COGS. So my overall COGS total is still accurate, I just can't pull margin by individual non-inventory items.

Rainflurry
Level 14

Inventory vs. non-inventory and COGS

@nmballa 

 

Correct, but COGS should not be used with non-inventory items.  COGS is an expense account that is used to expense the cost of inventory items at the time they are sold.  If you report COGS, you need to file Form 1125-A with your tax return or complete the COGS section in Part III  of Schedule C on your 1040.  Either way, COGS is calculated using the beginning and ending (of the tax year) inventory values.  If you have no inventory, you should not have COGS.  Instead of using COGS, you can use another expense account like Cost of Sales or Materials and Supplies. 

Gina62
Level 2

Inventory vs. non-inventory and COGS

I am very late to this conversation but having the same issue.  I'm struggling to find a report that gives sales & cost for non-inventory items.  I understand how inventory works & how COGS works, however it is necessary to view sales & cost on non-inventory items as well.  It seems like a simple report but just not a quick report in QBO as of now.  I hope with some feedback this will be addressed soon.  I found under reports>bus overview>custom summary report>display rows by product/srv & display columns by income statement might be a report to export to Excel & remove all columns except sales & whatever account the products are expensed in.  This results in four simple columns - product name + income + expense = gross profit (in my case).  Hope you find this report helpful and I hope QBO gives us more reporting for non-inventory products in the near future.

RAinteriors
Level 1

Inventory vs. non-inventory and COGS

And in this instance what income account should I assign?

Gina62
Level 2

Inventory vs. non-inventory and COGS

The report will list all the income statement accounts and you can remove all the accounts except the income & expense accounts that are assigned to the products/items.  Mine is simple because I use one income account and one COGS account for all products/items.  I set up a COGS account to track the cost even though these are non-inventory items the owner wants to see the cost in COGS.  Review your products/items list to see which income and cost accounts are assigned.  Hope this works for you too.

  

Gina62
Level 2

Inventory vs. non-inventory and COGS

And by the way, I name my COGS expense account "materials cost-non inventory" so there is no issue when the CPA reviews the financials.  The COGS account is not associated with any inventory in this situation/company.  Hope this helps........

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us