---

In this site there is a Microsoft Excel file you can use to record the incoming and outgoing of stock items in your store, quantity-wise and value-wise, using Weighted Average method. The instruction on how to use the file is in the file itself.

Click here to download a sample file.

---

PRICE : Careful when stating the OUT price. Use the latest weighted price (Col J) of the same item.

ITEM CUMULATIVE QTY : Will show correct figure if data is filtered based on ITEM (Column B)

ITEM CUMULATIVE VALUE : Will show correct figure if data is filtered based on ITEM (Column B)

ITEM WEIGHTED AVERAGE PRICE : Will show correct figure if data is filtered based on ITEM (Column B)

Use SUBTOTAL instead of SUM in TOTAL Row.