• Assets and equipment · EAM
• Accounting / Analytics, Operations Manager, Team Leader / Supervisor, Quality / Audit
• Manufacturing, Retail and branch networks, Services and offices, Logistics and warehousing, Public sector

Asset inventory template (Excel): columns, count sheet and how to use it

5 min read · Remanently team

In short

An asset inventory template is a table listing each asset with its ID, description, location, responsible person and condition, plus a count sheet where the counter records what was found. There is no single official form, so choose the columns that match your assets and keep them identical from year to year. Fill in the register first, count against it and note every difference with a reason. Excel works for a small number of assets; once moves happen weekly, the sheet starts to fall behind.

What an asset inventory template contains

An asset inventory is a list of what the company owns, checked against what is physically there. The template has two parts. The first is the register itself: one row per asset. The second is the count sheet: a copy of the list that people carry through each room or site and mark up.

There is no single official form for an internal asset count. Pick the columns you need and keep them stable. If an auditor or your accountant requires specific fields, add them. The layout below is a practical starting point.

Columns that matter

• Asset ID. A unique number, never reused. This is the one column you cannot do without.
• Description. What it is, with make and model where relevant.
• Serial number. Helps when a label is missing.
• Category. Computers, machines, furniture, vehicles, tools.
• Location. Site, building, room. Use the same names everywhere.
• Responsible person. A named owner, not a department.
• Condition. Working, damaged, unused.
• Found: yes or no, count date, counter. Filled in during the count.
• Remarks. Free text for exceptions.

Count sheet to print

Print template

How to fill it in

1. Freeze the list. Export the register on a fixed date and give each room or zone its own sheet. Everyone counts from the same version.
2. Check IDs before counting. Duplicates and blank IDs cause most of the trouble later. Fix them first.
3. Count in a fixed order. One room at a time, left to right, so nothing is skipped.
4. Mark each line. Write Y if the asset is there and matches. Write N if it is not. Never leave a line blank.
5. Record extras. Items in the room that are not on the list go to the bottom section, with a photo of the item and its label if there is one.
6. Note condition. Damaged or unused equipment is information the register does not have yet.
7. Sign and return the sheet the same day, so the registered location is still fresh.

Common mistakes

• Counting from a list that was changed during the count, so no two sheets agree.
• Marking an item as found because the label is on the desk, when the asset itself is missing.
• Giving no instruction for assets held by employees at home or on the road.
• Forgetting that items in service or lent to a supplier are not lost.
• Treating N as a final result. It means not found yet. Someone must check documents and moves before it becomes a shortage.

Layout tips for the Excel file

• Keep one row per asset and no merged cells, so you can sort and filter.
• Use drop-down lists for location, category, condition and found status. Free text produces five spellings of the same room.
• Lock the ID column and protect the header row.
• Add a column for count date and a column for the counter, so each line carries its own evidence.
• Save one file per count and never overwrite last year's. The old file is your baseline for comparison.
• Keep a separate tab for extras: items found that are not on the list.

With these rules, a spreadsheet gives you a usable count for a small number of assets in one place. Without them, two people editing two copies will give you two different answers by the end of the day.

After the count: closing the sheet

A filled sheet is not the end. Collect all sheets, enter the results in the master file and list every N and every extra on one tab. Give each line an owner and a due date. Then correct the register and save the file under the count date. If a line is still open a week later, someone should be chasing it. The sheet is evidence of what was seen on one day. The register must be changed for that evidence to matter.

When Excel stops being enough

A spreadsheet is fine for a few hundred assets in one place. It starts to hurt when the list is retyped after every count, when several people edit copies and when moves between sites happen between counts and go unrecorded. The template tells you what happened on the count day. It cannot tell you what happened in the eleven months before.

In Remanently Assets the same logic runs on a phone: you scan or confirm each asset, the result is compared with the register and the differences appear as a list with exceptions instead of a manual comparison. Labels can be your existing numbers, barcodes, QR codes or UHF RFID, and changes of location or user are kept as history. See asset management software for how to choose a tool, and the fixed asset register template if your register still needs to be built. For a count plan, see how to run a physical asset inventory and the 17-question checklist.

Frequently asked questions

Is there an official asset inventory form?

There is no single official form for an internal count. Most organizations design their own. Include the fields your accountant or auditor asks for and keep the layout the same each year.

What is the minimum I need in the register?

A unique asset ID, a description, a location and a responsible person. Serial number and condition make the count much easier.

What do I do with an item that is on the sheet but not found?

Mark it N, then check documents and recorded moves before calling it a shortage. Often it was transferred, lent out or sent for service without a record.

How do I handle items found that are not on the list?

Record them in the extras section with a description, serial number, location and photo. Then check the purchase records to decide whether to add them to the register.

Can Excel be enough for the whole process?

For a small number of assets in one place, yes. When assets move often or several sites are involved, a system that records moves and compares scans with the register saves a lot of retyping.

Run your next count on a phone, not on paper
Book a short demo and we will take a sample of your register through a test count, including differences and exceptions.

Book a short Remanently demo See pricing

Module: Remanently Asset Management (EAM) · Pricing · Contact · Get started