SMBDashboardFree eBay profit tracker template
eBay's payout is not your profit, because it leaves out what you paid for the item. This is a plain CSV that fixes that: one row per item, each carrying its share of the lot it came from, plus the fees, label, ad fee and refund on its order. Open it in Excel, Google Sheets or Numbers. It is the companion to eBay seller profit tracking: from cost basis to payout.
Free. No email, no account.
The columns
- lot_id
- A label for the sourcing trip, so every item from one purchase groups together.
- lot_cost
- The total you paid for the whole lot, repeated on each item row.
- item
- What you listed.
- expected_value_share
- This item's share of the lot as a decimal (0.30 for 30%), from its expected resale price divided by the lot's total expected resale. The shares in a lot add to 1.00.
- sale_price
- What the buyer paid, including shipping if you offer free shipping.
- ebay_final_value_fee
- The final value fee on the order, from your Earnings report.
- per_order_fee
- The per-order fee on the order.
- shipping_cost
- The label you paid for, including labels bought outside eBay.
- ad_fee
- Promoted listing fee for the order, if you ran an ad.
- refund_return
- Money refunded to the buyer.
- net_profit
- Calculated for you in the blank template. Sold rows subtract the item's allocated cost; returned rows do not, because the item is back in stock.
- status
- Sold, Returned or Unsold. The profit formula reads this.
The lot-allocation method
A lot has one price and several items, so the cost has to be split. This template uses the split weighted by expected resale value: look at recent sold prices, estimate what each item should fetch, and give each item that share of the lot cost. A $60 box where the five items are expected to sell for $60, $50, $40, $30 and $20 (total $200) gives shares of 0.30, 0.25, 0.20, 0.15 and 0.10, and costs of $18, $15, $12, $9 and $6. Pick the method once and use it on every trip so your numbers compare. The full guide covers the equal split, returns and unsold stock.
The worked example
The example file is that $60 estate sale box taken to the last row: three items sold (one with a promoted listing), one sold and returned, one still on the shelf. It ends with profit so far of $60.16, $15.00 of stock still on the shelf at cost, and a cash position of $45.16. Cash plus stock at cost lands on the same $60.16, which is the check that the books agree. The fee figures are the ones the guide verified on 20 October 2026; open eBay's live fees page before you rely on a rate, and use the figures from your own Earnings report.
Or keep the trips and payouts in the dashboard
If you would rather not maintain a spreadsheet, log each sourcing trip as an expense and each payout as income in the money view, and the profit tile shows whether the shelf is paying.
Questions
How is the cost of a lot split across items?
Each item gets a share of the lot cost in proportion to what you expect it to sell for. Add up the expected prices, divide each by the total, and multiply by the lot cost. The allocated costs must add back to exactly what you paid. Set them once at listing time and do not change them after you see which item sold.
What happens to a returned item?
The sale is removed, the label you already paid is a real loss, and the item's cost goes back to stock instead of being written off. In the template, a Returned row counts the refund and costs but not the allocated lot cost.
Do I need Excel?
No. The files are plain CSV and open in Excel, Google Sheets, Numbers or LibreOffice. The net_profit column in the blank template is a standard formula that fills in once you type the other columns.
Are the fee figures in the example current?
The example uses the fee figures from the linked guide, which were verified against eBay's selling fees page on 20 October 2026. Category rates differ and eBay changes them, so check eBay's live fees page before you rely on any rate. Replace the fee columns with the actual figures from your own Earnings report.
This is arithmetic, not tax or accounting advice. Written by Mark Fulton.