Purpose of the format
The universal RoboTaxMaker format is used to allow you to manually type transactions on any brokerage or bank account if there is no automatic report parser for that broker or bank.
In addition, it is possible to output any parsed data into this format.
If you need to calculate taxes from Forex transactions for Interactive Brokers reports, you can use the universal RoboTaxMaker format to store data for open Forex positions. More
When loading a file of the universal RoboTaxMaker format simultaneously with an Interactive Brokers report, if the data in the “Broker or Bank” sheet matches the data in the Interactive Brokers report (name of financial institution and account number), then all data in the universal RoboTaxMaker format will be ignored except for the “Forex Positions” sheet. The Interactive Brokers report already contains all data on transactions and open positions at the time of report generation, with the exception of Forex positions, so duplicating them could lead to incorrect calculation.
The file template is available here: Download the template file
Format Description
Here are the names of sheets in Excel and a list of columns with example values.
Broker or Bank
Sheet with a description of the financial organization. One of two values is specified as the organization type:
- Broker
- Bank
| Type of organization | Broker |
|---|---|
| Name | Interactive Brokers LLC |
| Address | One Pickwick Plaza, Greenwich, |
| CT 06830 USA | |
| SWIFT code or BIC | |
| Taxpayer number | 13-3863700 |
| Code of the country | 840 |
| Account number | 123456789 |
| Base currency | USD |
| Report for the period | 01.01.2021 – 31.12.2021 |
Cash positions
A sheet describing cash positions at the beginning and end of the period. One of the following values is specified as the position type:
- Balance at the beginning of the period
- Balance at the end of the period
| Currency | Position type | Quantity |
|---|---|---|
| USD | Balance at the beginning of the period | 1224,11 |
| USD | Balance at the end of the period | 978,12 |
| EUR | Balance at the beginning of the period | 3000,00 |
| EUR | Balance at the end of the period | 0 |
Flow of cash
Sheet describing cash flows. Date and Description are optional fields.
| Currency | Date | Quantity | Description |
|---|---|---|---|
| USD | 1385,12 | ||
| USD | 2190,00 | ||
| USD | -3821,11 | ||
| EUR | -3000,00 |
A sheet describing positions in securities at the beginning of the period. One of the following values is specified as the asset category:
- Stocks
- Bonds
- U.S. Treasury Bills
| T | Stocks | USD | 27.08.2018 | 30,00 | 32,8717 |
| VOD | Stocks | GBP | 01.03.2019 | 9,00 | 17,8195 |
Securities transactions
A sheet describing transactions in securities during the period. The asset category must be one of the following:
- Stocks
- Bonds
- U.S. Treasury Bills
| Symbol | Asset Category | Currency | Date | Quantity | Price | Comm |
|---|---|---|---|---|---|---|
| T | Stocks | USD | 20.03.2020 | 100,00 | 36,00 | -1.00 |
| VOD | Stocks | GBP | 09.03.2020 | 300,00 | 1,4054 | -8,11 |
A sheet describing positions in derivative financial instruments at the beginning of the period. The asset category must be one of the following:
- Options
- Futures
- Commodities
- CFDs
- IPO
- Warrants
- Other Items
| JNJ 19FEB21 145.0 P | Options | USD | 02.12.2020 | -100,00 | 4,6135 |
| T 08JAN21 28.0 P | Options | USD | 28.12.2020 | -100,00 | 0,2721 |
Derivatives transactions
A sheet describing transactions in securities during the period. The asset category must be one of the following:
- Options
- Futures
- Commodities
- CFDs
- IPO
- Warrants
- Other Items
| Symbol | Asset Category | Currency | Date | Quantity | Price | Comm |
|---|---|---|---|---|---|---|
| T 21FEB20 36.0 P | Options | USD | 30.01.2020 | -100,00 | 0,2300 | -1,10 |
| JNJ 17JUL20 136.0 P | Options | USD | 08.07.2020 | -100,00 | 0,5500 | -1,58 |
Dividends
A sheet describing dividends and withholding taxes.
| Symbol | Currency | Payment date | Amount | Withholding tax |
|---|---|---|---|---|
| AAPL | USD | 14.05.2020 | 5,74 | 0,57 |
| T | USD | 01.05.2020 | 77,48 | 7,75 |
Other
A sheet describing other income and expenses. The following values can be usea as a type of income/expense:
- Withdraw Fee
- Consultant fee
- Transaction Fees
- Service Fee
- Interest
- Coupon income
- Cash Dividend
- Other brokerage account expenses
| Description | Type of income/expense | Currency | Date | Amount |
|---|---|---|---|---|
| Withdraw Fee | Withdraw Fee | USD | 02.09.2020 | -3,65 |
| Consultant fee | Consultant fee | USD | 06.01.2020 | -5,98 |
Forex positions
A sheet describing positions in currency pairs.
| Symbol | Asset Category | Currency | Open date | Quantity | Price | Comm |
|---|---|---|---|---|---|---|
| USD.GBP | Forex | GBP | 07.12.2018 | 205,81 | 0,7915 | -133.1582 |
| USD.CAD | Forex | CAD | 29.04.2019 | -135,10 | 1,3460 | -2.692 |
Forex transactions
Sheet describing transactions with currency pairs.
| Symbol | Asset Category | Currency | Date | Quantity | Price | Comm |
|---|---|---|---|---|---|---|
| USD.GBP | Forex | GBP | 07.02.2020 | -29,58 | 0,7901 | -132,431 |
| USD.CAD | Forex | CAD | 17.11.2020 | 4,90 | 1,3074 | -2 |