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 there,
Our Accountant audit the inventory movement report by "Inventory valuation detail"
But we need inventory transaction row data export to excel for check the qty and amount
How to get the inventory transaction row data?
Solved! Go to Solution.
Thanks for coming back to the Community, JinYeh.
QuickBooks Desktop uses the Average Cost method to value your inventory. That’s why the Asset Value column will show on the Inventory Valuation Detail and other inventory reports.
If you opt not to see the average cost of the items, use the data from your Custom Transaction Detail. Please know you’ll have to manually calculate the amount for each one to get the cost.
Here’s an article that provides detailed information on how QuickBooks manages inventory assets, average cost, and COGS: Understand inventory assets and cost of goods sold tracking.
Additionally, this guide contains solutions on how to resolve the following issue: Balance Sheet and Inventory/Stock Valuation reports show different amounts for Inventory Asset accou....
Please let me know if there's anything else you need. I'll be around to help. Have a great day ahead.
Hello JinYeh!
Let me assist you regarding the inventory report.
We can customize the Inventory Valuation Detail report so we can add the transaction column, quantity, and amount. Please pull up the said report and follow these steps:
Once done, you'll see all the transactions related to each inventory with the quantity and amount. If you need detailed steps on how to edit the reports, here's how to customize them in QuickBooks Desktop. Then, click the Excel button at the top if you want to export it.
In addition, you'll want to set up Advanced Inventory in QuickBooks Desktop.
Post again here if you need anything else. Have a great day!
Sorry,I ask wrong question before.
I want the other data source to check the data of Report "Inventory Valuation Detail"
And I want the field "trans#"(No. Series) to audit Inventory transaction sequence
I appreciate you for getting back to us, JinYeh.
We can run the Custom Transaction Detail report. This way, we can add the quantity, item, and amount of the items.
Let me guide you how:
I've also added this reference for more information in adding and removing data on the report: Customize reports in QuickBooks Desktop.
I'll be around if there's anything that I can help. Keep safe!
I have the other question, the report Inventory Valuation Detail have field "asset value",
But the Custom Transaction Detail can't find the filed asset value,and the value not equal amount .
Hi JinYeh!
The Asset Value column shows the total value of the products. This is the result when you multiply the quantity on hand and its cost. The Amount column reflects the total amount for each transaction.
The reason why the Asset Value column isn't available in the Custom Transaction Detail report is that this report is for individual transactions only with each account involved.
I've added some links you can check. These will explain more about reports:
Leave a comment again if you have additional questions. Take care!
Could I calculate the asset value by the data of Custom Transaction Detail or the other data source?
Thanks for coming back to the Community, JinYeh.
QuickBooks Desktop uses the Average Cost method to value your inventory. That’s why the Asset Value column will show on the Inventory Valuation Detail and other inventory reports.
If you opt not to see the average cost of the items, use the data from your Custom Transaction Detail. Please know you’ll have to manually calculate the amount for each one to get the cost.
Here’s an article that provides detailed information on how QuickBooks manages inventory assets, average cost, and COGS: Understand inventory assets and cost of goods sold tracking.
Additionally, this guide contains solutions on how to resolve the following issue: Balance Sheet and Inventory/Stock Valuation reports show different amounts for Inventory Asset accou....
Please let me know if there's anything else you need. I'll be around to help. Have a great day ahead.
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.