Broker Conversion Templates

Opening Screen on All Templates
Broker Disclaimer.jpg

Click on the brokerage icon to download a macro-enabled Excel 2013 template.

You may need to adjust your Trusted Documents settings in Excel.

These will open as a link to my Google drive and you can download from there.

All Templates updated 1/17/2022

ally.jpg
Snag_25ca0d7e.png
tastyworks.jpg

Incomplete - does not include REMOVALs

tradier.jpg
Chas Schwab.jpg
Snag_258c9876.png
Snag_258cc91b.png

If you have NO REMOVALs on your data download.  You will have no expirations, exercises or assignments

ETrade.jpg
Robinhood.jpg
Snag_258cc91b.png

If you have REMOVALs on your data download.  You will have expirations, exercises or assignments

Add Closing logo.jpg

REMOVALs are Closing Transactions that TD Ameritrade fails to include; This Template adds the necessary Closing Transactions

Video Tutorials
Using the Standard OSI Template
TDA - Changing REMOVALs to Closes
Adding Closing Transactions

I you want us to prepare your tax return or just the trading portion of your tax return, you will save preparation fees by preparing your data using the Brokerage Conversion Template.

If you do not believe you can perform these conversions then we can, but our hourly rate of $180 will apply.

The Excel data file should appear as the example below.

You must still provide the Broker Year-End statement and Form 1099.

Broker Data File.jpg