> Stock Control / Stock valuation / Current stock valuation report

Current stock valuation report

The current stock valuation report displays your stock item levels and value at the time the report is generated.

The stock levels and value for the current stock valuation report are calculated for both confirmed stock itemsConfirmed stock items are where the cost of an item is already known and recorded. This occurs in the following circumstances: stock items have been bought and the supplier's invoice had been recorded in Sage 200; stock items have been returned to a supplier and the credit note has been processed in Sage 200; stock items have been added in Sage 200 at a specified cost; a work order has been entered (using Sage 200 Manufacturing) and the manufacturing cost is known. and unconfirmed stock itemsUnconfirmed stock items are where goods have been received, but the actual cost is not known. This occurs when: stock items from purchase orders have been entered as received, but the supplier's invoice has not been processed in Sage 200.Stock items from purchase returns have been entered as despatched, but the credit note has not been processed in Sage 200, or where the manufacturing process is finished (using Sage 200 Manufacturing) but not all the costs are known..

The stock levels and value are displayed on the report as follows:

Quantity.

This the confirmed stock level for the item.
Quantity Including Unconfirmed.

This is the confirmed stock level (Quantity) for the item, plus the unconfirmed stock level for the item.
Value.

This is the value of the confirmed stock level (Quantity).
Value Including Unconfirmed.

This is the value of the confirmed and unconfirmed stock level (Quantity Including Unconfirmed).

How the stock values are calculated

The value of a stock item is calculated differently depending on the Costing Method used for each stock item.

Standard costing method.

(Stock level) x (Standard cost price)

This uses the Standard cost price, on the stock item's record, to calculate the value of both confirmed and unconfirmed goods.

The Standard cost price is displayed on the report as the Valuation price.

Example

In this example, the standard cost price of an item is £10. You start with five of this in stock on 01/07. The purchase invoice for them has been entered.

Date		Stock level	Standard Cost	Stock valuation
01/07	5 confirmed	5	10	50

You purchase a further three items on the 15/07 and record the invoice.

Date		Stock level	Standard Cost	Stock valuation
15/07	Add 3 confirmed	8	10	80

You order and receive a further four items on the 20/07. This time you have not yet received the invoice and the standard cost has been reduced to £8.

When you run the stock valuation report now the new standard cost price (£8) is used to value all the items.

Date		Stock level	Standard Cost	Stock valuation
20/07	Confirmed	8	8	64
	Including Unconfirmed	12	8	96

Average costing method

(Stock level) x (Average buying price)

This uses the average buying price on the stock item's record to calculate the value of both confirmed and unconfirmed goods.

Each time a purchase invoice or an addition of stock is recorded for an item, the average buying price is updated and recorded by Sage 200 using the current system date on your PC.

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

Example

In this example, you start with 5 items in stock with an average buying price of £10.

Date		Stock level	Average Buying Price	Stock valuation
01/07	Confirmed	5	10	50

You then order and receive an additional 5 items on 15/07 at a price of £12.

The new average buying price is calculated as £11 ((5 x 10) +(5 x 12) / 10). The invoice is entered.

Date		Stock level	Average Buying Price	Stock valuation
15/07	Confirmed	10	11	110

You then order and receive a further five items at a price of £12 on 20/07, but the invoice has not been entered. The average buying price has not been updated. Their value is calculated using the last Average buying price(£11).

Date		Stock level	Average Buying Price	Stock valuation
20/07	Confirmed	10	11	110
	Including Unconfirmed	15	11	165

FIFO costing method

This uses a different cost price depending on whether the goods are confirmed or unconfirmed.

Confirmed goods

(Confirmed stock level per bin) x (the cost price of each item)

Unconfirmed goods

(Unconfirmed stock level per bin) x (the last cost price of the item, per bin)

The Last cost price is the cost price that was recorded the last time a purchase invoice or an addition of stock was entered for the item in that bin.

When the last cost price of the item is zero, the average buying price is used.

Example

In this example, the last cost price of an item in Bin 1 is different to the last cost price of the same item Bin 2.

You start with five items in Bin 1 and three items in Bin 2.

Date		Bin	Stock level	Cost Price	Stock valuation
01/07	Confirmed	1	5	10	50
	Confirmed	2	3	8	24
	Total Confirmed		8		74

On 15/07 you order and receive five items for Bin 1. The cost price is £11 and the purchase invoice is entered.

Date		Bin	Stock level	Cost Price	Stock valuation
15/07	Confirmed	1	5	10	50
	Confirmed	2	3	8	24
	Confirmed	1	5	11	55
	Total Confirmed		13		129

On 20/07, you order and receive three items for Bin 2. The cost price is £9 but the invoice has not been entered. The last cost price (£8) is used to value these items.

Date		Bin	Stock level	Cost Price	Stock valuation
20/07	Confirmed	1	5	10	50
	Confirmed	2	3	8	24
	Confirmed	1	5	11	55
	Unconfirmed	2	3	8 (last cost price)	24
	Total Confirmed		13		129
	Total including Unconfirmed		16		153

Actual costing method (traceable stock items only).

This uses a different cost price depending on whether the goods are confirmed or unconfirmed.

For confirmed items the actual cost price is recorded against each batch or serial number.

Confirmed items

(Confirmed stock level per bin) x (the cost price of each item)

Unconfirmed items

(Unconfirmed stock level per bin) x (the last cost price of the item per bin)

The Last cost price is the cost price that was recorded the last time a purchase invoice or an addition of stock was entered for the item in that bin.

Example

In this example, a serial numbered item is being valued. The actual cost of each item is recorded. On the 01/07 you start with five items in Bin 1 and 3 items in Bin 2.

Date		Bin	Serial number	Stock level	Cost Price	Stock valuation
01/07	Confirmed	1	1 - 5	5	10	50
	Confirmed	2	6 - 8	3	8	24
	Total Confirmed			8		74

By the 15/07 you have sold 2 items, one from Bin 1 and one from Bin 2.

Date		Bin	Serial number	Stock level	Cost Price	Stock valuation
15/07	Confirmed	1	2 - 5	4	10	40
	Confirmed	2	7 - 8	2	8	16
	Total Confirmed			8		56

By the 20/07, you ordered and received five items for Bin 2 at a cost price of £11. You have entered the invoice for these.

You have received an additional three items for bin 2 at £10, but have not entered the invoice. The last cost price of £11 is used to value these items.

Date		Bin	Serial number	Stock level	Cost Price	Stock valuation
20/07	Confirmed	1	2 - 5	4	10	40
	Confirmed	2	7 - 8	2	8	16
	Confirmed	2	9 -13	5	11	55
	Unconfirmed	2	14-16	3	11 (last price)	33
	Total Confirmed			11		111
	Total including Unconfirmed			14		143

To run the current valuation report

Open: Stock Control > Reports > Status > Valuation.

Use the criteria to select the stock items to include on the report.

You can select by:

Stock Item

Stock items in a warehouse

Product Group

Stock item search value

Stock item costing method

To run the current stock valuation report, accept the current date as the Valuation date.
To produce the report, click OK.