cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
Mediband
Level 1

Adding inventory - same product, different cost

I cant seem to find clarity on this specific scenario - the best I have found is under the FIFO information but not clear....

Currently have inventory loaded of medical wristbands eg: 10 bands @ R50 ea 

New stock arrived and I want to load additional 10 bands but these were at a R60 cost each

If I use the edit function on the Products and Services Inventory list it only gives me the option to adjust the original starting value.  

Is there another function to load new stock at a different cost?  Thanks

Solved
Best answer September 26, 2019

Best Answers
Rustler
Level 15

Adding inventory - same product, different cost

In QB you increase stock by entering a purchase of the item, with qty and total cost

that stocks the item purchase with that cost for that qty, FIFO means average cost per purchase, and the first purchase cost is posted to COGS when you sell one.

Insure that in company settings you turn on the items table and purchase orders. 

Then when you enter an expense or bill, about half way down the left side is a title "item Details" click that and a table opens where you can select the item, qty and item total cost for purchasing inventory


View solution in original post

10 Comments 10
Rustler
Level 15

Adding inventory - same product, different cost

In QB you increase stock by entering a purchase of the item, with qty and total cost

that stocks the item purchase with that cost for that qty, FIFO means average cost per purchase, and the first purchase cost is posted to COGS when you sell one.

Insure that in company settings you turn on the items table and purchase orders. 

Then when you enter an expense or bill, about half way down the left side is a title "item Details" click that and a table opens where you can select the item, qty and item total cost for purchasing inventory


jtatlantic
Level 1

Adding inventory - same product, different cost

FIFO is NOT the average cost, the average cost is the average cost. To anyone reading this new to accounting, FIFO and avg. costs are two different things.
Rustler
Level 15

Adding inventory - same product, different cost

did you read what I said
average cost per purchase date
you buy 13 for $9 on one day the cost per item is 9/13 = 0.69230 each

you buy 12 for $11 a different day, the cost per item for THAT day, 11/12=0.91666

Sell 20 and COGS shows
13 * 0.69230= 8.9999
7*0.91666=6.42
total of 15.41
Malcolm Ziman
Level 10

Adding inventory - same product, different cost

Do you know what average means? it's not the average. (sorry to interrupt your day)
Malcolm Ziman
Level 10

Adding inventory - same product, different cost

"Currently have inventory loaded of medical wristbands eg: 10 bands @ R50 ea"

You should not enter the qty and cost in the new P/S item set-up screen, unless you are starting a new set of books for an existing co.  The offset goes to Opening Balance Equity, which should have a zero balance, when you are done entering all the balances from the opening Balance Sheet (if you are starting a new set of books for an existing co.), and should never be used again.

Once the books are set up, use an Expense or Check (if you paid from a bank account) or Bill (if you will pay later - offset goes to Accounts Payable) when you purchase stock. If it's a new P/S item, you can create the P/S item on-the-fly, from within the purchase screen, But enter 0 as the starting qty in the P/S item set-up screen. You can enter a cost here (optional) but it is just for populating future purchases. It does not ever change

qbteachmt
Level 15

Adding inventory - same product, different cost

There is no New Product involved here. It is the same product; each purchase is where you list what you got. The Point of having a system managing FIFO means it tracks each time you replace stock, for that Same item, at varying cost. All you need to do is keep entering that you Bought more of that same product, if it was that same product that already exists.

joannamidolo
Level 1

Adding inventory - same product, different cost

So do you do consulting work to help someone set up their manufacturing company? 

Fiat Lux - ASIA
Level 15

Adding inventory - same product, different cost

@joannamidolo 

There is no specific feature in QBO for a manufacturing company (e.g Assembly). You need having a 3rd party app to integrate with your QBO.

joannamidolo
Level 1

Adding inventory - same product, different cost

This wasn’t a how to in quickbooks.  I have desktop enterprise. This was more of a concept question.

Fiat Lux - ASIA
Level 15

Adding inventory - same product, different cost

If you are not using QB Desktop (outdated) South Africa version, you should post your question with a new subject in other community (e.g Canada, US).