H&R Block 1099-B CSV Import — Format, Errors, and the Workaround

You exported your 1099-B as a CSV from Fidelity, opened H&R Block Online, clicked Upload CSV, and got this:

"We weren't able to import your tax data. Please check the file format and try again."

You re-saved the file as a .csv. You tried again. Same error. You exported it from your broker again with different settings. Still failing. The CSV opens fine in Excel — the data is right there — but H&R Block won't take it. After 20 minutes you start typing every transaction by hand into the "Add a Sale" form and remember why people pay TurboTax extra.

H&R Block accepts CSV imports for 1099-B data, but it's picky about the format in ways that aren't obvious from the upload screen. The column headers have to match exactly, the date format has to be consistent, and a handful of edge cases (wash sales, "VARIOUS" lots, negative proceeds) will silently break the import. This guide covers what H&R Block expects, the four or five errors that hit most users, the auto-import alternative, and what to do when neither path works.

How H&R Block Handles 1099-B Data

H&R Block offers two product lines for tax-year 2026:

• H&R Block Online Premium (web-based, called the version that handles investment income)
• H&R Block Software Premium & Business (desktop version, runs locally)

Both support 1099-B import through three paths:

1. Broker auto-import: sign in to your brokerage from inside H&R Block and pull the document directly.
2. CSV upload: drop a properly-formatted CSV with all your transactions.
3. Manual entry: type each sale into the form, one at a time.

Online has a soft cap around 2,000 transactions before the import slows to a crawl or errors out. Software (Desktop) handles 5,000+ comfortably and is the only path that supports TXF imports — useful if your broker (TradeStation, Interactive Brokers) provides a TXF export.

For most people the choice is between path 1 (auto-import, easy when it works) and path 2 (CSV upload, the fallback when auto-import fails or your broker isn't supported).

H&R Block's Auto-Import — Try First

In H&R Block Online: Federal → Income → Investments → Stocks, Mutual Funds, Bonds, Other, then pick I'll import my info when prompted. The broker dropdown is similar to TurboTax — Fidelity, Schwab, Vanguard, E*TRADE, Merrill, Wells Fargo, Robinhood, Apex Clearing, and a few dozen others are listed.

When this works, you sign in to your brokerage credentials inside H&R Block, the import pulls every transaction, and you're done in a minute. When it doesn't work, you'll see one of these:

• "We couldn't connect to your broker" — credentials issue or the broker's tax-document feed isn't live yet for the current year. Wait 24-72 hours.
• "No tax documents available" — same as above, or your broker isn't in H&R Block's import partner list.
• Import succeeds but transaction count is suspiciously low — H&R Block hit a partial-result cap. Re-run with a narrower date range and import in halves.
• Import succeeds but every row shows blank cost basis — the broker only sent proceeds, not basis. You'll need to fill in basis from the PDF.

If you have a Robinhood account, the auto-import path works for Robinhood Securities (since they self-cleared in 2018) but not always for older Robinhood lots that were cleared through Apex. If you trade through Webull, M1, Public, or another Apex-cleared neobroker, you may need to pick Apex Clearing Corporation in the dropdown instead of the front-end app — same story as TurboTax. The TurboTax alternatives writeup covers the cross-product differences in auto-import coverage.

The H&R Block CSV Format — What the Headers Need to Be

When auto-import isn't an option, you're uploading a CSV. H&R Block expects these columns, in roughly this order:

Required Header	Description	Format
Description	Security name and quantity	e.g., "100 sh. AAPL"
Date Acquired	Purchase date	MM/DD/YYYY (or "Various")
Date Sold	Sale date	MM/DD/YYYY
Sales Price	Proceeds (no $ sign)	e.g., 1234.56
Cost Basis	Cost or basis (no $ sign)	e.g., 1000.00
Wash Sale Loss Disallowed	Disallowed loss (positive number)	e.g., 50.00 or blank
Adjustment Code	One letter per IRS Form 8949	W, B, T, L, etc.
Adjustment Amount	Dollar adjustment (signed)	e.g., -50.00 or blank

A few format rules that aren't obvious:

• Headers must match exactly. "Date Acquired" works; "Acquisition Date" doesn't. "Sales Price" works; "Proceeds" doesn't. This is the single most common cause of "we weren't able to import" — your broker's column names are similar but not identical.
• Dollar signs and commas in numbers will break the import. Strip them before upload. 1,234.56 and $1234.56 both fail; 1234.56 works.
• Dates must be MM/DD/YYYY. Two-digit years and date-first formats (DD/MM/YYYY, common in European broker exports) fail.
• "Various" is acceptable in Date Acquired only. It signals multiple acquisition dates (long-term aggregated lots). Anywhere else, a date is required.
• No header row aliases. H&R Block doesn't do fuzzy matching — Cost or Basis doesn't map to Cost Basis.

Most brokers export with slightly different headers. To make a CSV H&R Block accepts, you typically need to:

1. Open the broker's CSV in Excel or Google Sheets.
2. Rename the header row to match the table above.
3. Reorder columns to roughly the same sequence (H&R Block is mostly tolerant of order, but having the headers in the expected positions reduces ambiguity).
4. Strip dollar signs and thousands separators from all numeric columns.
5. Standardize date format to MM/DD/YYYY.
6. Save as .csv (not .xlsx).

This works but is tedious for accounts with hundreds of trades. The TaxAct CSV format guide walks through similar reformatting steps; H&R Block's requirements are roughly comparable to TaxAct's but stricter about exact header text.

Common H&R Block Import Errors and How to Fix Them

"We weren't able to import your tax data"

Generic catch-all. Usually one of:

• Header mismatch: a single misspelled or differently-named header rejects the whole file. Compare yours line-by-line against the table above.
• Embedded commas in Description field: a security name like "Berkshire Hathaway, Class B" includes a comma that breaks CSV parsing. Wrap the field in quotes ("Berkshire Hathaway, Class B") or strip the comma.
• BOM byte at file start: some Excel exports include a Unicode byte-order-mark before the first header, which H&R Block treats as part of the column name. Open in a plain text editor (Notepad, TextEdit) and resave as UTF-8 without BOM.

"Cost basis is missing for one or more transactions"

Rows with blank or zero cost basis fail validation, even if the broker correctly marked them as noncovered. Options:

• If the blank is a noncovered lot (Box B or Box E), fill in basis from your purchase records before uploading. The missing cost basis guide covers how to find the right number.
• If the basis is truly unknown (inherited shares with no records, very old positions), enter your best reasonable estimate. The IRS will accept any defensible basis, but zero is treated as "you owe tax on the full proceeds" which is almost never correct.

"Wash sale adjustment exceeds disallowed amount"

H&R Block validates that Adjustment Amount (signed) equals the negative of Wash Sale Loss Disallowed for rows with code W. If your broker's CSV has the disallowed amount but no adjustment column (or vice versa), the validator fails.

Fix: for every row with a wash sale loss disallowed, add a matching row in the Adjustment Amount column with the negative of that value. E.g., Wash Sale Loss Disallowed = 50.00 → Adjustment Amount = -50.00.

"Date format not recognized"

You have date entries that aren't MM/DD/YYYY. Common offenders:

• European format: DD/MM/YYYY (e.g., 15/03/2026).
• Long format: March 15, 2026 or 2026-03-15.
• Two-digit years: 3/15/26.

Convert all to MM/DD/YYYY with leading zeros (03/15/2026). In Excel, use =TEXT(A1, "MM/DD/YYYY") to reformat in bulk.

"Description field too long"

H&R Block caps the description field around 50-60 characters. Long security descriptions get truncated or rejected. Shorten verbose entries — "Long-term capital gain distribution from XYZ Mutual Fund Class A Shares" becomes "XYZ Mutual Fund Class A LTCG dist".

When Your File Is Too Big for H&R Block Online

H&R Block Online slows dramatically above 1,500 transactions and may time out around 2,000-2,500. If you have 3,000+ trades, you have three options:

Option 1: Switch to H&R Block Software (Desktop). Desktop handles 5,000+ rows comfortably and supports TXF imports for cleaner bulk loading. The downside is the price difference and the desktop-install hassle.

Option 2: Summary method. For Box A and Box D transactions (covered, basis reported to IRS, no adjustments), you can report a single summary line per box on Form 8949 and skip itemizing each trade. H&R Block supports this through the "Enter totals only" option in the same investment income section. You'll need to mail or upload a copy of your 1099-B as a supplemental statement; the 1099-B summary totals method covers the IRS rules. This only works for unadjusted lots — any row with code W, B, or another adjustment has to be itemized.

Option 3: Convert the PDF and split the CSV. Run the 1099-B PDF through a PDF-to-CSV converter, then split the resulting CSV into chunks of ~1,500 rows. Upload each chunk separately. H&R Block doesn't have a "merge multiple imports" feature, so you'll end up with the imports appearing as separate Form 8949 sections, but the math still rolls up correctly to Schedule D.

The large 1099-B walkthrough covers the volume-vs-method decision in more detail.

Wash Sales and Adjustments — Where H&R Block Trips Up

H&R Block's import handles wash sales (code W) and basis adjustments (code B) correctly when the CSV is formatted right. The most common failures:

The disallowed loss is in one column, the adjustment in another. Most broker CSVs report Wash Sale Loss Disallowed as a positive number representing the deferred loss. H&R Block also wants Adjustment Amount as the signed version (negative because it reduces your reportable loss). Both columns need to be populated.

Adjustment Code is multi-character. The IRS supports combined codes like WB (wash sale plus basis adjustment) and WS (wash sale plus short sale). H&R Block sometimes accepts these and sometimes doesn't, depending on the version. If a multi-character code fails, split the transaction into two rows or pick the dominant code.

Code Q (QSBS exclusion). For Qualified Small Business Stock under Section 1202, the adjustment code is Q. H&R Block Online has historically had bugs with Q-coded rows — you may need to manually enter QSBS sales rather than CSV-importing them. Desktop handles Q correctly.

For a full reference on what each code means and which rows need which codes, see the Form 8949 adjustment codes guide.

What to Do When Nothing Works

If you've tried auto-import, CSV upload, and the summary method, and one of them still isn't working, the universal fallback is to convert your 1099-B PDF directly to a properly-formatted CSV designed for H&R Block, then upload that.

This skips two layers of brittleness: you're not dealing with broker-CSV-export inconsistencies (Fidelity's headers differ from Schwab's differ from Robinhood's), and you're not dealing with H&R Block's strict header validation (because the converter outputs exactly what H&R Block wants). It also works for any broker, even those H&R Block doesn't have in the auto-import dropdown.

The path is the same as the H&R Block CSV upload route — just with a CSV that's been pre-formatted for the destination instead of one you're trying to reshape from a broker export.

FAQ

Does H&R Block Online have a transaction limit for 1099-B?

There's no hard cap, but the software slows down significantly above ~1,500 transactions and may time out around 2,000-2,500. For accounts above that, switch to H&R Block Software (Desktop) which handles 5,000+ comfortably, or use the summary-totals method to roll everything up into a few lines.

Does H&R Block accept TXF files?

Only the Desktop version does. File → Import → TXF File. H&R Block Online does not accept TXF imports — only CSV uploads and broker auto-imports. If you have a TXF file from your broker (TradeStation, Interactive Brokers), either use H&R Block Desktop, or convert the TXF into a CSV first.

What's the difference between Sales Price and Proceeds?

Same thing. The IRS form (8949) calls it "Proceeds." H&R Block calls it "Sales Price" in their CSV header. Your broker might call it either. They all mean the gross dollar amount you received from the sale, before subtracting cost basis. If your CSV has a column called "Proceeds," rename it to "Sales Price" before uploading.

My broker isn't in the H&R Block dropdown. Now what?

CSV upload or manual entry. The dropdown covers the top 30-40 brokerages; smaller firms, foreign brokers, and crypto exchanges typically aren't listed. The CSV path works regardless of broker — just match the header format above. If your broker's CSV export is too far from H&R Block's expected format, converting the 1099-B PDF directly is faster than reformatting columns.

Can I import a 1099-B PDF directly into H&R Block?

No — H&R Block doesn't read PDF files for transaction import. You can upload a PDF as a supplemental statement (attachment to your return), but the transactions still need to come in via auto-import, CSV, or manual entry. The PDF-to-CSV converter handles this gap.

H&R Block keeps saying my dates are wrong but they look right.

Check three things: (1) all dates in MM/DD/YYYY format, (2) "VARIOUS" only in Date Acquired column, never in Date Sold, (3) no entries with future dates or pre-1990 dates (some H&R Block versions reject dates outside a reasonable range). Also check for Unicode characters in date cells from Excel autoformatting.

What if I get a corrected 1099-B after filing with H&R Block?

If H&R Block has already submitted your return, you'll need to file an amended return (Form 1040-X) reflecting the corrected numbers. H&R Block supports amended returns inside the same product. If you haven't filed yet but already imported the original 1099-B data, delete the imported transactions and re-import using the corrected PDF/CSV.

Bottom Line

H&R Block's CSV import works but is unforgiving about exact column headers, date formats, and number formatting. Most "we weren't able to import your tax data" errors trace back to one of: header mismatch with the broker's export, comma-or-dollar-sign in number cells, or wash sale adjustment columns missing the signed amount. Fix those at the CSV level and the upload succeeds.

Auto-import is the easier path when your broker is in the dropdown and the credentials work. For larger accounts (above ~1,500 trades), use H&R Block Desktop instead of Online — it handles volume better and accepts TXF imports. When everything else fails, convert the 1099-B PDF to a CSV pre-formatted for H&R Block and upload that — it sidesteps both the broker-export inconsistencies and H&R Block's strict header validation in one step.

---

H&R Block keeps rejecting your CSV? Convert your 1099-B free — drop in the PDF, get a CSV with the exact headers H&R Block wants. No reformatting, no header debugging, three free conversions per month.