Reselling Spreadsheet
Fill in a table of what you bought and sold, get profit and margin as you type, and download it as an Excel file with live formulas or a CSV.
Free · runs in your browser · nothing is uploaded
How to use the reselling spreadsheet
- Look at the sample row. Overwrite it, or press “Add a row” for each further item.
- Type the name in “Item” and the marketplace in “Platform”. Platform is a text box, not a list.
- Enter the purchase date in “Bought on” and the price you paid in “What it cost you”.
- When the item sells, fill in “Sold on” and “Sale price”.
- Enter what the platform charged in “Platform fees” and your costs in “Postage and packaging”.
- Read “Profit” and “Margin” at the end of the row. They stay empty until you enter a sale price. The “Total” row adds up the profit and works out the margin on all sales.
- Choose the “Currency” before you download. Press “Download Excel” or “Download CSV”.
- To move the rows into the browser ledger, press “Copy these rows into my ledger”.
The × button at the end of a row deletes it. The page remembers your rows in this browser, so you can come back and carry on, but clearing browser data removes them, so download a copy now and then. There is no link-sharing button on this page, so send the downloaded file if someone else needs the figures.
How do I calculate profit in a reselling spreadsheet?
Profit is the sale price minus what the item cost, the platform fees and your postage and packaging. Margin is that profit divided by the sale price. The sample row shows both: $30.00 less $8.00, $4.10 and $5.00 leaves $12.90, which is 43% of the sale.
| Column | Sample row | Second row |
|---|---|---|
| What it cost you | $8.00 | $5.00 |
| Sale price | $30.00 | $20.00 |
| Platform fees | $4.10 | $2.80 |
| Postage and packaging | $5.00 | $4.00 |
| Profit | $12.90 | $8.20 |
| Margin | 43% | 41% |
The Total row for these two items shows $21.10 of profit on $50.00 of sales, a margin of 42.2%. It divides total profit by total sales, so it is not the average of the row margins.
To build the same thing yourself, put cost, sale price, fees and postage in separate columns and use a formula like =F2-D2-G2-H2, with the cell letters of your own columns. The Excel file from this page already contains that formula.
What is in the Excel and CSV files?
The Excel workbook has the same columns plus Profit and Margin as live formulas, a totals row, and 200 spare rows, so new items you type below your data still calculate. Profit and Margin show nothing on a row until it has a sale price. The CSV holds the data columns only, with no formulas. The Excel file formats money with the symbol of the currency you chose, and the CSV holds plain numbers. If you re-open a CSV in a spreadsheet, format those columns as money yourself.
How do I track eBay fees in a spreadsheet?
Enter the fee eBay took for the sale in “Platform fees” on the row. The sheet does not look rates up. To see what eBay should charge for a given price, use the eBay fee calculator, then type the figure into the sheet, or compare it with the amount on your sales report. Postage goes in “Postage and packaging”.
Why copy rows into the ledger?
The ledger keeps stock, sold dates and a count of sales per platform and year. When you copy rows over, each item with a sale price arrives as sold and the rest as in stock. The platform you typed goes into the ledger’s Notes, and the platform is set to Other.
How this tool works and where the numbers come from
Each row holds one item. Profit is the sale price minus what it cost you, the platform fees and your postage; margin is profit divided by the sale price. The Excel file contains the same columns with live formulas, a totals row and 200 spare rows. Rows are kept in your browser until you clear them and can be copied into the ResalePocket ledger.
Sources
- ResalePocket sources and rate changelog (own method, no external rule) · checked
Frequently asked questions
Is a spreadsheet enough for reselling?
For a modest number of sales it covers the essentials: cost, sale price, fees, postage, profit and margin for each item. Past that, you may want to see which items are still in stock and how many sales each platform has had per year, which is what the ledger adds.
What fees should I enter for Grailed, Depop or StockX?
The sheet has no rates of its own. For Grailed and Depop, use the Grailed fee calculator or the Depop fee calculator and type the result in. StockX is not covered by any tool on this site, so take its figure from your StockX sales statement.
Where are my rows stored?
In this browser only, until you clear the browser data. The Excel and CSV buttons make a copy on your device. Your input is not uploaded to a server.
Can I use the numbers for my tax return?
The sheet organises your numbers and is not tax advice. Check the rules where you live, and keep your receipts.
Can I add more rows than the page shows?
Yes. Press “Add a row” as often as you like. The Excel file adds 200 spare rows as well.
Related tools
- Reseller Ledger: to keep stock and sold items with sales counted per platform and year.
- Selling Price Calculator: to find the price an item needs before you list it.
- Reseller Profit Calculator: for profit per item on a bulk lot.
- Reseller Income Calculator: to turn average profit per sale into weekly and yearly figures.
- COGS Calculator for Resellers: for cost of goods sold over a whole year.
- 1099-K Calculator: to check whether US marketplace payments would be reported.
- eBay Fee Calculator: to get the fee to type into the sheet.