7 signs your business has outgrown spreadsheets and needs custom software

In this article14 sections

1. Why spreadsheets work so well, until they suddenly do not
2. Sign 1: Only one person really understands the file
3. Sign 2: The same information is typed in again and again
4. Sign 3: Small errors are now costing real money
5. Sign 4: Several people need to work on the same data at the same time
6. Sign 5: You cannot see the real numbers when you need them
7. Sign 6: Customers, staff or partners need to interact with your data
8. Sign 7: Your process is unique, and off-the-shelf tools do not fit
9. Custom software for business, ready-made software or a better spreadsheet?
10. What custom software for business costs in Nigeria
11. How to move away from spreadsheets without chaos
12. Key takeaways
13. Frequently asked questions
14. Next step: turn your spreadsheets into a system that works for you

Many owners only start looking at custom software for business after something expensive breaks. Chinedu runs a building materials distribution company in Onitsha. When I first met him, he opened his laptop and showed me fourteen Excel files: “Price list final”, “Price list final 2”, “Stock March”, “Stock March (Emeka’s copy)”, “Customers debt”, “Salaries”, and so on. His two salesmen quoted different prices to the same customer on the same day, because each had a different version of the price list on his phone. His accountant spent the first three days of every month matching sales files to bank transfers and still found ₦300,000 that could not be explained. Then one Tuesday, the laptop died. The file called “Customers debt” was on it, and the last backup was seven weeks old.

Chinedu did not have a laziness problem or a staff problem. He had a business that had grown past its tools. A spreadsheet is a wonderful thing for the first year or two of a business. But at some point the sheet becomes the business, and that is the moment custom software for business starts to make sense. I am Dan Audu, a software engineer in Abuja, and for eight years I have watched this moment arrive in shops, schools, clinics, logistics companies and startups in Abuja, Lagos, Port Harcourt, Kano and Onitsha.

In this article I will give you seven clear warning signs that your business has outgrown spreadsheets, explain each with Nigerian examples, and then help you decide between a better spreadsheet, ready-made software and custom software. I will show you what custom software costs in naira as at 2026, how to start small, and how to choose a developer without getting burnt. If you recognise three or more of the signs in your own business, keep reading with a pen in your hand.

Why spreadsheets work so well, until they suddenly do not

Let me be fair to spreadsheets first. I use them every week, and I am not telling you to throw Excel or Google Sheets away. They are fast, cheap and flexible. You can start a sheet in five minutes without asking a developer. For a new shop, a small event business or a side hustle, a spreadsheet is the right tool.

What spreadsheets do well

A spreadsheet is excellent for one person doing analysis, quick calculations, budgets, one-off reports and small lists. It is good for testing an idea before you commit to a system. It is also excellent as an export format: even the best software should let you download your data to Excel. The problem is not the spreadsheet itself. The problem is using a personal calculation tool as the shared memory of a growing company.

The moment they break

Spreadsheets break in a quiet way. Nothing explodes. Instead, small frictions pile up: an extra column here, a second file there, a new tab for the branch, a WhatsApp message to confirm what the number should be. Each fix feels reasonable. Then one day you discover that no single person can say how many units are in the store, what the customer owes, or which price is correct. The cost is not the spreadsheet. The cost is the hours and mistakes that hide behind it.

Why this matters in Nigeria

Several local realities make this worse. Files travel by WhatsApp and flash drive, so there are always many copies. Laptops crash, get stolen or get repaired with the data still inside. Staff move on quickly, and with the wave of “japa” (people leaving Nigeria for opportunities abroad), the one person who understood the sheet may be in Toronto next year. Power cuts interrupt work and lead to unsaved files. Data costs make cloud tools feel expensive. And many owners run several branches or a mix of cash, POS and bank transfer, which multiplies the number of sheets. If you want a look at the same issue for customer records, see my article on CRM versus spreadsheets.

Sign 1: Only one person really understands the file

Ask yourself a simple question. If your “Excel person” resigned tomorrow, how long would it take before something important broke? If the honest answer is “a week” or “I do not know”, you have your first sign.

The hidden hero problem

In many Nigerian offices, one staff member builds the master sheet: the formulas, the macros (small automatic scripts inside Excel), the colour codes that only she understands. She knows that column K must never be touched, and that the total on the last tab is calculated with a formula on tab six. Nobody else dares to open it. This person becomes a single point of failure. When she goes on maternity leave, gets a better job or emigrates, the business is stuck.

What it costs when they leave

I once helped a logistics company in Lagos after their operations officer left for a job in Canada. He had built a beautiful dispatch sheet, but no one knew how the fuel and driver allowance figures were calculated. It took the company six weeks and two consultants to reverse-engineer it, and in that time, they underpaid drivers twice and had to apologise. Software also depends on people, but a well-built system has documentation, roles and a support contract. A spreadsheet has a smart person and hope.

A quick test you can run today

Choose your most important spreadsheet. Ask another staff member to update it while you watch, without asking the usual person for help. If they hesitate, get lost or break a formula, your process depends on one brain. The fix does not always require software right away, but it does require you to write the process down and to notice the risk.

Sign 2: The same information is typed in again and again

Double entry (typing the same information into more than one place) is a bad sign. It wastes time, and it creates mismatches. Watch for it in your daily work.

Where double entry hides

A sale is written in the sales book, typed into the sales sheet, then keyed into the stock sheet, then summarised for the accountant. A new customer is written on paper at the counter, saved in a phone contact, and added to the customer sheet at the end of the week. A staff attendance list is copied from a register to the payroll sheet. Every repetition means more time and more chances for a mistake.

The mismatch problem

Once the same data lives in several places, the versions drift apart. The stock sheet says there are 40 bags of cement while the sales sheet suggests you have sold 45. The warehouse manager says 38. The accountant says the numbers are close enough. But which one is right, and how much is lost? For a distributor of fast-moving goods, even a 2% mismatch can be a lot of money. If your monthly sales are ₦20 million, 2% is ₦400,000 a month, or ₦4.8 million a year.

A story from a supermarket

A supermarket owner in Enugu told me that her cashier wrote each sale in a book, her store keeper wrote deliveries in another book, and her accountant copied both into Excel at night. She had three people typing what should have been captured once at the till. When we replaced this with a POS system that reduced stock at the moment of sale, she stopped hiring an extra data clerk and recovered several hours a day for the accountant. If this sounds like you, my inventory management system page shows how a single record can feed sales, stock and reports.

Sign 3: Small errors are now costing real money

Spreadsheet mistakes are famous for a reason. A wrong cell reference, a formula dragged one row too far, a number typed with one zero missing, a sort that scrambles half the columns. Nobody notices, and the wrong result flows into decisions.

Wrong prices, wrong discounts

Price lists are a common danger. Someone updates the price of a product in one sheet but not in the quote template. A discount formula applies to all rows when it should apply to only some. A salesman quotes ₦145,000 instead of ₦154,000 because the digits were reversed on his phone. Each error is small. Over a year, they add up to real loss, and customers also learn that your prices are “flexible”, which weakens your position.

Wrong stock, wrong debts

Debtors’ lists are another risk. If a customer’s payment is recorded in one sheet and not in another, you may chase someone who already paid, which damages trust. Or you may forget someone who still owes you ₦800,000. I have seen a school lose track of tens of thousands in fees because a single sorting mistake attached the wrong pupils to the wrong balances. Software can enforce rules that spreadsheets cannot, such as “a payment must be linked to an invoice” and “the price comes from one master list”.

What good software does differently

A well-designed system validates inputs. It will refuse a quantity of “-5”, warn you when a discount exceeds your limit, prevent two people from editing the same record at the same time and keep a history of every change. That does not make errors impossible, but it makes them rare and traceable.

Sign 4: Several people need to work on the same data at the same time

A spreadsheet was designed for one person at a keyboard. When a team of five, or a company with three branches, tries to work in it together, cracks appear quickly.

Version chaos

You know the file names: “Sales report final”, “Sales report final FINAL”, “Sales report Bola edit”. Someone emails a sheet, someone else edits an old copy from WhatsApp, and a third person saves over both. Cloud sheets like Google Sheets help with live editing, but they do not solve the deeper problem: no rules about who can change what, and no clear process for approvals.

Everyone sees everything, or nobody sees what they need

Because a spreadsheet is one file, sharing it often means sharing all of it. The sales assistant can see salaries. The branch manager in Kaduna can see the margins of the Lagos branch. Or the opposite happens: you lock everything so tightly that people cannot do their jobs. Software solves this with roles and permissions. A cashier sees the till screen. A store keeper sees stock. A manager sees reports. The owner sees everything.

Who changed this, and when?

When the number in a cell is wrong, you cannot ask the sheet who changed it. Software with an audit trail (an automatic record of who did what and when) settles disputes quickly. For any business with cash, stock or client money, that record is powerful. It discourages fraud, because staff know their actions are logged, and it protects honest staff who are falsely accused.

Working with poor internet and power

Cloud-based sheets need internet, and internet in Nigeria is not always stable. That is why I often build systems that keep working offline, then sync when the network returns, especially for shops and clinics in areas with weak connections. A generic spreadsheet cannot offer that without a lot of pain.

Sign 5: You cannot see the real numbers when you need them

Ask yourself: how long does it take to answer these questions? “How much did we sell today?” “Which product made the most profit this month?” “Who owes us money and for how long?” “What is the stock value in each branch?” If the answers take hours or days, and each answer is slightly different depending on who you ask, you do not have a reporting system. You have a report-building job.

Month-end is a monster

In many businesses, the first week of every month disappears into reconciliation: matching bank statements, POS reports, cash counts and invoices. The accountant works late, staff wait for numbers and the owner makes decisions on last month’s picture, instead of today’s. With proper software, most of this is automatic. Sales flow into reports as they happen. Bank transfers and payments can be matched to invoices with a few clicks, using connections to services like Paystack or Flutterwave where appropriate. The month-end becomes a review, not a rescue mission.

Owners flying blind

I know many owners in Lagos and Abuja who travel often. They run their businesses through phone calls and WhatsApp: “Send me today’s sales.” “How much is in the account?” That works while the business is small. When you have five branches or 40 staff, it is not a strategy. A dashboard (a simple screen that shows the key numbers) on your phone that shows sales, expenses, stock alerts and debtors changes how you sleep. A simple example: an owner of three pharmacies in Port Harcourt now opens one page each morning and sees expiry alerts, yesterday’s sales and the products that will run out this week. The information was always there. It was just buried in different sheets.

Decisions need trends, not snapshots

Spreadsheets give snapshots. Software can show trends across months and branches, and highlight what changed. That helps you decide which products to reorder, which staff to reward, which branch needs help and where marketing money is working. If you want a broader picture, my article on data analytics for small and medium businesses covers this in more depth.

Sign 6: Customers, staff or partners need to interact with your data

A spreadsheet is private and internal. But modern customers expect to book, pay, track and get updates without calling. Modern staff expect to work from their phones. Partners expect their systems to talk to yours. The moment you need people outside your office to see or change some of your data, spreadsheets stop being enough.

Customers who want self-service

Think of the questions your team answers by phone every day: “Where is my order?” “How much do I still owe?” “Is my child’s result ready?” “Is the apartment available for these dates?” Every call costs staff time. A customer portal or a simple mobile app can answer them automatically. A logistics company in Lagos that gave customers a tracking link reduced status calls by about a third within two months, and the dispatch team could finally finish their work. That is what custom software for business can do: turn repeat questions into self-service.

Payments and connections to other tools

If you want customers to pay online through Paystack or Flutterwave, to receive receipts on WhatsApp, or to sync stock with your website and your POS, you need software that connects. Spreadsheets can be linked in a clumsy way, but the results are fragile. A custom system can call these services directly, verify payments automatically and update the right records. See my article on API integrations explained for a plain description of how systems talk to each other.

Staff in the field

Sales reps, drivers, technicians and inspectors work outside the office. If they still fill in a paper form and send a photo on WhatsApp, someone must retype it. A mobile form that syncs to the office, works offline and records the location and time, removes that step. For a company with 30 field staff, that can free up a person or two in the back office.

Sign 7: Your process is unique, and off-the-shelf tools do not fit

Sometimes you have tried ready-made software and found it awkward. You paid for it, you used it for a few months, and now the team keeps a parallel spreadsheet “just for the things it cannot do”. That is a strong sign that you have a process that is different enough to need its own tool.

The workaround pile

Watch for signs of workarounds: a paid app for invoicing, a separate sheet for commissions, another for delivery, and a WhatsApp group for approvals. Each tool does its own job, but the gaps between them are filled by people. Those people are your most expensive form of integration. A single tailored system can connect these steps and remove the manual bridges.

Your rules are your advantage

Many Nigerian businesses have rules that generic software does not understand: layered discounts for distributors, weekly instalment plans for customers, fees that vary by term and class, commissions for agents, multi-currency prices tied to the dollar, or approval chains that reflect how your family business really decides. If your competitive advantage is in how you do things, forcing yourself into somebody else’s structure can weaken it. Custom software encodes your way of working, so that it becomes easier to repeat and to scale.

Subscriptions that keep growing

Many SaaS tools (software you rent monthly) are billed in dollars per user. As your team grows and the naira moves, the cost can become painful. Five tools at $30 each per month for ten users is a lot more than it looks in year three. I explain the trade-offs in my article on SaaS versus custom software. Sometimes a custom system pays for itself within two years simply by replacing rent with ownership.

Back to Chinedu in Onitsha. He was seeing four of the seven signs: one person held the price sheet in her head, orders were typed twice, prices were quoted wrongly and month-end took three days. We did not start with a huge system. We built a simple web application with one price list, one customer record and one order form, so that his salesmen could raise quotes from their phones and the store could see confirmed orders instantly. Within two months, the month-end reconciliation dropped from three days to about half a day, and the quotes stopped clashing. The big win, he said, was that he could stop being the human bridge between his files.

Custom software for business, ready-made software or a better spreadsheet?

Seeing the signs does not automatically mean you need to build something from scratch. Sometimes a better spreadsheet is enough. Sometimes ready-made software is exactly right. Custom software makes sense when your needs are truly specific, or when the software is part of how you compete. Here is the decision table I use with clients.

When a better spreadsheet is enough

If you have two or three signs at a mild level, try the cheap fixes first. Keep one master file in a shared drive, not in emails. Give each sheet an owner. Lock formulas. Use data validation (drop-down lists and rules that limit what can be typed). Write a one-page guide to how the sheet works. Back it up daily. This can buy you a year or two at little cost, and it will also give you a very clear description of your process, which helps any future software project.

When ready-made software is the smart choice

For standard needs, do not build. Accounting, payroll, email marketing and basic point-of-sale often work best with existing products. You get updates, support and years of experience built in. I explain the trade-offs in my article on no-code versus custom development. My rule is simple: never build what you can safely rent, unless the rent hurts or the fit is poor.

When custom software is the smart choice

Choose custom software when the process is your advantage, when several tools must be joined together, when you need control over your data and roadmap, when subscriptions per user are becoming a burden or when customers need a branded experience. My software development service in Nigeria is built for exactly these cases, and my business process automation service focuses on removing the manual bridges between steps.

What custom software for business costs in Nigeria

Cost is the question every owner asks first. Prices vary with scope, quality and the developer you choose, so treat these as rough ranges as at 2026. Exchange rates, team size and complexity move them. A serious developer should give you a written scope and a fixed price or clear milestones after a discovery conversation.

What drives the price

The number of user roles, the number of screens, the number of integrations (Paystack, WhatsApp, SMS, accounting, biometric devices), the need for a mobile app and offline mode, the volume of data to migrate from old sheets and the level of reporting all push the cost up or down. The clearer your process is before we start, the cheaper the build. Unclear ideas cost more because the developer spends time discovering them. For app costs in particular, see my guide on mobile app cost in Nigeria.

The costs after the build

Software is not a one-time purchase. Plan for hosting (usually ₦10,000 to ₦80,000 a month for a small to medium system as at 2026), a domain and SSL, backups, small improvements and support. A common maintenance budget is 10% to 20% of the build cost per year, or a monthly retainer of roughly ₦50,000 to ₦300,000 depending on how active the system is. Training and change management also cost time. Owners who skip these often blame the software for problems that were really about people not being ready.

A simple payback picture

Here is an illustrative example. A distributor with ₦20 million monthly sales spends ₦2.8 million on a custom order and stock system. It replaces two part-time data clerks costing about ₦90,000 each a month, so ₦180,000 a month. It also reduces price and stock mistakes by about 1% of sales, which is around ₦200,000 a month. Together that is roughly ₦380,000 a month. Add ₦40,000 a month for hosting and support, and the net gain is around ₦340,000 a month. The system pays for itself in about eight months. Your numbers will be different, but you can run the same calculation using your own figures before you decide.

What you actually get for the money

Owners sometimes ask me what they are really paying for, because they cannot see the code. A proper project includes a discovery stage where I sit with your staff and map the process, the design of each screen so that a tired cashier at 6pm can use it, the build and testing of every feature, a secure hosting set-up with daily backups, the migration of your old data, training for your team and a handover with written notes. A part of the price also buys you a person to call when something goes wrong on a busy Friday. If a quote does not mention testing, backups, training and support, ask why. Those are the parts that keep the system alive after launch day.

How to move away from spreadsheets without chaos

The biggest risk in a software project is not technology. It is trying to change everything at once. A staged approach, with small wins, works far better.

Start with the most painful process, not the whole business

Pick one process that hurts most: quoting, order taking, stock control, fee collection or dispatch. Build that first. When it works and people trust it, add the next. This is the idea behind an MVP (minimum viable product, the smallest useful version). My startup MVP guide explains how to define it. For a business with existing customers, the MVP is often a single screen that replaces one messy sheet.

What a first version looks like in real life

To make this concrete, here is the first version I built for Chinedu’s distribution business. It had one price list that only the owner could edit, a customer record with credit limit and current balance, an order form that salesmen used on their phones, a stock view that updated when the store confirmed a dispatch, and a daily sales summary sent to Chinedu on WhatsApp at 8pm. That was all. It did not have accounting, payroll or a customer app. We added a Paystack payment link for online customers in the second stage, after the team had used the first version for six weeks. Small, useful and finished beats big and late every time.

Clean your data before you move it

Software will not fix messy data. Before migration, remove duplicate customers, standardise product names (“Cement 50kg” and “cement 50 kg bag” should be one item), agree one price list and confirm opening balances for stock and debts. It is boring work, but a clean start makes the new system credible. Staff who see a wrong balance on day one will decide the system is bad.

Run both systems side by side, then switch off the old one

For two to four weeks, use the new system and the old spreadsheet in parallel. Compare the numbers each week. When they match and staff are comfortable, set a switch-off date and lock the old sheet as read-only. If you never turn the old sheet off, people will keep using it and you will end up with two sources of truth again.

Choose a development partner carefully

Ask to see similar work, and speak to a past client. Insist on a written scope, milestones and a clear payment schedule. Make sure you own the source code and the data, that documentation is delivered, and that hosting accounts are in your name. Ask what happens if the developer is unavailable next year. Ask how bugs are handled and how quickly. A good partner will explain trade-offs in plain language and will say no to features that are not worth it. My web application development page explains how I structure projects, and you can see examples on the projects page.

A 30-day starter plan

Mistakes that sink projects

• Asking for everything in version one. Big-bang projects run late and over budget.
• No internal owner. Someone on your side must answer questions and test each stage.
• Skipping training. A good system that staff do not understand will be ignored.
• Not planning for data. Old sheets are messy, and cleaning takes time.
• Choosing only on price. The cheapest bid often leaves out testing, documentation and support.
• No exit plan. Make sure you can export your data and, ideally, own your code.

Key takeaways

• Spreadsheets are great for small, personal or short-term work. The trouble starts when they become the shared memory of a growing business.
• Seven signs: dependence on one person, repeated data entry, costly errors, several users at once, slow and unreliable reports, outside users who need access, and unique processes that ready-made tools cannot fit.
• Three or more signs at a serious level usually mean it is time to plan a proper system.
• Try a better spreadsheet or ready-made software first when your needs are standard. Choose custom software when your process is your advantage or when tools must be joined together.
• As at 2026, simple custom tools start around ₦400,000, and larger systems range from ₦1.2 million to ₦25 million or more, plus yearly support.
• Start with one painful process, clean your data, run the old and new systems in parallel and then switch the old one off.
• Own your code and data, insist on milestones and choose a partner who explains things plainly.

Frequently asked questions

Next step: turn your spreadsheets into a system that works for you

You do not need to decide everything today. Send me your current spreadsheets, or describe your process and the biggest pain, and I will tell you honestly whether a better sheet, ready-made software or custom software fits. If a system makes sense, I will help you define a first stage that is small enough to be affordable and useful enough to matter. Have a look at my software development services, then book a free consultation or message me on WhatsApp from the site.