Reconciling points across partner transactions

Reconcile partner points in two passes: match eligible partner transactions to member awards, then match the contract's funding or settlement amounts to commercial records. Keep the results separate. A correct invoice does not prove every member received points; a correct member balance does not prove the invoice is right.

Agree what the partner sends

Specify which event earns points: an order, payment, fulfilment or another defined stage. Record the eligible amount, discounts and exclusions, currency, conversion and rounding rules, and the date that determines the earn rate. State when an award is pending and when it becomes spendable.

Each exchanged event needs a stable partner transaction reference, member reference, event type and time, eligible value and rule version. A refund or cancellation should refer to the original transaction. Where systems use different IDs, retain a controlled mapping; names or email addresses alone are unreliable join keys.

The published earning rule must match these records. Reconciliation can explain what posted, but it cannot correct an unclear promise made at purchase.

Key Elements of a Valid Partner Transaction Reference

Match awards in both directions

Start with eligible partner transactions and find their corresponding loyalty awards. Then start with partner-linked awards and find their source transactions. Investigate missing, duplicate, reversed and unmatched events. Keep the original award and a later reversal as separate movements so a partial refund remains traceable.

For example, under an agreed rule that awards points on eligible spend, a partial refund may require a corresponding partial reversal. Record it as a separate movement so the remaining award is traceable; the exact points depend on the programme's stated earning and reversal terms.

Note the reporting cut-off, time zone and agreed posting interval. A late event may belong to the next period. A manual credit should carry its reason and source case; it should not erase the original mismatch.

Reconcile the member balance correctly

For a member's complete points balance, use the applicable movements across all earning sources:

Opening points + awards − reversals − redemptions − valid expiries ± documented adjustments = closing points.

Show pending and spendable points separately. Where points from several partners enter one pooled balance, do not assign a later redemption or expiry to a particular earning partner unless the programme has an explicit allocation rule and records it. Reconcile each partner's issued and reversed awards to its source transactions without inventing a partner-specific closing balance.

A reward claim may differ from voucher use or fulfilment. If a claim fails, inspect the actual points and reward records before deciding whether value needs restoring under the terms.

Member Points Balance Reconciliation Formula

Match commercial settlement

Apply the agreement's funding rule to the eligible events or completed benefits that it specifies. Compare the resulting amount with invoices, credit notes and payments. Record the treatment of refunds, failed fulfilment and manual corrections. Point counts do not establish a universal cash value; tax, currency and financial reporting treatment need the relevant contract and finance assessment.

Close each discrepancy with a source ID, member impact, owner, correction and resolution date. Correct a member-facing error under the published rules without waiting for the next invoice. Review repeated mismatches by partner, outlet or event type to identify where the hand-off needs repair.

Commercial Settlement Reconciliation Checklist