List of Supported Brokers and Supported Data File Formats
Brokers are required to provide you Form 1099-B or an approved facsimile each year in a human-readable format.
Some brokers will also provide the data to you in a computer-readable format. If given the opportunity, please request that your broker supply 1099-B data in one of the "Standard Computer-Readable Formats" described below.
Data File Formats
Standard Computer-Readable Formats
- OFX: Some brokers sponsor an accessible Open Financial Exchange (OFX) server from which applications can retrieve your data in a standard XML format in your behalf. Our application can interact with these servers. Other brokers sponsor an OFX server but limit access to specific OFX clients.
- XML: Extensible markup language. A downloadable data file in the same standard format used by OFX servers.
- TXF: Tax exchange format (TXF) files contain 1099-B data in a older, less-robust, albeit standard format.
Non-standard Computer-Readable Formats
- CSV: Comma separated values. A text file where data is presented in rows and columns. There is no standard CSV format for 1099-B data. Each broker uses a different proprietary approach. As such, our app needs to provide custom code to read and process these files.
- XLS: Microsoft Excel format. Data is presented in cells arranged in rows and columns. As with CSV, there is no standard XLS format for 1099-B data. Each broker uses a different proprietary approach. As such, our app needs to provide custom code to read and process these files.
Non-standard Human and Sometimes-Computer-Readable Formats
PDF: Portable Document Format. Instead of mailing you Form 1099-B, your broker will allow you to download the form as PDF.
We can sometimes parse (read with a computer program) and process PDF files.
Specifically, there a 2 types of PDF files "vector" and "rasterized". Vector is the most common and allows for presenting the PDF in any size and preserves the quality of the content. Rasterized PDFs convert the content to an image and show jagged edges on letters at large sizes. Our app does not process rasterized PDF files.