Eight signs your business has outgrown spreadsheets

How do you know your business has outgrown spreadsheets?

You have outgrown spreadsheets and single-PC accounting when the tools make people wait, copy numbers by hand or call each other to find out what is true. None of these is a crisis on its own. Together they cost real hours and real money every month.

This guide walks through eight signs at Harbour Steel Furniture, the fictional business used across these guides. It has 10 people, a main warehouse, a showroom across town, two salespeople and a bookkeeper who comes in at month end. Every cost below is an example, worked at $25 an hour of staff time. Put your own numbers in.

Sign 1: a second person waits for the PC to do their work

If invoicing stops whenever the bookkeeper sits down at the accounts PC, the software has become the bottleneck. A single-user licence on one machine means one person enters data at a time.

• Symptom: the salesperson writes invoices on paper or in Excel and types them in later. The bookkeeper works evenings to get a turn.
• Example cost: 20 hours a month of waiting and retyping, about $500.
• Fix: a system where several people log in at once, each with a role that limits what they can do.

Sign 2: the stock count never matches the register

When the physical count and the Excel stock sheet disagree every month, the problem is the process, not the counting. Stock is a separate sheet that someone updates after the sale, if they remember.

• Symptom: a customer is promised 10 racks that are not there. Nobody can say whether the shortfall is theft, a missed entry or a wrong count.
• Example cost: 10 hours of recounting and chasing, $250, plus $840 of shortage written off without a reason.
• Fix: stock that moves only when a document posts. The invoice takes the goods out, the supplier bill brings them in, and any correction is an adjustment with a reason.

Sign 3: "how much do they owe" needs a phone call

If the salesperson must call the office to learn a customer's balance, collections slow down. A spreadsheet tracks payments against the party, not against the invoice, so nobody trusts the outstanding figure.

• Symptom: a customer says they paid the March invoice. The office cannot see which invoice their $5,000 cleared.
• Example cost: 8 hours of calls and reconciling, about $200, before counting any payment that arrives late.
• Fix: payments allocated to invoices, an ageing report by party and a statement of account anyone with access can open on a phone.

Sign 4: tax return preparation takes days, not hours

When the bookkeeper spends the first week of every month or quarter rebuilding sales and purchase registers, the source data is in too many places. Invoices raised in Excel, bills entered late and tax rates typed by hand all need checking before anything is filed.

• Symptom: the tax totals are added up by hand, and the purchase register never quite agrees with the suppliers' bills.
• Example cost: 16 hours of collation each period, about $400.
• Fix: tax worked out on the invoice itself, a tax rate on every line, and registers that come straight from posted documents.

Sign 5: the backup lives on a USB stick in a drawer

If the only copy of your books is one PC and a USB stick, a dead hard disk is a business risk. Many small businesses only find out how old the last backup was on the day they need it.

• Symptom: someone copies the accounts folder on Saturdays, when they remember. Excel files sit on two laptops in two versions.
• Example cost: 2 hours a month of copying, about $50. The real cost is the week of re-entry after a failure.
• Fix: data that lives on a server rather than one office PC, so a broken machine means logging in from another one.

Sign 6: warehouse and branch numbers arrive by text message

When the store manager sends a photo of a notebook page every evening, your second location is not really in your books. Someone at the main office types it in, late and with mistakes.

• Symptom: 6 racks moved to the showroom on Monday are still in the main warehouse on paper on Friday.
• Example cost: 6 hours a month of retyping and correcting, about $150.
• Fix: one stock record with quantities per warehouse, and transfers between warehouses entered by the person who moves the goods.

Sign 7: payroll is a separate spreadsheet nobody else may open

If salaries are worked out in a private Excel file and then posted to the accounts as one lump journal, payroll is disconnected from attendance and from the books. Every change in leave or overtime is copied by hand.

• Symptom: attendance is on a paper register, leave requests come by message and the salary sheet has formulas only one person understands.
• Example cost: 6 hours a month of reconciling, about $150.
• Fix: attendance, leave and payroll in the same system as the accounts, so a payroll run posts its own journal.

Sign 8: the owner cannot see today's position from a phone

When the owner must call the bookkeeper to know cash, receivables or stock value, decisions wait for office hours. The numbers exist, but only on one screen in one room.

• Symptom: a supplier asks for payment on a Sunday, and the owner cannot check the bank balance or what customers owe.
• Example cost: 10 hours a month of the owner's and bookkeeper's time on update calls, about $250.
• Fix: reports that open in a browser on a phone, read only for the owner if that is all they need.

What do the eight signs cost together in a month?

Added up, the small delays at Harbour Steel come to about 78 hours and $2,790 a month in this example. Your figures will differ, but the pattern is common.

Compare that total with the price of a cloud system for the people who actually need to log in. If the cost of staying is the larger number, the case for switching is already made.

Is it time to switch? Check your business against the eight signs

Tick each line that is true for your business today. Three or more ticks is a good reason to plan a move; five or more means you are already paying for staying.

• Two or more people regularly wait to use the accounts PC
• The physical stock count differs from the register most months
• Salespeople call the office to learn a customer's balance
• Tax return preparation takes more than two working days
• The only backup is a USB stick or a second copy on a laptop
• A warehouse or branch sends its numbers by message or on paper
• Payroll is worked out in a spreadsheet outside the books
• The owner cannot see cash, receivables and stock from a phone

If you tick several, read how to switch from spreadsheets to cloud ERP for the full journey, and moving your data to SimpleERP for what to move and in what order.

How does SimpleERP address each sign?

SimpleERP is a web app for small businesses where posting a document does all the follow-on work. An invoice writes the journal, the cost of goods sold, the stock issue, the receivable and the tax in one step. Posted documents cannot be edited; a cancellation reverses them, and every change is in the audit history.

• Many users at once: unlimited members with seven ready-made roles, plus custom roles, at View, Manage or Approve level. Invite by email.
• Stock: quantities per warehouse at weighted average cost, transfers between warehouses and count-mode adjustments with a reason.
• Receivables: payments allocated to invoices, ageing by party and a statement of account you can print or share.
• Tax: your country's tax rates on every line, sales and purchase registers and a tax summary by rate.
• Payroll: attendance, leave and payroll runs that post to the books.
• The owner's view: trial balance, profit and loss, balance sheet and stock value on a phone browser as narrow as 360 px.

See how it compares with QuickBooks, or read about importing from Excel. In India, the same signs apply to Tally: see outgrown Tally and Excel (India).