Free reselling tracker spreadsheet (Google Sheets & Excel), and when to move to software
Download a working reselling tracker for Google Sheets or Excel. It has one row per pair and calculates payout, profit and days-to-sell for you. It also totals sales by marketplace and month. Then read the part most templates skip: when one pair is live on several marketplaces, any spreadsheet becomes the wrong tool.
Download the free reselling tracker spreadsheet
Reseller inventory tracker (.xlsx) for Google Sheets and Excel. It has four tabs. How to use explains the file. Inventory has payout, profit, ROI and days-to-sell formulas on 1,000 pre-built rows. Sales summary has totals by marketplace and by month. Lists holds the marketplace and status dropdowns.
The tracker follows one rule: one row per physical unit you own. Two pairs of the same style code in the same size are two rows. They rarely share a purchase price, a sale date or a marketplace. You type into the white columns. The grey columns are formulas and fill themselves as soon as a sale is recorded. Two example rows show the pattern. Delete them before you start.
| Style / size | Purchase | Sale | Fees | Payout | Profit | ROI |
|---|---|---|---|---|---|---|
| DD1391-100 / EU 42.5 | €120 | €180 | €20 | €160 | €40 | 33.3% |
This example uses the order deductions you enter. It does not predict marketplace fees: payout = 180 − 20; profit = 160 − 120. The workbook calculates these columns from your sale inputs.
Open it in Google Sheets or Excel
Google Sheets
- Download the .xlsx file.
- In Google Drive choose New → File upload and pick the file, then open it. Sheets edits it as an Excel file.
- To convert it into a native Google Sheet, choose File → Save as Google Sheets. The formulas and dropdowns carry over.
Already have a blank sheet open? Use File → Import → Upload, pick the file and choose Replace spreadsheet so all four tabs come across.
Excel
Open the .xlsx directly. Files downloaded from the internet usually open in Protected View: click Enable Editing so the formulas calculate. Excel for the web opens it once the file is in OneDrive, and LibreOffice Calc opens it too.
Every formula uses functions both Google Sheets and Excel support (IF, SUM, SUMIFS, COUNTIFS, AVERAGE, DATE). There are no macros and no scripts to authorise.
What each column does
| Column | Type | What it is for |
|---|---|---|
| SKU / style code | Enter | The manufacturer style code (for example DD1391-100). It is the key every marketplace catalogue matches on. |
| Product | Enter | A readable name so the row makes sense without looking the code up. |
| Size | Enter | Include the scale (EU 42.5, US 9, UK 8). Marketplaces do not all use the same size system. |
| Purchase date | Enter | Starts the days-to-sell clock. |
| Purchase price | Enter | What the unit really cost you, including any shipping or import costs you paid to get it in hand. |
| Marketplace | Dropdown | Where the unit sold, or where it is listed until then. Edit the list on the Lists tab. |
| Listed price | Enter | Your current ask, for reference while the unit is unsold. |
| Sale date | Enter | Leave empty until it sells. An empty sale date is how the summary knows the unit is still stock. |
| Sale price | Enter | The sale price the marketplace shows for the order. |
| Fees | Enter | Everything deducted before you are paid: commission, payment processing, shipping, cash-out. Copy it from the order's payout breakdown. |
| Payout | Formula | Sale price minus Fees. It should match what reaches your account. |
| Profit | Formula | Payout minus Purchase price. Turns red when a sale lost money. |
| ROI | Formula | Profit divided by Purchase price. |
| Days to sell | Formula | Sale date minus Purchase date: how long your money sat in the unit. |
| Status | Dropdown | In hand, Listed, Sold or Returned. |
| Notes | Enter | Order ID, defects, box condition, or which other sites the unit is also listed on. |
The Sales summary sheet
The summary reads the Inventory tab and needs no input except the year.
- Totals: units recorded, sold and unsold. Total spent. Unsold stock at cost (the cash still tied up in inventory). Revenue, fees, payout and profit on sold units. ROI on sold units. Average days to sell.
- By marketplace: units sold, revenue, fees, payout, profit and average days to sell for every marketplace on the Lists tab. Sales tagged with a marketplace that is not on the list are counted in a catch-all row, so no sale goes missing.
- By month: the same figures per month of the sale date, plus a year total. Change the year cell to look at another year.
Record money in one currency. If you sell in euros and pounds, convert to your reporting currency before you type the figures, or the totals mix units.
Three rules keep the tracker usable
- One row equals one owned unit. A quantity column can summarize stock, but unit rows are safer once purchase cost, condition or sale state differs.
- Cross-listings are not new rows. A pair live on three marketplaces is still one row. Record the other listings in Notes or in a separate listings tab that references the row, never as extra stock.
- Status has one owner. Decide who records intake, sale, return and cancellation, and when.
Missing columns are rarely why a spreadsheet fails. More often, two people or two marketplace exports overwrite the same record.
A daily spreadsheet workflow
At intake, add the row with style code, size, purchase date and price, and set Status to In hand. When you list, set Marketplace, Listed price and Status. At the start and end of each day, check every marketplace for sales. Fill in Sale date, Sale price and Fees, and set Status to Sold. Then remove the unit's listings on every other site before a second buyer orders it.
Run a weekly exception check: duplicate rows for the same unit, Listed rows that already sold elsewhere, Sold rows without fees, missing purchase prices. These checks do by hand what software rules would enforce.
Spreadsheet vs inventory software
| Need | Spreadsheet | Connected software |
|---|---|---|
| Custom fields | Fast and flexible | Structured, sometimes configurable |
| One unit across marketplaces | Manual linked rows | Inventory-to-listing relationship |
| Sale detection | CSV or manual entry | Marketplace sync |
| Delist after sale | Manual and time-sensitive | Automated on supported channels |
| Audit trail | Version history | Statuses, orders and documents |
| Repricing | Formulas plus manual updates | Marketplace-aware controllers and floors |
You have outgrown the sheet when coordination is the job
The threshold is not a particular number of pairs. Move when two or more of these become routine. The same unit is live on three or more sites. Sales are discovered late. Quantity differs between marketplaces. Repricing takes an evening. Several people edit the file. Month-end means rebuilding payouts and documents from exports.
More formulas can hide these problems for a while. They cannot make a marketplace push a sale into the sheet or remove the matching listing elsewhere. That is the job of sneaker inventory management software. It keeps owned stock, live listings, confirmed sales and payouts connected across marketplaces, where a spreadsheet relies on habits.
Migrate without losing your records
- Freeze new columns and remove duplicate rows for the same unit.
- Normalize style code, size scale, currency, condition and status values.
- Separate owned units, live listings and completed sales.
- Import a small batch and reconcile it against the physical shelf.
- Connect one marketplace, verify sale and delisting behaviour, then add the rest.
- Keep the old file read-only as a dated archive.
The tracker workbook and the manual inventory CSV are layouts for tracking. They are not app-import templates. Download the current template from the app's CSV Menu and follow the CSV Import guide. Map the style code to StyleCode, the size region to SizeType, and the size to Size. Supply StorePrice, Quantity and the supported Listing Mode for the listing workflow you intend. Keep historical purchase, sale and payout records in the tracker. Do not add columns to the app template. Import a small batch, inspect errors and confirm the validated rows before linking listings.
Related reading
All articles
The multi-platform selling playbook: list everywhere, sell once
How high-volume resellers run the same stock across StockX, Alias, WeTheNew and POIZON without overselling, out-of-sync records, or a wall of browser tabs.
How to avoid overselling when you list on five marketplaces
Overselling is the most expensive mistake in multi-platform reselling. Here is how to prevent it by design instead of catching it after the second order lands.
How to cross-list sneakers across marketplaces (without overselling)
Cross-listing shows the same pair to every buyer pool, so it sells faster. It only works if synced inventory and auto-delisting stop you selling a unit twice.