--- title: "Asset inventory for maintenance: where to start | attendo" description: "How to build a maintenance asset inventory that stays alive: what equipment to include, what each record needs, how to code assets and what kills it." url: "https://attendo.me/en/blog/asset-inventory-where-to-start" lang: "en" --- # Asset inventory: where to start Every maintenance project starts with the inventory, and many get stuck there. Not because it is hard, but because it is tedious. And if it is done badly, everything that comes after inherits the problem. - By the attendo team - Published September 27, 2026 - 3 min read **In this article** 1. The question that saves half the work 2. What goes on a record, in order of importance 3. Coding: one afternoon that saves years 4. How to build it in practice 5. The three mistakes that kill it 6. How to tell it is alive ## The question that saves half the work Before adding anything, ask yourself: **will I make decisions about this piece of equipment on its own?** If the answer is no, it does not need its own record. The 340 light fixtures in a building are not 340 assets. They are one, “second floor lighting,” or they are not there at all. An inventory with 12,000 records, of which 800 are actually managed, is an inventory nobody maintains. Start small. It is easier to add later than to clean up a bloated inventory. ## What goes on a record, in order of importance 1. **Code and identification.** Without this, there is nothing. 2. **Exact location:** site, floor and room. It is the first thing the technician needs. 3. **Family or type.** It lets you group, compare and apply task lists. 4. **Customer who owns it**, if you service third-party equipment. 5. **Technical data:** make, model, serial number, installation date and warranty. 6. **[Criticality](https://attendo.me/en/glossary/asset-criticality).** The first four are essential. The rest can be filled in as you go. A photo of the nameplate, taken while walking past, covers item 5 in two seconds. ## Coding: one afternoon that saves years A convention like `CUSTOMER-BUILDING-TYPE-NUMBER`: ``` CUS-BLD3-HVAC-014 ELV-TWR2-LIFT-007 FRG-PLT1-CMP-002 ``` The technician knows where the asset is without opening anything. The list sorts itself by customer and building, and you can search by segments. **Rules:** fixed length, no special characters, no spaces, and never reuse the code of a retired asset. ## How to build it in practice **What usually does not work:** sending someone to walk every site for three weeks with a tablet. It gets tedious, it gets dropped and it stays half done. **What works:** 1. **Start with what you already have:** an imperfect spreadsheet, the contract list, the installation invoices. Import it even if it is messy. 2. **Clean up duplicates and retired assets during the import.** This is where the surprises show up: the same asset under two names, and equipment that was removed years ago. 3. **Fill in the gaps as you go.** Every time a technician visits an asset, they complete what is missing. Within a few months the inventory is up to date without full days spent on it. 4. **Put QR labels on the equipment you touch often.** You do not need to label everything on day one. ## The three mistakes that kill it **1. Not retiring assets.** Ghost equipment generates impossible preventive work and drags compliance down. Retiring is not deleting: it means marking the asset as retired and keeping its history. **2. Creating duplicates.** Two records for the same asset split its history in two, and neither is useful. Searching before creating has to be a habit. And search must find assets by partial code and by name. **3. Asking for fields nobody fills in.** If you have defined 40 fields and 6 get filled in, remove the other 34. A long form is the most reliable way to make sure no record gets created. ## How to tell it is alive - Last month’s work orders point to records that exist, not to “miscellaneous” or “other.” - New equipment is added the week it is installed. - This year’s retirements are marked as retired, with their history. A living inventory with 800 assets is worth more than a complete, dead one with 12,000. What keeps it alive is not discipline: it is making updates easier than skipping them. Last updated: September 27, 2026 Downloadable guide · Template Preventive maintenance plan template A template to print or copy into your spreadsheet: task tables by asset family, how to prioritize with the hours you actually have and how to measure whether the plan is being met. Every interval is marked as an example. [Download the free guide](https://attendo.me/en/guides/preventive-maintenance-plan-template) ## How attendo handles it In attendo, the inventory is imported from Excel or CSV with visual field mapping and a report on which row fails. Each asset belongs to its customer and its site, carries its QR codes and keeps its history. Anyone standing in front of the equipment can report a problem from the QR code, without a user account. - [Assets and inventory](https://attendo.me/en/modules/assets) - [attendo Forms](https://attendo.me/en/modules/forms) - [attendo CMMS](https://attendo.me/en/cmms) ## More on maintenance ### How to build a preventive maintenance plan that actually gets done The hard part of preventive maintenance is not designing the plan. It is keeping it alive past the first few months. When a plan is abandoned, it is rarely for lack of will. It was usually sized wrong from day one. 5 min read Choosing and rolling out software ### 40 questions to ask before you buy a CMMS Take this list to every demo. It works with any maintenance software vendor: buyers who ask good questions end up with the right software. And it is better to find out before you sign than three months later. 4 min read ### How to calculate MTBF and MTTR without fooling yourself Both formulas fit on one line. The hard part is making the number mean something. Here are the formulas, a complete example and the three mistakes that turn these KPIs into decoration. 4 min read [All blog articles](https://attendo.me/en/blog) ## Shall we look at it with your operation? Tell us how you work today and we will show you attendo with your own data. If it is not a fit, we will say so. - With your operation, not a generic demo - A real person from our team replies - No cold calls afterwards Would you rather talk first? - Phone [+34 910 053 530](tel:+34910053530) - Email [sales@attendo.me](mailto:sales@attendo.me) - Monday to Thursday 9:30 AM to 6:30 PM and Friday 9:30 AM to 2:30 PM (Spain time)