How to Track Appliance Repair History by Unit (Free Template)

To track appliance repair history by unit, keep two linked lists: an inventory with one row per appliance (unit, type, brand, model, serial, install date) and a repair log with one row per visit (date, fault, part, cost, vendor, callback or not). A spreadsheet is enough. The appliance repair log template below is the starting point, and the payoff is three reports you can't get any other way.

Why an appliance repair log pays for itself

Most buildings already have the information. It's spread across vendor invoices, emails, the work-order system and the super's memory. What's missing is one place where it's organized by apartment and appliance.

Without that, every call starts from zero. The person who takes 6B's dishwasher call doesn't know the pump was replaced two months ago, so nobody asks the vendor to honor the warranty. The owner asks how old the fridges in the C line are, and someone has to walk the building with a flashlight.

A log fixes both. It also makes the repair-or-replace decision faster, because the age and the recent repair spend are already written down.

Table one: the appliance inventory

One row per appliance, not per apartment. A unit with a fridge, range, dishwasher and washer has four rows. Fill it in once, then update it only when something is replaced.

The building name and dates are placeholders; replace them with yours.

A few notes on the columns:

Model and serial are the most useful fields in the sheet. The model number lets a technician look up parts before the visit. The serial is what the manufacturer asks for on a warranty claim.

Installed date is often unknown in older buildings. Many manufacturers encode the manufacture date in the serial number, though the format differs by brand. Look up the maker's decoding guide or ask the technician to read it on the next visit, and record where the date came from (invoice, serial code, estimate), because an estimate shouldn't drive a budget the same way a receipt does.

Notes is for the things that make a replacement harder: a 24-inch opening, a 20-inch prewar range, a stacked washer-dryer in a closet, a dishwasher that drains through the disposal. Those details decide what you can buy when the time comes.

Table two: the repair log

One row per visit. If a job took two trips, that's two rows with the same work-order number, which is how the log tells you about return trips.

Write the reported symptom and the diagnosis in separate columns. Over time the gap between them is informative. If "won't drain" keeps turning out to be a clogged filter, a note to tenants saves you money.

Ask your vendors to put the part number on every invoice. "Replaced part" can't be matched to a warranty or a later failure. A part number can.

Two optional columns earn their place in bigger buildings. The first is cause: wear, tenant damage, building condition (a slow drain stack, low water pressure on the top floors) or unknown. If you ever charge back a repair, the pattern in that column is what supports it, and it also shows you which problems are really the building's. The second is days out of service, from the tenant's first report to the fix. It's the number an owner asks about after an HPD complaint, and it's tedious to reconstruct afterward.

One more habit: check the log when the call comes in, not after the visit. If the part was replaced within the vendor's warranty period, say so when you book the callback. That's the moment the warranty is worth something.

Spreadsheet or work-order software

Use whatever your team will actually keep up to date. A shared spreadsheet works well up to a few hundred units, with the inventory and the log on two tabs and unit plus appliance as the lookup key. It's free, anyone can filter it, and it survives a change of management software.

Work-order or property-management software is better once you have several buildings and more than one person dispatching. The advantage is that the log fills in as a side effect of closing work orders, instead of being a separate chore. The catch is that many systems store the appliance as free text on the work order, not as a record with a model and serial. If yours can hold an asset record per appliance, use it. If not, keep the inventory tab in a spreadsheet and log the work-order number against it.

Either way, decide who closes the loop. The best template in the world is empty if nobody types the invoice in.

The three reports it gives you

Once the two tables exist, three reports take minutes to pull. They're the reason to keep the log.

Repeat offenders

Filter the repair log for any appliance with three or more visits in the last 12 months, or two or more for the same symptom. That list is short in most buildings, and it's where your money goes. Each one is a candidate for the repair-or-replace decision. Our repair-vs-replace worksheet uses the age and recent repair spend straight from these tables.

The end-of-life list

Sort the inventory by age against typical life for that appliance type. Anything past about two-thirds of its expected life, with repairs on record, goes on a watch list. Our note on how long appliances last in rental units has the published figures to use for expected life.

The watch list turns emergency replacements into planned ones. Planned replacements can be scheduled at turnover, matched to the rest of the building, and bought before the old unit fails on a Friday night.

Vendor callback rate

For each vendor, count the visits marked as callbacks (same appliance, same symptom within about 90 days) against their total visits. Count the work orders that took more than one visit, too. Those two numbers tell you more about a vendor than their hourly rate does, and our note on first-visit fix rate explains why.

Keep it fair. A part on backorder is not the vendor's fault, so mark those visits in the log and leave them out of the count.

Getting the backlog in

You don't have to fill the inventory in one weekend. Three habits get it done within a year:

1. Every repair visit adds or confirms the row for that appliance. Ask the technician to note the model and serial on the write-up.
2. Every turnover, the super photographs the rating plate on each appliance in the empty unit.
3. Every replacement updates the row with the new model, serial and install date, and files the invoice.

Start the repair log today, even with an empty inventory. Each entry fills in another row.

Next step

Copy the two tables into a sheet and add your next work order to it. When you send us a request, include the model and serial if you have them, and ask for the diagnosis and part numbers on the write-up so they go straight into the log. You can open a work order for the unit here.