How to Turn Your M-PESA Till Statement into a Business Report
A practical guide for Kenyan business owners on converting a raw M-Pesa Till statement into a professional business report — covering P&L, KRA compliance, customer analysis, and bank-ready documentation.
In this article
Why Your M-Pesa Statement Is Not Yet a Business Report
Your M-Pesa Business Till statement is one of the most valuable financial documents your business produces. It contains a complete, time-stamped record of every payment received and every payment made — but in its raw form, it is just a long list of transactions. To be useful for business decisions, tax filing, or loan applications, it needs to be transformed into a structured business report.
The difference between a raw statement and a business report is organisation and analysis. A business report answers the questions that matter: How much did I earn this month? What were my biggest expenses? Who are my best customers? Am I making more or less than last month? Is my business growing?
Raw M-Pesa Statement
- ✗ 200+ rows of transactions
- ✗ No totals or summaries
- ✗ No expense categories
- ✗ No profit calculation
- ✗ No customer ranking
- ✗ Not useful for KRA or banks
Business Report
- Gross sales and net profit
- Expense breakdown by category
- Month-over-month comparison
- Top customers ranked by spend
- KRA TOT calculation included
- Ready for accountant or bank
Step 1: Categorise Every Transaction
The first step in turning your statement into a report is categorising each transaction. This means labelling every "Withdrawn" entry as a specific type of expense: Stock/COGS, Rent, Utilities, Salaries, Loan Repayment, or Personal Withdrawal. Without categories, all your expenses look the same and you cannot understand where your money is actually going.
Doing this manually in Excel is time-consuming and error-prone. PesaLedger's AI categorisation engine reads the transaction description and counterparty name and automatically assigns each transaction to the most likely category. For a 200-transaction statement, this takes under 30 seconds — compared to 2–3 hours manually.
| Transaction Description | AI Category | Report Line |
|---|---|---|
| Customer Payment - JANE WANJIKU | Sales | Gross Sales |
| Business Payment - KAMAU HARDWARE | Stock/COGS | Cost of Goods Sold |
| Pay Bill - KPLC 123456 | Utilities | Operating Expenses |
| Pay Bill - EQUITY BANK 0012345 | Loan Repayment | Financing Costs |
| Withdrawal - PETER MWANGI | Salaries | Operating Expenses |
| Transfer to Personal | Personal Draw | Excluded from P&L |
Step 2: Build Your Profit & Loss Statement
Once your transactions are categorised, the Profit & Loss (P&L) statement builds itself. A P&L is the standard financial document that shows whether your business made a profit or a loss during a period. For a Kenyan SME using M-Pesa, a simple P&L looks like this:
PesaLedger generates this P&L automatically from your uploaded statement. The Reports page shows it month by month, and the PDF export button produces a formatted version ready to hand to your accountant or bank manager.
Step 3: Add Customer Analysis
A complete business report goes beyond income and expenses. Knowing who your best customers are is critical for business growth. The Customer Leaderboard in PesaLedger ranks every person or business that has paid your till, showing their total spend, number of transactions, and average transaction size.
This analysis often reveals surprising insights. Many business owners discover that their top 5 customers account for 40–60% of their total revenue. Losing even one of these customers can have a significant impact on monthly profit. Knowing who they are allows you to prioritise their experience, offer loyalty incentives, or simply make sure you never run out of the products they buy most.
What customer analysis tells you:
- Which customers to prioritise for retention
- Whether your customer base is growing or shrinking
- Which suppliers are your biggest cost centres
- Whether you are too dependent on a single customer
Step 4: Export and Share Your Report
A business report is only useful if it can be shared with the people who need it. PesaLedger provides three export options:
PDF Report
A formatted A4 PDF containing your KRA TOT Summary and monthly P&L table. Suitable for printing, emailing to your accountant, or attaching to a bank loan application. Generated in seconds from the KRA Summary or Reports page.
Excel Export
A full Excel workbook with your categorised transactions, monthly P&L summary, and customer leaderboard. Useful for accountants who prefer to work in spreadsheets or for businesses that need to merge data with other financial records.
WhatsApp Summary
A pre-formatted WhatsApp message with your key numbers — gross sales, top expense, net balance, and KRA TOT — ready to send to your accountant in one tap. No formatting required.
Accountant Share Link
Generate a time-limited, read-only link to your PesaLedger dashboard that you can share with your accountant. They can view all your reports without needing to log in or handle any files.
Using Your Business Report for Bank Loans
One of the most practical uses of a well-prepared business report is supporting a loan application. Kenyan banks and microfinance institutions — including Equity Bank, KCB, Co-operative Bank, and M-Shwari — increasingly accept M-Pesa statements as proof of business income. However, they prefer to see the data presented in a structured format rather than as a raw PDF.
When applying for a business loan, bring the following documents generated from PesaLedger:
- 1
6-month P&L summary
Shows consistent income and expense patterns over time — the most important factor lenders assess.
- 2
KRA TOT compliance record
Demonstrates that your business is registered and tax-compliant, which significantly improves your creditworthiness.
- 3
Loan Readiness Score
PesaLedger's 0–100 score summarises your financial health in a single number, with specific recommendations for improvement.
- 4
Original Safaricom statements
Always bring the original PDFs as supporting evidence — the bank may want to verify the source data.
Generate your business report in seconds
Upload your M-Pesa Till statement and get a complete P&L, customer analysis, and KRA summary — ready to share with your accountant or bank. Free during open beta.
Create My Business Report