Replacing Excel with software: when is it time, and what does it cost?

When does a spreadsheet become a business system?

Almost every business process starts in Excel, and that is fine. It becomes a problem when the file quietly turns into the system your business runs on. If you recognise three or more of these signs, it is time to look further:

• Several people work in the same file, and versions like planning-final-v3.xlsx are going around.
• Data gets retyped: from email to sheet, from sheet to quote, from quote to invoice.
• One colleague knows how the formulas and macros work. When they are on holiday, the process stops.
• Everyone can see everything, while not everyone needs to see or change it.
• Clients, staff or management ask for an overview you first have to put together by hand.
• Things occasionally go wrong through an overwritten cell, a wrong copy or a formula that no longer covers new rows, and you only find out later.

When Excel is perfectly fine

Not every spreadsheet has to go. Excel remains the best tool for one-off analyses, calculations one person owns and maintains, and lists where a mistake has no real consequences. Sometimes the smartest move is to tidy the file up: one owner, locked formula cells, a fixed place in the cloud and a short explanation on the first tab.

A custom system only makes sense when the process repeats, several people work in it and mistakes cost real time or money.

Four ways to replace Excel

First check whether off-the-shelf software supports your process without workarounds. For accounting that is almost always the case. For planning with your own rules, a quoting process that fits your work or an operation with several roles, often not. See also custom or off-the-shelf.

What does replacing Excel cost?

With custom software you pay once for the build, then a fixed monthly fee for hosting, monitoring and technical maintenance. At Vorteca it looks like this:

Set that against what the current file costs you. A simple sum: count the hours per week your team spends retyping, searching, merging and fixing mistakes, then multiply by a reasonable hourly rate and the number of working weeks. Two people who each spend two hours a week retyping cost €9,200 a year together at €50 an hour over 46 working weeks. Against that, a €3,250 system is not expensive.

What the sum doesn't show counts too: fewer mistakes in quotes and invoices, and no longer depending on the one colleague who understands the file. The exact price follows an intake, once it is clear which process you are replacing and which integrations are needed. All packages are on the pricing page.

How to approach it

1. Map your sheets. Which files exist, who works in them, what goes in and what comes out? Three files often turn out to be one process.
2. Pick one core process to start with: the one that costs the most time or causes the most mistakes, not everything at once.
3. Clean up the data. Duplicate clients, different spellings and empty columns should go before they land in a new system. Appoint one owner to make the calls.
4. Build a first working version. Formulas and macros become rules in the system: calculations that are always right, fixed statuses and permissions per role.
5. Run both side by side for a short while. Let the team work in the new system for a few weeks, with the old file only as a check.
6. Keep Excel for what it is good at. Exporting to Excel for your accountant or an analysis stays possible. You use Excel for what it is, not as a database.

What happens to your formulas and macros?

We don't copy them one to one; we rebuild the logic behind them. A price calculation in a cell becomes a fixed rule in the system, and a macro that builds an overview becomes a dashboard that is always up to date. It is also the moment to clean up: many spreadsheets contain calculations nobody uses any more.

Existing data such as clients, products or history is imported at launch. If an outside party keeps sending you Excel files, such as a flight schedule or a supplier price list, the system can read those files directly instead of someone retyping them.

Real examples

• Hoveniersbedrijf Peter van der Linden, a landscaping business, worked with Word documents, Excel files and scattered admin. Clients, calendar, quotes, invoices and expenses now live in one CRM. A quote is ready in twenty minutes at most instead of whole evenings in Word, and the quarterly VAT overview goes to the tax return as an Excel export per return box. So Excel hasn't gone; it has become an export.
• For an aviation company, Vorteca replaced the spreadsheet-and-email process in ground handling with one operations portal. The flight schedule is still imported from Excel, but after that several colleagues work in the same overview at once and can see who is editing which field. More than 3,000 flights have been handled so far by 15 daily users across 7 roles.

The risk of waiting too long

Spreadsheet errors rarely show until they are big. A well-known example: in October 2020, 15,841 positive COVID-19 tests in England were left out of the daily figures. According to BBC reporting, the problem was an outdated .xls format limited to 65,536 rows per sheet. The file did what it was supposed to, until suddenly it didn't.

In a business the amounts are usually smaller: a forgotten invoice, a double booking, a quote with an old price. The pattern is the same. A system enforces what a spreadsheet leaves to someone paying attention.