Reseller Spreadsheet Google Sheets & Excel | Inventory, Profit and Tax Tracker for Poshmark eBay Mercari Depop | Schedule C Ready

I'm a reseller. I built this because every spreadsheet I tried either broke when I touched it or fell apart at tax time.

It tracks every item from the thrift rack to the sold label, then hands you a year-end summary laid out in actual Schedule C order.

Built for resellers of anything. Clothing, vintage, jewelry, glassware, toys, books, ephemera, collectibles, tools, furniture, home goods, holiday decor — if you buy it and resell it, it fits.

And for wherever you sell it. Poshmark, eBay, Mercari, Depop, Facebook Marketplace, Whatnot, Vinted, Grailed, live shows, craft fairs, your own site, or cash in a parking lot. Add any platform that isn't listed and the whole workbook picks it up.

WORKS WITH WHATEVER YOU ALREADY HAVE

- Google Sheets — free, no software to buy, works on your phone in the store
- Microsoft Excel — the full workbook, every formula intact
- LibreOffice Calc — also free, also works

Both are in your download. You are not choosing between them.

On a Mac, use Google Sheets rather than Apple Numbers. Numbers opens the file but drops the dropdown menus.

IT FITS HOW YOU ACTUALLY WORK

CROSS-LISTING. List one item on five platforms and record all of them. When it sells, you log which platform closed it — and a reminder column tracks what you still need to delist, so you don't sell the same thing twice.

BUNDLES. Several items in one sale, one label, one fee. There's a bundle splitter that works out each item's share, and you still get profit per item.

RETURNS. Mark it returned, enter the refund and any fees the platform gave back. The item's cost stops counting against the sale because you still own it, its value goes back into your inventory, and your Schedule C returns line fills in by itself.

YOUR OWN SKU SYSTEM. Already number your items? Type your own. The file flags duplicates instead of forcing a format on you.

FEES YOU DON'T KNOW YET. Rates differ by platform, by category, and by whether you promoted the listing. Separate rows for eBay's jewelry, handbag and trading card rates. A separate column for promoted listings and boosts, so you can see whether advertising paid. And an override column — when you see your real payout, type it in and it beats every estimate.


WHAT'S INSIDE — 13 TABS
- Start Here — set up in four minutes, no spreadsheet skills needed
- Dashboard — profit, margin, sell-through, month by month, year over year, five live charts
- Inventory — 500 rows, your own SKUs, cross-listing, delist reminders
- Sales — type the Item ID and brand, cost and dates fill themselves in
- Expenses — pick a category, the Schedule C line fills itself in
- Mileage — the correct IRS rate by date, plus parking and tolls
- Consignment — what you owe each consignor and what you've paid
- Tax Summary — the whole year in Schedule C order
- Deductions Checklist — categories to go through with your preparer
- Pricing Calculator — what to list at, whether to take an offer, bundle splitter
- Example — filled-in rows, including a bundle and a return
- FAQ & Fixes — every common question answered inside the file
- Setup — every fee, rate and list, all editable

The row counts are what the file starts with, not a limit. Need more? Copy the last row down and the formulas come with it.


WHAT MAKES IT DIFFERENT

REAL COST OF GOODS SOLD. Most trackers subtract what you paid for the things you sold. The IRS wants beginning inventory, plus purchases, minus ending inventory. This does it properly and carries your inventory year to year.

THE MILEAGE RATE CHANGED MID-YEAR. The IRS raised the business rate on July 1, 2026. Most templates have one rate box. This reads the date of each trip and applies the right rate on its own — and has a column for parking and tolls, which are separate from the mileage rate.

PROFIT BY SOURCING LOCATION. Not just what sold — where you bought it. Which thrift store is worth the drive.

PROFIT BY PLATFORM. Poshmark against eBay against Mercari, with real numbers from your own sales.

AGING ALERTS. Anything listed over 90 days turns amber, so dead stock stops hiding.

FIVE LIVE CHARTS. Net profit by month. Gross sales against net profit. Items sold by month. Profit by platform. Profit by sourcing location. They redraw themselves every time you add a sale — nothing to set up.

AN OFFER CALCULATOR. Someone offers you $35. Type it in and every platform tells you your profit, your margin, and whether to take it.


EASY ON DAY ONE

The advanced columns start hidden so it isn't overwhelming when you open it. There's a filled-in example row at the top of every tab you type in. And a short list telling you the six things you actually have to fill in to get a real profit number — everything else is there for when you want it.


SELLING IN POUNDS, EUROS, ANYTHING?

Change every currency symbol in about ten seconds:
Google Sheets — select all, Format, Number, Custom currency.
Excel — select all, Ctrl+1, Currency, pick your symbol.

No formula is affected. Written instructions are inside.

One honest note for sellers outside the US: every tab works anywhere, with two exceptions. The Tax Summary and Deductions Checklist follow the US Schedule C form. Elsewhere, use Tax Summary as a plain year-end income and expense summary and ignore the line numbers, or hide both tabs. Nothing else depends on them.


HOW IT WORKS

1. Buy. Your files download instantly.
2. Using Excel? Double-click the spreadsheet.
3. Using Google Sheets? Upload it to Google Drive and open it with Sheets. Three clicks, and the illustrated guide walks you through it.

No subscription. Nothing to install.

Also available bundled with the Antique Booth & Vintage Seller Spreadsheet — both for $49.99, a $15 saving.

ABOUT ME

I've been reselling since 2007. I run this shop, I have over 600 items listed, and I'm an Etsy Star Seller with a 4.9 rating. This is the spreadsheet I use, not a template built by someone who's never stood in a Goodwill bin.


BEFORE YOU BUY

This is a digital download. Nothing ships, so all sales are final.

Almost every question is already answered on the FAQ & Fixes tab inside the file — how to change the currency, what to do if a cell says View Only, how to log a bundle or a return, how to add more rows. Please look there first.

This is a bookkeeping tool, not tax advice. Tax rules change and every situation is different — have a qualified preparer review your return.