Excel templates for payroll, tax and business in Kenya

Excel workbooks and documents for payroll, tax, accounting and business. Many are free, and you do not need an account to download them.

Request a custom template Cart

Businessxlsx Loan affordability checker and schedule Check whether you can afford a loan: see the monthly payment, the total interest, the share of income it takes and the repayment schedule. KES 810KES 900-10% View details →
Businessxlsx Rental property investment analyser Compare rental properties by total cost, rent, expenses, yield and years to pay back, before you buy. KES 1,350KES 1,500-10% View details →
Businessxlsx Daily takings and expenses log Write down each day's takings and expenses, and see the day's profit, the running total and your best and worst days. Free View details →
Businessxlsx Customer database Keep your customers' names, phone numbers, towns, type, last purchase and total spent in one searchable list. Free View details →
Accountingxlsx Cost centre expense allocation Share shared costs such as rent and salaries between departments by percentage, and see each department's total cost. KES 1,080KES 1,200-10% View details →
Accountingxlsx Sales receipts book Record each cash or M-Pesa sale with a receipt number, item, quantity and price, and total sales by payment method. Free View details →
Accountingxlsx Trial balance template List the balance of every account in debit and credit columns, check they agree and see totals by account type. Free View details →
Taxxlsx VAT threshold monitor (rolling 12 months) Enter monthly taxable sales and see the rolling 12-month total against the VAT registration threshold, with a warning before you cross it. KES 810KES 900-10% View details →
Taxxlsx Rent receipt book Issue numbered rent receipts, keep a register of every payment and total the rent received for your monthly rental income return. Free View details →
Taxxlsx eTIMS sales invoice register Keep a list of every sales invoice with its eTIMS reference, the customer PIN, the VAT and the total, and match them to your sales. Free View details →
Taxxlsx VAT input invoice register List the purchase invoices you will claim VAT on, with supplier PIN and invoice number, and total the input VAT for your return. Free View details →
Payrollxlsx Payroll journal entry workbook Turn a month's payroll totals into a balanced journal for your accounts, with the employer's costs and every liability. KES 1,350KES 1,500-10% View details →