Skip to content
GullySales

Community halls · Pricing waterfall and discount leakage analysis

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

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.

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

Realistic editorial illustration of temples at work in India

Start with the buying decision

Which opportunities deserve the team’s effort?

Industry membership alone does not establish fit. The service exclusions, your operating model, and the records available determine the scope after your requirements brief.

Keep assistance and programme eligibility separate from fundraising or paid-service opportunities. The programme team decides access; sales targets and partner incentives must not determine who receives support.

The context for Community halls

Start with the decisions in your own enquiry records.

Compare the stated requirement with completed work and the effort needed to deliver it. Keep assumptions about demand separate from evidence in the records.

How people choose in this industry

Members of the trust or community get first claim and a lower rate. They ask the committee or the caretaker, and they trust a hall that their own people run. Outsiders choose by locality, capacity, parking, the price quoted and whether the hall allows their kind of function.

Residents' associations and companies book for meetings, training and festivals. They want a clear tariff, a deposit rule, sound limits and a bill they can pass on. A hall with no written rules gives them nothing to compare or to pass to their accounts team.

The decision before implementation

The owner approves segment priorities and commercial boundaries before the team changes its approach.

Existing industry priorities to review

  • Weekend bookings for family functions
  • Weekday bookings for classes and meetings
  • Festival and cultural evening bookings
  • Member concession bookings
  • Society and RWA annual meetings

These describe the industry's wider priorities. The written scope identifies which this service will address.

Industry application review

Test the service against a problem in your own records.

These review scenarios connect the industry context to a possible output and a checkable next step. They are scope questions, not client results or a promise that every industry problem belongs in this engagement.

The hall sits empty on weekdays

Classes, meetings and small gatherings could use it, but nobody outside the neighbourhood knows it is available.

Confirm the scope first

Check whether this issue belongs in the pricing waterfall and discount leakage analysis engagement or requires different work. The industry problem alone does not establish that this service will solve it.

What to bring

Bring a completed opportunity record, its requirement and outcome, and the assumptions used to prioritise it.

Proposed completion check

Record the scope decision and its reason. If the issue is outside this engagement, identify the responsible team or the separate work required.

Rates and rules live in the secretary's head

Each enquiry waits for the committee and the family hears three different prices from three people.

Confirm the scope first

Check whether this issue belongs in the pricing waterfall and discount leakage analysis engagement or requires different work. The industry problem alone does not establish that this service will solve it.

What to bring

Bring a completed opportunity record, its requirement and outcome, and the assumptions used to prioritise it.

Proposed completion check

Record the scope decision and its reason. If the issue is outside this engagement, identify the responsible team or the separate work required.

The problem

What pricing waterfall and discount leakage analysis is meant to address.

  • “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.

Who it is for

Check your operating model against the scope.

  • 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.

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

Agree the outputs before work begins.

These are the pricing waterfall and discount leakage analysis deliverables available for community halls. Your written scope identifies the included work and responsibilities.

  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.

Industry baseline

Keep the industry's wider measures beside the service measures.

Use the existing baseline to understand the context. These figures are not all targets for this engagement, and a change must not be attributed to the service without evidence.

  • Booking enquiries by source
  • Enquiries that become confirmed dates
  • Weekday days booked against weekday days empty
  • Member bookings against outsider bookings
  • Reply time to booking calls and messages
  • Deposit disputes raised after events

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.

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.

How it works

How pricing waterfall and discount leakage analysis 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.

Approval and acceptance

Use an observable check before accepting an output.

These are proposed review checks for the named outputs. Agree the final conditions in the written scope, then record any missing requirement before accepting the handover.

  • Waterfall definition note

    Trace the output back to the selected source record. The reviewer distinguishes confirmed information from assumptions and records any unmet requirement before accepting the handover.

  • Source data inventory

    Inspect a sample record against the original information. Check required fields, duplicate handling, the responsible owner, and who is permitted to access it.

  • Transaction-level waterfall workbook

    Trace the output back to the selected source record. The reviewer distinguishes confirmed information from assumptions and records any unmet requirement before accepting the handover.

  • Customer and product waterfall views

    Trace the output back to the selected source record. The reviewer distinguishes confirmed information from assumptions and records any unmet requirement before accepting the handover.

  • Concession approval trace

    Trace the output back to the selected source record. The reviewer distinguishes confirmed information from assumptions and records any unmet requirement before accepting the handover.

  • Leakage findings list

    Trace a finding to the supplied evidence. Separate observations from assumptions and identify the decision or action that follows from the finding.

  • Reconciliation to the ledger

    Trace the output back to the selected source record. The reviewer distinguishes confirmed information from assumptions and records any unmet requirement before accepting the handover.

  • Decision pack for the owner

    Trace the output back to the selected source record. The reviewer distinguishes confirmed information from assumptions and records any unmet requirement before accepting the handover.

FAQ

Questions owners ask before they call.

Not here? More answers, or ask on WhatsApp.

How is pricing waterfall and discount leakage analysis scoped for community halls?
Industry membership alone does not establish fit. The service exclusions, your operating model, and the records available determine the scope after your requirements brief. The owner approves segment priorities and commercial boundaries before the team changes its approach.
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.

Continue your review

Compare the service scope and the related work.

The scope, responsibilities, fee, reporting frequency, and term are agreed in writing after the requirements brief and conversation. Tell us what you need.

Your brief

Tell us what you need, and we will read it before we call.

Eight short steps about your business, what you want and who decides. Most questions are a tap, and you can skip any you would rather answer on the call.