Mpesa Payment Reconciliation

The Mpesa Payment Reconciliation tool is used to manually match incoming C2B payments (recorded in the Mpesa C2B Payment Register) against outstanding customer invoices. It is the manual counterpart to the auto-reconciliation feature available in Mpesa Settings.

Use this tool when:

• Auto-reconciliation is disabled.
• A payment could not be automatically matched because the customer entered an unrecognized account reference.
• You want to review and control how payments are allocated across multiple invoices.

How It Works

The tool displays two lists side by side:

1. Draft Mpesa Payments: Unreconciled entries from the Mpesa C2B Payment Register.
2. Outstanding Invoices: Unpaid or partially paid Sales Invoices for the selected customer.

You allocate payment amounts from the draft payments to the invoices, then submit to create the corresponding Payment Entries.

Step-by-Step Guide

Step 1: Open Mpesa Payment Reconciliation

Navigate to Mpesa Payment Reconciliation via the Mpesa workspace or Awesome Bar.

Step 2: Select Customer and Company

Fill in:

• Customer: The customer whose payments you want to reconcile.
• Company: The company to which the invoices and payments belong.

Step 3: Load Unreconciled Entries

Click Get Unreconciled Entries. The tool will load:

• All unreconciled draft Mpesa payment entries for the selected customer.
• All outstanding invoices for that customer.

Use the optional Filters section to narrow results by date range, currency, or other criteria.

Step 4: Allocate Payments to Invoices

In the table, assign each draft payment to one or more invoices. Enter the amount to allocate against each invoice. A single payment can be split across multiple invoices if needed.

Step 5: Reconcile

Once allocations are complete, click Reconcile. The system creates Payment Entries linking the Mpesa payments to the invoices, and the draft payment records are marked as reconciled.

When Auto-Reconciliation Is Sufficient

If the Auto Reconcile C2B Payments option is enabled in Mpesa Settings, the system handles reconciliation automatically when a C2B payment record is submitted. You only need this manual tool for payments that:

• Were not auto-matched.
• Need to be split across multiple invoices.
• Require review before being applied.