Home/ Insights/ How to design a loyalty points programme | Earn rules, expiry, FIFO redemption, refunds and fraud controls for membership apps

How to design a loyalty points programme | Earn rules, expiry, FIFO redemption, refunds and fraud controls for membership apps

Points are the least reversible part of a membership app. Earn rates, expiry, redemption order and refund handling are hard to change once shown to members, and changing them means a ledger rebuild and an announcement. Here is what to decide in the design phase, the options for each, and what the ledger has to look like.

Earn rate and earn rules

Decide what earns points and how many.

  • Percentage of spend: the common form. Decide pre- or post-tax, and rounding
  • Fixed amounts for actions: visits, reviews, referrals. Without caps these become fraud targets
  • Rank multipliers: higher rates for upper tiers. Decide the assessment window and demotion rules
  • Campaign bonuses: keep them as separate records so you can measure them later

Decide timing too: award at purchase, or after the return window. Most award immediately and reverse on refund.

Expiry and forfeiture

  1. Per-award expiry: one year from each award. The most common, and natural if the ledger is per award
  2. Rolling from last activity: expiry moves with use; good for pruning dormant members, harder to explain
  3. Fixed annual date: simple, but redemptions bunch up before the date

“Points expiring within 30 days” notices are among the most effective nudges, and a per-award ledger makes them trivial.

Redemption order (FIFO) and the ledger

Redeem the soonest-expiring points first: FIFO. Fewer forfeitures for members, fewer complaints for you.

FIFO only works if the ledger records transactions rather than a balance. A single balance number overwritten on every event cannot tell you which award is left, so expiry and refund reversals cannot be exact. Record every award, redemption, forfeiture and reversal as a row; the balance is the sum.

That structure gives you per-award balances and expiry, refund reversals of exactly the points a purchase earned, history to answer “my points went down”, and an audit trail.

Refunds and cancellations

  • Reverse the award: if the points were already spent, decide whether the balance goes negative or the shortfall nets against the next award
  • Restore redeemed points: when a purchase paid with points is returned, restore them with the original expiry

Exceptions abound here, and the transactional ledger is what makes them tractable.

Fraud controls (double earn, card sharing, manual awards)

  • Duplicate transactions: give each transaction a unique ID and accept an award once per ID (idempotency)
  • Repeated actions: once per day or per member caps in the earn rules
  • Shared member cards: rotate the QR or barcode on a short timer
  • Staff awards: log who awarded what to whom, and separate the permission

Payment-services law and accounting

Points you grant free of charge generally fall outside prepaid payment instruments regulation in Japan, but selling points or pooling them across companies changes that. Whether unredeemed points are booked as a liability depends on the accounting standard and company size. Confirm with legal, tax and audit advisers before launch.

Summary | A transactional ledger lets you change everything else later

Earn rates and expiry can change with notice. The ledger structure is what you cannot easily change. Record every event and derive the balance, and FIFO, reversals, expiry notices, audits and programme changes can all be added later.

SHANNON provides Membercore, a headless membership platform with members, a per-award points ledger, ranks, coupons, stamp rallies and delivery as APIs plus an admin console. FIFO redemption and reversals are built in. Contact us about a new membership app or a points programme review.

Back to Insights

Let's talk.

Everything you share is handled in confidence. We reply within two business days.