Average transaction value: grow the bill, not just traffic

Two numbers behind every sale

Your sales for any day can be split into two parts: how many bills you rang up, and how much each bill was worth on average. Sales equals bills times average bill. That one line explains most of the movement an owner sees.

The second number is what many people call average transaction value, or simply the average bill. Split it once more and you get items per bill, often called basket size, and the average price of each item. Average bill equals items per bill times average item price.

So there are three levers: more bills, more items on each bill, or higher-priced items on each bill. They move for different reasons, and they need different fixes.

How to work them out

Average bill is total sales divided by the number of bills. Items per bill is the number of items sold divided by the number of bills. Average item price is total sales divided by the number of items sold.

Count bills, not people. A family of four paying once is one bill. Take voided bills out before you divide, and decide once how refunds are treated. Then keep the same rule every month, or the number will move for no real reason.

Work it out for each outlet. A group average mixes a busy mall outlet with a quiet neighbourhood one, and hides what each of them is doing.

A made-up example: fewer customers, more sales

Here is a made-up example. In March, one outlet sells RM 60,000 from 2,000 bills and 5,000 items. The average bill is RM 30.00. Items per bill is 2.5. The average item price is RM 12.00.

In April, bills drop to 1,900. Fewer customers came in. But the average bill rises to RM 33.00, so sales are 1,900 times RM 33.00, which is RM 62,700. That is RM 2,700 more than March, up 4.5%, with 100 fewer bills.

Where did the extra RM 3 per bill come from? Items per bill went from 2.5 to 2.75, which is 5,225 items, and the average item price stayed at RM 12.00 (2.75 times RM 12.00 is RM 33.00). Customers did not pay more per item. They bought more items.

Look only at the sales line and you would call April a good month and move on. Split it, and you see two separate stories: fewer people are coming in, and something at the counter is working. Both need attention.

Why customer count and average bill move separately

The number of bills is driven mostly by things outside the counter: location, weather, a new competitor nearby, school holidays, the festive calendar and your opening hours.

The average bill is driven mostly by what happens inside: what staff suggest, how the menu or shelf is laid out, which bundles you offer, and whether popular items are in stock. A missing best seller can pull the average bill down even on a busy day.

Promotions can push the two in opposite directions. A discount may bring more bills but lower the average bill, because each item sells for less. That is why you check both before calling a promotion a success.

Levers that raise the average bill

Add-ons. A drink with the meal, batteries with the toy, a refill with the bottle. A good add-on is cheap for the customer, quick to say yes to, and carries a healthy margin for you.

Bundles. Put two or three items that already sell together under one price. Look at the bills that contain your best seller and see what else often appears on them; that pair is your first bundle. Keep the bundle discount small, because every ringgit off comes straight out of profit.

Staff suggestions. One sentence at the counter, said the same way every time, often does more than a poster. Give staff one item to suggest each week, not ten.

Trade up. Offer the bigger size or the better version first. This raises the average item price rather than items per bill, so watch that number to see whether it is working.

How to tell if a lever worked

Change one thing at a time, in one outlet first. Then compare that outlet with its own 4 weeks before the change, and with a similar outlet that changed nothing.

Watch the right number. An add-on or a bundle should lift items per bill. A trade-up should lift the average item price. If the average bill rose because you raised prices the same month, the lever did not do it.

Check the bill count too. If the average bill went up but bills fell by more, you may have slowed the queue or put people off. And check gross profit, not just sales: a bundle that adds RM 2 to the bill but gives away RM 2.50 in discount has lost money.

If the test outlet beats both its own past and the other outlet for 4 weeks, roll the change out. If it does not, drop it and try the next lever.

Ask it in plain words

This is a question you can ask iSenang, your AI data analyst, in plain words: for example, how the average bill changed at each outlet last month, and whether sales moved because of more bills or bigger bills. The figures are computed from your own sales data, and when a question is not covered by your data yet, it says so instead of guessing.