Why doesn't my payout match my sales?
Because a deposit is never just your sales. It's a bundle, and every channel bundles it differently:
- Fees, stacked. Several kinds of fees come out before the deposit is computed. They don't arrive as separate charges you can see — they're inside the one number that lands, which is why sellers say the payout hides its own fee structure.
- Timing. Refunds are deducted from a later payout than the sale. Chargebacks arrive from sales in earlier months. A deposit compared against this week's orders will never match — the money in it belongs to several different weeks at once.
- Reserves (Etsy). A reserve withholds part of a payout and releases it into a later one, so two deposits in a row look wrong in opposite directions.
- The second settlement file (TikTok Shop). Part of a payout can settle in a separate file. Miss that file and the payout never adds up, no matter how carefully you check the first one.
- Sales tax that looks like income (your own store). Marketplaces remit the tax they collect. Your own store leaves it in your account, where it sits looking exactly like your money until it's time to hand it over.
None of these are mysteries once you compare the right two things: not the deposit against your memory of sales, but the deposit against its own statement, line by line.
The method: four moves, every payout
- Statement. Open the payout's own statement — the deposit detail or settlement report for that payout.
- Lines. Enter every line exactly as the statement names it: gross, each fee, refunds, chargebacks and adjustments, reserves withheld and released.
- Net. The sheet computes the expected net from the statement's own math.
- Bank match. Enter the deposit exactly as it posted. The variance must be $0.00. If it isn't, the built-in Variance Hunt — a checklist ordered by where missing money actually hides — walks you to the line you haven't seen yet.
A payout that reconciles to zero is a payout you understand completely: every dollar that left has a name. Rolled up across the year, the system gives you a payout log for every channel, a monthly close that ties to your bank, a sales-tax tracker (collected, marketplace-remitted, still held) and an income-tax set-aside tracker, and a 1099-K & year-end page whose totals are already true — because every payout behind them reconciled.
Why is my 1099-K higher than my books?
It's supposed to be. The form reports on the marketplace's basis — before the fees, refunds, and adjustments your book separates out — so the two numbers differ by an amount you should be able to explain line by line. The system's year-end page puts that comparison in writing in advance: form gross, book gross, the difference, and the explanation. Sellers who reconcile all year meet January with a page that was true before the form arrived, instead of a shoebox and a reconstruction project.
Spreadsheet, service, or software?
Bookkeeping services will do this for you every month, at a monthly price, forever. Software will import your payouts automatically — and you'll still be the one who has to understand a variance when one appears. This is the third option: a spreadsheet system (Excel and Google Sheets) that teaches the discipline and then holds you to it. You enter the lines; it does the math and the checking. It prints no fee rates, on purpose — rates change quietly, and a rate printed in a workbook becomes wrong while the workbook still looks right. Your statement always shows what you were actually charged, so the math runs on your statement's own numbers.
The system ships in two versions: a blank workbook, and the same workbook completely filled in for a fictional seller — a candle shop working Etsy, TikTok Shop, her own Shopify store, and Gumroad through a full quarter, every closed payout reconciled to $0.00 — so you can see exactly what "done" looks like before you enter a single number of your own. A one-page quick-start guide and a companion guide that explains why every page exists are included.
General information and organizing only — not tax, legal, or financial advice. Marketplace fees, rules, and forms change; your statements and your preparer are the authority. This system does not file taxes and does not track inventory or cost of goods — it reconciles payouts, which is the job it was built for.
Marketplace Seller Bookkeeping System — $49 launch
Reconcile every Etsy, Gumroad, Shopify, and TikTok Shop payout to the penny: channel worksheets built from each channel's real lines, the Variance Hunt, a monthly close that ties to your bank, sales-tax and income-tax set-asides, and the 1099-K comparison page. Blank workbook + filled demo + both guides.
Get the SystemPrefer Etsy? The Marketplace Seller Bookkeeping System is in the SquaredSheets Etsy shop too.