Generic Format - Realized Gain/Loss

If your online broker is not in the list of supported brokers, you can create a spreadsheet file (XLS) using MS Excel or a Comma Delimited text file (CSV) using text editors such as NotePad, WordPad and MS Word. The CSV or XLS file must be in the format shown below.

Symbol,Quantity,Date Acquired,Cost,Date Sold,Proceeds,Gain
BX,200,09/05/2007,4446.99,09/11/2007,4561.01,114.02
YGE,500,10/18/2007,15665.01,10/19/2007,16234.99,-569.98
.AXZ,10,11/11/2007,2459.95,12/09/2007,3140.05,680.10

The CSV file in NotePad looks like the following.

The XLS file in MS Excel looks like the following. After entering all your gain/loss records, please save it as a Comma Delimited (*.csv) file.