✓ Instant download·PDF · Excel · Google Sheets·Full refund within 24 hours·PayPal & all major cards

Why does a 1099-K show more than you actually earned?

Because box 1a is the platform’s gross: refunds, platform fees, postage and the cost of the goods themselves are never subtracted, so the form can show a multiple of what you kept. In this workbook’s verified sample year, $48,000 of box 1a reconciles to $9,706.57 of Schedule C net profit — about 20 cents kept of each gross dollar — with every step of the other $38,293 accounted for and tied out to the cent (2,568 cell-level checks).

This is for United States FEDERAL tax, tax year 2026, and nothing else. A seller in Canada, the UK or the EU should stop reading here, and so should anyone filing for 2025. It says so in the product name, on the workbook title, on the first line of the first sheet, in a red banner across the top of all twelve sheets, and against every constant on the Sources sheet. It does not compute state or city tax and it does not model any state 1099-K threshold. Being unmistakably one thing is the point.

Here is the moment this product exists for. It is late January, a Form 1099-K lands, and box 1a says $48,000. You know perfectly well you did not make $48,000 — you cleared something under ten thousand — but you cannot prove it line by line, and the number on the form is the number the IRS already has. That gap is the single most common panic in reselling, and it has a boring, provable explanation: the IRS instructions say box 1a is reported "without regard to any adjustments for credits, cash equivalents, discount amounts, fees, refunded amounts, shipping amounts, or any other amounts." Your final value fees are inside it. Your refunds are inside it. The postage your buyer paid you is inside it. The form was never your income and was never meant to be.

So the flagship sheet walks the whole chain, per platform, and ties out: box 1a gross → refunds and cancellations → platform and final value fees → payment processing → shipping labels → other statement adjustments → net payout → cost of goods sold → mileage and every other expense → home office → Schedule C line 31. On the sample data that ships in the file, $48,000 of box 1a becomes $9,706.57 of actual profit, and the workbook shows every line in between. Print that page and staple it to your 1099-K; if anyone ever asks how one became the other, the answer is on it.

Nothing on the reconciliation sheet is estimated from a fee percentage, and that is deliberate. Fee schedules change several times a year and differ by category and by shipping label; while this file was being built, two aggregator sites disagreed about eBay's rate and eBay's own page said something different from both of them. A rate you typed in last March is a guess. Your statement is a fact. So the reconciliation uses only the figures you copy off your own statements, and fee rates appear nowhere near your tax figures.

The second half is the one nobody builds: inventory. Cost of goods sold is not what you spent on stock this year — it is what the items that actually SOLD cost you, and every item carries its own cost by specific identification. The workbook does the whole of Schedule C Part III from a plain item log: beginning inventory, purchases, items withdrawn for personal use, ending inventory, line 42. It also puts the number that hurts on the Dashboard: money you spent on stock that has not sold yet, and how much of that you bought in November and December. That is cash gone with no deduction until it sells, and knowing it in October is worth considerably more than $19.

Personal things stay out. Selling your own old coat for less than you paid is not a business loss and never was — IRC 165(c) disallows it — and selling it for more is a capital gain. Tick one box and the workbook keeps those rows off Schedule C entirely and reports them separately, which is exactly what a preparer needs and what almost every reseller template gets wrong.

Then the tax, with no "enter your tax rate %" cell anywhere — there is no such cell in this file and there never will be. Schedule SE lines 3 to 13 with the 92.35% adjustment and the 12.4% Social Security part capped at the $184,500 wage base for 2026. Form 8959 for the 0.9% Additional Medicare Tax. The 2026 rate schedules for all five filing statuses. The section 199A deduction on Form 8995-A, including the $400 minimum that applies for the first time in 2026. All three safe-harbour tests, which one binds, and the four estimated-tax due dates. Every rate is read off the Sources sheet, where it is printed with the IRS or SSA document it came from, the URL and the day it was checked.

One of those checks matters more than the rest. The IRS raised the business mileage rate mid-year: 72.5 cents to 30 June 2026 under Notice 2026-10, then 76 cents from 1 July under Announcement 2026-11. Almost every reseller spreadsheet on the market still carries one rate for the whole year and quietly loses you the difference. The Mileage Log here totals your miles separately either side of 1 July and applies both rates.

You can check every number, and we checked them for you. Behind the workbook is an independent Python model of the 2026 tax — the same one that powers our $29 tax engine, imported rather than retyped — and the build asserts twelve seller scenarios cell by cell against it: 2,568 comparisons to the cent, plus a full LibreOffice recalculation with zero formula errors both as shipped and with every input cleared. Twelve live reconciliations sit at the foot of the Schedule C Map sheet so you can see the file agreeing with itself. Where something could not be verified, the Sources sheet says so plainly: Poshmark's fee page could not be read when this file was built, so its preset row ships BLANK with the URL to read, rather than carrying a number nobody checked.

It ships filled in with a fictional three-platform reseller — $48,000 of box 1a across eBay, Poshmark and Mercari, 218 items logged, $3,720 of stock still unsold — so every sheet is alive the moment you open it. Clear the yellow cells and it is yours. Classic formulas only, so it behaves identically in Excel 2016 and later, Excel 365, Excel for Mac and Google Sheets. A six-page print pack comes with it in US Letter and A4, colour and ink saver.

What you get

  • United States FEDERAL tax, tax year 2026 only — stated in the product name, on the title, on every sheet header and against every constant
  • The 1099-K Reconciliation sheet: box 1a → refunds → fees → processing → shipping → COGS → Schedule C line 31, per platform, tied out to the cent
  • No "type your own tax rate" cell anywhere: every rate comes from a named IRS or SSA document with a URL and a verification date
  • 12 linked sheets, ~7,700 formulas — no macros, no add-ins, nothing locked
  • Cost of goods sold by specific identification over a 600-row item log — the whole of Schedule C Part III, lines 35 to 42
  • The number that hurts, on the Dashboard: stock you have bought that has not sold, and how much of it you bought in November and December
  • The federal 1099-K test done properly: gross over $20,000 AND more than 200 transactions, both strictly "exceeds" (IRS IR-2025-107)
  • And the caveat competitors skip: state thresholds are lower and differ — Massachusetts $600, Vermont $2,000, both from those states' own pages
  • Both 2026 mileage rates: 72.5 cents to 30 June, 76 cents from 1 July (IRS Announcement 2026-11), split automatically by trip date
  • Personal items kept OFF Schedule C: losses disallowed under IRC 165(c), gains reported separately as capital gains
  • Schedule SE in full: 92.35%, 12.4% to the $184,500 wage base, 2.9% uncapped, the $400 floor and the deductible half
  • Section 199A on Form 8995-A, including the $400 minimum new for tax year 2026, plus the three safe-harbour tests and the four due dates
  • Verified against an independent Python model: 12 seller scenarios, 2,568 cell-by-cell assertions, 0 recalculation errors as shipped and with every input cleared
  • Honest about its edges: the four platform fee schedules that could not be verified ship blank, and everything the workbook does not model is listed on the first sheet
  • Excel 2016+ and Google Sheets, plus a 6-page print pack in US Letter and A4, colour and ink saver

Preview every page

Click any page to zoom.

Online Seller Profit, COGS & 1099-K Reconciliation — US · Tax Year 2026 — Page 1
1 / 17
Online Seller Profit, COGS & 1099-K Reconciliation — US · Tax Year 2026 — Page 2
2 / 17
Online Seller Profit, COGS & 1099-K Reconciliation — US · Tax Year 2026 — Page 3
3 / 17
Online Seller Profit, COGS & 1099-K Reconciliation — US · Tax Year 2026 — Page 4
4 / 17

What's inside

Start Herehow it fits together, the six things worth knowing, and a plain list of everything this workbook deliberately does not do
Settingsfiling status, day-job W-2 wages, last year's tax and AGI, and your platform names
Dashboardbox 1a, what you actually made, what you owe, stock sitting unsold, and three charts
Inventory & COGSa 600-row item log costed by specific identification; Schedule C Part III lines 35 to 42; the personal-items block
Sales by Platformwhat each platform is really worth once its fees and your stock cost come off, and what you keep per $100 of box 1a
1099-K Reconciliationthe flagship: eight platform slots, the full waterfall, the two federal prongs, and a tie-out cell
Expensessupplies, storage, office, phone percentage, home office (simplified method with its income cap) and mileage
Schedule C Mapevery figure on its numbered IRS line, Part I, Part II and Part III, plus twelve live reconciliations
Tax & QuarterliesSchedule SE, Form 8959, the 2026 brackets, Form 8995-A, the safe harbour and the four payment dates
Mileage Log120 rows in IRS shape, totalled separately either side of 1 July for the two 2026 rates
Monthly Reviewtwelve rows: bought, spent, sold, margin, and stock still on hand at each month end
Sourcesevery constant with its IRS document, URL and verification date, the three quoted facts the product rests on, and a plain statement of what could not be verified
Print Pack6 pages, US Letter + A4, colour + ink saver, plus a Google Sheets set-up guide

Questions

Is this for my country?

No, unless you file a United States federal tax return. This is US federal tax for tax year 2026 only. It does not compute state or city income tax either. If that is not you, please do not buy it.

My 1099-K says far more than I made. Am I taxed on that?

No. Box 1a is gross — the IRS instructions say it is reported without any adjustment for fees, refunds, discounts or shipping. You are taxed on Schedule C net profit, which is what this workbook works out. On the sample data $48,000 of box 1a becomes $9,706.57 of profit, and every line in between is shown.

I sold under $20,000. Do I still have to report it?

Yes. The $20,000-and-200-transactions test decides whether a platform must send you a form. It has never decided whether you owe tax. Profit is taxable from the first dollar, and the workbook says so on the Dashboard whether or not a form is expected.

Does it know my state's 1099-K threshold?

No, and it says so on every sheet that mentions the test. State thresholds are lower and differ — Massachusetts is $600 with no transaction count, Vermont is $2,000, both read from those states' own revenue pages. A verified 50-state table could not be built when this file was made, and a partial table would be worse than none, because a seller in an unlisted state would wrongly conclude their state has no low threshold. Check your own state's revenue department. It changes nothing about what you owe.

Does it work out my platform fees for me?

Deliberately not. The reconciliation uses the fee figures on your own statement, because fee schedules change several times a year and vary by category and by shipping label. Fee rate presets appear only in the pricing section, and every number there was read from the platform's own fee page on 25 August 2026 — eBay (13.6% + $0.30/$0.40), Etsy (6.5% transaction + 3% + $0.25 US processing + $0.20 listing), Mercari (10%) and Depop (0% selling fee + 3.3% + $0.45 processing). Poshmark's page could not be loaded when this file was built, so its row ships blank with the URL to read, rather than printing a figure nobody checked.

What is 'specific identification' and why does it matter?

Every item carries its own cost, so cost of goods sold is the cost of the exact things that sold — not an average and not FIFO. On one of the test scenarios specific identification gives $1,850 where FIFO would say $1,800. It is also the method that actually fits one-off resale goods, where no two items cost the same.

I bought a lot of stock in December. Can I deduct it?

Not until it sells. It sits in ending inventory. This is the most expensive thing resellers get wrong, so the workbook puts it on the Dashboard as its own number, with the November–December portion broken out.

I sold some of my own old things too. What happens to those?

Tick 'Personal item?' on the row. The workbook keeps them off Schedule C entirely: a loss on personal property is not deductible under IRC 165(c), and a gain is a capital gain for Form 8949 and Schedule D. They are reported in their own block so you can hand them to a preparer separately.

Does it have a 'what's your tax rate' cell?

No, and it never will. Schedule SE, Form 8959, the 2026 rate schedules and Form 8995-A are all computed in full, and every rate is read off the Sources sheet where it is printed with the IRS or SSA document it came from and the day it was verified.

Why are there two mileage rates?

Because the IRS changed it mid-year. Notice 2026-10 set 72.5 cents a mile; Announcement 2026-11 raised it to 76 cents for miles driven on or after 1 July 2026. The Mileage Log totals your miles separately either side of that date and applies both rates. A one-rate spreadsheet understates the second half of your year.

Does it handle quarterly estimated taxes?

It computes all three safe-harbour tests, tells you which one binds, gives you the required annual payment and four equal instalments on the four 2026 due dates. It does not compute Form 2210 Schedule AI, the annualised method for a lumpy year — that is a separate, larger workbook, and this one says so rather than approximating it.

How do I know the numbers are right?

An independent Python model of the 2026 tax sits behind the file, and the build asserts twelve seller scenarios against it cell by cell — 2,568 comparisons to the cent — then recalculates the whole workbook in LibreOffice with zero formula errors, both as shipped and with every single input cleared. Twelve live reconciliations sit at the foot of the Schedule C Map sheet so you can watch the file agree with itself.

Reviews

No reviews yet — this product is new. Every review here comes from a verified purchase.

Personal-use license for one household. No resale or redistribution. Delivered as a ZIP download immediately after payment. No physical item will be shipped.

Excel & Google Sheets · Microsoft Excel 2016 and later, Excel 365, Excel for Mac, and Google Sheets (upload to Drive → File → Save as Google Sheets). Classic formulas only — no macros, no add-ins, nothing locked. Print pack in US Letter and A4, colour and ink saver.

Online Seller Profit, COGS & 1099-K Reconciliation — US · Tax Year 2026

United States federal, tax year 2026 only. The 1099-K says $48,000. You know you did not make $48,000. This is the workbook that shows exactly where the other $38,000 went — refunds, platform fees, postage, and the cost of the goods themselves — and lands on the Schedule C number you are actually taxed on.

$19

Pay with PayPal or any card

PayPalVISAMastercardAMEX
  • United States only · tax year 2026
  • Download link on the confirmation page and by email
  • What you need: Microsoft Excel 2016 and later, Excel 365, Excel for Mac, and Google Sheets (upload to Drive → File → Save as Google Sheets). Classic formulas only — no macros, no add-ins, nothing locked. Print pack in US Letter and A4, colour and ink saver.
  • Full refund within 24 hours — just message us, no reason needed
  • 6 pages
  • 12 sheets · 7,727 formulas
  • Formats: .xlsx (Excel 2016+, Google Sheets) + PDF guide
  • ZIP: 510 KB
Also in The Everything Bundle Get 45 products for $59 — you save $571.78 vs buying separately. View bundle →
♡ Full refund within 24 hours

Ask within 24 hours of paying and we refund the whole amount — no form, no reason needed. Up to 30 days we still refund, minus the 4% payment processing fee. Files that will not open are always refunded in full, with no time limit.