Add cost of item to Inventory Template


#1

I want to add a new variable to the Inventory template with the cost of each item that I have in stock so I that can quantify the value of my inventory for accounting purposes. How do I do this without messing up the structure (I’m a spreadsheet novice)?


#2

Hi there BTP,

I’d say one of the easiest ways to do it, is to add a sheet with Stock Keeping units in one column and the prices in another. (I’m assuming items with the same SKU have the same price).

Then, on tab "Current Inventory List" you’ll want to add a column to the far right, and add the following formula:
=ARRAYFORMULA(IF(A2:A="","",IFERROR(VLOOKUP(A2:A,Prices!A:C,3,0)*IF(F2:F<=0,0,F2:F))))

Take a look:


This is my prices tab.


And this is the final look of the inventory tab. Notice that if the SKU is not at the prices tab, the column for total value is empty.

Hope this helps :wink:


#3

Exactly what I was looking for. Thanks a lot.


#4

Glad to hear it.
:+1: