← 1099-K Reconciliation Worksheet
This worksheet vs. reconciling 1099-Ks yourself in a spreadsheet
The arithmetic is the same either way: Box 1a, minus refunds and marketplace-remitted sales tax, minus your costs, equals estimated net profit. The difference is whether that structure already exists when you sit down with two or three 1099-Ks in January, or whether you build it from scratch and hope you remembered both adjustments for every platform.
What each approach actually does
A spreadsheet can produce exactly the same reconciled figure as this worksheet — subtracting refunds, marketplace-remitted sales tax, fees, cost of goods sold, and shipping from a gross figure is not exotic math. What a blank spreadsheet does not give you is a reminder that Box 1a includes two specific things that were never your income, or a place that already applies the same two adjustments identically across every platform's 1099-K instead of however carefully each row happened to be built that year.
This worksheet is that structure already built, with a built-in finding whenever the non-income adjustments look unusually large relative to Box 1a — the case a from-scratch spreadsheet is most likely to miss because nothing prompts for it.
| Question | Where to answer it |
|---|---|
| What does one platform's 1099-K actually reconcile to? | This worksheet's per-platform result — free, private, no account. |
| I sell on several marketplaces and want one combined figure. | This worksheet's combined total across every row you add. |
| My situation has a wrinkle this worksheet doesn't model (foreign currency, a platform that already nets refunds into Box 1a). | A spreadsheet you build yourself — it can represent any rule you can describe. |
| Is this my final tax liability? | Neither. Both stop at an estimate; your tax preparer confirms it. |
| Is my data uploaded anywhere? | No. Everything runs in your browser; your figures stay on this device. |
This tool needs no account and no sign-in: it is a static page, the arithmetic runs in your browser, and nothing you type is uploaded anywhere.
Common questions
Isn't a spreadsheet just as accurate as this worksheet?
A correctly built one is — the arithmetic is Box 1a minus refunds minus marketplace-remitted sales tax minus your costs, which is ordinary subtraction. The risk is not the math, it is remembering that Box 1a includes sales tax you never kept and refunds you already gave back, and backing both out consistently across every 1099-K you received, often months after the sales happened and without the platform breaking either figure out clearly on the form itself.
When is a spreadsheet actually the better choice?
When your situation has a wrinkle this worksheet does not model — a marketplace that reports in a currency other than dollars, a platform that already nets refunds into Box 1a itself so backing them out again would double-count, or business income from outside any of these platforms entirely. A spreadsheet you build yourself can represent any rule you can describe. This worksheet trades that flexibility for a form that already has the right fields for the common case: one or more marketplace 1099-Ks, each needing the same two non-income adjustments backed out.
What does a blank spreadsheet not remind you to do that this worksheet does?
Back out marketplace-remitted sales tax as its own line, separate from refunds. It is easy to remember refunds — you know which sales came back — and easy to forget that a chunk of Box 1a was never your money at all because the marketplace collected and paid the sales tax on your behalf. A spreadsheet built from scratch has no built-in prompt for that second adjustment; this worksheet raises a specific finding whenever the two adjustments together are an unusually large share of Box 1a, which is exactly the case a rushed spreadsheet is most likely to under-subtract.
Does this replace my tax preparer or a filed return?
No, and it is not built to. This worksheet and a spreadsheet both stop at estimating net profit from the 1099-K figures you supply — neither one knows your other income, your filing status, or your actual tax liability. That determination still belongs to you and, if you use one, your tax preparer, working from verified figures rather than either tool's estimate.
Open the reconciliation worksheet, or see why the gap between Box 1a and your actual income exists.