How to Do a Physical Asset Inventory: A Step-by-Step Checklist

Confessions of a guy who found a $4,000 projector in a coat closet

I'll be honest with you: I put off my first physical inventory for eight months. Eight. Every week I'd tell myself "next week for sure" and every week something more urgent would come up. A broken printer. A new hire that needed a laptop. The CEO asking for "a quick summary" of our IT assets (I made one up. Don't judge me. Okay, judge me a little).

When I finally did it - cleared a Friday, printed my spreadsheet, and walked through the entire office with a clipboard - I found things I did not expect. A projector worth about $4,000 sitting in a coat closet behind someone's umbrella. Three laptops assigned to people who had left the company months ago. Two monitors that weren't in our system at all - nobody knew where they came from. And a label maker. I still don't know who bought the label maker. It remains a mystery.

The whole thing took one day. One painful, eye-opening, slightly embarrassing day. And it was the single most valuable thing I ever did for our asset management.

If you've been putting this off (and I know you have, because everyone does), this physical asset inventory checklist is your push. I'll walk you through the entire fixed asset inventory process - from "I have no idea what we own" to a clean, reconciled Asset Register. If you've already set up a spreadsheet system using the main asset tracking guide, even better - this is how you fill it with real data instead of best guesses.

Why You're Probably Overdue for a Physical Inventory

Let me ask you three questions. Be honest.

1. If your boss asked right now "how many laptops do we have?" - could you answer within 30 seconds? Not "about 40-ish." An actual number.
2. Have you bought something in the last year "just in case" because you couldn't find the one you already had? That second power strip. That third external webcam. That emergency monitor purchase because "we don't have any spares" (you did - it was in the storage room behind the old coffee maker).
3. Has someone left the company in the last 12 months, and you're not 100% sure all their equipment came back?

If you answered yes to any of these - and statistically, you answered yes to at least two - you need to do a physical inventory count. Not next quarter. Not when things calm down. Now. Because every day you wait, your records drift further from reality.

Here's what that drift costs you in real money. Companies with inaccurate asset records overpay on insurance premiums (you're insuring ghost assets - things that don't exist anymore). They overpay on property taxes (same reason - depreciation on phantom equipment). They make duplicate purchases. And they waste dozens of hours searching for things that are "somewhere around here."

The average first-time asset audit uncovers 5–15% discrepancies. For a company with 200 fixed assets worth $300,000, even a conservative 8% discrepancy rate means $24,000 worth of stuff that's either missing, misplaced, or misrecorded. That's not a rounding error. That's a problem.

Before You Start: The Preparation Checklist

Jumping straight into counting is tempting. Don't. An hour of preparation saves three hours of confusion and re-counting. I learned this the hard way when my first inventory attempt turned into a chaotic mess because I hadn't unlocked the storage room, half the team had equipment at home, and I didn't have a consistent way to record what I found.

Here's the prep checklist I use now.

Define Your Scope

You don't have to count everything on Earth in one go. In fact, for your first inventory, I'd recommend you don't.

Options for scope:

• One department - Start with IT equipment only, or just the marketing floor
• One location - The main office, ignoring the warehouse for now
• One category - All laptops and monitors, regardless of department
• Everything - Full sweep. Only if you have time and a team. Or a really boring weekend.

My recommendation for first-timers: pick one floor or one department. Get the process right on a small scale, then expand. Trying to inventory three offices and a warehouse on your first attempt is a recipe for burnout and incomplete data.

Set a value threshold. In the main guide, I suggested $100 as a minimum for tracked assets. Same applies here. You're counting laptops, monitors, printers, and furniture - not staplers and USB cables. Life is too short to inventory staplers.

Prepare Your Count Sheet

You need something to write on. Sounds obvious, but the format matters.

If you already have an Asset Register: Export it. Print it or load it on a tablet. You'll walk through the space and check off assets you find against the list. Anything not on the list = a surprise (we'll deal with those). Anything on the list that you can't find = a problem (we'll deal with those too).

If you don't have an Asset Register yet: Create a blank count sheet - essentially a physical inventory count template. This is what you'll fill in as you discover things. The count sheet eventually becomes your Asset Register - or at least the raw data for it.

Minimum columns for your count sheet:

A: Location (Room / Area)
B: Description (what is it)
C: Manufacturer / Brand
D: Model
E: Serial Number
F: Asset ID (if labeled)
G: Category (IT / Furniture / AV / etc.)
H: Condition (Excellent / Good / Fair / Poor / Damaged)
I: Assigned To (who uses it, if obvious)
J: Counted By (your name)
K: Notes (anything weird or notable)

Print multiple copies. Or - better - use Google Sheets on your phone so everything goes straight into the cloud. Both work. Paper is actually faster for raw counting; digital is better for reconciliation later. Personally, I do both: I jot quick notes on paper during the walk-through and enter the data into Sheets at the end of each room.

Prepare Your Space

This is the part that feels unnecessary until you're standing in front of a locked storage room at 10 AM with nobody around who has the key.

The "open sesame" checklist:

• Get keys / access to ALL rooms, closets, cabinets, and storage areas
• Ask building management to unlock any restricted areas you need
• Notify security if you'll be poking around after hours

The "bring it back" request:

• Check your equipment checkout system - what's currently borrowed?
• Ask employees to return shared equipment the day before, or document what's at their desk
• For remote employees - run a separate verification process (physical inventory doesn't work when the asset is in someone's apartment in Portland)

The "don't count it twice" system:

• Get a sheet of small stickers or colored dots
• After counting an asset, stick a dot on it
• Sounds silly. Works perfectly. Without markers, you will absolutely count that printer twice and miss the one in the corner.

Assemble Your Team

How many people do you need? Depends on how much stuff you have.

Critical rule: never let someone inventory their own department. I know it seems logical - "Sarah knows the marketing floor best." That's exactly the problem. Sarah knows where everything should be, so she'll assume it's there instead of actually looking. Cross-department counting eliminates confirmation bias and catches things insiders overlook.

If you're doing this solo (which, let's be real, most people running asset inventory for a small business are), that's fine. Just give yourself enough time and don't try to do it while also answering emails and attending meetings. Block the day. Put your headphones in. Tell people you're busy. You are.

Choose Your Tools

Minimum (budget = $0):

• Printed count sheet
• A pen (bring a backup - pens are the original ghost asset)
• Your eyeballs

Better (budget = your existing phone):

• Google Sheets on your phone or tablet
• Phone camera for serial number photos
• A friend to hold the flashlight under desks

Even better (budget = still $0 but with planning):

• Phone with QR code scanner app (if your assets are already labeled)
• Google Sheets for live entry
• QR code labels on each asset from the tagging process

Ideal (when you're ready to level up):

• UNIO24 mobile app - scan, verify, flag discrepancies in real time
• But we're here for the spreadsheet version, so let's keep going

The Count: Step by Step

Alright. You've prepped. You've got your count sheet, your stickers, your comfortable shoes (seriously - you're going to walk a lot). Let's do this.

Step 1 - The Room-by-Room Walkthrough

Start at the entrance of the first room. Move clockwise. Don't skip around randomly - systematic movement means you won't miss corners.

Count everything above your threshold. Even if you're "pretty sure" it's in the system. Even if it looks old and probably doesn't work. Even the server rack that nobody's touched in two years. If it has value and belongs to the company, it gets counted.

Record the physical location, not the "supposed" location. If your spreadsheet says the projector is in Conference Room A but you find it in Conference Room B, write down Conference Room B. The whole point of this exercise is reality, not what the records say.

Places people forget to check:

• Under desks (cables, docking stations, UPS units)
• Inside cabinets and drawers (tablets, spare mice, those keyboards from 2019)
• On top of high shelves (storage bins, old monitors)
• Server rooms / network closets (switches, routers, access points)
• Break rooms and kitchens (yes - company TVs, microwaves above threshold)
• Behind doors (coat closets are a classic hiding spot - ask my $4,000 projector)
• Reception desks (monitors, phones, printers that "just appeared")
• Personal offices with closed doors (knock first. be polite. bring coffee.)

Step 2 - Recording Each Asset

For each asset you find, capture:

1. Location - Be specific. Not "2nd floor" but "Room 204, left wall, desk 3." Future-you will be grateful when trying to find this thing again.
2. Description - "Dell monitor" is fine. "Monitor" alone is not.
3. Serial number - This is the most important identifier. It's usually on the back or bottom of the device. Yes, you'll need to pick things up and flip them over. Yes, your knees will hurt by 3 PM. Welcome to inventory.
4. Asset ID - If there's a label (QR code, barcode, sticker with AST-001), record it. If there's no label, leave this blank. You'll add labels after the count.
5. Condition - Quick visual assessment. Excellent, Good, Fair, Poor, or Damaged. Don't overthink it. "Screen has a crack" = Damaged. "Works fine, looks a bit worn" = Fair.
6. Photo - Snap a photo of the serial number plate with your phone. This is insurance against typos and unreadable handwriting. I once spent 20 minutes trying to figure out if I'd written "S" or "5" in a serial number. Never again.

Speed tip: If you have a partner, one person reads data while the other records. It's literally twice as fast and way less boring.

Another speed tip: For serial numbers, don't type them. Just take a photo. You can transcribe later. During the count, speed matters more than perfection.

Step 3 - The "Found vs. Expected" Tracking

If you started with an existing Asset Register, you're now doing a comparison in real time. As you find each asset, mark it as "Found" in your spreadsheet.

Add a column called "Found" (TRUE/FALSE or checkbox) next to each asset in your exported register. As you locate items, check them off.

Progress tracking formula:

=COUNTIF(Found_Column, TRUE) / COUNTA(Asset_ID_Column)

This gives you a real-time percentage. "We've verified 67% of registered assets." Feels good. Motivating. Until you get to 90% and the last 10% are nowhere to be found. That part feels less good. But that's exactly what this process is for.

At the end of the count, anything without a checkmark = potentially missing.

Step 4 - The Uncomfortable Discoveries

Your first physical inventory will turn up surprises. Guaranteed. Here's what to expect:

Ghost assets 👻 - Items in your system that don't physically exist. The laptop that was "definitely in the storage room" isn't there. The monitor that's "assigned to desk 14" - desk 14 has a different monitor, or no monitor at all. Discovering ghost assets during inventory is the most common and most expensive finding - you've been depreciating, insuring, and accounting for things that aren't real.

Zombie assets 🧟 - The opposite problem. Physical items that aren't in your system at all. Someone bought a keyboard on Amazon and expensed it. Someone brought in a personal monitor and left it when they quit. A piece of equipment arrived from a vendor and went straight to a desk without anyone logging it. Zombies are surprisingly common. In my first inventory, I found 14 items that weren't in any record. Fourteen.

Wrong location 📍 - The asset exists and it's in the system, but it's not where the system says it is. Conference Room B projector is actually in Conference Room A. The "Warehouse" laptop is on someone's desk in Marketing. This is the most forgivable discrepancy - stuff moves - but it still needs fixing.

Wrong assignee 👤 - "This laptop is assigned to Mike." "Mike left six months ago. I've been using it since then." Nobody updated the record. Mike's ghost haunts your Asset Register.

Condition surprises 😬 - The system says "Excellent." Reality says "the screen has a mysterious crack and three keys are missing." Someone should have reported this. Nobody did. That's why we do physical counts.

Don't panic when you find all of this. Every company's first inventory is messy. The whole point is to establish a real baseline - an honest snapshot of what you actually have, where it actually is, and what shape it's actually in. The mess is temporary. The accuracy you gain is permanent (well, until it drifts again - but we'll handle that).

After the Count: Asset Reconciliation in Your Spreadsheet

The count is done. You've walked miles. Your phone is full of serial number photos. Your count sheet has data that ranges from meticulously detailed to "laptop, desk, ok" (it happens at 4 PM - energy fades). Now comes the part that turns raw data into a clean Asset Register. Building an asset reconciliation spreadsheet is where the real value of your count comes together.

Do this the same day or the next morning while your memory is fresh. Do NOT wait until next week. I tried that once. Couldn't remember what half my scribbled notes meant.

Building the Reconciliation Sheet

Create a new sheet in your workbook called "Reconciliation." Import your physical count data and your system records side by side.

Structure:

A: Asset ID (from system)
B: System Location
C: Physical Location (from count)
D: System Status
E: Physical Status
F: System Assignee
G: Physical Assignee
H: Found? (TRUE/FALSE)
I: Match Status (formula)
J: Action Required

Auto-comparison formula (Column I):

=IF(H2=FALSE, "❌ MISSING",
  IF(AND(B2=C2, F2=G2), "✅ Match",
    IF(B2<>C2, "⚠️ Wrong Location",
      IF(F2<>G2, "⚠️ Wrong Assignee", "✅ Match"))))

Conditional formatting: Red for "MISSING", yellow for "Wrong Location" or "Wrong Assignee", green for "Match." Now your reconciliation sheet is a traffic light. The red rows are your top priority.

Handling Each Type of Discrepancy

Missing (ghost asset):

1. Don't immediately delete it from the register. Mark the status as "Missing - Under Investigation"
2. Ask around. Check with the last known assignee. Check storage areas you might have missed
3. Give it two weeks of investigation
4. If still not found: change status to "Lost" → update depreciation records → adjust insurance
5. Value of missing asset goes into your discrepancy report

Found but not in system (zombie):

1. Add it to the Asset Register with all available details
2. Assign a new Asset ID (follow your numbering scheme: AST-047, AST-048...)
3. Print a label and stick it on the asset immediately - if you don't label it now, you'll forget
4. Try to find the purchase record for accounting (check old invoices, credit card statements)
5. If you can't find purchase data - estimate. Something is better than nothing

Wrong location:

1. Update the location in the Asset Register. That's it. Simple fix.
2. Ask yourself: why did it move? If assets move frequently, your location tracking process needs work

Wrong assignee:

1. Update the assignee in the register
2. Notify both the old and new assignee - not as blame, just as documentation
3. If the old assignee left the company → this was an offboarding gap. Fix that process

Condition mismatch:

1. Update the condition in the register
2. If Poor or Damaged: create an entry in the Maintenance Log (from the main guide)
3. Consider whether the asset should be retired or repaired

The Numbers That Matter

After reconciliation, calculate these metrics. They're your inventory scorecard.

Discrepancy Rate:

=COUNTIF(Match_Column, "<>✅ Match") / COUNTA(Asset_ID_Column)

Ghost Asset Rate:

=COUNTIF(Match_Column, "❌ MISSING") / COUNTA(Asset_ID_Column)

Zombie Count (found but unregistered):

=COUNTA(New_Assets_Added)

Total Value of Missing Assets:

=SUMIFS(Value_Column, Match_Column, "❌ MISSING")

Benchmarks:

Don't be discouraged by a high first-time rate. The whole point is to find and fix these issues. It gets much better from the second count onward. My first inventory had a 12% discrepancy rate. Six months later, after implementing proper processes, the next one came in at 3.4%. That's the power of actually doing this.

Turning Your Count Into a Living System

A one-time inventory is useful. A repeating inventory process is transformative. Here's how to make sure your hard work doesn't go stale.

Populating Your Asset Register

If this was your first ever inventory and you didn't have an Asset Register before - congratulations, your count sheet just became one. But it needs some work to become a proper register.

Add the columns that aren't on a count sheet:

• Purchase Date (get from accounting / invoices)
• Purchase Cost (same source)
• Useful Life in years (for depreciation)
• Current Value (calculated - see the main guide for the depreciation formula)
• Warranty Expiration
• Department

Assign Asset IDs to everything that doesn't have one. Use a simple format: AST-001, AST-002, and so on. Don't overthink it. Consistency matters more than cleverness.

Label Everything You Found

This is non-negotiable. An asset without a label will get lost again. It's like naming your cat - if it doesn't have a name, nobody takes responsibility for it.

Print labels with the Asset ID and - if you're feeling ambitious - a QR code that links to the asset record. Stick them on every single asset you counted. Standardize placement: laptops get labels on the bottom cover, monitors on the back right corner, furniture inside a drawer or on the underside.

For details on asset tagging - materials, placement, QR code encoding - check the pillar article section on labels and QR codes.

Schedule the Next One

A physical inventory is like a dental cleaning. Unpleasant, necessary, and way worse if you skip it for three years.

Recommended cadence:

For most small businesses, the sweet spot is: one full inventory per year + monthly spot checks. The annual count is your reset button. The monthly spot checks keep drift under control between resets.

If you want to eliminate the annual full count entirely, switch to cycle counting - count a few assets every day on a rotating schedule. Over a quarter or a year, every asset gets verified at least once, and you never have to shut down for a Big Count Day. It's the grown-up version of physical inventory.

Common Mistakes (The Hall of Shame)

I've committed every single one of these. Consider this my public confession.

❌ Counting from memory. "I know there are three laptops on that desk, I was there yesterday." Go. Look. Count. Physically. The whole point of a physical inventory is that it's physical. Memory is not a data source.

❌ Not opening cabinets, closets, and drawers. Equipment loves to hide. It migrates into cabinets like socks migrate into the space behind the dryer. Open everything. Look behind things. Check the top shelves. I found a tablet in a file cabinet once. A file cabinet. It had been "missing" for four months.

❌ Inventorying your own department. When you see your own workspace every day, you develop blind spots. "Oh, that old monitor? That's always been there." Has it? Is it in the system? Do you know its serial number? Cross-department counting removes the familiarity bias. Fresh eyes catch what familiar eyes miss.

❌ Counting and correcting at the same time. "Oh, this laptop is in the wrong place, let me move it to the right desk and update the record." No. Count first. Record reality. Fix things after. If you start correcting during the count, you'll lose track of what was actually wrong versus what you already fixed. Count the mess, then clean it up.

❌ Not photographing serial numbers. "I'll just write it down, it's fine." It's not fine. You'll transpose digits. You'll mistake 0 for O and 1 for l. Your handwriting at 4 PM will be illegible by 5 PM. Take the photo. It's three seconds per asset and saves hours of "wait, is this 5N7KR2 or SN7KR2?"

❌ Postponing reconciliation. "I'll enter all this data next week." You won't. Or you will, but you'll have forgotten why you wrote "weird - check Dave" in the notes column. Reconcile the same day. While the memories are fresh and your handwriting still looks like words.

❌ Doing one inventory and calling it done. A single inventory is a snapshot. Snapshots go stale. Without an ongoing process - spot checks, cycle counts, scheduled audits - your beautiful, reconciled data will drift back toward chaos within 6–12 months. Ask me how I know. (See: the first paragraph of this article where I admitted to making up asset numbers for the CEO. That was post-first-inventory. The drift is real.)

For more cautionary tales, check out 10 Asset Management Mistakes That Cost Companies Thousands. I contributed to several of those personally.

When a Spreadsheet Isn't Enough

Everything in this guide works beautifully for a company with under 500 assets. Walk around, count stuff, enter data, reconcile. Done.

But there's a point where the spreadsheet approach starts cracking:

• You have 500+ assets across multiple locations - reconciliation in a spreadsheet becomes a full-time headache
• You need real-time scan-and-match - scan a QR code, see if it matches the system, flag discrepancies instantly. Spreadsheets can't do that on the floor
• You need timestamped audit trails - who counted what, when, and what they found. Spreadsheet edit history is not an audit trail
• Multiple people counting simultaneously - Google Sheets handles this okay-ish, but merge conflicts are real
• You want to track accuracy trends - historical audit data, discrepancy rates over time, improvement tracking

If you're nodding to three or more of these, read Excel vs Asset Management Software: When to Switch.

My recommendation: UNIO24. Mobile QR scanning, instant reconciliation, automatic discrepancy flagging, full audit history, and it works from your phone. Walk through the office, scan assets, and the system tells you what matches, what's missing, and what's new - in real time. The free tier handles everything a small team needs. You can migrate from your spreadsheet in an afternoon.

Wrapping Up

A physical asset inventory isn't glamorous work. You'll walk a lot, flip over a lot of equipment, and discover a lot of uncomfortable truths about your record-keeping. But here's the thing - that one day of honest counting does more for your asset management than six months of optimistic spreadsheet maintenance.

Your first inventory is not an audit. It's a baseline. A starting point. The moment you go from "I think we have about 150 assets" to "we have exactly 163 assets worth $247,000, of which 7 are unaccounted for and 12 need labeling." The second version is the one that lets you make real decisions.

Your minimum viable physical inventory:

1. Prepare - scope, count sheet, keys, stickers, comfortable shoes
2. Count - room by room, clockwise, check everything, photograph serial numbers
3. Reconcile - system vs. reality, flag discrepancies, investigate the red rows
4. Update - fix the register, label unlabeled assets, schedule the next count

Four steps. One day. And from that day forward, you'll actually know what you have.

Which is way better than finding out you don't have it when the CEO asks.