Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
My inventory valuation summary and Balance Sheet Don't Match. It appears to be a posting error within my subassembly items where the avg cost is changing.
I have 3 items that are "sub" assembly items. Each item is built individual and tracked until it is incorporating into the next sub assembly item. Sub Item 1 is built, an increases Work in Progress. This item is incorporated in to Sub Item 2. When this item is built, Work in Progress is Decreased by incorporated item 1 and increased by the new sub Item 2. This continues for 1 more step until the final item is build into a new asset and posted to an inventory asset account labelled Finished Goods. There is currently a negative balance in my Work in Progress Account. When i compare the GL detail and the Valuation summary, it appears, that when each step of the assembly is built, the avg cost is changing as it is posted to the GL but remaining constant on the valuation summary. I can't adjust the items global value because it is correctly reflected. It is only reflected incorrectly on the Balance Sheet. Any suggestions on how to solve this error?
Welcome back to the QuickBooks Community, astanleyCTG. I'll be sharing details on the difference between Inventory Valuation vs Balance Sheet reports in QuickBooks Desktop. Then, ensure that you'll be able to see both reports with accurate details.
The Balance Sheet report pulls information from the accounts whether they are associated with items or not. The Inventory Valuation draws details from items only. That said, entries using inventory items appear on both reports but transactions without inventory items show only on the Balance Sheet report.
Here are transactions that will show on the Balance sheet but not the Inventory Valuation reports:
To fix the error and any discrepancy that causes inaccurate details on the report, I reccomend following the different recommended solutions on this article: Balance Sheet and Inventory/Stock Valuation reports show different amounts for an Inventory Asset ac....
Lastly, you may refer to this article on how you can make any changes to your item details in QuickBooks Desktop: Add, edit, and delete items.
Don't hesitate to click the Reply button if you have any other questions about Inventory Valuation vs Balance Sheet reports in QuickBooks. I'm always here to help you out.
Thanks for following up with us, @astanleyCTG. I'm here to help sort your average cost out.
You can edit the average cost of an item that you've changed. This way, the two reports will match in QuickBooks.
Before doing the process, I'd suggest consulting your accountant. They'll be able to give you the best accounting advice for this situation. If you don't have one, check out this link to find one near you.
Here's how to adjust the average cost of an item:
Find out more about managing average cost in QuickBooks Desktop through the following articles:
Just in case you wanted to check moreover about inventory assets and COGS tracking, you can refer to this article: Understand inventory assets and cost of goods sold tracking.
You can always get back to us whenever you have other concerns or questions. I'm always here to help you anytime. Take good care, @astanleyCTG.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here