Is a spreadsheet good enough for reselling?

For many resellers, yes — genuinely. If you're selling roughly 5 to 20 items a month on one or two platforms, a well-maintained spreadsheet gives you everything that matters: cost basis, profit per item, ROI, and a record for tax time, all for free. The template on this page covers that use case completely. Where spreadsheets fall short is scale and automation. Once you're doing 40+ sales a month across multiple platforms, you're spending meaningful time on manual fee calculations, your inventory values are always out of date because there's no live market data, nothing alerts you to aged stock tying up capital, and every payout you transcribe by hand is a chance to introduce an error your formulas won't catch. The honest framing: start with a spreadsheet, keep it rigorously, and treat recurring reconciliation errors or skipped updates as the signal that you've outgrown it — not as a reason to feel bad about your record keeping.

How do I track eBay fees in a spreadsheet?

Use eBay's actual fee structure rather than a rough percentage. For most categories, eBay charges a 13.6% final value fee on the total sale amount — that's item price plus whatever you charged for shipping — plus a per-order fee of $0.30 for orders of $10 or less and $0.40 for orders above $10. In this template, put =ROUND(I2*0.136+0.4,2) in the Platform Fees column (K), where I2 is your sale price. Watch for category exceptions: sneakers over $150 are charged 8% with the per-order fee waived, books and music run 15.3%, handbags and jewelry 15%, and guitars only 6.7%. If you run promoted listings, add that percentage on top — a 5% ad rate on a $100 sale is another $5 off your profit. The most reliable habit is to enter the exact fee from eBay's order details page after each sale and let the formula serve as a pre-sale estimate. When the formula and the payout disagree, the payout is right.

How do I calculate profit for reselling in Google Sheets?

Net profit is sale price minus everything it cost you to buy and sell the item. In this template that's =I2-F2-K2-L2 — Sale Price minus Purchase Price, Platform Fees, and Shipping Cost. For ROI, divide net profit by purchase price: =M2/F2, formatted as a percentage. Wrap both in IF(I2="","",...) so unsold rows stay blank, then drag the formulas down the whole column so future sales calculate automatically.

Does this template work in Excel and Google Sheets?

Yes. It's a plain CSV, so it opens in Google Sheets, Excel, Apple Numbers, and LibreOffice. In Sheets, use File → Import → Upload. In Excel, open the file directly and save as .xlsx afterward so your added formulas and formatting persist. All the formulas in this guide work identically in both.

Why doesn't the CSV include the formulas already?

CSV is a plain-text format — it can store values but not live formulas, no matter who makes the template. Any downloadable CSV showing 'formulas' actually shows results. That's why the template's Notes column and this guide give you the exact formula text to paste in after importing. It's a one-time, two-minute setup.

How should I track the same item across multiple platforms?

Use one row per physical unit, and use the Platform Listed column for where it's currently listed (or update it to where it actually sold). If you cross-list one item on eBay and Grailed simultaneously, it's still one row — one unit can only sell once. If you own three of the same shoe, that's three rows with distinct SKUs, since each may have a different cost and sell in a different place.

What fees should I use for StockX, Grailed, and Depop?

StockX: 9% transaction fee for Level 1 sellers (decreasing to 7% at Level 5) plus 3% payment processing — about 12% all-in for most sellers. Grailed: 9% commission plus payment processing of 3.49% + $0.49. Depop US: no selling fee, just payment processing of 3.3% + $0.45 (Australian sellers pay an additional 10% selling fee). Rates are accurate as of July 2026 — re-check platform fee pages periodically.

Can I import this spreadsheet into ResellAIO later?

Yes. ResellAIO has CSV import built in, and the template's inventory columns — item name, brand, size, condition, SKU, purchase price, and purchase date — map directly to ResellAIO's inventory fields. Your tracking history carries over instead of starting from zero, which makes the spreadsheet a genuine starting point rather than throwaway work.

Free Reseller Spreadsheet Template (2026) — Track Inventory & Profit

Download the Free Template

Download the free reseller spreadsheet template (CSV) — no email required, no signup, no catch.

It's a plain CSV file, so it opens in anything: Google Sheets, Excel, Numbers, or LibreOffice. To get started:

Google Sheets: Go to File → Import → Upload, select the CSV, and choose "Replace spreadsheet". Done.
Excel: Open the file directly, then save it as .xlsx so your formulas and formatting stick.

The template includes three realistic example rows — a sold pair of Jordan 1s, a sold vintage Patagonia fleece, and a Pokemon Elite Trainer Box that's still listed — so you can see exactly how a filled-in row should look. Delete them once you've added your own inventory.

One honest note before you scroll further: CSV files can't store live formulas, so the Net Profit and ROI cells in the download contain the example results, not the formulas themselves. The Notes column tells you which formula to add in each spot, and the formulas section below walks through every one of them. It takes about two minutes to set up.

Beginner Tip: If you've never used spreadsheet formulas before, don't worry — you only need two of them (Net Profit and ROI), and you can copy-paste both directly from this guide.

What's Inside: Column-by-Column Walkthrough

The template has 16 columns. Here's what each one is for and why it earns its place:

Item Name (A): Full descriptive name — brand, model, colorway. "Nike Air Jordan 1 Retro High OG Chicago" beats "Jordans" when you're searching 200 rows later.
Brand (B): Separate column so you can filter and see which brands actually make you money.
Size (C): Shoe size, clothing size, or blank for items without one (sealed product, electronics).
Condition (D): New, Like New, Very Good, Good, Fair. Be consistent — it matters when you review what sells.
SKU (E): Your own internal ID (e.g. AJ1-CHI-105). Invaluable once you have duplicate items or bin storage.
Purchase Price (F): What you actually paid, including tax. This is your cost basis for every profit calculation.
Purchase Date (G): Lets you spot aged inventory — money sitting on a shelf instead of compounding.
Platform Listed (H): eBay, StockX, Grailed, Depop, etc. Needed to apply the right fee math.
Sale Price (I): The gross sale amount. Leave blank until sold.
Sale Date (J): Combined with Purchase Date, this gives you days-to-sell — one of the most underrated metrics in reselling.
Platform Fees (K): Total marketplace + payment processing fees for the sale. The fees section gives you the real numbers per platform.
Shipping Cost (L): What shipping cost you (label + materials), not what the buyer paid.
Net Profit (M): Formula column: sale price minus cost, fees, and shipping. The only number that actually matters.
ROI % (N): Formula column: net profit divided by purchase price. Tells you which sourcing is worth repeating.
Status (O): In Stock / Listed / Sold. Filtering on this column gives you an instant view of unsold inventory.
Notes (P): Flaws, storage bin, order numbers, or anything future-you will want to know.

Add the Formulas (Net Profit, ROI, Totals)

Because CSV files can't hold live formulas, you add these once after importing. They work identically in Google Sheets and Excel. Row 2 is your first data row; adjust the row number as needed and drag the formula down.

1. Net Profit (column M)

In cell M2:

=I2-F2-K2-L2

That's Sale Price − Purchase Price − Platform Fees − Shipping Cost. To keep unsold rows blank instead of showing a negative number, use this version instead:

=IF(I2="","",I2-F2-K2-L2)

2. ROI % (column N)

In cell N2:

=IF(M2="","",M2/F2)

Then format the column as a percentage (Format → Number → Percent in Sheets). A $60.50 profit on a $180 purchase shows as 33.6%.

3. Summary totals (put these anywhere above or beside your table)

Total profit from sold items: =SUMIF(O:O,"Sold",M:M)
Number of items sold: =COUNTIF(O:O,"Sold")
Average ROI on sold items: =AVERAGEIF(O:O,"Sold",N:N)
Capital tied up in unsold inventory: =SUMIFS(F:F,O:O,"<>Sold")
Average days to sell: =AVERAGE(ARRAYFORMULA(IF(J2:J="",,J2:J-G2:G))) (Google Sheets)

Once M2 and N2 are in place, select both cells and drag the fill handle down a few hundred rows. Every future sale calculates itself.

Pro Tip: The 'capital tied up in unsold inventory' formula is the one most resellers skip — and the one that most often reveals a problem. If that number keeps growing while sold profit stays flat, you're sourcing faster than you're selling.

How to Track Fees Per Platform

The Platform Fees column is where most spreadsheet trackers go wrong. Guessing "about 10%" quietly distorts every profit number downstream. Here are the real fee structures (US rates, accurate as of July 2026) and a ready-made formula for each:

Platform	Fee Structure	Formula for cell K2
eBay (most categories)	13.6% final value fee on the total sale (item + shipping charged), plus a per-order fee of $0.30 (orders $10 or under) or $0.40 (over $10)	`=ROUND(I2*0.136+0.4,2)`
eBay (sneakers over $150)	8% final value fee, per-order fee waived	`=ROUND(I2*0.08,2)`
StockX	9% transaction fee (Level 1 sellers; drops to 7% at Level 5) + 3% payment processing	`=ROUND(I2*0.12,2)`
Grailed	9% commission + payment processing of 3.49% + $0.49	`=ROUND(I20.09+I20.0349+0.49,2)`
Depop (US)	No selling fee; payment processing of 3.3% + $0.45 (Australian sellers pay a 10% selling fee on top)	`=ROUND(I2*0.033+0.45,2)`

A few important caveats:

eBay fees vary by category. 13.6% covers most categories, but books and music run 15.3%, handbags and jewelry 15%, watches 15% on the first $1,000, and guitars just 6.7%. eBay also calculates its fee on item price plus shipping charged to the buyer — if you charge for shipping, add it to the formula.
Promoted listings are extra. If you run eBay promoted listings at, say, 5%, that comes off the top too and belongs in your fees column.
Fees change. Platforms adjust their fee schedules regularly. Re-check the official fee pages every few months, because a stale formula silently corrupts every row you add after the change.

The practical approach: put the matching formula in K2 based on the platform in column H, or use a nested IF like =IF(H2="eBay",ROUND(I2*0.136+0.4,2),IF(H2="StockX",ROUND(I2*0.12,2),...)) — with the tradeoff that the formula gets harder to maintain with every platform you add.

These are baseline US rates. Category exceptions, promoted listings, international fees, and seller-level discounts all shift the real number. When a payout doesn't match your formula, trust the payout and correct the row.

Spreadsheet Workflow Tips

A spreadsheet only works if it stays current. These habits keep it trustworthy:

Log purchases the day you buy. The number one way spreadsheets die is a backlog of un-entered sourcing hauls. Enter items before they go on the shelf.
Record sales from the payout, not the listing. Enter the actual fee and actual shipping cost from the order details screen. Estimates drift; payouts don't.
Use data validation on the Status column. In Sheets: Data → Data validation → dropdown with "In Stock", "Listed", "Sold". This prevents typos like "sold " (trailing space) that silently break your SUMIF totals.
Freeze the header row (View → Freeze → 1 row) so column names stay visible as your inventory grows.
One row per unit, not per product. If you have three of the same shoe, use three rows with distinct SKUs (AJ1-CHI-105-1, -2, -3). Each unit can have a different cost and sell on a different platform.
Do a monthly reconcile. Once a month, compare your spreadsheet's sold total against your actual platform payouts. If they don't match, find out why before the gap grows.
Never delete sold rows. Filter them out of view instead. Your sold history is your tax record and your best sourcing data.
Back it up. Google Sheets handles this automatically; if you're in Excel, keep the file in OneDrive/Dropbox or export a copy monthly.

Money Tip: Your sold rows are a goldmine: sort by ROI % descending once a quarter and look for patterns in brand, category, and sourcing spot. Then go buy more of whatever tops the list.

When a Spreadsheet Stops Scaling

Let's be honest: this template is genuinely enough for a lot of resellers. If you're moving 5–20 items a month on one or two platforms, a well-kept spreadsheet costs nothing and does the job. Plenty of sellers run their whole first year on one.

But there's a predictable point where the spreadsheet becomes the bottleneck, and it shows up as four specific problems:

Manual fee math on every sale. Every sale means looking up (or trusting last quarter's memory of) the right fee structure, applying category exceptions, and typing the result. At 40+ sales a month across platforms, this is real time — and each entry is a chance to be wrong. Dedicated tools calculate eBay, StockX, Grailed, and Depop fees automatically from the sale price.
No live market data. Your spreadsheet knows what you paid, but not what your inventory is worth today. To reprice, you open StockX or eBay sold listings item by item. Software with market data integration shows current values against your cost basis without leaving the page.
No aged-stock alerts. The Purchase Date column technically contains the answer to "what's been sitting too long?" — but a spreadsheet never taps you on the shoulder. Stale inventory quietly ties up capital until you happen to sort by that column.
Error-prone copy/paste across platforms. Selling on eBay, StockX, and Grailed simultaneously means transcribing three payout formats into one sheet. One mistyped fee or a formula that didn't fill down, and your profit numbers are fiction until your monthly reconcile catches it — if it does.

None of these are spreadsheet skill problems. They're structural: a spreadsheet is a passive document, and past a certain volume you need something that does the math for you and flags what needs attention.

Importing Your Spreadsheet Into ResellAIO

If you hit that ceiling, the work you put into this template isn't wasted — it becomes your migration path.

ResellAIO ($10/month flat) has CSV import built in, so the inventory you've tracked in this exact template can be brought straight over: item names, brands, sizes, conditions, purchase prices, purchase dates, and SKUs all map to inventory fields. From there:

Platform fees for eBay, StockX, Grailed, and Depop are calculated automatically when you record a sale — no more fee formulas to maintain.
StockX market data shows what your sneakers and collectibles are worth right now, next to what you paid.
Profit, ROI, and expenses are tracked continuously instead of at your monthly reconcile.

And if you're not there yet? Use the spreadsheet. It's free, it's yours, and it teaches you exactly which numbers matter — which makes you better at reselling whether or not you ever switch tools.

Pro Tip: A good test for whether you've outgrown the spreadsheet: if your monthly reconcile regularly finds discrepancies, or you've skipped it two months running because it takes too long, the spreadsheet is already costing you more than $10/month in errors and time.

Free Reseller Spreadsheet Template (2026)

Table of Contents