From Excel to GPS: how an electrician saves €12,000 a year

Mario Bianchi, an electrician, was recovering €12,000/year in revenue. Then he stopped using Excel.

Mario is 38 years old, has been working as a freelance electrician for 12 years, and averages 4–5 jobs a day across homes, offices and industrial units. He’s good at his job, customers recommend him, and every year he was losing around €12,000 in unpaid hours.

Not because he was unlucky. Because he used Excel.

---

The problem with Excel for an electrician working on multiple sites

Excel is a wonderful tool. For bookkeeping, data analysis, planning. For documenting the work of a mobile technician, it is, by definition, the wrong choice.

Here’s why:

Problem 1: it’s filled in retrospectively
Mario would fill in his hours at the end of the day, sometimes at the end of the week. Memory plays nasty tricks: a two-hour job becomes ‘an hour and a half’ by mistake.

Problem 2: there’s no proof of location
The spreadsheet says “site at 23 Via Roma”, but it doesn’t prove that Mario was actually there, nor what time he arrived and left.

Problem 3: it can be altered
The client knows this. “You filled in this Excel sheet yourself; you could have put whatever you wanted in it.” And he’s right.

Problem 4: it doesn’t scale
With 5 job sites a day and 20 working days, Mario was filling in 100 rows a month. Every calculation error was a silent loss.

---

How time tracking works for an electrician with GeoTapp

The process is simple:

Morning, arrival at the first site:
Mario opens GeoTapp, taps “Start job” → the system records GPS, timestamp and site.

During the job:
He can take photos of the work carried out (installations, cables, switchboards). These are saved with GPS coordinates and automatic timestamps.

End of job:
He taps “End job” → GeoTapp generates a report with: exact duration, route, photos, and any notes. In 10 seconds.

End of the month:
Automatic export of all hours by client, site and type of work. Ready for invoicing.

---

What has changed for Mario after 6 months

“Before, I used to waste time trying to remember what I’d done and where. Now I open GeoTapp and see everything: every site, every hour, every photo. I found €1,000 worth of uninvoiced work in the first month simply because I’d forgotten to log an urgent job on a Saturday.”

Mario’s figures after 6 months:

Metric	Before (Excel)	After (GeoTapp)
Hours lost due to inaccuracy	~15 hours/month	0
Disputes accepted	3–4 per month	0
Time spent recording attendance	2 hours/week	0
Revenue recovered	–	+€12,000/year
GeoTapp cost	–	€59/month
ROI	–	1,593%

---

The case of the customer who ‘couldn’t remember’ Saturday

A specific incident that Mario often recounts: an urgent call-out on a Saturday morning, involving three hours’ work on a restaurant’s electrical panel. At the end of the month, the restaurant owner claimed that Mario had only been there for 45 minutes.

Without GeoTapp: Mario would have given in, or started an argument over €90.

With GeoTapp : he sent the link to the report. The restaurant owner saw:
– GPS check-in at 8:47 am in the restaurant car
park– GPS check-out at 11:52
am– 7 photos of the work with
timestamps– A document hash proving the report’s integrity

The restaurant owner paid. He also renewed the maintenance contract.

---

Specific features for electricians

GeoTapp has features that are particularly useful for those working on electrical installations:

Management of multiple sites: each site has its own file with a history of jobs, photos and technical notes. Perfect for clients with multiple properties.

Job categorisation: you can tag each job (installation, maintenance, emergency, testing) to analyse profitability by type.

Export for tax returns: GeoTapp generates a structured export for invoicing and accounting. Accountants appreciate this.

Overtime calculation: the system automatically detects work outside standard hours and flags it for separate invoicing.

---

From Excel to GeoTapp: migration in 1 hour

Many electricians think switching to a new system takes weeks. In reality:

1. Sign-up: 5 minutes
2. Importing customers and jobs: 20 minutes (or set up from scratch in 10 minutes)
3. Downloading the app to your smartphone: 3 minutes
4. First documented job: the very same day

No technical training, no IT support. GeoTapp is designed for those who work with their hands, not for those who work in front of a computer.

---

Comparison: Excel vs GeoTapp for freelance electricians

Function	Excel	GeoTapp
GPS attendance proof	❌	✅
Tamper-proof timestamp	❌	✅
Service call photo with GPS	❌	✅
Automatic invoicing export	Manual	✅ Automatic
Reports by customer	Manual (hours)	✅ 1 click
Multi-site management	⚠️ Complex	✅ Native
Mobile app	❌	✅ Android + iOS
Cost	€0	From €29/month

---

Conclusion: your time is worth more than what you’re charging

If you’re a freelance electrician or a small business, you’re probably already losing between €5,000 and €15,000 a year in undocumented, unaccounted for or forgotten hours.

GeoTapp doesn’t change your work in the field. It changes how you document it, automatically, as you go.

The Moment When Excel Stops Being Enough

There’s a specific moment in every electrician’s life as they grow, hiring their first technician, then a second, then running three sites simultaneously, when Excel stops being a tool and becomes a problem. It’s not that Excel works badly: it’s that managing the complexity of multiple people across multiple sites with a spreadsheet requires a maintenance workload that grows exponentially. Every week you spend hours cross-checking spreadsheets, correcting data entry errors, figuring out why the hours don’t add up, and sending emails to retrieve reports that haven’t arrived.

It’s not a problem of discipline or organisation, it’s a structural problem. Excel wasn’t designed to manage distributed work in real time. GeoTapp was. And the difference between the two approaches isn’t just about efficiency: it’s about the quality of the decisions you can make. With Excel, you make decisions based on yesterday’s or last week’s data. With GeoTapp, you make them based on what’s happening right now.

The Added Value You Didn’t Anticipate: Evidence for the Customer

When an electrician switches to GeoTapp, the most anticipated benefit is always the saving in administrative time. But the most surprising benefit, the one many haven’t anticipated, is the change in the relationship with customers. When you can show the customer not only the invoice but also the documentation of the job, photos, GPS, certified timings, the approval process changes completely. There is no longer a ‘we need to check’ phase that delays payment. The customer sees the evidence, approves it, and pays.

For extraordinary or emergency maintenance jobs, where the customer was often not present during the work, this documentation is the difference between invoices paid within the usual timeframe and invoices disputed for weeks. Many electricians who have adopted GeoTapp report a significant reduction in average payment times, with a direct impact on the company’s cash flow. It’s not just a nice bonus, it’s real cash flow.

Onboarding That Doesn’t Require a Dedicated Monday Morning

The main concern when considering new management software is always the same: how long does it take to learn, and how long do I have to stop operations to implement it? With GeoTapp, the answer to both questions is “very little”. You can set up an account in five minutes, technicians are added via an invitation link (it also works via WhatsApp), and they can start clocking in on the very same day. There’s no mandatory training, no manual to study, and no “roll-out” phase lasting weeks.

You can start on Friday afternoon and have the system up and running by Monday morning. Technicians install the app, available on the App Store and Google Play, free for them, and the normal workflow continues exactly as before, only with automatic data instead of manual entries. GeoTapp’s learning curve is practically flat for anyone who already uses a smartphone every day.