Organise sales VAT, purchase VAT, eTIMS references and supporting invoices with this free Excel VAT records and reconciliation template for Kenyan businesses.
Good VAT compliance begins with the underlying bookkeeping records. Businesses need to be able to connect VAT amounts to sales, purchases, invoices and supporting documentation.
The FedhaTrac VAT Records & Reconciliation Template contains separate Sales VAT and Purchase VAT registers, with fields for invoice numbers, customer or supplier PINs, taxable amounts, VAT, gross amounts, eTIMS references and document-review status.
A dedicated VAT Reconciliation sheet then summarises recorded output VAT and purchase VAT marked as supported for review, helping identify differences before return preparation.
The workbook deliberately does not automatically determine whether input VAT is legally deductible. Tax treatment should be reviewed based on the transaction and current law.
KRA currently states that VAT returns and payment are due on or before the 20th day of the following month.
