Was this page helpful?
Comments or suggestions?
May we contact you? Although a personal response may not be provided, we value your feedback.
Enter Email Address (optional)
This email is invalid
Your appear to have Cookies disabled in your browser. This web site is best viewed with Cookies enabled.
You appear to be using Internet Explorer 6. This web site is best viewed in more recent versions of Internet Explorer.
Add to favorites
Inventory valuation summary report
This report gives a quick assessment of the value of your inventory. By default, the date range is the current month to date, but this can be changed to suit business needs. Each item is listed with the following information displayed in columns
The description of the item, if a description for purchase transactions was entered.
The current quantity on hand, which is the net number of received and sold items. Because QuickBooks Desktop permits items with zero in stock to be sold, it is possible to have a negative number in this column.
Units of measure information
QuickBooks Desktop uses the totals from each transaction for receipt of inventory to calculate this figure.
The value posted to your Inventory account in the general ledger. The value is calculated by multiplying the number on hand by the average cost.
% of Tot Asset:
The percentage of your total inventory assets that this item represents.
The price set for this item. This figure is obtained by looking at the item's configuration window. If a price was entered when the item was set up, that price is displayed. If a price was not entered $0.00 displays. QuickBooks Desktop does not check the sales records for this item to determine this number. If the price is routinely changes when filling out a customer invoice, those changes will not be reflected in this report.
The current retail value of the item, which is calculated by multiplying the number on hand by the retail price (if the retail price is set).
% of Tot Retail:
The percentage of the total retail value of your inventory that this item represents.
Other Articles to Try
INF28019 - Create, filter and customize reports in QuickBooks Desktop for Windows
KB ID# INF13183
12/5/2016 12:35:29 PM
QYPPRDQBKSWS03 9138 Pro 2017 6abf62