
Hi all, Is the MPESA Pay-Bill operation also sms based as in when u pay your elec bill via PayBill does KPLC receive an MPESA SMS? Davis

Hi Davis, They have an MPESA web portal from which they download the transactions periodically. For KPLC i suspect they download the payments once a day. On Tue, May 18, 2010 at 3:56 PM, Davis Waithaka <daviswaithaka@gmail.com>wrote:
Hi all,
Is the MPESA Pay-Bill operation also sms based as in when u pay your elec bill via PayBill does KPLC receive an MPESA SMS?
Davis
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

Do you know what format they get it in, as in is it a database (eg MySql)? excel? CSV? Davis

I'm curious, How do they download the transactions exactly? Copy-Paste, or in some format, and do they do the entries manually to their system?
Hi Davis,
They have an MPESA web portal from which they download the transactions periodically. For KPLC i suspect they download the payments once a day.
On Tue, May 18, 2010 at 3:56 PM, Davis Waithaka <daviswaithaka@gmail.com>wrote:
Hi all,
Is the MPESA Pay-Bill operation also sms based as in when u pay your elec bill via PayBill does KPLC receive an MPESA SMS?
Davis
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

Its either in pdf or xls. [image: Google Talk:] kihahu [image: Google Wave:] kihahu [image: Y! messenger:] johnkihahu Contact Me [image: Blogger] <www.kihahu.blogspot.com>[image: Twitter]<http://www.twitter.com/kihahu>[image: Wordpress] <kihahu.wordpress.com> On Tue, May 18, 2010 at 4:31 PM, <sospeter@elimu.co.ke> wrote:
I'm curious,
How do they download the transactions exactly? Copy-Paste, or in some format, and do they do the entries manually to their system?
Hi Davis,
They have an MPESA web portal from which they download the transactions periodically. For KPLC i suspect they download the payments once a day.
On Tue, May 18, 2010 at 3:56 PM, Davis Waithaka <daviswaithaka@gmail.com>wrote:
Hi all,
Is the MPESA Pay-Bill operation also sms based as in when u pay your elec bill via PayBill does KPLC receive an MPESA SMS?
Davis
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f...
------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f...
------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

I guess not automated yet. Coz I've received an invalid code once and after calling kplc support they just asked me to read the number and corrected one digit. -----Original Message----- From: skunkworks-bounces@lists.my.co.ke [mailto:skunkworks-bounces@lists.my.co.ke] On Behalf Of sospeter@elimu.co.ke Sent: Tuesday, May 18, 2010 4:31 PM To: Skunkworks Mailing List Subject: Re: [Skunkworks] Pay Bill Operation I'm curious, How do they download the transactions exactly? Copy-Paste, or in some format, and do they do the entries manually to their system?
Hi Davis,
They have an MPESA web portal from which they download the transactions periodically. For KPLC i suspect they download the payments once a day.
On Tue, May 18, 2010 at 3:56 PM, Davis Waithaka <daviswaithaka@gmail.com>wrote:
Hi all,
Is the MPESA Pay-Bill operation also sms based as in when u pay your elec bill via PayBill does KPLC receive an MPESA SMS?
Davis
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f bjAwOUE&hl=en
------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f bjAwOUE&hl=en
------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f bjAwOUE&hl=en ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

You can either download as a pdf document or an excel worksheet. It's basically a statement of all transactions sent to their biller code for a defined period.Most organisations have a tool that they use to upload the statement in excel format to whatever billing system they are using. On Tue, May 18, 2010 at 4:31 PM, <sospeter@elimu.co.ke> wrote:
I'm curious,
How do they download the transactions exactly? Copy-Paste, or in some format, and do they do the entries manually to their system?
Hi Davis,
They have an MPESA web portal from which they download the transactions periodically. For KPLC i suspect they download the payments once a day.
On Tue, May 18, 2010 at 3:56 PM, Davis Waithaka <daviswaithaka@gmail.com>wrote:
Hi all,
Is the MPESA Pay-Bill operation also sms based as in when u pay your elec bill via PayBill does KPLC receive an MPESA SMS?
Davis
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f...
------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f...
------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

Thanks Newbie! Let me see what i can work out then On Tue, 2010-05-18 at 18:56 +0300, tech newbie wrote:
You can either download as a pdf document or an excel worksheet. It's basically a statement of all transactions sent to their biller code for a defined period.Most organisations have a tool that they use to upload the statement in excel format to whatever billing system they are using.
On Tue, May 18, 2010 at 4:31 PM, <sospeter@elimu.co.ke> wrote:
I'm curious,
How do they download the transactions exactly? Copy-Paste, or in some format, and do they do the entries manually to their system?
> Hi Davis, > > They have an MPESA web portal from which they download the transactions > periodically. For KPLC i suspect they download the payments once a day. > > On Tue, May 18, 2010 at 3:56 PM, Davis Waithaka > <daviswaithaka@gmail.com>wrote: > >> Hi all, >> >> Is the MPESA Pay-Bill operation also sms based as in when u pay your >> elec >> bill via PayBill does KPLC receive an MPESA SMS? >> >> Davis >> >> >> _______________________________________________ >> Skunkworks mailing list >> Skunkworks@lists.my.co.ke >> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >> ------------ >> Skunkworks Server donations spreadsheet >> >> http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... >> ------------ >> Skunkworks Rules >> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >> ------------ >> Other services @ http://my.co.ke >> > _______________________________________________ > Skunkworks mailing list > Skunkworks@lists.my.co.ke > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > Skunkworks Server donations spreadsheet > http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... > ------------ > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Davis Waithaka Maina Business Development Manager Systems Kenya Solutions 4th Fl. KCB Building Enterprise Rd., Nairobi www.systemskenya.com +254 721 305 374

Dear all, Safaricom will give u what they call a busines terminal. Just the same as what the M-Pesa Agents have. Its basically a sim card that is tied to your business number. So once a transaction hits safcom dbase you also get an SMS confirmation on the simcard. So it depends with an organisation, and how they want to get there information. This will only give you the correct transactions but things like a user sending 30ksh will only reflect on the web interphase. Zack On Wed, May 19, 2010 at 9:09 AM, Davis Waithaka <daviswaithaka@gmail.com>wrote:
Thanks Newbie!
Let me see what i can work out then
On Tue, 2010-05-18 at 18:56 +0300, tech newbie wrote:
You can either download as a pdf document or an excel worksheet. It's basically a statement of all transactions sent to their biller code for a defined period.Most organisations have a tool that they use to upload the statement in excel format to whatever billing system they are using.
On Tue, May 18, 2010 at 4:31 PM, <sospeter@elimu.co.ke> wrote:
I'm curious,
How do they download the transactions exactly? Copy-Paste, or in some format, and do they do the entries manually to their system?
Hi Davis,
They have an MPESA web portal from which they download the transactions periodically. For KPLC i suspect they download the payments once a day.
On Tue, May 18, 2010 at 3:56 PM, Davis Waithaka <daviswaithaka@gmail.com>wrote:
Hi all,
Is the MPESA Pay-Bill operation also sms based as in when u pay your elec bill via PayBill does KPLC receive an MPESA SMS?
Davis
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f...
------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f...
------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________Skunkworks mailing listSkunkworks@lists.my.co.kehttp://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks------------Skunkwo... Server donations spreadsheethttp://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... Ruleshttp://my.co.ke/phpbb/viewtopic.php?f=24&t=94------------Other services @ http://my.co.ke
-- Davis Waithaka Maina Business Development Manager Systems Kenya Solutions 4th Fl. KCB Building Enterprise Rd., Nairobiwww.systemskenya.com +254 721 305 374
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards, Zack K. Githinji Technical Officer, Cell:+254 722 649199 E-mail:zachgithinji@gmail.com <E-mail%3Azachgithinji@gmail.com> "God grant me the serenity to accept the things I cannot change, the courage to change the things I can, and the wisdom to know the difference."
participants (6)
-
Davis Waithaka
-
Mash
-
sospeter@elimu.co.ke
-
tech newbie
-
Tony Gacheru
-
Zack Githinji