Most Polish SMEs in distribution, wholesale, or assembly from supplier-provided materials take part in some kind of rebate program. Few of them actually know how much that program is worth or whether all the rebates ever come back. The money stays with the supplier because no one asks for it in time.
The mechanism is simple on paper and hard to track in practice. A manufacturer or a large distributor grants a retro rebate — a percentage of purchases, by brand, by category, sometimes on specific promo products. Thresholds are quarterly or annual. The corrective invoice, a credit note, or a settlement comes after the period closes — sometimes with a weeks-long delay, sometimes only after a reminder, sometimes not at all. In a 20–30-person company, responsibility is spread thin between accounting ("not my problem until the invoice arrives"), purchasing ("I had it in my head, but it slipped out"), and sales ("those are purchasing's numbers, not mine"). The net effect: no one owns the whole picture.
Across the projects where we helped tidy this up, the same figure kept coming back: 1 to 2% of annual purchase turnover disappears somewhere along the way. Not because the supplier is cheating — it's usually just the other party that won't issue a correction until someone asks. For a company with PLN 15 M of purchases a year, that's PLN 150–300 k left on the other side, uncollected, simply because nobody counted.
Why Excel isn't enough
The first reflex is always the same: "let's build a spreadsheet". One person builds it, keeps it alive for three months, then leaves the company or the spreadsheet. The sheet stays frozen in last year's state and nobody is sure whether it still means anything.
The problem is deeper than discipline. The sheet doesn't know what the company bought last month. You have to retype that from the ERP. It doesn't know what belongs to a given rebate category — because the supplier's rebate category doesn't match your product groups one-to-one. It doesn't know the supplier just moved the threshold from 500 k to 600 k PLN for the second quarter. It won't remind you a settlement window is closing. And it won't remember that the Q3 credit note should have arrived by October 20th, and today is November 10th.
In practice the sheet works as long as one person holds it in their head. The moment that person goes on vacation or leaves — it's gone.
What has to live in the ERP
The right place for retro rebates is your ERP system (Comarch Optima, Microsoft Dynamics AX/365, enova365, Subiekt — the principle is the same), because that's where the raw data already lives: purchase invoices, product groups, suppliers. You need to add three things that typically aren't there.
- A rebate program dictionary — one record per program (supplier × period × category). It holds thresholds, rates, the settlement form (correction, note, offset), and the deadline counted from the end of the period.
- A mapping between your products and the supplier's rebate categories — because their "professional power tools" aren't always your product group. The mapping is a living thing: new products arrive, items change categories, seasonal promotions enter.
- An automated real-time exposure calculation — a report that, for each active program, shows how much you've bought so far, how much is left to the threshold, and the expected rebate value under the "no further purchases" and "based on the current run rate" scenarios. Mailed to the buyer and the CFO weekly.
This does not require replacing the ERP. In most systems a simple extra table plus a SQL view or a BI report is enough. In Comarch Optima we've built it a few times as a SQL view plus a Crystal Reports layout. In Microsoft Dynamics AX — as a small form with its own logic in X++. The cost usually lands between a few and a dozen days of work and pays back within the first quarter.
A real example — an electrical wholesaler
We worked with a 25-person electrical wholesaler near Poznań. Comarch Optima as the ERP, around PLN 22 M of yearly purchases, seven key suppliers (two lighting manufacturers, two cable, one components, one accessories, and three smaller brands under a category umbrella). Each of the larger ones ran its own rebate program — quarterly or annual — with thresholds from PLN 300 k to PLN 1.2 M and rates from 1.5% to 5% depending on category and volume.
Before the project, rebate calculations were done by one person from purchasing, in Excel, once per quarter — usually already past the deadline for submitting the breakdown. Reviewing two previous years we found that:
- Three times nobody asked for the rebate — the manufacturer hadn't issued a correction because the company hadn't sent in the breakdown; total value ~PLN 86 k gone.
- Twice the company missed a threshold by 2–4%, unaware of it — had someone known mid-quarter, they'd have added an order that was needed anyway; lost rebate ~PLN 41 k.
- In one program the Excel calculation was understated by PLN 11 k because two SKUs were put in the wrong category. The manufacturer paid what the company calculated.
After adding a program dictionary, category mapping, and the weekly report to Optima, the first full year brought back ~PLN 210 k that previously just wasn't returning. Implementation cost was 7 days of our work plus a few hours of internal time for mapping configuration. The project paid back before the end of the second quarter.
Not every company will see these numbers — it depends on the specific rebate programs with specific manufacturers. But in our experience no project has ever returned less than four times its cost in the first year. Usually much more.
When is it most worth doing
There are three situations where cleaning up the rebate area pays back fastest.
- Turnover in purchasing. A change of the person running supplier relationships is the classic moment when rebate knowledge evaporates. If you're planning a purchasing change in the next few months — do this first.
- Negotiating terms. When you go back to a supplier for better conditions, a concrete report showing you did PLN 2.3 M in their category last year is an entirely different conversation from "we buy quite a bit from you".
- A conversation with the bank. For a working-capital line or factoring, a documented stream of supplier rebates is a very concrete piece of the picture — it's "non-working" income on your turnover and genuinely shifts the ratios.
What next
If today you can't produce, in ten minutes, a number showing how much the company is expecting in rebates for the current quarter from your five biggest suppliers — you're probably leaving money with them. Not because they're dishonest, but because the other side won't remind you on its own.
Start with a list of active rebate programs on a piece of A4 paper. For each — threshold, rate, period, settlement deadline. If the list runs longer than five items, Excel is a trap you're walking into yourself. If you want us to go through it with you and calculate what's actually recoverable within a year — the first call is free and takes half an hour.
A retro rebate is a form of credit you extend to your supplier. Too many Polish SMEs extend it for free.