MINJIBuyer resourcesAsk on WhatsApp

Rebate settlement control

Supplier rebate reconciliation template

A supplier rebate can be commercially agreed and still remain unreconciled because eligibility, returns, tier dates, currencies and settlement documents differ. The calculation needs a transaction trail both parties can reproduce.

Direct answer

The short version

Reconcile a supplier rebate by reading the signed agreement and fixing the exact program period, participating buyer and supplier entities, covered products, channels, locations and currency. Define the earning basis: ordered, invoiced, shipped, received, accepted, paid or sold quantity or value. These events are not interchangeable. Extract eligible line transactions with PO, invoice, credit, return and payment references. Remove taxes, freight, samples, canceled lines, excluded SKUs, non-qualifying affiliates and other items only where the agreement says so. Normalize units and currency using the agreed date and rate source. Net returns, credits and prior adjustments in the correct period. Apply thresholds, tiers, rates, caps and retroactive or incremental rules exactly as written; show the calculation by tier instead of multiplying the final percentage across every purchase. Compare buyer result, supplier statement and any accrued amount, then classify differences by missing transaction, event timing, eligibility, price, quantity, currency or rule interpretation. Obtain supplier confirmation and authorized buyer review. Settle through the agreed credit note, invoice allowance, cash payment or other document and allocate it to the correct account or inventory-cost treatment under qualified finance policy. Close when the source population, earned amount, settlement document and ledger posting agree, with disputed lines carried separately rather than hidden in one net number.

Use this before requesting a quotation

Reconcile what was earned, confirmed and actually settled

01

Translate the agreement into fields

Record program ID, parties, dates, products, channels, territories, currency, earning event, exclusions, threshold, tier method, rate, cap, claim process and settlement timing. Identify whether rates are incremental by band or retroactive once a threshold is reached. Do not infer a missing rule from last year’s spreadsheet or a supplier sales presentation.

02

Create the eligible transaction population

Extract the event named by the agreement with line-level PO, invoice, receipt, acceptance, payment, credit and return references. Keep the raw population and transformation logic. Confirm buyer and supplier legal entities, product mapping, pack units and program dates. A total from accounts payable cannot show whether excluded products or late returns were handled correctly.

03

Control exclusions and adjustments

Apply excluded SKUs, samples, freight, tax, tooling, canceled lines, non-participating locations and affiliate purchases only when documented. Net returns, shortages, price credits and other adjustments against the intended earning period. Flag late documents rather than silently shifting them. Preserve gross eligible activity, every exclusion and the resulting net basis.

04

Normalize units and currencies

Convert cases, inner packs and units through controlled product master data. Use the agreement’s currency, exchange-rate source and date convention; show original and converted amounts. Do not apply today’s rate to a historical program without authority. Round at the agreed level and record the difference between line rounding and period-total rounding.

05

Calculate thresholds and tiers

Show quantity or value entering each threshold, the applicable rate and earned amount. Test edge cases at boundaries, caps and minimums. Separate a retroactive rate from incremental band rates. If the agreement changes mid-period, calculate versions separately. Have an independent reviewer reproduce at least a sample from source lines before sending the claim.

06

Resolve the supplier variance

Compare buyer calculation, supplier report, prior accrual and settlement proposal. Classify each difference as population, eligibility, timing, unit, price, currency, tier, return, duplicate, prior settlement or interpretation. Exchange line evidence and preserve both positions. A supplier confirmation supports agreement but does not erase an unresolved buyer ledger or accounting error.

07

Settle and close the period

Record approved amount, credit note, invoice allowance, remittance or cash reference, date and currency. Allocate settlement to the authorized account and original transactions where policy requires. Reverse or update prior estimates through finance review. Close only after credit or cash is received and posted, with residual claims identified by amount, owner and next action.

Reusable buyer brief

Supplier rebate reconciliation record

Program ID, buyer/supplier entities and signed agreement:
Program period, earning event, claim date and settlement date:
Covered products, channels, locations and explicit exclusions:
Original currency, conversion currency, rate source and rate date:
Gross transaction quantity/value and source population:
Returns, credits, cancellations and other authorized deductions:
Net eligible basis, unit normalization and rounding method:
Threshold, tier type, rate, cap and calculation by band:
Buyer result, supplier result, accrual and total difference:
Difference category, affected lines, evidence and owner:
Confirmed credit note, allowance, cash or remittance reference:
Ledger treatment, residual dispute, approver and close date:

Fill only the details relevant to your request

Before you send the request

Questions buyers often ask

What purchases should be included in a supplier rebate

Use the agreement’s earning event, parties, products, dates and exclusions. Ordered, invoiced, received, paid and sold purchases can produce different populations.

How are tiered supplier rebates calculated

Apply the written threshold and tier method. Incremental tiers apply rates by band; a retroactive structure may apply a reached rate differently. Show each step and do not assume the method.

Should returns reduce a supplier rebate

Only as the agreement and applicable policy require. Link returns and credits to the correct product, event and period so late documents remain visible.

When is a rebate reconciliation complete

When both parties resolve or identify the source differences, the approved amount is documented, the credit or cash is received, and finance posts the authorized treatment.

Keep the request specific

Rebate accounting and tax treatment require qualified review

Whether a rebate adjusts inventory cost, cost of sales, another expense or income—and how tax is handled—depends on the arrangement, facts, accounting framework and jurisdiction. The sources below describe inventory and trade-document concepts; they do not decide MINJI or buyer accounting treatment.

Send this checklist on WhatsApp

Editorial method

How this guide was prepared

MINJI separates commercial eligibility, calculation, supplier confirmation and financial posting. IAS 2 supporting material confirms that discounts and rebates require accounting analysis; UNECE invoice standards provide line, range, allowance, charge and settlement structures.

Ready with the key details

Discuss a wholesale request

Send the product reference, estimated quantity and destination so the conversation starts with useful context.

Continue on WhatsApp