The True Cost of "We Just Use Excel"

Have you ever calculated what your Excel setup actually costs? Not the license. That one is practically free. I mean the hours, the errors, the workarounds. The frustration on Monday morning when someone overwrites a formula.

I worked at DHL, Instacart, Delivery Hero, and New Relic before founding Plexito. There I saw how Fortune 500 companies burn millions on the wrong tools. And now I see 5-person businesses in the Eifel region losing thousands to Excel. The pattern is the same: licensing costs are low, but hidden costs are enormous.

In this article I compare three typical business processes over three years: Excel versus a SaaS tool versus custom software. With real numbers. And a compliance risk that many SMBs simply ignore.

By the way: I am not writing this to badmouth Excel. Excel is a great tool. For analysis, for ad-hoc calculations, for prototypes. I use it myself almost every day. But as a permanent operating system for your core processes? That gets expensive. And the numbers prove it.

Process 1: Customer Pipeline and CRM

Take a trades business with 8 employees. Inquiries come in by phone, email, WhatsApp. Currently, someone maintains an Excel spreadsheet with customer contacts, quote statuses, and notes.

Excel

The spreadsheet grows. At some point it has 40 columns and 2,000 rows. Who called the customer last? Somewhere in the notes. Maybe. There are no automatic reminders, no follow-up tracking, no reporting. Management asks: "How many open quotes do we have right now?" Then someone sits there for 20 minutes and counts.

Time spent per week: 5 to 8 hours (maintenance, searching, manual reports). At EUR 40 per employee hour, that is EUR 800 to 1,280 monthly. Sounds exaggerated? Do the math: open the spreadsheet in the morning, add new contacts, search for old ones, update statuses, forward information to colleagues. Then a customer calls asking about their quote. "One moment, let me check..." And then you scroll through the spreadsheet for 5 minutes.

On top of that: if the person maintaining the spreadsheet gets sick or quits, there is often nobody who can find their way around. The knowledge lives in one person's head, not in the system.

HubSpot Free / Pipedrive

A free CRM like HubSpot or an affordable one like Pipedrive (starting at EUR 15 per user per month) solves most problems immediately. Contacts are managed centrally, reminders come automatically, sales has a pipeline view.

Time spent per week: 1 to 2 hours. Monthly cost for 3 users: EUR 0 to 90 for licensing plus EUR 160 to 320 in labor.

Custom Software

A CRM that connects directly to the invoicing process, to website forms, to the calendar. No manual transfers. A customer fills out the contact form, automatically lands in the CRM, automatically receives a confirmation, and the responsible employee sees the new lead in their task list.

Time spent per week: under 1 hour. Monthly cost: from EUR 249 (subscription model including maintenance and support). Yes, the monthly price is higher. But look at the total cost: EUR 249 licensing plus EUR 160 labor is EUR 409 per month. The Excel variant costs EUR 800 to 1,280 in labor alone. We will get to the 3-year calculation shortly.

Process 2: Time Tracking

Especially for businesses with field service, construction sites, or project work, time tracking is a constant topic. And no, this is no longer a "nice to have." Since the German Federal Labour Court ruling of September 2022, systematic recording of working hours is mandatory in Germany. The employer must provide a system for recording the start, end, and duration of daily working hours. An Excel spreadsheet where employees enter their own data only meets this requirement under a very generous interpretation. Similar obligations exist in many EU countries, so this is not just a German issue.

Excel

Employees enter their hours in a shared Excel file. At the end of the month, someone transfers the data to the payroll system. Sounds simple, but it is not: cells get accidentally overwritten, formats do not match, employees forget entries and fill in three days at once.

Time spent per week: 3 to 5 hours (recording, review, corrections, monthly transfer). For a 5-person company, that quickly adds up to EUR 500 to 800 monthly.

And: there is no reliable analysis. "How many hours has Project X consumed so far?" Nobody can answer that question in under 10 minutes when the data lives in a spreadsheet. It should really be a matter of seconds.

Clockify / toggl

Cloud-based time tracking starting at EUR 0 to 5 per user per month. Employees clock in via app or browser. Reports are generated automatically. Export to payroll with one click.

The difference in daily operations is tangible: no more retroactive entries. No more "I forgot to log my hours." The app reminds you, and the data is instantly available. At month-end, the entire manual transfer disappears.

Time spent per week: 30 to 60 minutes (review and approval). Monthly cost: EUR 0 to 50 licensing plus EUR 80 to 160 in labor.

Integrated Solution

Time tracking linked directly to CRM and invoicing. Employees log time against projects that are automatically assigned to the right customer. End of month: one click, the invoice is generated.

Time spent per week: under 30 minutes. Monthly cost: from EUR 249 (as part of a complete solution that also covers CRM and invoicing).

Process 3: Invoicing

This is where it gets serious. Because invoicing is not just about efficiency but also about compliance.

Excel

Many SMBs create invoices using an Excel template. Enter customer data, list line items, calculate the total, export as PDF, send by email. It works. Sort of.

Time spent per invoice: 15 to 30 minutes (including looking up customer data, assigning invoice numbers, filing the document). With 40 invoices per month, that is 10 to 20 hours. So EUR 400 to 800 monthly in labor.

And then there is the compliance problem.

The risk is real. I am not talking theory. Tax advisors regularly report that clients run into problems during audits because their digital bookkeeping is based on Excel. And starting in 2025, e-invoicing requirements are being phased in across the EU. By 2027, all B2B invoices in Germany must be sent in a structured electronic format (ZUGFeRD or XRechnung). Excel will not handle that.

sevDesk / lexoffice

These are popular German invoicing tools (starting at EUR 8 to 20 monthly). International equivalents include FreshBooks, Xero, or QuickBooks. Customer master data is entered once, invoice numbers are assigned automatically, sending is digital. Dunning is often included, and the accounting software interface saves a few more hours per month.

Compliant? Partially. The invoice creation itself is compliant, but as soon as you export data and process it externally, you leave the protected environment. And: you still have to enter customer data and project hours manually if no CRM is connected.

Time spent per invoice: 3 to 5 minutes. With 40 invoices monthly: under 4 hours. Monthly cost: EUR 8 to 20 licensing plus EUR 120 to 160 in labor.

Custom Solution

Invoices are generated automatically from CRM data and time tracking. Line items, hourly rates, customer data: all pre-filled. Audit-proof archiving included. Fully compliant because the system guarantees immutability at the database level.

Time spent per invoice: under 1 minute (review and approval). With 40 invoices monthly: under 1 hour. Monthly cost: from EUR 249 (as part of a complete solution).

The Total Cost over 3 Years

Now it gets interesting. Let us look at the total cost over three years when we combine all three processes.

Read those numbers again. Excel costs "nothing," but over three years you pay between EUR 69,000 and 144,000 in labor. In return you get a solution that is not audit-proof, offers no automation, and regularly produces errors.

The SaaS option is significantly cheaper. Three separate tools, each doing their job. The downside: the tools do not talk to each other. Data is transferred manually between CRM, time tracking, and invoicing. That still costs 3 to 5 hours per week.

Custom software has the highest monthly price but the lowest total cost. Because everything is connected, the manual effort nearly disappears. CRM data flows into time tracking, time tracking flows into invoicing. No copy-paste between three different programs.

And something the table does not show: the value of reclaimed time. The 10 to 20 hours per week someone spends on Excel maintenance could be spent on customer acquisition, project work, or team leadership. What is that worth to you?

If you are interested in how integrated workflows look in practice, check out our article on workflows that save hours.

The Hidden Cost Factor Nobody Accounts For

Errors.

In an Excel spreadsheet, errors happen silently. A formula gets overwritten. A decimal point shifts. A customer contact is created twice. An invoice goes to the wrong address.

Studies from the University of Hawaii show: 88% of all spreadsheets contain errors. That is not an exaggeration. Think of your own spreadsheets. Have you ever found one where a formula was broken? Exactly.

What do these errors cost?

• A wrong invoice that the customer disputes: 30 to 60 minutes of correction plus lost trust
• A forgotten lead that goes to a competitor: the entire contract value
• Duplicate records leading to wrong reports: bad decisions by management
• A compliance violation during a tax audit: back taxes plus penalties

These costs never appear anywhere in the spreadsheet. They exist, but they are invisible.

I remember a conversation with a trades business in the region. The owner had managed quotes in Excel for years. Eventually it turned out that an employee had been calculating with outdated material prices for months because he was using an old version of the price list. The difference: over EUR 12,000 in six months. Not because anyone wanted to make mistakes, but because Excel has no version control that prevents it.

Opportunity Costs: What You Are Missing

Beyond the direct cost of errors, there is something harder to measure: missed opportunities. If your CRM is a spreadsheet, you cannot offer your customers automatic follow-up. No "Your quote expires in 3 days" email. No reminder when a regular customer has not ordered in 6 months.

A proper CRM can do this. Automatically. Without anyone having to think about it. These are not gimmicks. This is revenue slipping through your fingers today because your system cannot capture it.

A business we work with discovered after switching to a CRM with automatic reminders that about 15% of their quotes had previously gone unanswered. Not because customers did not want to buy, but because nobody followed up. With an average contract value of EUR 3,000 and 20 quotes per month, that was EUR 9,000 per month just sitting there.

What Should Happen on Monday

You do not have to change everything tomorrow. But you should do three things next week:

1. Measure the actual time spent. For one week. Every time you or an employee opens a spreadsheet to manage customer data, log hours, or create an invoice: start the stopwatch. You will be surprised.

2. Check your bookkeeping compliance. Talk to your accountant about how your digital bookkeeping is set up. Ask specifically: "Would our Excel-based invoices be a problem during an audit?" The answer will be uncomfortable.

3. Calculate the 3-year cost. Use the table above as a template. Plug in your own numbers. How many hours per week do you spend on manual processes? What does one labor hour cost at your company? Multiply by 156 weeks (3 years). That is your comparison baseline. Do not forget to include employer-side costs like taxes and benefits. An employee earning EUR 25 gross per hour costs you closer to EUR 35 to 40 with all overheads.

After that, you can make an informed decision. Maybe SaaS tools are enough to start with; for many businesses that is the right first step. Maybe a fully integrated solution makes sense right away because your processes are tightly linked. Maybe Excel really is fine because your processes are so simple that the overhead is minimal. That happens too, and in that case Excel genuinely is the right choice.

But the decision should be based on numbers. Not on the feeling that Excel is "free."

Most business owners I talk to are surprised after running these numbers. Not because the figures are unrealistic, but because they have never written them down. You get used to things running the way they run. Only when you see the costs in black and white does it become clear: "We just use Excel" is not a savings strategy. It is an expensive force of habit.

If you want, I will run these numbers with you. Free, no obligation, 30 minutes. We look at your three most important processes and calculate together what the current solution actually costs. After that you will know whether a switch is worthwhile, and if so, which path makes the most sense. Just reach out. Or take a look at what we do at Plexito.