How to obtain the statements for Auto-Renta?

Currently Auto Renta is available for the following brokers:

DeGiro, IBKR, Trading 212, Revolut, eToro and MyInvestor. There is also a generic template that can be filled in for unsupported brokers.

New 2024/2025: Through the platform VUMIbank statements can be obtained from the banks. BANKINTER,BBVA, CAIXABANK, IBERCAJA, DEUTSCHE BANK, SANTANDER, METAGESTION, ANDBANK, , RENTA4 e INVERSIS.

Note: It is very important to attach the total movements (the entire history) since the opening of the account with your broker, otherwise the report will be incomplete.

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.

• Andbank (from VUMI)
• Bankinter (from VUMI)
• BBVA (from VUMI)
• CaixaBank (from VUMI)
• DeGiro
• Deutsche Bank (from VUMI)
• eToro
• Freedom24
• Ibercaja (from VUMI)
• IBKR
• iBroker (uses IBKR)
• ING (from VUMI)
• Inversis (from VUMI)
• Metagetsion (from VUMI)
• Mexem (uses IBKR)
• MyInvestor (New 29 May 2024)
• Renta4 (from VUMI)
• Revolut
• Santander (from VUMI)
• Singular Bank (from VUMI)
• Scalable Capital
• Trading 212
• TradeRepublic (coming soon)
• Other Brokers not supported (Valid for clickTrade, ING, HeyTrade, TradeRepublic,..)

Coming soon

• Quantfury
• Sabadell
• SelfBank
• Trade Republic

VUMI

¿Quién es VUMI? Vumi es una empresa española de software de gestión de cartera que analiza tus inversiones de una forma visual, clara y concisa. Con Vumi puedes conectar todos los brókers, bancos o exchanges que quieras.

From the platform VUMI you can obtain extracts from the following platforms:

• BBVA
• SANTANDER
• METAGESTION
• BANKINTER
• ANDABANK
• CAIXABANK
• RENTA4
• INVERSIS
• ING
• MYINVESTOR
• SINGULAR BANK

Coming soon:

• ING
• SABADELL
• SELFBANK

The instructions are:

1/ Create an account on https://app.vumi.io/auth/register

2/ Adding assets/entities to connect all your entities

3/ Steps to download the CSV file that will later be used in Autodeclaro:

• Ir a “Mi Patrimonio”->”Inversiones financieras“
• Go to "Movimientos“
• Download excel of the table of movements.

• Seleccionar todos los campos disponibles:

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

DeGiro

Note Model 720: Only transactions from the last year 2024 are required for the 720 model. Exclude dividends.

Auto Renta generates the profit and loss report from of the full transaction history since the account was opened and of the 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

Note on AutoFx commission on DeGiro (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% from that date onwards.

This information is not included in the CSV of transactions, so at Autodeclaro, we account for this commission in the Profit and Loss Report.

Note: If you have transferred positions to DeGiro or from DeGiro to another broker, they will be identified as purchases or sales in the statement.

We have been told that in the annual report DeGiro takes transfers to another broker as sales. These operations should be removed if you want them to be ignored.

Contact us if you need assistance in identifying these records.

1/ Go to DeGiro WebTrader

2/ Click on the "Mailboxin 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 AUTO-RENTA: 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/2025’ (ensure compliance two months beyond the end of the year 2024)

Note AUTO-720: Year 2024 only. start date ’01/01/2024′ and end date ’31/12/2024′

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: Continue with the extract from Dividends (Statement of account) 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 statements are in a language other than English, adjustments must be made to the statement.

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 AUTO-720: Dividends do not have to be provided for the 720 model.

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 "Mailboxin 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/2025′. The report will show the history of Dividends collected up to the date you specify.

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 Language of extracts: If your statements are in a different language (English, Italian, Dutch, etc.), you have to make adjustments to the statement by modifying the header by the English texts and also the Dividend and currency exchange concepts.

• Dutch
• English

Dutch:

In this example, the CSV header of the bank statement CSV 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 in the Dutch a English:

• Dividend by Dividend
• Dividendbelastng by Dividend withholding
• Valuta Creditering by Income Foreign Exchange
• Valuta Debitering by Withdrawal Currency Exchange

It would look like this:

English:

In this example, the CSV header of the bank statement CSV is in English:

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 in the English a English:

• Dividend Tax by Dividend withholding
• Dividend by Dividend
• FX Credit by Income Foreign Exchange
• FX Debit by Withdrawal Currency Exchange

Interactive Brokers

Note: The platforms Mexem and iBroker use the same statements as IBKR, they can use them to obtain their P&L report for income.

Note Model 720: Only transactions from the last year 2024 are required for the 720 model. Exclude dividends.

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:

Attention:

Was your account migrated at the end of 2020 and 2021 due to the UK's exit from the European Union? or

Have you transferred shares between IBKR accounts?

In that case, it is likely that you will not be able to select dates prior to migration or transfer.

To make the migrated account information visible, it must be activated as follows.

1/ Go to your IBKR identifier

2/ This will open the window on the right and go to the "Filter

3/ Activate or tick the option "Migrated". and then go to "Apply"..

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 (Note: Select ONLY if you want position transfers to/from another broker to be taken as sales/purchases)

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". (Note: Select ONLY if you want position transfers to/from another broker to be taken as sales/purchases)

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 AUTO-720: Select operations from the 1 January to 31 December 2024.

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

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

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

Notes: Note that date ranges (Start date and To date) must be entered starting with the end date (field To date) instead of the start (Start date), by mistake, does not warn you and creates a file with only one date.

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

Dividends

Note AUTO-720: Dividends do not have to be downloaded for the Form 720.

Note 17 May 2024: As some clients have reported to us that the dividend "Flex Queries" query is not getting all dividends (Unilever, Iberdrola for now), we will use the "Dividend report which we detail below how to obtain it.

However, CSVs from the flex query that was used until now will also be valid, but not both types will be attached.

DIVIDEND REPORT - Use this report, new from 17 May 2024

1/ Enter to Client Portal.

2/ Go to the tab "Performance & Statements (Performance and Reporting) -> "Tax Documents (Tax documents).

3/ In the section "Taxesselect the year you want to download the "Dividend report in format CSV.

4/ Once downloaded it will have the name: UXXXXXXXXX.2023.dividends.csv . Remove the identifier code and VERY IMPORTANT put the year at the end of the file.

It would remain: “nameany_2023.csv".

Note: If you wish, you can download previous years to get the dividend report for previous years together with the dividend list once you place your order.

5/ You can also remove personal data from the CSV file for privacy but it will not be used by Autodeclaro for any purpose.

Open with file editors such as "Notepad" or "Notepad++" on Windows or "TexEdit" on Mac (DO NOT OPEN WITH EXCEL) and go to line 2.

The result would be to leave line 2 (important to leave commas): Account,Data,,,,EUR,

FLEX CONSULTATION - See note of 17 March 2024 above

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 2023 (first school day) at 31 December 2023and 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:

Trade Republic

Estamos trabajando para automatizar el informe fiscal de Trade Republic.

A día de hoy (9 de abril del 2025) Trade Republic no ha enviado informe fiscal para la declaración de la Renta, únicamente un informe fiscal para el Modelo 720 y 721 pero no válido para la Renta.

Actualizaremos las instrucciones cuando tengamos la funcionalidad necesaria para tratar los informe fiscales de Trade Republic para generar el informe de PyG junto al resto de brokers.

Freedom24

Estamos trabajando para automatizar el informe fiscal de Freedom24.

Por ahora puedes utilizar la plantilla de broker no soportados. Habría que trasladar la información del excel de operaciones de Freedom24 a dicha plantilla.

Puedes descargar las operaciones de dos maneras:

• OPCIÓN 1: INFORMES DEL CORREDOR
• OPCIÓN 2: INFORME DE TRANSACCIONES PARA LA DECLARACIÓN DE IMPUESTOS

OPCIÓN 1: INFORMES DEL CORREDOR

1/ Ir a tu perfil de Freedom24 y seguir los pasos de ir a “Cuenta del cliente” -> “Informes del corredor” -> “Elegir periodo”

Note: elegir desde la fecha que se abrió la cuenta para descargar el histórico completo

2/ Una vez elegido el periodo, descargar el formato Excel.

3/ Una vez tengas el excel, puedes trasladar la información a la plantilla de brokers no soportados.

OPCIÓN 2: INFORME DE TRANSACCIONES PARA LA DECLARACIÓN IMPUESTOS

1/ Ir a tu perfil de Freedom24 y seguir los pasos de ir a “Cuenta del cliente” -> “Informes del corredor” -> “Informe de transacciones para la declaración de impuestos”

2/ Descargar todos los reportes anuales desde que abrió la cuenta, en el formato Excel, para tener el histórico completo de operaciones

Trasladar las operaciones a la plantilla de broker no soportados desde el excel de operaciones de Freedom24 a dicha plantilla.

Scalable Capital

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

Below are instructions on how to obtain Scalable Capital transactions and dividends (all in one file):

• Export history Scalable Capital

1/ From the Broker's account select TRANSACTIONS

2/ In TRANSACTIONS: Click on the ORDER TYPE and select all (or select none until now automatically selects all).

3/ Click on DATE and choose the CUSTOM INTERVAL of interest, in our case, the complete history.

4/ Leave ALL SELECTED activated (IMPORTANT) and finally "EXPORT TO CSV" and the file is downloaded.

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: 18 June 2024The web option no longer shows the investments, you have to go directly to the app).

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

2/ Go to the section on "Invest.

3/ go to Invest", "... More", "... More" and choose "Documents.

4/ Go to "Account statement

5/ Select "Excel" You can set the start date since you opened your account and the end date of your choice, at the latest February of the following year of the year you are making the income tax return. And click on "Get Statement.

You will need to obtain a file in CSV format.

Note: El movil te sugerirá abrirlo con alguna aplicacion. Puedes usar “Google Sheets” y luego en el menú de la aplicacion ir a “Hacer copia” y lo guardas en el dispositivo, donde generara un archivo con formato y extensión CSV. Lo puedes enviar por correo para abrirlo con el ordenador.

No abra el fichero con excel, ni lo guarde en ese formato, podria hacer una copia del mismo si desea abrir y ver el contenido con Excel.

If you open it with Notepad, you can see that it will have a similar structure to this one:

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 2024 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 which you download from the eToro platform, which is used on the platform Self-declared:

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 2024). And click on "Create:

With the downloaded excel it could be used on the Autodeclaro platform. Create a ZIP with all the statements if you have other brokers and you can make your Auto-Renta purchase process at:

MyInvestor

MyInvestor has been integrated into Autodeclaro since 29 May 2024.

To obtain the list of Transactions and dividends, please follow the steps below:

1/ Visit the website of Inversis (www.inversis.com/cbmyinvestor).

2/ Go to Client Access to log in with your MyInvestor username/ID and password.

Note: If it doesn't work with the DNI, use your username.

3/ Once inside. Pull down the menu of "INVESTMENTS -> "Funds" -> "Operations and consultations -> "Consultation of operations"..

Note: By choosing Funds, then in the next filter you will have to indicate Product Type" -> "All" -> "AllThis way you will get Dividends, Buy/Sell shares, Funds, etc.

4/ In the operations filter, indicate the fields "Date From" and "Date To"and, in addition, the "Product Type" indicate the value All. In this way we ensure that all transaction history, dividends, funds, etc. come to us.

An Excel file will be downloaded with all movements of shares, funds and dividends.

Note: Do not make any modifications to this excel, just leave it as downloaded.

The downloaded Excel can be used to make the auto-income request to generate the profit and loss report from the statement of transactions and dividends.

Don't forget to ZIP all the statements you may have from various brokers when you make your Auto-Rent purchase process at:

Other brokers not supported

Auto Renta generates the profit and loss report from the 2023 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 dividends 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/ Please fill in the appropriate fields.

• ISIN: If you do not know it, you can use the ticker.
• Country: If indicated, it is taken into account, otherwise Autodeclaro calculates the country from the ISIN.
• Gross Dividend: Gross dividend in the currency indicated
• Tax/withholding tax: Indicate the tax or withholding tax applied in the currency you indicate
• Destination tax/withholding tax: Indicate the tax or withholding tax at destination (This only applies to brokers based in Spain, ING, Myinvestor, HeyTrade, CaixaBank, Bankinter, clicktrade, etc.).

3/ Once you have finished filling in your template, you can download the CSV at "Archive -> "Download". -> "Comma separated values (.csv)"..

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