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.
-
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
Marketing campaign tracker
Record each campaign's channel, budget, spend, leads and sales, and see the cost per lead and the return.
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
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
M-Pesa till reconciliation
Match every M-Pesa payment to a sale, and see what is matched, what is not and how much money has no explanation yet.
Free
View details →
-
Accountingxlsx
Daily cash-up sheet
Close the till each day: compare what the system says with what you counted, by payment method, and see any difference at once.
Free
View details →
-
Taxxlsx
VAT returns register (12 months)
Record each month's sales and purchases, work out output VAT, input VAT, the credit carried forward and the VAT payable, for the whole year.
KES 1,350KES 1,500-10%
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
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 →
-
Payrollxlsx
Sales commission calculator and tracker
Record each sale, apply tiered commission rates automatically, and see what every salesperson has earned and what is still unpaid.
KES 1,080KES 1,200-10%
View details →
-
Businessxlsx
Sales pipeline and lead tracker
Track every opportunity from lead to won or lost, with weighted values, next actions and a forecast of what you will close.
KES 900KES 1,000-10%
View details →
-
Businessxlsx
Monthly sales tracker with targets
Record the units you sell of each product each month, see the revenue, and compare it with your target with a chart.
Free
View details →
Advertisement