You funded the promotion. Do you know what you owe?
When your distributors run a promotion you paid for, the amount you owe each of them depends on how much of the promoted product left their warehouses, and which customers it reached.
That is their sell-out data. It reaches you every day, and Distributor Promotional Settlement recalculates every refund overnight, so you know what you owe on a promotion while it is still running.
Trusted globally by leading brands
The problem
The refund depends on sales you did not make
You agree a promotion, your distributors take it to their customers, and at the end of the period you owe each one a refund. Its size depends on how much of the promoted product left their warehouses, to which customers, at which discount. All of this is recorded in their systems.
So the calculation gets rebuilt by hand, once a month. Someone pulls invoices, promotion definitions and product hierarchies from three different places, then reconciles them with queries only one or two people in the company can write. Three things follow from that.
The cost arrives a month late
You learn the cost of a promotion once it is over. While it runs, nobody can answer “what have we spent so far?”
It sits in one person’s head
It takes someone who can write database queries and knows why the third discount on a corrected invoice behaves differently from the first. When that person is on holiday, the settlement waits.
A claim arrives as a surprise
A distributor writes in, disagrees with the amount, and the conversation starts from scratch: which invoices, which promotion, which correction.
A monthly settlement by hand and Distributor Promotional Settlement, side by side
| TodayMonthly settlement by handRebuilt from documents once the period closes | ||
|---|---|---|
| Who calculates it | The one or two people who can write the database queries | The module, every night, for the whole open period |
| What it is built on | Invoices, promotion definitions and product hierarchies pulled from three places | Distributor sell-out data in your own product and customer codes, through Trade Data Hub |
| When you know the cost | After the period closes, a month late | The next morning, while the promotion is still running |
| Several promotions on one line | Decided by hand, case by case | The highest discount pays, with a fixed order of precedence |
| When a distributor disagrees | The conversation starts from scratch | The amount traces back to the invoice line |
How it works
Your promotion definitions, your distributors’ sell-out data, the refund overnight
Distributor Promotional Settlement is a module of Trade Terms & Settlement. It works from two inputs: your promotion definitions, kept in the trade promotion system you already use or in Asseco Platform, and your distributors’ sell-out data, which comes in through Trade Data Hub. During implementation, each distributor’s system is connected, your products and customers are mapped, and the link to your finance system is set up.
The promotion
Promotions are defined once, centrally
Product scope, discount, period, who the promotion is for, and a ceiling price where the mechanic needs one. The definitions can come from the trade promotion system you already use, or be entered in Asseco Platform.
The sell-out
Sell-out data arrives daily through Trade Data Hub
Each distributor sends what left their warehouse, and Trade Data Hub maps it to your own product and customer codes. After a period closes there is a grace window, so invoices that arrive late still land in the right settlement.
The calculation
Refunds are recalculated overnight
Invoices are joined with their corrections and products are grouped under their common parent product, which is the level the promotion is written at. Prices are reduced by the standing discounts in your commercial terms, and the actual discount is compared with the threshold set in your commercial terms. Where it is higher, your terms decide what happens: the refund can be capped, held, or flagged for review. This runs every night, for the whole open period, so the cost of a promotion that is still running is known the next morning.
The payment
The payment document goes to finance
Once the settlement is verified and approved, the module prepares the payment document for your finance system, which then issues a credit note against the distributor’s purchase invoices. That is how the refund reaches the distributor.
Refunds by distributor
| Distributor | Main promotion type | Distributor sell-out value | Refund value | Refund % of sell-out |
|---|---|---|---|---|
| Distributor A | Distribution promotion | 1,840,000 | 58,900 | 3.2% |
| Distributor B | Campaign agreed with the customer | 1,210,000 | 41,200 | 3.4% |
| Distributor C | Distribution promotion | 960,000 | 30,700 | 3.2% |
| Distributor D | Local promotion | 720,000 | 19,400 | 2.7% |
| 10 more distributors | Various | 1,280,000 | 36,200 | 2.8% |
| Total | 6,010,000 | 186,400 | 3.1% |
What you owe distributors for July, recalculated every night while the period is still open. As of 15 July the refunds come to €186.4K, or 3.1% of the €6.01M these distributors resold, listed by distributor with the main promotion type.
What you can settle
Three kinds of promotion, settled the same way
Manufacturers run promotions in the indirect channel in more than one way, and each one is agreed by different people on a different timeline.
Whoever agrees them, all three are recorded as promotion definitions in one place and measured on the distributor’s sell-out data, so they settle the same way.
Campaigns agreed with the customer
Agreed with the customer during a visit and recorded as a promotional order, by your own sales rep or by the distributor’s, including through the distributor’s B2B portal.
Distribution promotions
Published to every distributor on the same terms, most often as a leaflet discount. Nobody negotiates them individually, which is the point: the market sees one offer, and the settlement reads one definition.
Local promotions
Agreed by the sales manager who owns the region, aimed at local retail groups or at wholesalers buying from the distributor, and executed by the distributor. The terms are set regionally and change from month to month.
The calculation
One invoice line can match several promotions at once. The module picks one and can show why
A single case of product on a single invoice can qualify under a campaign agreed with the customer, a distribution promotion and a local promotion at the same time. Somebody has to decide which one pays, and decide it the same way every month.
Every applicable definition is found
For each line on the invoice the module collects all promotion definitions that fit: the product, the customer, the date, the distributor. Nothing is chosen by hand, so a local promotion nobody remembered is still found.
The highest discount pays
Among the definitions that matched, the one with the highest discount is settled, and the refund is calculated at that discount on the eligible value, the part of the line the promotion covers. Where two carry the same discount, a fixed order of precedence decides. That order is set once in configuration and applies the same way everywhere.
Every amount traces back to an invoice line
Each refund can be followed from the payment document down to the invoice line, with the promotion that was applied. When a distributor asks why the amount is what it is, the answer is the record itself.
Before a settlement is approved
Four checks before a settlement is approved
These checks run on the calculation and on the data behind it, before a settlement goes to finance. Each of them protects both sides: a correct amount paid on time is worth more to a distributor than an amount they have to argue for.
Orders above the eligible limit
A promotional order above the limit set in the applied promotion’s definition is flagged before the settlement is calculated, while it can still be corrected.
Source data checked before it counts
Missing product hierarchy, a product not assigned to any of your business divisions, a definition entered with the wrong period, a correction that does not reconcile. This is where discounts activated in error are found: each of them shows up in the source data, early enough that the settlement does not have to be redone.
Distributor sell-out matched against purchases
The module compares what a distributor resold against what they bought from you in the same period. Where a distributor resold more than it bought, the module shows the gap together with the transactions behind it. The cause is often timing, or stock bought in an earlier period. Both figures sit in one place, so the two of you can check the period together before the settlement is approved.
The value of a claim before it arrives
On request, the module runs the settlement again on the most generous reading of the promotion terms, the one a distributor might claim, and lists the transactions where the two results differ. Where you agree the distributor is owed it, you can settle that difference as a correction while the period is still open, so the distributor does not have to file anything.
| Distributor | Promoted product | Bought from you (sell-in) | Resold (distributor sell-out) | Resold minus bought | Status |
|---|---|---|---|---|---|
| Distributor C | Biscuits 200 g | 9,000 | 12,000 | +3,000 | To check |
| Distributor F | Tomato passata 500 g | 4,200 | 5,000 | +800 | To check |
| Distributor A | Biscuits 200 g | 15,500 | 13,900 | −1,600 | OK |
| Distributor B | Orange juice 1 L | 6,800 | 6,100 | −700 | OK |
The resales and purchases check as the back office sees it. For each distributor and promoted product, the report sets what the distributor bought from you against what it resold. Distributor C resold 3,000 more units in July than it bought from you in July. The difference is often timing or stock from an earlier period, so your team checks it with the distributor before the settlement is approved.
Who reads it
Who reads it, and what they read for
The reports work twice. Before the settlement closes they are operational, because correcting a product hierarchy on Tuesday is cheaper than correcting a payment in three weeks. After it closes they are the audit record.
Back office
Runs the settlement, verifies it, approves it, and handles the exceptions. Instead of assembling the calculation by hand, the team reviews what the module flagged.
Sales controlling
Reads refunds against last year, refunds as a share of distributor sell-out, and how many distributors and products a promotion actually reached. Broken down by period, distributor, commercial terms, division and promotion type.
Regional sales manager
Sees the promotions they agreed themselves, limited to their own area: what has settled, what is still open, and which corrections have been issued.
Sales director
Sees where the channel budget is going: which promotion type is absorbing it, which distributors the money reaches, and how it compares with last year.
In use
Measured in our own FMCG manufacturer deployments
The module recalculates refunds every night for promotions run by a network of distributors, on their sell-out data.
One platform
One platform. Every moment in FMCG execution.
Distributor Promotional Settlement is a module of Trade Terms & Settlement, part of Asseco Platform, where data, planning, execution and settlement share one set of numbers.
Trade
Data Hub
See where your products really sell.
- See which stores actually stock your products, and which keep reordering them
- Right down to outlets you reach only indirectly, through distributors and wholesalers
- Across every route to market: distributors, chains, foodservice and online
Route-to-Market
Optimization
Decide where to invest sales effort and where to grow.
- See where you can grow most across stores, bars and restaurants, then send your reps there
- Find the stores and territories you’re not reaching yet
- Plan promotions where they’ll pay off, before you launch
Sales & Retail
Execution
Help your field reps sell more in every store they visit, with less admin.
- Plan visits and optimize routes: more selling, less driving
- Take orders and run every in-store task
- Hit your shelf standards with Perfect Store, scored live on every visit
- Guide each rep to the next best action (RAO)
- Keep teams sharp with built-in Motivation and Coaching
- Launch promotions and check they’re live in store
Retail
Image Recognition
Automated shelf audit from a photo.
- See what’s on shelf: facings, share of shelf, out-of-stock
- Check planogram and price compliance instantly
- Verify promotions and displays went up as agreed
- Get fix-it actions while the rep is still in the store
Trade Terms
& Settlement
Distributor Promotional Settlement works out what you owe distributors for the promotions they run, from their sell-out data. OTIF measures how they deliver, and Checkout-Based Promotional Settlement settles promotions in retail chains.
Explore Trade Terms & SettlementHow a settlement is calculated and checked
What happens to invoices that arrive after the period closes?
They can still be settled. Each period has a grace window for late documents, and a closed settlement can be recalculated on request, for example when a distributor reports sales late. Every settlement goes through the same verification and approval before it reaches finance.
A distributor disagrees with the amount. What do we show them?
The path from the payment document to the individual invoice line, with the promotion that was applied. Distributor Promotional Settlement also estimates what the distributor’s own claim would come to, so both sides look at the same transactions before anyone has to open a dispute.
How it fits with what you already run
Do our field teams have to work in your application?
No. Promotional orders placed in Mobile Touch, our field application, flow straight in, and where your teams use something else, order data comes in through an integration with that system. The module works from orders and sales documents, whatever application they were entered in.
Can it settle promotions run in retail chains as well?
Not in this module. Chain promotions settle on receipt data from the chain’s tills, which is what Checkout-Based Promotional Settlement reads. Contract conditions with a chain, such as volume thresholds and shelf commitments, are settled separately.
See how a refund is calculated, line by line
We will walk one promotion through Distributor Promotional Settlement on a worked example: from a distributor’s sell-out data to the amount owed, and the four checks that run before a settlement is approved. Bring the mechanics of a promotion you run, and we will show what the settlement would look like.
Book a demo Explore Trade Terms & Settlement