Most growing businesses in Kenya run on a spreadsheet at some point. Stock, debtors, school fees, loans, deliveries: someone builds a sheet, it works, and the business grows around it. Spreadsheets cost little, everyone can open one, and nobody has to approve a purchase.
The trouble builds slowly, so it is easy to miss.
Signs the spreadsheet is holding you back
- There are several versions. "Stock FINAL", "Stock FINAL 2" and a copy on someone's laptop. Nobody is sure which is right.
- One person understands it. Whoever wrote the formulas knows where everything is. When they are on leave, the numbers wait.
- Things are typed in twice. A payment lands on the Paybill, someone reads the SMS and types it into the sheet. An order arrives on WhatsApp and is copied across by hand. Each copy is a chance for a mistake.
- You cannot see the numbers on your phone. To know today's sales or who still owes you, you call the office.
- Everyone can see everything. Salaries sit in the same file as stock, or the whole team can edit customers' phone numbers. Under Kenya's Data Protection Act, you answer for who sees personal data.
- Nobody knows who changed what. A figure is wrong, and there is no way to tell when it changed or who changed it.
One of these is a nuisance. Three or more usually means the business is paying for the spreadsheet in hours every week, and nobody has added them up.
Try the cheap fix first
Before you pay for software, tidy what you have.
Keep one copy in a shared online spreadsheet, so everyone works on the same file. Split it by job into tabs or files: stock, sales, debtors. Lock the cells people should not edit, and give each person access to what their job needs. Write one page that says what each column means and who updates it.
For many small businesses this is enough for another year. It costs an afternoon. If it still fails, you will have learnt which parts of the work a sheet cannot handle, and that list is most of the brief for a proper system.
Ready-made software or a custom system
If the tidy sheet still fails, look first at ready-made software for your trade: point of sale, accounting, school management, salon booking. If one fits the way you work, it is usually quicker and cheaper to start with than anything built for you.
A custom system makes sense in three cases. The ready-made options force you to change a process that works. You need two things joined that no product joins, such as M-Pesa payments matched to your own orders. Or you have already paid for a tool that staff stopped using because it did not fit.
Whatever you choose, check that you can export all your data in a format you can open. If you cannot get your records out, you do not fully own them.
What a first version should do
Start with one process: the one that costs the most time or money today. For a shop that might be orders and payments. For a school it is fees. For a SACCO it is loan applications.
A good first version does that one job from start to finish:
- one place where each record is created, instead of a copy in each department;
- M-Pesa payments matched to that record automatically, from Safaricom's confirmation rather than someone reading an SMS;
- a screen the owner can check on a phone;
- access set by role, so staff see what their job needs;
- a log of who changed what, and when;
- if you issue tax invoices, eTIMS invoices sent through a KRA-approved provider instead of being typed again.
Leave reports, dashboards and the second process until the first one runs and staff use it every day. A system that does one job well gets used. One that tries to do everything on day one is often dropped for the old sheet.
Time and cost
For a first system like this, we plan on six to twelve weeks. The time and the cost depend mostly on how many other tools it has to connect to: M-Pesa, eTIMS, WhatsApp, an existing accounts package.
Before any build, we send a free written scope within 48 hours of a walkthrough call. It says what would be built and what would not, so you can decide with the details in front of you, and you keep it whether or not you go ahead.