From Excel to an Accounting System: When to Move — and When Not To

"Which is better: Excel or an accounting system?" is a question asked often, **and it is the

wrong question**.

Wrong because it assumes they are two things of one kind, one of them stronger. They are not. Excel is

an open calculation tool that does what you write in it. An accounting system is a constrained ledger

that stops you from doing things on purpose.

And the constraint is the product, not the features.

The sentence this book rests on

Excel does not fail when your file grows — it fails when more than one person owns the number.

Read it twice.

Because people defer the decision waiting for a sign in size: "when we reach a hundred customers", "when the

files get big". And size is not the problem — a file with ten thousand rows works without complaint.

The problem is two people opening the file. That is when the questions Excel does not answer appear:

• Who changed this number?
• And when?
• And which version is the right one?
• And why does this month's total differ from what we printed last week?

And these are not reporting questions — they are accountability questions. An accounting system was built

to answer them, and Excel was never built for them at all.

What Excel does well — and nobody denies

And I will say it because much vendor talk ignores it:

• It does exactly what you want, with no templates imposed on you
• It is cheap and you already know it — and knowing it is worth more than a licence
• It opens ten years later with no subscription and no supplier
• And it is excellent at analysis, modelling and experimenting ← **and no accounting system ever replaces

that**

And the last item matters: even after moving, you will keep analysing in Excel. The move is not about

abandoning the tool — it is about moving the ledger out of it.

What this book is — and is not

It is about the decision: when to move, what it costs, and how to move without losing a year of your data.

It is not about learning Excel — that is the "Excel for Business" course, and I assume you know it.

Nor about how to clean and migrate your data — that is "Cleaning and Migrating Your Data", **which

carries the whole method**, and I will point at it rather than repeat it.

Nor about choosing an ERP — that is "Selecting and Implementing an ERP System". The difference is that an

ERP covers inventory, purchasing and human resources, and this book is about the financial ledger alone,

which is what most businesses need first.

Nor about national e-invoicing — that is "National E-Invoicing", and it may be your reason for moving

(chapter three), but it does not choose a system for you.

And I will not name a single program. Programs change, get bought and shut down, **and the decision does

not change**.

When this book does not concern you at all

Three cases, and I will say them before you read another chapter:

1. If you are alone with no employees, your activity is simple, and you know your number at any moment ←

stay on Excel, and chapter two explains why.

2. If your external accountant keeps your books and gives you what you need on time ← **your problem is

not the system**, and may be in how you communicate with them.

3. If you want a system for prettier reports ← reports are a symptom, not a reason. Chapter four

separates what a system actually buys from what is sold to you as a reason.

And the third is the most common, and the most expensive: **whoever moves for the reports discovers their

new reports reflect the same chaos** — in a better arrangement.

Before you continue

Open your file now and answer four questions honestly, and we will return to them in chapter three:

• How many people open and edit this file?
• Do you know how much your customers owe you right now — within a minute?
• How long does closing a month take you?
• If asked about a transaction from a year ago, would you find it?

And an honest answer to those four is worth ten vendor presentations.

Action steps

1. Write the sentence: Excel fails when more than one person owns the number.
2. Stop asking "which is better" — ask: what changed in my business?
3. Go honestly through "when this book does not concern you", starting with the third.
4. Acknowledge what Excel does well — and do not plan to give it up for analysis.
5. Answer the four questions now, in writing.
6. Do not meet a vendor before chapter six.
7. Decide: do you need a financial ledger or a full business system?
8. Read chapter two before deciding — your answer may be to stay.