Rental Statement Reconciliation Guide
Rental statement reconciliation means checking that a tenant’s charges, payments and closing balance agree with the supporting records. It is not enough for the spreadsheet total to match a bank balance. You need to know which tenant each payment belongs to, which period it covers and why any difference remains.
This guide uses an illustrative tenant account to show how to reconcile a rental statement across M-Pesa, bank and cash evidence. The method is a practical recordkeeping workflow, not a tax return or a substitute for professional accounting advice.
First identify which statement you are checking
A tenant statement records activity on one tenant’s account. A bank or M-Pesa statement records transactions on a receiving account. An owner statement may summarise rent collected, expenses and money remitted to the owner. They are related, but they are not interchangeable.
Write the statement type and the period at the top of the working file. A bank statement containing deposits, rent and owner transfers will not automatically equal the rent charged for that month. Likewise, an agent’s net remittance may be lower than gross collections because separately documented payments or deductions are included.
Step 1: fix the period and gather the evidence
Choose a clear start date and end date. Gather the previous closing tenant balance, the current rent schedule, approved adjustments, receiving-account statements, cash receipts and any recorded reversals. Keep a copy of the records as reviewed so a later edit does not make your reconciliation impossible to reproduce.
Use the actual payment evidence available to you. A forwarded message or screenshot is a lead to investigate; confirm it against the receiving account or other reliable collection evidence before treating it as verified money received.
Step 2: agree the opening balance
The opening balance should connect to the previous period’s closing balance. When they differ, investigate the earlier period before using a balancing adjustment. Label any unresolved opening amount clearly and retain its explanation.
Set a consistent sign convention. In this guide, a positive balance is money still due from the tenant. A negative balance is a credit on the tenant’s account. Different systems may display credit balances differently, so read the column labels before copying figures.
Step 3: check charges and genuine credits
Confirm the rent charge against the applicable tenancy records. List additional charges separately so they can be reviewed. Check that the same monthly charge was not raised twice. A credit should have a documented reason and appropriate approval; it should not be created merely to make the statement balance.
Keep security-deposit records separate from rent allocations unless an appropriate, documented adjustment is being made. Record how an advance payment is allocated, and do not apply the same receipt to more than one charge.
Step 4: match each payment to its source
Match using the reference, amount, date and payer context together. For M-Pesa and bank transfers, retain the transaction reference and explain third-party payers. For cash, use the receipt and collection record, including the person who received it. When one payment covers several units, document the split and confirm that the allocations add to the receipt.
A payment collected in cash and later deposited into the bank is one tenant payment followed by a transfer of collected money. Recording both as fresh rent would count the tenant’s payment twice.
Worked example: reconciling one rental statement
The following fictional account has a KSh 3,000 opening amount due and a KSh 15,000 rent charge. No additional charges apply.
| Entry | Charge / debit | Payment or credit | Running amount due |
|---|---|---|---|
| Opening balance | KSh 3,000 | — | KSh 3,000 |
| Current rent charge | KSh 15,000 | — | KSh 18,000 |
| Verified M-Pesa receipt SAMPLE-MP-001 | — | KSh 10,000 | KSh 8,000 |
| Verified bank receipt SAMPLE-BK-001 | — | KSh 5,000 | KSh 3,000 |
| Approved correction credit SAMPLE-CR-001 | — | KSh 500 | KSh 2,500 |
The closing amount due is KSh 3,000 + KSh 15,000 − KSh 10,000 − KSh 5,000 − KSh 500 = KSh 2,500. The KSh 500 credit changes the tenant balance, but it is not a cash receipt. Verified payment inflows in the example are KSh 15,000.
Step 5: investigate differences instead of hiding them
| Difference found | Check next | Record the resolution |
|---|---|---|
| Receipt appears twice | Compare references and source evidence | Correct the duplicate with an explanation |
| Payment is on the statement but not the ledger | Check cut-off, tenant match and prior entries | Add only a genuinely missing receipt |
| Ledger shows a payment absent from the account | Check the payment channel, evidence and reversals | Keep it unverified until explained |
| Payer name does not match the tenant | Confirm the intended unit and payment purpose | Retain the third-party payer explanation |
| Net bank credit is below gross receipt | Look for a separately evidenced charge or deduction | Separate gross amount and charge; do not guess |
For timing differences, record both the payment date shown by the source and the date used in the working ledger. Apply the same cut-off policy consistently. A receipt outside the chosen period should not be pulled into the month simply because it makes a total agree.
Step 6: review the closing balance and sign off
Recalculate the closing balance from the agreed opening amount, valid charges, payments and credits. Review unmatched receipts separately. Then record who prepared the reconciliation, who reviewed it, the review date and any remaining exception.
Keep the statement, supporting references and exception list together. Carry an unresolved item forward visibly, with a named next action. The month-end checklist can support the wider property review.
Use the result for fair tenant follow-up
Send a tenant-specific statement rather than a property-wide list containing other tenants’ information. Explain the period and balance, and provide a route for correcting a missed payment. Use the rent reminder templates only after checking the balance.
For ongoing records, compare the rent reconciliation software guide with your current method. NyumbaLedger’s bank-payment guide provides related recordkeeping context; confirm current product capabilities before depending on an automated import or connection.
Frequently asked questions
What is rental statement reconciliation?
It is the process of checking a rental account against charges, payment evidence and authorised adjustments. The aim is an explained closing tenant balance and a visible list of unresolved items.
Why does rent collected differ from rent charged?
Charges describe what was billed. Collections describe payments received. Opening arrears, part-payments, advances and the reporting cut-off can make the figures different without necessarily indicating an error.
How do I handle a payment made by a relative?
Keep the actual payer details and record the confirmed tenant and unit allocation. Do not change the tenant’s identity or allocate the payment using amount alone.
Is depositing collected cash another rent payment?
No. Once the tenant’s cash payment is recorded, depositing that money into the receiving account is a transfer of the collection. Counting both as fresh rent would duplicate the payment.
What should I do with an unmatched receipt?
Keep it on an exception list with its amount, date, reference and source. Assign someone to investigate the intended tenant and purpose. Allocate it only when the explanation is supported.
Should I create an adjustment to force a zero difference?
No. Investigate the cause first. Use a credit, reversal or correction only when it reflects a genuine, documented event with the required approval.
How do I deal with a disputed opening balance?
Keep the disputed amount visible and examine the prior closing balance and source records. Explain the unresolved issue instead of treating a new period as proof that the old amount was correct.
When is a reconciliation complete?
The reviewed figures should connect to their evidence, and every remaining exception should have an explanation or an assigned next action. Record the preparer, reviewer, date and period covered.
Related landlord guides
Rent Reconciliation Software for Landlords and Property Managers · Rent Reminder Notices and Templates · Caretaker Management Software
Choose a clearer way to keep your property records
Explore the NyumbaLedger sample demo or view the editable Landlord Starter Pack. The online workspace and downloadable toolkit are separate products. Review current details before purchasing.
Examples on this page are illustrative. Operational templates do not replace qualified legal, accounting or technical advice where it is needed.