Tips On Importing Stock Transactions To Intuit Tax Online

Click on the image to enlarge.

Beginning in tax year 2013, Intuit Tax Online finally was equipped with some limited import capability thru excel file or .csv file to improve data input efficiency.  As mentioned in my previous post, importing stock transactions in this manner is not straight forward, it requires us to scrub the spread sheet to comply with the software's import format.  One issue that the software's import instruction doesn't mention is that there should be no special character in the "Description" column on your spread sheet before import, because the software  doesn't take special character such as ",  or #".  Remember to scrub out all special characters before importing, or you will be flashed by the software  with error message about "missing required description column".  Once your spread sheet is successfully imported, you have to check the "Ignore" box next to the heading line imported from your spreadsheet, and then select in the above drop down boxes (see picture above) the appropriate headings. Only columns that are selected through the drop down box are imported.  So make sure you select all the headings that are relevant to your columns in your spread sheet to ensure a complete schedule D import.