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 nowHello,
In my inventory evaluation summary report, the calculations for inventory asset value is off by a few $.
760 units X $37.38 = $28408.00
Can anyone explain why?
Thank you for your time.
Welcome to the Community, @2000yearsago.
Let me sort things out for you. Your asset value will depend on the transactions entered in your QuickBooks. Possible reason that the calculation is incorrect is because of some data damage. To fix this you can Verify and Rebuild Data in QuickBooks Desktop.
I'll show you how:
If you're still having the same result after performing all the troubleshooting, you can contact our support team. They have the necessary tools to further investigate and fix your concern.
Please let me know if you need further assistance. I'd be glad to help you. Keep safe.
Thanks for the reply.
It said "QuickBooks detected no problems with your data"
The math is still wrong.
Thanks for the reply.
Tired the steps above and it said "QuickBooks detected no problems with your data"
The math is still wrong.
I know how important to account for every number accurately, @2000yearsago.
This discrepancy usually happens because the program is rounding the decimal points. You may try checking the original price of your Item List from the Lists menu. This way, you'll be able to verify if you got the same price/cost shown in your report.
While the report shows the rounded number, the total amount always bases on the original price/cost of the item.
Let me also add an article about setting up multiple locations for tracking inventory: Multiple Inventory Sites.
Please let me know if you have other concerns. Have a great day.
Hey,
It looks like my average cost has about 5 digits after the decimal. How can I change so it rounds up to the nearest 100th?
Hey there, @2000yearsago.
Thanks for following up with us.
At this time, you can't round to the nearest 100th. The average cost is based on the math for the qty and the asset value for the item. I can see how this would be beneficial for you and your business. If you'd like, I can submit product feedback to our developer team so this could be considered in a future update.
Please let me know if you have further questions or concerns. You can always reach out to us here in the Community anytime you need a helping hand. Take care!
**Say "Thanks" by clicking the thumb icon in a post
**Mark the post that answers your question by clicking on "Accept as solution"
Hey,
So is there any valid Solution to the problem I'm having?
Hello 2000yearsago,
You can manually adjust the cost of an item through these steps:
Here's an article that might be a help as well: Adjust your inventory quantity or value in QuickBooks Desktop.
I'd also suggest reaching out an accounting professional when managing your inventory items. They can give you options that will suit your business setup.
If you encounter the same issue with the amounts, you can contact our Technical Support Team. They can review your company file and provide additional troubleshooting steps.
We'll be right here if have additional concerns.
This is useful!
Hi there,
I'm glad to know that my colleague's response has helped you with your concern. We're always committed to providing excellent service to everyone. We assure you that you'll have the best experience with QuickBooks.
Feel free to post your queries or concerns here in the Community space. We're always here to help you.
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.