M-Pesa Rent Reconciliation in Kenya: A Month-End Guide

On the last working day of the month, your M-Pesa statement says the portfolio received KES 492,000. Your tenant ledgers show KES 465,000 in posted receipts, and your owner report says KES 481,000. Which number should you send to the landlord? Before anyone changes a tenant balance, find out what each report measures. Each figure has a different source. The Paybill statement records money received through that channel, the tenant ledger records how payments were applied, and the owner statement reports activity for a defined property and period.

This guide shows Kenyan landlords and property agencies how to close the month when Paybill references, bank deposits and tenant records disagree. The examples use fictional units and amounts in Kenya shillings. Use them to test your current workflow or to ask a vendor to demonstrate automated rent reconciliation software against transactions that are harder than a clean, full rent payment.

If you are still deciding how tenants will pay, start with the M-Pesa rent collection setup guide. This article begins once the payment channels and billing records are already in use.

Table of Contents

Decide what each figure is supposed to answer

Your payment-channel statement answers how much the channel received and when. The tenant ledger answers who paid, what the money covered, and what remains due. The owner statement answers what happened at a property or for a specific owner in the reporting period. Start by naming all three totals. If a landlord sees one unlabeled figure called collections, they have no way of knowing whether it includes refundable deposits, a water charge or rent paid in advance.

Keep the original transaction record distinct from the allocation. The record should carry the payment channel, account or shortcode, provider receipt number, amount and transaction timestamp. An allocation should point from that record to a tenant, property, period and charge. One payment can have multiple allocations. Several payments can settle one invoice. Make sure the statement can trace both directions. Starting with a tenant balance should take you back to the receipt. Starting with a receipt should show every charge it covered.

Pick a reporting cutoff and write it on the close worksheet. An agency working in Kenya can use local time consistently across its exports, and record any timezone conversion applied to a provider file. The ledger may legitimately post an April transaction in May after review, depending on the agency’s close procedure. Save both the transaction date and the posting date so the finance lead can explain the difference when comparing exports.

Assemble the close pack before reconciling

Export the period’s M-Pesa transactions and the relevant bank statements. Include enough neighbouring dates to investigate transfers and receipts that settle across a boundary. Save unedited copies with the covered dates and source account in the filename. Restrict access to transaction files because they may contain personal information. Leave the original reference as supplied. If your matching process trims spaces, changes case or removes a delimiter, save that transformed value in a separate field.

Pull the rent roll, opening tenant balances, charges raised, receipts posted, credit notes and reversals. Ask the leasing team for move-ins, move-outs and transfers. A visible vacancy on one report and an active tenancy on another often points to an effective-date issue. Verify that the property mapping is current before spending time on individual payment exceptions. An old owner assignment can make a perfectly matched payment appear in the wrong statement.

Assign someone to prepare the close and someone to review corrections or unusual allocations where staffing allows. A small landlord who handles both jobs can still use a saved checklist and redo the comparison from the original exports before locking records. The goal is to make the decision reproducible if someone asks about it a month later.

Balance a fictional apartment before closing the whole portfolio

Assume Riverside Court opens April with KES 12,000 of tenant arrears. April invoices add KES 90,000. The preparer posts a KES 2,000 approved charge adjustment and allocates KES 82,000 in receipts to tenant charges. The closing amount due is KES 18,000. The calculation is KES 12,000 plus KES 90,000, less KES 2,000 and KES 82,000. A tenant-level sum should give the same answer as the property ledger.

The Paybill statement for the same property contains KES 79,000 of unique incoming receipts. The bank account adds KES 13,000 in direct tenant payments. Of the KES 92,000 received, KES 82,000 went to tenant charges, KES 7,000 went to refundable deposits and KES 3,000 remained unidentified. The closing pack needs both reconciliations. The first shows why tenants owe KES 18,000. The second explains where all KES 92,000 went.

Suppose a KES 70,000 M-Pesa sweep also appears in the bank account. Record the transfer in the cash movement records as appropriate and trace it back to the source account. The bank statement now has a much larger total of incoming credits, even though tenants paid exactly the same amount. Counting the sweep as fresh rent would inflate the owner report. Where payment fees are present, reconcile the difference between gross proceeds and the amount settled using the provider and bank records.

Riverside Court close worksheet

Control Calculation in KES What to verify
Closing tenant arrears 12,000 + 90,000 − 2,000 − 82,000 = 18,000 The total agrees with the individual closing tenant balances.
Unique incoming tenant payments 79,000 Paybill + 13,000 direct bank = 92,000 Each receipt appears once and the Paybill sweep is excluded from direct tenant payments.
Allocation of money received 82,000 tenant charges + 7,000 deposits + 3,000 unidentified = 92,000 The allocation schedule accounts for every shilling received, including money held outside rent.

When the figures disagree, trace individual receipts before posting any adjustment. If the channel total agrees and the allocation total falls short, look for receipts with no destination or partial allocations. If both collections totals agree but tenant balances differ, compare the opening balances, invoices and approved adjustments. Review the property and tenancy identifiers on the records that differ. A forced adjustment can hide the error from this month’s statement while carrying it into the next close.

Set the rules for automatic matching

Give each tenancy a reference that is easy to type and unique across the accounts that receive its money. Unit A05 is often insufficient when three buildings have an A05. A building code followed by a unit code can be easier to administer, but check the permitted reference length and characters with the provider. If a tenant moves out, decide how references remain traceable. Reassigning a reference too quickly can send a late payment from an old tenant to a new household.

Start with matches that are strong enough to defend. An identifiable payment, an exact reference, a single eligible tenancy and a valid account are a useful combination. An exact amount by itself is weak. Multiple households may pay KES 18,000, and a partial payment from one household may equal the full rent for another. Phone numbers help a reviewer investigate, but one payer can cover several tenancies. Agree which conditions create an automatic posting and which create a suggestion for review.

Store payment import identifiers together with event or transaction types. A repeated callback should not create a second receipt for the same event. A genuine reversal must also remain visible as a linked event, even if it refers to the same original receipt. Ask the vendor how imports, callbacks and correction files interact, and test what happens when the same file is uploaded twice.

Run the owner report only after checking the exceptions

Prepare two separate schedules for each property. The first explains amounts applied to tenant balances, including the month or charge they covered. The second explains money held outside rent, including deposits, advances and any amount awaiting identification. For an agency that handles several landlords, list only the owner’s properties on their report. Keep a consolidated reconciliation for finance with controls over who can access it.

Review owners and tenancy balances against the approved schedule before sending statements. Check whether previously reported collections were corrected in the current month, and whether deductions and disbursements follow your agreement. When an unresolved receipt might affect an owner’s figures, describe the pending issue at the appropriate level of detail and show it as pending. Save the report version that was actually sent, so that a later correction can be traced.

How to use the exception cases below

Run the cases in a demonstration account or a test spreadsheet using the fictional amounts. Keep three columns for each case. Record what the payment channel shows, what the tenant ledger should show and what the owner report should show. Ask the vendor or bookkeeper to perform the action in front of you and export the result. Screenshots of a dashboard are less informative than an audit record that names the source receipt and shows the amount assigned to each charge.

For every unresolved item, add the next action, the assigned reviewer and the date you expect a response. A useful queue is one that changes as people do work. If every item is still pending at the start of the next month, check whether staff can see enough details to resolve cases and whether there is a clear decision maker. Record the real reason for delay rather than changing the status just to make a dashboard look cleaner.

Correct amount, wrong Paybill reference

A tenant paying KES 18,000 transposes two digits in the Paybill reference and enters RC-610 instead of RC-601.

Compare the date and receipt number against the provider record. Check both tenancy records before assigning it. If RC-610 exists, establish who was billed at each unit on that date and secure independent confirmation from the tenant. A screenshot can help locate the transaction, but the provider record should establish that money reached the correct account.

Record the entered reference and the verified tenancy separately. If the wrong account was credited automatically, reverse that allocation through the correction workflow, keep the receipt and post the verified allocation once. Send corrected receipts to the parties that received inaccurate balances.

Two payments settle one invoice

A tenant pays a KES 22,000 invoice in two instalments, sending KES 10,000 on the third and KES 12,000 on the sixth.

Confirm that both receipt numbers appear in the provider export and that both belong to the same tenancy. Check the posted balance after each payment. On the third it should still show KES 12,000 due, assuming no other balance or charge. On the sixth the invoice should show fully settled.

Save both entries under the same invoice while keeping separate receipt numbers and dates. Ask whether a scheduled arrears reminder reads the latest balance immediately before sending. A reminder prepared on the third may be inaccurate if it is delivered after the second payment settles.

Overpayment to carry forward

A tenant sends KES 24,000 against a KES 21,000 invoice, leaving KES 3,000 to allocate.

Check for older charges first. Apply the agreed allocation order and document any tenant instruction that changes the default. If the extra KES 3,000 is genuinely an advance, show it explicitly. The next billing cycle should consume it according to the agreed policy and display the full invoice value as well as the amount left to pay.

Keep the remaining amount as tenant credit where appropriate. Review whether the owner statement treats advances as available for disbursement or reports them separately. Depending on the agreement and accounting practice, the owner’s report may show money in custody that does not yet belong in current-period rent.

One receipt covers rent and metered water

A KES 19,500 payment arrives for a tenancy billed KES 18,000 in rent and KES 2,300 for water.

Open the two charges and confirm the agreed priority. If rent takes priority, the water line receives KES 1,500 and KES 800 remains outstanding. A display that shows merely paid or unpaid can hide the distinction. Ask whether the tenant statement prints both allocations and the remaining water balance.

Save the meter reading and invoice as supporting records. If the water charge changes after a review, issue a dated adjustment and leave the original bill and payment allocation visible. Check the deposit balance after the adjustment to make sure the software did not move the money to an unrelated category.

Same-name payer using a different phone

A spouse sends KES 16,500 from a number that does not appear in the tenant record.

Start from the transaction reference and tenancy code. Contact the tenant through the approved channel when the reference is unclear. Confirm the specific receipt number and amount. Avoid treating the payer as a new tenant or replacing the tenant’s saved contact with the payer’s phone number.

Add a payment note or linked payer record where your system supports it. Keep third-party payer details accessible only to staff who need them. Test a case where the same payer covers two different households. A matching rule based only on payer phone will make at least one of those allocations unsafe.

Wrong building, identical unit number

A KES 27,500 payment arrives with the reference B12. Two buildings have a unit B12.

Compare the receiving account and candidate tenancies. If both use the same Paybill and both rents are KES 27,500, account and amount do not identify the correct tenant. Ask the payer or the relevant staff member for independent evidence and save the evidence with the transaction review.

Place the receipt in the unidentified queue while investigating it. Once resolved, send the household the reference it should use going forward. Test separate building codes on corrections and confirm that a payment posted to one owner never appears in another owner’s detailed statement.

Duplicate callback and statement import

A KES 18,000 receipt arrives through the automated feed and appears again in the month-end statement.

Compare provider receipt IDs before comparing amounts. The second appearance provides corroboration for the receipt already recorded. The month-end import can confirm the transaction without adding another payment. Ask that the system preserve which two sources supplied it and show the result of the duplicate check.

Re-run the same sample file and check the ledger balance, total receipts and export after the second run. They should be stable. Include one second transaction with the same amount and payer but a different receipt number. It must still be treated as a real payment.

A reversal after a receipt was issued

The provider reverses a KES 31,000 payment after the agency issues a receipt.

Verify the reversal with the channel and trace it to the original receipt. Record the reversal date and review whether it falls in a locked reporting period. Check which rent and utility lines reopen when the receipt is reversed. Notify the tenant through the normal workflow if the balance changes.

Keep the original receipt, the reversal and the resulting balance visible. If an owner statement had already included the money, show the approved correction in the agreed statement period. Where the funds were disbursed to an owner already, finance should investigate the resulting difference and document the next action.

Direct bank deposit without a tenant reference

The bank statement shows a KES 38,500 credit with a depositor name and no tenancy reference.

Search the raw bank entry for a transaction identifier and any narration carried in the downloadable file. Compare tenant advice with the actual amount, account and credit date. If two people claim it, ask for enough independent detail to distinguish them before allocating. Avoid publishing payer names in any shared group message.

Log the bank transaction in the same exception workflow as unidentified mobile money. The separate source column matters because a bank credit may look like a Paybill sweep. Once verified, attach it to the charge and show it once in the owner totals.

Paybill transfer into the operating bank account

A KES 70,000 transfer from the Paybill account appears as a credit in the operating bank account.

Trace the movement through both records. Record which batch or settlement produced the bank line, the provider amount, and any documented difference caused by charges. The original set of tenant receipts still provides the detail for the tenant ledgers.

Mark the bank credit as a movement between accounts where appropriate. Compare the gross total on the source statement with the bank credit and any fees. Verify the owner report does not count the aggregate transfer again when it groups collections by receipt channel.

Advance payment on a new tenancy

An incoming tenant sends KES 42,000 a week before the lease begins.

Break the amount down with the approved onboarding schedule. For example, KES 21,000 may be refundable deposit and KES 21,000 may be the first month’s rent paid in advance. Check the effective dates and agreed amounts against the signed records before treating either item as rent for the current period.

Assign the deposit and advance to distinct balance categories. Confirm the correct tenant gets the combined receipt with a clear breakdown. At lease start, apply the advance to the first invoice and check the deposit remains independently visible when the tenant ledger and owner statement run.

Receipts after a tenant moved out

A former tenant uses the old unit reference to pay KES 8,500 still due after moving out.

Check who occupied the unit when the charge arose. Compare the payment advice and historic tenancy record to the current tenancy. A matching rule that uses only the latest occupant may apply the payment to the wrong ledger.

Use the former tenancy’s receivable history and post the amount to the agreed charge. Keep the new household’s balance intact. Test whether your software can find archived lease records from the payment screen and whether a closed account can accept a reviewed payment without reopening the lease itself.

Payment after the statement cutoff

The provider records a KES 25,000 payment just after midnight on the first day of the next month.

Confirm the provider timestamp and timezone before placing it into a report. If your reporting procedure closes at month-end, the payment normally falls in the next extraction period. A dashboard filtered by posting date may display different results from the provider export.

Save both dates and show the tenant’s current actual balance when answering an enquiry. Preserve the owner statement’s stated cutoff. Re-run the same month using the same date basis to see whether the exported balances can be reproduced after new payments arrive.

Charge correction following a disputed meter reading

A transposed meter reading produces a KES 2,400 water bill that the tenant disputes.

Ask for the original and corrected readings, meter identifiers, dates and the basis for the tariff used. If the approved correction lowers a bill from KES 2,400 to KES 1,650, post the difference of KES 750 as a credit adjustment against the water charge.

Retain the invoice and the evidence for the correction. Verify the tenant statement displays the adjustment distinctly from a payment and that nobody changes the Paybill receipt total to force the ledger to agree. If the tenant already paid, handle the credit according to the approved policy.

Unclear split across two units

A commercial tenant sends a single KES 54,000 transfer for two premises.

Request the remittance advice and verify the entities, property identifiers and amounts. Where one unit owes KES 28,000 and another owes KES 26,000, those two allocations add to the receipt. If the amounts do not fit, hold the unresolved part for review and continue only where you can substantiate the rest.

Check how the reports present a shared receipt. An owner with one of the properties needs only the relevant allocation. The finance reviewer needs the original KES 54,000 bank record and a way to see both allocations add back to it.

Opening balance from an Excel migration

After a migration from Excel, a tenant challenges KES 14,300 in opening arrears and says they already paid.

Compare the last approved workbook, old receipts and the opening ledger import. Confirm the cutoff and check whether the payment was omitted from the workbook or duplicated as an opening balance. A common error is importing an outstanding total plus the historical charges that already produced it.

Document the cause before requesting an adjustment. Review the landlord statement and the other tenancies imported from the same sheet. If the migration formula was wrong, an individual correction can resolve one dispute while leaving other tenant balances overstated.

Partial refund of an overpayment

A tenant has an unapplied credit and the team approves a KES 5,000 refund.

Confirm the credit on the tenant ledger and the original receipt. Check that no outstanding charges should be cleared under the agreed procedure before making the refund. Verify recipient details through the authorised workflow and obtain the appropriate approval.

Record the original payment, refund date, destination reference and effect on the credit. The outgoing amount should trace to the bank or payment provider. Test the owner statement for the refund month if the original receipt appeared in a prior reporting period.

Arrears notice queued before a payment clears

A rent reminder quoting KES 12,000 is queued just before the tenant makes a payment.

Recalculate the balance immediately before sending the message. If the provider has received the payment but the reference is under review, check the exception queue before chasing an identified household. If KES 8,000 has been confirmed against KES 12,000, the stated amount should reflect the remaining KES 4,000.

Use the notification log to show which balance and cutoff the SMS or WhatsApp reminder used. Keep payment references and other personal particulars out of broad distribution. If a message did go out with the wrong amount, reply with the verified balance and preserve the correction.

Build a five-day closing schedule

Day 1. Export and freeze the working inputs

Collect the files from each source and write down the number of transactions and the signed total per file. A signed total treats incoming and outgoing amounts with their correct signs. A file with 110 credits and three refunds needs both sets checked, even if the net happens to agree with a dashboard. If your branch receives cash, gather sequential receipt records and the corresponding deposit or custody records according to your process. Keep cash distinct in the channel summary so the team can verify where funds are held.

Review opening balances against the previous signed close. Investigate any difference before working on current-month postings. A good test is to export the old period again and compare it to the signed version. If transaction IDs are available, compare the sets as well as the totals. Two equal and opposite edits can leave the same headline figure while creating wrong tenant balances.

Day 2. Match the straightforward receipts

Apply the agreed exact-match rules. Check a sample against the original statements and vary the sample across buildings, payment amounts and tenant history. Review the full list of automatically allocated payments when the rules are new or when a reference pattern has changed. A KES 10,000 receipt matched to an active account can still be wrong if a tenant was transferred and the payer is using a saved reference from months earlier.

Reconcile controls at each stage. Start with the sum of unique incoming receipts. Subtract the reversals and outgoing refunds relevant to the control. Separate transfers. Then account for tenant charge allocations, deposits, unapplied advances and pending identifications. Differences should have identifiable transaction IDs. Record who reviewed each step and when. When several properties use different channels, compare per property and per channel before relying on a single portfolio total.

Day 3. Resolve high-impact exceptions

Prioritise obvious owner-statement errors, duplicate allocations, reversed payments and amounts old enough to be missed in day-to-day work. Unidentified receipts still count as money received. Their uncertainty concerns the customer or purpose. Use an ageing field that starts at the original receipt date, and review both value and count. A queue with only two items can be material if one is a large commercial payment.

Protect tenant service during this stage. Decide who handles objections and how they can search the receipt register. Staff who communicate with tenants need to see accurate balances and the status of disputed payments. They do not necessarily need unrestricted access to files for all owners. Log which evidence cleared an exception so the team does not repeat the same investigation when the next statement is queried.

Day 4. Tie out reporting by property and owner

Keep the property list in the owner statement consistent with management mandates and applicable dates. Compare reporting totals to each property schedule. Where an owner needs more than one building rolled up, provide a building-level subtotal and retain the source schedules. Check whether deposits, credits and receipts applied to old balances are grouped separately from current rent. Read the statement as the owner would. If they can see an amount but cannot tell why it is different from the payments in the bank, a short transaction note can prevent a long follow-up.

Prepare an internal reviewer pack with unresolved items and proofs for adjustments. Ask the reviewer to pick an owner amount and trace it all the way back, then select one source receipt and trace forward. Doing both checks reveals different problems. A backward check can catch an unsupported owner figure. A forward check can catch a receipt that never reached an owner or tenant schedule.

Day 5. Sign off, save versions and assign follow-up

Record the reporting period, files used, settings, person preparing and person approving. Save the owner statement version sent and the unresolved queue at the same cutoff. Store the files securely with access appropriate to the staff involved. Assign next actions to named roles and define the policy for changes after close. Some teams permit approved corrections dated in the next period, while others reopen the affected period and reissue reports where appropriate.

Discuss exceptions that keep recurring. Sending instructions to tenants who enter a unit-only reference may solve more problems than introducing another matching rule. Where the bank export consistently omits a needed field, ask for an alternative file format. Track the median time from receipt to posting and the value of items open at sign-off. A fall in unmatched counts is only useful if tenant balances and owner statements stay accurate.

Ask software vendors for evidence from your own test file

Take three anonymised Paybill receipts, a direct bank payment and one correction into your demo. Include a combined rent and water allocation, a refund or reversal, and a former tenant using an old reference. Ask the vendor to create a second property with the same unit number. Run the same import twice. Capture the before-and-after open balances, unapplied credits and owner reports. A team evaluating rental management software in Kenya should be able to open those exports without relying on the vendor’s live demo environment.

Check where payments are received and which accounts must be configured. Ask how the integration receives transactions, how delayed events are recovered and which reports reconcile to the payment provider. Confirm whether you can export records if you switch systems. Ask how users are authorised to allocate an unmatched payment, reverse a ledger entry, run landlord statements or change an existing tenancy reference. Request the actual costs for the setup you tested, including migration, user access, maintenance and any separate charges for payment or notification services.

If you manage multiple buildings, pilot one building with enough variety to test the rules and a trained person who can handle exceptions. Run one period alongside your current close. Reconcile both sets of opening and closing balances and document every difference. After approval, roll out the reference format and close procedure to the remaining properties. For a small landlord, the same pilot can start with a single unit and one duplicate import rather than an entire building.

Questions Kenyan property teams ask about rent reconciliation

Can I close the month with unmatched M-Pesa receipts?

You can finish a close with unresolved receipts if your reporting process allows it and the control accounts explain where the funds sit. Record each item, the underlying payment evidence and the next investigation step. Only allocate it to a tenant and include it in the appropriate rent totals once you can verify the match.

Why does a landlord’s statement differ from the bank deposit?

A bank deposit may represent a settlement covering several properties, or the balance after charges. It may include deposits, funds in transit or receipts belonging to another reporting period. Trace the owner statement through its property schedule to the original receipts and reconcile the settlement separately.

Can the same solution reconcile both M-Pesa and bank payments?

Ask which banks and payment arrangements the vendor supports for your account. Some workflows import a statement for review while others connect a feed. The important test is whether both channels can appear in the same reconciliation report without duplicating a Paybill sweep or losing the original receipt reference.

Will automation eliminate payment exceptions?

Automation can post clear matches and flag receipts that need attention. People still need to make decisions about wrong references, disputed balances and approved reversals. Check how easy it is to review those decisions after closing the month. A complete audit history becomes especially valuable when a tenant moves out or an agency hands an owner’s records back.

Evaluate the process with PMS.co.ke

PMS.co.ke lists M-Pesa and bank reconciliation, tenant and lease management, and owner statements among its property management features. If you are comparing systems, bring one fictional payment batch with a wrong reference, a partial payment, a deposit and a bank settlement. Ask to see how the same transactions appear in the tenant ledger and owner report. Explore PMS.co.ke and confirm the payment channels, reporting options and setup for your portfolio.

Include the person who prepares the monthly owner statements in the demonstration. Ask them to reproduce the totals using the files they can actually export. If they need the vendor to explain a figure, record which source or breakdown was missing and ask to see how it can be retrieved before committing to a rollout.