Sage 200 - Retrospective stock valuation report

When Sage 200 is set up to retain a history of stock transactions, it is possible to produce a retrospective stock valuation report. This displays stock levels and value at the end of a specified date in the past - known as the valuation date.

This can be useful when checking the value of stock against the Nominal Ledger.

If you keep a history of your stock transactions, you can produce a retrospective stock valuation report. This displays your stock levels and value at the end of a specified date in the past. This date is the 'valuation date'. This can be useful when checking the value of stock against the Nominal Ledger.

Before you begin.

• You must have selected 'Keep movement history' for the Product Groups that hold the stock items you wish to include on the report.
• Ensure that the stock transaction history for the reporting period in question has not been deleted.

How the stock levels and values are calculated

Quantity

This is the confirmed stock level for the item. The retrospective quantity is calculated by reversing the transactions entered for the stock item from the current date back to the specified valuation date, an example of which is below:

The table shows how the stock quantity is calculated on 30 July for a retrospective stock valuation report with a valuation date as at 10 July.

Value

This is the value of the confirmed stock level (quantity). The retrospective stock value is calculated differently depending upon the Costing Method used for each stock item.

Standard costing method.

The standard cost price is calculated as (Quantity) x (Standard cost price of the item on the valuation date specified for the report).

The standard cost price is displayed on the report as the 'valuation price'. Each time the standard cost price of the item is changed on the stock record, the new price and the date it was changed is recorded by Sage 200 (using the current date on your PC), an example of which is below:

Using the example for calculating the quantity above, the value of the 13 items is calculated using the standard cost price on 10 July. This was £8 per item.

Average costing method

The average cost price as calculated as (Quantity) x (Average buying price of the item on the Valuation date specified for the report).

The Average buying price is displayed on the report as the Valuation price.

Using the example for calculating the quantity above, the value of the 13 items is calculated using the average cost price on 10 July. This is £9.10 per item.

FIFO costing method

This retrospective stock value is calculated in the same way as the retrospective stock quantity. The value of each transaction is reversed from the current date back to the valuation date, an example of which is below:

Using the example for calculating the quantity above, the value of the 13 items is calculated using the cost price of the item for each transaction.

Actual costing method

This retrospective stock value is calculated in the same way as the retrospective stock quantity. The value of each transaction is reversed from the current date back to the valuation date, an example of which is below:

Using the example for calculating the quantity above, the value of the 13 items is calculated using the cost price of the item for each transaction.

Upgrade your licence

Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.