The Price on the Shelf: Tax-Inclusive vs Tax-Exclusive at the Till
The number on the shelf either includes VAT or it does not, and getting that one boolean wrong on an item makes every sale of it wrong by sixteen percent — in your favour or the customer's, quietly, until somebody reconciles a VAT return.
A customer in a Kenyan shop expects the price on the shelf to be the price they pay. A supplier quoting the same business expects the price to exclude VAT, with tax added at the bottom. Both conventions are normal, both are correct in their context, and your item records have to know which one applies to every single line — because the arithmetic runs in opposite directions.
This is one boolean per item. It is also the field most likely to be set by whoever imported your catalogue at three in the morning, and the errors it produces are the hardest to spot: nothing crashes, no total looks absurd, and the receipt prints beautifully. The only symptom is that your tax figure is wrong.
The two directions, side by side
The distinction is not cosmetic. In one direction you add tax on top of the price. In the other you pull tax out of a price that already contains it. Those produce different net figures from the same shelf number.
The same item, the same 16%, two settings
Set an inclusive price as exclusive and you overcharge every customer by the tax. Set an exclusive price as inclusive and you absorb the tax out of your own margin on every unit sold. Neither error announces itself.
Our till handles both, per item, and the rule it follows is simple: the subtotal is always net of tax. On an inclusive item the tax is extracted so that subtotal plus tax equals the total. On an exclusive item the tax is added so that subtotal plus tax equals the total. Either way the three figures on the receipt reconcile, which is exactly what an auditor checks first.
Why the subtotal must be net
If a receipt showed a gross subtotal and then a tax line, the two would add up to more than the customer paid. Inclusive prices are stored gross for the shelf and reported net for the books — that translation happening in one place, at the line, is what keeps the two audiences from contradicting each other.
Not every item pays tax at the same rate
A basket in a Kenyan supermarket routinely mixes standard-rated goods with items that carry no VAT at all. That has to work at the line, not at the sale, because the sale is just the sum of its lines.
The tax treatment on an item, and what it actually does
Setting on the item What happens at the line
Standard Your enabled tax rate applies
The default. The line takes whatever combined rate your organization has enabled — and this is where most of your catalogue should sit.
Zero-rated Rate resolved to 0%
The line computes no tax. In VAT terms, a zero-rated supply is still a taxable supply at a nil rate, which matters for your return even though the line arithmetic is the same as exempt.
Exempt Rate resolved to 0%
Also no tax on the line. In VAT terms this is a different animal from zero-rated — it affects what input tax you can recover — but at the till the amount charged is identical.
Blank Treated as standard
An item with no treatment set behaves as standard-rated. That is the safe default, but it means a genuinely exempt item left blank will have tax added to it silently.
The honest limitation: the sale line records the rate applied and the tax amount, not the treatment that produced them. So a zero-rated line and an exempt line look identical in the sale record — both are simply 0%. Separating the two for a VAT return means going back to the item, whose treatment may have changed since.
Where the rate itself comes from
The rate is not typed at the counter and it is not hard-coded. It is resolved from your organization's enabled tax settings at the moment of the sale, and there are two behaviours worth knowing about because they surprise people.
- If you have more than one tax type enabled, their default rates are added together into one combined rate, and the sale line records that single combined figure. A 16% VAT plus a 2% levy becomes one 18% line, not two tax lines.
- The label follows suit: the tax type on the sale becomes the enabled codes joined together, so you might see something like VAT+TL rather than a breakdown.
- If no tax type is enabled, or the enabled ones resolve to a zero rate, the sale simply carries no tax. Nothing errors; you just get a sale with a zero tax figure — which is correct for a business below the registration threshold and wrong if somebody forgot to turn VAT on.
- Each sale stores a financial snapshot of the tax type and rate that applied. A rate change next year does not rewrite last year's receipts.
- A discount reduces the taxable base before tax is computed, so a discounted line charges proportionally less tax. That is correct — and it is another reason untracked discounting moves more than just your margin.
How much tax configuration does your shop actually need?
Hardware shop, all standard-rated
Enable VAT, set every item to standard, and never think about it again. Get the inclusive-or-exclusive boolean right once at import and you are done.
Supermarket with unprocessed foods
You need per-item treatment, because a basket mixes standard-rated and zero-rated goods and the receipt has to be right at the line.
Pharmacy
A genuine mix of exempt, zero-rated and standard items, where the treatment on each product is a compliance decision and not a preference.
Wholesaler quoting business buyers
Usually exclusive pricing throughout, with the tax added at the bottom — the opposite default from retail, and worth setting deliberately rather than inheriting.
Most shops are further left than they assume. If your whole catalogue is standard-rated, the only field that matters is whether the shelf price includes tax.
How to check your own catalogue this week
-
Pick your five best sellers and do the arithmetic by hand
Ring one of each in a test sale. If the total the till produces is not the number you would take at the counter, the inclusive setting on that item is wrong. Five items takes ten minutes and finds the systemic error, because catalogues are almost always wrong in one direction, not randomly.
-
Check what your imported items inherited
A spreadsheet import that did not include the tax-inclusive column left every item on the default. If you price inclusively at the shelf and the default was exclusive, every one of them is adding tax on top of a price that already has it.
-
Set treatment explicitly on anything not standard-rated
Leave standard items blank if you like — they behave as standard. But mark your zero-rated and exempt lines deliberately, because a blank on an exempt item quietly charges tax you should not be charging.
-
Confirm your enabled tax types are what you think
If two are enabled, your till is charging their sum as one rate. That is fine if intentional and a surprise if not. Read the combined rate on a test receipt rather than the settings screen.
-
Reconcile one day of sales against your VAT working
Take a single day, sum the tax figures from the sales summary, and compare it to what your accountant would compute from the same sales. A discrepancy here is far cheaper to find in a day than in a quarter.
What we do and do not do
What AWRA OpsHub does today
- A tax-inclusive or tax-exclusive selling price per item, with the extraction arithmetic handled at the line.
- A subtotal always reported net of tax, so subtotal plus tax equals the total on every receipt.
- Per-item tax treatment — standard, zero-rated or exempt — resolving the line rate accordingly.
- The organization's enabled tax types and default rates resolved automatically at the point of sale.
- Tax computed after any line discount, so the taxable base reflects what the customer actually paid.
- A financial snapshot of the tax type and rate stored on each sale, so historical receipts survive a future rate change.
- Tax rate and tax amount stored on every sale line, not just on the sale total.
- eTIMS fiscalisation for Kenya, covered separately in eTIMS at the point of sale.
What it does not do
- Separate tax lines when multiple tax types are enabled — their default rates are summed into one combined rate on the line.
- The tax treatment stored on the sale line, so zero-rated and exempt sales cannot be distinguished from the sale record alone.
- Per-customer VAT exemption at the till — the hook exists in the code but is not wired, so a tax-exempt buyer is not handled automatically at the counter.
- Automatic reconciliation of your recorded tax against a filed VAT return.
- Tax-inclusive buying prices flowing through to the till's cost figures in a way that separates recoverable input tax.
- Any warning when an item's inclusive setting looks inconsistent with the rest of its category.
The two that matter most on that second list are the tax treatment on the line and per-customer exemption. Both are contained pieces of work. If either is blocking your VAT reporting today, that is worth telling us rather than working around.
Our take
Almost every tax problem we see at a Kenyan till is not a rate problem, a rule problem or a compliance problem. It is one boolean, set wrong on an item, repeated across a whole imported catalogue. Test five best sellers by hand before you trust anything else — because a fiscalised receipt with a confidently wrong tax figure on it is worse than no fiscalisation at all.
A tax figure your accountant can reconcile
Inclusive or exclusive per item, treatment per line, the rate snapshotted onto every sale, and a subtotal that always adds up with the tax to the amount the customer actually paid.
See POS in AWRAFrequently asked questions
Can some items be tax-inclusive and others tax-exclusive in the same shop?
Yes — it is a setting on each item, resolved at the line, so a single basket can mix both and the totals still reconcile. In practice most shops should be consistent within a catalogue, because mixed conventions on the shelf confuse staff far more than they confuse the software. The mixing that genuinely matters is between retail pricing and wholesale quoting, which is a decision about who you are selling to.
How does the till know what rate to charge?
It resolves your organization's enabled tax types and their default rates at the moment of the sale, then applies the item's treatment to that rate. Nothing is typed at the counter. The resolved tax type and rate are also snapshotted onto the sale, so a rate change later does not rewrite what an old receipt says.
What happens if we have both VAT and another levy enabled?
Their default rates are added together into a single combined rate, and the sale line records that one figure along with one tax amount. The label becomes the enabled codes joined together, so you may see something like VAT+TL. If you need the two reported separately on the line and on the receipt, that is not built today — say so and we will scope it, because it is a schema and reporting change rather than a rewrite.
Is there a difference between zero-rated and exempt at the till?
Not in the amount charged — both resolve the line rate to zero. The difference is real for VAT purposes, since it affects your input tax recovery, but the sale line only records the rate applied and the tax amount, not the treatment that produced them. That means separating zero-rated from exempt sales for a return requires going back to the item records, whose treatment may since have changed. It is a genuine gap and a fair thing to ask us to close.
Does a discount change the tax we charge?
Yes. Tax is computed on the line amount after the discount, which is correct — you charge tax on what the customer actually paid, not on the list price. It does mean a heavy volume of counter discounting reduces your output VAT as well as your margin, which is one more reason to read your discount totals rather than ignore them.
Can we mark a specific customer as VAT-exempt so their sales carry no tax?
Not at the till today. The hook for per-customer exemption exists in the code but is not wired, so every sale resolves tax from the organization's settings and the item's treatment regardless of who is buying. If you serve exempt institutional buyers regularly, handle it deliberately — and tell us, because it is a small, well-defined change rather than a structural one.
