01Translate 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.
02Create 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.
03Control 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.
04Normalize 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.
05Calculate 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.
06Resolve 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.
07Settle 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.