How to Add Stock Opening Balance and Stock Take Values

Use the attached How to for Stock when:

You want to enter in your Opening Balance for Stock

You've done a stock take, and you want to add in the new value for your stock

If you are taking the stock figures from the Stock Report rather than a stock take:

Go to Reports, Sales Report, Stock Report.

Opening Stock - comes from Tools, Products, Opening stock as entered
Sales Quantity - comes from the total quantities of all the sales invoices, drill down to see
Purchase Quantity - comes from the total of all the purchase invoices, drill down to see
Quantity on Hand - Opening Stock - Sales Quantity + Purchase Quantity
Opening Stock Value - comes from the Tools, Products, Opening Stock Value as entered
Sales Value - comes from the total value of all the sales invoices, drill down to see
Cost Value - comes from the total of all the purchase invoices plus the opening stock value, drill down to see
Stock Sales Value - the average selling price (drill down to see) by the Quantity on hand
Stock Purchase Value - the average purchase price (drill down to see) by the Quantity on hand
COGS (Cost of Goods Sold) Average Cost price (drill down to see) by the Sales Qty
Average Cost Price is (Cost Value ) / (Total Purchases qty + Opening Stock Qty)
Average Margin is (Sales Value - COGS) / Sales Value as a percentage