Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Can We See Which Lines We Are Buying for More Than We Get Back?
Problems We Solve

How Can We See Which Lines We Are Buying for More Than We Get Back?

Pharmacy lines dispensed at a loss hide until the payment arrives. We compare what you paid per line with expected reimbursement and flag the gap early.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Lines bought above the price you expect to be reimbursed go unnoticed because the purchase price and the payment arrive months apart in different systems. We line up each line's purchase price from your invoices with the reimbursement price data you use, and list the lines where you are paying more than you expect to get back.

A good month for items, a bad month for margin

Item numbers are up. The payment arrives and the margin is thinner than it should be. Somewhere in the month, a set of lines cost more to buy than you received for dispensing them. Some were shortages bought at inflated prices. Some had price changes you did not spot.

Finding them means pulling invoices, looking up reimbursement prices line by line and comparing. Nobody has time for that, so the loss is absorbed and the same thing happens next month.

Why losses on individual lines stay hidden

The purchase price is on a wholesaler invoice, possibly several. The reimbursement price is in published tariff data that changes monthly, and some lines have price adjustments announced later. Your dispensing volume per line is in the PMR. Those three sources rarely meet.

The gap also moves. A line that is fine in March can be loss-making in April, and back to normal in June.

When the market is short on a line, the decision to buy at a high price is made at the order cut-off by whoever is on shift, with a patient waiting. That is the right call for the patient, but nobody records it, so nobody later checks whether anything could be done about the price paid or how the item was recorded.

What you cannot see is costing you

Blind spotConsequence
No per-line margin viewLosses on a few lines hide inside the total
Late discoveryYou find out after the purchase decisions are made
Purchasing habitYou keep buying from the same supplier at a higher price
Endorsing detail missedInformation that affects payment may not be recorded

We do not advise on reimbursement or what you are entitled to. That is for you and your accountant or adviser. We make the numbers visible.

A line-by-line margin view

  1. Purchase prices captured from electronic invoices from each wholesaler, per line and per pack.
  2. Reference prices loaded from the published price data you work with, refreshed each month, plus any adjustments you record.
  3. Volumes from your PMR's dispensing reports.
  4. A margin table per line: what you paid, the reference price, the difference and how many packs were involved.
  5. A watch list of lines where the difference is negative or close to it, updated as new invoices arrive, not only at month end.
  6. Supplier comparison for each watch list line, from the prices you have actually paid each supplier.

This works best alongside the invoice checking and endorsement tools, but it can be built on its own.

Buying with the numbers in front of you

When a line goes on the watch list, you see it while there is still time to change supplier, adjust ordering or make sure your records are complete. The monthly view shows where margin went rather than just that it went.

It also helps the conversation with your accountant. Instead of a general feeling that margins are squeezed, you can show which lines, which months and which suppliers. That is a much better starting point for decisions about buying groups, supplier terms or which lines to hold less of.

And the person at the ordering screen gets a simple signal. Lines on the watch list are marked, so whoever places the order knows to check the alternatives before accepting the first price on offer.

Is margin leaking line by line?

  • Your margin varies month to month and you cannot explain why
  • You buy short lines at whatever price is available
  • Nobody compares purchase price with reimbursement per line
  • Price information lives in invoices nobody reads
  • You find out about loss-making lines months later

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does this tell us what we should be paid?

No. It compares your purchase prices with the reference data you use. Interpretation is for you and your adviser.

Where does the reference price data come from?

From the published sources you already rely on. We load them in a structured way each month.

Do we need to change wholesalers?

No. The tool shows where prices differ. What you do about it is your decision.

Can it cover several branches?

Yes, with each branch's purchases and volumes kept separate and rolled up.

Keep reading

More on Problems We Solve

Start here

Tell us how you track purchase prices

Describe your wholesalers, your invoices and how you look at margin today. We will tell you what can be matched and what needs your accountant.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →