How to obtain the statements for Auto-Renta?

Important: Please note that we will be unavailable from Saturday 23 May to Wednesday 3 June.. During this period delays are expected in any kind of query via email or whatsapp, sorry for the inconvenience.

Currently Auto Renta is available for the following brokers. There is also a generic template that can be filled in for the following brokers. brokers not supported.

Note: Remember that 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.

New 2026: Unfortunately VUMI has ceased to provide services, so that brokers BANKINTER, BBVA, CAIXABANK, IBERCAJA, DEUTSCHE BANK, SANTANDER, METAGESTION, ANDBANK , RENTA4 are no longer available. through its platform.

DeGiro

Note Model 720: Only transactions from the last year 2025 are required for Form 720. Dividends are not included.

Note 2026: Currently options trading is not supported when there are allocations and maturities. Review the results of the report after purchase to resolve any inconsistencies.

Auto Renta generates the profit and loss report from of the full transaction and dividend history since the account was opened. 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 your complete transaction and dividend history you can make your purchase process at:

Please review the following detailed notes before downloading extracts:

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.
• If deactivated, the autoFx commission is not added.
• On the basis of binding consultation: V2324-10. Purchases and sales that are not in Euro currency will be converted into Euros at the exchange rate indicated by DeGiro at the time of the transaction.

Note Position transfers:

• 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 transactions should be removed from the downloaded CSV if you do not want them to be taken into account.

Note Tobin Tax (purchase of Spanish shares)

• The Tobin tax is included from this 2026 campaign. It increases the commission on the purchase of the share.

Dividend short positions

• When short positions are held, a negative dividend is generated, i.e. a dividend is paid. It does not offset other dividends, but is a capital loss in box 1656. This is detailed in the Autodeclaro report.

Note Bonds and coupons

• The purchase and sale of bonds and collection of coupons is supported.

Note Language not English:

• It is advisable to check the results as the lack of Spanish may affect the reading of the information. At the end of the instructions you will find the correct header in Spanish, but if you detect that any information has been omitted, please do not hesitate to contact us.

Transactions

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/2026’ (ensure compliance two months beyond the end of the year 2026)

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,Reference Exchange,Execution Venue,Number,Price,Price,,Local Value,,EUR Value,Exchange Rate,AutoFX Commission,Transaction and/or External Costs EUR,Total EUR,Order ID,

Dividends

Note AUTO-720: Dividends do not have to be provided for the 720 model.

Note:

• Coupons collected on the Bonds will be reflected as dividends in the report. (new 2026)
• 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/2026′. 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 - Mexem

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

Self-rented operation notes (important to read):

• 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..
• If you trade derivatives, futures, options, review the results of the report to ensure that everything is covered as expected.
• "La Options trading, Currently, Autodeclaro provides for the allocation of shares at the strike purchase price, and the premium is reported as a capital gain. In this case the premium received does not reduce the average purchase price with the receipt of the premium as IBKR does in its reports, which is why the values in the Autodeclaro and IBKR reports are not similar in this type of operation.
  • However, a modification is pending to take into account the binding consultation V2172-21. In the case of allotment, the shares are acquired at the quoted price on the day of allotment and a loss arises from the difference between the quoted price and the strike price.
• The short operation is supported from this year 2026 onwards, but I also check that the results are as expected.
• Autodeclaro converts all transactions in shares with a currency other than EURO (purchases and sales), which is why the final data differs from the results of the IBKR activity report. Based on the binding consultation V2324-10
• It has been detected that IBKR extracts rarely have some quantities without decimal separator, which disproportionately alters the results in the resulting PDF report.
• Bonds and coupon collection is supported.

INSTRUCTIONS

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 (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.

Note: Specify CSV format and activate the option to include column headers.

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 2025.

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

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

• 2026-01-01 to 2026-03-01
• 2025-01-01 to 2025-12-31
• 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.

The file to download appears on the right hand side, if it does not, refresh the web page.

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.

Specific notes IBKR dividends:

• For dividends, the full history would not be necessary, unless you want your dividend income history to be shown as well.
• The coupons of the bonds appear in the dividend statement and are unified with the dividends.

However, the CSVs of the Flex query used so far will also be valid, but do not attach both types.

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 .

• You can remove the identifier code from the filename.
• VERY IMPORTANT put the year at the end of the file in the following format:
  • It would remain: “nameany_2025.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

Note: Do not provide this CSV of the flex query if the previous csv of the dividend report has already been provided.

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.

LIGHTYEAR

Auto Renta generates the profit and loss report from Lightyear's complete transaction history.

Lightyear provides a PDF excerpt to date 31 December 2025 as shown in the example below. The instructions for preparing the CSV used in Autodeclaro are:

1/ Go to the Lightyear platform https://lightyear.com/transactions

2/ Select “Transactions” -> “Download report”.” and “Statement of account”. Download the CSV

3/ Select the “Start date” "Start date" "Start date" "Start date" "Start date" "Start date" "Start date" as Lightyear's account opening date and end date you can enter 1 March 2026 to consider the 2 months to verify the two-month rule

Then click on “Export CSV”.

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

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.

Note: 2026, it has been detected that the history itself does not report corporate actions, such as splits, that have occurred and the number of shares is not updated.

• E.g. In 2020 Apple suffered a 1:4 split if you bought 1 share before the split, then the sale appears after the split for 4 shares, but the purchase only has 1 share.

The solution would be to review the transaction history received by autodeclaro and see if the purchases match the sales, and update the 212 trading history to adjust the splits manually.

Although we have consulted the Trading 212 Customer Service team, if you find that your statement does not show the splitting correctly, you should contact the Trading 212 Customer Service team to correct it.

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

Trade Republic

Note 24 April 2026: Trade Republic is fully supported by Autodeclaro. Please contact us if you detect any missing information, as new cases may arise.

Error in fiscal data: as we already announced in networks, It seems that the information sent by Trade Republic to the AEAT is not 100% correct. With Autodeclaro you can perform the calculations and delete any information you have in your draft on Trade Republic to incorporate it again.

Functionality

• Support stocks, funds, cryptocurrencies, bonds.
• Collection of dividends, bond coupons
• Interest earned on the account

Instructions 2026

From 2026 onwards, Trade Republic generates a CSV with all movements. Below are the steps to download the CSV.

1/ Go to the Trade Republic APP. Go to “Profile” (top right icon)

2/ Select “Statements“

3/ “Select the period”.” from the beginning of the opening of the account until 1 March 2026 (to take into account the 2-month rule)

Note: Send the statement by mail to your email address and you will have it at your disposal.

Once you have obtained the statement you can make your purchase process at:

Instructions before 2026 (do not use, CSV option above will be used)

For the broker Trade Republic, we will use the annual tax report sent by the broker in PDF format, we will explain how to prepare the statements, you will have to copy the PDF and transfer it to a text file such as Notepad or TexEdit on Mac.

We will take the 2023 report as a reference.

Note 1: If you use Mac, use the programme “Text-edit”.

• Transactions
• Dividends

Example:

1/ Transactions:

For transactions, copy the section “III. Capital gains and losses”.” from the PDF and bring it into Notepad.

Note: copy all pages. It is recommended to open with Chrome browser, select the text and scroll down with the “wheel” of the mouse.

Paste the copied information into Notepad:

Once we have this file ready, we save it.

2/ Dividends

For the dividends, create a new file and copy the section “I. Income from movable capital”.” from the PDF and bring it into Notepad.

Note: Only copy the dividend lines, as interest payments are not supported.

Note: copy all pages. It is recommended to open with Chrome browser, select the text and scroll down with the “wheel” of the mouse.

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

Fidelity

1/ Transactions, you have to go to:

"Documents -> “Tax Forms” -> Choosing the “year” and click on “CVS Format” of the rightmost column

2/ Dividends

a. Click on the “desired account”.” -> “More” -> “Tax Info YTD”

b. Choose the year and click on the desired section; in this case “...".“Ordinary Dividends and Distributions"

c. Click on “Ordinary Dividends"

d. Finally, by clicking on the “download arrow”, you will download a .CSV file with the details of the desired information.

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

Freedom24

From 27/04/2026, Autodeclaro can automate the tax reporting of Freedom24, both transactions and dividends. Also the generation of deposit earnings (which are OTC purchases and sales).

Previously it was suggested to use the broker not supported where you had to transfer the information from the Freedom24 operations excel to the Freedom24 template, but this is no longer necessary.

You can download the operations and dividends through:

• TRANSACTION REPORT FOR THE TAX RETURN

TRANSACTION REPORT FOR THE TAX RETURN

1/ Go to your Freedom24 profile and follow the steps of going to “Customer account” -> “Broker reports”.” -> “Transaction reporting for tax purposes”.”

2/ Note: Download all the annual reports (all years) since the account was opened, in Excel format, to have a complete history of operations.

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

ClickTrade

ClickTrade is owned by iBroker. We have confirmed that:

• Derivatives: Use the Interactive Brokers interface. You can obtain the statements by following IBKR's instructions.
• Actions: Use Saxo broker. We do not support this broker.

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.

Note 2026US dividends are paid with withholding tax of 15% already included, European stock dividends are not.

• It has been noted that dividends from European shares are not included with withholding tax and are collected in full, so they will be shown in the report as “EU” country without withholding tax. But it is recommended to check this if you have non-US dividends and confirm this in case it might change at some point.

CFDs / Overnight Commissions

For CFDs, a Overnight commissions on all CFD positions held. Buy/sell transactions are generated so that these results appear in the report and will be used as losses.

INSTRUCTIONS

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: The phone will suggest you to open it with an application. You can use “Google Sheets” and then in the application menu go to “Make a copy”.” and save it on the device, where it will generate a file with CSV format and extension. You can send it by email to open it on your computer.

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.

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 statement with the transaction history 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 “Personalised“ (Choose date of etoro account opening and end date today's date can be). 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:

XTB

From 4 May 2026 XTB statements will be supported.

You have to download an excel file where you can find the movements/transactions and dividends.

Note:

• For CFD type movements, a commission is created to match the profit and loss; as the buy and sell price in the excel, does not exactly match the profit or loss generated according to the XTB excel.
• The Tobin Tax (buying shares in Spain) and Stamp Duty (UK) commissions that appear in the “Cash Operations” tab of the Excel that you download are considered, and appear included as a commission in Autodeclaro transactions. That is why the result of the operations in XTB does not include this commission and you will see differences if these commissions exist.

1/ Go to XStation5 -> https://xstation5.xtb.com/#/_/login

2/ Go to Overview -> History

3/ Go to Export. Then create “New report” -> select date range since the creation of the account. The full transaction history is required to perform the FIFO correctly.

Choose New Report :

• Date from: ensure that it is from the date the account was created. If you do not know, you can enter 2010.
• Date until: indicate 1 March 2026.
  • This is necessary to ensure that the 2-month rule is validated, including January and February 2026.

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

MyInvestor

MyInvestor has been integrated into Autodeclaro since 29 May 2024.

Note: Please review the results of Autodeclaro with the PDF report from myinvestor and your personal income tax data reported. Inversis offers the excel with net amounts in all your movements, but when transferring data to the AEAT, there are certain particularities that we have detected.

However, the following has been detected with regard to the tax data they send:

• Actions:
  • Purchases are reported net: i.e. gross purchase cost minus commissions.
  • Sales are reported gross: i.e. net plus expenses; and then these expenses are identified as expenses.
  • Result: the net amount of the transaction must be the same as Autodeclaro's. (Except for transactions in another currency, there may be a mismatch due to the exchange rate used by Inversis, Autodeclaro takes the ECB's exchange rate)
• Funds
  • If the result of the sale is positive; The sales amount is the net amount from the excel of inversis + the calculation of the 19% withholding tax. We believe that an artificial amount is being added for the withholding tax reported to the AEAT.
  • If the result of the sale is negative; The net sales amount is reported and has no withholding tax.

Here is an example of a Funds trade with a screenshot of a real result:

• Self-declared calculates a profit of 45.04€. according to the net amount of inversis. This gain will then be subject to a withholding tax.
• Inversis sends the AEAT €55.60 gross profit: €45.04 + €10.56 for 19% withholding tax which adds up to €55.60 gross. We believe that this €10.56 is artificially added.

However, for loss-making operations, the result does coincide with tax data.

INSTRUCTIONS

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

• Step 1: Extract the list of inversis movements

• Step 2: copy the dividend table from Myinvestor's tax report

Step 1: Extract the list of inversis movements

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.

Step 2: Copy the dividend table from Myinvestor's tax report

Note: Open PDF with browser Chrome.

Note 1: If you use Mac, use the programme “Text-edit”., para windows, el programa Notepad

1/ Open the “tax report”.” -> go to section “Dividends and income from shareholdings in entities”.”

2/ Copy the table with the list of dividends.

Note: Copy from browser Chrome.

3/ Transfer the information to a text file in Notepad or Notepad ++.

Note: Se espera que la columna “DIVISA” sea siempre “EUR”. Si tienes otra divisa, contáctanos, ya que creemos que aunque indicara otra divisa ej. “USD” los importes que se indican están en EUROS.

Note: If you have dividends that take up more than 1 page in the PDF, the text will appear in linear form. It is processed correctly, it would be correct, as shown below.

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

Other brokers not supported

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

Dividends from brokers not previously supported can also be attached.

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/ Fill in the template (do not forget to indicate the full transaction history):

• 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 it is not compulsory (Column N), If not stated, the European Central Bank exchange rate shall be used.
• Field currency (Column M); 3. E.g. EUR, USD, GBP, etc.
• If you do not know the ISIN (Field F), fill in only the field Ticker (Field H).
  • Note: For the field Ticker, Make sure you use the same one as it looks like on the yahoo website:
    • e.g. Diageo would be DGE.L https://es.finance.yahoo.com/quote/DGE.L/
    • eJ. BBVA would be BBVA.MC https://es.finance.yahoo.com/quote/BBVA.MC/

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. International format e.g. US, ES, GB, IT, etc.
• 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:

DO YOU USE MAC?

In those brokers where it is necessary to copy information from the PDF, it is recommended to do the following in the “Text Edit” programme.

1/ Choose format “Convert to plain text”.”

2/ The display format will change

3/ Once you have pasted the content, save the file in UTF-8 format with the extension “.csv”.”

---