Skip to content
GullySales

FMCG distributors · Pricing waterfall and discount leakage analysis

The company price list is not what your warehouse actually earns on a case.

For an FMCG distributor, a pricing waterfall follows one case from the company's billing price down to what the warehouse keeps after retailer margin, schemes, free goods, returns, freight and credit. GullySales builds that trace outlet by outlet from your invoices, claim sheets and credit notes, and separates the cost the company reimburses from the cost you carry yourself.

Scope, fee, reporting and term are agreed in writing after we have read your brief and spoken to you.

FMCG distributors: show a real physical business scene illustrating Beat plans and outlet master. Group outlets into beats by day, record each outlet’s type, owner and phone, and see which shops were visited and which placed no order.

What pricing waterfall and discount leakage analysis means

A pricing waterfall traces each sale from list price down to the price your business actually keeps, step by step, by customer and product. GullySales builds that trace from your invoices and credit notes, shows where margin leaks, and records who approved each concession.

Last updated 14 Nov 2026.

For FMCG distributors

Where it usually goes wrong, and what we would do.

  • “Some of the leak is yours and some is the company's”

    A scheme funded by the company should come back as a claim, so it is not a loss. A scheme you extended on your own, or one you never claimed, is. Without a waterfall both look the same on the retailer's invoice. The first job is to colour every layer as claimable, claimed, or carried by you, so the owner sees the real margin and not the printed one.

  • “The largest outlet is not always the best one”

    A wholesaler who takes the biggest drops also asks for the deepest concession, the longest credit and the biggest share of free goods. Once those layers are stacked, a mid-sized counter that pays on the day can leave more in the till. Distributors rarely see this because the beat register ranks outlets by billing, not by what remained after every layer.

  • “Salespeople promise terms the invoice never shows”

    A sales officer agrees an extra case on a scheme to win an order, and the godown clerk bills it as a free good. The promise sits in a message, the stock goes out, and the claim to the company fails later because nothing in the file explains it. Tracing the approval for each large concession shows which ones were rules and which were favours.

  • “Damaged and expired returns hide inside credit notes”

    A credit note for a leaking carton or a short-dated pack looks like housekeeping. Joined to the outlet and the product, it shows which retailers send back the largest volume, which products expire on the shelf, and which returns the company refuses to take back. That cost lands on the distributor, and it only becomes visible when returns are a layer of the waterfall and not a footnote.

What we do

What we deliver for FMCG distributors.

The work available for this need. We agree the deliverables and responsibilities for your engagement in writing.

  1. Layer list for your territory

    A one-page list of every step between the company's billing price and the price kept: trade margin, invoice discount, cash discount, scheme, free goods, freight, returns and credit cost. Your accountant confirms each layer and the ledger it posts to.

    Result: Every layer has a name, a ledger and a person who can explain it.

  2. Outlet-level waterfall workbook

    An invoice-line sheet that steps each case down layer by layer to the realised price. It rolls up by outlet, route, salesperson, brand and company code, so the owner can read any slice of the beat.

    Result: You can open one outlet and read its realised price line by line.

  3. Claimable and carried split

    Each concession is marked as reimbursed by the company, reimbursable but not yet claimed, or carried by the distributor. Claim sheets are matched against what was actually given at the counter.

    Result: The unclaimed value is listed outlet by outlet, with the bill copies that support it.

  4. Approval trace for large concessions

    For every unusual free-goods issue or invoice discount, the order message, call note or signature that approved it, joined to the bill. Concessions with no trace are listed separately for the owner to review.

    Result: You can see which concessions followed a rule and which followed a phone call.

  5. Returns and expiry view

    Credit notes for damage, expiry and shortage are joined to outlet and product, with the company's stated return conditions beside them. The owner sees which returns the company accepts and which land on the warehouse.

    Result: A list of outlets and products where returns are carried by you, ranked by value.

  6. Leakage findings and decisions list

    Ranked patterns in plain words, each with the decision it raises: a scheme given twice, a freight allowance on a short drop, a credit period nobody approved. Nothing changes in your pricing until you choose.

    Result: Each finding names the records behind it and the person who decides.

How the result is measured

  • Gap between list price and realised price, by customer
  • Share of concessions with a recorded approval
  • Off-invoice value as against on-invoice value

Recorded as a baseline before work starts, so every later report has an honest comparison.

Who it is for

This is written for these FMCG distributors.

  • Distributors for packaged food, biscuits and snacks brands
  • Home and personal care distributors for soaps, detergents and toiletries
  • Beverage and bottled water distributors with chilled-outlet coverage
  • Staples and edible oil distributors serving wholesalers and kiranas
  • Dairy and ice cream distributors with cold-chain vehicles
  • Multi-brand FMCG distributors holding four or five company codes
  • Super stockists who supply sub-distributors in several towns
  • Modern trade and institution suppliers to supermarkets, canteens and hotels

Before you decide

Agree the work. Know how to judge it.

Pricing waterfall and discount leakage analysis for FMCG distributors: use these checks to prepare, choose the scope, and review what changes.

Bring the right evidence

Bring the current offer, delivery costs, and examples of discount requests or lost proposals. Separate a buyer who cannot afford the offer from one who does not understand what is included.

Make the scope clear

Agree which products or packages are being reviewed and who can approve price changes. Make assumptions about volume, delivery effort, and support visible in the model.

Check the work in use

Compare the proposed package with a real buyer requirement and the cost of fulfilling it. Check whether exclusions and optional work are understandable before testing a change.

Know when to change course

If a lower price creates more work than the business can support, revisit the scope. A higher conversion rate can still produce a worse commercial result.

These are discussion points, not a fixed package. GullySales confirms the deliverables, responsibilities, fee, and term in writing after reading your brief and speaking with you.

Before we start

What to have ready before the work starts.

The records, access and decisions this work needs from FMCG distributors. Anything missing is noted in the written scope, with who will supply it.

Invoice and credit note exports
The waterfall is built from what was billed and credited at the counter. An export from your billing package is enough. Without it, the work holds only the company's price list and cannot show what retailers paid.
Scheme circulars and claim sheets
Companies change schemes without much notice, and each has its own claim form. Share the circulars and the claims you filed. Without them, reimbursed and carried layers cannot be told apart and the margin is overstated.
Company settlement statements
These show what each company actually paid back. A summary for each company code is enough. Without them we cannot say whether a claim was short-paid, rejected or never filed, and the unclaimed figure stays a guess.
Beat and outlet list with owners
Outlets must be tied to routes and to the salesperson who serves them. A rough list is acceptable. Without it, leaks are found but cannot be linked to a route or a person for the owner to act on.
One accounts contact for questions
Old outlet codes, merged retailers and unclear credit notes need someone who knows the books. A named contact is enough. Without one, questions queue up and the reconciliation stalls.

How it works

How the pricing waterfall and discount leakage analysis work runs

The work itself, in order. How an engagement starts, from your brief to a written scope, is set out on our method page.

  1. 1

    Name the layers on your invoice

    You and your accountant list every concession your warehouse gives, from the retailer's margin to the free case. We note which company codes carry which schemes, because each company writes its own rules and a multi-brand distributor lives with several at once.

  2. 2

    Collect bills, claims and credit notes

    Accounts shares invoice exports, scheme claim sheets, credit notes and the company's own scheme circulars. We match retailer names, product codes and claim numbers that appear in different spellings in different files, and mark the layers that have no record at all.

  3. 3

    Step each case down the waterfall

    Every invoice line is taken from the company's billing price to the price the warehouse kept. Delivery cost and credit days are added where you share them, so the sheet shows margin on the beat as well as price on the bill.

  4. 4

    Split claimable from carried

    We read each scheme circular against what was billed, and mark the part the company reimburses, the part awaiting a claim and the part you carry. Your claims clerk checks the marking against the last settlement from each company.

  5. 5

    Trace the approvals and reconcile

    Large concessions are matched to the order message or approval that allowed them. Totals are then tied to your ledger and the company statements, and your accountant reviews every line that does not match before anything is presented.

  6. 6

    Read the result against the first figures

    You see the waterfall by outlet, route and brand beside the margin figures recorded before the work began. The ranked leaks and the decisions they raise are laid out for you to settle, and your pricing stays as it is until you choose otherwise.

Where this fits

Three pieces of sales work, in this order.

This work sits inside sales audit. Find where deals are being lost and what to fix first.

  1. Step 1 · you are here

    Sales audit

    Find where deals are being lost and what to fix first.

    Start here if you cannot say where orders are lost.

  2. Step 2

    Sales process design

    One written way to sell, from first enquiry to repeat order.

    Start here if every salesperson sells differently.

  3. Step 3

    Sales management

    A target, a review routine and someone who owns the number.

    Start here if the team has targets and no routine.

Tell us what you need Your brief is read before we call. Scope, fee and term in writing.

FAQ

Questions owners ask before they call.

Not here? More answers, or ask on WhatsApp.

What is a pricing waterfall for an FMCG distributor?
It is a line-by-line trace of one sale from the company's billing price to the amount the warehouse keeps. Each layer, such as retailer margin, scheme, free goods, return and credit cost, is shown in order. The owner reads where the money went for a single outlet, route or brand.
My margin is fixed by the company, so what is there to find?
The company sets your percentage, but what you pass to retailers and what you fail to claim back are your decisions. The waterfall shows which concessions you carried yourself and which were claimable. Those two lists are where a fixed margin actually shrinks.
Do you need access to my billing software?
No login is needed. An export of invoices and credit notes from your billing package is enough, along with claim sheets and company statements. If your package cannot export, a ledger extract and copies of the bills let us start, though that route takes more cleaning.
Will this tell me which retailers to drop?
It shows what each outlet leaves after every layer, and the owner decides what to do with that. Some outlets earn their place through reach or brand visibility the company values. The analysis gives the figures; the choice of outlets stays with you.
Can you recover the claims I never filed?
We list unfiled and short-paid claims with the bills that support them. Filing is done by your claims clerk, because the company accepts claims from the registered distributor only. Whether a late claim is accepted depends on that company's current rules, which you should check with them.
How is this different from discount rules or margin work?
Discount management writes limits going forward, and margin work changes how you buy and deliver. The waterfall comes first and measures what already happened. The rules are easier to write once the real layers are on one page.
How long is the contract?
The term is agreed in writing after we have spoken, along with the fee and the reporting. It is never a default twelve months, and renewal is decided on the numbers against the baseline recorded at the start.
How soon will we see results?
It depends on the trade, the channel and what is already in place. After we have read your brief and spoken to you, we say what we would expect to move first and how it will be measured against the baseline. Nothing here is guaranteed.
Who will actually do the work?
The person you speak to before anything starts. We work from one office in Nagarbhavi, Bengaluru, with no account managers in between.
What if we are not happy with the work?
Tell us and the plan changes. Everything is reported against the baseline, so a number that is not moving is visible to both sides. The term is in your written scope, and the refund and cancellation policy sets out the rest.

Your next practical step

Tell us what you are trying to grow, and we will read it before we call.

Eight short steps, mostly taps. Skip anything you would rather answer on the call.