Know what you actually make on every order
Revenue isn't profit. This spreadsheet takes each sale and subtracts platform fees, shipping labels and what the product cost you, so you can see which products and which channels really pay. It works for Etsy, Shopify, Amazon, eBay and your own site.
| Order | Channel | Order total | Fees | Shipping label | Product cost | Profit | Margin |
|---|---|---|---|---|---|---|---|
| 2 × mug | Etsy (US) | 42.50 | 4.69 | 7.20 | 8.40 | 22.21 | 52.3% |
| 1 × tote | Shopify Basic | 24.80 | 1.02 | 4.80 | 3.10 | 15.88 | 64.0% |
| 3 × candle | Amazon | 72.00 | 20.46 | – | 17.25 | 34.29 | 47.6% |
What's inside
- Orders. One row per product sold. Pick the channel and SKU from dropdowns; the total, fees, product cost, profit and margin fill themselves in. Margins under 20% turn amber and losses turn red.
- Products. Cost and price per SKU, live stock count, and a Reorder or Out of stock flag when you hit your reorder point. Plus units sold and profit per product this year.
- Restock. Log stock as it arrives. Stock isn't counted as a cost until it sells, so a big order from your supplier doesn't make the month look like a loss.
- Overheads. Platform plans, ads, apps and packaging. They come off on the dashboard to give you true net profit.
- Dashboard. Revenue, fees, product cost, overheads and net profit for the year, a month-by-month table and chart, and a breakdown by sales channel.
- Check column. Flags any order row that's missing something, so totals don't go quietly wrong.
The fee rates it starts with
The Fee Settings tab estimates fees from these US rates. Each one was checked in October 2026. Etsy blocks automated checks, and Shopify shows card rates only in a browser, so those two came from published summaries. Confirm them on your own account. They're in yellow cells, so you can change them if your rates differ.
| Channel | Estimate used | Source |
|---|---|---|
| Etsy | 6.5% transaction + 3% & $0.25 payment processing + $0.20 listing renewal per item | Etsy fees |
| Shopify Payments | 2.9% + 30¢ (Basic), 2.7% + 30¢ (Grow), 2.5% + 30¢ (Advanced) | Shopify pricing |
| Amazon | 15% referral fee (most categories) | Amazon selling fees |
| eBay | 13.6% (no Store or Starter Store) or 12.7% (Basic Store and up) + $0.40 per order ($0.30 if $10 or less) | eBay selling fees |
| Stripe | 2.9% + 30¢ | Stripe pricing |
| PayPal Checkout | 3.49% + 49¢ | PayPal fees |
Some fees depend on the order, so they're not in the estimate. Etsy Offsite Ads (12–15%), Amazon FBA fees and ad spend per order go in the Extra fees column. For exact numbers, copy the fee from your payout report into Actual fees and it replaces the estimate for that order. Rates outside the US are different, so update the Fee Settings tab if you sell elsewhere. Etsy's processing fee and eBay's final value fee are also charged on sales tax, so with tax-free prices the estimate runs slightly low.
Using it
- Add your products on the Products tab: SKU, cost per unit, selling price and how many you have.
- Check the rates on Fee Settings for the channels you use.
- Delete the sample rows (they're marked “sample”) and start logging orders.
- For an order with several products, use one row per product and the same order number on each. Put shipping on the first row. Fixed per-order fees are only charged once.
In Google Sheets: upload to Drive, right-click → Open with → Google Sheets, then File → Save as Google Sheets. In Excel or LibreOffice, just open it.
Good to know
- Enter prices without sales tax. Etsy, Amazon and eBay collect and pay US sales tax on marketplace orders for you. Check whether you still have to register in your state.
- Net profit here is before income tax and before you pay yourself.
- It's a planning tool, not accounting software. For your books and taxes, the bookkeeping template is the better fit.
Related reading
- How to sync Shopify with eBay, including how to price for eBay fees and free shipping
- An ecommerce manager should be looking at the whole business
Want someone to run the store side?
I manage Shopify, Etsy and Amazon stores day to day, from listings and inventory to ads and the numbers behind them. If your margins look worse than they should, message me and I'll take a look.
E-commerce Profit Tracker
Excel .xlsx · 590 KB · Works with Google Sheets, Excel and LibreOffice