VAT Report for Kenyan Retailers: What to Reconcile Every Month

A VAT report for a Kenyan retailer is not just a total at the bottom of a page. It is the bridge between what happened at the till and what the business files with KRA. When the report is wrong, the problem is usually upstream: an unrecorded sale, a product with the wrong tax code, a supplier invoice that was never captured, or a credit note that did not reach the report.

This guide explains what a useful monthly VAT report should contain, how to reconcile it against sales and purchases, and which checks catch problems before filing. It is written for shop owners, finance teams and accountants working with retail, wholesale and distribution businesses. Confirm current VAT rules and rates with KRA or your tax adviser.

What a Kenyan VAT report should show

A practical report should make these figures easy to separate:

• Output VAT: tax charged on sales during the period.
• Input VAT: tax paid on eligible purchases and expenses.
• Net VAT: the difference between output and input VAT, before adjustments.
• Zero-rated and exempt supplies: turnover that must be reported but is not taxed at the standard rate.
• Credit notes and returns: reductions that affect the amount already reported.
• Sales by outlet or branch: enough detail to explain differences between locations.

The report should also reconcile to the underlying documents. A total that cannot be traced back to invoices, purchases and payments is not ready for filing.

Output VAT: start with every sale

Output VAT begins with complete sales records. If a sale never reaches the POS, no report can recover it. The first control is therefore operational: every cashier uses the system, every shift is closed, and every exception is documented.

For each sale, confirm:

• The correct tax treatment was applied to each item.
• Discounts and promotions reduced the taxable amount correctly.
• The payment method was recorded accurately, especially when a customer splits cash and M-Pesa.
• The invoice was issued and, where applicable, submitted through the eTIMS route.

Review fast-moving and high-value items first. These create the largest VAT differences and are the most likely to expose a wrong product code.

Input VAT: only claim what you can support

Input VAT is not simply the VAT shown on every supplier document. The purchase must be for the business, the invoice must be valid, and the claim must be allowed under the current rules. Some expenses are restricted or blocked, and the treatment can change.

Build a monthly routine around supplier invoices:

• Capture the supplier PIN, invoice number, date and VAT amount.
• Match the invoice to the goods received or the expense it supports.
• Check that the invoice has not already been claimed.
• Separate purchases that are not eligible for input VAT.
• Investigate supplier invoices that are missing or disputed.

For distributors and wholesalers, also check that returns to suppliers and supplier credit notes are reflected. A purchase that was claimed and later returned should not remain in input VAT.

Credit notes, returns and discounts

Returns and credit notes reduce the amount of output VAT previously reported. They need the same discipline as sales:

• Link the credit note to the original sale where possible.
• Record the reason and the items returned.
• Ensure the credit note reaches the VAT report for the correct period.
• Confirm that the customer-facing document and the internal record agree.

A common error is issuing a refund at the till without creating a proper credit note. The cash movement is recorded, but the tax report still shows the original sale in full. The result is overstated output VAT and an unexplained difference at month end.

Reconcile POS sales to invoices and payments

Use a simple three-way check each month:

The comparison does not have to be complicated. It has to be done consistently, with the differences written down and resolved.

Month-end VAT reconciliation checklist

1. Close all shifts and confirm that sales are posted for the period.
2. Review failed, rejected or uncertain eTIMS submissions and resolve them.
3. Reconcile sales by outlet and payment method.
4. Check product tax codes for new or changed items.
5. Capture all eligible supplier invoices and match them to purchases.
6. Review supplier returns and credit notes.
7. Review customer returns and credit notes.
8. Confirm that discounts and promotions reduced the taxable amount correctly.
9. Produce the VAT report and compare it with the ledger.
10. Investigate differences before filing, and keep a record of the explanation.

Common VAT report discrepancies

• Cash sales outside the POS. The most damaging gap, because it affects sales, stock and VAT at the same time.
• Wrong tax category. A standard-rated item treated as exempt, or the reverse, changes the whole return.
• Timing differences. A sale or purchase recorded in a different period from the document.
• Unclaimed input VAT. Valid supplier invoices that were never captured.
• Duplicate claims. The same supplier invoice entered twice.
• Missing credit notes. Returns processed at the till but not reflected in the report.
• M-Pesa mismatches. Transactions recorded against the wrong sale or not matched to settlement.

How Vega supports the workflow

Vega brings sales, stock, payments, purchasing and VAT reporting into one workspace. A sale at the till updates the stock and payment record, and the reporting layer uses the same data. That reduces the retyping and spreadsheet reconciliation that create month-end differences.

For businesses planning electronic invoicing, the eTIMS integration guide explains the routes, testing and exception handling. The POS system Kenya guide covers multi-branch sales, M-Pesa and VAT reporting, while the wholesale POS guide covers trade customers, van sales and distribution.

Frequently asked questions

How often should a Kenyan retailer reconcile VAT?

At least monthly, before filing. Businesses with high transaction volumes or several outlets should review key controls more often, especially payment matching and failed invoices.

Can a POS produce the VAT report automatically?

A POS can calculate output VAT from recorded sales and help separate tax categories, but the business still needs to review input VAT, credit notes and exceptions. Automation reduces manual work; it does not remove the need for reconciliation.

What if my sales and VAT report do not match?

Investigate before filing. Start with unrecorded sales, credit notes, wrong tax codes and timing differences. Keep a written explanation of what you found and how it was corrected.

Does eTIMS replace the VAT report?

No. eTIMS relates to electronic invoicing. The VAT report and return still need to reflect output VAT, input VAT and adjustments for the period.

Next step

If month-end VAT reconciliation takes days, start by fixing the flow of sales, purchases and payments into one system. Review the POS system Kenya page or request a setup discussion with Vega.

This guide is general information, not tax advice. Confirm current VAT rules, rates and filing requirements with KRA or your qualified adviser.