INPUT FILE REQUIREMENTS - 1099B Version
THE BASICS

The file should contain one entry per line and have a comma between each of the fields. To accomplish this, the Excel entries should be saved as a "comma delimited file" otherwise known as a "csv" file.

There should be no imbedded commas, double quotes or single quotes in any of the fields.

All dates are in a month/day/year format: mm/dd/yy or mm/dd/yyyy. examples: 02/04/04, 02/04/2004, 2/2/04, etc.

Please note: A date of 00/00/0000 is invalid and the program will not process the file.

REQUIRED FIELDS

1. Security (stock) name – up to 80 characters long with no imbedded commas;
2. Account Id – unique user defined identifier up to 50 characters in length;
3. Unique Lot Id – unique user defined identifier up to 50 characters in length;
4. Date Acquired – in the format mm/dd/yy or mm/dd/yyyy;
5. Date Sold – in the format mm/dd/yy or mm/dd/yyyy; or blank if the lot is still open;
6. Number of shares – maximum length of 15 including a decimal point;
7. Original Price per Share – maximum length of 15 including a decimal point;
8. Sale Price per Share – maximum length of 15 including a decimal point;
9. Total Cost – maximum length of 15 including a decimal point;
10. Proceeds – maximum length of 15 including a decimal point; or blank if the lot is still open;
11. Gain or Loss – maximum length of 15 including a decimal point; or blank if the lot is still open;


If the Gain or Loss (Field 11) is negative, please use a '–' and not parentheses.

Click here to download an excel template for the input file

SAVE INPUT FILE

Once this file is prepared in Excel, you must save it as a "csv" or comma delimited file for Washems!. You do this by clicking on the "File" option in Excel's toolbar and then selecting "Save As". Once the "Save As" window opens, scroll down the file types until you see "Comma Delimited". Choose this type and key in a name for your file. You may use the original worksheet name since Excel appends a different suffix to the name indicating the file's type. Your Excel work file, for example will have the name "whatever.xls" and your saved csv file will be called "whatever.csv". Remember this name since you will have to tell it to Washems!.

QUICK LINKS
RUNNING THE 1099B CALCULATION MODULE

Now that you've created and saved your input file in the correct format, you're ready to calculate your wash sales. The following section describes the job parameters found on the 1099B calculation screen.

CALCULATION PARAMETERS

1. Input File – name and directory (full path) where the input file can be found;
2. Output File – name and directory (full path) for the full detail output file;
3. 1099B Output File – name and directory (full path) for the 1099B output file;
4. Adjustment Output File – name and directory (full path) for the adjustment output file;

Once you've selected your options, click the CALCULATE button to start the program. When its completed, you'll be able to see and download the full detail results.

Your other 2 output files can be found in the location you specified in their respective parameter fields.