How to get M-Pesa sales into your accounting software without typing
ShelfWise ·
M-Pesa is where most of a Kenyan shop's money comes in, and it's the hardest part to get into the books. Statements list hundreds of payments with names and codes but no idea what was sold. Here is how to get M-Pesa into QuickBooks, Xero, Zoho Books or Odoo properly, without typing.
Why importing the M-Pesa statement isn't enough
You can download an M-Pesa statement and import it as a bank feed, and many businesses do. But the statement only says money came in. It doesn't say which sale it paid for, what was sold, or what those goods cost. Your accountant still has to work out sales and profit by hand, and payments for credit sales get mixed up with new sales.
The better way: match first, then send
- Connect your own Till or Paybill to your POS through Daraja, Safaricom's official M-Pesa API.
- Every payment is reported to the POS and matched to its sale, online order or booking, so the POS knows exactly what each payment was for.
- Each night the POS sends the day to your accounting software: M-Pesa received into your M-Pesa account, the sales they paid for, and the cost of those goods.
- Your accountant reconciles the M-Pesa account against the statement once, instead of building the books from it.
Set up your accounts once
In your accounting software, have a separate account for M-Pesa (a bank-type account), one for cash and one for each bank. Tell your POS which account each payment method goes to. From then on, every shilling lands in the right place.
Common questions
Can I import my M-Pesa statement into QuickBooks or Xero?
Yes, as a bank statement. But it only shows money in and out, not what was sold or what it cost. A POS that matches payments to sales and sends the day to your books gives you sales and profit too.
Does this work with a Till and a Paybill?
Yes. Both connect through Daraja, and payments to either are matched and sent the same way.
Does the POS hold my M-Pesa money?
It shouldn't. With ShelfWise, customers pay your own Till or Paybill and the money goes straight to you. ShelfWise only sends the records.
Read next
- A POS that syncs with QuickBooks, Xero or Zoho Books in KenyaStop retyping sales into QuickBooks, Xero, Zoho Books or Odoo. How a POS sends each day's sales, M-Pesa, stock and expenses to your books, and what to check.Read
- How to connect your M-Pesa Till or Paybill to a POS (Daraja, step by step)Connect your own M-Pesa Till or Paybill to your POS through Safaricom's Daraja API: Go Live, the passkey, testing with KSh 1, and fixing common errors.Read
- M-Pesa Till vs Paybill: which one should your business use?Buy Goods Till or Paybill for your business in Kenya? How each works, who each suits, how customers pay, and how both connect to a POS through Daraja.Read