Export M-Pesa Statement to Google Sheets and Find True Profit

When you run a business or side hustle from your phone, M-Pesa is an absolute lifesaver. But when client payments, supplier purchases, matatu fares, and evening grocery runs all happen on the exact same line, figuring out what you actually earned becomes a headache. Let's fix that by turning your raw mobile money data into a clear, simple spreadsheet that tells you exactly where your cash is going.

In a nutshell:

• How to download an official, e-stamped M-Pesa statement directly to your email.
• The safe way to convert your PDF into a spreadsheet without risking your personal data.
• A basic Google Sheets formula to separate business profit from daily personal spending.

Why Your M-Pesa Statement is the Ultimate Business Record

If you find it difficult to separate your business and personal money, you are not alone. Kenya has roughly 18.1 million informal workers compared to just 3.3 million in formal wage employment. The gig economy alone employs approximately 1.5 million people, representing about 5% of the total labor force in 2026. This massive gig economy in Kenya generates roughly $1.029 billion (about KSh 100 billion) annually.

With so much money moving through mobile phones, writing down individual SMS messages in a notebook quickly leads to burnout and calculation errors. You might look at your M-Pesa balance at the end of the week, see KSh 15,000, and feel like you had a great week. But confusing total cash received with actual profit is a common trap when business stock, transport, and personal items are bought using the same line.

Your M-Pesa statement solves this. The Kenya Revenue Authority (KRA) accepts M-Pesa statements as supporting documentation for tax filing due to the complete audit trail indexed by unique transaction codes. Since M-Pesa users can transact up to a daily limit of KSh 500,000, with a per-transaction limit of KSh 250,000, your mobile wallet is more than capable of handling serious business volume. (Always consult a certified tax agent for definitive tax advice regarding your specific KRA compliance).

How to Download Your E-Stamped M-Pesa Statement in 2026

Before you can start analyzing your numbers, you need the raw data. Safaricom provides digitally stamped M-Pesa statements that are official, secure, and generated as password-protected PDFs opened using your National ID or passport number.

You can easily request statements via USSD (*334#), the M-Pesa App, or the Safaricom self-care portal for durations up to 12 months directly to your email.

Here is the fastest way to do it on your phone:

1. Dial *334# on your Safaricom line.
2. Select the option for 'My Account'.
3. Select 'M-Pesa Statement' and choose 'Full Statement'.
4. Pick a timeline, such as 3 months or 6 months.
5. Enter your email address and confirm with your PIN.

Within a few minutes, you will receive an email containing a secure PDF file.

Your M-Pesa statement arrives as a secure, password-protected file.

The Safe Way to Convert Your PDF Statement to a Spreadsheet

Now that you have your PDF, you need to turn it into a format that Google Sheets can understand.

This is where many people make a critical mistake: uploading password-protected M-Pesa PDFs into sketchy free PDF to Excel websites. Doing this exposes highly sensitive financial history and your National ID number to the open internet, putting you at severe risk of identity theft.

Instead, use a secure, local offline tool like mpesa2csv to convert the PDF ledger into a CSV file without uploading it to the internet. A CSV (Comma Separated Values) file is a simple text format that strips away all the fancy PDF formatting, leaving just the raw data in neat rows and columns. Because these tools run locally on your computer, your data remains entirely private.

Setting Up Your Google Sheet: Columns, Dropdowns, and Categories

Once you have your CSV file, it is time to bring it into Google Sheets.

Open a blank Google Sheet, click File > Import, and upload your CSV. Delete the unnecessary header rows at the top of the sheet so that your first row contains clean headers like Date, Receipt No, Details, Paid In, and Withdrawn.

Next, add a brand new column at the end and title it 'Category'. This is the most important column in your entire spreadsheet.

To make categorizing fast and error-free, create a dropdown list:

1. Select your entire 'Category' column.
2. Click on Data > Data Validation in the top menu.
3. Add a rule and choose 'Dropdown'.
4. Enter clear labels for your everyday life. Keep them simple, like 'Business Stock', 'Personal Food', 'Transport', 'Client Income', and 'Family Support'.

Now, instead of typing out a category for every transaction, you can just click the dropdown and select the right label. This takes the guesswork out of your record keeping and ensures your categories are spelled exactly the same way every time.

Setting up clear categories prevents your business and personal money from mixing.

The Magic Formula: Using SUMIFS to Calculate Your True Profit

One common error people make is trying to build complex nested IF formulas in Google Sheets to auto-read merchant names. These almost always break when new shops or abbreviations appear in your statement.

The most reliable manual method to categorize expenses in Google Sheets is keeping one raw transaction tab and using a SUMIFS formula on a separate tab to automatically total each category.

Create a new tab at the bottom of your screen and call it 'Summary'. List your categories in one column. In the next column, you will use the SUMIFS formula.

The formula works like this: =SUMIFS(Amount_Column, Category_Column, "Specific Category").

For example, if you want to know exactly how much you spent on business stock, your formula will look at the column where your withdrawal amounts are, look at your dropdown category column, and only add up the numbers that have the label 'Business Stock'.

If you see that your 'Client Income' total is KSh 45,000 for the month, but your 'Business Stock' is KSh 20,000 and 'Transport' is KSh 5,000, you now know your true gross profit is KSh 20,000.

Seeing these numbers clearly laid out helps you manage unpredictable cash flows and stay prepared for tax time. Straightforward record keeping leads to predictable months and significantly reduces financial stress.

Frequently asked questions

Can I pull an M-Pesa statement for just one week? Yes, the M-Pesa app and the *334# USSD menu allow you to select custom date ranges. You can pull statements for a few days, a month, or up to 12 months depending on how often you want to update your spreadsheet.

What password do I use to open the PDF in my email? The PDF is securely locked by Safaricom. You must enter the exact National ID number or passport number you used when originally registering your M-Pesa line.

Do I need an expensive computer to do this? No. While doing the initial setup is easier on a laptop, you can view, edit, and update Google Sheets entirely on your smartphone using the free Google Sheets app.

Getting a handle on your business numbers does not require an accounting degree. Start small. Your concrete next step today is to dial *334# and request your statement for the last 30 days. Import it into a spreadsheet, add your categories, and see where your money really went. Over time, this simple habit will give you immense confidence in your daily decisions. If you would rather not do this by hand, BlueSpend automatically parses M-Pesa confirmation messages locally on your device to categorize spending in real-time, offering a helpful alternative for busy days.