Points a Cashier Cannot Invent
A loyalty balance that someone can type into is a till drawer with no count. Ours is a ledger: every point is a row written by a sale, a return, an expiry or a named adjustment, and the balance is only ever the sum of the rows.
- Written by
- Washingtone AuraFounder, AWRA OpsHub
- Issued
- Build
- Initial
The owner of a mini-supermarket in Nakuru noticed it in the third month of her points scheme. One customer, a cousin of the evening cashier, had redeemed KES 9,000 of shopping on points while buying almost nothing. The old system kept the balance as a number on the customer card, and any cashier who could edit a customer could change it. Nobody had stolen cash, and every till balanced to the shilling. The loss was in a field.
Points are money with a delay. A customer who holds 500 points worth a shilling each holds KES 500 of your stock, payable on demand at any till. Most shops would never let a cashier change the float without a count and a signature, and then run a points scheme where the balance is a field anyone with the right screen can overwrite. Our points programme was built the other way round.
The balance is the sum of the rows
There is no balance field to edit. Each customer has a ledger of point entries, every entry carries a sign, and the balance is the sum, worked out each time it is read. Nothing caches it. An entry is written in only five ways:
| Entry | Written by | Sign |
|---|---|---|
| Earned | A till sale to a named customer | + |
| Redeemed | Points spent on a till sale | − |
| Return | A till return against a sale that earned or spent points | + or − |
| Expired | Points older than the workspace’s expiry, not already spent | − |
| Adjusted | A person who may edit customers, with a reason | + or − |
No screen edits or deletes an entry once written. A mistake is put right by another entry, which is how the cash book has always worked. The customer page shows the balance and the recent entries, each with its date and its note, so a question at the counter is answered by reading down the list rather than by trusting the number at the bottom.
The one manual door
A goodwill credit for a late delivery, or points from a paper card being retired, is an adjustment. It needs the permission to edit customers, which cashiers usually do not hold, a non-zero number of points and a written reason. The entry keeps the name of the person who made it. The route is protected against a double submit, so a slow connection cannot credit the points twice.
Points are stored value. Treat them like the float: no figure without a document, and no document without a name.
Earning and spending at the till
The programme is off until someone with settings rights switches it on and sets four numbers: points earned per shilling spent, the value of a point when it is redeemed, the smallest redemption allowed, and how many days points last. A common setting is one point per KES 100 and KES 1 per point.
When the cashier picks the customer, the till shows their balance. Redeeming takes the points off the basket as a reduction spread across the lines, each line keeping its own tax share, exactly as a discount would. So the receipt, the revenue posting, a later return and the eTIMS submission all read reduced lines; there is no special case for points anywhere downstream. Points are then earned on what the customer actually paid, not on the price before the points came off. How a cashier’s own discount is limited and approved is in a discount with a name on it.
A basket at one point per KES 100, KES 1 per point
260 − 200 + 16. Two entries, both pointing at the same sale number.
Two tills, one balance
On a busy Saturday a family can be at two tills at once with the same loyalty card. Before a redemption is accepted, the customer’s record is locked until the sale is written, so the second till waits for the first and then sees the balance that is left. A redemption above the balance, or below the workspace minimum, is refused at a live till with the number of points the customer actually has.
One case is handled differently on purpose. A sale rung up offline is replayed when the till reconnects, and by then the customer has already walked out with the goods. If the redemption turns out to be more than the balance, the sale is kept rather than refused, and the overspend is logged for someone to look at. Refusing a sale that already happened would only make the stock and the cash disagree. How offline sales are replayed safely is in the sale the till sent twice.
Returns and expiry
A return gives back the points that were spent and takes back the points that were earned, in proportion to how much of the sale is refunded. Return half of the KES 1,600 basket above and the customer gets back half of the 200 points spent and loses half of the 16 earned: one entry of +92. Return all of it and they are where they started.
Expiry runs first in, first out. When a balance is read, earned points past their date that later spending has not already used up are written off by an Expired entry. Reading the balance again writes nothing more, because the expiry entry already counts as spent.
Four questions for any points scheme
Who can change a customer’s points balance?
What you will probably hear
Anyone who can edit the customer.
How to read it
Then the balance is a field, and the cashier’s cousin is one edit away from free shopping.
Can you show me every change to this customer’s points, with who made it?
What you will probably hear
We can show the current balance.
How to read it
A balance without its history cannot be checked, by you or by the customer disputing it.
What happens to points when a sale is returned?
What you will probably hear
The customer keeps them.
How to read it
Buy, earn, return, repeat. Points earned on a refunded sale should leave with the refund.
Do redeemed points reduce the tax on the sale?
What you will probably hear
Points are a payment type.
How to read it
If points are a tender, the tax return still shows the full price. If they reduce the price, the lines and the tax should say so.
Verdict
Run points the way you run the float. Every point comes from a sale, a return, an expiry or a named adjustment with a reason; nothing is overwritten; and the balance is the sum of what happened. Then the only way a cashier can give a friend points is to sell the friend something, and that sale is on the till roll.
Points that reach beyond the till
The ledger, earning and redemption at the till, return reversals, expiry and named adjustments are in place on the web till, in the mobile app and through the API. These extend them.
Points on invoiced sales
Account customers earning on invoices as well as at the till, into the same ledger.
A liability for unspent points
The value of points earned and not yet redeemed carried as a balance in the books, for organizations whose auditors ask for it.
A second approver for large adjustments
Adjustments above a threshold you set held until someone else approves them.
The balance on the receipt and by SMS
The running balance printed under points earned, and a text to the customer after each sale.
Earning rules by category
Double points on a promoted range, or none on airtime and other thin-margin lines.
Each builds on the ledger that already records every point.
Tell us how your scheme worksSee the point of sale
Till sales online and offline, split tenders, returns with approvals, drawer sign-off and a loyalty ledger that nobody can type into.
Explore the point of saleFrequently asked questions
Can a cashier change a customer’s loyalty balance?
Not by typing a number. The balance is the sum of ledger entries. A manual adjustment needs the permission to edit customers and a written reason, and it is kept in the ledger with the name of the person who made it.
Are points earned on the price before or after redemption?
After. Points are earned on what the customer actually paid, rounded down to whole points.
How do redeemed points affect tax?
A redemption reduces the price of the sale’s lines, each keeping its own tax share, the same way a discount does. The receipt, the revenue posting and the eTIMS submission all read the reduced lines.
What happens to points when a sale is returned?
Points spent on the sale are given back and points earned on it are taken back, in proportion to how much of the sale is refunded.
Do points expire?
Only if the workspace sets an expiry, from 1 to 3,650 days. Expiry is first in, first out, and only points that have not already been spent are written off.