How to reconcile a provider statement (M-Pesa, Airtel, bank)

Accounting Updated 5 Aug 2026

Summary

Upload a provider statement for reconciliation and read how many of its records have been processed.

About 6 minutes - 9 steps.

Also called: payment reconciliation, statement upload, MPKE, AIRTEL, xlsx statement.

Prerequisites

  • A CAMS Superadmin Portal sign-in that can open Payment Reconciliation. Access is controlled per provider and by upload authorisation level.
  • The statement file from the provider, saved as .xlsx, under 10 MB, with no more than 10,000 records.
  • The exact dates the statement covers. The range must be 30 days or fewer and must not include future dates.

Step-by-step

  1. Sign in to the CAMS Superadmin Portal.
  2. Open the Business Accounts section.
  3. Open the Payment Reconciliation tab. The statements already uploaded are listed.
  4. Read the Statement Dates column so you do not repeat a range that is loaded already.
  5. Choose the provider in Select Provider. Providers include MPKE for M-PESA Kenya, MPESA_TZ for M-PESA Tanzania, AIRTEL, TIGOPESA, DTB, COOP and NMB.
  6. Set From Date and To Date to the range the statement covers, then set Provider Name.
  7. Upload the .xlsx statement file.
  8. Click Submit to send it for processing.
  9. Find the new row and read Status. It shows X/Y, where X is records processed and Y is the total in the file. For example, 874/2212.

Common pitfalls & FAQ

  • The Status number is lower than the total. The statement is partly reconciled or still running. Check again later. Equal numbers mean every record has been processed.
  • The file was not accepted. The supported format is .xlsx. The file must be under 10 MB and hold no more than 10,000 records.
  • Which dates should I enter? The range must match the statement content. It cannot be longer than 30 days and cannot include future dates.
  • A statement for that range is loaded already. Only one statement is allowed per date range per provider, and ranges must not overlap. Read Statement Dates on the grid, then change your range.
  • The status has not moved for a long time. Processing times out after 30 minutes, with up to three retry attempts. Three uploads run at once per provider, so a queue can hold yours back.
  • I need to check one transaction. Open the Transactions tab. The Reconciled column shows True or False, and there is a ReconcileId search field.
  • I need this data outside CAMS. Use Export Statements on the Payment Reconciliation tab. The File, Uploaded Date and Uploaded By columns tell you which upload is which.