Nine numbers from last month. This sheet works out where your practice is losing margin, and which leak is costing you most.
Your total sales for the month with discounts already taken off.
Every completed sale that went through the till.
A frame sold with its lenses, counted as one sale.
Your system may call this 'discount given' or 'price override'.
Count of sales where any discount or price reduction was applied.
Complete sales that also included an upgrade, a second pair or Rx sunglasses.
Frames received more than a year ago that have not sold.
The cost (not retail) value of the aged frames above.
The cost value of your entire frame inventory.