Free Airbnb Inventory Checklist (Excel)
What's in the Airbnb inventory checklist
The workbook has one working tab, Inventory, with 100 rows: room (Kitchen, Bathroom, Bedroom, Living room, Safety, Other), item, quantity expected, quantity counted and replacement cost.
Variance and total value calculate automatically for every row - variance is quantity counted minus quantity expected, so a negative number flags something missing or broken the moment you finish a count.
The summary below the table totals replacement value overall and by room, plus how many items came up short versus how many came up over.
Cost tracking and reorder flags competitors don't offer
thegoodocs.com's checklist is a generic room list with no cost tracking. Xenia's version is SaaS-first - the calculating version is gated to their platform. Routedfamily and hosttools frame their checklists as printable PDF/Word content rather than a live-calculating spreadsheet.
This file auto-sums replacement cost by room and flags a variance the instant quantity counted drops below quantity expected - neither the SUM rollup nor the auto-flag exists in those competitors' static or gated versions.
An inventory, not a cleaning checklist
This is deliberately different from cleaning-checklist-template-excel already on this site: that one tracks turnover cleaning tasks (what needs to be wiped, vacuumed or restocked between guests). This one tracks what furniture and amenities physically exist in the unit and their dollar value.
Use this inventory for insurance documentation and periodic condition audits, and the cleaning checklist for the actual turnover task list between guests.
Who this template is for
Short-term rental hosts and property managers who need a documented, dollar-valued inventory of what's in a unit - for insurance, for co-host handoffs, or for periodic condition checks.
It's built for a single unit's furniture and amenities, not for a multi-property portfolio's stock and reorder system.
How to use it
- List every item by room with quantity expected, quantity counted and replacement cost.
- Variance and total value calculate automatically for every row.
- Check the summary for total value by room and how many items are short or over.
Download the free Free Airbnb Inventory Checklist (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Inventory Tracker — Small Business
For a full retail or multi-location operation, the paid Inventory Tracker ($14) tracks up to 200 SKUs with profit margin and reorder alerts across every sales channel.
See the full versionFrequently asked questions
Is this the same as a cleaning checklist?
No. This tracks furniture, appliances and amenities with quantity and dollar value - use cleaning-checklist-template-excel on this site for turnover cleaning tasks instead.
How does it flag missing items?
Variance is quantity counted minus quantity expected - any negative number is highlighted automatically, and the summary counts how many items came up short.
Does it total replacement value by room?
Yes. The summary uses SUMIF to roll up dollar value for Kitchen and Bathroom automatically, plus a grand total across every room.
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, open it, and choose File > Save as Google Sheets - the formulas keep working.
What's the usage license?
Personal use or use within one rental business. It's not meant to be resold or redistributed as a template product.