How to
- Open Analysis → Stock Rotation.
- Choose the Period (or From and To dates), and a Branch if you have more than one.
- Choose Group by — Shape, Color, Clarity, Size, Department, Lab or Category — a Department, and Show: Carats, Pieces or Cost. Press Show.
- Each row shows Opening, Bought, Other in, Sold, Other out, Closing and Of which on memo. Opening + in − out always equals closing.
- Turnover is what was sold ÷ the average of opening and closing stock, at cost. Days to sell is how long an average stock takes to sell at that pace.
Good to know
- Stones out on memo or with a maker are still yours, so they stay in stock. Memo-in stones are not counted until you buy them.
- Closing at cost for all branches equals the stock on the Balance Sheet for the same day.
- For one branch, stones transferred in and out count as Other in and Other out.
- Show: Cost appears only for people allowed to see cost.
- Export Excel and Print / PDF are at the top right.
Related
- Stock ageing: how long your stock has been sitting
- Stock register: the full history of a stone
- Margin: what you earned on your sales
Still stuck? WhatsApp or call us on +91 97262 88072, or use Help & support inside Avirat — we’ll see the screen you’re on.