Syntha Lab RU

Bonus points liability and breakage

From points issued, redeemed and expired calculates the points balance, the obligation to members at face value, the historical breakage of a closed cohort, the reserve allowing for expected breakage, the cost of the program in revenue and the addition to the reserve already created.

CRM and the customer base: retention, segments, win-back For whom: Finance directors, chief accountants and heads of CRM and loyalty when assessing a bonus program.

Calculate on your data →

At a glance

What question does it answer?
How much the brand owes members in points, what part will expire and how much reserve to hold.
What data is needed?
Points at the start, issued, redeemed and expired in the period.
How to read the result?
On the default data the points balance at period end is 9,800,000, the obligation at face value is 9,800,000. The historical breakage of the cohort is 34.0%: the reserve allowing for expected breakage is 6,468,000. In the period 6,500,000 points were issued, 60.0% of issued were redeemed, 27.7% expired. The cost of the program in revenue is 3.3%. With a reserve of 6,000,000 already created, 468,000 is to be added. An error of 5 pp in breakage moves the reserve by 490,000. Example on the default values: Points at the end of the period: 9,800,000; Obligation at face value: RUB 9.8 million; Historical breakage (cohort): 34%; Reserve allowing for expected breakage: RUB 6.47 million. The figures are illustrative: enter your own to see your result.

Why and how to reason

Loyalty points are a promise: the customer has accumulated them, and at some point the brand has to accept them as payment. While points have neither expired nor been redeemed, they are a debt, and it needs to be shown in the valuation. The point balance equals opening plus issued minus redeemed minus expired: 9.0 + 6.5 − 3.9 − 1.8 = 9.8 million. The liability at face value at RUB 1 a point is 9.8 million. But not all points will be used: in a closed cohort 34% expired (1.7 of 5.0 million). So the provision is taken with an adjustment: 9.8 × 0.66 = 6.47 million. 6.0 million has already been created, so 468 thousand needs to be added. The cost of the program in revenue is computed on issued points with expiry: 6.5 × 0.66 = 4.29 million, which is 3.3% of revenue of 130 million.

When to use it

It comes in handy when closing a period, reviewing program rules (point lifetime, rate) and assessing its cost. It does not replace accounting policy or the accountant’s decision: the way liabilities are recognized is set by standards, check it against the current text. Assumptions: the historical expiry share of a closed cohort will persist, the cost of redemption is known, the cohort is representative. It is needed by marketing too: it shows what each percent of program generosity costs and how its point lifetime lowers the price.

How to read the result

Look at the liability at face value (9.8 million) and at the provision with expiry (6.5 million): the difference is your assumed expiry effect, and it is itself a risk. Sensitivity shows: each 5 points of expiry change the liability by 490 thousand. If “Redeemed to issued” is 60% and “Expired” 28%, the program is working, but the expiry share is below the historical one, so check whether rules have changed. Compare the program cost of 3.3% of revenue with the effect of loyalty: purchase frequency and average basket. Decision: if the liability grows faster than revenue, tighten the point lifetime or limit payment by points, but first assess the reaction of customers.

Common mistakes

Typical trap: computing the liability without an expiry adjustment or, conversely, understating it too much, taking the cost of redemption not from facts, not updating the cohort, mixing points of different programs. For the cohort use only a closed one whose point lifetime has passed. Do not count expired points as clean profit: customers notice expiry, and it affects loyalty.

What data is needed?

  • Points at the start, issued, redeemed and expired in the period.
  • A closed cohort: issued, redeemed, expired; the breakage is calculated from it.
  • The point value, the redemption cost share and optionally revenue and the reserve created.

Inputs

FieldUnitValue in the exampleMeaning
Points at the start of the periodpoints9,000,000The balance of points of all members at the start of the period from the loyalty program records. The example value is illustrative.
Issued in the periodpoints6,500,000All accruals in the period: for purchases, promotions, welcome points.
Redeemed in the periodpoints3,900,000Points spent by members on payment or rewards.
Expired in the periodpoints1,800,000Points whose validity period has ended.
Value of one point₽1The face value of a point in money on redemption: 1 point = 1 or otherwise under the program rules. The example value is illustrative.
Share of face value that redemption costs%100If points are redeemed as a discount, redemption costs 100% of face value. If by a reward item, enter the share of the reward’s cost in its price. For footwear and children’s the share differs from accessories: take your own.
Cohort: issuedpoints5,000,000Points issued in one closed period (for example a year ago): their validity has ended and the fate of every point is known.
Cohort: redeemedpoints3,300,000Of the same cohort redeemed by members.
Cohort: expiredpoints1,700,000Of the same cohort expired. Redeemed plus expired is not above issued.
Revenue of the period excl. VAT₽130,000,000For the cost of the program in revenue. Empty: the measure is not calculated.
Reserve already created₽6,000,000The balance of the points reserve in the books. Empty: the addition is not calculated. Agree the accounting treatment with your accountant.

How it is calculated

StepFormula
Points balancestart + issued − redeemed − expired
Breakageexpired ÷ issued in a closed cohort
Obligation and reservepoints × point value × redemption cost share; reserve × (1 − breakage)
Cost of the programmeissued × face value × cost share × (1 − breakage) ÷ revenue

Worked numbers

Default values from the app; in the interactive version you enter your own.

Points at the end of the period
9,800,000Start + issued − redeemed − expired.
Obligation at face value
9.8 m ₽If all points are redeemed.
Historical breakage (cohort)
34 %Expired ÷ issued in a closed cohort.
Reserve allowing for expected breakage
6.47 m ₽Obligation at face value × (1 − breakage).
Expired in the period to issued
27.7 %
Redeemed in the period to issued
60 %
Issued in the period, at face value
6.5 m ₽
Redeemed in the period, at face value
3.9 m ₽
Cost of the programme in revenue
3.3 %Issued × face value × cost share × (1 − breakage) ÷ revenue.
Add to the reserve created (minus: excess)
468,000 ₽
Each 5 p.p. of breakage changes the obligation by
490,000 ₽The sensitivity of the reserve to an error in breakage.

At period end there are 9,800,000 points: an obligation at face value of 9.8 m ₽. The historical breakage of 34 % lowers the reserve to 6.47 m ₽. An error of 5 p.p. in breakage moves the reserve by 490,000 ₽.

The breakage is taken from a closed cohort, not from the current period: the fate of open points is not yet known. If the programme rules changed (validity, accrual rate), an old cohort does not fit. Agree the accounting of the obligation, the timing of revenue recognition and the tax effect with your accountant. Amounts excl. VAT.

Nuances and limits

  • Take breakage from a closed cohort: the fate of open points is unknown.
  • If the validity of points or the accrual rate changed, an old cohort does not fit.
  • Agree the accounting of the obligation and the recognition of revenue with your accountant.
  • The redemption cost share depends on the reward: a discount costs the face value, an item its cost.

Terms used

Calculate on your data →