Document Guide

Convert 1099-DIV Forms to Excel

Upload consolidated brokerage 1099-DIV forms and get a structured spreadsheet with box 1a, 1b, 2a, 3, 4, 5, 6, 7, and 11 values pulled out automatically.

1099-DIV forms report ordinary dividends, qualified dividends, capital gain distributions, and foreign tax paid — but they rarely arrive as a single clean document. Most investors receive a consolidated 1099 from their brokerage that bundles 1099-DIV with 1099-INT and 1099-B on the same pages, sometimes across multiple accounts or payers. pdfexcel.ai reads these PDFs (digital or scanned) and extracts the box-level dividend data into a row-per-payer Excel or CSV file, so you can total ordinary dividends for Schedule B or hand off structured data to a tax preparer without retyping every box.

Who This Is For

  • Tax preparers consolidating multiple clients' 1099-DIV forms into one working spreadsheet before Schedule B prep
  • Individual investors with dividend income spread across several brokerages (Fidelity, Schwab, Vanguard, Merrill) who need one combined total
  • Bookkeepers reconciling year-end dividend income for small business investment accounts
  • Accountants who need box 7 foreign tax paid figures pulled out separately for Form 1116

When This Is Relevant

  • During tax season (January–April) when brokerages send consolidated 1099 packages
  • When reconciling dividend income across multiple accounts before filing Schedule B
  • When a tax preparer receives 10-20 client PDFs and needs the box data in one file instead of opening each one
  • When importing dividend totals into tax prep software that accepts spreadsheet uploads

Supported Inputs

  • Digital PDF 1099-DIV forms (brokerage-generated or IRS fillable)
  • Scanned or faxed paper 1099-DIV copies
  • Photos of printed 1099-DIV forms taken on a phone
  • PNG or JPEG screenshots of downloaded tax documents

Expected Outputs

  • Excel (.xlsx) file with one row per payer/account showing box 1a, 1b, 2a, 3, 4, 5, 6, 7, and 11 values
  • CSV export formatted for import into tax software or a master client tracking sheet

Common Challenges

  • Consolidated brokerage statements mix 1099-DIV with 1099-INT and 1099-B on the same pages, so the DIV section has to be correctly isolated rather than pulling every number on the page
  • Households with joint accounts or multiple payers generate several separate DIV blocks inside one PDF, each needing its own row
  • Scanned or faxed copies can shift box alignment slightly, which sometimes causes box 1a and 1b values to be misread if the scan is skewed
  • Foreign tax paid (box 7) is occasionally reported with different decimal or currency formatting depending on the brokerage template

How It Works

  1. Upload one or more 1099-DIV PDFs, scans, or photos — including full consolidated brokerage statements
  2. AI locates each payer's 1099-DIV block and reads box labels (1a, 1b, 2a, 3, 4, 5, 6, 7, 11) rather than just scraping raw text
  3. Preview the extracted rows and adjust field selection if you only need specific boxes, like 1a and 4
  4. Export to Excel or CSV with one row per payer/account, ready for Schedule B totals or tax software import

Why PDFexcel.ai

  • Handles multi-payer consolidated statements instead of assuming one 1099-DIV per file
  • Custom field selection lets you extract just the boxes you need (e.g., only 1a and 7 for foreign tax credit work) instead of every field
  • Batch processing means a preparer can run 15-20 client PDFs in one pass instead of opening each individually
  • Files are encrypted and deleted after processing, which matters when handling client tax documents with SSNs and account numbers

Limitations

  • Complex multi-page consolidated statements from major brokerages that interleave 1099-DIV, 1099-INT, and 1099-B sections may need a manual review pass to confirm section boundaries were read correctly
  • Heavily skewed or low-quality scans can misalign box numbers, so straightening the scan before upload improves accuracy
  • Non-standard or custom broker layouts (some robo-advisors format 1099-DIV differently than traditional brokerages) may require field customization to map correctly
  • Handwritten corrections or annotations on a paper 1099-DIV are unlikely to be read reliably

Example Use Cases

  • A tax preparer converts 15 clients' consolidated 1099-DIV PDFs into one master Excel file with a row per client for Schedule B prep
  • An individual investor with dividend accounts at Fidelity, Schwab, and Vanguard combines all three 1099-DIVs into one spreadsheet to total box 1a for the year
  • A bookkeeper extracts box 1a and box 4 (federal tax withheld) from a client's 1099-DIV to reconcile against brokerage year-end statements
  • An accountant pulls box 7 foreign tax paid across several international fund holdings to support a Form 1116 foreign tax credit calculation

Frequently Asked Questions

Can I convert a consolidated 1099 that includes 1099-DIV, 1099-INT, and 1099-B sections?

Yes. Upload the full consolidated PDF and the AI identifies the 1099-DIV portion specifically by reading box labels rather than pulling every number on the page. You can also use custom field selection to limit the export to just dividend boxes if the file also contains interest or brokerage sale data you don't need right now.

Does it handle 1099-DIV forms for multiple accounts or payers in one PDF?

Yes, if the document contains multiple payer blocks (common with joint accounts or multi-account brokerage packages), each one is extracted as a separate row in the output spreadsheet, keeping the payer name and TIN tied to its own dividend figures.

What's the best format for getting 1099-DIV data into Schedule B or tax software?

CSV works well for most tax software imports since it's a plain, column-based format. Excel is better if you're manually reviewing totals across multiple clients or accounts before entering them elsewhere, since you can sort and sum by payer.

How accurate is the extraction for box 1a versus box 1b and box 7 foreign tax paid?

Accuracy is strong on clear, typed digital PDFs and standard scans, but very low-quality faxes or skewed scans can cause box values to shift. Always spot-check box 1a, 1b, and 7 against the original PDF for at least one document per batch before relying on the totals.

Ready to extract data from your PDFs?

Upload your first document and see structured results in seconds. Free to start — no setup required.

Get Started Free

Related Resources