1099 Sorted / 1099-K reconciler

Your client crossed $20,000. Now someone has to prove what actually happened.

Built for bookkeepers and CPAs reconciling 1099-Ks for Stripe and Square merchant clients — not a consumer app for gig workers. Upload the 1099-K and the processor's transaction export. Get a clean, workpaper-ready reconciliation in minutes instead of an afternoon per client.

1099-K, Box 1a (processor gross)$54,208.00
Schedule C, Line 1 (matches Box 1a)$54,208.00
Line 2 — Returns and allowances$3,860.00
Line 3 — Net receipts (Line 1 − Line 2)$50,348.00
Fees — Line 10 expense, not a receipts offset$1,500.65
Variance vs. Box 1a$0.00

Gross receipts on Line 1 are held equal to Box 1a. Refunds move to Line 2. Fees are deducted as a business expense elsewhere on the return — never netted against receipts. Anything that doesn't reconcile is flagged for documentation, not quietly absorbed.

One reconciliation engine. Four reasons to open it.

The same check — processor, bank and books — applies whenever a number has to be proven. Start from whichever situation you're in today.

Jan – Apr

The 1099-K doesn't match the books

The form becomes the checksum for a year of activity: Box 1a against the processor's own transaction history and the client's books.

May – Oct

A CP2000 or mismatch notice arrived

The same workpaper, labeled for notice response, once the letter is already on the desk.

Nov – Jan

Who needs a 1099-NEC, and is the TIN even formatted right?

Vendor totals against the threshold for the payment year, plus a TIN format check before January 31.

All year

Stripe or Square vs. the books and the bank

Monthly close for every merchant client, with a fee-change flag and a sales-tax nexus watch. The other three doors are this check, run at a deadline.

The federal threshold is $20,000 and 200 transactions — but your client's state may be lower

The federal $600 rule never took effect: the One Big Beautiful Bill Act repealed it retroactively in July 2025. But several states, including Maryland, Massachusetts, Vermont and Virginia, still require a 1099-K at $600, so a client well under $20,000 can still receive one. Either way, the form is the number you reconcile against. See the state thresholds →

$20,000
and 200+ transactions — the federal threshold, restored for every year since 2022. Some states still require a form at $600 or $1,000
12×/yr
reconcile processor activity every month at close, not just once at tax time
4+
processors the average multi-channel merchant client runs through
Oct 15
extension deadline — the same reconciliation still applies to extended returns
May–Oct
CP2000/notice season — this is the same workpaper the IRS is asking you to produce

Run a client reconciliation right now

Saved locally in this browser — pick a client and tax year to keep reconciliations organized across busy season. Work in progress is saved automatically as you type, so a refresh won't cost you the afternoon.

Switching computers or browsers?

Everything here lives only in this browser. Export it to move your whole client list and reconciliation history to another device — still nothing ever touches a server.

1

Enter what your 1099-K forms report

Upload your 1099-K PDFs and 1099 Sorted will read the amounts for you — including scanned copies, via OCR. You can add more than one at a time.
2

Add the Stripe (or Square) transaction history

Upload the CSV — Stripe's itemized/balance report (Gross, Fee, Net, Type or Reporting Category, Created) is the primary supported format; a plain Stripe Charges export and Square's Transactions CSV (Gross Sales, Fees, Tax, Partial Refunds) also work. If you upload a payout report instead, it will tell you — payouts are batched and net of fees, so they can't reconcile against Box 1a.
3

What do the client's books show?

The number recorded as revenue for this period in QuickBooks or wherever the client's books live — not from Stripe, not from the 1099-K. This is what makes it a three-way reconciliation instead of a two-way one.

4

Result

Enter your 1099-K totals and transaction history above, then press Reconcile.

Monthly close: reconcile processor activity all year, not just at tax time

The same engine that catches a Box 1a mismatch in April catches an unrecorded Stripe deposit in June. Run this every month at close and a client's books never drift far enough from their processor to become a January surprise — no 1099-K required, since it's just checking processor gross against what's booked for that period.

Putting a client on monthly close? Generate an engagement-letter draft →

1

Add this month's Stripe (or Square) transaction history

Upload the CSV for this month only, or paste it below. Same formats as the annual tool: Stripe's itemized/balance report, a plain Charges export, or Square's Transactions CSV.
2

What hit the bank this month? (optional)

The actual deposit total from the bank statement for this period. This catches payout-timing issues a two-way check misses — a payout that straddles month-end lands in the bank a different month than the sale itself. Leave blank to skip and run the simpler two-way check.

3

What do the books show for this month?

Revenue recorded for this specific month in QuickBooks or wherever the client's books live.

4

Result

Add this month's transaction history above, then press Reconcile.

Put a client on monthly close: draft the engagement letter

A finished reconciliation is a one-off. A monthly close is a service the client agrees to and you bill for. Fill in the fields and copy a plain-language draft to adapt to your firm's own engagement-letter standard. It is a starting template, not legal advice, so have your own counsel or professional-liability carrier review it before you send it.

Built in your browser as you type. Nothing you enter here is saved or sent anywhere.

1099-NEC issuance check: who crossed the threshold, and is their TIN even valid?

A different direction of the same problem: instead of reconciling a 1099-K your client received, this checks vendor payments your client made — who needs a 1099-NEC issued to them by January 31, and whether the TIN on file is even formatted correctly before you find out from an IRS rejection notice.

1

Paste this year's vendor payment ledger

One row per vendor, or one row per payment — either works. Needs at minimum a vendor name/TIN and an amount column; multiple payments to the same vendor are summed automatically.

Paste a vendor payment ledger above, then press Check.

Sales tax economic nexus: which states has this client crossed?

A non-seasonal companion to the 1099-K work — a client selling across state lines can trigger a sales tax registration obligation in a state without ever setting foot there, once cumulative sales cross that state's threshold. Enter this year's sales by state below and this flags which thresholds are already crossed.

1

Enter this client's sales by state for the year

Most Stripe/Square exports don't break sales out by state, so this is entered by hand or pulled from a state-tagged sales report. Add a row per state with any sales this year.

Add sales by state above, then press Check thresholds.

2026 threshold reference (all states)

Most states: $100,000 in annual sales. Exceptions below. Some states also apply a transaction-count test (commonly 200/year) alongside or instead of the dollar figure — check the state's own rule before relying on the dollar threshold alone. Five states have no statewide sales tax at all. Last verified against multiple current sources, August 2026 — thresholds and rules change; this is not tax advice, confirm with the state's Department of Revenue before registering or not registering.

Start with one reconciliation. Keep it as a monthly service.

The $15 reconciliation is the way in. The firm license is for firms that put clients on monthly close: the year-end 1099-K then becomes the tie-out of twelve closes already done, not a fresh project in January. Everything runs in your browser — client 1099-Ks and transaction history are never uploaded to a server, on any plan.

$15 / reconciliation
  • One client, one engagement
  • Unlimited 1099-K forms and processors for that client
  • Workpaper PDF and transaction CSV export
  • Processed entirely in-browser — nothing you upload leaves your machine

By purchasing you agree to the Terms of Service. 1099 Sorted reconciles numbers — it doesn't file anything or represent you before the IRS.

$79 / month
  • Firm license — unlimited clients, monthly close all twelve months
  • Year-end 1099-K workpapers, plus the notice-response version when a CP2000 arrives
  • Bank-deposit check, fee-change flags, unresolved-gap queue and sales-tax nexus watch
  • Processed entirely in-browser — client data is never uploaded to a server

By subscribing you agree to the Terms of Service. Billed monthly via Stripe; cancel anytime from your Stripe receipt/customer portal link.

Already subscribed? We'll email you a link to unlock exports on this device (works on any browser or device — no password needed):

Terms of Service

Plain language, not a wall of boilerplate. This is what you're actually agreeing to.

What this is

1099 Sorted is a reconciliation aid. You give it a 1099-K total and a transaction history; it shows you what matches, what doesn't, and produces a workpaper documenting the difference. That's the whole job.

We don't file. You do.

1099 Sorted does not prepare, sign, or submit any tax return. It does not determine a filing position, does not represent you or your client before the IRS or any state agency, and is not a substitute for professional judgment. You — the preparer, bookkeeper, or business owner using this tool — remain fully responsible for reviewing every figure and for the return you or your client ultimately files.

No accuracy guarantee

The reconciliation depends entirely on the 1099-K amounts and transaction data you provide. Column detection and categorization are automated and can misclassify a row, especially on export formats not explicitly listed as supported. Always review the transaction detail before relying on a result, and treat any flagged variance as something to resolve, not something to override.

How your data is handled

Every calculation happens in your browser. Nothing you upload or paste — 1099-K PDFs, transaction CSVs, client names — is sent to a server; there is no server in this flow to send it to. Saved clients and reconciliations are stored in your browser's local storage only. That means: they persist across refreshes and restarts on this device, but they are not backed up, not synced to another device or browser, and are permanently lost if you clear your browser's site data. Export your workpapers if you need a durable copy.

Payment and refunds

The $15 per-reconciliation purchase covers one client engagement, as described at the time of purchase. If the tool fails to produce a reconciliation for a file in a supported format, contact support for a refund. Refunds are not offered for dissatisfaction with a correctly-computed variance — the tool's job is to surface discrepancies accurately, not to make them disappear. The Firm License renews monthly (or yearly, on the annual plan) until you cancel; cancelling stops the next renewal and keeps access until the end of the period already paid. See the full Terms of Service for refund windows.

Limitation of liability

1099 Sorted is provided as-is, without warranty of any kind. To the maximum extent permitted by law, we are not liable for penalties, interest, audit outcomes, or other damages arising from a filed return, whether or not this tool was used to prepare figures for it.