You’re the best. I just started working at a Manufacturing company with hundreds of inventory and this has been a huge problem with that company. His QB inventory is a mess.
@HectorGarciaCPA4 жыл бұрын
Annie K. Good luck.
@radicalaccounting8 ай бұрын
That was fun. i"m a QB fixer but fixing inventory is new to me, so I enjoyed that. Poor folks who let their inventory get out of hand, argh. I feel for them.
@HectorGarciaCPA8 ай бұрын
Hot mess
@2003babzc Жыл бұрын
Thank you !!!! This is greatly appreciated and will help me correctly adjust inventory!
@HectorGarciaCPA Жыл бұрын
Excellent!
@IsmailBaj-ri6wv3 ай бұрын
You're the best I've seen explaining QB so far. Does activating/inactivating inventory items could be a reason for having variances between inventory in BL & inventory valuation for previous dates? In my case, pulling-up inventory valuation today matches BL but doing it for previous dates shows variances then doing inactivate to some inventory items shows different differences on different dates but matches as of today.
@HectorGarciaCPA3 ай бұрын
No.. because there is an option to show inactive items in the valuation report. The variances are oftendo to people making adjustments to the inventory asset account via non-inventory transactions
@oprahson82393 жыл бұрын
thanks for your instruction!! great helpful!
@max-zl1vm3 жыл бұрын
Thanks for posting!
@chapmangrouplv4 жыл бұрын
Thank you very much for this video! Can you give advice on the Balance Sheet side of it: how to trouble shoot that side of it and how it got so far off in the first place? So that a large correction doesn't need to be done like this in the future?TIA!
@nadinemonico68354 жыл бұрын
Can you please do a review on how to properly document inventory adjustments for expired items? Should this reflect a negative or positive number on my P&L?
@HectorGarciaCPA4 жыл бұрын
It would be an positive expense (a “negative” to net income) Just make a regular inventory adjustment
@DressmerizedBlogspot3 жыл бұрын
Hi. Just want to ask the inventory adjustments should put right under COGS? Because it really really reflect negative at PL. ?
@westernshack3 жыл бұрын
how do you scan in quantity count that just came in ?
@pauldumaluan5724 жыл бұрын
Hi Hector thank you for helping us with QB but what about when the Journal Report in my sales invoice generate a different entry when it come to COGS : Debit inventory and credit COGS. Pls. Help!
@harmanbhamrah37922 жыл бұрын
Hi Hector, I have a question regarding the Add of date on inventory. By mistake I put the wrong date. Could you please help me with the steps to correct my date?
@dawnwood487117 күн бұрын
I have a company that does not do individual items for inventory just the price paid for it on the bank account and she writes inventory purchased. It is input in Inventory Asset. I never see what individual items are sold either , just the bank account that shows the income ...... Nothing subtracts from inventory asset and it does not show COGS. Any suggestions on how to make this work without putting in each item. She tells me the amount of inventory on hand in dollar amount when she wants a P&L but I don't know how to make it show on the P&L. Is there anyway to make this work "her way" in Quickbooks?
@HectorGarciaCPA16 күн бұрын
Just dont use inventory items…
@MrFixit-op6nb Жыл бұрын
my inventory asset is calculating the RETAIL VALUE on some items and nothing on others, How do i change what Quickbooks is using to calculate the Value of inventory
@HectorGarciaCPA Жыл бұрын
If its wrong, you may need to do a one time value adjustment to fix the historical. Then moving forward you need to learn how to book the inventory purchases correctly
@TheBlanco951 Жыл бұрын
I tried making an adjustment for an item (zeroed it out) but the change does not show up in cogs I had enough inventory on hand for the cogs to go through. Does anyone know what could be causing this problem? I know for a fact that the previous year had nothing to do with it because my company just started assembling the product for the first time this year.
@kimchiice3 жыл бұрын
Hi Hector You are a awesome teacher thanks for giving so generously of your time. I have a question concerning a build created incorrectly in 2018 (books are closed) but just caught the mistake now, How do I correct it so my inventory will reflect the correct stock on hand? Should have been a build with 2oz product but it was incorrectly created a build with a 9oz product so I need my inventory to reflect the true count.
@HectorGarciaCPA3 жыл бұрын
Just make a manual inventory adjustment with today’s date.
@kimchiice3 жыл бұрын
@@HectorGarciaCPA thank so much for your response! I did it but I don't see the raw materials going back into stock. Do I need to do more to make that happen?
@user-bn1kg6oj9u Жыл бұрын
Hi Hector. I've learned so much from your videos. Amazing. I've just cleaned up a 20 year mess. My Asset account still does not match between the Balance Sheet and Inventory valuation. We are a wholesale and manufacturing company. After lots of digging, I'm sure it is between our service charges. If I would like to use a service charge in my item cost, how would these be set up. Currently, they are not all the same. We have different service charges for different categories. I can clearly see that they are not uniform. But before I change them, I'd like to know which is correct. If I want the service (such as labeling or bottling) to be part of the assembly item, which expense account and which income account should i use?
@HectorGarciaCPA2 ай бұрын
Use any COGS account
@maysemsaeed81824 жыл бұрын
Hi hictor, i have a problem with my inventory. I have pending builds I don’t know how i got that. So when i need to make new building i do have on hand enough to build but the is amount( quantity reserved by another assemblies) how can i solve that please help
@chinguyen7992 жыл бұрын
If you have a negative item, don't you need to find out why it was negative in the first place before you zero it out? Also, this video is to reconcile the inventory value to the ledger value, but does this value reflect the correct valuation of inventory? I am having quite a lot of trouble with QB inventory as some of the adjustments that my staff made just screwed up the average cost causing incorrect value of the item as well as incorrect COGs...and I still trying to find a way to rectify it :(
@HectorGarciaCPA2 жыл бұрын
All 100% true… but sometimes there is no time for that
@jasongreggmegabyte68783 жыл бұрын
We write equipment leases. Since we own the equipment, should we create a fixed asset, and then somehow associate that fixed asset to a recurring invoice with memory?
@HectorGarciaCPA3 жыл бұрын
You can’t associate it.
@2003babzc Жыл бұрын
After my adjustment, I keep finding negative inventory. What is causing this to repeat?
@HectorGarciaCPA Жыл бұрын
I guess i would need to look at it. I don’t know what you are doing it not doing. Maybe the adjustment was not complete?
@2003babzc Жыл бұрын
@@HectorGarciaCPA When a work order get completed and the quantity is updated, should the value be updated as well? I am told within my company they are not updating the value and therefore my balance sheet is stagnant or unchanged. Is this proper accounting?
@CNordy4 жыл бұрын
Hi Hector, your videos are a great help for us small businesses owners! My accountant made an adjustment to the quantity of an item we had none remaining of, however there was still a value showing. This must be the QB quirk you mentioned happens from time to time. Is this type of adjustment in the video for negative inventory with incorrect valuations doable in any version of Quickbooks Online? I plan to switch to QBE, however I wanted to convert my QBO file over, but was concerned with our negative inventory being a problem.
@HectorGarciaCPA4 жыл бұрын
Inventory value adjustment is not available in QBO
@CNordy4 жыл бұрын
@@HectorGarciaCPA Thanks for the quick response! Is there a workaround? Or is the only option to make the adjustment (without starting a new company file) to convert the file to QBE and make adjustments after that?
@HectorGarciaCPA4 жыл бұрын
Nordy yes you need to adjust the inventory on hand to zero. Change the cost in the item list. Then adjust the quantity again the next day.
@luisorvananos39452 жыл бұрын
Hector, how are you? my question is: how can I check my previous inventory adjustments? thanks
@HectorGarciaCPA2 жыл бұрын
You can tun a custom transaction detail report and filter by that transaction type
@nydiaflores53803 жыл бұрын
Is there a way to "hide/eliminate" the items in inventory when they have been adjusted? so that when the item is looked up to see qty on hand it only shows what's available. Please advise. TY
@HectorGarciaCPA3 жыл бұрын
You need to make the active, adjust them to zero; then make them inactive
@lewy76013 жыл бұрын
At 19:25, May I ask how can we create Negative Inventory Listing report using premier version?
@HectorGarciaCPA3 жыл бұрын
Cant.. it’s only on Enterprise
@MrFixit-op6nb Жыл бұрын
do you consult?
@HectorGarciaCPA6 ай бұрын
Yes, sorry for the late response, do you still need help? here is my website qbkaccounting.com/hourly-quickbooks-consulting-training-support/
@ahmedelmosalamy51453 жыл бұрын
I have an issue: once I build an assembly product to send all material to the production line QuickBooks adds it at once to stock as a finished product although it is still in production not finished yet? the workers maybe need one week to finish ( as an example) and I need to be updating with real material and real finished products please help me how I solve this problem
@HectorGarciaCPA3 жыл бұрын
Wait until their are completed before you create the build
@ahmedelmosalamy51453 жыл бұрын
@@HectorGarciaCPA thank you Hector very much for your reply , but in this way I cannot control the production line because I will build assembly after workers finished so , you give me an idea 💡 that everyday I will build assembly in the morning , move raw material form store to production area and tracking raw material very well and with the end of day I’ll edit same build with actual finished items but this way need some work around cause QB not cover my point.
@khadarxasan86174 жыл бұрын
I have a problem in my quickbooks desktop, the cost of goods is zero in the income statement for the sold items. And some items have zero sales as well.. I kindly need your help..thnk u
@HectorGarciaCPA4 жыл бұрын
I guess I would need to see it.. are you sure you are using inventory parts?
@abdirashidadan88964 жыл бұрын
xasan Item List ga fiir ILeen waxaa laga yaaba inaad dooratey Non-Inventory Item Kadhig Inventory Part .Expense side kana kadhig Cost of Goods Sold. Income Side kana kadhig Revenue/Sales income etc.
@khadarxasan86174 жыл бұрын
@@HectorGarciaCPA Yes, teacher. i have solved the problem by watching some of your videos. Thank u.
@michaelfernandez51732 жыл бұрын
Hi Hector! How do I set up an appointment with you?
@HectorGarciaCPA2 жыл бұрын
954-414-1524
@robertschoen77914 жыл бұрын
My inventory item list has many inactive items with quantities. However, I cannot change the item from inactive to active. Why not?
@HectorGarciaCPA4 жыл бұрын
Shouldn’t be an issue, maybe you have some corruption
@robertschoen77914 жыл бұрын
@@HectorGarciaCPA if corrupt how to I repair. Otherwise, I cannot correct these items?
@HectorGarciaCPA4 жыл бұрын
Robert Schoen no clue.. without looking at it, it’s impossible to diagnose
@robertschoen77914 жыл бұрын
@@HectorGarciaCPA I have a meeting with Alexander on Monday. Should I discuss with him or arrange a conference with you? I have a bank waiting for statements.
@robertschoen77914 жыл бұрын
By the way, I'm really impressed with all your videos. Thanks.
@emadkhalid82614 жыл бұрын
I don't want avg. Cost in inventory rather I need to take actual cost entered in my ledger , can anyone help....?
@HectorGarciaCPA4 жыл бұрын
thats is not an option
@emadkhalid82614 жыл бұрын
I mean I need to take cost entered in bill with new cost for every item Purchased
@emadkhalid82614 жыл бұрын
Since we are a trader of bulk orders shipped on demand. Do you think batch costing can help us here
@HectorGarciaCPA4 жыл бұрын
Emad khalid eitherway it doesn’t work like that.. it’s avg cost.
@rjbrun88473 жыл бұрын
HOW DO I MAKE SERIAL NUMBERS FOR MY PRODUCTS?
@HectorGarciaCPA3 жыл бұрын
I explain serial numbers in other videos
@rjbrun88473 жыл бұрын
@@HectorGarciaCPA Hi thanks for the reply, how do I track warranty for each of my products using QB?
@HectorGarciaCPA3 жыл бұрын
There is not warranty tracking. But if the info is inside the Invoice, you could always just search the invoice. If the items have serial numbers, you can enter that serial number in the Invoice
@rjbrun88473 жыл бұрын
@@HectorGarciaCPA Will Barcode scanning work for AC units? and Aircon parts?
@khadarxasan86174 жыл бұрын
Could you pls tell me your email. Thank so much teacher..