From Excel and WhatsApp to Facility Management Software: A 30-Day Switch Plan

Every FM company we work with started here. A client calls about a leaking AHU, someone posts it in a WhatsApp group, a technician is "informed", and three days later the client asks for the report. Nobody can say who owned the job, when it closed, or what was actually done.

That is not a people problem. Spreadsheets and chat groups were built for lists and conversations, not as the system of record for multi-site facility work. This guide is the plan we give new customers for the first 30 days. It works whether you choose DWD or another product.

Why Excel and WhatsApp break as you grow

For one client and five technicians, a sheet and a group can limp along. They fail when you add a second client, a night shift, or a contract that asks for SLA evidence, because there are three things they simply cannot do:

1. Assign work as a fact. A message in a group is not an assignment. Everyone can read it, so nobody owns it.
2. Keep history. Changing a cell from "open" to "closed" erases the trail clients and auditors want to see.
3. Produce proof. A photo in someone's gallery is not a signed service report. A PDF emailed from site is.

If you are still deciding whether the switch is worth it, the facility management software vs Excel comparison covers that. The rest of this page assumes you have decided and want to do it without chaos.

Before day 1: make four decisions

The software is the easy part. What slows teams down is that nobody ever agreed these four things, because a spreadsheet never forced the question. Get your operations head and one senior supervisor in a room for an hour.

1. Service names. One list: HVAC, Electrical, Plumbing, Civil, Housekeeping, Pest Control, and so on, with sub-services underneath. Not "AC", "A/C" and "Aircon" in three different sheets.
2. Site codes. A short, unique code for every site, such as TWR-B or MALL-RD. Technicians will see these all day.
3. Statuses. Keep it to five or six: Open, Assigned, In progress, Awaiting quote approval, Closed. Every extra status is a place for tickets to hide.
4. Who closes. Decide that a job is closed only when the technician completes the report on the app, with photos. Not when someone says "done" in a group.

Week 1: every new complaint goes into the system

Goal: no new complaint exists only in WhatsApp.

• Sign up, add your active clients, their sites and your service list. In DWD this takes an afternoon; you can bulk-import sites from Excel.
• Copy in this week's open complaints by hand. Only the open ones.
• From Wednesday, whoever answers the phone logs the complaint before they forward anything.
• Keep the WhatsApp groups. But the only thing posted there now is the ticket number.

Clients who prefer WhatsApp do not need to change. In DWD, a message to your WhatsApp Business number becomes a ticket with the client, site and photos attached, and status updates go back on the same chat. The client keeps the channel they like. You get a record that does not scroll away.

Week 2: jobs close only from the technician app

Goal: every closed job has photos and a signature, and the client has the PDF before the technician leaves.

• Install the app on every technician's phone and do a 20-minute session on site, not in a classroom. Close one real job together.
• Show them the voice button. Most technicians would rather speak than type, and DWD turns a short voice note in Hindi, Arabic or English into a clean report.
• Pick two supervisors as champions. They check every closed ticket for photos for the first ten days.
• Listen for the two biggest complaints and fix them in week two. It is usually a missing service name or a site that was set up wrong.

Basements and plant rooms with no signal are not an excuse: the app works offline and syncs when it can.

Week 3: assets, QR codes and PPM

Goal: PPM no longer lives in one person's file.

• Import your asset list from Excel: asset, site, location, make, model, install date. Do not wait for it to be perfect; you will clean it as technicians scan.
• Print QR stickers and put them on your top 50 assets first: chillers, AHUs, DG sets, pumps, lifts, fire panels.
• Set PPM frequencies per asset. DWD builds the 52-week calendar and raises each visit as a ticket with its checklist.
• If your current plan is in Excel, our free PPM calendar tool is a quick way to sanity-check frequencies before you import.

Week 4: clients, SLAs and rate cards

Goal: clients see their own work, and extra work gets quoted.

• Set SLA targets per client and priority, straight from the contract. Escalations start firing before breaches.
• Import rate cards for clients who get quotations. From now on, extra work is quoted from the ticket, and the client approves by email.
• Invite one friendly client admin to the portal first. Fix whatever confuses them, then invite the rest.
• At month end, send the first automatic client report. Then rename the old spreadsheet to "ARCHIVE" and make it read-only.

What to leave behind

Do not import five years of closed complaints. It takes weeks, the data is messy, and nobody will look at it. Keep the old files read-only for reference and let the new system build clean history from day one. The exception is asset service history for critical equipment, which you can attach as a document to each asset.

The objections you will hear, and what to say

"My technicians cannot type reports." They do not have to. Photos, a signature and a voice note are enough; the app drafts the text.

"Clients like WhatsApp." They can keep it. The ticket is created from their message and updates go back to the same chat.

"We tried software before and nobody used it." Usually because closing a job in the system was optional. Make the app the only way a job gets closed, and make sure the client sees the PDF. Once clients expect it, technicians follow.

"It will slow us down." For about a week. After that, the morning phone round to rebuild the job list disappears, and month-end reports take minutes instead of days.

Day 31 onwards: what to measure

• Share of tickets created in the system rather than retro-logged: aim for 100%
• Share of closed jobs with photos and signature
• Time from job done to client receiving the report
• SLA and PPM compliance per client
• Value of extra work quoted from tickets

Need a number for your finance team before you start? The facility management software ROI calculator estimates the payback in INR or AED. If you are still comparing vendors, use the buyer's guide and checklist.

Frequently asked questions