Set up a reseller spreadsheet
In Google Sheets, a reseller spreadsheet needs three parts: an inventory list of what you bought and what it cost, a sales log of what sold, where and for how much, and a fee table with each marketplace's rates and the date they took effect. Profit on a sale is the sale price minus the marketplace fees, the shipping label, the packaging and the item's cost.
Guide by ProfitStamp LLC · Updated · Fees as verified
What columns does the inventory list need?
One row per item. Bins and bundles get one row per piece, all sharing a lot ID.
- Item
- A short title you will recognise later.
- Source and date bought
- Where it came from and when, so you can see which sources pay off.
- Lot ID
- Ties the pieces of one bin or bundle together.
- Cost and prep cost
- What you paid and what cleaning or repair cost. A lot's price is split across its pieces.
- Status
- In stock, listed or sold, so unsold stock is easy to count.
What columns does the sales log need?
One row per order. You type what happened; the fee and profit columns work themselves out.
- Order number and date sold
- The date decides which fee rates apply.
- Marketplace
- Picks the fee rows for that marketplace.
- Item
- Links the sale to its inventory row and its cost.
- Sale price and shipping charged
- What the buyer paid. Several marketplaces take their fee on shipping too.
- Label and packaging cost
- What shipping cost you.
- Fees, net payout and net profit
- Worked out from the fee table and the costs, never typed by hand.
How do you work out marketplace fees?
Keep the fees in their own table: one row per marketplace, fee line and start date, with the official page it came from. Each sale looks up the rows in force on its date. When a marketplace changes a fee, add a new row with the new date instead of editing the old one, so the sales you already logged keep the fee they were charged.
One sale, worked through on eBay
A wool overcoat from a thrift store, sold for $58.00 with free shipping. eBay's fee rows as verified on October 31, 2026 against its official fee page: 13.6% of the sale plus shipping, and $0.40 per order.
| Sale price plus shipping charged | $58.00 |
|---|---|
| 13.6% of $58.00 | −$7.89 |
| Fixed fee per order | −$0.40 |
| Net payout from eBay | $49.71 |
| Label $4.50, packaging $0.30, item $14.00, cleaning $2.00 | −$20.80 |
| Net profit | $28.91 |
The same coat nets $34.84 on Depop and $25.60 on Poshmark, because each marketplace charges a different mix of fees. The free fee calculator runs any sale through all five, and each marketplace has its own page: eBay, Poshmark, Mercari, Depop and Etsy.
Each marketplace's official fee page: eBay, Poshmark, Mercari, Depop and Etsy.
Which Google Sheets formulas do the work?
Put the rates on a tab called Fees: marketplace in column A, the date the rate took effect in B, the percentage in C (as a decimal) and the fixed fee per order in D. On the Sales tab, row 2 holds one sale: date sold in A, marketplace in B, sale price in C, shipping charged in D, label in E, packaging in F and item cost in G. These formulas fill in the rest. None of them types a rate, so a fee change is one new row on the Fees tab.
- H2: fee rate
=INDEX(FILTER(Fees!$C$2:$C, Fees!$A$2:$A=B2, Fees!$B$2:$B<=A2), COUNTIFS(Fees!$A$2:$A, B2, Fees!$B$2:$B, "<="&A2))Finds the rows for this sale's marketplace that started on or before the sale date and takes the newest. Keep the Fees tab in date order, adding each change at the bottom.- I2: fixed fee per order
=INDEX(FILTER(Fees!$D$2:$D, Fees!$A$2:$A=B2, Fees!$B$2:$B<=A2), COUNTIFS(Fees!$A$2:$A, B2, Fees!$B$2:$B, "<="&A2))The same lookup, one column over.- J2: fees
=ROUND((C2+D2)*H2+I2, 2)The rate on the sale price plus the shipping charged, plus the fixed fee. For a marketplace that takes its fee on the price only, drop D2. eBay, Depop and Etsy also count the sales tax the buyer paid in at least one fee line, so the fee they charge can be a few cents higher than this.- K2: net payout
=C2+D2-J2What the marketplace pays you.- L2: net profit
=K2-E2-F2-G2The payout minus the label, the packaging and what the item cost.
Poshmark's flat fee under its threshold and fees with several percentage lines (Depop and Etsy add payment processing) need a second lookup per line. The fee calculator applies every line for each marketplace if you want to check a result.
Five mistakes that skew the numbers
- Typing a fee percentage into each formula. When the marketplace changes it, every formula is wrong at once and past sales change with it. Keep the rates in one table and look them up.
- Taking the fee on the item price only. eBay, Mercari, Depop and Etsy take a percentage on the shipping the buyer pays as well; Poshmark does not, because the buyer pays shipping to Poshmark directly.
- Calling the payout your profit. The payout still has to cover the label, the packaging and what the item cost.
- Copying rates from an old guide. Mercari dropped its separate payment processing fee and Depop dropped its US selling fee for new listings; older templates still charge both.
- Pricing just under a threshold. Poshmark charges a flat fee below its threshold and a percentage above it, so check both sides before you set a price.
Sources: Mercari's separate payment processing fee ended on January 6, 2025 (Mercari's fee page); Depop's US selling fee changed on July 15, 2024 (Depop's fee page). Every rate and its date is on the changelog.
Questions resellers ask
Is a spreadsheet enough, or do I need an app?
A spreadsheet is enough for most resellers: the inventory list, the sales log and a dated fee table cover profit per sale and per month. An app helps when you want your marketplace accounts to sync on their own; a spreadsheet keeps your data in your own Google Drive and needs no connection to any account.
Should the sale price include sales tax?
No. Type the price of the item and the shipping the buyer paid; the marketplace shows the tax separately. eBay, Depop and Etsy do count that tax when they work out at least one fee line, so their fee can be a few cents higher than the sheet's. How you report the tax depends on where you sell, so ask your accountant.
How do I record a return?
Keep the original sale row and mark it returned, then record what the marketplace kept or refunded as its own line. Fee refunds differ by marketplace, so check what was credited back before you change the numbers.
Where do expenses like mileage and supplies go?
In their own tab, one row per expense with a date and a category. They come off the month's total, not off a single sale.
How often do marketplace fees change?
Often enough that a template's built-in rates go stale. Mercari dropped its payment processing fee on January 6, 2025, and Depop's US selling fee changed on July 15, 2024. The changelog lists every rate on record with the date it took effect.
Build it yourself or start from ours
Everything above fits in a sheet you can build yourself; the fee table is the part that needs upkeep. The Profit Tracker is that sheet already built: inventory with lot splitting, sales, expenses, a Dashboard and the dated fee table for eBay, Poshmark, Mercari, Depop and Etsy, in one Google Sheet with no scripts or add-ons. The Profit Calculator is the fee math on its own, for checking an item before you list it.
Fees change. Check each marketplace's official page before you rely on a value; the changelog lists every rate on record with its date. Not affiliated with, endorsed by or sponsored by eBay, Poshmark, Mercari, Depop or Etsy. Not tax, accounting or legal advice.