Form 1099-B - Import Stock Information from CSV File
1
TaxAct® customers can enter multiple Form 1099-B Proceeds From Broker and Barter Exchange Transactions quickly and easily by importing a CSV (comma separated values) file.
To import transactions, you will need to either:
obtain a spreadsheet file from your broker and import it using the steps below, or
In the Investment Income dropdown, click 1099-B CSV import.
Click CSV Import.
Click Choose File and browse your computer for the CSV file. Select it and click Open.
Verify that the correct file was selected, then click Continue.
Use the dropdowns to match the column headings from your file to the appropriate column headings allowed in the program, then click Continue.
Select the entries you want imported into your tax file by checking the box to the left of each row, then click Continue.
Verify that the data is aligned. If everything is correct, click Import. If you need to make changes, click Back
You are notified that the import was successful, click Close and Continue.
Click Continue, then either launch the Stock Assistant to review or adjust the imported transactions, or click Continue to review, modify, or delete any of the Form 1099-B data imported into your return.
Desktop
Open your TaxAct return, and click Federal
In the Investment Income dropdown, choose 1099-B CSV import.
Alternatively, go to File > Import > 1099 Information > CSV 1099-B.
Select CSV Import.
Browse your computer for the CSV file, select it, and click Open.
Use the dropdowns to match the column headings from your file to the appropriate column headings allowed in the program and click Continue.
Select the entries you want imported into your tax file by checking the box to the left of each row, then click Continue.
Verify that the data is aligned and appears correct, then click Import.
If you need to make changes, click Back
You are notified that the import was successful, click OK.
You can either launch the Stock Assistant to review or adjust the imported transactions, or click Continue to review, modify, or delete any of the Form 1099-B data imported into your return.
Notes
It is your responsibility to make sure the CSV file columns match the appropriate fields in the TaxAct program. If these do not accurately match, the program may not calculate the investment sales correctly.
If you import more than one CSV file or brokerage statement, the transactions will be added to the list of Form 1099-Bs previously created (up to 2,000 total).
If you receive an error message while attempting to import your CSV file, try switching your browser to Google Chrome.
The only way to see the CSV Import is to have the screen in full view. The CSV import is not available on smaller screens (such as on mobile devices).
You should compare the CSV or Excel file you obtain from your broker with the information that was reported to you on Form 1099-B. All transactions reported on Form 1099-B need to be included in your CSV or Excel file. If there are transactions missing from your CSV or Excel file, you will need to manually add these transactions to your file before importing into TaxAct.
If you use Microsoft Excel or Open Office to open files, you must convert the spreadsheet file to a CSV format before attempting to import that file into TaxAct.
Some .xls files may be acceptable, if they are text files.