R
Finance
Karatasi Rental Income & Tax Tracker
An Excel tracker built for Kenyan landlords. Log every rent receipt and expense once, and the dashboard and KRA Monthly Rental Income (MRI) tax summary update themselves: 7.5% of gross rent, due by the 20th, with a rent roll for every tenant and unit.
KES
1,000
one-time · instant download
- One ledger for rent and expenses: nothing typed twice
- Rent roll with tenant, unit, deposit and lease dates
- Multi-property dashboard: rent, expenses and net by property
- KRA MRI calculator: 7.5% of gross rent with monthly due dates
- Automatic MRI threshold check (KES 288,000 to 15M)
- Normal-regime calculation with allowable expenses
- Editable tax rates, thresholds and expense categories
- Pre-filled sample data so you can see it working
Get this template
Pay with M-Pesa, card, or bank. Files sent to your email immediately after payment.
Stop piecing your rental records together from M-Pesa messages and bank statements. The Karatasi Rental Income & Tax Tracker is one Excel workbook that keeps every rent receipt and every expense in a single ledger, then builds your dashboard and KRA tax summary for you.
Set it up once (your name, KRA PIN, properties and expense categories), then log each payment as it happens. Rent received and expenses share one sheet on purpose, so you get a clean audit trail in date order, and nothing is ever typed twice.
The Tax Summary shows your Monthly Rental Income (MRI) tax month by month at 7.5% of gross rent, with the 20th-of-the-month deadline beside each figure. It also flags whether you fall below the KES 288,000 threshold, sit in the MRI band, or need the normal annual regime, and includes a normal-regime calculation with allowable expenses deducted. Rates and thresholds are editable if KRA changes them.
Built for Kenyan landlords with one house or several blocks. Works in Microsoft Excel and compatible spreadsheet apps. This is a record-keeping tool, not tax advice: confirm your position with KRA or a tax adviser.