Creating Monthly Rent Collection Reports: What Every Landlord Should Track
"How much did I actually make last month?"
Simple question. Most landlords can't answer it accurately.
They know roughly how much rent came in. But actual net income? After vacancies, arrears, and expenses? That's guesswork.
A monthly report changes this. It turns scattered information into actionable insight.
Here's how to create one.
Table of Contents
- Why Monthly Reports Matter
- The Essential Metrics
- Report Structure
- Reporting Structure
- Creating the Report
- Reading Your Report
- Comparing Across Time
- Reporting for Property Managers
- Using Reports for Decisions
- Report Distribution
- Common Reporting Mistakes
- Simple Monthly Report Template
- Key Takeaways
Why Monthly Reports Matter
Running rental properties without reports is like driving without a dashboard.
What reports reveal:
- Actual collection rate (not assumed)
- Problem tenants before they become disasters
- Properties underperforming relative to others
- Seasonal patterns
- Progress over time
Without reports:
- You think you're collecting 95% when it's 80%
- Small arrears compound unnoticed
- You can't compare properties objectively
- Decision-making is based on feeling, not facts
The Essential Metrics
Your report should track these core numbers:
1. Gross Rent Expected
What you should collect if all units were occupied and paid.
Calculation:
Example:
- Unit A1: KES 25,000
- Unit A2: KES 25,000
- Unit A3: KES 30,000
- Unit A4: KES 30,000
- Gross expected: KES 110,000
2. Rent Collected
What actually came into your account.
Calculation:
Include:
- M-Pesa payments
- Bank transfers
- Cash (if documented)
- Cheques (when cleared)
3. Collection Rate
The key performance indicator.
Calculation:
Example:
- Expected: KES 110,000
- Collected: KES 95,000
- Collection rate: 86.4%
Benchmarks:
- Excellent: 95%+
- Good: 90-95%
- Concerning: 85-90%
- Problem: Below 85%
4. Occupancy Rate
What percentage of units are occupied.
Calculation:
Example:
- Total units: 10
- Occupied: 9
- Occupancy: 90%
5. Outstanding Balance
Total arrears across all tenants.
Calculation:
Track both:
- Current month arrears
- Accumulated arrears (previous months)
6. Vacancy Loss
Revenue lost to empty units.
Calculation:
7. Net Operating Income
What you actually kept.
Calculation:
Operating expenses include:
- Caretaker salary
- Repairs and maintenance
- Service charges
- Insurance
- Management fees
- Utilities (if landlord-paid)
Report Structure
Organize your report clearly:
Section 1: Summary
One-page overview:
| Metric | This Month | Last Month | Change |
|---|---|---|---|
| Gross Expected | KES 550,000 | KES 550,000 | 0% |
| Collected | KES 510,000 | KES 495,000 | +3% |
| Collection Rate | 92.7% | 90.0% | +2.7% |
| Occupancy | 96% | 94% | +2% |
| Outstanding | KES 85,000 | KES 100,000 | -15% |
| NOI | KES 420,000 | KES 405,000 | +3.7% |
Section 2: Property Breakdown
Per-property performance:
| Property | Expected | Collected | Rate | Occupancy |
|---|---|---|---|---|
| Sunrise Apt | KES 200,000 | KES 195,000 | 97.5% | 100% |
| Westview | KES 180,000 | KES 160,000 | 88.9% | 90% |
| Garden Court | KES 170,000 | KES 155,000 | 91.2% | 100% |
This reveals which properties need attention.
Section 3: Tenant Status
Individual tenant breakdown:
| Unit | Tenant | Rent | Status | Balance | Days Late |
|---|---|---|---|---|---|
| A1 | J. Kamau | 25,000 | Paid | 0 | - |
| A2 | M. Wanjiku | 25,000 | Paid | 0 | - |
| A3 | P. Odhiambo | 30,000 | Partial | 15,000 | 12 |
| A4 | - | 30,000 | Vacant | - | - |
Section 4: Arrears Detail
Focus on outstanding balances:
| Tenant | Current | 30 Days | 60 Days | 90+ Days | Total |
|---|---|---|---|---|---|
| P. Odhiambo | 15,000 | 30,000 | 0 | 0 | 45,000 |
| S. Maina | 25,000 | 0 | 0 | 0 | 25,000 |
| K. Njeri | 0 | 15,000 | 15,000 | 0 | 30,000 |
Aging shows severity. 90+ days needs urgent action.
Section 5: Expenses
What went out:
| Category | Amount | % of Rent |
|---|---|---|
| Caretaker | KES 25,000 | 4.5% |
| Repairs | KES 35,000 | 6.4% |
| Service charge | KES 20,000 | 3.6% |
| Utilities | KES 8,000 | 1.5% |
| Other | KES 5,000 | 0.9% |
| Total | KES 93,000 | 16.9% |
Section 6: Incidents and Notes
Narrative summary:
- Major maintenance completed
- Tenant issues
- Lease changes
- Planned expenditures
- Market observations
Reporting Structure
Section 1: Summary
One-page overview:
| Metric | This Month | Last Month | Change |
|---|---|---|---|
| Gross Expected | KES 550,000 | KES 550,000 | 0% |
| Collected | KES 510,000 | KES 495,000 | +3% |
| Collection Rate | 92.7% | 90.0% | +2.7% |
| Occupancy | 96% | 94% | +2% |
| Outstanding | KES 85,000 | KES 100,000 | -15% |
| NOI | KES 420,000 | KES 405,000 | +3.7% |
Section 2: Property Breakdown
Per-property performance:
| Property | Expected | Collected | Rate | Occupancy |
|---|---|---|---|---|
| Sunrise Apt | KES 200,000 | KES 195,000 | 97.5% | 100% |
| Westview | KES 180,000 | KES 160,000 | 88.9% | 90% |
| Garden Court | KES 170,000 | KES 155,000 | 91.2% | 100% |
This reveals which properties need attention.
Section 3: Tenant Status
Individual tenant breakdown:
| Unit | Tenant | Rent | Status | Balance | Days Late |
|---|---|---|---|---|---|
| A1 | J. Kamau | 25,000 | Paid | 0 | - |
| A2 | M. Wanjiku | 25,000 | Paid | 0 | - |
| A3 | P. Odhiambo | 30,000 | Partial | 15,000 | 12 |
| A4 | - | 30,000 | Vacant | - | - |
Section 4: Arrears Detail
Focus on outstanding balances:
| Tenant | Current | 30 Days | 60 Days | 90+ Days | Total |
|---|---|---|---|---|---|
| P. Odhiambo | 15,000 | 30,000 | 0 | 0 | 45,000 |
| S. Maina | 25,000 | 0 | 0 | 0 | 25,000 |
| K. Njeri | 0 | 15,000 | 15,000 | 0 | 30,000 |
Aging shows severity. 90+ days needs urgent action.
Section 5: Expenses
What went out:
| Category | Amount | % of Rent |
|---|---|---|
| Caretaker | KES 25,000 | 4.5% |
| Repairs | KES 35,000 | 6.4% |
| Service charge | KES 20,000 | 3.6% |
| Utilities | KES 8,000 | 1.5% |
| Other | KES 5,000 | 0.9% |
| Total | KES 93,000 | 16.9% |
Section 6: Incidents and Notes
Narrative summary:
- Major maintenance completed
- Tenant issues
- Lease changes
- Planned expenditures
- Market observations
Creating the Report
Manual Method (Spreadsheet)
- Set up template with sections above
- Collect data from:
- M-Pesa statements
- Bank statements
- Cash records
- Expense receipts
- Enter data for the month
- Calculate metrics using formulas
- Review and analyze
- Save and archive
Time required: 2-4 hours/month for medium portfolio
Automated Method
Property management software generates reports automatically:
- Pulls payment data from connected sources
- Calculates all metrics
- Compares to previous periods
- Exports in standard formats
Time required: Minutes to review
Reading Your Report
Numbers without interpretation are useless. Ask these questions:
Collection Rate Dropped?
Ask:
- Which tenants are responsible?
- Is it one problem or spread across many?
- Same pattern last year (seasonal)?
- Any changes in employment market?
Action:
- Intensify follow-up on specific tenants
- Review screening process
- Consider market rent adjustment
Occupancy Dropped?
Ask:
- How long have units been vacant?
- Is pricing competitive?
- Any issues with the property?
- Marketing working?
Action:
- Review market rates
- Improve listing/photos
- Address property issues
- Offer move-in incentives
Expenses Spiked?
Ask:
- One-time or recurring?
- Necessary or avoidable?
- Could have been prevented?
Action:
- Adjust budget if recurring
- Improve preventive maintenance
- Review vendor pricing
Arrears Growing?
Ask:
- Same tenants or new?
- Are payment plans being followed?
- Time for legal action?
Action:
- Escalate collection efforts
- Consider eviction
- Improve screening for future
Comparing Across Time
Single month reports have limited value. Trends matter more.
Track over 12 months:
- Collection rate by month
- Occupancy patterns
- Expense ratio
- NOI trend
Look for:
- Seasonal patterns (December usually low)
- Improvement or decline trends
- Correlation between changes and actions
Reporting for Property Managers
If you manage properties for others, reports are mandatory:
Owner report should include:
- All standard metrics
- Comparison to agreed benchmarks
- Explanation of variances
- Upcoming concerns
- Recommended actions
Frequency:
- Monthly summary
- Quarterly detailed review
- Annual performance analysis
Transparent reporting builds owner trust.
Using Reports for Decisions
Reports should drive action:
Rent increases:
- Compare your rates to market
- Check occupancy after increases
- Track impact on collection
Property improvements:
- Calculate ROI based on rent potential
- Compare to current yield
- Prioritize by impact
Portfolio expansion:
- Analyze performance of existing properties
- Set acquisition criteria based on data
- Project returns realistically
Divestment:
- Identify consistently underperforming properties
- Calculate true return (including your time)
- Consider selling or changing strategy
Report Distribution
Who sees your reports?
You (always):
- Full detail
- All properties
- Action items
Property manager (if applicable):
- Properties they manage
- Their performance metrics
- Issues requiring attention
Property owners (if managing for others):
- Their properties only
- Agreed metrics
- Context and recommendations
Accountant/Tax advisor:
- Income summary
- Expense categories
- KRA-compliant formats
Common Reporting Mistakes
Mistake 1: Not Doing It
"I know how my properties are doing."
No, you think you do. Data often surprises.
Mistake 2: Too Complex
A 20-page report with 50 metrics is useless. Focus on what matters.
Mistake 3: No Comparison
Single month numbers mean little. Compare to:
- Previous month
- Same month last year
- Your targets
Mistake 4: No Action
Reports that sit in a folder change nothing. Each report should generate at least one action item.
Mistake 5: Inconsistent Timing
Reports on random dates make comparison hard. Pick a date and stick to it (e.g., 15th of each month for previous month).
Simple Monthly Report Template
If you're starting from scratch:
Start simple. Add complexity as needed.
Key Takeaways
- Track the right metrics — Collection rate, occupancy, arrears, NOI
- Structure consistently — Same format every month
- Compare over time — Single months mean little
- Ask "why" — Numbers without context are just numbers
- Drive action — Reports should create decisions
- Automate if possible — Manual reporting doesn't scale
- Share appropriately — Right information to right people
What gets measured gets managed. Start measuring.
Generate rent collection reports automatically. KodiSawa tracks all payments and expenses, then creates reports with one click. See your true performance. 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