What should a reseller inventory spreadsheet track?
Track SKU, item title, marketplace, date listed, purchase cost, bin location, sale price, shipping cost, marketplace fee, net profit, and days to sell so every sale can be reconciled.
Free spreadsheet hub
Build a practical Google Sheets or Excel workflow for purchase cost, SKU, bin location, marketplace fees, shipping, sale status, and true profit. Start from one template, then customize columns for the marketplaces where you actually sell.
General Reseller Inventory Spreadsheet
A flexible starter workbook for sellers listing across more than one marketplace.
| SKU | Platform | Purchase Cost | Marketplace Fee | Bin Location | Net Profit |
|---|---|---|---|---|---|
| EX-SKU-001 | eBay | $12.00 | $5.22 | BIN-A03 | $17.35 |
Included tabs
Best for
New and part-time resellers who need one inventory list before moving into software.
The home template covers the common fields most sellers forget to keep together: what you paid, where the item lives, what the buyer paid, what the platform kept, and what was left after shipping.
Starter fields for inventory, sale, profit, storage, and tax review.
| Field | Category | Tracks | Example |
|---|---|---|---|
| SKU | Inventory | Internal stock number used to connect the listing, bin, and sale record. | EX-SKU-001 |
| Item Title | Inventory | Short listing title or product description. | Example denim jacket |
| Bin Location | Storage | Shelf, tote, rack, or box location used to pull sold items quickly. | BIN-A03 |
| Condition | Inventory | Condition note that supports consistent listing and return decisions. | Pre-owned good |
| Category | Inventory | Seller category used for reporting, taxes, and sourcing review. | Clothing |
| Sold Date | Sales | Date the order was paid or accepted. | 2026-05-21 |
| Sale Price | Sales | Buyer-paid item price before marketplace deductions. | $36.00 |
| Marketplace Fee | Profit | Platform commission, payment processing, or selling fee deducted from the sale. | $5.22 |
Pick one marketplace or combine several. The builder keeps one canonical SKU and profit structure while adding the fields each platform needs for fees, shipping, returns, offers, and local pickup.
eBay
Best for item IDs, promoted listing notes, buyer-paid shipping, returns, and fee reconciliation.
Poshmark
Best for closet SKUs, bundle tracking, offers, fixed fee thresholds, and bin organization.
Mercari
Best for buyer-paid versus seller-paid shipping, offer tracking, and compact inventory workflows.
Depop
Best for style categories, boosted listings, shipping labels, and cross-posted clothing inventory.
Facebook Marketplace
Best for local pickup, shipping orders, cash sales, and inventory that may also be cross-posted.
Use the guide pages when one marketplace needs extra setup detail, or jump to supplies when bin labels and shipping materials are the next bottleneck.
| Stage | Use the spreadsheet when | Upgrade when |
|---|---|---|
| Starter | You list part time and need cost, bin, and profit clarity. | You need bulk importing or automatic fee reconciliation. |
| Crosslisted | You keep one SKU across two or three marketplaces. | Manual status updates create overselling risk. |
| Scaling | You review weekly profit and sourcing performance. | You ship daily and need labels, inventory sync, or bookkeeping exports. |
Track SKU, item title, marketplace, date listed, purchase cost, bin location, sale price, shipping cost, marketplace fee, net profit, and days to sell so every sale can be reconciled.
Yes. The builder combines eBay, Poshmark, Mercari, Depop, and Facebook Marketplace presets and removes duplicate columns so one workbook can support crosslisted inventory.
Upgrade when manual updates cause overselling, you need bulk listing sync, you ship enough orders to need label automation, or you cannot reconcile fees before bookkeeping deadlines.