1099 conversion is a tax-season bottleneck — a single client can hand you a stack of 1099-NEC, 1099-MISC, 1099-INT, 1099-DIV, 1099-B, and a consolidated brokerage 1099. Below: the step-by-step (recipient + payer + amounts extract correctly), the variants and what they need, and how to batch a tax-season envelope in one upload.
Convert your first 1099 — free
1099 forms come in seven common variants (1099-NEC, MISC, INT, DIV, B, R, K) plus the consolidated brokerage 1099 (DIV/INT/B/MISC sections combined into one document). Each has different boxes, different field meanings, and different tax-prep destinations. The consolidated 1099 is particularly painful — a Schwab year-end is 30+ pages with separate sections for ordinary dividends, qualified dividends, short-term cap gains, long-term cap gains, wash sales, foreign tax paid, and supplemental cost basis.
Generic PDF tools either flatten the form into one column of text or extract only the first page (missing the long-form sections). Tax software lets you hand-key the boxes — but for a tax preparer with 100 client envelopes during March, hand-keying every 1099 is the busy-season bottleneck. The fix: a tool that knows 1099 structure end-to-end, including consolidated brokerage forms with multiple sections.
Step 1: Identify the 1099 variant. NEC = nonemployee comp (most common for contractor income). MISC = miscellaneous income (rent, royalties, prizes). INT = interest income. DIV = dividend income. B = brokerage proceeds (cap gains). R = retirement distributions. K = third-party network payments. Consolidated 1099 = brokerage year-end with multiple sections.
Step 2: Upload to PDFExcel. Sign in with Google or Microsoft (no card). Drop the 1099(s) — single form or full client envelope. Multiple variants in one batch upload work — the tool tags each row with the form type.
Step 3: Pick the columns. Defaults extract Recipient (Name + TIN), Payer (Name + EIN), each box value, and form-variant tag. For consolidated 1099s, each section (DIV / INT / B / MISC) extracts as its own grouping. Add custom fields (e.g., 'extract any backup-withholding flag') if your workflow needs it.
Step 4: Drop into your tax software. Excel/CSV imports into Drake, Lacerte, ProConnect, UltraTax, ATX, and most major tax-prep tools as a 1099 batch. Saved column preset reuses across all client envelopes during busy season.
Common pitfalls. Consolidated 1099 sections sometimes span pages — make sure the tool reads all pages (PDFExcel does; Adobe Acrobat default export sometimes stops at page 1). Backup withholding in Box 4 is easy to miss in manual entry — preserved automatically. Wash-sale adjustments on 1099-B detail are critical for cost basis — extracted as their own column. State withholding (Boxes 16-18) varies by state — extracted by box number for state-tax-prep workflow.
Consolidated brokerage 1099s (Schwab, Fidelity, Vanguard, E*TRADE, Robinhood) extract section-by-section — DIV / INT / B / MISC each tagged separately. Run a tax-season batch upload mixing 1099s from 4 custodians + W-2 + K-1 in one client envelope — one workbook back with everything tagged.
If you're picking a tool, here's what to evaluate.
Mixed-variant batch from one client envelope: NEC + INT + DIV + B from multiple payers. Form-type column tags each row; Box columns map by variant. Drop into tax software as a batch.
| # | Form | Recipient | Payer | Box | Amount |
|---|---|---|---|---|---|
| 1 | 1099-NEC | Smith, John (XXX-XX-1234) | Acme Logistics LLC | Box 1 — Nonemployee Comp | $48,200.00 |
| 2 | 1099-INT | Smith, John (XXX-XX-1234) | First Federal Savings | Box 1 — Interest Income | $1,820.40 |
| 3 | 1099-DIV | Smith, John (XXX-XX-1234) | Schwab Brokerage | Box 1a — Ordinary Div | $3,420.18 |
| 4 | 1099-DIV | Smith, John (XXX-XX-1234) | Schwab Brokerage | Box 1b — Qualified Div | $2,980.00 |
| 5 | 1099-B | Smith, John (XXX-XX-1234) | Fidelity Brokerage | Box 2 — LT Gain | $8,420.40 |
Tax preparers handling client envelopes, CPA firms supporting individual high-net-worth clients, fractional CFOs preparing 1099s for issuance, individual taxpayers who DIY tax prep.
100 client envelopes, average 4-6 1099s per envelope. Batch upload all envelopes at month-start; convert to Excel; load into UltraTax via saved import. ~3 days saved across the busy season vs hand-keying.
High-net-worth client with 7 brokerage accounts across Schwab, Fidelity, Vanguard. Consolidated 1099 from each. PDFExcel converts all 7 in one batch; Schedule D / Form 8949 entries reconcile across custodians.
Single brokerage Robinhood consolidated 1099 + 1099-INT from bank. PDFExcel free tier (10 docs/month) covers it; Excel ready for TurboTax import in minutes.
Yes — consolidated 1099s from Schwab, Fidelity, Vanguard, E*TRADE, Robinhood, Merrill, TD Ameritrade, Interactive Brokers all extract section-by-section. DIV / INT / B / MISC each tagged separately. See brokerage statements and 1099 forms for the broader workflow.
Yes — 1099-B detail extracts row-by-row with date acquired, date sold, proceeds, cost basis, wash-sale adjustment, and short-term vs long-term flag. Critical for Schedule D / Form 8949 entry.
Excel/CSV exports work with Drake, Lacerte, ProConnect, UltraTax, ATX 1099 batch import. Set up a saved import mapping per software once; reuse across clients during busy season.
10 documents per month, free, forever. No card. Most DIY taxpayers fit free; small CPA practices fit Starter at $69/50 docs; busy-season tax preparers fit Pro at $199/200 docs or Business at $699/1000.
Yes. Drop the envelope as a ZIP — W-2 + multiple 1099s + K-1 + consolidated brokerage 1099 all together. Get back one Excel with everything form-tagged. See batch processing for the broader workflow.