20 years of operational data trapped in spreadsheets

Energy Saving Malta had been servicing water heaters across Malta for two decades. But their operations hadn't caught up with their experience. Everything, client records, job history, technician schedules, parts inventory, lived in Excel files updated by hand.

The Breaking Point

• 20 years of client data on spreadsheets with no reliable search, history tracking, or automation
• Manual QuickBooks sync every update required duplicate entry across disconnected systems
• Handwritten job reports no standardisation, no digital trail, no proof of work for clients
• No technician visibility no way to know what a technician was working on, how long it took, or what parts were used
• No automated reminders clients missed scheduled maintenance because there was no system to prompt them

With a small team managing over 5,000 clients, the manual workload wasn't just inefficient. It was a ceiling on growth. The business needed a system built around how they actually work.

A custom field service management system built from the ground up

We tested existing products but none solved Energy Saving Malta needs. We built them a purpose-built field service platform that replaced every manual process in their operation. Rather than adapting an off-the-shelf tool, we designed the system around their exact workflow: product servicing, repairs, installations, and ongoing maintenance.

What We Built

• Client management system full history, service schedules, and contact records for 5,000+ clients in one place
• Automated client reminders the system identifies who is due for service and prompts outreach automatically
• Digital job management technicians start jobs on the system, work through product and job-type specific checklists, and close off with before-and-after photo uploads
• Automated invoicing invoices generated and sent from within the platform, with job details and photo proof attached
• Warranty tracking warranties logged against clients and sent to them automatically post installation.
• Technician management track who is working on what, time spent, and performance across the team
• Parts and stock control log parts used per job, monitor stock levels, and receive low-stock alerts
• QuickBooks integration financial data flows directly — no duplicate entry
• WhatsApp integration client communications and job receipts sent via WhatsApp automatically

How We Worked

We ran structured discovery sessions to map every step of their existing process before writing a line of code. The goal was to replace the workflow entirely, not just digitise it. Build sprints were reviewed collaboratively with the Energy Saving Malta team to ensure the system matched real-world operations before go-live.

The project was delivered over three months, with ongoing support and training in place post-launch to iterate as the team embedded the new system into daily operations.

From manual to managed. Measurable impact from day one.

Operational Wins

• Job reports: seconds, not hours what previously required handwriting and manual filing is now completed at the click of a button on-site
• Service scheduling: instant the system surfaces who needs to be contacted and when — no manual calendar-checking required
• 20 years of data, now searchable all historical client and job data migrated and accessible in seconds
• Zero duplicate data entry QuickBooks integration eliminated manual financial reconciliation entirely
• Digital proof of work every job closes with timestamped before-and-after photos sent directly to the client via WhatsApp

The system didn't just digitise existing processes — it fundamentally changed what Energy Saving Malta can do as a business.

1. From Reactive to Proactive

The system tells them who is due for service, when, and what the job history looks like. Maintenance is now scheduled, not reactive.

2. Proof of Work, Every Time

Before-and-after photo documentation sent automatically with every job receipt means clients receive verified proof of work done. This builds trust and reduces disputes.

3. Full Technician Accountability

Management now has real-time visibility into what every technician is working on, how long jobs take, and what parts are being used. This was impossible with handwritten reports.

4. Stock and Parts Control

Low-stock alerts and per-job parts tracking mean the business is no longer surprised by shortages. Purchasing decisions are now informed by actual usage data.

5. Financial Accuracy

The QuickBooks integration removed a layer of manual reconciliation entirely. Invoices flow from job completion through to accounting with no duplicate entry and no margin for error.

Building a centralised system created a cascade of operational improvements that extended well beyond the original brief.

• Client retention improved because automated reminders mean scheduled maintenance no longer falls through the cracks
• Staff capacity freed up hours previously spent on manual data entry and report writing are now available for client-facing work
• Business is now scalable a team of under ten people can manage 5,000+ clients without adding headcount — the system scales with them
• WhatsApp receipts build brand trust clients receive professional, timestamped job summaries automatically — a level of service most competitors cannot offer

Most importantly, Energy Saving Malta can now do things that were simply not possible before: run accurate service forecasts, track technician performance over time, manage parts procurement based on data, and deliver a professional, documented service experience to every single client.