How do I reconcile vendor rebates?
A vendor rebate reconciles when four numbers agree: what your agreements entitle you to (computed from your own purchase data), what you accrued as a receivable, what you claimed, and what you actually received in cash or credits. Most teams compare only the last two — which is why earned-but-never-claimed money doesn’t even appear as a discrepancy.
Run the four-way match monthly, per program; decompose every gap by cause; and age the claimable gaps against their submission windows, because an unreconciled vendor rebate has an expiry date.
The four columns
- Entitled. Qualifying purchases per program per period — from your purchase ledger, not the vendor’s statement — times the rate you expect to finish at. This column is the independent truth the other three are tested against; without it, reconciliation degenerates into “checking the vendor’s math with the vendor’s numbers.”
- Accrued. The receivable on your books, recognized as purchases occur at the expected rate — the mechanics and worked entries are on vendor rebate accounting under ASC 705-20. Entitled minus accrued should equal zero by construction; where it doesn’t, your accrual policy and your entitlement math have quietly diverged.
- Claimed. What was actually submitted, per line, with status. Entitled minus claimed is the unclaimed-rebate gap — the money that never even entered the pipeline.
- Received. Cash, credit memos, and deductions you took against payables — matched back to specific claims, not netted in bulk. Claimed minus received is the aging pipeline: pending, rejected-needs-resubmission, disputed, expired.
Decompose every gap by cause
The gaps between adjacent columns each have their own small set of causes, and naming them monthly is what keeps the reconciliation from becoming archaeology: rate-estimate differences (you accrued at 2%, the year finished at 4% — a true-up, not an error), entity aggregation misses, rejected lines sitting without a resubmission owner, and vendor settlements netted against disputed amounts. A gap explained by cause is a work item; an unexplained gap is a write-off waiting to be booked as “other.”
The inventory wrinkle buyers forget
Received rebates don’t just clear the receivable — they belong to the goods. The portion relating to inventory still on hand reduces inventory carrying value; the sold-through portion reduces cost of goods sold. A reconciliation that proves the cash arrived but never re-allocates the credit leaves margin misstated in both directions — the allocation mechanics are in the worked 705-20 entries.
Cadence and ownership
Monthly, per program, with one owner — the same discipline as the sell side, mirrored: entitlement computed as purchases land, claims tracked per line with their windows, rejections feeding a resubmission queue. Quarter-end then reviews an already-reconciled position instead of rebuilding one — the operational ledger view is under vendor rebate receivable, and the buyer-side platform treatment on vendor rebate management.