Nearly every fire protection business starts the same way: an asset register in Excel, a paper logbook on site, routine dates in a shared calendar and defects in someone’s notebook. For a handful of buildings that works. The trouble is that AS 1851 work grows in a way spreadsheets do not, and the cracks show up as missed visits, defects nobody quoted and records you cannot find when an auditor asks.
This guide covers what a spreadsheet does well, where it breaks for fire maintenance, ten questions to tell whether you have outgrown it, and how to move to fire maintenance software without retyping your register.
What a spreadsheet does well
Spreadsheets are free, flexible and familiar. Everyone in the office can open one, you can add a column whenever a client asks for something new, and for a sole trader with a few sites it can be the right tool. There is no shame in running on Excel. The question is whether it is still saving you time or quietly costing it.
Where spreadsheets break for AS 1851 work
The frequencies multiply
AS 1851 sets monthly, six-monthly, yearly and five-yearly activities that differ by type of equipment. A building with extinguishers, hydrants, hose reels, exit lights and a detection system carries several overlapping cycles, and each new site multiplies them. Keeping every next-due date right by hand is where most spreadsheets first fail.
There is never one copy
The office has the register, the technician has a printout from last month, and someone emailed an updated version to the client. When an extinguisher is replaced or a detector is added, only one copy gets the change. A month later nobody is sure which is right.
Defects fall through
A defect written in a cell or a logbook is easy to note and easy to forget. Unless someone turns it into a quote, the remedial work is never sold, the building stays non-compliant, and the same defect turns up on the next visit.
The evidence is scattered
Photos sit in technicians’ camera rolls, signatures are on paper, and test results are in a mix of logbooks and files. When a building owner, certifier or auditor asks for the service history of one asset, someone spends an afternoon assembling it.
Statement season hurts
Annual statements such as the NSW AFSS need the right measures, the right dates and evidence the work was done. Pulling that together from spreadsheets for every building that is due is a seasonal scramble.
One person holds it together
Most spreadsheet systems depend on the one person who built the formulas and knows the colour coding. When they are on leave, or leave, the system goes with them.
Ten questions: have you outgrown the spreadsheet?
- Has a routine visit been missed or done late in the last six months because a date was wrong?
- Do you have more than one version of any site’s asset register?
- Could you produce the full service history of a single asset in under five minutes?
- Are defects from the last quarter all quoted, or at least recorded as declined?
- Do technicians retype results from paper into the office system?
- Are site photos stored somewhere other than technicians’ phones?
- Does preparing annual statements take more than a day a month in the busy season?
- Would the system keep running if the person who built it was away for two weeks?
- Are you invoicing completed visits within a day or two?
- Could you take on ten more buildings next month without hiring office help?
If you answered the wrong way on three or more, the spreadsheet is costing you more than software would.
What a missed visit really costs
The obvious cost of a missed routine is the visit you did not bill. The bigger costs follow it: remedial work that was never found or never quoted, a statement that cannot be signed on time, an owner exposed to a penalty, and a contract that is harder to keep at renewal. Our guide to the hidden cost of missed service dates works through it in detail.
What fire maintenance software changes
- Schedules are generated from the contract, so every monthly to five-yearly visit is planned for the term rather than typed into a calendar.
- There is one register per site, shared by the office and the field, and it updates itself as assets are tested, added or replaced.
- Technicians test on the phone against that register: pass, defect or not applicable per asset, with photos and a signature.
- Defects become quotes in a step, so remedial work is sold instead of forgotten.
- Service history, reports and photos for any asset are a search away, and building owners can see them in a client portal.
Moving off the spreadsheet without starting again
You do not need to retype anything. Tidy the register first: one row per asset, one column per piece of information, consistent site names and real dates. Then import it. In traqR the asset import reads Excel and CSV files, including workbooks with several sheets, matches your columns automatically and keeps anything it does not recognise as custom fields. Clients and staff import the same way. Keep the old spreadsheet as an archive, and run both for one service cycle if it makes the team more comfortable.
Frequently asked questions
Can I run AS 1851 servicing on Excel?
Yes, for a small number of sites, and plenty of contractors do. It gets harder as the number of buildings, assets and frequencies grows, because every next-due date, defect and record has to be kept right by hand.
Will I have to retype my asset register?
Not with software that imports spreadsheets. traqR reads Excel and CSV registers in the layout you already have, matches the columns and shows you the mapping before anything is added.
How long does it take to move off a spreadsheet?
The import itself takes minutes per site. Cleaning the spreadsheet beforehand usually takes longer, and setting up contracts and schedules depends on how many you have. Most small contractors can be running on real sites within a week or two.
Is fire maintenance software worth it for a small business?
It usually pays for itself once it prevents one missed visit or one unquoted defect a month. Start with a free trial on a real contract and judge it on the time it saves your office.