Signs Your Business Has Outgrown Spreadsheets
Spreadsheets are a fine place to start. These nine signs tell you when they've started costing more than they save, with a quick self-check to score your own business.
Nobody regrets starting on spreadsheets. They're free, flexible and everyone knows how to use them. The trouble is that they don't announce when they've stopped working. The cost creeps in as late nights, small errors and questions nobody can answer quickly. Here are nine signs it has happened to you.
1. There's more than one "final" version
Invoice_LekkiHeights_FINAL_v3.docx. Payroll_Oct_2026_Aisha_edits.xlsx. When file names start carrying version numbers and people's names, the business no longer has one record. It has several, and someone has to decide which one is true.
What it costs: time spent reconciling versions, and the occasional invoice sent from the wrong one.
2. Payments are matched to invoices by eye
A bank alert reads Credit · NGN1,342,250.00 · TRF/LEKKI HTS. Which invoice is that? Was it the full amount? Someone opens the debtors spreadsheet, scrolls, guesses and updates a cell.
That works with twenty customers. With two hundred it becomes a job, and the errors are quiet ones: the payment above was ₦1,500 short of a ₦1,343,750 invoice, and it was marked paid anyway.
What it costs: small shortfalls nobody collects, and a debtors list nobody fully trusts. See How to Collect Invoice Payments Online in Nigeria for what the alternative looks like.
3. Approvals happen in chat
"Has anyone approved the Garki voucher?" Seen at 4:52 p.m. No reply.
When approvals live in WhatsApp, there's no reliable record of who said yes, to what amount, or when. If the payment later turns out to be wrong, the conversation that would explain it has scrolled away.
What it costs: payments that wait for an answer, and payments that go out without one. Our guide to approval workflows explains how to structure this properly.
4. One person understands the payroll file
Every business has one: the spreadsheet with nested formulas for PAYE, pension and NHF that only Aisha in HR can safely edit. When she's on leave, payroll either waits or someone edits it nervously.
What it costs: a single point of failure for the one process staff notice immediately when it goes wrong. Payroll Management in Nigeria walks through what a controlled payroll process involves.
5. The VAT return is rebuilt every month
If preparing the VAT return means copying figures from four sheets into a fifth, the same work is being done twelve times a year, and each time is a fresh chance to make a mistake. The same goes for WHT schedules.
What it costs: a day or two each month, plus the risk of a return that doesn't match your records. See VAT in Nigeria for what the records need to show.
6. You can't answer simple questions quickly
How much did we collect last month? Which customers owe us more than 30 days? What was total payroll cost for the quarter? If each of those means building a new pivot table, you don't have reporting. You have raw material.
What it costs: decisions made on instinct because the numbers take too long to get.
7. Nobody can say who changed what
A cell in the payroll file changed from ₦450,000 to ₦540,000. Was that a promotion or a typing error? Spreadsheets record the latest value, not the history behind it, and shared drives rarely help.
What it costs: disputes you can't settle, and an uncomfortable conversation with your auditor. What Is an Audit Trail and Why Does It Matter? covers what a proper record captures.
8. Your customers see an inconsistent business
One invoice has the old logo. Another has no TIN. A third is missing the bank details. Invoices are documents your customers keep and forward to their own finance teams, and inconsistency makes you look smaller than you are. Our checklist in How to Write a Professional Invoice in Nigeria shows what every invoice should carry.
What it costs: slower payment, because unclear invoices get queried before they get paid.
9. You've added a second company
The moment a business becomes a group, with a second company for haulage or a separate entity in Abuja, spreadsheets multiply. Different numbering, different templates, different approvers, and no way to see the group at a glance.
What it costs: every problem above, doubled.
Score yourself
Give each sign a score: 0 if it never happens, 1 if it happens sometimes, 2 if it happens every month.
| Score | What it suggests |
|---|---|
| 0–4 | Spreadsheets are still serving you. Tighten the habits: one master file, agreed approvers, a naming rule. |
| 5–10 | The cost is real but manageable. Fix the most expensive process first, usually payment matching or approvals. |
| 11–18 | You've outgrown them. Each month you wait adds more history you'll need to move later. |
What to do next
Moving off spreadsheets doesn't have to happen all at once. Most businesses get the biggest return from starting with the process that hurts most:
- If the pain is getting paid, start with invoicing and online payment.
- If it's payroll, start there and keep invoicing as it is for a cycle.
- If it's control, start with approvals on vouchers and invoices.
Before you move, agree the rules (who approves what, and above which amount), tidy your customer and employee lists, and decide what history you actually need to bring across. Our guide to ERP software covers the questions to ask when you choose.
How Flux helps
Flux replaces the spreadsheets behind invoicing, payments, payroll, approvals and VAT reporting with one approval-controlled workspace. Invoices carry a Pay online link, payments are matched to the invoice and short payments are flagged instead of being accepted. Payroll calculates PAYE, pension, NHF, NSITF and ITF. Every invoice, voucher and pay run has an approver and a place in the audit trail. You can import customers and employees from Excel, so your existing lists come with you. See how the modules fit together.