Skip to content
logo Knowledgebase

Product valuation reports

Created on  | Last modified on 

Summary

Understanding stock value reports in Sage 50 Accounts.

Description

This helps you understand the value of the products you have in stock and enables you to run opening and closing stock journals.

The product valuation reports are only available in Sage 50 Accounts Professional. If you're interested in upgrading, leave your details and we'll be in touch.

 NOTE: All values on these reports display in your base currency. 

Resolution

Run a stock valuation report
  1. Click Products and services, then click Reports.
  2. Select Product valuation then double-click the report you'd like to run.
  3. Select the required criteria, then click OK.
How the product valuation is calculated
Last purchase price This is the Last Code Price (Standard) field from your product record.
Average cost price This figure is the total cost price of the product, divided by the Quantity in Stock. This figure is updated by from Adjustments In, Goods In and Goods Returned transactions.
Retrospective This figure calculates product activity within your date range. It takes the transaction's quantity and multiplies by the cost price. This is the only method that allows you to enter a date range.
The product valuation reports
Product Valuation (Average Cost Price) This report uses the average cost price and shows the quantity in stock, average cost price, value of the product, sales price and expected sales. This report uses all transactions "in". 
Product Valuation (Last Purchase Price) This report is the same as above, but it calculates the Cost Price using the last purchase price used. This appears in the Last Cost Price (standard) box in the Product Record. This report is based on the current quantities in stock whatever the last purchase price was.
Product Valuation by Stock Cat This report is the same as the Product Valuation (Average Cost Price) but it groups the report by Stock Category. This report is based on the current quantities in stock.
Retrospective Product Valuation This report generates figures from the individual stock transactions, rather than from the Product Record. Because of this, it is the only Product Valuation report which runs retrospectively, allowing you to enter a date range on the Criteria window of the report. This report should be run from 01/01/1980 up to the date you want to see the value at.
Troubleshooting and investigation

If the report figures aren't as expected, check the reasons why the figures can appear to be incorrect.