Reseller Spreadsheet Template (Free) -- and When You'll Outgrow It
Every reseller starts with a spreadsheet. Here is a free template that actually works, plus an honest look at when you will need something more.
Tax config last verified: 2026-01-10. Download link below -- no email gate, no signup required.
Download the template
This is a CSV file you can open in Google Sheets, Excel, or any spreadsheet app. It includes the columns most resellers need to track profit correctly.
Download CSV template (free, no email)
What is in the template
The template has these columns:
| Column | What it tracks |
|---|---|
| Title | Item name / description |
| Platform | Where you sold it (eBay, Poshmark, Mercari, etc.) |
| Source | Where you bought it (thrift, wholesale, retail, other) |
| Date Acquired | When you sourced it |
| Date Sold | When it sold |
| COGS | What you paid for the item |
| Sale Price | What the buyer paid |
| Platform Fee | Commission charged by the marketplace |
| Payment Fee | Payment processing fee (e.g., $0.30 on eBay) |
| Shipping Cost | What you paid for the shipping label |
| Shipping Charged | What the buyer paid for shipping |
| Other Costs | Supplies, packaging, etc. |
| Profit | Calculated: Sale Price - COGS - Fees - Shipping - Other |
| Status | listed, sold, donated, personal |
| Notes | Free-form notes |
How to use it
- Download the CSV and open it in Google Sheets or Excel
- Add a profit formula in the Profit column:
=G2-F2-H2-I2-J2+K2-L2(Sale Price - COGS - Platform Fee - Payment Fee - Shipping Cost + Shipping Charged - Other Costs) - Enter every item as you source it (COGS and source are the must-haves)
- Fill in sale details when the item sells
- At the end of each month, sum your Profit column
Tips for getting the most out of your spreadsheet
- Enter COGS immediately: Do not wait until you list the item. Enter what you paid the same day you source it. You will forget otherwise.
- Track fees separately: Do not lump all fees into one column. Platform fees, payment fees, and shipping are different deduction categories on Schedule C.
- Use one row per item, not per sale: This makes it easier to match costs to sales at tax time.
- Track mileage separately: Keep a mileage log with date, destination, and miles. The IRS rate for 2026 is $0.70/mile.
When you will outgrow a spreadsheet
Spreadsheets are great at low volume. Here are the signs you have outgrown yours:
- You stop entering COGS: Entering costs on a phone spreadsheet is painful. If you are skipping it, you are not tracking profit -- you are tracking revenue.
- Fee math gets complicated:eBay's final value fee varies by category. Poshmark's commission has two tiers. Keeping formulas accurate across platforms is tedious.
- Tax season is stressful: If you spend hours manually totaling columns and worrying about whether your numbers will match your 1099-K, you need a tool that generates the report for you.
- You sell on 3+ platforms: Managing separate fee structures, shipping models, and reporting across multiple platforms in one spreadsheet gets messy fast.
- You have more than 200 items: At this scale, one wrong formula corrupts hundreds of rows and you may never notice.
Migrating from a spreadsheet
When you are ready to switch, Soldbook treats your spreadsheet as the front door. Upload your .xlsx or .csv, and the importer auto-detects your columns (title, cost, dates, platform, price, fees). Preview the mapping, confirm, and your full history imports. Target: under 10 minutes.
Your spreadsheet served you well. Soldbook is for when you need it to do more.
Ready to outgrow your spreadsheet? Import it into Soldbook.
Try Soldbook freeRelated reading:
Informational only — not tax advice.