Free template
A reselling spreadsheet that's ready for tax time
Most reselling spreadsheets start with title, price and profit, and find out in April that they needed the buy date and the fees too. This one has the twelve columns a reseller's return actually asks about, with the profit worked out for you.
A CSV file. Opens in Google Sheets, Excel and Numbers.
The columns, and why each is there
| AItem | Enough to recognise it a year from now: brand, what it is, size. |
|---|---|
| BBought on | The date you paid for it. It decides which year's inventory it sits in. |
| CWhere | The store, sale or lot. Useful for spotting which sources pay off. |
| DCost | What you paid, including sales tax. For a bag or lot, this item's share. |
| EMarketplace | Where it sold. Each one takes its fees differently. |
| FSold on | The sale date. Profit counts in this year. |
| GSale price | The item price after any offer, not the listing price. |
| HShipping charged | What the buyer paid for shipping, if you bought the label. |
| IFees | Everything the marketplace took. Your payout statement has it; the calculators break it down. |
| JShipping label | What the label and packaging cost you. |
| KOther costs | Cleaning, repairs, authentication, supplies for this item. |
| LProfit | Filled in by formula: sale price + shipping charged − fees − label − cost − other. |
Using it well
- Add the row when you buy, not when it sells. The cost is the number that disappears if you wait.
- For a lot, add one row per item and split the price across them so the costs add back up to what you paid.
- Leave the fees blank until it sells, then copy them from the payout or work them out with the eBay, Poshmark or Mercari calculator.
- Filter by the Sold on year to get the year's totals. Rows with no sale date are your inventory.
When a spreadsheet stops being enough
A spreadsheet is fine at twenty items. It starts to slip when the fees need checking against each marketplace's rules, when you're entering sales from a phone in a parking lot, and when you also need a mileage log. That's the job Hustl's ledger does: the same columns, with fees filled in from each marketplace's schedule, a mileage log at the IRS rate and a year-end report.
Already have a spreadsheet? Ledger imports CSV files, including this one, and marketplace sales reports, so you don't start over.