Reports

Margin: what you earned on your sales

Your sales less what those stones cost you, after returns, in your main currency — grouped by shape, customer, salesperson, month and more.

How to

  1. Open Analysis → Margin. It opens on This month.
  2. Choose the Period (or From and To), and narrow it if you like with Customer, Department, Shape, Color, Clarity and Branch. Press Apply filters.
  3. The cards show Revenue, Cost, Margin, Margin on revenue and Discount to Rap for the whole period.
  4. Choose Group by to compare — Shape, Color, Clarity, Size, Department, Customer, Salesperson, Month, Branch, Seller / Purchaser, Lab or Category. The table shows each group’s Margin, On cost and On revenue.
  5. The grid below lists every sale line. Export Excel downloads it.

Good to know

  • Cost is fixed on each line when the stone is sold, so a later change to a stone’s cost doesn’t change past margin.
  • Sale returns are taken off, so a returned stone does not count as earned.
  • On cost and On revenue are the margin as a percentage of each. Disc. to Rap covers only the diamond lines that have a Rap price.
  • Only people whose role allows it see Margin — roles are set in Settings → Users.

Open this screen in Avirat →

Related

Still stuck? WhatsApp or call us on +91 97262 88072, or use Help & support inside Avirat — we’ll see the screen you’re on.

Try it with your own stock

14 days free, everything switched on, no card needed.

WhatsApp us