Antique Booth Inventory Spreadsheet
For dealers renting booths or cases at antique malls. Track each piece, its tag code, cost and sale so monthly booth checks reconcile with the mall's sales report.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| SKU | Item | Bin | Purchase Date | Cost | Platform | Status | List Price | Sold Price | Fee % | Shipping | Profitƒ |
|---|---|---|---|---|---|---|---|---|---|---|---|
| AB-0317 | Oak Spindle Back Chair, c. 1910 | Booth 42 | 2025-07-27 | 35 | Antique Mall | Sold | 125 | 115 | 10 | 0 | auto |
| AB-0322 | Depression Glass Candy Dish | Case 7 / Shelf 2 | 2025-09-14 | 8 | Antique Mall | Listed | 38 | 10 | 0 | auto | |
| AB-0336 | Brass Ship's Lantern | Booth 42 | 2025-10-05 | 40 | Etsy | Sold | 160 | 150 | 9.5 | 24 | auto |
ƒ = calculated automatically by formula.
What's included
- SKU
- Item
- Bin
- Purchase Date
- Cost
- Platform
- Status
- List Price
- Sold Price
- Fee %
- Shipping
- Profit — calculated automatically
Tips for using this template
- Use the same SKU on your price tag and in the sheet so the mall's sales report matches line by line.
- Treat booth rent and mall commission as fees; set the fee percent to the mall's commission rate.
- Refresh the booth when pieces haven't sold in 90 days; move them to another mall or a different display.
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 TemplateSneaker Reseller Inventory SpreadsheetTrading Card Inventory SpreadsheetVintage Clothing Inventory TemplateThrift Store Inventory SpreadsheeteBay Seller Inventory SpreadsheetPoshmark Inventory SpreadsheetMercari Seller Inventory TemplateVinyl Record Inventory Spreadsheet