Learn · Calculators

Liability estimator

A liability estimator values points that members have earned but not yet redeemed. Multiply active points by the marginal cost of fulfilling each point, then reduce for expected breakage where history supports it. Post the result as a monthly accrual so the balance sheet reflects the future cost of unclaimed rewards.

How it works

A loyalty liability estimator turns unredeemed point balances into a future cost. Begin with all points issued to members and still open, then subtract rewards already taken and points that expired under the programme terms. Multiply the remaining active points by the marginal outlay needed to satisfy one point. That outlay comes from the reward catalogue, such as dividing the actual cost of a voucher by the points required for it. If evidence shows some members will never claim their points, a separate breakage reduction can be applied to the gross amount, but only with a supportable historical basis. Update the estimate whenever point earning, redemption, or expiry activity changes the open balance. This gives the monthly accrual that belongs on the balance sheet.

Worked example

The arithmetic below is illustrative only. A scheme holds 1,500,000 open points at the end of May. Its catalogue lets a member swap 500 points for a 5 dollar coupon that costs the firm 3 dollars to provide. One point therefore costs 0.006 dollars. Supported breakage is 20 percent. The May liability equals 1,500,000 times 0.006 dollars times 0.80, giving 7,200 dollars. In June the open balance rises to 1,800,000 points and the cost per point stays the same, while breakage improves to 25 percent. The June liability becomes 1,800,000 times 0.006 dollars times 0.75, giving 8,100 dollars. The month over month increase is 900 dollars, which is the extra accrual to post.

What to do

First, pull a current report of each member point balance and total the open balance after excluding redeemed and expired entries. Second, split the catalogue into reward tiers and compute a fulfilment rate per point for each by dividing provider cost by required points. Third, obtain at least twelve months of redemption history to set a defensible non-redemption ratio, and record the reasoning for that choice. Fourth, calculate the period end obligation with the formula open balance times fulfilment rate times one minus non-redemption ratio. Fifth, enter a journal line to the loyalty liability account for the difference from the prior period, then repeat the process every month. This sequence keeps the liability aligned with member behaviour and reward cost changes.

Common mistakes

  • Believing that the liability equals the retail value of outstanding points leads to an overstated balance sheet and an incorrect expense.
  • Keeping points on the books after they have expired or been forfeited creates a liability for rewards the scheme will never provide.
  • Reducing the gross obligation by a breakage percentage with no historical redemption record produces an understated balance and a later correction.
  • Reviewing the estimate only once a fiscal year misses monthly swings in earning and redemption, leaving the liability account out of date.

Related