Read the reports and act on them
- For
- Owners and head office, Store managersOwners, managers
On this page
Mortar has four reports, and each answers one question about money the business is losing or is owed. Read them on a fixed day, and finish each one with a list of things to do. Each report needs its own tick in Admin → Logins: see Access levels.
Why it matters
Minfos holds every sale and every pack, but it doesn't say which products lose money, which sit on the shelf for a year, or which keep being thrown out. Each report answers one of those from the stores' own data, and each downloads as a CSV for a buyer, an accountant or a supplier meeting.
Which report, how often, and who
| Report | Answers | How often | Who |
|---|---|---|---|
| Low-margin products | What are we selling at a loss, or too cheaply? | Monthly | Head office buying |
| Deadstock | What stock isn't selling, and what is it costing us? | Quarterly | Store managers, buying |
| Write-offs | What clearance stock are we throwing out, and from whom? | Monthly | Store managers, buying |
| ORT claims | Which ORT patients do we claim for this period? | Each claim period | Whoever files the claims |
Choose the store, or all of yours. Low-margin products and Write-offs open on last month. Deadstock reads the stock as it is today.
Low-margin products
The products sold between two dates at or under a margin, 20 percent unless you change Margin at or under, lowest margin first.
- Sort by Biggest shortfall. It puts first the products that lost the most dollars against your margin, not only the lowest percent, so one costly loss isn't buried under cheap ones.
- A row marked Check cost has a cost ten times its sales or more. Minfos most likely holds a pack's cost against one unit. Correct the cost in Minfos.
- For the rest, check the price in Minfos against the supplier's cost now. A cost that rose without the price is the usual cause.
- A product given away, or sold under cost on promotion, shows here too. That may be deliberate.
Dispensary lines read low on margin, because a PBS script's government payment never reaches the till while its cost does. Read retail lines on their own for pricing.
Deadstock
Stock on hand that isn't selling, with its cost at each store, most surplus first. Unsold is nothing sold for some months, three unless you change it. Overstocked is more than some weeks of cover at the last year's pace. New arrivals are left out, so a product received recently isn't counted as dead.
A pharmacy keeps one unit of many slow lines on purpose, so the report leaves what Each store may keep (one unit by default) out of the surplus, and lists an overstocked product only when the units over are worth $50 or more, unless you change those.
- Read Surplus stock at the top: the cost tied up beyond what each store should hold.
- Work down from the top row. For each product, look it up in Products, which shows every store's stock and sales.
- If another store sells it, send it there or move it in Minfos.
- If nothing sells it, ask the supplier for a return. If it is short-dated, put it on clearance.
- Stop reordering it, or lower its reorder level in Minfos.
Write-offs
Clearance stock each store wrote off, by product, with the product's primary supplier. See Get clearance under control for what to do with it.
ORT claims
Every patient a store dispensed Buvidal or Sublocade to between two dates, listed once with their prescriber. The CSV is in the form the claim is filed with.
- Choose the store and the claim period.
- Mortar builds the report from the store's Minfos in the background. Leave the page open, or come back to it under Recent reports.
- Download the CSV and file the claim with it.
The report holds patients' details. A login sees only its own stores' reports, unless it reaches every store. Keep the CSV as you keep other patient records.
How to tell it's working
- Each month's Low-margin products list is shorter, or its shortfall smaller, than the last.
- Surplus stock on Deadstock falls from one quarter to the next.
- The same products don't top Write-offs month after month.
- Claims are filed on time, from the report, without searching Minfos by hand.