Supplier Rebates and Claims: Getting Paid What You Have Already Earned

Anything a supplier owes you that is not a price on an invoice. The common types are volume and growth rebates earned on purchases, sell through or scan deals earned on units sold, promotional and co-op advertising funding, new store or new line allowances, price protection when a cost drops on stock you already hold, settlement discounts, and claims for shortages, damages and warranty recovery. They behave differently and need different data, which is why a single spreadsheet usually handles only the simplest ones well.

For a handful of straightforward volume rebates, you can, and we will tell you so rather than sell you a build. Spreadsheets break down in three specific places: when claims depend on sales line data at promotional prices, when tier progress needs to be visible before the period ends rather than after, and when supplier credits need matching back to individual claims. They also carry a person risk, because the knowledge of how each deal really works tends to live with whoever maintains the file.

Sales lines, not sales totals. You need the transaction date, the location, the item, the quantity, the price actually charged, and the ability to exclude staff sales, clearance and returns. In a multi channel retailer that means point of sale data and ecommerce data reconciled to the same item identifiers, which is often the real work. If your systems cannot produce that consistently, the honest first step is fixing the sales extract rather than building a claim engine on top of unreliable input.

That is a question for your accountant, and the answer shapes the whole design. The practical distinction is between treating rebates as other income, which keeps the posting simple and leaves product margins overstated, and treating them as a reduction in the cost of goods, which makes margin honest but requires the rebate to carry product or category detail and makes accruals more important. We build to the treatment your accountant confirms, and we make sure every claim follows it consistently.

It depends on what the payment is for. The Australian Taxation Office treats a rebate that reduces the price of goods you bought, such as a volume rebate or a settlement discount, as an adjustment to the original purchase: the supplier has a decreasing adjustment and generally needs an adjustment note to claim it, and you have an increasing adjustment. A payment for something you do for the supplier, such as co-op advertising, promotional activity or warehousing, is generally payment for a separate sale by you, so you issue a tax invoice to the supplier. Recipient created tax invoices are possible only where both parties are registered for GST, have a current written agreement and the supply is of a type the ATO allows. What causes problems is treating similar deals differently without recording which is which, so the register holds the settlement method and document type per deal, confirmed with your accountant.

Partly. Purchase based rebates only need receipted quantities in the ERP, so those work regardless. Shortage and damage claims are much weaker without a recorded receipt count, because the claim rests on the difference between what was advised and what arrived, and a ticked docket is not evidence. If shortage recovery is a significant part of the value, expect scanned receipting to be a prerequisite rather than a nice to have.

The register and the first accrual calculation are typically live in four to six weeks. Where there is value to recover, it tends to come from two sources: lapsed or unclaimed deals found during the initial review, which can be claimed immediately where the terms still allow it, and then the ongoing lift from claims that were previously abandoned as too hard. Be sceptical of anyone promising a percentage before they have seen your deal terms, because the value depends entirely on what you have negotiated and how much of it you are currently collecting.