cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 09-26-2019

Accepted Solutions
Level 15

In QB you increase stock by entering a purchase of the it...

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

6 Comments
Level 15

In QB you increase stock by entering a purchase of the it...

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

Level 1

FIFO is NOT the average cost, the average cost is the ave...

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.
Level 15

did you read what I said average cost per purchase date y...

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
Level 10

Do you know what average means? it's not the average. (so...

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

"Currently have inventory loaded of medical wristbands eg...

"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

Level 15

There is no New Product involved here. It is the same pro...

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.