Register
Asset, category, club, zone, serial number, supplier, purchase date and cost for every item. Identical machines get a row each so their histories stay separate.
FREE EXCEL TEMPLATE
Gym equipment register template: every machine, its value and what's due.
A free gym equipment inventory for Excel and Google Sheets. One row per machine, for one club or many. It works out written-down value and replacement year, flags services, inspections and warranties before they lapse, and keeps a service log with a summary you can hand to your insurer.
By Callan, ClubPilot · Updated
Free Excel template · Works in Google Sheets · No sign-up required
- Built for gyms: cardio, strength, free weights, flooring and safety equipment
- Red and amber flags for overdue services, inspections and warranties
- Summary by club and category for insurers, owners and accountants
AT A GLANCE
Built around accountable follow-through.
Service log
Every service, repair and inspection with supplier, reference, cost and who returned the item to service. Pick the asset ID and the rest fills in.
Summary
Assets, purchase cost, current value and 12 months of service spend by club and by category, plus a five-year replacement forecast.
WHAT IT WORKS OUT FOR YOU
The grey columns do the arithmetic.
Enter what you know about each machine. The register calculates the rest every time the file opens.
- Age and the year each item is due for replacement
- Written-down value by prime cost or diminishing value
- Next service date from the last service and the category's interval
- Next inspection date from your inspection interval
- One flag per asset: out of action, overdue, due soon, warranty ending or OK
- Totals by club, by category and for the whole group
DEFAULTS YOU CAN CHANGE
Sensible starting points for gym equipment.
Each category comes with a default useful life and service interval, such as seven years and quarterly servicing for cardio, or fifteen years and yearly checks for racks and benches. They are planning estimates for commercial use, not ATO effective lives. Change them on the Lists sheet to match the manufacturer's instructions and your own experience, and use your accountant's figures for tax.
Gym equipment maintenance checklist
Pair the register with daily, weekly and monthly checks and a fault-to-close record.
Open pageOut of order tags
Print do-not-use tags and keep an out-of-service register for anything tagged out.
Open pageWITH CLUBPILOT
Same column names as a ClubPilot maintenance job.
Club, asset, serial number, supplier, supplier reference, actual cost and job number use the names ClubPilot uses, so you can copy details across when you log a fault. In ClubPilot each job keeps its photos, quotes, approvals, supplier hand-off and completion evidence together, across every club.
Gym maintenance software
See how faults, quotes, approvals and verified repairs run in ClubPilot.
Open pageWHEN A SPREADSHEET STOPS WORKING
Where registers usually drift.
A register is only as good as its last update. These are the gaps to watch for as the group grows.
- Repairs are agreed by text and never reach the service log
- Several people edit their own copy of the file
- Nobody owns checking the flags each week
- Quotes and invoices stay in an inbox instead of with the asset
- Disposed equipment is deleted, so its history is lost
STRAIGHT ANSWERS
Gym equipment register: questions worth asking.
What should a gym equipment register include?
At minimum: a unique asset ID, what the item is, its category, club and location, serial number, supplier, purchase date and cost, status, warranty expiry, service interval and the last service and inspection dates. This template includes all of these, plus calculated value, due dates and flags.
Does it work in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets. The formulas, dropdowns and colour flags all work there.
Is the written-down value right for my tax return?
No. It is an estimate as at today for insurance and replacement planning. Tax depreciation depends on ATO rules and your circumstances, so use your accountant's figures.
Should identical machines share a row?
Give each machine its own row and asset ID. Two treadmills bought on the same day will still have different faults, services and replacement dates.
Can I use it for more than one club?
Yes. Type your club names on the Lists sheet. They become the Club dropdown, and the Summary shows assets, value, service spend and items needing attention for each club.
FREE RESOURCES
More free gym operations guides
Gym equipment fault report and repair tracker
Capture a fault once, give the repair an owner and keep the evidence needed to verify closure. Use alongside the equipment register and manufacturer service instructions. Free PDF
Gym equipment maintenance checklist
Daily, weekly and monthly reviews with a fault-to-close record. Free PDF
Gym out of order sign and equipment tag
Printable do-not-use tags and an out-of-service register. Free PDF
New gym manager first 30 days plan
Help a new manager learn the club, establish responsibilities and agree priorities before changing routines. Use weekly checkpoints with the area manager to turn observations into practical actions. Free PDF
Gym member feedback follow-up template
Give each feedback item a response owner, due date and closure check. Keep sensitive member information in your approved member system and use references here. Free PDF
Gym petty cash reconciliation template
Record the opening float, approved additions, receipt-backed spending and counted closing cash. Investigate differences before sign-off. This is an operational record, not tax advice. Free PDF
A PRACTICAL NEXT STEP
Keep every club's equipment history in one place.
ClubPilot keeps each fault, quote, approval, supplier, cost and verified repair together, with reminders before services and inspections lapse.