Your Client's Stripe 1099-K Doesn't Match the Books. Here's the Actual Fix.
A client's Stripe 1099-K lands, and it agrees with nothing — not the number in QuickBooks, not what the client remembers, not last year's pattern. Before you start adjusting anything, it helps to separate this into the two gaps it actually is, because they have different causes and different fixes.
This is two problems, not one
Treating "the numbers don't match" as a single mystery is how reconciliations turn into a full afternoon. There are two distinct comparisons to make, and conflating them is the usual reason a preparer ends up guessing:
Gap 1: Does Box 1a match what Stripe itself says? Pull Stripe's own transaction history — the itemized or balance-transaction export, not a payouts report — and sum the gross charge amounts. This should equal Box 1a almost exactly. If it doesn't, the cause is on the Stripe side: a second connected account under the same TIN, a timing cutoff at year-end, or activity the export you pulled doesn't include.
Gap 2: Does Stripe's gross match what's recorded as revenue in the books? This is a completely different question, and it's a bookkeeping issue, not a Stripe issue. Common causes: Stripe activity that was never recorded, revenue booked on an accrual basis while Stripe reports on a cash/transaction basis, or postings that landed in the wrong period.
Why this distinction matters
If you collapse both gaps into one adjustment, you can end up "fixing" Gap 2 by changing a number that was actually explained by Gap 1 — or vice versa. Worse, if you paper over the combined gap by adjusting Schedule C Line 1 directly, you've created a new problem: the IRS matches Line 1 against Box 1a, not against your adjusted number. A clean-looking return with a Line 1 that doesn't match the 1099-K on file is exactly the pattern that generates a CP2000 notice.
The rule that resolves most disputes with yourself
Line 1 stays equal to Box 1a. Always. Whatever doesn't reconcile gets documented as a separate item — refunds and chargebacks go to Line 2, fees are a deductible expense elsewhere on the return (commissions and fees, not a receipts offset), and anything genuinely unexplained gets a note in the file, not a silent adjustment to gross receipts.
What a real Stripe reconciliation needs
- The 1099-K total (Box 1a)
- Stripe's itemized/balance-transaction export for the same period — gross, fee, and category per transaction, not a payouts summary
- The books' recorded revenue for the same period
- A place to document whichever gap doesn't close, because "I couldn't fully explain $340 of this" is a legitimate, filable answer — silence about it is not
Doing this without a spreadsheet every time
Building this three-way comparison by hand for one client is manageable. Doing it for forty clients in six weeks is not. 1099 Sorted takes the 1099-K total, the Stripe export, and the books figure, and produces both gaps and a signed workpaper — without ever touching Line 1.