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 from all brokerages and is absolutely required for ALL Mark to Market traders. Do not attempt to convert the brokerage file into any other format.
Click on the brokerage icon to download the sample data file
​
All Templates updated for 2024 tax year
and DO NOT contain any viruses
PLEASE NOTE: Some of the broker templates have been updated and some have not. Some of the brokers are no longer in existence. I have found that it is easier to do the conversions myself rather than have to correct what is submitted, saving both time and money. Therefore, please just send the RAW TRADES downloaded from your broker as a .csv or .xlsx.
NOTE: For tax year 2024 some of these brokers have changed their reporting format.
Download what you can and email to us for evaluation. We will update when possible.
Incomplete - does not include REMOVALs
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 Year-End statement for each brokerage and Form 1099 as a pdf and as an Excel electronic download.
​
