Build an Equipment Register in One Month, One Store a Week

It is 7:40 on a Saturday morning. The walk-in cooler at store six is at 9 degrees and climbing. You call the refrigeration company, and the dispatcher asks for the make, the model and the serial number. You have none of them. Someone has to dig out the nameplate from behind the dairy crates.

An equipment register fixes that. It is a single list of every piece of equipment you own, with enough detail to make a repair call in two minutes. This post gives you an equipment register template you can build in a month, one store a week. It works in a spreadsheet. It also works in software, and we say where Concoct fits and where it does not.

The six fields that matter

Most registers die because the template asked for too much. Start with six fields:

1. Make. The manufacturer, as printed on the nameplate.
2. Model. Copy it exactly, including dashes and suffixes. Parts and service manuals are looked up by model.
3. Serial number. This identifies the individual unit, and it is what warranty and manufacturer support ask for first.
4. Install date. If you do not know it, enter the year on the nameplate or your best estimate and mark it "est." An honest estimate beats a blank.
5. Owner. Who is responsible for this asset: you, the franchisor, the landlord. This matters more than people expect. Rooftop units and shared exhaust systems can be the landlord's responsibility under your lease. Check the lease, and find out before a failure, not during one.
6. Servicing vendor. Who you call when it breaks. One name and one phone number.

Add two helper columns: store and location in store (kitchen, back room, roof). That is the whole template. If you want a seventh field, wait until the register is done and you know what you actually missed.

An equipment register template you can copy today

Make a sheet with these column headers, in this order:

• Store
• Area in store
• Equipment type
• Make
• Model
• Serial number
• Install date
• Owner
• Servicing vendor
• Notes

Equipment type is a plain label: walk-in cooler, fryer, rooftop unit, ice machine. Reuse the same words across stores so you can filter later. "Walk-in" in one store and "walk in fridge" in another will cost you an afternoon. Notes is for the odd stuff, such as "landlord owns, call property manager first."

Week 1: store one, walk it with a phone

Pick the store with the most equipment or the most problems. Walk the building with a phone. For each item:

• Photograph the nameplate. Take one wide photo showing where the unit sits too.
• Type the six fields into the sheet before you leave the room. Do not plan to enter them later. Later does not happen.
• If a nameplate is unreadable, note "plate worn." The make and model may be on an old invoice.

Budget a few hours for a store. That is a rough guess, not a benchmark: it depends on the kitchen and the building.

At the end of week one, ask one question. Could the person on call, with only this sheet, make a service request for any item in the store? If not, fix the template now, before you copy it to more stores.

Week 2: store two, and settle the vendor column

Store two goes faster. This is also the week to clean up the servicing vendor column. The same refrigeration company will be spelled three ways. Pick one spelling for each vendor and use it everywhere. If you do not know who services something, write "unknown" rather than guessing. Unknown entries show you exactly where a failure would catch you flat. If you want help with the vendor side, see how to manage vendors who refuse to log in.

Week 3: stores three and four, delegated

Hand it off. Give each store manager their section of the sheet, a one-page walkthrough of the six fields and a deadline. Then verify: spot check five rows against the nameplates. A serial number that is one character off is worse than a blank.

If you are doing this across many stores, the 30-day rollout plan for 10 sites covers how to sequence the people side.

Week 4: finish, then give it an owner

Finish the remaining stores, then do three things that keep the register alive.

• Name one maintainer. One person owns the sheet. Managers send changes to that person, or edit only their own tab.
• Set a trigger for updates. Every time equipment is replaced or added, the register changes the same week. Make this part of the purchase or install checklist.
• Review once a quarter. Fifteen minutes: look at the install dates, sort oldest first and decide what to budget for.

Install dates tell you what is likely to need replacing, so you can budget for it instead of paying for the emergency.

Where software helps, and where it does not

A spreadsheet is a fine register for a few stores. It gets harder when several people edit it, or when the sheet has to connect to repair history.

Concoct stores equipment records with make, model, serial number and install date, plus an asset tag and QR code you can put on the unit, so a manager can scan it and report a problem against the right machine. Equipment can be imported from a spreadsheet (CSV), so the work you do in the sheet is not thrown away. The web app works in a phone browser.

Be clear about the limits. The import needs a name, type, location and status for each row, and the location must already exist in Concoct with the same name. Make, model, serial number, install date and notes are optional columns. There is no separate owner field, so "landlord owns" goes in notes. And Concoct does not replace the walk-through. Someone still has to read the nameplates. Software cannot do that part for you, and neither can a template.

What to do next

If you want to try this on one store before deciding anything, build the sheet above and walk your worst store this week. If you would rather have the register live next to your work orders, see the pricing page, where plans are per location with unlimited users, or book a demo and bring your sheet. We will show you how the import handles it.

FAQ

How many fields should an equipment register have?

Six is enough to start: make, model, serial number, install date, owner and servicing vendor, plus store and area. Add more only once the register is complete. A long template is the main reason registers are left half finished.

What if I cannot find the install date?

Use the year on the nameplate if it shows one, or the date of the first invoice or lease you can find. If you are guessing, mark it "est." An estimated date still lets you sort by age. Replace it with the real one when you learn it.

Do I need to include small equipment?

Start with anything that would stop you trading or cost real money to replace: refrigeration, cooking equipment, HVAC, hood and exhaust, water heaters, ice machines, dispensers. Low-cost items can wait. Ask your insurer what they expect you to document.

Can I import my spreadsheet into Concoct?

Equipment can be imported from a CSV file. Each row needs a name, type, location and status, and locations must exist first. Make, model, serial number, install date and notes are optional. Bring your sheet to a demo and we will check it with you.