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 quanitites 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 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 sellign 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) Avg Cost price (drill down to see) by the Sales Qty
Avergage Cost Price is (Stock Purchase Value + Opening Stock Value ) / (Total Purchases qty + Opening Stock Qty)
Average Margin is (Sales Value - COGS) / Sales Value as a percentage