How do I track gym equipment maintenance without expensive software?

Q: Is a paper binder good enough for gym maintenance records?

It can be. UK HSE says inspection records do not have to be made in writing, and a binder at the desk is a valid format. The weakness is that paper can't tell you what's overdue and is easy to lose.

Q: What should a gym maintenance log record?

At minimum: the machine and its ID, the date, who checked it, the specific symptom, what was done, and when it went back into use. Keep notes on repeat problems so patterns show up.

Q: How long should I keep gym maintenance records?

HSE says inspection records should be kept at least until the next inspection. Markel, a fitness insurer, recommends keeping them for the lifespan of the equipment.

Q: When should a gym move from a spreadsheet to maintenance software?

When the spreadsheet stops getting opened, when you need reminders for due work, or when members' reports get lost between the form and the person who fixes things.

Track gym maintenance for free: a three-tab spreadsheet, a Google Form for staff, a QR code on each machine and a weekly review.

Nookesh Karri ·Oct 25, 2026 · 8 min read

Cover with the title: How do I track gym equipment maintenance without expensive software?

You can track gym equipment maintenance with free tools: a spreadsheet with one tab for equipment, one for the log and one for the schedule, a Google Form so staff can log work from their phones, and a QR code on each machine that opens the form. Add conditional formatting to flag overdue tasks and spend a few minutes each week reviewing what’s open. A binder works too, as long as it gets filled in every time.

What you need

A free Google account (for Sheets and Forms). Excel works the same way if that’s what you have.
A list of every machine on your floor, with its location and serial number if you can read it.
Each machine’s owner’s manual, for the service intervals.
A printer and some sticker paper or clear tape for QR codes.

Is a free system good enough?

For the record itself, yes. The UK Health and Safety Executive says “The result of the inspection should be recorded”, but also that “Records do not have to be made in writing.” Its maintenance guidance asks that, where a machine has a maintenance log, the log is kept up to date. Nothing there requires software.

Skelcore, an equipment supplier, makes the same point in its guide to gym maintenance logs: the log can be a spreadsheet, software, a QR code system or a binder at the desk, and consistency matters more than sophistication.

Step 1: Give every machine an ID

Walk the floor and give each machine a short ID: TM-01 for the first treadmill, CB-03 for the third cable station. Write it on the frame with a label maker or marker. The ID is what ties a staff note, a member report and a technician invoice to the same machine.

Step 2: Build the spreadsheet

Make one spreadsheet with three tabs.

Equipment: ID, name, model, location, serial number, purchase date, and the manual’s service intervals.

Log: one row per event. Start with Skelcore’s fields: date and time, the person who reported or inspected it, the specific symptom, the immediate action taken (cleaned, tightened, removed from service, monitored), parts ordered and service visits, the date the machine was returned to use, and notes on recurring problems like repeated belt drift, loose hardware, unusual noise or cable wear.

The symptom field is where most logs fail. “Broken” tells the technician nothing. Skelcore’s example of a good entry, “Cable fraying near handle on right side of functional trainer,” names the machine, the part and the urgency.

Schedule: one row per recurring task per machine, with columns for the task, how often, last done and next due. “Vacuum under hood, monthly” for each treadmill. “Tighten hardware, monthly” for each strength machine. Pull starting tasks from our guide to daily, weekly and monthly checks.

Step 3: Flag overdue work

Nobody reads a schedule tab line by line. Make overdue rows turn red.

In Google Sheets, select the cells, open Format, then Conditional formatting. Under “Format cells if”, choose “Custom formula is” and enter a formula that compares the next-due column with today. If next due is in column E, select the rows and use =$E2<TODAY(), then pick red fill. One catch from Google’s help page: formulas can only reference cells on the same sheet, so keep the due dates on the schedule tab itself.

Step 4: Let staff log from their phones

Staff won’t walk to the office computer to type a row. They will fill in a form on their phone.

Build a short Google Form with a dropdown of machine IDs, a field for what was done or found, and a choice of “still in use” or “taken out of service”. Then connect it to your spreadsheet: on the form’s Responses tab, open the menu and choose “Select destination for responses”, and pick your existing spreadsheet. Every submission lands as a new row. Copy those rows into your log tab, or use the responses tab as the log itself.

Step 5: Put a QR code on each machine

Open the form in Chrome on a computer and use the Share button on the right of the address bar to create a QR code for the page. Download it, print it and stick one on every machine next to the ID.

Now the person who spots the frayed cable can log it on the spot. HSE says employers should “have a procedure that allows workers to report damaged or faulty equipment”. A form that’s one phone scan away is that procedure.

Step 6: Review it every week

Skelcore suggests a short weekly manager review, about 20 minutes, covering open items, repeat issues and repairs waiting on parts. Put it in the calendar. This is where you notice the same bike has had a loose pedal three weeks running, and where you update next-due dates.

The log also pays off when it’s time to replace something. Repeated service, member complaints or long downtime on one machine make the case. And Markel, a fitness insurer, says that if you sell old equipment, “offer a copy of these records to the purchaser, and maintain the original copy.”

How to check it’s working

After a month, open the log and ask three questions. Does every machine have at least one entry? Are there any red rows older than a week? Can you answer “when was the lat pulldown cable last checked?” in under a minute? If any answer is no, fix the habit before you blame the tool.

What goes wrong

Nobody owns it. Name one person responsible for the weekly review.
The spreadsheet doesn’t remind anyone. Red rows only help if someone opens the file. A recurring calendar event for the weekly review is the cheapest fix.
Next-due dates go stale. When someone completes a task, they have to update the schedule tab by hand. This is the step that slips first.
Member reports have nowhere to go. A staff-only form leaves members telling the front desk, who forgets. Decide whether the QR form is for staff only or open to members.
Records get thrown out. Markel says to “maintain these records for the lifespan of the equipment.” Don’t delete old rows when a machine is serviced.

My take

Every small gym should start on the spreadsheet. It costs nothing, it shows you what you actually need to track, and when you outgrow it you’ll know why. Its weakness is that it’s passive. It never tells anyone a task is due, and next-due dates stay current only if someone updates them every time.

That gap is what GymTagOps is built for. Each machine gets a QR tag that members can scan to report a problem without an account or app, and completing a recurring task schedules the next one automatically. You can import your existing equipment list by CSV (up to 250 rows per upload) and export everything at any time, so the spreadsheet you build today isn’t wasted. It’s in early access with a free working preview; paid plans are planned, starting at $24 per location per month, but not yet purchasable, and email reminders aren’t active in the preview. The live demo shows a sample gym.

For what to put on the schedule, see how often gym equipment should be serviced and the preventive maintenance checklist. For one of the most common log entries, see when to replace gym cables.

FAQ

Is a paper binder good enough for gym maintenance records?

It can be. UK HSE says inspection records do not have to be made in writing, and a binder at the desk is a valid format. The weakness is that paper can’t tell you what’s overdue and is easy to lose.

What should a gym maintenance log record?