Still running the business on spreadsheets? What to move first.

You do not need all four. Two is enough.

• Only one person understands it. There is a tab nobody else opens, a formula nobody else would dare touch, and a quiet worry about what happens when that person is on leave.
• There are two versions of the truth. Someone made a copy to work on. Now there is a file called final, a file called final v3, and a shared drive where nobody is sure which one is right.
• Someone re-keys it. A person reads a row and types it into Xero, a supplier portal, an email or another spreadsheet. Every week. That person is the integration, and they are the most expensive and least reliable one you could have.
• It breaks and nobody knows why. A column was sorted on its own. A row was deleted. A formula points at the wrong cell since March. The numbers look plausible, which is worse than looking wrong.

If that is one of your spreadsheets, it is not a spreadsheet any more. It is unowned software.

Do not try to replace everything. Pick in this order.

1. The one with money in it. Quotes, orders, pricing, invoices, anything a customer pays against. A mistake here costs cash directly and costs trust when the customer spots it before you do. One client of ours supplies more than 100 retail customers. Orders arrived by email and had to be turned into pricing, packing, delivery runs and Xero invoices by hand. That is the first thing we moved, and it is now one system where an emailed order becomes a packed, delivered, invoiced order without anyone re-typing it.

2. The one several people edit. A job board, a roster, a compliance register, a stock count. The more hands in it, the more often it is wrong, and the harder it is to know who changed what. Another client tracked contractor licences, insurances and safety documentation in a spreadsheet. Fine at ten contractors. Not fine when a major customer asks for proof that every person on site is current, today. That register is now a portal where contractors upload their own documents and expiries are flagged before they lapse.

3. The one that feeds another system. Anything that ends with a person copying data somewhere else: stock levels into the online store, timesheets into payroll, leads into the CRM, sales into the month-end report. This is usually the cheapest to fix, because the spreadsheet often does not need replacing. The re-keying does.

Everything else can wait, and a lot of it should wait forever.

Being honest here saves you money.

• One person owns it and one person uses it.
• It is a one-off: a bit of analysis, a scenario, a list for a single project.
• The structure changes every week because you are still working out what you are looking at.
• Nothing else depends on it. If it vanished, someone would be annoyed, and that is all.

A spreadsheet is the best tool ever made for thinking with numbers. Leave it doing that. The cases above are not thinking, they are operating.

People hear “replace the spreadsheet” and picture a six-month ERP rollout. That is not what this is.

Moving a spreadsheet into a real system usually means:

• The layout people know stays. Nobody wants to relearn their job. The screen looks like the sheet they used, with the rubbish removed.
• The data lives in a database. One copy. Everyone sees the same thing at the same moment. Nobody can accidentally sort one column or delete last month.
• The rules are enforced, not hoped for. You cannot enter the same customer twice. A quote cannot go out without a price. A contractor with an expired licence shows red.
• The re-keying disappears. The order becomes the invoice in Xero. The stock count updates the store. The person who used to do that gets their Wednesday back.
• There is a history. Who changed what, when. The question “why is this number different from last week” gets an answer instead of a shrug.

For a single spreadsheet this is days of work, not weeks, and in our pricing guide it lands in the first bracket. The first thing moved is often the most expensive, because it is where the mess is. The ones after it get cheaper, because the data is already clean and the connections already exist.

Do this first. It takes an hour and it is the best brief you could give us or anyone else.

1. List every spreadsheet the business would notice within a week if it vanished.
2. Next to each, write who owns it and who else touches it.
3. Mark the ones where somebody re-types the contents into something else.
4. Circle the one that scares you most.

The circled one is where to start. Bring the list to the first conversation and most of the scoping is already done.