A Depop sales spreadsheet needs one row per sale and a handful of columns: what you paid, what it sold for, the fees and shipping that came out, and the profit left over. Add two formulas, one for profit and one for margin, and a monthly summary, and you'll know exactly which items are worth your time. Here's a layout you can copy into Google Sheets or Excel.
The columns
| Column | What goes in it |
|---|---|
| A: Item code | A short code, like JKT-014. Match it to the label on the item. |
| B: Item | A short description. |
| C: Category | Jackets, jeans, shoes and so on. |
| D: Source | Where you bought it: thrift store, car boot, wholesale. |
| E: Buy date | When you bought it. |
| F: Cost | What you paid. |
| G: List date | When it went live. |
| H: Sale date | When it sold. |
| I: Sale price | The item price the buyer paid. |
| J: Fees | Depop and payment fees, from the sale's details in the app. |
| K: Shipping cost | What postage cost you, if you paid it. |
| L: Packaging | Mailers, tape, tissue. |
| M: Profit | Formula below. |
| N: Margin | Formula below. |
| O: Days to sell | Formula below. |
Use the actual fees shown on each sale rather than a fixed percentage. Depop's fees differ by country and have changed over time. See Depop selling fees explained.
The formulas
For row 2:
- Profit (M2):
=I2-F2-J2-K2-L2 - Margin (N2):
=IF(I2>0,M2/I2,""), formatted as a percentage - Days to sell (O2):
=IF(H2="","",H2-G2)
Copy them down the column, and every new row calculates itself.
A monthly summary
On a second tab, use SUMIFS to total each month:
- Revenue:
=SUMIFS(Sales!I:I,Sales!H:H,">="&A2,Sales!H:H,"<"&EDATE(A2,1)), with the first day of the month in A2 - Profit: the same formula on column M
- Items sold:
=COUNTIFS(Sales!H:H,">="&A2,Sales!H:H,"<"&EDATE(A2,1))
A pivot table by category or source is the quickest way to see what's actually making you money. Often a source you love turns out to have the lowest margin.
Tips that keep it accurate
- Record the cost when you buy, not when it sells. You'll forget.
- Log sales the same day, from the sale details in the app.
- Keep unsold stock in the sheet too, so you can see what's been sitting. See how to track Depop inventory.
- Keep receipts. The sheet helps at tax time. See Depop tax deductions.
When a spreadsheet stops being enough
Spreadsheets work well for small shops, but everything is typed in by hand. Once you're listing dozens of items a week, or selling on Depop and Vinted, rows get missed and the numbers drift.
DepopAutomation.com's profit tracker records fee-adjusted profit per sale for you, with CSV export when you still want a spreadsheet. The AI listing tool writes titles and descriptions and fills in category, brand, colour, condition and style, Nano Banana cleans up your photos, the bulk lister handles whole hauls, relisting keeps older stock visible, and cross-listing puts items on Vinted too.
Quick answers
What should a Depop spreadsheet include? Item, cost, sale price, fees, shipping, packaging, profit, margin and dates.
How do I calculate Depop profit? Sale price minus cost, fees, shipping and packaging.
Where do I find my Depop fees? In the details of each sale in the app.
Google Sheets or Excel? Either. The formulas above work in both.
Is a spreadsheet good enough? For a small shop, yes. At higher volume, an automatic tracker saves time and catches mistakes.
Conclusion
A good Depop spreadsheet is one row per sale, real fees from the app, and formulas for profit, margin and days to sell, plus a monthly summary. Keep it updated the day things sell, and switch to an automatic tracker once manual entry starts slipping.