Service Charge Reconciliation System Kenya: Why Balances Drift and How to Stop Them
Service charge reconciliation system Kenya is the answer to a question every estate treasurer eventually asks: how can the ledger say one thing, the Paybill statement say another, and the bank say a third? The answer is that three records are kept by three different processes and nobody has been making them agree.
A resident pays by M-Pesa with the wrong reference and the money sits in the Paybill statement attributed to nobody. The caretaker takes cash, writes a receipt, and banks it three days later in a lump with other receipts. A resident pays twice by mistake and the second payment is recorded as March’s charge cleared early.
A transaction is reversed and the ledger still shows it. Someone applies a payment to the wrong unit. By month end the ledger’s total collected does not match what reached the bank, the difference cannot be explained, and every resident whose balance is affected by one of those errors is now in dispute with an estate that cannot show its own arithmetic.
That is drift, and it is not caused by dishonesty or incompetence — it is caused by the absence of a routine that matches every payment to a resident and an invoice, every day, and closes the month when the three records agree.
This guide covers that routine: the three records, payment sources, matching by reference, phone and amount, the suspense account and clearing it, partials, overpayments, duplicates and reversals, cash and banking, charges and timing differences, allocation and invoice status, daily discipline and month-end close, locking periods, bank and Paybill reconciliation, exceptions, roles and the treasurer’s protection, the audit trail, migration, multi-estate structures and reporting.
The value of a service charge reconciliation system Kenya is that the ledger, the Paybill and the bank agree, and a service charge reconciliation system Kenya that matches payments as they arrive rather than at year end is what keeps every resident statement true — which is why a service charge reconciliation system Kenya is the control underneath every other control.
Table of Contents
- Why Balances Drift
- The Kenyan Context
- What Reconciliation Actually Is
- The Three Records: Ledger, Paybill and Bank
- Payment Sources
- Matching by Reference
- Matching by Phone Number
- Matching by Amount and Timing
- The Suspense Account
- Clearing Suspense
- Partial Payments
- Overpayments and Credits
- Duplicate Payments
- Reversals and Failed Transactions
- Cash Receipts and Banking
- Charges and Net Amounts
- Timing Differences
- Applying Payments to Invoices
- Invoice Status
- Daily Reconciliation
- Month-End Close
- Locking Periods
- Bank Statement Reconciliation
- Paybill Statement Reconciliation
- Exceptions and Investigation
- Who Reconciles
- The Treasurer’s Protection
- The Audit Trail
- Migration and the First Reconciliation
- Multi-Estate Reconciliation
- The Reconciled Position Report
- Reconciliation and Statements
- Data Protection
- Systems and Costs
- Frequently Asked Questions
Why Balances Drift {#why-drift}
Drift has identifiable causes and each is a missing match.
A payment received but not attributed to any resident.
A payment attributed to the wrong resident.
A payment attributed to the right resident but the wrong invoice.
A payment recorded twice.
A payment recorded that was later reversed.
Cash received and not recorded until banked, or banked and not recorded.
A charge raised twice.
An adjustment made without a record.
A bank charge or M-Pesa fee reducing the net without the ledger reflecting it.
None requires bad faith, since a service charge reconciliation system Kenya exists precisely because ordinary volume produces these errors at a rate that accumulates, and a service charge reconciliation system Kenya that catches each one the day it occurs keeps the accumulation at zero.
The Kenyan Context {#kenyan-context}
Local conditions make reconciliation both harder and more necessary.
M-Pesa is the primary channel and references are frequently wrong, missing or freeform.
Residents pay from phones not registered to them, including spouses, relatives and employees.
Cash persists, particularly with caretakers and older residents.
Bank deposits arrive with narrations that identify nobody.
Committees are volunteers with limited time and the treasurer is frequently untrained.
Spreadsheets are the ledger in most estates and they are edited by whoever has them.
Developer handover leaves opening balances that were never reconciled.
Committee turnover means the person who knew where the money went has left.
Residents contest balances at meetings and the estate cannot prove its figures.
M-Pesa and bank charges reduce what arrives and are rarely accounted for.
Each is what a service charge reconciliation system Kenya must handle, and a service charge reconciliation system Kenya built around phone-number matching, suspense and daily routine addresses the specific ways money goes unmatched here.
What Reconciliation Actually Is {#what-is}
Precision about the task prevents it being confused with bookkeeping generally.
Reconciliation is confirming that independent records of the same money agree.
The ledger says a resident paid; the Paybill statement shows the transaction; the bank shows the settlement.
Each payment is matched across the records.
Each difference is identified and explained.
The period is closed when everything matches or every difference has a documented reason.
It is not recording payments, though recording is its input.
It is not chasing arrears, though it makes arrears figures true.
It is the check that the figures being acted on are real.
The distinction matters, since a service charge reconciliation system Kenya that records payments without confirming them against the Paybill and the bank has bookkeeping without reconciliation, and a service charge reconciliation system Kenya that performs the match has the assurance the bookkeeping alone does not.
The Three Records: Ledger, Paybill and Bank {#three-records}
Three records exist for most estate payments and they should be treated as three witnesses.
The estate’s ledger, where charges and payments are recorded per resident.
The Paybill or Till statement from the mobile money provider, showing every transaction received.
The bank statement, showing settlements from the Paybill and direct deposits.
Cash receipts as a fourth where cash is taken, reconciled to banking.
The ledger is what the estate believes; the Paybill and bank are what happened.
Ledger to Paybill confirms every M-Pesa payment was recorded and every recorded M-Pesa payment exists.
Paybill to bank confirms settlements arrived.
Ledger to bank confirms the whole.
All three must agree, since a service charge reconciliation system Kenya that reconciles only ledger to bank will miss a Paybill transaction recorded against the wrong resident, and a service charge reconciliation system Kenya that reconciles all three catches it.
Payment Sources {#sources}
Each source has its own record and its own failure modes.
M-Pesa Paybill, with an account reference the resident enters.
M-Pesa Till, with no reference field, matched by phone.
Bank transfer or deposit, with a narration.
Cash to the caretaker or treasurer, with a receipt.
Cheque, rarely.
Each arrives with different identifying information, and a service charge reconciliation system Kenya that knows which source a payment came from applies the right matching method, since a service charge reconciliation system Kenya treating a Till payment with no reference like a Paybill payment with one will fail to match what it could have matched by phone.
Minimise sources where possible, since every additional channel is another record to reconcile.
Matching by Reference {#by-reference}
The account reference is the intended matching key and the least reliable one.
The resident enters a reference when paying: a unit number, a name or an account code.
Matched to the resident’s record when it is correct.
Wrong when the resident mistypes, uses an old unit number, enters their name in a different form or enters nothing.
Freeform references require interpretation.
A simple memorable reference format reduces errors, and the unit number is usually best.
Communicated to residents on every invoice and statement.
Automatic matching where the reference is exact; flagged for review where it is close; suspense where it is absent or unrecognised.
Reference matching alone leaves a substantial share unmatched, which is why a service charge reconciliation system Kenya matches on reference first and falls back to phone number, since a service charge reconciliation system Kenya relying on reference alone accumulates suspense that phone matching would have cleared.
Matching by Phone Number {#by-phone}
The paying phone number is the most reliable key available and the one most estates ignore.
Every M-Pesa transaction carries the sender’s number.
If that number is on a resident’s record, the payment matches regardless of reference.
Multiple numbers per resident, since spouses, relatives and employees pay.
Numbers registered as they are discovered, so a number that paid once and was matched manually matches automatically next time.
Ambiguity where one number pays for several units, which the multi-unit section of the statements article addresses.
Register the numbers, since a service charge reconciliation system Kenya with two or three numbers per resident on file matches most payments without a reference at all, and a service charge reconciliation system Kenya that learns each new number at the first manual match reduces suspense every month.
Ask residents to register the numbers they pay from, and add them at every manual match.
Matching by Amount and Timing {#by-amount}
Where reference and phone both fail, amount and date narrow it.
A payment of exactly one month’s charge for a unit type, on or near the due date.
A payment matching an outstanding balance exactly.
A payment from a number that has paid a particular unit’s amount before.
Suggested rather than automatic, since amount matching can be wrong.
Confirmed by a person.
Confirmed with the resident where doubt remains.
Amount matching is a suggestion engine, and a service charge reconciliation system Kenya that proposes “this looks like unit 14’s balance” for the accountant to confirm speeds the work, while a service charge reconciliation system Kenya that applies amount matches automatically will attribute payments wrongly.
The Suspense Account {#suspense}
Unmatched payments belong in suspense, not in the wrong resident’s ledger and not nowhere.
Money received and not yet attributed.
Held as a balance visible to the reconciler.
Each item dated, with amount, source, reference and phone as received.
Never applied to a resident by guess.
Never left as a pool nobody examines.
A suspense balance is a list of residents who paid and are not yet credited, which means a list of future disputes, and a service charge reconciliation system Kenya that surfaces suspense daily is keeping the list short, while a service charge reconciliation system Kenya whose suspense grows unexamined is accumulating residents who will be chased for money they paid.
Suspense should be the exception queue, not a place to leave things.
Clearing Suspense {#clearing-suspense}
Suspense items are cleared by investigation, promptly.
Check the phone number against all registered numbers.
Check the amount against outstanding balances.
Check the reference for partial matches.
Contact the number that paid and ask which unit.
Contact residents whose balances match.
Record the match and register the phone number for next time.
Age suspense items, since one three days old is easy and one three months old is hard.
Target zero at month end.
Promptness is the discipline, since a service charge reconciliation system Kenya with a rule that no suspense item is more than a week old keeps the work small, and a service charge reconciliation system Kenya that clears suspense quarterly is reconstructing payments residents have forgotten making.
Message the payer, since the person who paid usually knows what it was for.
Partial Payments {#partials}
Residents pay less than the invoice and the ledger must show it.
Payment applied to the invoice.
Invoice status moves to partial.
Remaining balance on that invoice visible.
Subsequent payments applied to the remainder per the allocation rule.
Statement shows the partial and what remains.
Partial handling is routine, and a service charge reconciliation system Kenya that tracks partial status per invoice shows exactly what is outstanding on which charge, while a service charge reconciliation system Kenya that only tracks a running balance cannot tell the resident which month is short.
The levy arrears article covers the policy on partials.
Overpayments and Credits {#overpayments}
Residents also pay more than they owe and the surplus must be held correctly.
Applied to the outstanding invoices first.
Surplus held as a credit on the resident’s ledger.
Applied to the next charge raised.
Shown on the statement as a credit balance.
Never absorbed, since money a resident overpaid remains theirs.
Refundable on request or on departure, per the estate’s policy.
Credits are liabilities, and a service charge reconciliation system Kenya that holds them per resident knows what the estate owes back, while a service charge reconciliation system Kenya that lets overpayments vanish into the general balance has taken money it cannot account for.
Duplicate Payments {#duplicates}
Residents pay twice, usually because the first did not confirm, and the second must not become a phantom charge cleared.
Detected by the same phone, amount and date within a short window.
Flagged rather than applied automatically.
Confirmed with the resident.
Second payment treated as a credit or refunded.
Recorded as a duplicate with the original’s reference.
Undetected duplicates distort the ledger, since a service charge reconciliation system Kenya that flags likely duplicates catches the resident who paid twice before they notice, and a service charge reconciliation system Kenya that applies both will show the resident as paid two months ahead when they meant to pay one.
Refund promptly where the resident wants it, since holding a duplicate is holding their money.
Reversals and Failed Transactions {#reversals}
Transactions reverse and fail, and the ledger must follow.
M-Pesa reversals where a transaction is reversed after being recorded.
Failed transactions that showed as pending and never completed.
Bounced or recalled bank transfers.
Each reversed in the ledger by a reversal line, not by deleting the original.
Invoice status returned to what it was.
The resident informed.
Reference retained for the trail.
Reversals caught late are the worst drift, since a service charge reconciliation system Kenya reconciling ledger to Paybill daily sees the reversal the day it happens, and a service charge reconciliation system Kenya reconciling monthly finds a resident credited for money that went back to them three weeks ago.
Cash Receipts and Banking {#cash}
Cash is the source with no independent record and it needs the most discipline.
Receipt issued at the moment of collection, numbered.
Recorded in the ledger the same day against the resident.
Held securely.
Banked promptly and in full.
Banking slip matched to the receipts it comprises.
Cash on hand reconciled to receipts not yet banked.
The gap between collection and banking is where cash goes missing, and a service charge reconciliation system Kenya that records each receipt and matches each banking to its receipts closes the gap, while a service charge reconciliation system Kenya that records cash only when banked has a period where money exists nowhere.
Two people counting and one person never both collecting and recording, as the governance article requires.
Minimise cash, since every cash payment is a reconciliation the other channels do automatically.
Charges and Net Amounts {#charges}
Fees reduce what arrives and the ledger must decide how to treat them.
M-Pesa transaction charges deducted before settlement.
Bank charges on deposits and transfers.
Paybill service fees.
The resident paid the gross; the estate received the net.
Credit the resident with the gross, since they paid it.
Record the charge as an estate expense.
Reconcile the bank at net.
Confusing the two produces a permanent small difference, since a service charge reconciliation system Kenya that credits gross and expenses the fee reconciles to the bank exactly, and a service charge reconciliation system Kenya that credits net will have every resident slightly short and the difference unexplained.
The budgeting article includes charges in the cost base.
Timing Differences {#timing}
Some differences are only timing and should be recognised as such.
A payment made on the last day of the month and settled to the bank on the first.
A cash receipt taken on Friday and banked on Monday.
A Paybill settlement batched.
A bank transfer initiated but not yet cleared.
Genuine differences that resolve themselves in days.
Listed as reconciling items with the expected clearing date.
Cleared when they land.
Not confused with errors, and a service charge reconciliation system Kenya that lists timing items separately from unexplained differences keeps the two apart, while a service charge reconciliation system Kenya that treats every difference as an error wastes investigation on money that arrives on Monday.
A timing item that does not clear within its expected window becomes an exception.
Applying Payments to Invoices {#allocation}
Matching a payment to a resident is half the job; applying it to the right invoice is the other half.
Oldest invoice first is the common rule.
Current invoice first is an alternative.
Resident-designated allocation where they specified.
The rule stated and applied consistently.
Allocation recorded on the payment and shown on the statement.
Ageing depends on it, since a payment applied to the current month leaves an old invoice ageing while the same payment applied to the oldest clears it.
Consistency is the control, and a service charge reconciliation system Kenya that applies the rule automatically produces comparable ageing across residents, while a service charge reconciliation system Kenya where allocation is decided per payment by whoever recorded it produces ageing that means nothing.
The statements article explains why allocation must be visible to the resident.
Invoice Status {#invoice-status}
Every invoice should carry a status that reconciliation keeps true.
Draft, before issue.
Issued, when sent to the resident.
Partial, when some payment has been applied.
Paid, when fully settled.
Reversed or cancelled, with reason.
Status derived from payments applied, never set by hand.
Arrears reporting built from status.
Status is where the resident’s position and the estate’s position meet, and a service charge reconciliation system Kenya whose invoice statuses are derived from reconciled payments reports arrears that are true, while a service charge reconciliation system Kenya where status can be changed manually will have invoices marked paid that were not.
Daily Reconciliation {#daily}
The work is small if it is daily and large if it is monthly.
Import or receive the day’s Paybill transactions.
Match automatically by reference and phone.
Review the flagged and suspense items.
Clear what can be cleared.
Record cash receipts.
Check reversals.
Twenty minutes for a typical estate.
The daily habit is the whole system, since a service charge reconciliation system Kenya worked daily has a handful of items to examine each morning, and a service charge reconciliation system Kenya worked monthly has hundreds, most of which the payer has forgotten.
Assign it, since a daily task that belongs to nobody is not done.
Month-End Close {#month-end}
The month closes when the three records agree and the differences are explained.
All Paybill transactions for the month matched or in suspense with a reason.
All bank deposits matched.
All cash receipts banked and matched.
Suspense at or near zero.
Timing items listed with expected clearing.
Charges expensed.
Ledger total collected reconciled to bank total received plus charges plus timing items.
Signed off by whoever holds that role.
Statements issued from the closed figures.
The close is the moment the figures become reliable, since a service charge reconciliation system Kenya with a documented month-end close has figures the committee can present, and a service charge reconciliation system Kenya that never formally closes has figures that are always provisional.
Do not issue statements before the close, as the statements article insists.
Locking Periods {#locking}
Once a month is closed it should not change silently.
Closed periods locked against edits.
Corrections to a closed period made by adjustment in the current period, with reference to the original.
Reopening only by authority, recorded.
Reports for a closed period stable, so the figures presented to the AGM in March are the figures the auditor sees in September.
Locking is what makes the trail trustworthy, since a service charge reconciliation system Kenya with locked periods means a balance reported once is the balance reported always, and a service charge reconciliation system Kenya where anyone can edit January in June has no reliable history.
The audit trail section depends on this.
Bank Statement Reconciliation {#bank-rec}
The bank is the ultimate record and the ledger must reconcile to it.
Bank statement obtained for the period.
Every deposit matched to a Paybill settlement, a direct transfer or a cash banking.
Every withdrawal matched to an authorised payment, which the accounting side covers.
Bank charges identified.
Interest identified.
Unmatched deposits investigated, since money in the bank nobody recorded is a resident uncredited.
Unmatched withdrawals investigated, since money out nobody authorised is serious.
Closing bank balance agreed to the ledger’s bank balance.
Monthly at least, and a service charge reconciliation system Kenya that imports the bank statement and matches settlements to Paybill batches removes most of the manual work, while a service charge reconciliation system Kenya that never reconciles to the bank is trusting the Paybill and the ledger to agree with a record nobody checked.
Paybill Statement Reconciliation {#paybill-rec}
The Paybill statement is the transaction-level truth for M-Pesa and it must match the ledger line by line.
Every transaction on the Paybill statement recorded in the ledger against a resident or in suspense.
Every M-Pesa payment in the ledger present on the Paybill statement.
Reversals on the Paybill reflected in the ledger.
Settlements from the Paybill to the bank matched.
Charges deducted identified.
Line-level matching is the requirement, since a service charge reconciliation system Kenya that matches totals only will miss a payment recorded against the wrong resident, and a service charge reconciliation system Kenya that matches every transaction catches it.
Automated import from the Paybill is what makes this practical, and the Paybill integration page describes it.
Exceptions and Investigation {#exceptions}
Differences that are not timing are exceptions and each needs a conclusion.
Payment on Paybill not in ledger: record it, match it or suspense it.
Payment in ledger not on Paybill: find where it came from; if nowhere, reverse it.
Deposit in bank not in ledger: identify the source.
Withdrawal in bank not authorised: escalate immediately.
Resident credited twice for one payment: reverse the duplicate.
Amount differences: charges, partial or error.
Each investigated, concluded and documented.
Patterns noticed, since the same error recurring is a process fault.
Never write off a difference to make the numbers agree, since a service charge reconciliation system Kenya that carries an unexplained difference as an open item is honest, and a service charge reconciliation system Kenya that plugs it with an adjustment has hidden something that will surface later.
Who Reconciles {#roles}
Separation of duties applies here as much as anywhere in estate finance.
Recording payments is one role.
Reconciling to the Paybill and bank is ideally another, or at least reviewed by another.
Approving adjustments and write-offs is a third.
Viewing for committee oversight.
One person doing all of it is the weakness, since the person who records can also conceal.
Small estates with one treasurer should have a second person review the month-end.
Roles enforced in the system rather than by trust.
The platform’s roles exist for this, and a service charge reconciliation system Kenya where the accountant reconciles and the manager approves adjustments has a control, while a service charge reconciliation system Kenya where one login does everything has a treasurer who is unprotected as much as unchecked.
The Treasurer’s Protection {#treasurer}
Reconciliation protects the person handling the money more than anyone.
The treasurer is the one suspected when figures do not agree.
A reconciled ledger shows every shilling in and out.
An unreconciled ledger leaves the treasurer unable to disprove an accusation.
Month-end sign-off by a second person is the treasurer’s witness.
Locked periods mean nobody can later alter what the treasurer reported.
The audit trail shows who did what.
Present it that way, since a service charge reconciliation system Kenya framed as protecting the volunteer who does the work is adopted, and a service charge reconciliation system Kenya framed as checking up on them is resented — and the harambee article makes the same point about contribution treasurers.
A treasurer who insists on reconciliation is protecting themselves.
The Audit Trail {#audit-trail}
Every action on the ledger should be recorded with who, when and what.
Payment recorded: by whom, when, from which source.
Match made: by whom, on what basis.
Suspense item cleared: by whom, to which resident.
Adjustment: by whom, with what authority and reason.
Reversal: by whom, referencing what.
Period closed and locked: by whom.
Unchangeable, so history is appended rather than edited.
The trail is what an auditor, a tribunal or a suspicious resident can follow, and a service charge reconciliation system Kenya with a complete trail lets a committee show exactly how a balance arose, while a service charge reconciliation system Kenya on a spreadsheet has a trail only as reliable as the last save.
The platform’s audit-ready history is this feature.
Migration and the First Reconciliation {#migration}
Moving from a spreadsheet to a system starts with a reconciliation that establishes the opening position.
Every resident’s spreadsheet balance as at the migration date.
Checked against receipts, Paybill history and bank statements for as far back as evidence exists.
Residents asked to confirm their opening balance.
Disputed balances flagged rather than carried as fact.
Suspense established for any money in the bank that cannot be attributed.
The bank balance at migration agreed to the sum of resident balances plus estate funds.
Documented: source, date, who checked, what was disputed.
The first reconciliation is the hardest and the most important, since a service charge reconciliation system Kenya that starts from confirmed opening balances is trustworthy from day one, and a service charge reconciliation system Kenya that starts from unchecked spreadsheet figures inherits every historical error as an opening balance nobody can explain.
The statements article and the handover article both depend on this.
Multi-Estate Reconciliation {#multi-estate}
Management companies reconcile many estates and the discipline must be the same across all.
A workspace per estate with its own Paybill, bank and ledger.
Never one Paybill for several estates, since money for different clients mixed in one account is a client money problem.
The same daily and monthly routine per estate.
Standardised charge libraries and allocation rules.
Consolidated view of reconciliation status across estates for the company.
Per-estate reporting to each committee.
Roles per estate, so a client’s committee sees only their own.
Client money kept separate and reconciled separately, since a service charge reconciliation system Kenya run by a management company must be able to show each committee their own money reconciled, and a service charge reconciliation system Kenya that pooled estates would fail that at the first question.
The management companies page addresses the structure.
The Reconciled Position Report {#reporting}
A small report shows whether reconciliation is current.
Suspense balance and item count, with oldest item age.
Unreconciled Paybill transactions.
Unreconciled bank items.
Timing items outstanding.
Exceptions open.
Last month-end close date.
Cash on hand not yet banked.
Collection rate for the period on reconciled figures.
Suspense age and last close date are the two that show whether the estate is current, since a service charge reconciliation system Kenya reporting suspense at three items none older than two days and the last close on the second of the month is being run, and a service charge reconciliation system Kenya reporting forty items and no close since March is not.
Committee members should see this report, since it is the health check on the money.
Reconciliation and Statements {#statements}
Statements are the output that reconciliation makes true.
A statement issued from an unreconciled ledger may show a resident owing money they paid.
A statement issued after the close shows the reconciled position.
Suspense items are residents whose statements are wrong until cleared.
The sequence is reconcile, close, issue.
Statement disputes that turn out to be reconciliation errors should feed back into the process.
The statements article covers the document, and a service charge reconciliation system Kenya is what stands behind every figure on it, since a service charge reconciliation system Kenya that clears suspense before statements go out is the reason the statements can be trusted.
Data Protection {#data-protection}
Reconciliation records contain residents’ payment data and the Data Protection Act applies.
Phone numbers registered against residents, including relatives’ and employees’ numbers.
Payment histories.
Bank and Paybill statements containing every payer’s details.
Access limited to reconciling and reviewing roles.
Paybill and bank statements stored securely, not circulated.
Numbers registered for matching used only for matching.
Retention defined for the period audit and dispute could require.
A Paybill statement is a list of who paid what and when, and a service charge reconciliation system Kenya that holds it within the system with role-based access protects it, while a service charge reconciliation system Kenya whose Paybill statement is forwarded around the committee on WhatsApp has shared every resident’s payments with everyone.
Confirm obligations with qualified advice.
Systems and Costs {#systems}
Reconciliation capability is the core of a service charge platform and the matching engine is what to assess.
Automated Paybill import.
Matching by reference, then phone, then suggested amount.
Multiple phone numbers per resident, learned at each manual match.
Suspense queue with ageing.
Duplicate and reversal detection.
Partial and credit handling.
Allocation rules applied automatically.
Invoice status derived from payments.
Cash receipting and banking match.
Bank statement import and matching.
Month-end close with sign-off and locking.
Exception list.
Audit trail.
Roles.
Reconciled position report.
Pricing commonly from around KES 5,000 monthly for up to a hundred units, rising with unit count.
Implementation should begin with the migration reconciliation, since a service charge reconciliation system Kenya that starts from confirmed balances is right from the first day, and phone number registration for every resident, since that is what makes matching automatic.
Then daily routine from the first day and the first close at the first month end.
Weigh it against the dispute, since a service charge reconciliation system Kenya that keeps suspense at zero has removed the reason for most balance disputes in the estate, and the treasurer’s protection alone is worth the subscription.
Frequently Asked Questions {#faqs}
Why do our ledger, Paybill and bank never agree?
Because three records are kept by three processes and nobody has been matching them. Wrong references leave payments unattributed, cash is recorded when banked rather than when received, reversals go unnoticed, duplicates get applied, and fees reduce the net without the ledger reflecting it. None requires dishonesty — it is the absence of a daily routine that matches every payment to a resident and an invoice.
Most of our M-Pesa payments arrive with the wrong reference. What do we do?
Match by phone number. Every transaction carries the sender’s number; register two or three per resident including spouses and relatives, and add each new number at the first manual match. Most payments then match without any reference at all, and suspense shrinks every month.
What is suspense and why does it matter?
Suspense is where unmatched money is held until it can be attributed — never applied to a resident by guess, never left as a pool. A suspense balance is a list of residents who paid and are not yet credited, which is a list of future disputes. Clear it daily, age it, and target zero at month end.
How often should we reconcile?
Daily for matching — twenty minutes for a typical estate — and a formal close at month end when the three records agree. Worked daily it is a handful of items each morning; worked monthly it is hundreds, most of which the payer has forgotten. Assign it to a named person, since a daily task that belongs to nobody is not done.
A resident paid twice. What happens to the second payment?
It is flagged as a likely duplicate — same phone, amount and date within a short window — confirmed with the resident, and held as a credit or refunded promptly. Applied automatically it would show the resident paid two months ahead when they meant to pay one, and holding it without their agreement is holding their money.
Should we credit residents the gross amount or the net after M-Pesa charges?
Gross, since that is what they paid. Record the charge as an estate expense and reconcile the bank at net. Crediting net leaves every resident slightly short with the difference unexplained forever.
We are moving from a spreadsheet. Where do we start?
With a reconciliation that establishes opening balances: check every resident’s spreadsheet figure against receipts, Paybill history and bank statements, ask residents to confirm, flag what is disputed rather than carrying it as fact, and agree the bank balance to the sum of resident balances. It is the hardest reconciliation and the most important — every historical error not caught here becomes an opening balance nobody can explain.
Who does reconciliation actually protect?
The treasurer, above everyone. The person handling the money is the one suspected when figures do not agree, and a reconciled ledger with month-end sign-off by a second person and locked periods is the only thing that disproves an accusation. A service charge reconciliation system Kenya framed as protecting the volunteer who does the work is adopted; one framed as checking up on them is resented.