Mercari Seller Inventory Template
For casual and side-hustle sellers clearing out closets, toys and household goods on app-based marketplaces. Track each listing from purchase to sale with fees and shipping included.
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ƒ |
|---|---|---|---|---|---|---|---|---|---|---|---|
| MC-1402 | Kids' Building Block Set, Complete | Closet Bin 1 | 2025-08-15 | 10 | Mercari | Sold | 40 | 36 | 10 | 9.5 | auto |
| MC-1415 | Air Fryer 5 qt, Like New | Garage Shelf | 2025-09-27 | 20 | Mercari | Listed | 55 | 10 | 0 | auto | |
| MC-1428 | Handheld Game Console, Used | Desk Drawer | 2025-10-30 | 95 | Mercari | Sold | 165 | 155 | 10 | 0 | 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
- Keep cost basis even for items you already owned; use what you'd realistically pay today so profit is honest.
- Track which items you offered free shipping on, since it moves the cost into your shipping column.
- Relist or drop price on stale items on a set day each week so nothing sits forever.
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 SpreadsheetAntique Booth Inventory SpreadsheetVinyl Record Inventory Spreadsheet