What eBay spreadsheet searches want
The suggestions around "ebay spreadsheet" are nearly all about record-keeping: "template", "for sellers", "template free", "for taxes", "example", "upload". People clearing out a wardrobe or flipping a few finds want one sheet that shows what sold, what eBay took in fees, what postage cost and what's left. That's what this page provides.
It's a sideline for a site about the Usfans agent, so a clear boundary first: this page is for selling your own items. Reselling goods that copy someone else's trademark is illegal and against eBay's rules, and this site doesn't cover it.
Most searchers want a seller's tracking template.
A template you can copy
| Column | Enter | Why |
|---|---|---|
| Item | Short description and listing number | Find it in Seller Hub later |
| Bought for | What you originally paid, with date | Shows whether a sale was a gain |
| Sold for | Final sale price including postage charged | Gross amount eBay reports |
| eBay fees | Final value and other fees from the order | Real cost of selling |
| Postage paid | Label cost and packaging | Often forgotten, adds up |
| Net | Sold for − fees − postage | What you actually kept |
| Profit | Net − bought for | Taxable gain, if any |
eBay's Seller Hub can export order and payout reports; paste them into a second tab and look up fees by order number rather than typing them in.
Seven columns cover sales, costs and gain for most casual sellers.
The 1099-K rule in 2026
US sellers searched "ebay spreadsheet for taxes" through years of changing rules. The current position: the One Big Beautiful Bill Act, signed in July 2025, restored the original federal threshold. eBay must issue a Form 1099-K only if your gross payments exceed $20,000 and you have more than 200 transactions in a calendar year. Both tests must be met. Some states set lower thresholds of their own, so you can receive a form for state purposes below the federal line.
The threshold only decides whether eBay reports your totals. It doesn't decide whether you owe tax: profit from selling is taxable whether or not a form arrives, while selling personal items for less than you paid generally isn't a gain. That's why the "bought for" column matters. This is general information; a tax professional can apply it to your case.
Over $20,000 and 200 sales gets a federal form; records matter either way.
State thresholds and formulas that help
Federal rules aren't the whole picture. Several states set their own lower reporting thresholds; 2026 tax guides cite, for example, Illinois at $1,000 and four transactions and New Jersey at $1,000. eBay applies the lower state threshold for residents of those states, so you can receive a form for state purposes while far below the federal line.
A few formulas make the template do the work for you:
- Net per sale: sold for minus fees minus postage, in its own column so totals update automatically.
- Year totals: SUMIF on the date column to total gross sales and net by year.
- Transaction count: COUNTIF on the year to compare with the 200-transaction test.
- Gain flag: an IF that marks rows where profit is above zero, separating personal clear-outs at a loss from real gains.
Know your state's threshold, and let SUMIF and COUNTIF track the federal tests.
Outside the US
Sellers in the EU and UK face different reporting rules. Under the EU's DAC7 rules, platforms such as eBay report sellers who reach 30 sales or €2,000 in a year to tax authorities, and the UK applies similar reporting rules for digital platforms. As in the US, reporting isn't the same as owing tax: selling your own used belongings at a loss is generally not taxable income, but regular trading is. Keep the same "bought for" records.
EU and UK platforms report too; the same records answer any question.
Bulk uploads
"Ebay spreadsheet upload" refers to listing many items from a file. eBay's Seller Hub has bulk listing tools that accept spreadsheets in eBay's own template, downloadable from Seller Hub. Fill the template rather than your own layout; eBay rejects files with unexpected columns.
Bulk listing works, but only with eBay's template.
Buying on eBay vs through an agent
A few buyers compare eBay prices with ordering the same item from China through Usfans. eBay's Money Back Guarantee and local delivery cost something; an agent route is often cheaper for several items but slower, with duty paid on arrival and returns best handled before shipping. For US buyers, the New York shipping guide covers duties on parcels from China, and the shipping estimator helps compare totals. Our Usfans review lists the agent's fees and storage.
eBay buys protection and speed; an agent buys lower item prices.
Keeping the sheet useful all year
- One row per sale, entered when the item ships, not at year end.
- Keep receipts for what you originally paid, even photos of old receipts.
- Add a year-total row to compare with any 1099-K you receive.
- Separate personal clear-outs from items bought to resell; tax treatment differs.
For tracking purchases rather than sales, see our haul template on the SHEIN page.
Enter sales as they happen and keep proof of cost.
FAQ
Is there a free eBay spreadsheet template?
Yes: the columns on this page can be copied into Google Sheets or Excel. eBay's Seller Hub also exports sales reports you can paste in.
When does eBay send a 1099-K in 2026?
Federally, when gross payments exceed $20,000 and you have more than 200 transactions in the calendar year. Some states use lower thresholds.
Do I owe tax if I sell my own used things?
Selling personal items for less than you paid generally isn't a gain, but rules depend on your situation. Keep records of what you paid; a tax professional can confirm.
Can I bulk-upload listings from a spreadsheet?
eBay offers bulk listing tools in Seller Hub that accept spreadsheet files in its own template format.
What does eBay have to do with Usfans?
Little. Some buyers compare eBay prices with ordering through an agent. Reselling trademark-infringing goods on eBay is illegal and gets accounts banned.