Depop inventory tracking gets messy fast. A few thrifted tees can live in your notes app. A serious vintage rack needs SKUs, listing dates, cost basis, size/color details, shipping costs, Depop fees, stale-stock reviews, and profit by source.
If you searched for a Depop inventory spreadsheet template, you probably need the columns first: item, SKU, bin, cost, price, fee, shipping, sold date, and profit. Download the starter CSV below if you need a sheet today; use the rest of this guide when the sheet starts hiding stale stock or margin mistakes.
The goal is not to build a prettier spreadsheet. The goal is to avoid buying, listing, and discounting blind. Every item should answer three questions: what did I pay, where is it listed, and did it make enough profit to source again?
Depop inventory tracker columns that actually matter
If you are tracking Depop stock manually, keep the system tight. Too many columns create busywork; too few columns hide whether you are making money.
| Column | Why it matters |
|---|---|
| SKU / bin location | Find sold items quickly and avoid relisting something you cannot locate. |
| Item title, category, size, brand | Search your own inventory and learn which categories deserve more sourcing time. |
| Source and purchase date | Compare thrift stores, bins, estate sales, and wholesale lots by real sell-through and ROI. |
| Cost of goods | Protect margin before fees, shipping, packaging, and discounts eat the sale. |
| Listing date and status | Spot stale listings before your death pile becomes invisible. |
| Sale price, fees, shipping, net profit | Measure what you actually keep, not just gross Depop sales. |
Free Depop inventory spreadsheet template
The safest starter template is one row per item, not one row per order. That lets you keep unsold stock visible, reconcile sold items later, and avoid counting cost of goods before a sale happens.
Download the free Depop inventory CSV template and open it in Google Sheets, Excel, or stokd's import flow. It includes these fields:
- Identity: SKU, item title, brand, size, color, category, condition, and bin/location.
- Sourcing: source, purchase date, cost of goods, cleaning/repair cost, and receipt notes.
- Listing: listing date, asking price, status, cross-listed channels, and days listed.
- Sale math: sale price, Depop fees, shipping label, packaging, net profit, margin, and ROI.
- Next action: relist, discount, bundle, cross-list, donate, or source more of the same category.
Do not make the spreadsheet the whole system. Use it as a cleanup pass for the first 10–25 active listings, then move repeat tracking into a profit tool before manual formulas become another source of lost margin.
Depop inventory spreadsheet formulas to copy
If you are starting in Google Sheets or Excel, add formulas that connect each sale back to cost basis. A Depop spreadsheet that only tracks sale price will overstate profit because it misses packaging, shipping labels, boosted listings, refunds, and stale inventory.
| Metric | Spreadsheet formula | What it tells you |
|---|---|---|
| Net profit | Sale price − Depop fees − shipping label − packaging − COGS | The dollars you actually keep from a sold item. |
| Profit margin | Net profit ÷ sale price | Whether discounts, shipping, and fees are leaving enough margin. |
| ROI | Net profit ÷ COGS | Which sources and categories deserve more buying budget. |
| Days listed | Today − listing date | When to relist, retitle, discount, bundle, cross-list, or clear the item. |
Use formulas for the first cleanup, but do not rely on hidden spreadsheet cells forever. Once you are selling across Depop plus eBay, Poshmark, Mercari, or Whatnot, a dedicated tracker makes each sold item connect to inventory, source, fees, shipping, expenses, and reports automatically.
Google Sheets vs a Depop inventory tracker
A Depop Google Sheet is useful when the job is simple: list every item, add a SKU, record cost, and stop losing track of what is sitting in bins. It becomes painful when you need to reconcile payouts, track receipt photos, split a thrift haul across multiple items, or compare Depop profit against other marketplaces.
- Use a spreadsheet when you have a small closet, fewer than 25 active listings, or you need a one-time audit before tax season.
- Use a tracker when listings are cross-posted, you source by lots, you have stale stock, or you want profit by source/category/platform without rebuilding formulas.
- Use both briefly by exporting your sheet as CSV, importing the active items, and keeping the old file as a backup while you verify totals.
Track Depop listing age before stale stock piles up
Depop sellers often think the problem is pricing. Sometimes it is age. If a piece has been listed for 45 days with likes but no sale, your next action might be refreshing photos, changing keywords, bundling, discounting, or cross-listing — not buying more of the same category.
Review inventory in simple buckets:
- 0–30 days: new stock; improve title, tags, and photos before cutting price.
- 31–60 days: test a discount, relist, bundle, or cross-list to another marketplace.
- 61–90+ days: decide whether to clear, donate, consign, or stop sourcing similar items.
Build SKUs before your Depop inventory gets hard to find
Search demand around Depop inventory keeps pointing back to the same operational pain: sellers need a way to find items after they sell. A SKU does not need to be complicated. It just needs to connect the physical item, its bin, the Depop listing, the original cost, and the eventual profit record.
Use a short code like B04-027 or TS-B04-TEE-027, then keep that same SKU on the item tag, in your storage bin, in your spreadsheet, and in stokd. If you need the full setup, read the Depop SKU system guide.
Depop profit tracking is more than the payment fee
Depop fee math is only one piece of the margin. A $42 sale can look good until you subtract cost of goods, processing, boosted listing fees, shipping upgrades, packaging, and returns. Use the Depop fee calculator for one-off margin checks, then save sold items in stokd so the profit rolls into source, category, and platform reports.
For each sale, record:
- Sale price and buyer-paid shipping.
- Depop payment processing and any boosted listing fee.
- Your shipping label cost and packaging expenses.
- Original purchase cost and any cleaning/repair costs.
- Final net profit and ROI.
When a spreadsheet stops being enough
A Depop inventory spreadsheet can be fine at the beginning. It starts to break when you cross-list to eBay, Poshmark, Mercari, or Whatnot; when you buy lots that need split cost; or when you need tax-ready records without hunting through screenshots and bank statements.
stokd is built for that next step: inventory, cost basis, platform, sales, fees, shipping, expenses, and profit reports in one reseller workflow.
Depop inventory spreadsheet migration checklist
You do not need to rebuild your whole shop in one sitting. Start by migrating the fields that affect profit and fulfillment, then clean up older inventory in batches.
- Keep your spreadsheet export as backup. Do not delete the sheet until every active item has a SKU, location, source, and cost basis in your tracker.
- Import or enter active listings first. Prioritize items currently listed on Depop, especially anything older than 30 days or stored across multiple bins.
- Map spreadsheet columns to real reseller fields. Item title, SKU, source, cost, listing date, asking price, status, sale price, fee, shipping, and net profit should each have one clean home.
- Reconcile sold items weekly. Match each Depop payout to the item cost, shipping label, packaging, refund, and final profit so your reports are not just gross-sales screenshots.
- Use the sheet only for edge cases. Once the active shop is inside stokd, keep spreadsheets for one-off exports instead of day-to-day inventory decisions.
Start with a 10-item Depop inventory cleanup
Use this as a spreadsheet audit before importing or rebuilding everything. Ten items is enough to expose missing costs, stale listings, and categories that are not worth sourcing again.
- Pick 10 active Depop listings: five newer items and five items older than 45 days.
- Add SKU/location, source, purchase cost, asking price, listing date, and current status.
- Run one item through the Depop fee calculator to check expected net profit.
- Fill the template's next-action column: improve photos, relist, discount, bundle, cross-list, donate, or source again.
- After each sale, log the actual fee, shipping cost, sale price, profit, and ROI.