JM

Tana Water Works Development Agency

Turned Reconciliation Into a Continuous Control Across 1,000+ Donor-Funded Stakeholders

0%

Spending Reduction

0+

Stakeholders Reconciled

Executive Summary

Tana Water Works Development Agency, a Kenyan government agency administering African Development Bank-financed water infrastructure programmes, needed a stricter standard of financial control than ordinary government spend allows: every payment traceable to an approved programme activity, audit-ready continuously rather than annually. As Accounts Assistant, I treated reconciliation as a continuous control rather than a month-end clean-up exercise, validating supplier and contractor payment documentation against approved programme budgets before posting, and applying accrual-based recognition consistently so expenditure landed in the period it belonged to. I reconciled high-volume transactions across more than 1,000 contractors, suppliers and stakeholders, operated the agency ERP to post journals and process payments, and worked directly with procurement and programme teams because the answer to most reconciling items sat with the people who had commissioned the work, not in the ledger. Within four weeks, an investigation into expenditure trends contributed to a 9% reduction in discretionary operational spending, and financial records remained audit-ready throughout, with expenditure across donor-funded programmes substantiable against approved budgets on request.

Context

Tana Water Works Development Agency is a Kenyan government agency administering water infrastructure programmes financed by the African Development Bank. Donor-funded capital programmes carry a stricter accountability standard than ordinary government spend: every payment must be traceable to an approved programme activity, and financing conditions and future disbursements depend on continuous audit readiness. I worked within the finance function from February 2022 to August 2023.

Challenge

Payment flows ran across more than 1,000 contractors, suppliers and stakeholders, spanning both capital and operating programmes. Any break in the reconciliation chain created audit exposure, and at that transaction volume, errors were far easier to introduce than to find after the fact.

Strategic Approach

  1. Phase 1

    Reframing Reconciliation

    I treated reconciliation as a continuous control rather than a month-end clean-up exercise, because discrepancies caught only at close mean the supporting evidence is already weeks old and the people who can explain a payment have moved on.

  2. Phase 2

    Catching Breaks at Entry

    I validated supplier and contractor payment documentation against approved programme budgets before posting, and applied accrual-based recognition consistently so expenditure landed in the period it belonged to, not the period it was paid.

  3. Phase 3

    Working Beyond Finance

    I worked directly with procurement and programme teams rather than only within finance, because the answer to most reconciling items sat with the people who had commissioned the work, not in the ledger; this is also what surfaced the discretionary-spend investigation below.

Quantifiable Outcomes

  • Reconciled high-volume transactions across more than 1,000 contractors, suppliers and stakeholders.
  • Investigated expenditure trends, contributing to a 9% reduction in discretionary operational spending within four weeks.
  • Prepared accrual-based reconciliations and variance analysis supporting monthly financial reporting.
  • Operated the agency ERP to post journals, process supplier and contractor payments, and extract month-end close reporting.
  • Supported budget preparation and forward expenditure estimates across donor-funded capital and operating programmes, feeding reconciliation work directly into planning.

Qualitative Achievements

  • Financial records remained audit-ready throughout, not just at year-end.
  • Monthly reporting and compliance deadlines were consistently met.
  • Expenditure across donor-funded programmes could be substantiated against approved budgets on request.
  • Built the reconciliation discipline that later underpinned automation work at DashboardWorx.
Financial controls at scale aren't about catching errors after the fact. They're about building a reconciliation discipline strong enough that errors rarely make it into the books in the first place.

This is the foundation the rest of my finance career was built on: reconciliation, compliance and audit readiness under real governance stakes. It remains the discipline behind every dashboard and forecast I build today.

Technical Proficiencies

The agency ERPAccrual-based reconciliation frameworksAdvanced Excel

Competencies Displayed

Financial Reconciliation & Month-End CloseAudit, Compliance & Regulatory ReportingBudgeting & Forecasting