It is crucial to run the Inventory Listing by Category report as close to the year-end as possible. Only the current inventory value can be obtained when the report is run. If any invoices or inventory orders have been entered for the new year, the Estimated Inventory Value report will give a close estimate for the previous year.
- Before continuing, ensure that your Default Discount has been set.
- From the Business Tools menu, select Reports (or from the Reports - Tools group on the main toolbar, click Reports).
- Under the Inventory section, double-click the Estimated Inventory Value report.
- From the preview window, click to print (or to export as a pdf).
Understanding the report:
- (1) - Current Inventory: the retail amount of inventory on the date the report was printed (amount added)
- (2) - Customer Sales: the total retail amount of products invoiced for the current year at the time the report was printed, excluding all Direct Ship and Guest Checkout invoices as well as excluding any Shipping or Gift Certificates sold (amount added)
- (3) - Loaned Product: the retail total of any loaned product (amount added)
- (4) - Product Orders: the retail total of all received orders for the current year, excluding any Direct Ship or Guest Checkout orders (amount subtracted)
- (5) - Borrowed Product: the retail total of any borrowed product (amount subtracted)
- (6) - Estimated Inventory Value: the approximate wholesale amount (cost of goods) for the previous year based on your Default Discount