A rebate agreement may sit with sales, while its accrual sits with finance and its settlement arrives as a credit note. The ledger can contain the right amounts without showing which agreement changed the return on a customer account. Explaining the movement then means connecting records that weren’t designed to be read together.
This article focuses on price deductions. Buying costs, product mix, and fulfilment costs can also reduce distribution margins; keep those movements separate when assessing what changed in the price you retained.
Why Steady Sales Can Conceal Weaker Prices
Revenue combines selling prices and quantities. Selling more at a lower net price can keep turnover steady while reducing profit, if unit costs remain unchanged. To understand that movement, separate the price agreed at sale from any further concessions linked to the transaction.
List price and invoice price answer different questions
List price gives you a reference point. Invoice price shows what you charged after the adjustments included on the invoice. The difference may reflect a negotiated contract, an order discount, or an authorised override.
A lower invoice price isn’t automatically a problem. A customer may commit to dependable volumes or accept terms that reduce your costs. Compare the price with the agreement that applies to that customer and date. Measuring every sale against today’s list can make a valid historical contract look like an unauthorised discount.
Pocket price needs a clear definition
McKinsey’s explanation of transaction pricing looks beyond invoice prices to the discounts and incentives that affect what a business retains. For this analysis, pocket price means the invoice amount retained after further customer rebates, settlement discounts, and price allowances, excluding VAT. It’s a management measure: define which deductions it includes and apply that definition consistently. Revenue in the accounts may already reflect some of those adjustments, including estimates for amounts that haven’t settled.
Keep delivery expenses separate from price reductions. Waiving a delivery charge and absorbing a carrier invoice can both weaken profitability, but they aren’t the same accounting entry. A customer-profitability report can show both. Calling the combined result gross margin without explaining the cost treatment makes comparisons unreliable.
Where Price Deductions Become Hard To Trace
Commercial terms can affect different records at different times. The useful question is whether you can connect each adjustment to the customer, agreement, and sales that caused it. Four areas deserve attention.
Discounts agreed when the order is placed
A salesperson agrees a discount to win an order. Depending on the system and configuration, the sales record may retain the discount percentage, show a separate discount line, or contain only the final price.
The accounting entry alone may therefore tell you what the customer owes without explaining how the price was reached. Retain the applicable price, the adjustment, and its approval reference where that detail matters. That lets finance distinguish an agreed concession from a pricing error without reconstructing the quote history.
Customer rebates settled after the sale
A customer earns a rebate by meeting the terms of a volume or trade agreement. The entitlement may build over several months before settlement. Waiting for a credit note to investigate it leaves finance explaining an agreement long after the sales took place.
The IFRS Foundation’s IFRS 15 overview explains that variable consideration is estimated when determining the transaction price. For IFRS reporters, settlement therefore isn’t the only point to consider. Keep the agreement, qualifying sales, estimated entitlement, and amounts settled together, applying your reporting framework and accounting policy. When a credit note settles an amount already accrued, reconcile it to that accrual so the deduction appears once in your analysis.
Contract prices and manual overrides
A customer’s agreed price may remain unchanged when the general price list increases. That can be entirely consistent with the contract. It can also become a source of margin pressure if buying costs rise before the next price review.
Record which agreement set the price and when it should be reviewed. Separate a contractual price from a discretionary override. Otherwise, a report of sales below list combines two decisions with different owners and different remedies. Avoid counting the same difference as both an override and a line discount.
Settlement discounts and delivery concessions
An early-payment discount reduces the amount retained from a sale when the customer meets its terms. A delivery allowance or waived delivery charge can reduce the return further. The agreement may sit with sales, while finance sees its effect during payment allocation or through a later adjustment.
Assess what the concession achieves as well as what it costs. Faster payment may have value; an agreed delivery arrangement may help secure an account. Finance needs enough detail to assess that trade-off and identify when the terms have changed, expired, or been applied incorrectly.
A deduction can be commercially justified and still need a clearer place in your reporting.
What Your Margin Report Needs To Explain
Start with one customer whose sales have held up while profit has weakened. Use the same period and cost basis for both measures. Separate the effect of prices and deductions from changes in product mix, purchase costs, and the work needed to fulfil orders.
Connect the adjustment to the agreement
For each material deduction, keep its amount, category, customer, relevant period, and supporting reference. Include product or order detail where the agreement supports that level of allocation. An annual customer rebate may need an allocation method before it can sensibly appear in product-level reporting.
Choose categories that help someone act. A contractual rebate, a discretionary discount, and a correction for a billing error should be distinguishable. Agree who maintains those categories and reviews exceptions. That makes the report useful to sales and credit control as well as finance.
Reconcile the analysis to the ledger
Show which deductions already reduce recorded revenue, which remain accrued, and which appear elsewhere. Identify estimates and explain material differences between the management report and the accounts. A spreadsheet can support this work if its inputs, calculations, and reconciliation are controlled.
Investigate unexplained differences and adjustments counted twice. Check whether each credit note clears an existing accrual or records a new deduction. Keep the supporting calculation so another member of the team can follow the result.
How Sage Intacct Supports The Analysis
Sage Intacct offers pricing and reporting options that can support this work. The result depends on how transactions are entered, which applications you use, and whether the relevant detail reaches the accounts. Those choices should follow the questions your finance team needs to answer.
Keep the pricing reference clear
Sage’s Order Entry documentation describes price lists and price schedules, including assignments to customers and transaction definitions. These can provide a maintained reference for sales pricing. Your team still needs clear ownership of price changes, contract exceptions, and review dates.
Choose how discounts reach the accounts
Sage’s discount documentation distinguishes three approaches. Reducing the line-item price doesn’t separate the discount for reporting. A separate negative discount line, mapped to an appropriate account, allows the amount to be reported separately. For a subtotal discount, reporting depends on whether it is apportioned and how the accounts are mapped.
Sage also states that Advanced Revenue Management requires subtotal discounts to be apportioned. Check the approach against your subscriptions and transaction setup before promising a particular report. The same commercial discount can produce different reporting detail depending on how you enter it.
Use dimensions with suitable transaction detail
Sage documents standard and user-defined dimensions for organising and reporting on transactions. A custom category can help group deductions, provided your team can record it on the relevant entries. Agree how those entries will be created and coded. Adding a category won’t recover a discount amount already absorbed into a net price.
Rebate calculations also need an agreed process for determining entitlement, reviewing estimates, and linking settlements to accruals. Test the complete flow with representative agreements. A dimension classifies an amount; it doesn’t calculate what a customer has earned under a complex contract.
What To Test Before The Next Margin Review
Ask your team to demonstrate the following using a real customer agreement:
- Which price applied when the order was accepted, and why?
- Where is each discount recorded, and can its amount be identified separately?
- How do earned but unsettled rebates reach the report?
- Can you trace a deduction from the customer view to its agreement and ledger entry?
- Does the report count every adjustment once and explain differences from the accounts?
Make The Next Pricing Decision Easier
Choose one agreement to investigate before redesigning the whole reporting process. Establish what the customer receives, what the concession achieves, and whether the return still supports the terms. Then decide which information needs to be captured when the next order is entered.
That gives the next margin discussion a specific starting point: the agreement that changed, the sales it affected, and the decision needed. If your current setup makes that difficult, you can book a discovery session with us to discuss how Sage Intacct could support the reporting your team needs.
