Optisoft Forum
Login
Could you enhance the Sales Conversions report/export so it works as a per-optometrist performance view for a chosen period? At present it gives sales volume but not profitability or efficiency by optom. The four additions below would let me calculate gross margin and conversion per optometrist directly from the export.
1. Cost (ex-VAT) per line — a COGS column
A cost column against every product line, taken from the buy-in/cost price ex-VAT held in the product record. With cost sitting alongside the sale price on each line, I can derive gross profit and margin % per line, per order and per optom.
2. Days worked per optometrist (in the period)
The number of clinic days each optometrist worked over the period. This normalises everything else — tests per day, revenue per day, jobs per day — so optoms working different numbers of days can be compared fairly.
3. Refunds, adjustments and discounts by optometrist
These broken out per optom rather than only at practice level, so I can see net revenue per optometrist and identify who is discounting heavily or generating refunds/recheck eye tests.
4. Tests done vs jobs dispensed per optometrist — conversion
A clean paired count per optom: sight tests done and jobs (spectacle orders) dispensed, plus the conversion % (jobs ÷ tests). The exam counts are already in the report so I'm currently estimating this, but a clean paired figure gives the true efficiency metric.
Hi,
Rather than making changes to the existing report, we think your suggestion may be better addressed using our Custom Query Generator.
This will allow us to create a new report tailored specifically to your requirements, without affecting the existing report.
We’ll be in touch to discuss exactly what you need and take this forward.
Thanks,
Adam