To reconcile eBay sales for 1099-K tax reporting, match every sold order to a payout line, then subtract fees, shipping, refunds, and cost of goods sold (COGS) to get your taxable profit. The 1099-K reports gross payments, so it will almost always be higher than what you actually earned.
Consider a reseller with a $48,000 1099-K. Add up what the form leaves out: $6,200 in eBay fees, $5,100 in shipping labels, $2,300 in refunds, and $19,500 in item cost. Taxable profit is closer to $14,900, not $48,000. But only if you can prove each number. This post shows how to build that proof monthly, not in a panic on April 10.
A note: we're not your accountant. This is an operations workflow. Confirm tax treatment with a qualified preparer.
What the 1099-K actually reports (and what it leaves out)
The 1099-K is a payment-volume form. It tells the IRS how much money moved through your account. It does not know what you paid for inventory, and it generally does not net out your costs. Check your form and your eBay reports for how your own figure was built, because treatment of fees, shipping, and refunds is where totals drift apart.
The reporting threshold has also changed over the years and has been subject to legislative and IRS adjustments. Check the current IRS guidance for the tax year you are filing. More importantly for resellers: even if you never receive a 1099-K, the income is still reportable. The threshold decides whether a form is issued, not whether you owe tax on profit.
1099-K gross vs net sales: where the gap comes from
Here is a simple year-level bridge from the form to profit. Numbers are an example, not a benchmark.
| Line | Example amount | Source to check |
|---|---|---|
| 1099-K gross amount | $48,000 | Tax form |
| Less: refunds issued to buyers | -$2,300 | Order refund report |
| Less: eBay fees (final value, ad fees, store) | -$6,200 | Transaction report |
| Less: shipping labels purchased | -$5,100 | Label purchase history |
| Less: COGS (item cost basis) | -$19,500 | Your inventory records |
| Taxable profit (before other expenses) | $14,900 | Schedule C math |
Fees and shipping are typically deductible business expenses, and COGS reduces gross receipts. How you report each line on Schedule C depends on your situation, so confirm with a preparer. The point is that every row needs a paper trail you can export.
Why payouts never match sold items one-to-one
Three mechanics break the match:
- Timing. An item sold on December 29 may pay out in January. Sales and payouts land in different months.
- Bundled deposits. One bank deposit can cover many orders, minus fees and adjustments.
- Partial refunds and returns. One sale becomes two ledger lines. A buyer who gets $15 back on a $60 sale leaves you with a $45 net, and the item may or may not return to inventory.
If you only compare bank deposits to your 1099-K, you will find a gap and no way to explain it. Reconcile at the order level instead.
Track cost basis for eBay tax filing
COGS is the biggest deduction and the weakest record for most resellers. A $4 thrift find with no receipt still has a cost, but you need a consistent way to record it. Capture these at sourcing time:
- Purchase price, date, and source (store, estate sale, bundle lot)
- Lot allocation: a $40 bundle of 8 items is $5 each, or weighted by expected value
- Cleaning, repair, and supply costs you attach to the item
- A SKU that follows the item through listing, sale, and any return
Condition also touches this. An item you grade Fair instead of Very Good often sells lower or comes back. If your records tie a SKU to its grade across Fabric Condition, Structural Integrity, Cosmetic Appearance, Functional Elements, and Odor & Cleanliness, you can see which refunds trace back to a grading miss. That makes the refund line explainable, not just a number.
The 6-step monthly reconciliation routine
Do this in the first week of each month. Budget about 45 minutes for 150 orders once the habit is set.
- Export last month's eBay transaction report. Include orders, fees, shipping labels, refunds, and payouts. Save the file with the month in its name.
- Match each order to a payout. Tag every sold item as paid out, pending, or held. Anything sold in the month but unpaid carries to next month's pending list.
- Attach cost basis to every sold SKU. If a sold item has no cost on file, fix it now while you remember the purchase. Use a documented estimate only when you have no receipt, and note it as an estimate.
- Log refunds and returns separately. Record the refund amount, the reason, and whether the item went back into inventory. A returned item at NWOT or Excellent resells; one now at Poor may be a write-off.
- Total the month: gross, fees, shipping, refunds, COGS, profit. Run it per item and in aggregate. Flag any item with negative profit.
- Compare the running year-to-date gross to the 1099-K estimate. eBay shows year-to-date figures. If your gross sales plus pending differ from theirs by more than a few percent, investigate that month now.
[Screenshot placeholder: monthly reconciliation view showing orders, payouts, fees, refunds, and COGS in one table]
Reseller tax records checklist
Keep these for the number of years your tax advisor recommends. Store digital copies where you can retrieve them.
- Monthly eBay transaction and payout reports (CSV and PDF)
- Purchase receipts, or a dated log for cash and no-receipt buys
- Lot allocation notes for bundles
- Shipping label and supply purchase records
- Refund and return log with reasons
- Mileage log for sourcing trips, if you deduct it
- Inventory count at year end, valued at cost
- Your final year-end bridge from 1099-K to profit
Common mismatches and what to do
1099-K is higher than your sales total. Check whether it includes sales tax collected, shipping charged to buyers, or refunded amounts. Compare against your gross report, line by line.
You got two 1099-Ks. Resellers using eBay and another processor can get multiple forms. Add them up and reconcile each separately. Don't assume overlap.
Personal items sold at a loss. If part of the form is garage-sale clutter sold below cost, keep records showing the original cost and sale price. Ask your preparer how to report it.
Unsold inventory at year end. It stays on the shelf at cost. Don't deduct it as COGS until it sells, unless your preparer advises otherwise.
Try it on one month first
You don't need to rebuild your books. Pick last month, run the six steps, and see how many sold items lack a cost basis. That number tells you how far you are from defensible. FlipDesk's Reconcile module pulls orders, payouts, fees, and refunds into one per-item P&L so you can run this routine without a spreadsheet. Try it on a single month and see what it finds.