Running a Business in a Spreadsheet: A Free Business Template to Download, and the Five Points Where the Sheet Breaks

Anyone typing "run a business in a spreadsheet" or "business management template" is not looking for a lecture. They are looking for a file. Something they can open this morning and start putting the mess in order.

So let's start with the file. Then we'll talk honestly about where it ends.

Take the file

Download: the business tracker file

The file is free. There is no form to fill in, no email to leave, and no "send us your details and we'll email it to you". You click, you download, done. I'm also not going to call you afterwards.

I give it away like this because a template that asks you to sign up before you download is not a gift, it's a form. And someone looking for a file at seven in the morning does not want another mailing list.

The file sits alongside a few other free tools I built on the same logic: a calculator that shows what the mess costs you, and a short test of whether your site is really yours. All open, no form.

What's in it

Three main sheets, plus a summary sheet that updates itself. That's all of it, on purpose.

The "Leads" sheet. Date, name, phone, email, where the lead came from, status (new, contacted, quote sent, closed, not relevant), owner, next follow-up date and notes. The two columns that matter most are the lead source and the next follow-up date. The first answers "where do people find me". The second stops inquiries from falling through the cracks.

The "Clients" sheet. Name, contact person, phone, email, business ID number, start date and notes. Separating inquiries from clients is not cosmetic. Not everyone who contacts you is a client, and the moment you mix the two you can't answer a simple question: how many inquiries actually turned into work.

The "Income and Expenses" sheet. Date, type (income or expense), category, description, amount before VAT, VAT, total, invoice number and payment method. VAT is calculated automatically at 18 percent, the rate in use today. If it changes, that's one cell to update.

It is not an impressive file and there is nothing clever in it. That is exactly the point. A sheet you can explain in three lines is a sheet you will still fill in on a busy day.

The five points where it breaks

I'm not giving you a file so I can sell you a system a minute later. But I do have to say up front where it ends, so that when it happens you recognize it, instead of thinking you did something wrong.

1. Two people at the same time. The moment a second person starts editing, the versions begin. Someone overwrites someone else's row, someone saves a copy for themselves, and then comes the most exhausting question in the business: which file is the real one.

2. It doesn't remind you of anything. A spreadsheet never chases an inquiry. It waits to be opened. The "next follow-up date" column is worth exactly as much as you remembering to open the file that morning. Nothing inside it moves on its own, and that is exactly how leads fall through the cracks.

3. It is cut off from where the work actually happens. Inquiries arrive on WhatsApp, through the form on your site and by phone, and invoices go out in another program. The sheet is not connected to any of them, so everything that goes into it goes in by hand. Anything that needs typing gets done when there is time. And there is no time.

4. The history disappears. A cell that was overwritten leaves no trace of what was in it, when, or by whom. A status that jumped from "new" to "not relevant" looks the same in the end, whether you spoke to the client or simply gave up.

5. It breaks quietly as it grows. Filters, formulas and merged cells hold up nicely, until they don't. The new row stays outside the range of the formula, and nobody gets an error message. You get a number. A number that looks reasonable, and is simply wrong.

When a spreadsheet is actually enough

Now the part most people who write about "systems" skip.

If the business is just starting out, or you work on your own, a spreadsheet really is enough. Not a compromise, and not an embarrassing in-between stage, but the right choice. It costs nothing, everyone knows how to use it, nobody has to install it for you, and you can change it in the middle of the day without asking anyone's permission.

When one person runs everything, the first point barely touches you, and the fourth one much less, because the history sits in your head. What will keep bothering you is what doesn't move on its own and what needs typing.

That's why I'm in no rush to get anyone out of the spreadsheet. The move should come from pain, not from a salesperson. If you want the signs that the pain is real, I listed them in five signs a business needs one system.

What comes after

The sign that the time has come is not a number of clients and not the size of the business. The sign is that two or three of the points above hurt you every week, and not once a quarter.

And even then, the file does not go in the bin. The columns you really did fill in, and the ones you ignored for months, are the most accurate definition of what your business needs. A client's full spreadsheet teaches me more than any list of requests.

Start with the file. If in a few months you find that you are updating it more than you are working, there is a short questionnaire that will put the picture in order. Even if you never do anything with me, you will come out of it with a clearer list of what is broken.