
Retail · Excel automation
Cornerstone Hardware Paybill reconciliation
Paste the M-Pesa statement and the open invoices into their sheets. Every payment is matched to its invoice, the difference is worked out, and each one is marked Matched, Part payment, Overpaid or Check account.
- Excel
- INDEX and MATCH
- Conditional formatting
- Filters
- Charts
Read the case studyFictional client