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

NOTE: For tax year 2021 most of these brokers have changed their reporting format so the templates may not work properly. Will update when possible.

ally.jpg
Snag_25ca0d7e.png
tastyworks.jpg

Incomplete - does not include REMOVALs

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

 
tradier.jpg
Open Manual Entry.jpg

Opening Positions manual entry

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