How to reconcile construction project expenses.
Reconciling construction expenses means matching every line on your M-Pesa and bank statements to a payment record and an approved request, then investigating anything that does not match. Do it weekly, not at month end, so that a missing receipt is a one-week problem and not a one-month mystery.
Why weekly beats monthly
At the end of a week, people still remember why a payment was made, receipts are still in pockets and wrong numbers can still be chased. At the end of a month, the same questions take hours, and some never get answered. A weekly routine also tells you how much cash you really have before you commit to next week's spending.
What you need
- Statements for every account you pay from: the M-Pesa line, till or paybill, and the bank account.
- Your payment records: vouchers or the payment list, each with its requisition number.
- Evidence: invoices, receipts, delivery notes and signed payroll sheets.
The weekly routine, step by step
- Export the statements for the week, from the first day to the last.
- Tick each outgoing statement line against a payment record.
- Tick each payment record against an approved request.
- List the exceptions: anything that did not tick on both sides.
- Resolve or escalate each exception, with a named owner and a date.
- Update the project totals, so budget against actual reflects the real spend.
- Sign off: the preparer and a reviewer confirm the week is closed.
How to match statement lines
- Match on three things: the amount, the date and the recipient. An M-Pesa statement shows the recipient's name and a transaction code for each line.
- Record the M-Pesa code on every payment record when you pay. It turns matching into a search instead of a guess.
- Treat transaction charges as their own cost line, so project totals agree with the statement.
- Watch for split payments: one approved request paid in two parts is two statement lines and one request.
Exceptions and what they usually mean
| Exception | Usual cause | What to do |
|---|---|---|
| Statement line with no payment record | Paid outside the process, or the record was never entered | Find the request and approval. If there is none, escalate |
| Payment record with no statement line | Not yet paid, or paid from another account | Check the other accounts, then correct the record |
| Amounts differ | Part payment, charges or a typing error | Correct the record and note why |
| The same payment appears twice | Duplicate payment | Ask the payee to refund or credit you |
| Recipient name does not match the payee | Wrong number, or something worse | Investigate the same day |
A worked example: one week of M-Pesa payments
The lines below are illustrative.
| Day | Paid to | Amount (KES) | Matched to | Result |
|---|---|---|---|---|
| Monday | Hardware supplier, Paybill | 142,500 | PAY-1192, request REQ-0482 | Matched |
| Tuesday | Peter O., mason | 9,120 | Payroll REQ-0490 | Matched |
| Wednesday | An unknown number | 15,000 | Nothing | Exception: the site manager paid a fundi directly. A request and approval are raised now, and the rule is restated |
| Thursday | Fuel station, till | 12,000 | PAY-1189 | Matched |
| Thursday | Hardware supplier, Paybill | 142,500 | PAY-1192 again | Exception: paid twice. The supplier credits the next invoice |
Two exceptions in one week is normal at the start. What matters is that both were found within days, not discovered at the end of the project. For the other comparisons that catch leaks early, see how to detect cost leakage before it becomes a major loss.
Who does what
| Role | Task |
|---|---|
| Finance | Prepares the reconciliation and lists exceptions |
| Project manager | Explains exceptions on their projects |
| Director | Reviews the summary and anything unresolved |
| Accountant | Uses the closed weeks for the monthly accounts |
The person who made the payments should not be the only person who reconciles them.
Reconciling in MjengoKit
In MjengoKit, each payment sits on the request it settles, with its reference. The cash statement shows money in and out with opening and closing balances, and a request can be marked as paid if it was settled another way. Statements export to Excel for your accountant. See construction payment software, or start with our free expense tracker.
Bring last week's M-Pesa statement. We will show you how each line would match in MjengoKit.
Book a 20-minute demo