The 1099-K a marketplace sends the IRS is almost always bigger than the money that reached your bank — and nothing on the form explains why. This workbook explains it, line by line.
Why your 1099-K doesn’t match your deposits
Both numbers are correct. They measure different things.
Box 1a reports gross payment volume — everything a platform processed on your behalf, before a single fee, refund, discount or shipping charge comes out. Your bank shows what was left standing at the end. The difference between them is real, it is explainable, and until you have explained it you are filing a figure you cannot defend.
The gap is made of five things: platform fees, refunds you issued, shipping the buyer paid and the labels you bought, sales tax a marketplace collected and remitted for you, and timing — a sale on December 29 that settles on January 3 sits in one year’s form and the other year’s bank statement. That last one is the reason most reconciliations never quite close, and it is the one no general bookkeeping template handles.
What the workbook actually does
It walks the reported gross down to your bank
The 1099-K Bridge starts from the Box 1a figure your platform reported and subtracts each reconciling item in front of you — refunds, then transaction, listing, processing, advertising, shipping-label and adjustment fees, each summed from your own ledger. It compares the result against what you actually banked, applies the two timing lines, and leaves an unexplained variance with a computed status and a next action that names the real dollar figure rather than telling you to investigate.
It separates the sales tax you owe from the sales tax you don’t
Under marketplace facilitator laws, a platform like Etsy collects and remits sales tax on your behalf. That money never passes through your account and it is not your income. Your own website, your craft-fair table and your wholesale orders are not covered by that, and the tax you collect there is yours to remit.
Sales Tax by State comes pre-filled with all 52 US sales-tax jurisdictions — each with its own rule and its state source, and where one applies, its real economic-nexus threshold, its transaction trigger, its lookback period and a link to that state’s own Department of Revenue guidance. You fill in what you sold; the verdict and the action are computed. There is also a tie-out that checks the figures on that tab against your Settlement Ledger, because the same money is entered in two places and the two should agree.
It puts every fee on the right Schedule C line
Fees to Schedule C maps each fee bucket to the line it belongs on — advertising to Line 8, commissions and fees to Line 10, postage and shipping to Line 27a — and totals them from your ledger. It also flags the double-count that costs sellers the most: shipping labels bought through a platform are often already deducted from your payout and itemized on the fee statement, so claiming the label as an expense while treating the net payout as income deducts it twice.
What it is, and what it isn’t
This covers the marketplace side of your return. It reconciles your forms, your payouts and your fees, and it produces Schedule C Lines 1, 2 and 3 with the derivation shown beside each figure. Cost of goods, materials, home office and mileage are not in this workbook — bring those from wherever you already track them.
For reference, the federal threshold is more than $20,000 in gross payments AND more than 200 transactions, per platform — but a form arriving, or not arriving, changes nothing about what you owe. It is a reconciliation and record-keeping tool, not tax advice. Every figure in the worked example is illustrative, reporting thresholds and state rules change, and a tax professional takes it from here.
Own it, don’t rent it
A blank spreadsheet is free, and every formula, threshold and fee rule is yours to research and build. Bookkeeping software is monthly, forever, and your figures live in someone else’s account. This sits between the two: one payment, eleven connected tabs, 52 sourced jurisdictions and the method in five printed guides. It doesn’t expire, nothing is locked, and every formula is yours to read and change.
Next January you start from a copy of this year’s file instead of from a blank sheet and a stack of CSV exports.
Outgrown a once-a-year reconciliation? Ardent Seller (opens in new tab) is the living version of this workbook — every Etsy, Shopify and marketplace payout landing in one ledger as it happens, already split into gross, fees, refunds, tax and net deposit. There’s a free plan to start.
