How to Track Equipment for Remote Employees Using Spreadsheets

Or what happens when your asset register says "Office A" but the laptop is actually on someone's kitchen table in Portland

In March 2020, like half the world, we sent everyone home. In about a week we handed out around 40 laptops, a dozen monitors, a bunch of keyboards, mice, headsets — basically anything that wasn't bolted to the floor. We had a spreadsheet. Sort of. More like a Google Doc with a table that someone started and nobody finished.

Six months later, I tried to figure out exactly where all that equipment was. I could confidently account for 28 out of 40 laptops. The rest were... somewhere. Probably. Two people had left the company by then. One of them "was sure" she'd returned everything. She hadn't. Another guy had moved to a different city and taken the monitor with him — not maliciously, he just forgot it wasn't his.

If this sounds painfully familiar, you're in the right place.

In the main asset tracking guide, I built an entire system around an office-centric workflow — assets live in known locations, people borrow them and bring them back. But remote work blew that model apart. When the asset's "location" is someone's apartment and the "return" process involves a FedEx box, you need a different approach.

This guide is that approach — a complete remote employee equipment tracking system built in a spreadsheet. We're going to adapt our spreadsheet system specifically for remote and hybrid teams. Same tools — Excel or Google Sheets — but with new fields, new workflows, and a few hard-earned lessons about what happens when you can't just walk over to someone's desk and say "hey, where's the projector?"

Why Remote Equipment Tracking Is a Different Beast

Let me be blunt: work from home equipment tracking is harder than tracking assets in an office. Not a little harder. A lot harder. And the reasons are annoyingly obvious once you think about them.

You lose visual control. In an office, you can literally see the laptops on desks. You walk by and think "yep, that one's there." With remote workers, you have zero visual confirmation. That laptop could be on their home desk, in a closet, at a repair shop, or sold on eBay. You don't know. You can't know — unless you build a system that tells you.

There's no central storage. Office equipment lives in a server room, a supply closet, or on a designated shelf. Remote equipment lives in 15 different apartments across 3 cities and maybe 2 countries. Each "storage location" has its own cat that likes to sit on keyboards.

Onboarding means shipping. When a new hire starts in the office, you hand them a laptop. Done. When a remote hire starts, you need to order the equipment, ship it to their address (which you need to verify), track the shipment, confirm delivery, and get them to sign an equipment agreement. That's five steps instead of one.

Offboarding means... hoping. When someone leaves an office job, they turn in their badge and laptop on the last day. When a remote employee quits, you send a prepaid shipping label and cross your fingers. Some people are great about it. Others... aren't. And by the time you realize the equipment never came back, the person is long gone.

The ghost asset problem multiplies. A ghost asset is equipment your records say you have, but you actually don't. In an office, ghost assets are annoying. With remote teams, they're endemic. Equipment disappears into the void of "someone's home" and stays there, still on your books, still depreciating, still technically "assigned" to someone who left the company eight months ago.

Here's a number that should scare you: according to industry research, 47% of former employees still have access to passwords from their previous jobs. If they're not returning passwords, what makes you think they're returning equipment?

Adapting Your Asset Register for Remote Teams

If you've already built an Asset Register following the main guide, good news — you don't need to start over. You need to extend it. Think of it as adding a remote-work wing to your existing building.

New Fields You'll Need

Add these columns to your existing Asset Register:

That's eight new columns. I know, I know — I just told you in the equipment checkout system guide that fewer columns is better. And that's true for a check-out log where speed matters. But the Asset Register is your source of truth. It's the one place where completeness wins over brevity.

Work Model is the most important new field. It lets you filter your entire register to see only remote assets, only office assets, or only hybrid — making hybrid employee equipment management much easier. When you need to answer "how much equipment do we have floating around in people's homes?" — that's a one-filter answer.

Tracking Equipment by Employee (The Bundle View)

Here's something I wish I'd done from day one: think in terms of equipment bundles, not individual assets. A remote employee doesn't just get "a laptop." They get a laptop, a monitor, a keyboard, a mouse, and a headset. That's a bundle. And you need to see the whole bundle at a glance.

Standard bundles by role:

This isn't just nice-to-have. It changes how you think about onboarding and offboarding. You stop thinking "we need to get a laptop to Sarah" and start thinking "we need to deploy a Designer bundle to Sarah." And when Sarah leaves, you're not checking "did we get the laptop back?" — you're checking "did we recover the full $3,800 bundle?"

Formula for total equipment value per employee:

=SUMIFS('Asset Register'!Cost_Column, 'Asset Register'!Employee_Column, "Sarah Johnson", 'Asset Register'!Status_Column, "<>Retired")

Add this to a Dashboard section and you'll see exactly how much company equipment is sitting in each person's home. It's a number that tends to make CFOs sit up straight.

The Remote Onboarding Equipment Workflow

In an office, onboarding is a five-minute handoff. In the remote world, it's a multi-step logistics operation. And if you don't track it properly, things fall through the cracks on day one — which is exactly when you want everything to go smoothly.

Step 1 — Define What They're Getting

Before a new hire's start date, figure out their equipment bundle based on role. Sounds obvious, but you'd be surprised how many companies wing this. "We'll figure out what they need after they start" is a recipe for a new employee sitting at home with nothing to work on.

Create an Onboarding sheet (or section) in your workbook:

A1: Employee Name
B1: Role
C1: Bundle Type
D1: Start Date
E1: Item 1 — Asset ID
F1: Item 1 — Shipped?
G1: Item 2 — Asset ID
H1: Item 2 — Shipped?
...
Q1: All Shipped?
R1: Tracking Number
S1: Delivery Confirmed?
T1: Agreement Signed?
U1: Onboarding Complete?

Yeah, it's a wide sheet. But every column matters. Miss one step and your new developer starts Monday without a monitor. Ask me how I know.

Step 2 — The "All Shipped?" Auto-Check

Instead of manually checking if all items have been sent, let the spreadsheet do it:

=IF(AND(F2=TRUE, H2=TRUE, J2=TRUE, L2=TRUE, N2=TRUE), "✅ Yes", "❌ Not yet")

Adjust the cell references based on how many items are in the bundle. This gives you a single green/red indicator per employee. During the crazy week before a batch of new hires starts, this column is your lifeline.

Step 3 — Track Shipping Like You Mean It

Add the tracking number to your Onboarding sheet and to the Asset Register (yes, both — the Onboarding sheet is a workflow tracker, the Register is permanent record).

Days since shipped without delivery confirmation:

=IF(AND(S2<>TRUE, R2<>""), TODAY()-P2, "")

Where P2 is the ship date and S2 is delivery confirmation. If this number goes above 5, something's wrong. Either the package is lost, or the employee received it and forgot to confirm. Both are problems worth chasing.

Pro tip: In the Asset Register, set the status to "In Transit" between ship date and delivery confirmation:

=IF(AND(Ship_Date<>"", Delivery_Confirmed<>TRUE), "In Transit",
  IF(AND(Delivery_Confirmed=TRUE, Status<>"Retired"), "In Use (Remote)", Status))

Now your Dashboard can show you exactly how many assets are currently bouncing around in FedEx trucks. During big hiring pushes, this number gets surprisingly large.

Step 4 — Get the Equipment Agreement Signed

This one is boring but essential. An employee equipment agreement is a document that says "these are company assets, you're responsible for them, and you'll return them when asked." Without it, you have zero legal leverage if someone decides to keep the MacBook Pro.

I'm not a lawyer and this isn't legal advice, but in my experience, a simple employee equipment agreement template that covers these points does the job:

• List of equipment being provided (with serial numbers)
• Employee's responsibility for reasonable care
• Obligation to return everything upon separation
• Company's right to deduct replacement cost from final paycheck (where legally permitted)
• Condition expectations (don't use the company laptop as a cutting board)

Track the signed/unsigned status in your spreadsheet. A formula on the Dashboard:

=COUNTIFS('Asset Register'!Work_Model, "Remote", 'Asset Register'!Agreement_Signed, "<>Y")

If this number isn't zero, go chase those signatures. Seriously. You'll thank me when someone quits without returning their stuff.

The Offboarding Nightmare (and How to Survive It)

Remote employee offboarding equipment return is the part of this job that keeps me up at night. I call it a nightmare because I've lived it. Multiple times. An employee gives two weeks' notice (if you're lucky — sometimes it's two days) and suddenly you're scrambling to figure out what equipment they have, where they are, and how to get it all back before they disappear.

The Offboarding Equipment Recovery Checklist

First, pull up everything assigned to the departing employee. If you've connected your Check-Out Log and Asset Register properly (see the equipment checkout system guide), this is a one-formula operation:

=FILTER('Asset Register'!A:P,
  'Asset Register'!Employee_Column="Departing Person",
  'Asset Register'!Status_Column<>"Retired")

This gives you the complete list of active assets assigned to that person. Print it. Email it to them. Make it very clear: "These items need to come back."

Then create (or use) an Offboarding sheet:

The Timeline That Works

Here's the offboarding timeline I've landed on after way too many trials:

Day T-14 (two weeks before last day): Send the employee a list of all equipment they need to return. Include photos if possible — "this is the monitor model you received." People genuinely forget what they got, especially if they've been remote for two years.

Day T-7 (one week before): Send prepaid shipping labels. FedEx or UPS, whatever's cheapest for the route. Include packing instructions. Yes, you need to tell people to bubble-wrap a monitor. Trust me.

Day T-1 (last day): Confirm that the package has been dropped off. Ask for a photo of the shipping receipt. Update your Offboarding sheet with the tracking number.

Day T+3 (three days after): Package should arrive. Inspect everything. Update condition. Close out the records in Asset Register — change the employee assignment to blank, update the status.

Day T+7: If the package hasn't arrived and there's no tracking activity... it's escalation time.

When Equipment Doesn't Come Back

Let's be realistic. Sometimes equipment doesn't come back. The person ghosts you. The package gets lost. They "shipped it" but have no receipt. Knowing how to recover equipment from remote employees is a skill you'll develop over time.

Here's my escalation ladder:

1. Friendly reminder email — "Hey, we haven't received your equipment yet. Here's a new shipping label just in case."
2. HR involvement — HR sends a formal notice referencing the equipment agreement.
3. Final paycheck hold — Where legally permitted, withhold the equipment value from the final paycheck. (Check your state/country laws first — this isn't legal everywhere.)
4. Write it off — Sometimes a $300 keyboard and mouse just aren't worth the legal fight. I hate saying this, but it's true. Pick your battles. Chase the $2,500 MacBook. Let the mouse go.

Track all of this in a formula:

=IF(AND(Last_Day < TODAY()-14, Received<>TRUE),
  "⚠ OVERDUE — Escalate", "")

The Ghost Asset Sweep

Every quarter, run this check:

=FILTER('Asset Register'!A:P,
  ('Asset Register'!Employee_Column<>""),
  ('Asset Register'!Status_Column="In Use (Remote)"),
  (ISNA(MATCH('Asset Register'!Employee_Column, Active_Employees_List, 0))))

Translation: find all assets that are assigned to someone who is no longer on the active employee list. These are your ghost assets — equipment your records say is "in use" by someone who doesn't work here anymore. It's depressingly common. The first time I ran this check, I found 11 assets assigned to 4 former employees. Eleven. One of them had left nine months earlier.

Remote Equipment Verification (The "Prove You Still Have It" Check)

In an office, verification is easy. Walk around. See the stuff. Done. For remote teams, you need a dedicated remote equipment verification process. I call it the quarterly proof-of-life check, and yes, I know that sounds dramatic. But after the Ghost Asset Incident of 2023 (see above), I don't apologize for being thorough.

The Google Form Approach

Create a Google Form that asks employees to verify their equipment. This is the simplest approach that actually works:

Form fields:

• Employee Name (dropdown)
• Asset ID (short answer — they'll find it on the label you stuck on the device... you did stick labels on everything, right?)
• "Do you still have this item?" (Yes / No / Not sure)
• Current condition (Excellent / Good / Fair / Poor)
• Photo of the asset (file upload — required)
• Photo of the serial number label (file upload — required)
• Notes ("The laptop fan is loud," "I need a replacement keyboard," etc.)

Why photos matter: Because "Yes, I still have it" without proof is just a checkbox. The photo of the serial number does double duty — it confirms possession and updates your serial number records if they've become outdated. Two verifications for the price of one.

Link responses to your spreadsheet:

Google Forms auto-creates a response sheet. Add a "Last Verified" column to your Asset Register and update it when responses come in:

=IFERROR(INDEX(Form_Responses!$A:$A,
  MATCH(A2, Form_Responses!$B:$B, 0)), "Never verified")

Dashboard Metrics for Remote Assets

Add a "Remote Equipment Health" section to your Dashboard:

Verified this quarter (%):

=COUNTIFS('Asset Register'!Work_Model, "Remote",
  'Asset Register'!Last_Verified, ">"&EOMONTH(TODAY(),-3)) /
COUNTIFS('Asset Register'!Work_Model, "Remote",
  'Asset Register'!Status, "<>Retired")

Total equipment value at employees' homes:

=SUMIFS('Asset Register'!Current_Value,
  'Asset Register'!Work_Model, "Remote",
  'Asset Register'!Status, "<>Retired")

Assets pending recovery (offboarding):

=COUNTIFS(Offboarding!Received, "<>TRUE", Offboarding!Last_Day, "<"&TODAY())

Employees with no verification (>90 days):

=COUNTIFS('Asset Register'!Work_Model, "Remote",
  'Asset Register'!Last_Verified, "<"&TODAY()-90,
  'Asset Register'!Status, "In Use (Remote)")

That last one is my favorite red flag indicator. If 30% of your remote assets haven't been verified in 90 days, your system is leaking. Time to send reminders. Or hire an intern with very strong emailing skills.

Security: The Stuff Nobody Wants to Talk About

I'm an asset tracking guy, not a security expert. But I'd be irresponsible not to mention this: a company laptop on someone's home WiFi is fundamentally different from a laptop on your corporate network. And your spreadsheet should at least acknowledge this reality.

What to Track (Security-Adjacent Fields)

Consider adding these columns to your Asset Register for remote assets:

• Encryption Enabled (Y/N) — Is the hard drive encrypted? If not, a lost laptop = a data breach.
• VPN Required (Y/N) — Does this device connect through VPN?
• MDM Enrolled (Y/N) — Is Mobile Device Management installed? (If your company uses it)
• Last OS Update — When was the operating system last updated? Stale updates = vulnerabilities.

These fields are typically filled in by IT, not by the employee. And honestly, for most small businesses, even tracking "Encryption Enabled" and "Last OS Update" puts you ahead of 80% of companies.

What NOT to Track in Your Spreadsheet

Never, ever, under any circumstances store these in a shared spreadsheet:

• Passwords or access tokens
• Employee home network details (WiFi passwords, router models)
• VPN credentials
• Any personally identifiable information beyond what's needed for shipping

Your spreadsheet is an asset tracking tool, not a security vault. If someone gets access to it — and in a shared environment, many people will — you don't want sensitive data sitting there.

The BYOD Gray Area

Some employees use personal devices for work. My advice: don't track personal devices in your Asset Register. It creates confusion about ownership, liability, and it's a privacy headache. Instead, keep a separate, simpler list: "Employee X uses personal laptop for work. Equipment agreement signed. Company provides: headset, monitor, keyboard." Track the company-owned peripherals. Leave their personal laptop out of it.

If you need full IT Asset Management including BYOD devices, you've outgrown spreadsheets. That's not a criticism — it's just reality.

Common Mistakes (I've Made Every Single One)

❌ Tracking only at onboarding. "We gave them equipment, we wrote it down, we're done." No. That was the beginning, not the end. Without ongoing verification, your data goes stale within months. Equipment breaks, gets lost, gets moved to a different room. Six months after onboarding, your records might as well be fiction.

❌ No equipment agreement. I cannot stress this enough. Without a signed agreement, you have a verbal understanding that "this stuff belongs to the company." Try enforcing that when someone in another state won't return a $3,000 laptop. Get the agreement signed before (or on) day one.

❌ Ignoring shipping data. "We'll just remember when we sent it." You won't. Three months later when the employee says they never got the second monitor, you'll have no tracking number to check and no ship date to reference. Track every shipment. Every single one.

❌ Keeping remote equipment in a separate file. I tried this once. A master Asset Register for office stuff and a separate "Remote Equipment" spreadsheet. Within two months, the two were out of sync. Total asset counts didn't match. Reconciliation was a nightmare. One file. One source of truth. Use the "Work Model" filter if you want to see only remote assets.

❌ No process for "employee moved." People move. Especially remote workers — that's kind of the point. If Sarah moves from Portland to Austin and you don't update her address, your offboarding package will ship to an empty apartment. Ask employees to notify you when they relocate. Add a "Last Address Verified" date to your register.

❌ Treating remote verification as optional. "We'll get to it next quarter." You won't. Make it a recurring calendar event. Block the time. Send the forms. Chase the non-responders. The first time you catch a missing asset through verification, the entire process pays for itself. I've seen it happen — and the look on the office manager's face was worth the quarterly hassle.

If you want more cautionary tales, check out our 10 Asset Management Mistakes article. I contributed to a few of those mistakes personally.

When to Move Beyond Spreadsheets

I love spreadsheets. I've built things in Excel that would make a database administrator weep (partly in admiration, mostly in horror). But there are clear signals that your remote equipment tracking has outgrown what a spreadsheet can handle:

• More than 50 remote employees — The spreadsheet gets slow, unwieldy, and error-prone at scale.
• You need real push notifications — An Apps Script that runs once a day is not the same as an instant alert when equipment is overdue. Employees ignore emails. They don't ignore push notifications.
• Multiple countries with different compliance rules — Tax depreciation, data privacy laws, import regulations. A spreadsheet won't handle this.
• You need MDM integration — If IT needs to remotely wipe lost devices, track encryption status in real-time, or push OS updates, that's not a spreadsheet job.
• Onboarding volume exceeds 5 people/month — At that point, the manual shipping-tracking-confirming workflow becomes a full-time job. You need automation.
• Remote asset audits take more than a day — If quarterly verification consumes your entire week, the system isn't scaling.

If three or more of these hit home, it's time to look at dedicated tools. I wrote about the decision process in Excel vs Asset Management Software.

My honest recommendation: UNIO24. It handles remote equipment with QR-scan verification from any phone, automatic overdue notifications, a complete chain of custody history for every asset, and employee self-service check-in. The free tier is genuinely useful — not a crippled trial, but a real product for small teams. You can migrate from your spreadsheet in an afternoon and keep your sanity intact.

Wrapping Up

Remote equipment tracking is just regular equipment tracking with worse visibility and higher stakes. You can't see the stuff, you can't touch the stuff, and getting it back requires a logistics operation instead of a tap on the shoulder.

But the core principle is the same: know what you have, know where it is, know who's responsible for it. A spreadsheet can absolutely do this for a team of 5 to 50 remote employees — as long as you adapt it for the realities of distributed work.

Your minimum viable remote tracking system:

1. Adapted Asset Register with Work Model, shipping data, and agreement tracking
2. Onboarding workflow with bundle tracking and delivery confirmation
3. Offboarding checklist with prepaid labels and a clear timeline
4. Quarterly verification via Google Form with photo proof

That's four components. None of them are complicated. All of them are essential. And together, they're the difference between "we think we have about 40 laptops out there somewhere" and "we have exactly 43 laptops deployed to remote employees across 12 cities, all verified within the last 90 days, with a total value of $94,600."

The second version is the one that lets you sleep at night.