How It Works — LipaClear

1

Upload Your M-PESA CSV Statement

Log in to your M-PESA Business Portal (Paybill or Till Number dashboard). Download your transaction statement as a CSV file. Then, upload it to LipaClear with one click.

💡 Pro Tip: You can upload statements from multiple branches or till numbers. LipaClear will automatically organize them by branch.

2

Automatic Parsing and Categorization

Once uploaded, LipaClear automatically extracts transaction details — date, time, amount, transaction ID, sender name, and phone number. We categorize transactions by type (C2B, B2C, Reversals, Withdrawals) and match them to your internal records.

Extracts transaction metadata (date, amount, ID, sender)

Categorizes by payment type (C2B, B2C, Reversals, etc.)

Detects duplicates and invalid entries

3

View Variances and Discrepancies

LipaClear compares your M-PESA statement against your internal records (if you've uploaded them). We instantly flag:

Missing transactions — payments received on M-PESA but not recorded in your books
Duplicate entries — same transaction recorded multiple times
Amount mismatches — when recorded amounts differ from actual M-PESA amounts

4

Generate Reports (PDF, Excel)

Once reconciliation is complete, generate beautiful reports for your accountant or management. Export to PDF for presentations or Excel for further analysis.

📄

PDF Report

Professional summary with charts and variance breakdowns

📊

Excel Export

Detailed transaction-level data for custom analysis

5

Get WhatsApp Alerts for Issues

With Pro and Enterprise plans, LipaClear sends automated WhatsApp alerts when:

📱 A large discrepancy is detected (e.g., missing payment over KES 10,000)
📱 A new CSV upload completes with variances flagged
📱 Monthly reconciliation summary (automated on the 1st of each month)

💚 Stay in the loop: Never miss a discrepancy again. Get real-time alerts directly to your WhatsApp.

How LipaClear Works