1099-B PDF to CSV: The Complete Guide
Your broker sends a 1099-B as a PDF. Your accountant wants a spreadsheet. You need it in Excel for your records. Here's how to bridge that gap.
Why Convert 1099-B to CSV?
A CSV file is the universal format for structured data. Once your 1099-B data is in CSV, you can:
- Send it to your CPA in a format they can actually work with
- Open it in Excel or Google Sheets for review and analysis
- Calculate your own totals to verify against the broker's summary
- Import into accounting software like QuickBooks or Xero
- Keep clean records for future reference or audits
Method 1: Manual Copy-Paste (Not Recommended)
You could open the PDF, select tables, and paste into Excel. Problems:
- Formatting breaks constantly — columns don't align
- "VARIOUS" dates and footnotes create extra rows
- Wash sale adjustments get lost in the noise
- A 100-transaction 1099-B takes 2-3 hours manually
Method 2: Generic PDF-to-Excel Tools
Tools like Adobe Acrobat, Tabula, or Smallpdf can extract tables from PDFs. They work decently for simple tables, but 1099-B forms are tricky:
- Multiple sections (short-term covered, long-term covered, noncovered) get merged
- Summary rows mix with transaction rows
- Security descriptions wrap across lines
- Different brokers format 1099-Bs completely differently
Method 3: AI-Powered Extraction (Recommended)
Purpose-built tools like 1099-B Converter use AI to understand the structure of your specific 1099-B, regardless of which broker issued it. The AI:
- Identifies each transaction individually
- Separates short-term from long-term
- Extracts wash sale adjustments correctly
- Normalizes dates, dollar amounts, and security names
- Outputs a clean CSV with consistent column headers
What Your CSV Should Contain
A proper 1099-B CSV should have these columns:
| Column | Description |
|---|---|
| Date Acquired | When you bought the security (YYYY-MM-DD or VARIOUS) |
| Date Sold | When you sold it |
| Description | Security name and/or ticker |
| Quantity | Number of shares sold |
| Proceeds | What you received from the sale |
| Cost Basis | What you originally paid |
| Gain/Loss | Proceeds minus cost basis |
| Wash Sale Loss | Disallowed loss amount, if applicable |
| Type | Short-term or long-term |
Verifying Your CSV
After conversion, always spot-check a few transactions against the original PDF:
- Pick 3-5 transactions at random
- Verify the proceeds and cost basis match exactly
- Check that wash sale amounts are captured
- Confirm the total proceeds matches the broker's summary
If everything checks out, you have a reliable CSV you can send to your CPA, import into tax software, or keep for your records.