Bank Statement Reconciliation for Kenyan Landlords: A Practical Guide

Not all rent comes through M-Pesa.

Some tenants — especially corporate ones and high-end residential — prefer bank transfers. EFT. Standing orders. The occasional cheque (yes, those still exist).

And while bank payments are more traceable than cash, they come with their own reconciliation challenges.

Here's how to handle them.

Table of Contents

• Why Bank Reconciliation Matters
• Types of Bank Payments You'll Receive
  • 1. EFT (Electronic Funds Transfer)
  • 2. Standing Orders
  • 3. RTGS (Real Time Gross Settlement)
  • 4. Cheques
  • 5. Mobile Bank Transfers
• The Reconciliation Process
  • Step 1: Download Your Statement
  • Step 2: Separate Rent from Non-Rent
  • Step 3: Match to Tenant Records
  • Step 4: Record in Your System
  • Step 5: Update Tenant Balances
  • Step 6: Investigate Unmatched Payments
• Common Reconciliation Problems
  • Problem 1: No Reference Provided
  • Problem 2: Payment From Unknown Sender
  • Problem 3: Standing Order Not Updated
  • Problem 4: Bounced Cheque
  • Problem 5: Same Name, Multiple Tenants
• Building a Better System
  • Clear Payment Instructions
  • Collect Multiple Contact Points
  • Encourage Standing Orders
  • Monthly Payment Confirmations
• Bank Reconciliation vs M-Pesa Reconciliation
• Multi-Currency Considerations
• Tax and Audit Readiness
• Software vs Spreadsheets
• Monthly Reconciliation Checklist
• Key Takeaways

Why Bank Reconciliation Matters

Bank statements don't lie. But they also don't explain themselves.

A typical landlord's monthly bank statement might show:

• 15 incoming transfers
• 8 with clear references (tenant name or unit)
• 5 with cryptic references ("SALARY", "PAYMENT", random numbers)
• 2 with no reference at all

Which payments are rent? Which are personal? Which tenant does "TRANSFER FROM J OCHIENG" belong to — you have three J Ochiengs.

Without proper reconciliation:

• You might think a tenant hasn't paid when they have
• You might miss a shortfall
• Tax records become unreliable
• Cash flow projections are guesswork

Types of Bank Payments You'll Receive

1. EFT (Electronic Funds Transfer)

Most common. Tenant initiates transfer from their bank to yours.

Characteristics:

• Usually clears same day or next day
• Reference field available (but often unused)
• Shows sender's name and bank

Challenge: Tenant names on bank accounts may not match lease names (spouse's account, company account, etc.)

2. Standing Orders

Tenant sets up automatic monthly transfer.

Characteristics:

• Same amount, same date each month
• Very reliable once set up
• Reference usually includes unit or tenant name

Challenge: When rent increases, standing orders need updating. Tenants forget.

3. RTGS (Real Time Gross Settlement)

For large amounts (typically above KES 1 million).

Characteristics:

• Instant settlement
• Higher fees
• Mostly corporate tenants

Challenge: Usually fine, but corporate names may not match tenant names.

4. Cheques

Becoming rare but still used by some corporate tenants and older individuals.

Characteristics:

• Takes 3-5 days to clear
• Can bounce
• Physical handling required

Challenge: Bounced cheques, delays, additional bank visits.

5. Mobile Bank Transfers

KCB M-Pesa, Equity EazzyPay, etc.

Characteristics:

• Initiated from phone
• Often shows phone number, not name
• Fast clearing

Challenge: Name/phone matching issues similar to M-Pesa.

The Reconciliation Process

Step 1: Download Your Statement

Get the official bank statement for the reconciliation period.

Options:

• Internet banking portal (PDF or CSV)
• Mobile app export
• Branch request (takes longer)

Tip: CSV format is easier to work with if you use spreadsheets.

Step 2: Separate Rent from Non-Rent

Before matching to tenants, separate rental income from other deposits.

Create three categories:

• Confirmed rent — Clear reference to tenant/unit
• Probable rent — Likely rent but needs verification
• Non-rent — Personal deposits, refunds, other business

Mark each transaction. This prevents double-counting and missed income.

Step 3: Match to Tenant Records

For each rent payment, identify the tenant:

Easy matches:

• Reference says "UNIT A1" or "JOHN KAMAU A1"
• Amount matches exact rent for a unit
• Sender name matches lease

Harder matches:

• Sender name is spouse/relative
• Reference is cryptic or missing
• Amount is partial or different from expected

Techniques for hard matches:

• Check amount against all outstanding balances
• Look up sender name in tenant records
• Compare to previous months' payment patterns
• Contact tenant to confirm

Step 4: Record in Your System

Once matched, record:

• Date received
• Amount
• Payment method (EFT, standing order, etc.)
• Tenant/unit
• Reference number
• Any notes (e.g., "Paid from spouse account")

Whether you use spreadsheets or property management software, consistent recording matters.

Step 5: Update Tenant Balances

After recording payments:

• Reduce outstanding balances
• Note any overpayments (apply to future rent or hold as credit)
• Flag underpayments for follow-up

Step 6: Investigate Unmatched Payments

Some payments won't match. For each:

1. Check amount — Does it match any invoice?
2. Check timing — Is someone catching up on arrears?
3. Check sender — Any connection to existing tenants?
4. Contact sender — If you have their details from the bank
5. Hold as unallocated — If truly unidentifiable, don't book as rent

Unallocated funds should be minimal. If you regularly have many unmatched payments, your payment instruction system needs improvement.

Common Reconciliation Problems

Problem 1: No Reference Provided

Tenant sends EFT but doesn't include reference.

Solutions:

• Match by amount and timing
• Check sender name against records
• Ask tenant to send payment confirmation
• Remind all tenants to include unit number in transfers

Problem 2: Payment From Unknown Sender

"MARY NJOKI" sends KES 25,000. You have no Mary Njoki.

Solutions:

• Check if amount matches any unit's rent
• Ask your tenants if anyone paid through someone else
• Contact the sender's bank (difficult but possible)
• Hold as unallocated until clarified

Problem 3: Standing Order Not Updated

Rent increased from KES 25,000 to KES 27,000. Tenant's standing order still sends KES 25,000.

Solutions:

• Record partial payment
• Contact tenant immediately
• Request they update standing order and send the KES 2,000 difference
• Consider requiring annual standing order reviews

Problem 4: Bounced Cheque

Cheque was deposited, initially appeared to clear, then reversed.

Solutions:

• Contact tenant immediately
• Request alternative payment (EFT or M-Pesa)
• Add cheque bounce fee per lease terms
• Consider banning cheques from this tenant

Problem 5: Same Name, Multiple Tenants

"J. OCHIENG" could be John Ochieng in A3 or James Ochieng in B7.

Solutions:

• Check amounts (different rents?)
• Check banks (different banks?)
• Contact both tenants to confirm
• Request more specific references going forward

Building a Better System

Prevention beats reconciliation. Here's how to minimize matching problems:

Clear Payment Instructions

Give every tenant specific instructions:

BANK TRANSFER INSTRUCTIONS

Bank: [Your Bank]
Branch: [Branch Name]
Account Name: [Your Name/Company]
Account Number: [Number]
Reference: [UNIT NUMBER] (e.g., A1)

Please ensure your reference includes your unit number.

BANK TRANSFER INSTRUCTIONS

Bank: [Your Bank]
Branch: [Branch Name]
Account Name: [Your Name/Company]
Account Number: [Number]
Reference: [UNIT NUMBER] (e.g., A1)

Please ensure your reference includes your unit number.

Collect Multiple Contact Points

At lease signing, record:

• Primary bank account name
• Secondary payers (spouse, company)
• Phone numbers for all payers

When unexpected names appear, you can match them.

Encourage Standing Orders

Standing orders are the most reliable bank payments:

• Same amount, same date
• Once set up, no tenant action needed
• Easy to reconcile (pattern is predictable)

Help tenants set them up. Provide bank details on a card.

Monthly Payment Confirmations

Send monthly statements to tenants:

• Shows payments received
• Shows any balance due
• Gives tenants chance to dispute or clarify

This catches mismatches early.

Bank Reconciliation vs M-Pesa Reconciliation

Different challenges, different approaches:

Many landlords receive both. Your reconciliation process should handle both, ideally in one integrated system.

Multi-Currency Considerations

For landlords with foreign tenants or diaspora payments:

USD/EUR/GBP transfers:

• Usually go through SWIFT
• May take 2-3 days
• Bank converts at their rate
• Conversion amount may not match expected rent

Solutions:

• Set rent in KES
• Accept forex variations within reasonable range
• Or set rent in foreign currency and accept KES equivalent

Document your forex policy clearly in leases.

Tax and Audit Readiness

Bank reconciliation creates tax-ready records:

For MRI/Regular tax:

• Total rental income is clearly documented
• Payment dates are verifiable
• Source of funds is traceable

During KRA audit:

• Bank statements are primary evidence
• Matched reconciliation shows organized records
• Unallocated funds raise questions — minimize them

Keep reconciliation records for at least 5 years.

Software vs Spreadsheets

When does software pay off?

Spreadsheets work if:

• Under 15 units
• Mostly bank transfers (less matching complexity)
• You enjoy manual work
• Time isn't a constraint

Software makes sense if:

• Over 15 units
• Mixed payment methods (M-Pesa + bank + cash)
• Multiple properties
• You value your time
• You want automatic matching

The crossover point varies. Most landlords find that beyond 20-30 units, manual reconciliation is unsustainable.

Monthly Reconciliation Checklist

Use this every month:

Day 1-5 of month:

• [ ] Download bank statement for previous month
• [ ] Separate rent from non-rent deposits
• [ ] Match clear payments to tenants
• [ ] Investigate ambiguous payments

Day 6-10:

• [ ] Contact tenants for unmatched payments
• [ ] Update tenant balances
• [ ] Identify non-payers
• [ ] Send reminders

Day 15:

• [ ] Final reconciliation
• [ ] All payments allocated or marked unallocated
• [ ] Arrears list finalized
• [ ] Escalation actions for non-payers

End of month:

• [ ] Archive records
• [ ] Generate income summary
• [ ] Note any process improvements needed

Key Takeaways

1. Download statements promptly — Don't let months stack up
2. Separate rent from personal — Tag every transaction
3. Match by multiple criteria — Amount, name, timing, pattern
4. Investigate unknowns immediately — Fresh trails are easier to follow
5. Standardize payment instructions — Reference field is your friend
6. Encourage standing orders — Most reliable bank payment method
7. Keep records for 5 years — Tax compliance requirement

Bank payments are supposed to be easier than cash. With a proper system, they are.

Managing bank payments across multiple properties? KodiSawa imports bank statements and matches payments to tenants automatically. See who paid at a glance. Try free for 14 days.