A POS that syncs with QuickBooks, Xero or Zoho Books in Kenya
ShelfWise ·
Most small businesses in Kenya keep two sets of numbers: the till or notebook at the counter, and the accounting software their accountant uses. Someone types the totals across, usually at month end, and the two rarely agree. A POS that syncs with your accounting software closes that gap every night.
Why typing totals across goes wrong
- It happens late, so problems show up weeks after the day they happened.
- M-Pesa, cash and credit sales get lumped together, so the bank and M-Pesa accounts never reconcile.
- Cost of goods and stock losses are guessed, so profit is guessed too.
- The accountant spends paid hours on data entry instead of advice.
What a proper sync sends
A good POS doesn't send every receipt one by one; your books would drown in thousands of tiny entries. It adds the day up by account and sends one balanced journal entry per day:
| Line | Debit | Credit |
|---|---|---|
| Cash and M-Pesa received | the money that came in | |
| Credit sales (debtors) | what customers owe | |
| Sales | the day's sales | |
| Cost of goods sold | what the goods cost you | |
| Inventory | the stock that left | |
| Expenses | rent, wages, transport |
Because each payment method has its own account, your M-Pesa account in the books matches your M-Pesa statement, and your cash account matches the drawer.
What to check before you choose
- Does it connect directly, or only export a file? A direct connection runs every night without anyone remembering.
- Can you use your own account names and codes? Your accountant has a chart of accounts; the POS should fit it, not the other way round.
- What happens when a day changes later, like a sale voided the next morning? The entry should be replaced, not duplicated.
- Is cost of goods sent too? Without it, profit in your books is wrong.
- Who holds the money? The POS should only send records. Customer payments should go straight to your own Till, Paybill or bank.
QuickBooks, Xero, Zoho Books or Odoo?
All four work well for small businesses in Kenya, and accountants here use all of them. QuickBooks Online and Xero are the most common with accounting firms. Zoho Books is popular with businesses already using other Zoho apps. Odoo suits businesses that want a full ERP. Choose the one your accountant knows; a good POS should connect to any of them.
Common questions
Can a POS send sales to QuickBooks automatically?
Yes, if it connects directly. ShelfWise sends each finished day to QuickBooks Online as one balanced journal entry every night, with sales split by payment method, cost of goods and expenses.
Does it work with QuickBooks Desktop?
Not directly, because QuickBooks Desktop runs on one computer. Download the journal as an IIF file from ShelfWise and import it into QuickBooks Desktop.
Will it create duplicate entries?
It shouldn't. ShelfWise records what it has sent for each day; a day that changes later is replaced, and a day is never sent twice.
Does syncing file my taxes or KRA eTIMS?
No. Syncing keeps your books up to date for your accountant. Filing returns and eTIMS invoices are separate.
Read next
- How to get M-Pesa sales into your accounting software without typingGet M-Pesa Till and Paybill sales into QuickBooks, Xero, Zoho Books or Odoo automatically, matched to each sale, so your books agree with your M-Pesa statement.Read
- How to choose the best POS system for a small business in KenyaA checklist for choosing a POS in Kenya: M-Pesa matching, offline sales, stock control, phone or computer, Kiswahili, support, price and questions to ask every vendor.Read
- KRA eTIMS for small shops: what it is and how to startA plain guide to KRA eTIMS for small businesses in Kenya: who it applies to, the free KRA options, how it fits with your POS, and records to keep.Read