Package pricing workbook
Work out what one session really costs, then see what each package discount does to your margin. Three tiers, a what-if table and an instalment plan tied to the sessions.
Download
FreeNo sign-upDownloads directlyExcel and Google Sheets
Rather fill it in on screen? Package pricing calculator
What is inside
| Settings | Clinic name, currency, branches, doctors and your services with their prices. |
|---|---|
| Inputs | One service at a time: its price, the device’s monthly cost and operating hours, room and therapist cost per hour, session length, consumables per session, doctor share, payment fees and the margin you want. |
| Session cost | Device, room, therapist and consumables per session, the full cost at the single price, the floor price for your target margin and the largest discount that keeps it. |
| Packages | Three tiers, 3, 6 and 10 sessions by default: package price, price per session, margin per session and in total, what the patient saves, the deposit, and payments due before sessions 1, 3 and 5. A margin under the target shows red. |
| Deferred revenue | Packages sold this month, cash received and sessions delivered: revenue recognised against cash, and the balance you still owe patients in sessions. |
How to use it
Enter the costs
The device, room, therapist, session length and consumables for one service.
Set the target
Doctor share, payment fees and the margin you want. The floor price follows.
Shape the tiers
Change the sessions, discount and deposit for each package and watch the margin.
Close the month
Enter packages sold, cash and sessions delivered to see what is still owed.
Who it is for
Clinic owners and managers who sell courses of laser, skin care, physiotherapy or nutrition sessions and set the discount by feel. The sample prices a laser session on a device costing SAR 12,000 a month and run 120 hours a month: 15% off six sessions keeps a 48% margin, while 25% off ten sessions falls to 42%, under the 45% target.
Read next
Plans & packages
Price a course rather than a visit. Medicolize tracks sessions, packages and progress from the first consultation to the last appointment…
Read more From the blogHow to price treatment packages: sessions, discounts, deposits and revenue
In most clinics the package price is the session price times the number of sessions minus a discount chosen by instinct. That works until…
Read moreMore free files
Questions
Does it work in Google Sheets?
Yes. Upload it to Google Drive and open it with Google Sheets. Every formula is plain arithmetic with SUM, ROUND and IF.
Can I change the currency?
Yes. Pick it on the Settings sheet. The amounts are numbers, so the sums do not change.
Is my data stored anywhere?
No. The file is yours, on your computer or your own Drive. Nothing you type reaches Medicolize.
Why is the doctor share not part of the session cost?
Because it moves with the price. The workbook takes the share and the payment fees off each package’s own price per session, so a bigger discount lowers them too and the margin stays honest.
Packages that count their own sessions
In Medicolize a package is sold as a treatment plan: each session delivered comes off it, payments are recorded against it, and the sessions still owed show on the patient file. Thirty minutes on your own clinic.