How to obtain statements for Auto-Renta

Currently Auto Renta is available for DeGiro, IBKR, Trading 212, Revolut and eToro. A generic template is available and can be filled in for unsupported brokers.

Below are instructions on how to obtain the transaction and dividend history statement. If you want to generate the report for several brokers, it is possible by creating a single ZIP file with all statements.

• DeGiro
• IBKR
• Trading 212
• Revolut
• eToro
• Other Brokers not supported

DeGiro

Auto Renta generates the profit and loss report from of the full transaction history since the account was opened and dividends. Below are instructions on how to obtain:

• Transactions
• Dividends

Note: If you are attaching both files (Transactions and Dividends), do not forget to attach both files (transactions and dividends) in a single ZIP file.

Once you get the extracts of its full trading and dividend history you can make your purchase process at:

Transactions

DeGiro AutoFx Commission (Automatic Currency Exchange)

The automatic currency exchange (AutoFx) is a fee charged by DeGiro which is 0.1% for transactions before 20 December 2021 and 0.25% after that date. This information is not included in the CSV of transactions, so at Autodeclaro, we account for this commission in the Profit and Loss Report.

1/ Go to DeGiro WebTrader

2/ Click on the "Activityin the menu on the left and click on " " in the menu on the right.Transactions".

3/ On the transactions page, select the date range containing all your operations.

Note: To ensure that all transactions are obtained from the opening of the account start date must be indicated. ’01/01/1900′ and end date ‘1/03/2023’ (to ensure compliance two months beyond the end of the year 2022)

4/ Click on the button "Export". on the right-hand side of the screen.

5/ Select "CSV" "CSV" "CSV" "CSV" "CSV" "CSV" to export your operations as a CSV file and save it.

Note: The dates of the catch are not up to date

Note: Continue with the Dividend statement (Account Statement) as it is necessary to determine the AutoFX (automatic currency exchange) commission when it was active on your account.

Note Language of extracts: If your extracts are in a different language, adjustments have to be made to the extract.

In this example, the header of the CSV extract of transactions is in Dutch:

You would have to open the CSV with Notepad or Notepad++ and remove the header by this one below that you can copy and paste.

Date,Time,Product,ISIN,Exchange,Execution Venue,Number,Price,,Local Value,,Value,,Exchange Rate,,Transaction Costs,,Total,,Order ID

Dividends

Note: Yes has no Dividends and all its transactions are in EUR. (i.e. there are no trades in non-EUR currency), it is most likely that when you place the order, it will indicate an error that it is empty or there are no relevant positions. In this case, you can skip this dividend CSV file and do not include it.

1/ Go to DeGiro WebTrader

2/ Click on the "Activityin the menu on the left and click on " " in the menu on the right.Statement of account".

3/ On the 'Statement of account', select records from the ’01/01/1900′' al ’01/03/2023′.

4/ Click on the button "Export". on the right-hand side of the screen.

5/ Select "CSV" "CSV" "CSV" "CSV" "CSV" "CSV" to export your operations as a CSV file and save it.

Note: The dates of the catch are not up to date.

Note Language of extracts: If your extracts are in a different language (English, Italian, Dutch, etc.), you have to make adjustments to the extract by modifying the header by the English texts.

In this example, the CSV statement header is in Dutch:

You should open the CSV with Notepad or Notepad++ and remove the header by the English name. You can then copy and paste the following.

Date,Time,Value date,Product,ISIN,Description,Type,Variation,,Balance,,Order ID

In addition, the following texts need to be replaced:

• Dividend by Dividend

• Valuta Creditering by Income Foreign Exchange
• Valuta Debitering by Withdrawal Currency Exchange

It would look like this:

Interactive Brokers

Auto Renta generates the profit and loss report from the complete transaction history. All transactions for all years since the account was opened must be provided..

For dividends this would not be necessary unless you want your dividend history to be displayed as well.

Below are instructions on how to obtain:

• Transactions
• Dividends

All CSVs shall be grouped in one file. .ZIP which will be used for the purchase process.

Note: It only allows you to export a maximum of one year, i.e. 365 days. If you opened the account before 2021, you will have to export separately several times since you opened the account until today with the option (Customise data range).

Once you have obtained the extracts you can make your purchase process in:

Transactions

1/ Enter to Client Portal.

2/ Go to the tab "Performance & Statements (Yields and Statements) -> "Flex Queries.

Click on the "Flex Queries" tab.

3/ In the section "Flex activity consultation".Click on the "+" sign to create a new query.

4/ Fill in the 'Query name' field with whatever you want, for example. "Self-declared operations. Then select the following three sections:

• "Operations
• "Corporate actions
• "Transfers

5/ Let's start with "Operations. Click on the "Operations in the section "Sections".

Brand "Select all". and then you unmark the field "Account ID and "Account Aliases and save the options in the "Save". at the bottom of all fields in the table.

6/ Then we continue with "Corporate actions. Click on the "Corporate actions in the section "Sections".

As we did before, mark "Select all". and then you unmark the field "Account ID and "Account Aliases and save the options in the "Save". at the bottom of all fields in the table.

7/ Finally go to "Transfers. Click on the "Transfers in the section "Sections".

As we did before, mark "Select all". and then you unmark the field "Account ID and "Account Aliases and save the options in the "Save". at the bottom of all fields in the table.

8/ We leave the default settings and click on the button of "Continue" at the bottom of the page.

9/ In the next screen, click on the button "Create". button on the next page and then "Accept"..

10/ Now, click on the right arrow to run the query and export it in "CSV" "CSV" "CSV" "CSV" "CSV" "CSV".

11/ Select the period you want, e.g. last 365 calendar days, and click on "Execute". to export transactions.

Note: Select operations (remember that it only allows 365 calendar days) from the start of account opening until 1 March 2023 to ensure correct calculation of the two-month rule.

To make it easy you can indicate in each download: del:

• 2023-01-02 to 2023-03-01
• 2022-01-01 to 2022-12-31
• 2021-01-01 to 2021-12-31
• 2020-01-01 to 2020-12-31…
• and so on.

Note that the date ranges must be indicated starting with the end date instead of the start date, by mistake, it does not warn you and makes a file with only one date.

Note: the dates of the catches are not up to date.

Dividends

1/ Enter to Client Portal.

2/ Go to the tab "Performance & Statements (Yields and Statements) -> "Flex Queries.

Click on the "Flex Queries" tab.

3/ In the section "Flex activity consultation".Click on the "+" sign to create a new query.

4/ Fill in the 'Query name' field with whatever you want, for example. "Self-declared Dividends". and click on the "Change in accrued dividends". in the section "Sections".

5/ Brand "Select all". and then you unmark the field "Account ID and "Account Aliases and save the options in the "Save". at the bottom of all fields in the table.

6/ We leave the default settings and click on the button of "Continue" at the bottom of the page.

7/ In the next screen, click on the button "Create". button on the next page and then "Accept"..

8/ Now, click on the right arrow to run the query and export it in "CSV" "CSV" "CSV" "CSV" "CSV" "CSV".

9/ Select the period of the 2 January 2022 (first school day) at 31 December 2022and click on "Execute". to export dividend information.

Note: If you add dividend information from previous years, there is no problem; the report will be broken down by year. In this case you would have to export in IB for each year as it does not allow more than 365 days per CSV extract.

Trading 212

Auto Renta generates the profit and loss report from the complete transaction history since the account was opened together with the dividends.

Below are the instructions on how to obtain trades and dividends from the Trading 212 broker (all in one file):

• Export Trading 212 history

Note: Trading 212 only allows you to export 365 days, if your account is more than one year old download all years and compress all files into a single ZIP file.

Once you have obtained the extracts you can make your purchase process in:

Revolut

Auto Renta generates the profit and loss report from the complete transaction history since the account was opened together with the dividends.

Below are the instructions on how to obtain the transactions and dividends from the Revolut broker (all in one file):

1/ Login to the Revolut website: https://app.revolut.com or directly download the extracts at https://app.revolut.com/wealth/stocks/statements

Note: If you could not on the desktop web version, open the Revolut app of the mobile phone.

2/ Go to the section on "Stocks.

3/ go to the "3 points". and choose "Statements.

4/ Go to "Account statement

5/ Select "Excel" and click on the start date from when you opened your account. And click on "Generate.

You will need to obtain a file in CSV format. Do not open the file with excel, or save it in that format, you could make a copy of it if you want to open and view the contents with excel.

Once you get the extract "Account statement Revolut in CSV format, as indicated in the steps above, you can continue with your Revolut purchase process. Auto-Renta en:

eToro

Auto Renta generates the profit and loss report from the 2022 transaction statement together with the dividends.

Note: We have detected that the profit indicated by eToro on the "Closed positions is not the same (it is less) than that calculated by Autodeclaro. We understand that there is some hidden commission, but it is not detailed either. With the "Dividends"no problem.

Below are instructions on how to obtain trades and dividends from the eToro broker. Everything comes in a single Excel file that you download from the eToro platform, but two CSVs will have to be created from that Excel who are those who we will contribute to Autodeclaro:

• Step 1: Download eToro Excel extract
• Step 2: Generate the 2 CSV files (closed trades and dividends) from eToro's Excel file.

STEP 1

1/ To get the extract in Excel format, you have to go to "https://etoro.com/porfolio"and then go to the section on "Settings.

2/ Then go to "Account

3/ And on the next screen you can go to "Account Statement

4/ Indicate below the Last year (previous year in our case 2022). And click on "Create:

We then continue with the STEP 2to create the CSV of the dividends. We are going to do it with Google Sheets instead of Excel, the reason is that depending on the version of Excel or languages, it does not respect the separation of ',' in the resulting CSV file and uses another separator such as ';'.

STEP 2

1/ Go to Google DriveOnce there, we will upload the Excel file that we have previously downloaded from eToro.

Important: Check that the quantities do not contain two decimal separators.

There is a button "+ New" or "+ New" (depending on the language), select the eToro excel and it will be uploaded to your Google Drive space.

And open the excel previously downloaded from eToro,

2/ We will need to download in CSV the tabs "Closed positions and "Dividends. Start with the tab "Closed positions and change the text of "Action by "Action (delete accent).

Note: If we have the header in another language, we have to change it to Spanish, in this case the fields would look like this, without accents:

Position ID,Share,Amount,Units,Opening Date,Closing Date,Leverage,Spread,Profit,Opening Rate,Closing Rate,Take Profit Rate,Stop Loss Rate,Rollover and Dividend Fees,Copy from,Type,ISIN,Notes

Note: check the country indicated in Google Sheets. For them go to "Archive -> "Configuration" and mark the "regional configuration". in Spain, that way we will have the decimal separator as ',' and the thousands separator with the '.'.

3/ Go to the tab "Closed positions to download the CSV. Go to "File" -> "Download" -> "comma-separated values (.csv)".

4/ The .CSV file will be downloaded to our "Downloads" folder.

5/ Repeat the same steps as in step 3 with the "Dividends. In this case we leave the header which should be in English. If this is not the case, the fields would be: Date Of Payment, Instrument Name, Net Dividend Received (USD), Withholding Tax Rate (%), Withholding Tax Amount (USD), Position ID, Type, ISIN.

Once you have obtained the two CSV files, you can carry out your Auto-Renta purchase process at:

Other brokers not supported

Auto Renta generates the profit and loss report from the 2022 trading statement together with the previously supported brokers' dividends.

However, in order to support other brokers, a template is provided in Google Spreadsheets (Google excel) for the client to fill in if their broker is not supported.

• TRANSACTIONS
• DIVIDEND

Transactions

The instructions for completing the transactions are shown below.

1/ The excel template is available at "Excel Template"and then make a copy of it in your Google Drive space.

2/ Once copied, you can modify the template in your Google Drive space.

3/ An example may be helpful in completing your transactions.

4/ Please fill in the template:

• Follow the same format in the fields Date DD/MM/YYYYY and Time HH:MM:SS (Columns A and B).
• The shopping have the number of shares (Field I) positive y Total Quantity (Field K) in negative.
• The sales have the number of shares (Field I) in negative y Total Quantity (Field K) positive.
• The exchange rate is not compulsory (Column N), if not indicated, the European Central Bank exchange rate shall be taken.
• If you do not know the ISIN (Field F), complete only the Ticker field (Field H).

Note: Try filling in a few lines and continue to the next point to test the Demo version of Auto-Renta. So you can check that it works.

5/ Once you have completed your template, download it in CSV format.

7/ Once you have downloaded the CSV you can proceed with your Auto-Renta purchase process at:

Dividends

The instructions for completing the transactions are shown below.

1/ The excel template is available at "Excel Template"and then make a copy of it in your Google Drive space.

You can fill in the dividend template and download it in CSV format.

Once you have downloaded the CSV of dividends you can make your Auto-Renta purchase process at:

---