Bank Statement Import & Reconciliation
Import M-Pesa and bank statements, match them against recorded payments, and sign off each period.
What It Is
Upload a bank or M-Pesa statement and Nyumba Zetu lines it up against the payments already recorded in the system: what matched, what did not, and what needs a person to decide. Each bank account is then signed off period by period.
How It Works
Statements come in through the same upload wizard as the rest of the platform, with parsers for M-Pesa paybill exports, NCBA files and generic CSV. Every statement line is matched against recorded payments and scored. An exact receipt match reconciles on its own; lower-confidence candidates go to a workbench that shows the statement evidence beside each candidate with a per-component score breakdown. Lines with no counterpart land in a typed exceptions queue, and a payment that was never recorded can be posted from the statement line itself through the normal payment path, using a receipt number derived from the statement so a retry cannot double-post. Accounts are enrolled individually, and each period is signed off once reviewed.
Why It Matters
Reconciliation is where property managers find money they thought they had lost: payments made against the wrong reference, deposits that never reached the ledger, credits applied twice. Doing it in a spreadsheet stops scaling after a handful of accounts, and leaves no record of who approved what.
Frequently Asked Questions
Common questions about this feature.
Which statement formats are supported?
M-Pesa paybill exports, NCBA statements and generic CSV, imported through the standard upload wizard with a column-mapping step.
Will importing the same statement twice duplicate anything?
No. Imports are fingerprinted, so re-uploading the same or a corrected file brings in only what is genuinely new, and posting a payment from a statement line derives its receipt number from the statement so a retry cannot double-post.
Does every line have to be matched by hand?
No. Exact receipt matches reconcile automatically, and only scored candidates and unmatched lines are routed to a person.
Ready to see this feature in action?
Schedule a demo to explore how this feature can help your property operations.
Request a Demo