ERPNext Walkthroughs Accounts

Match M-Pesa receipts to invoices at your desk

Requires: M-Pesa Payments

Match Paybill receipts that nobody has applied to an unpaid invoice, from one screen, and let the system book the payment.

Matching Paybill receipts at the desk

Matching Paybill receipts at the deskCustomer pays the Paybill, then Paybill receipt; Sales Invoice, then Unpaid invoice; Paybill receipt, then Mpesa Payment Reconciliation; Unpaid invoice, then Mpesa Payment Reconciliation; Mpesa Payment Reconciliation, then Payment Entry; Payment Entry, then Bank matching.Customer paysthe PaybillPaybill receiptSales InvoiceUnpaid invoiceMpesa PaymentReconciliationPayment EntryBank matching
Hover or tap a box for a short note.

Dashed boxes happen before or after this walkthrough.
Step 1: Open the M-Pesa reconciliation screen

Step 1 of 11

Open the M-Pesa reconciliation screen

Search Mpesa Payment Reconciliation. It matches money that arrived by Paybill with the invoices still unpaid. Pick your Company and the Customer.

Arrow keys or space also move through the steps.

Steps

  1. Search Mpesa Payment Reconciliation. It matches money that arrived by Paybill with the invoices still unpaid. Pick your Company and the Customer.

  2. The customer decides which unpaid invoices are listed. Here it is a customer with one open invoice.

  3. Click Get Unreconciled Entries. It fills both tables below.

  4. Invoices lists this customer's submitted invoices that still have an outstanding amount, with the total and what is left to pay.

  5. Mpesa Payments lists all M-Pesa receipts of the company that are still drafts, not only this customer's. Match them by the payer's name, date and amount.

  6. Type part of the payer's name in Full Name, then click Get Unreconciled Entries again to narrow the list.

  7. Tick the invoice this payment settles.

  8. Then tick the receipt that paid it. You need at least one of each before you can allocate.

  9. Click Allocate. Each ticked receipt becomes a submitted Payment Entry for this customer, and it is reconciled against the ticked invoices.

  10. The paid invoice is gone from Invoices, and the receipt is no longer a draft. Other customers' receipts are still waiting for their own match.

  11. Open the new Payment Entry. Its Payment References table shows the invoice the receipt paid, for the full amount.