Free Excel spreadsheet for buying and reselling
A ready-to-use spreadsheet to track your buying and reselling on Vinted, eBay or at flea markets: your purchases, the items of each lot, your sales and your net margin, calculated automatically.
Excel file of 54 KB, no macros, written in English. It also opens in LibreOffice and Google Sheets (File → Import).
What the spreadsheet contains
- Purchases: one row per lot, box or item, with the price paid. The spreadsheet shows how much the lot has already brought in and whether it has paid for itself.
- Items: one row per item, linked to its lot. Status (in stock, listed, sold), platform, selling price, fees and shipping.
- Summary: sales, revenue, fees, taxes or contributions and net margin, month by month.
How the margin is calculated
The spreadsheet splits the price of each lot between its items in proportion to their value: the target price while an item is unsold, then its real selling price. A coat sold for €22 therefore carries a bigger share of the lot than bodysuits sold for €10.
share of the lot = lot price × item value ÷ value of all the items in the lot
net margin = selling price − fees − shipping − share of the lot − taxes or contributions
Taxes and contributions are set to 0 in the Read me sheet: enter the rate that applies to you, or leave 0 if you only sell personal belongings. For reference only, the French micro-entreprise rate for goods in 2026 is 12.3%. It is a French rule: other countries differ.
The limits of a spreadsheet
A spreadsheet is fine to start with. It gets heavy as your stock grows: an item sold on one platform stays online on the other, the receipts are somewhere else, and a formula deleted by mistake quietly throws everything off. That is why we built Alraune.
The same tracking, without formulas
Alraune does everything this spreadsheet does, and adds photos, receipts, parcel reminders and, in France, the amount to declare.