Broker Conversions

Once you download your broker's RAW TRADE data, we will convert it into a uniform format across brokerages.  This will not replace the requirement to provide an electronic 1099-B in Excel format and is absolutely required for ALL Mark to Market traders.

Click on the brokerage icon to download the sample data file

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

All Templates updated 7/23/2022

NOTE: For tax year 2021 most of these brokers have changed their reporting format.

Download what you can and email to us for evaluation.  We will update when possible.

Chas Schwab.jpg

Incomplete - does not include REMOVALs

Open Manual Entry.jpg

Opening Positions manual entry

The Excel data file should appear as the example below, one broker download per tab. 


If you have multiple accounts at one brokerage, then append the last 4 digits of the account number to the tab name.  For example, you have two accounts at TD Ameritrade with account numbers 987654321 and 123456789.  Your tab names would be TDA-4321 and TDA-6789.

We will take your information and convert it into a uniform format for wash sale purposes across brokerages.

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

Broker Data File.jpg