Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHi all,
I'm having some issues with my expenses and income. Basically, our inventory was all screwed up and there were lots of issues for years on end, prior to me working here. This year, I converted over to non inventory and in doing this I realized how many parts were sold with no expense for the last year. These parts were billed out on invoices, but they had no cost so we just show huge profits with no expenses which is incorrect. Is there any way I can go back and realize these expenses for all the parts sold? Would I have to basically retype every invoice this year by correcting every part number with the updated expense? Any advice is greatly appreciated.
I appreciate the complete details you've shared, @Chloecs.
Tracking your inventory purchase cost varies from business to business. There are three ways to record the cost of your inventory items in QuickBooks.
There's no need to retype your invoices to update your inventory expense or cost. You can clone your company file, and update/correct your inventory setup. You can only export and import the correct data on the other company file. Here's how to export items:
Here's how to import data on the other company file:
Also, you can do inventory adjustments to ensure you're correctly tracking your items in QuickBooks. As long as you've posted the adjustment to their proper accounts, your inventory status report will show accurate tracking of your inventory quantities. You can read through this article for more detailed information about tracking COGS correctly: Adjust your inventory quantity or value in QuickBooks Desktop.
Lastly, I'd recommend consulting with an accountant to ensure that you're guided accurately in managing your inventory items.
Keep in touch if you have other questions about tracking inventory in QuickBooks. I'm always around to answer them. Have a good one.
I'm here to ensure everything is flawless, @Chloecs.
Did the information on how you can track your inventory expenses in QuickBooks answer your inquiry? Were you able to perform the steps I've shared to correct your inventory setup?
I'll be around if you need more help with your concern. Wishing you all the best.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.