Home/Spreadsheets/Small Business/Office Inventory Tracker
Office Inventory Tracker
An office inventory spreadsheet: set a minimum for each supply, see what to reorder, chase late orders and know who has which piece of equipment. The files open in Microsoft Excel and in Google Sheets, have no macros and nothing to install, and are yours to reuse as often as you like.
What it does
- On hand = your last shelf count plus anything received since that count, from the purchase log
- Anything at or below its minimum shows Reorder (or On order), with the quantity that tops it back up to the maximum
- Purchase log: open orders show On order, then Chase order once they are older than your chase setting
- Equipment register with who has it, condition, warranty days left, and return due dates for loaned items
- Who Has What: pick a person, a location or both and see every item they hold with its status
- Summary with six counts and four short lists: reorder now, orders to chase, equipment to action and warranties ending
- 250 ready rows each for supplies, purchases, equipment and people
- Opens in Excel and in Google Sheets
$14.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription

What it looks like


What is in the bundle
- Office Inventory Tracker workbook, 7 tabs: Getting Started, Summary, Setup, Supplies, Purchases, Equipment and Who Has What
- A blank Excel workbook with starter locations and lists
- A Filled Example workbook with a made-up office
- START HERE PDF with your Google Sheets make-a-copy links
Works in
- Google Sheets in a web browser: make-a-copy links (blank, plus a filled example) are in the START HERE PDF; free Google account needed
- Microsoft 365, Excel 2024 or Excel for the web (not Excel 2021 or older); the formulas use LET, HSTACK, FILTER and SORTBY
- No macros, add-ons or scripts; not compatible with Numbers, LibreOffice or OpenOffice
Honest scope
This is a planning and bookkeeping template, not tax or accounting advice. The numbers it reports are the numbers you enter.
Others in Small Business
- ExcelInteractive Excel Formulas Cheat SheetAn Excel cheat sheet with 243 formulas and functions: a searchable workbook you can…$7.99View →

- Excel + Google SheetsRFI and Submittal LogAn RFI and submittal log for construction administration that ages every open item from…$12.99View →

- ExcelCleaning Business Planner SpreadsheetA cleaning business spreadsheet for Excel: know which jobs to take, what each one earns…$11.99View →

- Excel + Google SheetsPrivate Tutor Business and Student Progress ManagerPrepaid hours and student progress in one file, plus a test-date countdown per student…$12.99View →
