List with SKU first so every bin pull starts from your system, not eBay search.
eBay guide
eBay inventory spreadsheet for SKUs, fees, shipping, and returns.
Build one worksheet row that connects your internal SKU, eBay item ID, bin location, buyer payment, label cost, promoted listing fee, return status, and true profit. This keeps Seller Hub exports and manual notes from living in separate places.
eBay worksheet columns
Track final value fees, payment processing, promoted listing fees, and shipping as separate columns.
A B C D E F
| Field | Category | Tracks | Example |
|---|---|---|---|
| SKU | Inventory | Internal stock number used to connect the listing, bin, and sale record. | EX-SKU-001 |
| Item Title | Inventory | Short listing title or product description. | Example denim jacket |
| Platform | Listing | Marketplace where the item is listed or sold. | eBay |
| Listing or Item ID | Listing | Marketplace listing identifier for lookup, returns, and reconciliation. | EXAMPLE-ITEM-ID |
| Date Listed | Listing | Date the item first went live so aging inventory is easy to review. | 2026-05-01 |
| List Price | Listing | Current asking price before offers, discounts, or promoted listing fees. | $38.00 |
| Purchase Cost | Cost | Item-level cost of goods before platform fees and shipping. | $12.00 |
| Bin Location | Storage | Shelf, tote, rack, or box location used to pull sold items quickly. | BIN-A03 |
| Sold Date | Sales | Date the order was paid or accepted. | 2026-05-21 |
| Sale Price | Sales | Buyer-paid item price before marketplace deductions. | $36.00 |
eBay guide intro advertisement
The eBay row should reconcile the whole order
eBay sellers need more than a title and sale price. Item IDs help find orders and returns, shipping columns show whether buyer-paid postage covered the label, and separate promotion fees make promoted listing tests measurable.
| Field | Use it for | Example |
|---|---|---|
| SKU | Use one internal SKU per item before listing. | EX-EBAY-BIN-A03-014 |
| Item ID | Paste the eBay item ID after the listing goes live. | EXAMPLE-ITEM-ID |
| Shipping | Compare buyer-paid shipping with the actual label cost. | $7.95 charged / $6.85 cost |
| Returns | Mark returned, refunded, cancelled, or kept. | Returned - relist |
Record shipping charged and shipping cost separately before reviewing profit.
Move returned items to a cleanup status before relisting, donating, or writing off.
Formula guidance
eBay profit formulas
Use buyer-paid shipping, actual label cost, marketplace fees, and promoted listing fees as separate inputs.
A B C D E F
True profit
Shows item-level cash profit after cost, prep, shipping, fees, and promotion costs.
=Sale Price + Shipping Charged - Purchase Cost - Prep Cost - Shipping Cost - Marketplace Fee - Promotion Fee
Use buyer-paid shipping as revenue only when it is listed separately from the item price.
Gross margin
Compares profit quality across categories, sources, and marketplaces.
=Net Profit / Sale Price
Format the cell as a percentage and review low-margin rows before sourcing more similar items.
Sell-through rate
Measures how much listed inventory sold during the period you are reviewing.
=Sold Items / Listed Items
Run this on a weekly or monthly summary tab, not on each item row.
Days to sell
Flags stale inventory and shows how quickly each SKU turns into cash.
=Sold Date - Date Listed
Leave the cell blank until the item sells so active listings do not distort averages.
When shipping becomes daily work
A dedicated 4x6 thermal printer pays off when shipping labels become daily work and handwritten postage starts hiding true profit.
Shop Rollo printers on eBay eBay guide upgrade advertisement
Other marketplace worksheets
Switch sheets if you also sell on another platform. Each guide keeps the same SKU and profit structure.
eBay inventory spreadsheet FAQ
What columns should an eBay inventory spreadsheet include?
Use SKU, eBay item ID, title, bin location, purchase cost, list price, sale price, shipping charged, shipping cost, marketplace fee, promoted listing fee, return status, and net profit.
How should I track eBay fees in a spreadsheet?
Keep marketplace fee and promotion fee in separate columns so final value fees, payment deductions, and optional promoted listing costs do not hide the true profit on each order.
When should I upgrade from an eBay spreadsheet?
Upgrade when manual item ID matching, return cleanup, shipping reconciliation, or crosslisted status updates take longer than listing and sourcing work.
eBay guide FAQ advertisement