Vinted Stock Spreadsheet in Excel: Columns, Formulas and Limits

A good Vinted stock spreadsheet in Excel needs about a dozen columns: reference, description, category, size, location, purchase price, purchase date, listed price, listing date, status, sale price and sale date. With three formulas (profit, days in stock, stock value), you know what makes money and what's just sitting there.

You'll be able to build the spreadsheet this evening, paste the formulas as they are, and know when it will start costing you more time than it saves.

What columns should a Vinted stock spreadsheet have?

Only include what you'll use to make decisions. Every extra column is a cell you'll forget to fill in.

Columns F, I and K are the ones people neglect, and they're what make the spreadsheet worthwhile. No purchase price, no profit figure. No listing date, no way to spot stock that's not moving. No actual sale price, and you're calculating from a listed price that may never have been paid.

Which sale price should you record?

Record what you receive for the item, not the total the buyer paid. The amount the buyer pays includes their protection fee and postage, which don't come to you. If you record that total, your profit will be inflated on every row.

If you accept an offer, record the offer price, not the listed price.

Which formulas should you use in a Vinted stock spreadsheet?

Three calculated columns cover 90% of decisions. The formulas below are written for English-language Excel, with a comma as the separator. We assume row 1 holds the headers and the first data row is row 2.

M. Profit (in euros)

=IF(K2="","",K2-F2)

Empty until the item sells, then sale price minus purchase price.

N. Days in stock

=IF(I2="","",IF(L2="",TODAY()-I2,L2-I2))

For a listed item, the number of days since it went live. For a sold item, how long it took to sell.

O. Multiplier

=IF(K2="","",K2/F2)

A pair of jeans bought for €4 and sold for €19 gives 4.75. That's more telling than profit alone when you compare items at different prices.

What about totals at the top of the sheet?

A few summary cells, on a separate tab or above the table:

• Value of listed stock (what you paid for what's left): =SUMIF(J:J,"Listed",F:F)
• Number of listed items: =COUNTIF(J:J,"Listed")
• Total profit made: =SUM(M:M)
• Items unsold for more than 60 days: =COUNTIFS(J:J,"Listed",N:N,">60")
• Average profit per category (jeans here): =AVERAGEIF(C:C,"Jeans",M:M)

That last formula, repeated for each category, is the one that changes what you buy. You might find, for example, that your jeans make €12 profit on average and your T-shirts €3, for the same photo and shipping time.

Excel or Google Sheets for your Vinted stock?

Google Sheets is often more practical: you can update the row from your phone as you store an item or when a sale comes in. Excel is more comfortable for large volumes and pivot tables. The formulas above work in both.

The real deciding factor is where you'll be when the information arrives. If you mostly sell from your phone, a spreadsheet you can only open on a computer will always lag behind.

What are the limits of an Excel spreadsheet for Vinted?

A spreadsheet is great at calculations. What it can't do is fill itself in. And that's where it breaks down.

The three problems we see with almost every seller who reaches a certain volume:

• The lag. A sale on Vinted doesn't appear in your spreadsheet until you enter it. Two busy days and the sheet is twenty sales behind.
• Data entry mistakes. A forgotten offer price, a date in the wrong format, a row marked "Sold" when it was the one below. Every mistake skews the totals without you noticing.
• Giving up. The spreadsheet becomes a chore, you update it on Sundays, then every fortnight, then not at all. It turns back into a snapshot of the past.

Working out the time

Example: you sell 100 items a month. For each sale, you find the row, change the status and enter the actual price and date, which takes about a minute. Add entering new items: a minute each, for 100 new pieces. That's more than 3 hours a month of pure copying, not counting corrections.

If you sell 10 items a month, a spreadsheet does the job perfectly and there's no need to look further. At 100 sales a month, copying Vinted into Excel becomes an unpaid part-time job. That's what Revendor does for you: sales, purchases and stock sync from Vinted, and profit per item is calculated without any data entry.

How to keep the spreadsheet up to date without losing your evenings

If you stick with a spreadsheet, three rules limit the drift:

• Enter data when it happens. The item goes into the sheet when you store it, not that evening. The sale is recorded when you pack the parcel, because you have the order in front of you.
• Use the reference everywhere. If every listing ends with "Ref. 0142", you find the row with Ctrl+F in two seconds. To fit these habits into your day, take inspiration from our 20-minute routine to sell faster.
• Reconcile once a week. Compare the week's number of sales in Vinted and in your spreadsheet. Any gap, you fix it while you still remember.

What do you do with the figures once the spreadsheet is filled in?

Look at three things once a month:

1. Average profit per category, to know what to buy again.
2. Average time to sell per category, to know what ties up your money.
3. The list of items listed for more than 60 days, to decide what to do with them (price cut, bundle, new listing).

For the third point, our checklist for listings that don't sell helps you choose what to fix. And if you pass the reporting thresholds, your spreadsheet will also be your best starting point to declare your Vinted sales: in France, platforms pass on the details of sellers who reach 30 transactions or €2,000 in a year to the tax authorities, according to impots.gouv.fr.