Company has no system for tracking remote employee equipment and it’s getting bad

Work for 120 person fully remote company. We have zero system for tracking who has what equipment. Literally zero.

Discovered this problem when:

• Insurance audit asked for equipment inventory
• We couldn’t provide accurate list
• Turns out we’ve been paying insurance on equipment returned 18+ months ago
• Also discovered we have no idea where about 20 laptops actually are

Current “system”:

• Google Sheet last updated 7 months ago
• Multiple conflicting versions in different folders
• Some entries just say “John’s laptop” (we have 4 Johns)
• Several devices listed as “unknown location”

CFO is now demanding proper asset tracking before end of quarter. Need solution that:

• Actually tracks distributed equipment automatically
• Doesn’t rely on people manually updating spreadsheets
• Works for remote teams across multiple states
• Ideally handles the full lifecycle (procurement, tracking, recovery)

What are companies actually using for this? Everything I find seems designed for office environments with physical access.