Year-End Rental Income Summary: What Kenyan Landlords Need to Prepare
December arrives. Tax season looms.
Suddenly you need to know: How much rent did I actually collect this year? What were my expenses? Am I compliant?
If you've been diligent with monthly records, this is straightforward. If not, you're in for a long few weeks.
Here's how to prepare your year-end rental income summary.
Table of Contents
- Why Year-End Summary Matters
- The Core Numbers You Need
- Gathering Your Data
- The Summary Document
- MRI vs Regular Tax: Year-End Considerations
- Audit Preparation
- Common Year-End Mistakes
- Year-End Checklist
- Using Software for Year-End
- Planning for Next Year
- Key Takeaways
Why Year-End Summary Matters
Even if you file MRI monthly, you need annual records for:
Tax compliance:
- Annual return filing
- Audit support
- Expense documentation
Financial clarity:
- True profit/loss picture
- Property performance comparison
- Investment decisions
Business planning:
- Next year's budget
- Rent adjustment decisions
- Expansion or divestment
The Core Numbers You Need
1. Total Gross Rental Income
Every shilling of rent collected during the year.
Include:
- Regular monthly rent
- Late payments for previous months
- Any additional charges (parking, utilities pass-through)
Don't include:
- Security deposits (unless forfeited)
- Refunds given to tenants
2. Vacancy Loss
Rent you could have collected but didn't.
Calculation:
Track per unit, sum for total.
3. Bad Debt
Rent invoiced but never collected (write-offs).
What qualifies:
- Tenant left without paying
- Evicted tenant with balance
- Genuine irrecoverable amounts
Documentation needed:
- Proof of invoicing
- Evidence of collection attempts
- Write-off decision
4. Net Rental Income
What you actually collected.
Calculation:
This is your taxable rental income for MRI purposes.
5. Operating Expenses
Costs of running the properties.
Categories:
- Repairs and maintenance
- Management fees
- Insurance
- Service charges
- Utilities (if landlord-paid)
- Legal and professional fees
- Caretaker salary
- Marketing/advertising
- Bank charges
- Other property-related costs
6. Net Operating Income (NOI)
Profit before financing costs.
Calculation:
This measures property performance.
7. Financing Costs
Mortgage interest and related costs.
Note: Only relevant if you're under regular income tax system (not MRI).
8. Net Profit
What you actually kept.
Calculation:
Gathering Your Data
Where to find the numbers:
Bank Statements
- All rental income deposits
- All expense payments
- Export full year's statements
M-Pesa Records
- All rent received via M-Pesa
- Request annual statement from *334# or app
- Match to tenant payments
Tenant Records
- Lease agreements
- Payment records per tenant
- Outstanding balances
Invoices and Receipts
- All expense documentation
- Contractor invoices
- Service provider receipts
- Insurance certificates
Property Records
- Occupancy by month
- Rent amounts per unit
- Lease start/end dates
The Summary Document
Structure your year-end summary clearly:
Section 1: Portfolio Overview
| Metric | Value |
|---|---|
| Total properties | 3 |
| Total units | 25 |
| Average occupancy | 94% |
| Total potential rent | KES 7,200,000 |
| Total collected | KES 6,600,000 |
| Collection rate | 91.7% |
Section 2: Income by Property
| Property | Units | Potential | Collected | Rate |
|---|---|---|---|---|
| Sunrise | 10 | KES 3,000,000 | KES 2,850,000 | 95% |
| Westview | 8 | KES 2,400,000 | KES 2,100,000 | 87.5% |
| Garden | 7 | KES 1,800,000 | KES 1,650,000 | 91.7% |
Section 3: Income by Month
| Month | Expected | Collected | Rate |
|---|---|---|---|
| January | 600,000 | 570,000 | 95% |
| February | 600,000 | 540,000 | 90% |
| ... | ... | ... | ... |
| December | 600,000 | 480,000 | 80% |
| Total | 7,200,000 | 6,600,000 | 91.7% |
Section 4: Expenses by Category
| Category | Amount | % of Rent |
|---|---|---|
| Repairs/Maintenance | KES 400,000 | 6.1% |
| Management fees | KES 660,000 | 10% |
| Insurance | KES 120,000 | 1.8% |
| Service charges | KES 300,000 | 4.5% |
| Caretaker | KES 360,000 | 5.5% |
| Legal | KES 50,000 | 0.8% |
| Other | KES 80,000 | 1.2% |
| Total | KES 1,970,000 | 29.8% |
Section 5: Profitability
| Item | Amount |
|---|---|
| Gross rental income | KES 6,600,000 |
| Less: Operating expenses | KES 1,970,000 |
| Net Operating Income | KES 4,630,000 |
| Less: Mortgage interest | KES 1,200,000 |
| Pre-tax profit | KES 3,430,000 |
| Less: MRI tax paid | KES 495,000 |
| Net profit | KES 2,935,000 |
Section 6: Tax Summary
| Month | Rent Collected | MRI Tax (7.5%) | Paid Date |
|---|---|---|---|
| January | 570,000 | 42,750 | Feb 15 |
| February | 540,000 | 40,500 | Mar 12 |
| ... | ... | ... | ... |
| Total | 6,600,000 | 495,000 |
Section 7: Outstanding Items
- Tenant arrears carried forward: KES 150,000
- Bad debt written off: KES 75,000
- Deposits held: KES 500,000
- Pending repairs: KES 100,000
MRI vs Regular Tax: Year-End Considerations
If You Use MRI
Your year-end is simpler:
- Total monthly filings = annual obligation
- No additional annual rental return needed
- Keep records for audit support
Verify:
- All 12 months filed
- All payments made
- No pending penalties
If You Use Regular Income Tax
More complex:
- Include rental income in annual return
- Claim allowable deductions
- Calculate tax on net income
Additional documents needed:
- Full expense breakdown
- Supporting receipts
- Mortgage interest certificates
- Depreciation schedules (if applicable)
Audit Preparation
KRA may audit. Be ready.
What They Look For
Income verification:
- Bank deposits vs reported income
- M-Pesa records vs filings
- Lease amounts vs declared rent
Expense verification:
- Receipts for claimed deductions
- Legitimacy of expenses
- Connection to rental activity
Consistency:
- Patterns across years
- Relationship between properties and income
- Logical expense ratios
Documents to Keep (5 Years)
Income documentation:
- Bank statements
- M-Pesa statements
- Tenant payment records
- Lease agreements
Expense documentation:
- All invoices and receipts
- Contracts with service providers
- Proof of payment
- Photos of repairs (useful)
Tax filings:
- iTax return acknowledgments
- Payment receipts
- E-Slips
Organize by:
- Year
- Property
- Category
Digital backup essential.
Common Year-End Mistakes
Mistake 1: Missing Income
Forgetting to include:
- Late payments received in current year (for previous year)
- Cash payments
- One-off charges
Fix: Reconcile bank/M-Pesa statements against tenant records.
Mistake 2: Double-Counting
Including same income twice:
- Received in December, also counted in January
- Deposits counted as income
Fix: Use consistent cut-off dates.
Mistake 3: Missing Receipts
Can't prove expenses you claimed.
Fix: Collect and file receipts throughout the year, not just at year-end.
Mistake 4: Ignoring Bad Debt
Still showing income you'll never collect.
Fix: Write off genuinely irrecoverable amounts.
Mistake 5: Wrong Tax Calculation
MRI filed doesn't match actual income.
Fix: Reconcile filed amounts against actual collections.
Year-End Checklist
Complete before January 31st:
Income reconciliation:
- [ ] All M-Pesa rent payments identified
- [ ] All bank transfer rent payments identified
- [ ] Cash payments documented
- [ ] Total matches monthly records
- [ ] Bad debts identified and written off
Expense compilation:
- [ ] All receipts collected
- [ ] Expenses categorized
- [ ] Supporting documents organized
- [ ] Personal expenses excluded
Tax verification:
- [ ] All 12 MRI returns filed
- [ ] All payments confirmed on iTax
- [ ] No penalties outstanding
- [ ] Records retained for 5 years
Reporting:
- [ ] Summary document prepared
- [ ] Property-level analysis done
- [ ] Year-over-year comparison
- [ ] Action items for next year identified
Administrative:
- [ ] Tenant records updated
- [ ] Outstanding balances carried forward
- [ ] Deposit records accurate
- [ ] Lease renewals scheduled
Using Software for Year-End
Manual compilation takes hours. Property management software streamlines:
Automatic:
- Income totals by period, property, tenant
- Expense tracking by category
- Tax calculations
- Report generation
One-click reports:
- Annual income summary
- Monthly breakdown
- Property comparison
- KRA-compliant exports
Time saved: 8+ hours reduced to 15 minutes.
Planning for Next Year
Year-end is also planning time:
Based on this year's data:
- Which properties underperformed?
- Where did expenses exceed budget?
- Which tenants had payment issues?
- What maintenance is coming due?
For next year:
- Rent adjustment decisions
- Expense budget
- Reserve targets
- Improvement priorities
Key Takeaways
- Know your core numbers — Income, expenses, NOI, net profit
- Gather data from all sources — Bank, M-Pesa, tenant records
- Structure your summary clearly — Portfolio, property, monthly
- Verify tax compliance — All filings done, all payments made
- Prepare for audits — Keep organized records 5 years
- Avoid common mistakes — Missing income, missing receipts
- Use software if possible — Hours saved, accuracy gained
- Plan for next year — Data drives decisions
A clean year-end summary is the foundation for a profitable next year.
Generate year-end reports in minutes. KodiSawa tracks all your income and expenses throughout the year and creates summary reports with one click. Try free for 14 days.
Start Tracking Rent Today
Track every unit, tenant and rent payment in one place. Start your 14-day free trial today.
Pay Bill and Buy Goods integration built in
Manage all your properties from one dashboard
Tax-ready reports for hassle-free filing