Skip to content
GullySales

Pricing waterfall and discount leakage analysis · Sales

Your list price looks healthy, but nobody can say what a customer really pays.

Your price list says one number. The invoice says a lower one. After a rebate, a free-goods scheme, a freight allowance and a long credit period, the money you actually keep is lower again. Few owners have ever seen those layers added up for one customer.

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

Colleagues calculate prices and discounts beside product samples

In one paragraph

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.

A pricing waterfall lays the layers out in order, from list price to the realised price, line by line. Each layer is a separate concession with its own owner and its own paperwork. The analysis shows which layers are large, which were never approved, and which customers carry them.

This service finds and measures the leak. Sales discount management writes the discount rules going forward, and pricing and packaging strategy sets the prices themselves. Owners start here, because the rules and prices are easier to settle once the real picture is on one page.

Who it is for

This is written for you if these sound familiar.

  • Distributors and manufacturers who pay schemes, rebates and free goods outside the invoice
  • Owners whose gross margin report looks fine while cash in hand feels thin
  • Sales heads who suspect a few large customers get terms nobody remembers agreeing
  • Service firms and showrooms whose quotes drift down between first offer and final bill
  • Finance leads who hold the credit notes but have never joined them to the customer and the salesperson

Before you decide

When this may not be the right fit.

  • You want new prices or a new package structure built first. Start with pricing and packaging strategy.
  • You want discount limits and approval rules written. Sales discount management is the direct service for that.
  • You want a promise that margin will rise after the analysis. The work shows the leak; what you change is your decision.

The problem

Does this sound like your business?

Common situations this work addresses.

  • “Our invoices look fine but the margin is not there”

    The invoice carries only part of the concession. Rebates, schemes and credit notes arrive later and sit in other ledgers, so the margin report never reflects them.

  • “Two customers buy the same product at very different real prices”

    The list price is the same for both. One of them also has a rebate, a longer credit period and free goods, and the other does not.

  • “I do not know who agreed that rate”

    A rate appears on an invoice and nobody can find the email, the call note or the signature behind it. The concession has no owner, so it repeats.

  • “Our best customers may be our least profitable”

    The largest accounts negotiate hardest and cost the most to serve. Revenue ranks them first, and the full waterfall may rank them last.

Choose the right scope

Start with the work your business needs.

  1. Distributor and dealer waterfall

    For a trade where schemes, rebates and free goods are paid after the invoice. The work joins scheme claims and credit notes to the original sale, so each dealer shows a realised price rather than a billed one.

  2. Key customer waterfall

    For an owner who negotiates annually with a handful of large buyers. Each customer gets one page that shows every concession given, in order, with the approval behind it.

  3. Product group margin trace

    For a business that sells several product lines and suspects some are carried by others. The workbook shows which product groups lose the most between list price and the amount kept.

  4. Quote-to-invoice drift review

    For a service firm, clinic or showroom where the final bill sits below the first quote. The review compares quotes, revisions and invoices to show where the price moved and who moved it.

  5. Credit term cost view

    For a seller who gives long payment periods to win orders. The view puts the cost of waiting for payment into the waterfall beside the discounts.

What we do

The work we can include.

Each deliverable and the purpose it serves. Your written scope confirms what is included, who is responsible, and what it costs.

  1. Waterfall definition note

    A one-page list of every layer between list price and realised price in your business: trade discount, invoice discount, volume rebate, scheme, free goods, early-payment discount, freight allowance, returns and credit terms. Your finance lead confirms each layer and the ledger it sits in.

  2. Source data inventory

    A record of where each layer lives: invoices, credit notes, scheme claim sheets, rebate accruals, delivery records and the quote file. It also marks the layers with no record at all, which are findings in themselves.

  3. Transaction-level waterfall workbook

    An invoice-line sheet that starts at the list price and subtracts each layer in order, ending at the realised price per line. It rolls up by customer, product group, salesperson and region.

  4. Customer and product waterfall views

    A one-page waterfall for each selected customer and each product group, drawn from the workbook. The owner reads the leak in the sequence it happened.

  5. Concession approval trace

    For every large or unusual concession, the quote, the message or the signature that approved it, matched to the invoice. Concessions with no trace are listed apart from those with one.

  6. Leakage findings list

    Ranked patterns in plain words: a rebate paid on volume the customer would have bought anyway, a scheme claimed twice, a freight allowance given on small orders, a credit period longer than the agreement says.

  7. Reconciliation to the ledger

    A check that the waterfall total matches the sales and credit note totals in your accounts, with differences explained. Your accountant signs off the match.

  8. Decision pack for the owner

    The findings, the questions each one raises, and which neighbouring service would act on it. GullySales presents options; you decide what to change.

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
  • Margin after all layers, by customer and product group
  • Credit notes and scheme payouts matched to an original quote

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

Marketing and sales together

Your sales team sees what each concession cost before the next negotiation.

The waterfall for each customer goes to the sales head and the account owner before the next price conversation. They see the real price each customer pays today, what was given and when. Findings that call for rules pass to sales discount management; findings about price levels pass to pricing and packaging strategy. Each is a separate scope.

Decisions to make before the work starts

  1. Your records

    The analysis is only as complete as the invoices, credit notes and scheme sheets you share. Missing records are listed, not guessed.

  2. Accounting and tax

    GullySales does not give accounting or tax advice. Ledger treatment, invoice wording and credit note rules go to your own accountant or tax adviser.

  3. Legal agreements

    A dealer agreement or rebate contract that needs a legal view goes to your own legal adviser. We read the agreement for the terms it records, not for its enforceability.

  4. Neighbouring work

    Discount rules, price lists, approval routes and negotiation training are separate scopes. They are linked from this page and are not included in it.

This or a nearby service

Which piece of work fits your situation.

These services sit close to each other. The line between them, in plain words.

Sales discount management
Choose sales discount management when you need rules on who may give what concession and a register of discounts going forward. Choose pricing waterfall and discount leakage analysis when you first need to see what customers actually paid after every concession on past invoices.
Sales margin improvement
Choose sales margin improvement when you want selling rules your team follows, written after reading quotations, invoices and payment records. Choose pricing waterfall and discount leakage analysis when the question is narrower: how each sale falls from list price to the price you keep, and who approved each step.
Sales profitability analysis
Choose sales profitability analysis when you want to know which products, customers and regions leave profit after the cost of serving them. Choose pricing waterfall and discount leakage analysis when each sale must be traced layer by layer from list price, with every concession and approval visible.

A sample of the output

A waterfall layer sheet lists each step between list price and the price kept.

This sheet is for a distributor of electrical goods. Each row is one layer between list price and the price kept, with the record that proves it and the person who approved it.

Illustrative example, not client data. Yours is built from your own records.
LayerWhat it takes offWhere the record livesWho approved it
List priceNothing; the starting point for the itemPrice list held by the sales officeSet by the owner
Quotation discountThe reduction agreed in the quotationQuotation registerSales manager, named on the quotation
Invoice adjustmentPrice changes made when the invoice was raisedInvoice copiesNo approval found in several cases
Rebate or scheme creditMoney returned to a dealer after the saleCredit notes and scheme fileNamed in the scheme approval
Payment-term costThe cost of credit allowed to the customerLedger and payment recordsTerms agreed by the account holder
Price keptWhat remains after every layerReconciled to the ledgerNot applicable

Before we start

What we need from you.

The work depends on these. Each says why it is needed and what happens when it is missing.

Invoice and credit note exports
The waterfall is traced from what was actually billed and credited, line by line. An export from your accounts package is enough. Without it, the work has only list prices and cannot show what customers paid.
Quotations with their approvals
To see who approved each concession, the analysis needs the quotations and any approval messages. Scattered files are acceptable. Without them, leakage is found but cannot be linked to a decision or a person.
Scheme and rebate agreements
Dealer schemes, volume rebates and special terms change the price after the invoice. Share the agreements or summaries held by your team. Without them, those layers are guessed and the price kept is overstated.
A ledger extract for reconciliation
Totals in the waterfall must agree with your accounts or the findings cannot be relied on. A summary extract for the same records is enough. Without it, differences cannot be explained.
One finance contact for questions
Odd entries, old customer codes and unclear credits need someone who knows the records. A named contact is enough. Without one, questions queue up and the clean-up of records stalls.

How it works

How the 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

    Agree the layers and the scope

    You and your finance lead name every concession your business gives. We choose which customers, products and periods to trace first, so the first pass is manageable.

  2. 2

    Collect and clean the records

    Accounts shares invoices, credit notes, scheme sheets and rebate accruals. We match customer names, product codes and credit notes that carry different spellings in different files.

  3. 3

    Build the waterfall

    Each invoice line is stepped down from list price to realised price, layer by layer. Costs you share, such as cost of goods and delivery, are added to show margin as well as price.

  4. 4

    Trace the approvals

    For large concessions we look for the request and the decision. The result separates concessions that followed a rule from those that followed a phone call.

  5. 5

    Reconcile and test

    The totals are checked against your ledgers. Your accountant reviews the match, and we correct any line that does not tie.

  6. 6

    Present findings and options

    You see the waterfall per customer and product, the ranked leaks and the decisions they raise. Nothing is changed in your pricing until you choose to.

Before you hire anyone

Do this first yourself.

Pick one customer and one product and follow a single sale from list price to the money you kept.

  1. Write down the list price of one product and the customer you sold it to.
  2. Find the invoice and note every reduction shown on it.
  3. Search your credit notes, scheme sheets and rebate accruals for the same customer and product.
  4. Add the payment terms you gave and how long the customer took to pay.
  5. Subtract everything from the list price and compare the result with the price you thought you got.

Judge any provider

What to ask any provider of this service.

Useful whoever you choose, including us.

  • Which layers between list price and realised price will you trace, and who confirms each one?
  • How will you match credit notes and scheme claims to the original sale?
  • What will you do where a record is missing?
  • How will the waterfall be reconciled to our ledgers, and who signs off the match?
  • Will you set prices or limits, or only show what happened?

Where this fits

Three pieces of sales work, in this order.

This work sits inside sales process design, at stage 0, foundation. The audit comes before it, and sales management keeps it running.

  1. Step 1

    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 · you are here

    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.

Industry applications

Pricing waterfall and discount leakage analysis needs the context of your industry.

Choose your industry to review its buying journey alongside the service scope, deliverables, responsibilities, and measurement. Specialist programmes explain their limits when the operating model does not match.

1,231 industries available.

Healthcare (103)
Manufacturing (198)
Professional services (79)
Retail (109)
Hospitality (68)
Real estate and construction (80)
Financial services (38)
Education (66)
Home services (67)
Automotive (52)
Wellness (52)
Non-profit (42)
Technology (53)
Logistics (40)
Other (184)

FAQ

Questions owners ask before they call.

Not here? More answers, or ask on WhatsApp.

What is the difference between invoice price and realised price?
The invoice price is what the bill shows. The realised price also removes rebates, schemes, free goods, early-payment discounts, freight allowances and similar items paid after billing. The waterfall shows both.
Will you set our discount limits or prices?
No. This service measures what happened. Sales discount management writes the limits, and pricing and packaging strategy sets prices. You choose which of those to take up.
What if our records are in several files and spellings?
That is the normal starting point. Matching customer names, product codes and credit notes is part of the work, and gaps in the records are reported as findings.
Do we need special software?
No. The waterfall is built in a spreadsheet from your own exports. If you later keep this view in your accounting system or CRM, the workbook shows what to capture.
How is a rebate or discount treated for tax?
The treatment depends on how and when it is agreed and documented, and the rules change. Check with your own tax adviser before changing invoice or credit note wording.
What does it cost and how long does it take?
Scope, fee and term are set in writing after your requirements brief and a first conversation. No figure or duration is quoted before that.

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.