It is possible to import Buy transactions that act as reinvestments from Fidelity through the Excel Import Interface by entering a special transaction code on the spreadsheet.
Create your Excel spreadsheet with the transaction information and include a column for Transaction Code. Enter the transaction code of RIN+BY.
Save the spreadsheet.
When you are ready to Import from Excel, click on the Import button from the top menu in Office.
From the Import Interfaces list, place a check next to Microsoft Excel – Transactions, and then click Import from the top menu.
Follow the standard directions for importing from Excel. Make sure that the Transaction Code field is mapped to the Code column in the spreadsheet.
Select Fidelity as the Custodian, and then click Import.
Once imported, when you review the blotter, the Reinvest column for the Buy shows the Distribution Reinvest.
When you open the transaction record, this is what you will see.
See Also
Importing from Microsoft Excel