What is PesaMail
Pesamail is an android mobile app that has many features key among them being the integration to M-PESA by using the incoming payment SMS on your phone. It can also be used to send out bulk SMS message notification back to the M-Pesa sender
Pesamail has the following summary features
-
Bulk SMS integration
-
Bulk SMS alerts to customers upon receipt of m-pesa payments
This can be used to,
- Thank the mpesa sender
- Market your products or services or other peoples products and services for a fee
- Automatically collect customers contacts into a database.**
- Satisfaction survey and view feedback in real time which you can use to call unhappy customers and resolve any issues arising.**
- Automatic Collection of Birthdates, sending of Pre birth day SMS, Happy Birthday SMS. Use this to entice the customer to buy from you during their celebrations.**
- M-Pesa receipt printing to a blue tooth printer *
- Automatic Customer contacts data mining
- Customer satisfaction survey and real time analytics - viewed on our server www.lulusms.com
- Create a bulk SMS account on www.lulusms.com and get 10 free bulk sms units and test Bulk SMS Alerts to customer upon receipt of M-Pesa payments'
- * Call 0705 209 200 for your own BRANDED SMS name and for ACTIVATION of features not enabled by default
- ** Backend accessed on our website - www.lulusms.com
-
Bulk SMS alerts to customers upon receipt of m-pesa payments
This can be used to,
-
Converts your M-PESA transaction text messages into an Excel Spreadsheet of rows of data consisting of the columns,
- Date, Time, Ref, Status, Amount, Balance, Source Number and Source Name
-
Automatically E-Mail this file, to your prescribed e-mail address
- Every Hour
- Every Day at midnight
- Every Month at midnight of the last date of the month
-
Allows users to Query the SMS transactions using a date and time range and
-
Send to a predefined e-mail address for better analysis i.e. Reconcile, Print, Sort, Filter, Group, Aggregate, Slice, Dice e.t.c. using
- Desktop computer software e.g. MS Excel
- Cloud based solutions e.g. Google Docs.
Real time printing of m-pesa receipt
Features
Convert
M-Pesa text messages on your mobile device into an Excel based Spread Sheet with logical columns for easy analysis e.g. Date, Time, Ref, Status, Amount, Balance, Source Number, Source NameView
The Spreadsheet on the device or send to a predefined e-mail address for easier viewing and printing using desktop computer software e.g. MS Excel or using cloud based solutions e.g. Google Docs.Query
Transactions using a date and time range and preview the resulting excel file on the device or send to yourself as an E-Mail attachment for easier analysis including, graphing, sorting, printing, aggregating, grouping etc.Install
On a remote phone, and receive automated Excel file report of M-Pesa transactions on an hourly, daily and monthly schedule.Query
Your SMS Transactions to quickly get record or records of M-Pesa transactions occurring within a specified time period.Automatically
Send you E-Mail, on an hourly, daily and monthly schedule of your M-PESA transactions text messages using a pre configured e-mail address on the device.Manage
Your income and expenses by generating easy to analyse Excel based report of your transactions if you make all your transactions using m-pesa including, payments and receipts bank withdrawals, deposits etc.Backup
Your mobile money SMS transactions on to the gmail hence transactions can be retrieved even if the phone gets lost or the SMS messages are deleted.Excel
Work with the excel file on a desktop computer or on the device and enjoy the power of using a Spreadsheet based file to analyze your SMS transactionsExcel File Benefits
- Easy filtering of fields for analysis
- Formatting of text messages e.g. you can add color, lines, boxes etc
- Import into another application
- Printing of transactions/reports
- Sorting based on a field
- Add aggregate functions e.g. Sum, total, average, count
- Quickly Search for a specific record
- Acts as a backup of the SMS inbox, so that the transactions are available for Querying, viewing, printing even if deleted from the Phone inbox.
- Generate Graphs using Excel for easy analysis of your M-Pesa Transactions
- Query SMS Transactions to quickly get a record or records of M-Pesa transactions occurring within a specified time period of interest.
- Work with the excel file on a desktop computer or on the device and enjoy the power of using a Spreadsheet based file to analyze your SMS transactions.
- The Excel spreadsheet for contacts that can be used to send marketing SMS alerts.
- Easy to print, reconcile
- Easy to extract data for a longer time period by querying on the device.
- Automatic Backup of SMS transactions as this is sent to your e-mail address
- Easier conversion of Excel to other data formats e.g. CSV, MS Access, etc.
- This can be imported and integrated into other applications e.g. Accounting Systemsâ
Who can use PesaMail.
| Type | Notes |
|---|---|
| 1. Merchants who have Lipa na M-Pesa Tills |
Install on the phone that has the M-PESA TILL. Monitor remotely the Lipa na M-Pesa payments by getting Excel based statement of all M-PESA Transactions, hourly, daily and monthly. Backup of SMS transactions even if the user deletes from the phone. This will help in easy reconciliation of m-pesa payments received. They can auto filter the excel report generated by PesaMail to know how much has been received from a particular entity within a time period of interest. Data can be used as basis of data to import to other systems. |
2. M-Pesa users
More and more people are using M-Pesa to make their transactions. Some of them who are heavy M-Pesa users would like to analyse their M-Pesa transactions. |
Install on android phone. Those people who use m-pesa to make lots of m-pesa transactions including receiving, withdrawals, payments etc. They can auto filter the excel report generated by PesaMail to know how much has been paid or received from a particular entity within a time period of interest. They can easily reconcile their m-pesa transactions. |
Big Lipa na M-Pesa (Quality) Merchants
The following so called quality merchants are the potential business who will find this application usefull. They normally received alot of payments on lipa na na M-Pesa and hence would have problems reconcilling the same
Bars & Restaurants
Clubs & Lounges
Petrol Stations
Saccos
Hardware shops
Spare part shops
Supermarkets
FMCG Distributors
Cosmetic Shops
Hospitals
Clinics
Busy Salons
Big Barber Shops
etc.