AWRA OpsHub Search
AWRA Field 04 screens 7 min read

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

Basket before points KES 1,800
Points redeemed 200 points = KES 200
Customer pays KES 1,600
Points earned on what was paid 16 points
New balance 76 points

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.

More we can add

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 works

See 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 sale

Frequently 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.

Share this article

LinkedIn X WhatsApp

Help Center

Need a quick answer while you read?

Run inventory, procurement, assets, sales, and field work with approved AWRA guidance for setup, migration, integrations, security, pricing, and support.

Search all approved AWRA public help articles.

Open Help Center