Photography Equipment Inventory Spreadsheet
For working photographers and videographers tracking camera bodies, lenses, lights and memory cards. Have serials and purchase prices ready for insurance, travel and resale.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| Asset Tag | Item | Category | Brand / Model | Serial # | Location | Assigned To | Condition | Purchase Date | Purchase Cost | Useful Life (yrs) | Current Valueƒ |
|---|---|---|---|---|---|---|---|---|---|---|---|
| PH-01 | Mirrorless Camera Body | Cameras | Sony a7 IV | 4512908 | Studio Cabinet | Owner | Excellent | 2025-02-14 | 2499 | 6 | auto |
| PH-04 | 24-70mm f/2.8 Lens | Lenses | Sigma 24-70 DG DN Art | 56124330 | Camera Bag A | Owner | Good | 2025-02-14 | 1099 | 10 | auto |
| PH-09 | LED Video Light | Lighting | Aputure Amaran 200d | A2D1180443 | Studio Shelf | Second Shooter | Good | 2026-04-05 | 329 | 6 | auto |
ƒ = calculated automatically by formula.
What's included
- Asset Tag
- Item
- Category
- Brand / Model
- Serial #
- Location
- Assigned To
- Condition
- Purchase Date
- Purchase Cost
- Useful Life (yrs)
- Current Value — calculated automatically
Tips for using this template
- Record body and lens serials before you travel; some airports and insurers ask for proof of ownership.
- Track shutter count for bodies at each update since it affects resale value and service timing.
- Keep second-shooter loaners under the assignee column so gear always comes back after a wedding.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateIT Equipment Inventory TemplateTool Inventory TemplateGym Equipment Inventory SpreadsheetAV Equipment Inventory TemplateSchool Equipment Inventory TemplateFleet Vehicle Inventory TemplateLab Equipment Inventory SpreadsheetMedical Equipment Inventory Template