Photograph and tag the SKU on the item before listing — Depop buyers often message about condition and sizing immediately after purchase, and bin pulls go faster when the SKU is on the tag.
Depop guide
Depop inventory spreadsheet for SKU, style category, fees, and cross-post tracking.
Build one row that connects your SKU, bin location, style category, size, purchase cost, Depop selling fee, payment processing fee, boost spend, and true net profit. Combine with a cross-post status column when the same item lives in your Poshmark closet or on eBay.
Depop worksheet columns
Keep marketplace fees and boosted listing costs separate when reviewing clothing category margins.
A B C D E F
| 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 |
| Platform | Listing | Marketplace where the item is listed or sold. | eBay |
| Date Listed | Listing | Date the item first went live so aging inventory is easy to review. | 2026-05-01 |
| List Price | Listing | Current asking price before offers, discounts, or promoted listing fees. | $38.00 |
| Purchase Cost | Cost | Item-level cost of goods before platform fees and shipping. | $12.00 |
| Bin Location | Storage | Shelf, tote, rack, or box location used to pull sold items quickly. | BIN-A03 |
| 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 |
| Shipping Cost | Shipping | Actual label or postage cost paid by the seller. | $6.85 |
Depop guide intro advertisement
Depop rows need three fee columns, not one
Depop combines a selling fee, a payment processing fee, and an optional boost fee into a single payout line — but keeping them in separate columns reveals which costs are fixed per sale versus which are choices that affect margin. Style categories and cross-post status round out what a fashion reseller's inventory row actually needs.
| Field | Use it for | Example |
|---|---|---|
| SKU | Assign an internal SKU before photographing and listing the item. | EX-DEP-BIN-A02-009 |
| Style category | Record clothing type so you can review margin by category. | Vintage denim / Streetwear |
| Size | Add size for clothing so bin pulls and relists stay accurate. | M / US 10 / One Size |
| Selling fee | Calculate 10% of sold price — logged after the sale posts. | $4.50 (10% of $45) |
| Payment fee | Log Depop Payments fee (~2.9% + $0.30) separately from the selling fee. | $1.60 (2.9% + $0.30) |
| Boost fee | Record the extra percentage charged for boosted listing visibility. | $1.80 (4% boost on $45) |
| Cross-post | Track active marketplaces so sold items get removed from other closets. | Active on Poshmark + Depop |
Keep selling fee and payment processing in separate columns. Depop Payments payouts net both deductions in one line, but splitting them in your spreadsheet makes category-level margin reviews more accurate.
Use a cross-post column rather than a separate Depop spreadsheet. One SKU row with a platform status field prevents the overselling risk that comes from maintaining two spreadsheets for the same item.
Formula guidance
Depop profit formulas
Use sold price, 10% selling fee, payment processing fee, and optional boost fee as separate inputs before reviewing profit.
A B C D E F
True profit
Shows item-level cash profit after cost, prep, shipping, fees, and promotion costs.
=Sale Price + Shipping Charged - Purchase Cost - Prep Cost - Shipping Cost - Marketplace Fee - Promotion Fee
Use buyer-paid shipping as revenue only when it is listed separately from the item price.
Gross margin
Compares profit quality across categories, sources, and marketplaces.
=Net Profit / Sale Price
Format the cell as a percentage and review low-margin rows before sourcing more similar items.
Sell-through rate
Measures how much listed inventory sold during the period you are reviewing.
=Sold Items / Listed Items
Run this on a weekly or monthly summary tab, not on each item row.
Days to sell
Flags stale inventory and shows how quickly each SKU turns into cash.
=Sold Date - Date Listed
Leave the cell blank until the item sells so active listings do not distort averages.
When the closet outgrows manual tracking
Inventory tags and poly mailers handle the physical side of a growing Depop closet. Consider crosslisting tools when the same SKU lives on multiple platforms and manual status updates risk overselling.
Depop guide upgrade advertisement
Other marketplace worksheets
Switch sheets if you also sell on another platform. Each guide keeps the same SKU and profit structure.
Depop inventory spreadsheet FAQ
What columns should a Depop inventory spreadsheet include?
Track SKU, item title, style category, size, condition, bin location, purchase cost, list price, sold price, Depop selling fee (10%), payment processing fee, boost fee, shipping cost, prep cost, and net profit. Add a cross-post status column if you list the same item on Poshmark or eBay.
How do I calculate Depop fees in a spreadsheet?
Depop charges a 10% selling fee on the sold price. Depop Payments also applies a payment processing fee of roughly 2.9% plus $0.30 per transaction. Keep these in separate columns so you can see selling fees and payment processing as distinct costs when reviewing margin.
Should I track boosted listings in my Depop spreadsheet?
Yes. Boosted listings cost an additional percentage on top of the 10% selling fee. Add a boost fee column and flag boosted items so you can compare average days to sell and sell price for boosted versus unboosted listings in the same category.
How do I handle cross-posted Depop items in one spreadsheet?
Use one row per SKU and add a platform column for the active marketplace. When the item sells on Depop, record the platform name, sold price, and Depop-specific fees in that row. A cross-post status column (Active/Sold on Depop/Sold on Poshmark) prevents double-selling without needing a separate sheet per platform.
When should I upgrade from a Depop spreadsheet to reseller software?
Upgrade when manual cross-post status updates lead to overselling, when daily shipping label generation takes more time than sourcing, or when you cannot reconcile Depop Payments payouts against your spreadsheet before tax filing.
Depop guide FAQ advertisement