- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Customers and Income
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
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Customers and Income
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Customers and Income
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
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Customers and Income
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Customers and Income
"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
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Customers and Income
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Customers and Income
So do you do consulting work to help someone set up their manufacturing company?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Customers and Income
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Customers and Income
This wasn’t a how to in quickbooks. I have desktop enterprise. This was more of a concept question.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Customers and Income
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).