How to reconcile a trade promotion to the deduction you received

A promotion reconciliation should answer: what did we agree to fund, and how was that obligation settled? Begin with the claim detail and the governing agreement, then trace the money. Matching a deduction to an invoice explains where cash was withheld. It does not, by itself, establish which promotion earned the charge.

This distinction also appears in Microsoft's documented trade allowance workflow: promotion contracts, claim review and approval, and matching customer short payments are separate steps. The workflow supports billbacks, lump sums and off-invoice events. Those are useful distinctions for a manual review, even when your own records live in a spreadsheet. [1]

Consider this fictional household-products brand. Agreement P-081 authorizes $1,200 of fixed event support for an August 1–14 promotion covering dish soap and surface cleaner at a specified retailer. Payment requires evidence that the agreed event ran. Invoice INV-204 totals $8,400. A later remittance applies $6,600 of cash and two claims billed August 28: $1,200 for promotion support and a separate $600 fee.

The bridge balances, but the review is unfinished. The $1,200 needs an agreement match and performance evidence. The $600 needs its own explanation. Do not increase P-081's cost merely to make the entire short payment fit one promotion. Equally, do not call the fee invalid solely because the promotion agreement does not explain it.

Use the claim's retailer, program reference, covered products and activity description to locate the approved agreement and amendments. Compare the amount, earning conditions and settlement method. A nearby agreement with a matching dollar value is only a candidate. Record why you selected P-081 and which evidence rules out another event.

Check the account's contractual documents together. For example, UNFI's published supplier terms say a mutually executed supplier agreement prevails where it conflicts with those terms; they also describe paying invoices net of applicable deductions and fees. That is a scoped example of why both governing terms and payment detail matter, not a rule establishing the validity of this fictional fee. [3]

August 28 is when the example claims were billed. August 1–14 is when P-081's activity had to occur. The later billing date does not by itself disqualify the promotion claim, and it does not make an August 28 event the correct match. Read the activity period in the backup and compare it with the earning window in the agreement. Check any separate claim-timing requirement independently.

Preserve order, shipment, invoice, event, claim and payment dates when available. Identify which one governs eligibility instead of choosing the closest date. Microsoft's documentation illustrates why this matters: a billback rule can use sales-order creation date as its calculation date and can specify a separate accumulation period. Your own agreement supplies the applicable basis. [1]

Build a crosswalk between your SKU, the trading partner's item number and the relevant GTIN or UPC. Include pack size and its effective dates. GS1 US distinguishes an each, generally the individual resale unit, from a case containing eaches and a mixed case containing multiple product types. A product description alone cannot tell you which quantity is being claimed. [2]

For example, 100 cases containing 12 bottles represent 1,200 bottles. Preserve both quantities and write the conversion explicitly. With a mixed case, split the contents by eligible SKU. Do not compare 100 cases with 100 consumer units or assume an old case pack still applies. If evidence measures consumer sales, shipment quantities alone do not establish those sales.

P-081 has fixed support, so quantities help verify product scope; they do not create a new per-unit charge. For a variable allowance, use the contract's eligible quantity and rate after normalization, then apply its caps or exclusions. Label any unsupported quantity as unknown rather than silently substituting a forecast.

Keep multiple evidence links for each claim: agreement for authorization, activity backup for performance, invoice for the receivable, and remittance for settlement. In the example, C-081 links to P-081, an event-performance record and the remittance containing INV-204. F-028 shares that remittance but requires a separate fee basis. One document can support several relationships without proving every part of the claim.

Add an allocated amount to each relationship involving money. If one claim spans two events, split only where the backup supports the allocation. If one promotion settles through several claims, total those claims against the agreement. A link is a navigation aid; the amount and explanation make it auditable.

Keep status and money separate: supported, awaiting evidence, disputed, credited and settled describe different outcomes. Record the owner, next action and any deadline verified for that account. Avoid closing a claim merely because someone approved a dispute or promised a credit; retain the eventual credit and its application.

Maintain separate fields for commitment, accrual and settlement. For this operating worksheet, commitment means approved support; accrual means the amount finance has recorded under its accounting policy; settlement means how an obligation was cleared. These fields describe the same lifecycle from different angles. Adding them together would overstate the promotion's cost.

If finance already recognized P-081's $1,200 cost, matching C-081 to that obligation does not create another $1,200 cost. Nor has the brand recovered $1,200 in cash: the original $6,600 receipt remains unchanged. A later reversal, credit or repayment needs its own record. Ask finance to determine the appropriate accounts and recognition period; this worksheet does not prescribe journal entries.

For a manual process, use three tabs: agreements, claim lines and payment applications. Give every row an identifier, attach evidence links and reconcile allocated totals. Finish P-081 with its $1,200 supported settlement, preserve the $600 fee's separate status, and carry unresolved items into the next review. The result is a traceable explanation of the promotion and the payment.