Small business accounting: when spreadsheets break

Your accountant filed everything on time. Every figure is correct. And you still cannot answer a simple question: is this business making money?

That is not your accountant's fault. They are solving a different problem.

This article explains the difference, and what you need in place to get an answer.

One note first: this is not tax or accounting advice. We are talking about what information you need in order to decide things. Filing obligations and how they apply to you are your accountant's territory.

Signs you have outgrown spreadsheets

You do not need all of these. Three is enough to start the conversation.

Getting a number requires asking a person. If "how much cash do we have?" is answered by your bookkeeper two hours later rather than by a system, that is the signal.

Files have started duplicating. `Finance_final_v3_USE_THIS`. Once two people edit different copies, the correct number no longer exists.

Last month's figures arrive mid-month. You needed them to make a decision three weeks ago.

Nobody knows the current receivables total. There is a list, but it was last updated at some point in the spring.

You cannot say which service line is profitable. You have a total. You do not have a breakdown.

One person understands how the file works. When they take leave, reporting stops. That is an operational risk, not an inconvenience.

Tax accounting versus management accounting

The most important distinction in this article.

Tax accounting answers to HMRC, or to whichever authority applies to you. It has fixed formats and fixed deadlines. It looks backwards: it describes what already happened.

Management accounting answers to you. How much cash will there be next month, which line of work earns, who owes you and whom do you owe. It looks forwards.

Two different things, and neither replaces the other.

The practical consequence: do not expect management reporting from your accountant. They work to different deadlines and to a different level of detail. Asking for both usually produces a late report that is no help in deciding anything.

The four numbers an owner needs weekly

Four is enough to start. Reviewed on a fixed day.

Cash today. Across all accounts, as a single number.

Receivables and payables. What you are owed and what you owe, with ages: who is late and by how many days.

Next month's commitments. Payroll, rent, tax, suppliers. What has to be paid regardless.

Margin by line of business. Not the total. Broken down.

The fourth is the one that is usually missing and the one that costs the most. A business can be profitable on average while carrying a loss-making line for years. The aggregate figure hides it.

Profit and cash are different things

The point that causes the most confusion.

You can close a profitable month and be unable to make payroll. That is not a contradiction.

The reason is simple: profit is recorded when you invoice, cash arrives later. If clients pay on 60-day terms, September's profit is November's cash. September's payroll is paid in September.

That gap is a cash gap: the business is profitable and there is no money.

A related trap worth naming: VAT collected is not your money. It sits in your account until the return is due, which makes the balance look healthier than it is. Treat it as a liability from the day you receive it.

Seeing a cash gap in advance

The most practical part of this article.

You need one simple table covering the next eight weeks. Against each week, two figures: expected receipts and required payments.

When the second figure exceeds the first in any week, you can see the problem a month ahead. With a month of warning there are still options: chase a payment, delay a purchase, negotiate with a supplier, draw on a facility.

When the same gap appears on the day the payment is due, there are none.

This table can start in a spreadsheet. A system becomes necessary when the data grows and updating it by hand stops actually happening.

One detail that improves the forecast considerably: record the date that client usually pays, not the date on the invoice terms. They are different, and the first one is the useful one.

Where Xero and QuickBooks stop being enough

Both are good products. They handle bookkeeping, invoicing, bank reconciliation and VAT returns well, and Making Tax Digital pushed most small businesses onto one of them.

Where they stop:

• margin by line of business needs tracking categories set up

properly, and most accounts are never configured that way

• cash flow forecasting is basic in the core product; the useful

version usually means an add-on

• reporting runs on accounting logic, so accruals and deferrals

blur the cash picture you are trying to see

• custom reporting is limited without exporting to something else

Before buying anything new, check whether your existing product already does what you need and simply has not been set up. This is common, and configuration costs far less than migration.

If it genuinely does not, the sensible route is usually not to switch products. It is to keep the bookkeeping where it is and build the management reporting on top, pulling data through the API. Both Xero and QuickBooks have workable APIs, which makes this straightforward.

Multi-currency

If you invoice abroad and spend at home, single-currency reporting gives you a distorted picture.

Three things need to be right:

Record each transaction in its own currency, with the base currency equivalent stored alongside.

Separate the exchange difference. The rate on the invoice date and the rate on the payment date are different, and the gap between them is not a change in how well you traded. Kept in a separate line, it answers the question "why was the figure good and the cash short?"

Account for conversion costs. Bank spread on conversion and intermediary fees on international transfers are rarely recorded anywhere. Over a year they add up to a real number.

Both Xero and QuickBooks handle multi-currency on their higher tiers. Confirm which tier before assuming it is included.

Migrating from spreadsheets

The part that sounds frightening and is not.

Worth migrating: current balances, open receivables and payables, customer and supplier lists, active contracts.

Not worth migrating: three years of transaction history. Keep it as an archive file. In practice nobody opens it in the new system, and migration is charged by the hour.

This is where most of the money is saved. People routinely ask to bring everything across "just in case", which can double the cost of the project.

The right start is opening balances at a single cut-off date, and everything from that date forward in the new system.

Cost and timeline

Work	Price	Timeline
Management accounting setup	from €800	2-4 weeks
Reporting by line of business	from €300	1 week
Cash flow forecast	from €250	3-5 days
Connection to Xero or QuickBooks	from €400	1-2 weeks

Prices exclude VAT. Third-party licences are separate.

The most common mistake

Putting in a system without deciding who will maintain it.

Month one, everyone fills it in. Month two, partially. By month three it is abandoned and everyone is back in the spreadsheet.

The answer is always the same: a named person for whom this is part of the job. Not "the team", not "whoever has time".

In summary

Spreadsheets break when the number stops being trustworthy, not when turnover grows.

Start with four figures and an eight-week table updated on a fixed day. That alone changes decisions, and it costs nothing yet.

Tell us which accounting product you use and which question you cannot answer today. If configuring what you already own is enough, we will say so. Quote within one working day.