Skip to content

Business systems 5 min read

Signs your business needs a custom system instead of spreadsheets

How Ugandan hotels, schools and shops can tell they have outgrown Excel and paper books, what a business system changes, and how to start without overspending.

By Persmon Technologies team
Dashboard of HMS, the hotel management system built by Persmon, showing available rooms, arrivals, outstanding balances and revenue charts
In this guide
  1. Seven signs you have outgrown spreadsheets
  2. What this looks like in hotels, schools and shops
  3. What a system will not fix
  4. Ready-made or custom?
  5. How to start without overspending
  6. Next step

Spreadsheets are where most Ugandan businesses start, and for good reason. Excel is already on the office computer, everyone roughly knows how to use it, and a new column costs nothing. Plenty of businesses should stay on spreadsheets for years.

But there is a point where the spreadsheet starts running the business instead of the other way round. This guide covers the warning signs we see most often in hotels, schools and shops, what a proper system changes, and how to move without paying for more than you need.

Seven signs you have outgrown spreadsheets

1. Two people keep two different versions of the truth

The front desk has one file, the manager has another, and the accountant has a third that was emailed last Tuesday. When someone asks “how many rooms are free on Friday?” or “how much does this parent still owe?”, the answer depends on whose file you open. Once your team spends time arguing about which number is right, the spreadsheet has stopped saving time.

2. Month-end takes days of copying and pasting

If closing the month means pulling figures from several sheets, retyping them into a summary and checking the totals by hand, you are paying staff to do work a system does in seconds. Worse, every retyped figure is a chance for a mistake.

3. You cannot tell who changed what

A spreadsheet rarely records who deleted a row, edited a price or marked an invoice as paid. In a business that handles cash and Mobile Money every day, that gap matters. A system with staff logins and an audit log shows who did what and when, which protects honest staff as much as it discourages dishonest ones.

4. Stock numbers never match the shelves

Many stock sheets store only the current quantity. When the count is wrong, nobody can tell whether the gap came from a sale that was not recorded, a delivery that was entered twice or something walking out of the store. A system that records stock as a list of movements (purchases, sales, transfers and adjustments) lets you trace every unit.

A guest at reception waits while staff scroll through bookings. A parent calls about a balance and has to be called back. A customer asks if an item is in stock and someone walks to the store to check. Each delay is small, but they add up to a business that feels slow, even when the team is working hard.

6. The file only works on one computer

Spreadsheets live on a desktop, a flash disk or an email thread. The director cannot check today’s sales from a phone, the branch cannot see head office stock, and when the computer breaks, the records may go with it.

7. Everything depends on one person

If one staff member is the only one who understands the formulas, your business is one resignation away from trouble. Systems with clear screens and a user guide make the process belong to the organisation, not the individual.

If three or more of these sound familiar, it is worth at least pricing a system.

What this looks like in hotels, schools and shops

Hotels and guesthouses

The usual pattern is a bookings book or sheet at reception, separate bills at the bar and restaurant, and housekeeping tracked on paper. That is how double bookings and unpaid bills slip through. A hotel management system brings reservations, rooms, housekeeping, guests, payments and the restaurant and bar into one place. Our own product, HMS, blocks double bookings at the database and includes a restaurant and bar point of sale with Mobile Money. It has a public demo you can try before talking to anyone.

Schools

Fee books, marks spreadsheets and class registers are often kept by different people. Balances are worked out by hand, report cards are retyped every term, and records leave with the staff member who kept them. A school management system keeps one record per learner for admissions, fees, marks and attendance, so the bursar, teachers and head teacher all work from the same information.

Shops, pharmacies and distributors

Here the pain is usually stock and cash. A point of sale and inventory system records each sale at the till, updates stock as it happens, compares expected and counted cash for each shift, and gives you sales reports without a spreadsheet. If you also sell online, an online shop can share the same stock so you do not sell items you no longer have.

What a system will not fix

It is worth being honest about this. Software does not fix a process nobody agrees on. If your team does not have a clear way of recording a delivery or approving a discount today, a system will force that conversation, which is useful, but it will not make the decision for you.

A system also needs people to use it. Training, a simple user guide and a manager who insists that “if it is not in the system, it did not happen” matter as much as the software itself.

Ready-made or custom?

You have three broad options:

  1. Off-the-shelf software. Quick to start and often cheaper per month, but you adapt your process to the software. Check that it supports UGX, Mobile Money and the way Ugandan businesses actually work.
  2. A ready-made product with local support. Products such as our HMS for hotels and OMS for professional firms cover most needs out of the box and cost far less than building from scratch, with a local team who can set them up and train your staff.
  3. A custom system. Built around your exact process. It costs more up front, so it makes sense when your process gives you an edge or when nothing ready-made fits.

A good supplier will tell you which of these fits, even if the answer is “not custom yet”.

How to start without overspending

  • Write down the three problems that cost you most. Not a feature wish list. For example: “we double-book rooms”, “we cannot see fee balances”, “stock never matches”.
  • Start with one module. Many organisations begin with bookings, fees or stock, then add more once staff are comfortable.
  • Ask to see screens before you pay for code. A clickable prototype lets your team test the flow and catch misunderstandings early, when they are cheap to fix.
  • Get the price in writing. Scope, timeline, payment schedule and what happens after launch should all be in a written quote.
  • Ask about your data. Where is it hosted, who can see it, how is it backed up, and can you take it with you if you leave?

Next step

If your spreadsheets are starting to cost you time, money or sleep, tell us how your team works today. We will tell you honestly whether you need a ready-made product, a custom build or just a better spreadsheet, and you get a fixed written quote before any payment.

Get a free quote or read more about our custom software development.

Written by

The Persmon Technologies team

Software, systems and digital growth for East African businesses, from our office in Kampala. These guides answer the questions business owners ask us most.

About us See our work

All guides

Liked this guide? Get the next one.

What we are building, what is working online for Ugandan businesses, and new guides before anyone else. No spam, unsubscribe any time.

  • Monthly at most
  • Practical guides
  • Your email stays with us

No spam. Unsubscribe any time. See our privacy policy.

Get a free quote