One row per sale
Sold price, what you paid, eBay fees, label and supplies sit on one row, and the workbook fills in the fee math and net profit.
Free template
Free eBay sales and profit spreadsheet for Google Sheets and Excel.
One row per sale, with columns for the sold price, what you paid, eBay fees, the label, supplies and net profit. Download the CSV or the workbook with formulas, and open it in Google Sheets or Excel. Nothing is uploaded: the CSV is built in your browser.
At a glance
What is in the template
Google Sheets and Excel
Open the workbook in either one, or use the plain CSV. No macros, and nothing is uploaded.
Columns match Strooply's import
The first group of columns uses the names Strooply's CSV import recognizes, so a saved CSV maps without renaming.
Download
Download the template
Two files, same columns. The workbook calculates fees and profit for you. The CSV is a plain table you can paste or import anywhere. Both start with three rows of sample numbers, marked SAMPLE, to show the format. Delete them and enter your own sales.
Title,eBay Item ID,Custom SKU,Status,Listing Price,Sold Price,Sold Date,Listing Date,Purchase Price,Purchase Date,Purchase Location,Storage Location,Purchase Lot,eBay Fees,Quantity Sold,Condition,Brand,Platform,Notes,Order Number,Shipping Charged to Buyer,Sales Tax Collected,Ad Rate Percent,Label Paid by Seller,Supplies Used,Fee Base,Percent Fee,Per-Order Fee,Promoted Ad Charge,Net Profit,ROI SAMPLE 1900 Robinson Crusoe Rhead Edition,,S-001,Sold,55.00,50.00,2026-03-14,2026-02-20,12.00,2026-02-10,Estate sale,Shelf B,Sample lot,8.29,1,Used,Example Brand,eBay,"Sample numbers, delete this row",,8.00,0.00,0,7.50,1.00,58.00,7.89,0.40,0.00,29.21,2.4343 SAMPLE cast iron skillet,,S-002,Sold,40.00,35.00,2026-03-18,2026-02-20,6.00,2026-02-12,Thrift store,Shelf B,Sample lot,7.43,1,Used,Example Brand,eBay,"Sample numbers, delete this row",,0.00,2.80,5,11.20,1.50,37.80,5.14,0.40,1.89,8.87,1.4782 SAMPLE paperback bundle,,S-003,Sold,9.00,8.00,2026-03-20,2026-02-20,3.00,2026-02-15,Garage sale,Shelf B,Sample lot,3.12,2,Used,Example Brand,eBay,"Sample numbers, delete this row",,4.00,0.00,0,3.90,0.50,20.00,2.72,0.40,0.00,6.48,1.0800
To open the CSV in Google Sheets, choose File, then Import, then Upload. In Excel, choose File, then Open. The workbook opens in Excel directly, and in Google Sheets through File, then Import. The files carry no macros and make no network calls.
What goes where
What each column is for
The first group uses the same column names Strooply's CSV import recognizes, so a file saved from this template maps without renaming. Dates are easiest to read as YYYY-MM-DD. Strooply treats a row as sold when it has a sold price or a sold date, and you can also pick the Status column yourself in the mapping step.
| Column | What to enter | Example |
|---|---|---|
| Title | The listing title or a short name | 1900 Robinson Crusoe Daniel Defoe Harper & Brothers Rhead Edition |
| eBay Item ID | The item number from the listing | Leave blank if unknown |
| Custom SKU | Your own label for the item | BIN4-017 |
| Status | Active or Sold | Sold |
| Listing Price | The price you listed at | 55.00 |
| Sold Price | The price one item sold for, before shipping and tax | 50.00 |
| Sold Date | The date of the sale, YYYY-MM-DD | 2026-03-14 |
| Listing Date | The date you listed it, YYYY-MM-DD | 2026-02-20 |
| Purchase Price | What you paid for one unit | 12.00 |
| Purchase Date | The date you bought it, YYYY-MM-DD | 2026-02-10 |
| Purchase Location | Where you bought it | Estate sale |
| Storage Location | Bin, shelf or room | Shelf B |
| Purchase Lot | A name for the lot or trip it came from | March estate sale |
| eBay Fees | All eBay fees on the order: final value fee, per-order fee and ad fee | Calculated from the columns to the right in the workbook |
| Quantity Sold | How many units sold on this row | 1 |
| Condition | Condition as listed | Used |
| Brand | The brand | Example Brand |
| Platform | Where it sold | eBay |
| Notes | Anything you want to remember | Sample numbers, delete this row |
| Order Number | The eBay order number | Leave blank if unknown |
The second group is for your own math. Strooply's import ignores these columns and works out profit itself from the cost and fees it imports, so they do not need to be removed. The label and supplies columns are not imported.
| Column | What to enter | Example |
|---|---|---|
| Shipping Charged to Buyer | Shipping the buyer paid you | 8.00 |
| Sales Tax Collected | Sales tax eBay collected on the order | 0.00 |
| Ad Rate Percent | Your Promoted Listings ad rate for this sale as a number, or 0 | 0 |
| Label Paid by Seller | What you paid for the shipping label | 7.50 |
| Supplies Used | Box, tape and other supplies for this order | 1.00 |
| Fee Base | Calculated: item price times quantity, plus shipping and sales tax | Calculated |
| Percent Fee | Calculated: the final value fee percentage applied to the fee base | Calculated |
| Per-Order Fee | Calculated: eBay's fixed fee for the order | Calculated |
| Promoted Ad Charge | Calculated: ad rate times the fee base | Calculated |
| Net Profit | Calculated: what is left after fees, label, supplies and cost | Calculated |
| ROI | Calculated: net profit divided by the total you paid for the units sold | Calculated |
The math
How to work out profit per sale
Net profit = item price x quantity + shipping charged to the buyer - eBay fees - label - supplies - what you paid for the item
eBay charges its fees on the total sale amount, which includes the item price, the shipping the buyer pays and any sales tax. In this template, sales tax is used only to work out the fee amount, and the Net Profit formula above does not add it in. eBay also adds a fixed per-order fee, and an ad charge applies if you promote the listing. The ad charge is a percentage of the total sale amount.12
The workbook starts with the fee level for Most categories for sellers without an eBay Store: 13.6% of the sale total up to $7,500.00 per item, then 2.35% on the part over that, plus $0.30 per order when the order total is $10.00 or less, and $0.40 above that. Store fees differ, and so do other categories and seller levels. These figures were checked on September 27, 2026. Change the numbers on the Settings sheet to match your category.
As an illustration, here is what the three sample rows work out to. These are sample numbers, not a prediction for any item.
| Sample row | Item and shipping paid | eBay fees | Label and supplies | Purchase cost | Net profit |
|---|---|---|---|---|---|
| SAMPLE 1900 Robinson Crusoe Rhead Edition | $58.00 | $8.29 | $8.50 | $12.00 | $29.21 |
| SAMPLE cast iron skillet | $35.00 | $7.43 | $12.70 | $6.00 | $8.87 |
| SAMPLE paperback bundle | $20.00 | $3.12 | $4.40 | $6.00 | $6.48 |
For the arithmetic on a single sale in any category, use the eBay fee calculator. To split one receipt across several items, see the guide on splitting a receipt across items, and for how cost is counted, the cost of goods sold guide.
Outgrow the sheet? Import it into Strooply. Get the app
Check your sheet
Mistakes that make sheet profit wrong
- Taking the fee on the item price only. eBay counts shipping and sales tax in the amount its fee is charged on.
- Leaving out the per-order fee, which applies to every order.
- Taking the ad charge on the item price only, when it applies to the total sale amount.
- Forgetting the label. If the buyer paid shipping, count that as revenue and the label as a cost.
- Putting a whole lot's cost on one item, or on none. Spread it across the items it covers.
- Using a fee rate from a different category or Store level than the one the sale was in.
Keep it importable
Keep the sheet ready to import
- Use one row per sale or per order line.
- Use Active or Sold in the Status column.
- Keep the header names as they are. A bare Date, Location or Item column can be read as the listing date, the storage location or the title.
- Save the Sales sheet as CSV UTF-8. Strooply's import reads CSV files, not .xlsx.
- Order Number is read only when your account has the newer import enabled, so it is safe to leave in the file but do not rely on it yet.
When the sheet gets heavy
Move the sheet into Strooply
Strooply's CSV import is on every plan in the app. You upload the file, review how each column maps, and confirm. Strooply works out profit from the cost and fees it imports. After that, sales and eBay charges can be brought in from your connected eBay account instead of typed. See how Strooply works for what it does today.
Mileage
Sourcing trips
For a mileage log, use the template on the sourcing mileage calculator page.
Questions
Spreadsheet template questions
How do I keep track of my eBay sales?
Keep one row per sale with the sold price, the date, what you paid for the item, the eBay fees, the label and any ad charge. The template has a column for each. Strooply can instead pull sales from eBay once you connect your account.
Can I use this in Google Sheets?
Yes. In Google Sheets choose File, then Import, then Upload, and pick the CSV or the workbook. The columns and sample rows come across, and the workbook's formulas work in Sheets.
Does the template calculate eBay fees?
The workbook does, using the fee settings on its Settings sheet for sellers without a Store in Most categories. Your category, Store and seller level may use other rates, so check the figures against your order or the fee calculator. The CSV has no formulas, so type the fee from your order there.
Can I import my own spreadsheet into Strooply?
Yes, as a CSV file. Strooply shows how each column of your file maps to its fields and you review the mapping before anything is imported.
Why is there a CSV and not only an Excel file?
Strooply's import reads CSV files, not .xlsx. Use the workbook for the formulas, then save the Sales sheet as CSV UTF-8 when you want to import it.
Is there a mileage log?
Yes. The sourcing mileage calculator page has a separate mileage log template you can download.
Outgrow the sheet? Import it into Strooply
Strooply is an app for eBay resellers that identifies items from photos, shows live comps and sold-price estimates, drafts eBay listings for your review, and tracks costs and profit.
Get the app
A free plan is available.
Sources
Where these facts come from
- eBay, Selling fees, ebay.com/help/selling/fees-credits-invoices/selling-fees
- eBay, Promoted Listings general campaign strategy, ebay.com/help/selling/ebay-advertising/promoted-listings/general-campaign-strategy, checked October 21, 2026