← All guides

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

  1. Connect your own Till or Paybill to your POS through Daraja, Safaricom's official M-Pesa API.
  2. 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.
  3. 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.
  4. 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

Ready when your customers are.

Start free for 14 days. Set up in an afternoon, on the phone you already have.