Rebate Collections Reconciliation Agent
Reconciles supplier rebate and card-programme remittances to the rebates owed.
- Industry
- Procure AI
- Department
- Finance
- Team
- Accounting Operations
- Kind
- Investigator
- Approver
- Accounts Payable Lead
- Code
- FIN-19
It reconciles the remittance files suppliers and purchasing-card issuers send, volume rebates, early-payment discounts settled by credit, and card programme rebates, against the rebate receivables the contracts say are owed for each client and for the company. It allocates each receipt to a rebate agreement, client and period, separates short payments, netted deductions and disputed tiers, explains every receipt it cannot allocate, and posts the allocations so rebates can be passed through to clients. **The problem it solves:** Why a supplier's or card issuer's rebate remittance does not match the rebates owed: which receipts cannot be allocated and why, which tier was applied against the one earned, what was netted off against what the agreement allows, and how long each exception has been open.
How it works
6 steps, and a person signs off before step 6.
- 01Looks it up
Finds the record the request is about in the spend analytics warehouse: invoiced spend by client and supplier for each rebate period, the rebate agreements and tiers from the contract lifecycle management system, the rebate receivables, cash credited for each remittance and unallocated cash from earlier files..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Works it through
Weighs competing explanations against the evidence and shows which one holds up.
- 05Asks a person
Hands the work to Accounts Payable Lead with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the ERP's purchasing and accounts payable modules: it posts the allocations and approved write-offs to the rebate receivables, records deductions and disputes, and releases allocated rebates for pass-through to clients. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The rebate arrangements: which supplier or card issuer owes which rebate under which client contract, tier thresholds and rates, the remittance formats and cadence, netting and deduction rules, pass-through terms to clients and the escalation path for unallocated cash.
Reads from
the spend analytics warehouse: invoiced spend by client and supplier for each rebate period, the rebate agreements and tiers from the contract lifecycle management system, the rebate receivables, cash credited for each remittance and unallocated cash from earlier files.
Acts in
the ERP's purchasing and accounts payable modules: it posts the allocations and approved write-offs to the rebate receivables, records deductions and disputes, and releases allocated rebates for pass-through to clients.
Hands back
A list with one entry per collector and file, each with collector_name, file_reference, currency, gross_rebate, rebate_earned, deductions_claimed, deductions_agreed, net_remitted, cash_received, difference, reconciled (true or false), allocations (a list, each with agreement_reference, client_tenant, period, amount and basis), exceptions (a list, each with amount, exception_class (tier_dispute, unknown_agreement, wrong_reference, duplicate, short_payment, deduction_variance, missing_remittance or not_ours), evidence and days_open), unallocated_total and write_offs (a list).
Asks a person when
A supplier applied a lower tier than earned, a deduction is outside 0.5 percent, a receipt is classed as a duplicate or not ours, unallocated cash is older than 7 days, a write-off is at or above 50, or a remittance is missing.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Amount tolerance for an allocation (USD) | 1.0 | A receipt within this of a rebate receivable may be allocated to it and closed. |
| Recalculate the tier from spend | On | When on, every rebate is checked against the tier the client's invoiced spend with the supplier actually reached, not the tier the supplier applied. |
| Close a short-paid rebate under (USD) | 50 | A shortfall under this closes the receivable to write-off; anything more stays open and is chased. |
| Deduction variance tolerance (%) | 0.5 | A netted deduction outside the agreement by more than this is a variance against the arrangement. |
| Escalate unallocated cash after (days) | 7 | A receipt still unallocated this long after the file arrived is escalated. |
| A remittance is late after (days) | 15 | A rebate not remitted this long after the period's due date is reported as missing, with the amount expected. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Reconcile each remittance in three steps that must agree: gross rebate against the receivables for the agreement and period, deductions against the agreement, and net remitted against cash received in the bank.
- When on is true, recalculate the tier from the client's invoiced spend with the supplier in the period, and treat a lower tier applied by the supplier as a disputed shortfall.
- Allocate a receipt on agreement reference and client first, then on amount within 1.0; a receipt covering several clients must be split by each client's earned rebate.
- A shortfall under 50 closes to write-off; anything more stays open and is chased with the tier calculation attached.
- A deduction outside 0.5 percent of the agreement is a variance against the arrangement, not a cost to absorb.
- Hold every receipt that cannot be allocated as unallocated cash with its class, and never allocate it to the nearest agreement or pass it through to a client until it is allocated.
- A remittance not received 15 days after it is due is reported missing, and unallocated cash older than 7 days goes to the Accounts Payable Lead.
See the Rebate Collections Reconciliation Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.