From Excel to software

Excel or construction software? How to tell when Excel is no longer enough

When Excel is still the right tool for a Belgian contractor, the signs that you have outgrown it, and a simple test you can run on your own week.

On this page

If you work alone or with one or two people, send a handful of quotes a month and invoice mostly private clients, Excel and a carefully checked PDF are still a sound way to run a small building firm in Belgium. Excel stops being enough once several people depend on the same files, or once you invoice other businesses, because since 1 January 2026 an invoice between businesses registered for VAT in Belgium has to be a structured electronic invoice, and a PDF made from a spreadsheet no longer counts as that invoice (official FAQ on electronic invoicing, questions 11 and 14).

Below I go through the cases where Excel is the right tool, seven signs that you have outgrown it, what the research on spreadsheet errors really says, and a short test you can run on your own last month.

When Excel is genuinely fine

Honestly, if you are three people and the same person writes every quote, keep your spreadsheet and spend the money on a good accountant. Construction software earns its keep by putting several people on the same page, and when nobody else is on the page it mostly adds a subscription.

Take a tiler in Ghent who works alone, sends three or four quotes a month and mostly redoes bathrooms for private owners in houses older than ten years, at 6% VAT. Nobody else opens his files, he wrote every formula himself, and his customers are private people, who are outside the obligation to receive structured electronic invoices. For them a clean PDF is still a valid invoice, so his paperwork is a matter of discipline rather than tools.

The one question he does have to answer is whether any of his customers is a business. The day a property developer or a general contractor asks him to tile twelve bathrooms, that invoice has to go out in the structured format over the Peppol network, and the official FAQ (question 2) says this applies even to businesses under the small business exemption scheme, with a turnover of EUR 25,000 or less, which surprises people who read older blog posts. That still does not mean he needs construction software, because an invoicing tool that sends over Peppol is enough, and the government’s own guide on where to start points out that some applications on the market cost nothing. The article on Peppol for Belgian contractors goes through the details.

Staying in Excel safely asks for a few habits. Keep one master price list that every quote reads from, so that a price changes in one place only, and lock the cells that hold formulas, so that a total cannot be typed over by accident. Above an amount you choose, ask someone else to read the quote before it leaves, because the research further down shows that people who check their own spreadsheet find about half of their mistakes at best.

Seven signs that you have outgrown Excel

None of these is a disaster on its own, but each one costs hours or money every month, and they tend to arrive together when a firm grows from one crew to two. Count how many describe your last four weeks.

  1. More than one person edits the same quote or planning file, and the folder holds names like “quote_final_v3_really_final.xlsx”, so nobody is quite sure which version the client received.
  2. Hours arrive on paper, as photos in a WhatsApp group or as a phone call on Friday afternoon, and somebody has to retype them before the payroll office can use them.
  3. You learn the real margin of a job at the end of the year, when your accountant puts the costs next to the invoices.
  4. Invoices wait for a quiet evening, and the extras a client asked for on site, such as two more sockets or a radiator moved half a metre, are invoiced only when somebody remembers them.
  5. Material leaves the depot or the van without anyone writing down which job it went to.
  6. You chase late payments from memory, and the fixed compensation of EUR 40 that the law gives you on every late invoice to a business is never claimed.
  7. Peppol made you add a separate invoicing tool next to Excel, so your customer details now live in two places and have to be kept in step by hand.

Paper hours and forgotten extras cost more than they seem

Retyping is easy to underestimate because its cost arrives in small pieces. Take a renovation firm near Liège with two crews: the owner, one office employee and eight workers who fill in a paper timesheet every day, which makes 40 sheets a week. If reading, retyping and checking one sheet takes three minutes, the office spends two hours a week on it, or about 90 hours over 46 working weeks. At roughly EUR 32 for an hour of office time (the article on what software saves a construction firm of ten people shows how that hourly figure is built), the firm pays close to EUR 2,900 a year for typing in what the workers had already written down, before a single mistake has been found. To get your own figure, multiply the sheets per week by the minutes per sheet and by your working weeks, then divide by 60 and multiply by your hourly cost.

Extras are harder to put a number on. I know of no Belgian figure for the share of site extras that never reach an invoice, so instead of a statistic I suggest a check: take the last three months, write down every change a client asked for on site, and look for each one on an invoice. Every extra you cannot find is lost profit in full, because the labour and the material have already been paid.

Late payment weighs more than it used to, as well. In a survey by the federation Embuild of 239 construction and installation firms, reported by The Brussels Times and Belga on 25 September 2025, 32% said they faced liquidity problems, and a May 2026 survey by the credit insurer Atradius named construction as the Belgian sector under most pressure from late payers. Between businesses, though, the rules are on your side. The law of 2 August 2002 on late payment in commercial transactions, as amended in 2013 and 2021, sets a payment term of 30 days when nothing was agreed and never more than 60 days, and a late invoice to a business gives you EUR 40 of fixed compensation plus interest, which the EU’s Your Europe portal puts at 10.5% for Belgium from 1 July to 31 December 2026. Those rules only help a firm that invoices on time and notices when a payment is late, which is exactly what a spreadsheet does not do for you.

What the research on spreadsheet errors really says

The figure that circulates on vendor blogs, “88% of spreadsheets contain errors”, usually comes without a source, so I prefer to go back to the research it seems to come from. Raymond Panko’s review, Spreadsheet Errors: What We Know. What We Think We Can Do, presented at the EuSpRIG symposium in July 2000, gathers field audits of real business spreadsheets. In the careful audits between 1.1% and 2.5% of cells contained an original error, and the more recent audits, which used better methods, found errors in at least 86% of the spreadsheets they examined. In one experiment the people who built the spreadsheets put the chance that they had made a mistake at 10% (the median), while 86% of them had made one, and Panko adds that a single person checking a spreadsheet finds half of the errors or fewer.

Those audits were mostly of corporate spreadsheets in the 1990s, and none of them looked at construction quotes, so they do not mean that 86% of contractor quotes are wrong. What they do say is that people make mistakes in one or two cells out of a hundred, that they do not see them, and that a second reader catches more than the author.

A public decision shows what one such cell can do. In the GAO decision B-292555 of 10 October 2003, about barracks for the US Army at Fort Hood in Texas, the lowest bid came from Emerson Construction at USD 35,574,639.50. The subtotal in cell D160 was meant to add up rows 16 to 159, but the formula stopped at row 158, so the electrical work in D159, worth USD 3,702,025, was simply missing. Public procurement rules allowed Emerson to correct its bid to USD 39,498,340, while a private client would most likely have signed the lower price without a question.

Bring that back to the scale of a Belgian renovation. A quote of EUR 48,000 excluding VAT with forty lines, from which one line of EUR 1,800 drops out of the total, is 3.75% too cheap. If your margin on such a job is between 8% and 12% (an assumption, so use your own), that single line is between a third and a half of the profit on the job, gone before the first day on site.

What you gain and what you give up when you switch

What you gain is one place where the quote, the hours, the material and the invoices of a job meet, so that you see the margin while the job is still running and can still do something about it. Hours that a crew registers on the phone land in the cost of the job without being retyped, and an invoice starts from the quote or the progress statement instead of a blank page.

What you give up is real, and vendors rarely say it: your own formulas and layouts, the freedom to add a column whenever you like, and a few weeks during which both systems run side by side and everything takes longer. Software also does not check whether your quantities are right, because it removes the retyping and the totals you build by hand while a wrong number of square metres stays wrong. You do not have to say goodbye to Excel for analysis either, since most tools export to it, as the article on keeping Excel next to construction software explains.

To give one concrete example from the tool I know best: in Beloplan the price of an article is copied into the quote line at the moment you add it, so a later change in your price list does not change quotes you have already sent, and an issued invoice is frozen with the next number of a series without gaps, so that it can only be corrected with a credit note. Those are two guarantees a spreadsheet cannot give you, however careful you are.

A simple test for your own firm

Go back to the seven signs and count the ones that matched your last month. This is my rule of thumb from running sites and the paperwork behind them, and it makes no claim to be scientific.

With none or one, stay in Excel, tidy it up with a single price list and locked formulas, and make sure your invoices to businesses go out in the structured format. With two or three, find the one that hurts most, which is usually hours or invoicing, and solve that with a single tool before you think about a complete system. With four or more, you are already paying for Excel every week in hours and in work that never gets invoiced, and construction software is likely to cost less than what you lose. The calculation for a firm of ten people shows how to put a number on that before you sign anything.

What to do next

This week, make a list of your customers who have a Belgian VAT number and check how each of them received your invoices since 1 January 2026. If any of those invoices still left as a PDF only, fix that first, because it is the one item on this page that the law requires.

Then count the timesheets that somebody retyped last week, and go through the extras of the last quarter to see which ones reached an invoice. Those two numbers tell you more about your firm than any comparison of software brands. If the count says it is time to move, the plan for switching from Excel in 30 days shows how to do it around site work, and the article on what the crew does on the phone answers the question your foreman will ask first.

Sources

  • Panko, R., Spreadsheet Errors: What We Know. What We Think We Can Do, EuSpRIG symposium, July 2000, arxiv.org/abs/0802.3457
  • US Government Accountability Office, decision B-292555 and B-292555.2, Roy Anderson Corporation, 10 October 2003, govinfo.gov
  • FPS Finance and FPS BOSA, electronic invoicing FAQ for businesses (questions 2, 11 and 14), einvoice.belgium.be, and the guide on where to start, einvoice.belgium.be
  • The Brussels Times with Belga, One third of Belgium’s construction companies in financial difficulty (Embuild survey), 25 September 2025, brusselstimes.com
  • Atradius, Payment Practices Barometer Belgium (a survey by a credit insurer), 22 May 2026, atradius.de
  • Law of 2 August 2002 on combating late payment in commercial transactions, as amended by the laws of 22 November 2013 and 14 August 2021
  • European Commission, Your Europe, Late payment, with the statutory rate per country, europa.eu

All sources checked on 8 November 2026.

About the author

Denys-Daniel Croitor

founder

Denys-Daniel Croitor is a founder of Beloplan. He writes about how construction firms run their sites and offices, and about the step from spreadsheets to software.