List of Supported Brokers and Supported Data File Formats
Brokers are required to provide you Form 1099-B, Form 1099-DA, or an approved facsimile each year in a human-readable format.
Data File Formats
As stated above, your broker is REQUIRED to provide you Form 1099-B or Form 1099-DA
or a facsimile in a human-readable format.
Your broker SHOULD also provide 1099-B and 1099-DA data in a computer-readable format.
Unfortunately, many brokers do not do so.
Our app can process 1099-B and 1099-DA data files in the formats listed below.
1099-B and 1099-DA data includes realized gain or loss information
plus any adjustments for the wash sale rules.
Note: Our app cannot process raw trade data files (a record of buys, sells, etc.)
in a "Standard Computer-Readable Format" (see left column below).
Standard
Computer-Readable
Formats
Intelligent Tax Document® (ITD)
Intelligent Tax Documents are PDF files that contain the tax document data internally in JavaScript Object Notation (JSON) format specified by the Financial Data Exchange standard-setting organization.
FDX JSON: Financial Data Exchange JavaScript Object Notation format. The newest modern standard for financial and tax data communication.
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 often — but not always — parse (read with a computer program) and process downloaded PDF files.
Specifically we cannot process:
- PDF files generated by scanning paper 1099-Bs
- PDF files that are password protected
- PDF files containing "rasterized" text. Normally PDF files contain "vector" information. Vectors allow 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.
- PDF files that use a non-standard encoding of text.
Brokers
For information specific to a broker,
click on the link in the Broker Name column below.
If your broker is not listed,
please email us.
If you have more up-to-date information,
let us know.
As stated above, the
Standard
Computer-Readable
Formats
of FDX,
OFX, XML, and TXF
are preferred over the
Non-standard Formats (CSV, XLS, and PDF).
#
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
Name
Site
ITD
OFX
XML
TXF
CSV
XLS
NONE