How Excel fits with eTIMS
Excel is a preparation and record-keeping tool, not a compliance system. You can use it to assemble invoice data, lists of items and customers, or to keep a running record, but the actual signing and transmission of invoices happen through eTIMS.
Depending on the current eTIMS features, you may be able to upload prepared data in bulk, or you use a certified integrator that reads your spreadsheet and pushes invoices to eTIMS. Either way, the spreadsheet feeds eTIMS; it does not replace it.
How to use Excel with eTIMS
- 1
Structure your spreadsheet to match eTIMS
Lay out columns that match what eTIMS needs: item, item code, quantity, price, tax type, and buyer details where required.
- 2
Keep your item and tax data consistent
Use the same item codes and tax types as in eTIMS so the data maps cleanly and invoices are not rejected.
- 3
Use bulk upload where available
If the eTIMS portal offers a bulk upload or template, prepare your data to fit it. Confirm the current template with KRA.
- 4
Or use a certified integrator
For regular bulk invoicing, a certified integrator that reads your spreadsheet and transmits to eTIMS saves manual entry.
- 5
Reconcile after upload
Check that uploaded invoices received control numbers, and keep your spreadsheet as a record alongside the eTIMS confirmations.
Mistakes to avoid
Thinking an Excel invoice is compliant
A spreadsheet invoice is not a compliant tax invoice until it is signed and transmitted through eTIMS.
Inconsistent item codes
Codes that do not match eTIMS cause rejections on upload. Keep them consistent.
Ignoring tax types
Each line needs the correct tax type. A spreadsheet that omits it will produce rejected invoices.
No reconciliation
Uploading without checking control numbers leaves you unsure which invoices are compliant.
A worked example
A wholesaler issued many similar invoices a day and prepared them in Excel to save time.
By structuring the spreadsheet to match eTIMS, keeping item codes and tax types consistent, and uploading in bulk where the portal allowed, the team cut the manual entry sharply. They reconciled control numbers afterwards so every invoice was confirmed.
Excel sped up preparation, but eTIMS still did the signing and transmission. The two worked together.
Trading without eTIMS-compliant tax invoices risks KRA penalties, blocked VAT input claims for your customers, and receipts a business buyer cannot expense.
Veira signs every sale to KRA eTIMS automatically, so each receipt is compliant the moment it prints, with no separate device to reconcile.
How Veira helps
If manual spreadsheets and uploads are slowing you down, a POS that records each sale and transmits to eTIMS automatically removes the bulk-entry step entirely, while still giving you exportable reports for your records.
For a busy counter, that is faster and cleaner than preparing invoices in Excel. See how Veira works or book a demo.