It isn't cost minus price. It's a moving reconciliation across four Drug Tariff categories, a discount clawback, item fees, and price concessions that change several times a month — applied across every line you dispense. Here is how we model it.
A single dispensed line's true margin depends on at least seven independent variables — each on its own clock, each able to flip a line from profit to loss without warning. Track one wrong and the error compounds across thousands of lines a month.
Seven variables, four different update cycles, thousands of lines. The interactions are where the money hides.
Margin is computed per line, per month, then aggregated. Every term has to be resolved against the right reference data for that exact month — including any mid-month concession revision.
A pipeline, not a template. Raw, inconsistent inputs are normalised, matched to live reference data, reconciled line by line, then read by an AI layer that classifies losses, surfaces anomalies and drafts the narrative — before a human audits every material figure.
The AI accelerates classification and pattern-finding across thousands of lines; the judgement, and the sign-off, stay human.
Practices ask whether they could build this in-house. Honestly: the calculation is the easy part. Keeping it correct, every month, as the rules move underneath you, is where it becomes a specialist discipline.
Tariff categories re-price quarterly; concessions shift several times a month; rebate matrices change with every promotion. A model is only as right as the day's data behind it.
A concession applied a week late, or a clawback band misread, quietly mis-states thousands of lines. Small errors don't stay small once they aggregate.
The model encodes how a real dispensary actually trades — not a generic finance template. That domain reading is the part that can't be downloaded.
An AI-drafted figure that nobody checks is a liability. Every material number is traced to source before it reaches a partner's desk.
The scale is the point. This isn't a one-off audit; it's a standing reconciliation that runs each period and tracks whether the actions you took actually moved the number.
Explore a full sample review — the interactive dashboard, the drug-level ledger and the partner report — built on a fictional practice.