Bank statements for tax preparation: the 1099 reconciliation workflow

If you run an LLC or sole-proprietorship and receive 1099-NEC or 1099-K forms from clients and platforms, the February tax-prep ritual looks roughly the same every year: download twelve months of business bank statements as PDFs, receive 1099s that may or may not agree with your books, try to reconcile the delta, and hope the whole thing lines up for Schedule C before the April deadline. The statement-download-to-usable-spreadsheet step is where most of the friction lives.

The specific pain: tax software (TurboTax Self-Employed, H&R Block, a good CPA's workflow) wants a CSV of bank transactions it can categorise. The bank gives you PDFs. The gap is manual retyping or an unreliable OCR pass. Every year the same 12 hours disappear into this step. It's the step that's easiest to automate correctly, and the one where an accuracy mistake costs the most — a miscategorised or missing $8,000 client payment changes your taxable income directly.

The 1099 reconciliation check you actually want

The specific reconciliation that matters for tax prep isn't just balance-level. It's: for each 1099 you received, does there exist a matching deposit (or sum of deposits) in your bank statement? The 1099 says Client X paid you $12,400 during 2024. Your bank statements should show that $12,400 arriving — maybe as one wire, maybe as 11 monthly $1,127.27 invoices, maybe with a few reversals. If the sum doesn't match the 1099, one of three things is true: the client mis-reported, you missed a deposit, or the timing spans the calendar-year boundary (paid in late December, received early January).

A reconciled CSV from pdftoexcel, dropped into a pivot table grouped by Description, turns this reconciliation into a 5-minute job. Every recurring originator shows as a row in the pivot; the sum column ties directly against the 1099 amounts. Discrepancies surface immediately with the specific month and transaction the delta lives in — which is what you need to write back to the client if the 1099 needs a correction, or to claim the payment on the correct year's Schedule C if it's a timing issue.

Schedule C categorisation works best with a clean Description column

Every expense in your business checking account maps to a Schedule C line — Advertising, Car and truck, Insurance, Legal and professional services, Office, Supplies, Utilities, Travel, Meals. The Description column in a clean XLSX export ("STRIPE FEE," "AMZN MKT PLACE," "AT&T MOBILITY," "GOOGLE SERVICES") maps cleanly to category with a small amount of lookup-table work the first time, and with near-zero work in subsequent years because you've already built the mapping. OCR'd descriptions — where "AT&T" may have become "AIST" — break this workflow entirely.

Special note on 1099-K threshold changes

The 1099-K reporting threshold for third-party payment processors (Stripe, PayPal, Venmo-for-business) has been moving: it was $20,000 / 200 transactions pre-2024, dropped to $5,000 for 2024, $2,500 for 2025, and $600 thereafter. This means many sole proprietors who never received a 1099-K before are now getting one, and the number on it may or may not match what they think they earned. A reconciled export against the bank statements is the only way to verify the 1099-K is correct — because the 1099-K aggregates gross payments, not net, so the number is almost always larger than what you "feel" you earned.

Year-end workflow in under an hour

The clean version: download 12 months of business bank statements as a single merged PDF (most business-banking portals do this under "combined statement" or "annual statement"). Upload to pdftoexcel, download the reconciled XLSX. Pivot by Description, categorise the top 20 recurring originators (which almost always account for 90% of both income and expense), sum each Schedule C line, hand to your CPA or drop into your tax software. Total time: 45-60 minutes for a moderately busy sole proprietor. Previous time, by hand: the rest of the weekend.

Convert your annual business statements — 15 free pages, no card