Inventory Value Reconciliation report
This report reconciles the balances of your inventory asset accounts with the values of the associated inventoried items as of a particular date. (Inventoried items are items for which you’ve selected I Inventory This Item in the Item Information window.)
If you record your inventory account number on a non-inventory item transaction, this report will show an out of balance amount other than $0.00.
For example, if you record your inventory account on a general journal entry transaction, your inventory account will reflect the debit or credit amount, and so the Account Balance on this report will reflect the amount. The general journal entry, though, won’t be included in the transaction list on this report; only transactions that include inventoried items are included. The Inventory Value on this report won’t include the amount. Therefore, an out of balance amount will display.
Report details
Filters
General: Accounts: All/Selected
Advanced: As Of: Date
Sorted by
Item Number/Name
Subtotals / Totals
Totals for each account:
Subtotal On Hand
Subtotal Current Value
Out of Balance (difference between Current Value subtotal and balance of account as of the date)
More Report Fields (not preselected)
Item Description
Average Cost
Current Price
Sell Price
Sell Unit
Last Buy Price
Buy Unit
Finishing Choices
Separate Pages
Add to Reports Menu
Prevent Data Changes During Report Generation
Sort by Account Number/Account Name
Include Company Name
Include Company Address
Include Report Date and Time
View transaction source
Click an Item Number, Item Name to open the Item Information window. Click On Hand or Current Value to open the Items Register.
View sample
Reports List

More help options

Top of page