How to obtain extracts for Auto-720

Instructions for obtaining the Form 720 from the portfolio of securities deposited in the broker or crowdlending platform you are using.

Many of them provide extracts with all the information necessary to fill in the TAX FORM MODELO 720but other brokers do not include e.g. the ISIN.

Don't worry, Autodeclaro fills in the ISIN automatically and other missing fields, so you don't have to search for it manually.

Below is the type of statement and how to obtain it for the following brokers.

Note: If you use a broker or crowdlending platform not listed in this table, contact us if you want us to integrate it into the Autodeclaro platform.

However, we offer a generic template to be filled in with information from any broker or crowdlending platform.

Broker	Full excerpt	It does not provide (and calculated by Autodeclaro)
DeGiro	Yes	–
Interactive Brokers (IBKR)	Yes	–
eToro (Act. 23 March 23)	YES in PDF	–
Revolut	Yes	–
Trade Republic	Yes	–
Charles Schwab	No	ISIN
eTrade	No	ISIN
Interactive Investors	No	ISIN
XTB	Yes	–
Trading 212	No	ISIN, Description, Currency
Admiral Markets	No	ISIN
DIF Broker	Yes	–
Scalable Capital	Yes	–
Generic Template (Valid for any broker)	Yes

Crowdlending	Full excerpt	It does not provide (and calculated by Autodeclaro)
ViaInvest	Yes	–
Mintos	Yes	–
Generic Template (Valid for any Crowdlending platform)	Yes	–

If you have any questions or problems, please do not hesitate to contact us at contact.

---

Have you filed the Form 720 before?

No problem, Autodeclaro will make the relevant calculations so that your Form 720 takes into account returns already filed.

To do this, you will need to provide the brokers' statements as follows:

• Statements for the last year of the financial year in which you are going to file the Form 720..
  • It will probably be from 2022. So you will have to download the statements as of 31 December 2022.
• Extracts for the year of the financial year of the Form 720 submitted..
  • If you filed Form 720 for 2020, you will need to download the statements as of 31 December 2020.

Finally, the file with the position statement for the year you are going to file the Form 720 and the file with the position statement for the last year of the Form 720 already filed, you must indicate its year at the end of the file name.

For example. "DeGiro2020.csv" or "namewhowants2022.csv".

We will explain a practical example, please note that your situation may be different:

• I am a DeGiro broker, and I filed the last model 720 for the financial year 2020.

• Now I have to to file Form 720 for the 2022 financial year.

What do I have to do?

1. Download the position statement as at 31 December 2020.
2. Download the position statement as at 31 December 2022.
3. Rename the files by adding their year to the end of the file name.
4. Ex. "Degiro2020.csv" and "Degiro2022.csv"..
5. Finally, make a zip file with both files. The zip file is the one that will be attached in the purchase process.

Do I have more than one broker?

No problem, attach all position statements in the ZIP file. If they were declared in previous years, indicate the year at the end of the file as above.

---

DeGiro

Instructions for obtaining the TAX FORM MODELO 720 from DeGiro where we have to export the statement of our open positions as follows:

1/ Enter the DeGiro website

2/ Go to "Portfolio"-> "Open Positions"

4/ Once you have chosen the option of "Export", we will only have to indicate the date 31 December of the year we want to obtain and the CSV" format to proceed with the download.

Note DeGiro: The DeGiro statement provides the Euro conversions of non-Euro positions. However, it does not calculate the conversions using the ECB (European Central Bank) exchange rates. Autodeclaro will not use this amount in Euro, but will calculate it using the ECB exchange rate as of 30 December 2022.

Note: If you filed the Form 720 previously, remember to download also the statement of the last year in which you filed the Form 720, as explained here.

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

Interactive Brokers (IBKR)

Instructions on how to obtain the statement from Interactive Brokers

1/ Go to Client Portal of IBKR

2/ Go to "Performance and reporting in the main menu and then to "Flex consultations".

3/ Create a flex consultation on the button "+".

We then indicate a name such as Modelo 720 and select ".open operations" :

4/ Choose the following fields that you want to appear in the report:

• ISIN
• Description
• Quantity
• Currency
• Position Value
• Asset Class

5/ Mark the indicated fields and click on "save" button at the bottom of the list of fields.

6/ Leave the default fields and click on "continue".

7/ Summary of your flex query created. Click on "Create"

8/ Confirmation message for the newly created flex query. Click on "Accept"..

9/ The newly created flex query will now appear. Execute the query in the "blue icon with white date"..

10/ We will run the query by specifying the following parameters in the pop-up shown below:

• Period': Customise data range
• Start date': 2022-12-30
• As at': 2022-12-30
• ‘Format': 'CSV

11/ After a few seconds, the report will be downloaded to your device. 

Note: If you filed the Form 720 previously, remember to download also the statement of the last year in which you filed the Form 720, as explained here.

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

eToro

IMPORTANT Update 23 March 2023

Autodeclaro integrates the eToro broker as of tax report Form 720 that etoro gives to customers in the form of PDF. It is called "TaxReport Mod.720 2022 eToro.pdf". You can ask eToro support, if you don't have it.

The integration with Autodeclaro will be completed today. Please note that the sales information that is included in this eToro report is not included, as it may be sales of purchases during the 2022 financial year. Sales are calculated by Autodeclaro by comparing the 2021 statement with the 2022 statement. The information on the sales, both the amount and the date of extinction, must be entered by hand later in the tax authorities, once the Form 720 generated by Autodeclaro has been imported. At the end of the eToro instructions, it is indicated how to proceed to send your statement of the previous year in case you have submitted the Form 720 last year.

The steps you need to follow are:

1/ Copy from the PDF all V and I type positions from the 'eToro PDF Extract'.It starts from the header to the end (in the image below you can see the selected content in blue). Once copied, it will be pasted into Notepad or Notepad++ of Windows.

2/ Select from the beginning to the end of the last position. This may include several sheets if your extract is long.

Trick: If you select at the beginning, press the "shift" key and scroll with the mouse wheel to the last sheet and click at the end of the last position.

3/ Once copied from the PDF, open Notepad and paste the content. You can save it with a '.CSV' extension such as "Portfolio_etoro.csv". The result would look like this:

Problem: There are page breaks in the PDF that cut off the registration information. As shown below.

Solution:

1/ Adapt the information in notepad, adjusting the record that has been cut with the information below.

2/ Do nothing in the CSV extract it has generated, and enter this information by hand in the 720 model once it has been imported into the tax office (AEAT).

Note: If you filed the Form 720 previously, you have to do step 2, twice (open positions of the year you are filing and the last one filed), as the last year in which you filed the Form 720 is also required, as explained here.

For example if you want the years 2022 and 2021, you should get two excels in which you have to indicate the year at the end of the filename. "Portfolio_etoro_2021.csv" and "Portfolio_etoro_2022.csv".

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

Revolut

In Revolut, we will have to download the December report via the Revolut APP.

1/ Go to the "second blue icon" in the bottom menu and then click on the "three dots".

2/ Then go to "Statements".

3/ And finally, choose the month of December, where you can download the PDF with the status of our portfolio as of the last day. 31 December.

4/ Once you have downloaded the PDF, send it by email to your email address to open it on your laptop or PC with a PDF reader such as "Adobe Acrobat".

5/ Then select and copy the contents of the table from the header to the end (in the image above it is indicated within a red frame). Once copied, it will be pasted into the Notepad or Notepad++ of Windows.

Note 1: If you use Macuse the programme "Text-edit.

Note 2: It is recommended to use "Adobe Acrobat or open the PDF with "Google Chromeif the content is not formatted as shown below when pasted.

6/ Save it with extension '.CSV'. such as "Portfolio_Revolut.csv".

Note: If you filed the Form 720 previously, remember to download also the statement of the last year in which you filed the Form 720, as explained here.

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

TRADE REPUBLIC

Trade Republic deposits the securities in Germany.

Trade Republic will provide a statement listing securities as at 31 December, as shown in the example below.

In order to automate the 720 model, you need to obtain the Trade Republic statement provided in "Your profile". To do this you need to log in to your Trade Republic account.

Note: In the statement, the cash appears, but this will not be part of the Autodeclaro automation and you will have to include it by hand once you import the resulting form 720 into the tax tool you are going to file it with.

1/ Log in to Trade Republic: https://app.traderepublic.com/

2/ Go to "Profile" and look for the "Annual Tax Report of the relevant year. In the screenshot it is 2021. And download the PDF document.

3/ Open the PDF document, select and copy the content of the table from section III. Model 720 to the end (in the image below you can see the selected content in blue). Once copied it will be pasted into Notepad or Notepad++ of Windows.

4/ Select from the beginning to the end of the last position. This may include several sheets if your extract is long.

Trick: If you select at the beginning, press the "shift" key and scroll with the mouse wheel to the last sheet and click at the end of the last position.

5/ Once copied from the PDF, open Notepad and paste the content. You can save it with a '.CSV' extension such as "Portfolio_TradeRepublic.csv". The result would look like this:

Note: If you filed the Form 720 previously, remember to download also the statement of the last year in which you filed the Form 720, as explained here.

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

CHARLES SCHWAB

Charles Schwab deposits securities in the United States.

Charles Schwab provides a daily extract in PDF, as shown in the example below.

In order to automate the 720 tax return, you need to obtain the PDF statement provided in your Charles Schwab account.

Note: In the statement, the cash appears, but this will not be part of the Autodeclaro automation and you will have to include it by hand once you import the resulting form 720 into the tax tool you are going to file it with.

Note 2: Charles Schwab does not provide the ISIN in the statement, but the security symbol. For this reason, Autodeclaro has a large list of symbols with the corresponding ISIN. However, it may be the case that a security is not found. Therefore, in the generated Form 720 the ISIN will be empty and would have to be entered manually.

1/ Log in to Charles Schwab: https://client.schwab.com/Login/SignOn/CustomerCenterLogin.aspx

2/ Go to "Accounts in the main menu and in the submenu go to "Statements

3/ Download the PDF for 31 December 2022 or the year you wish to generate the Form 720.

4/ Open the PDF document, select and copy the contents of the table from "Investment Detail - Equities to the end (in the image below you can see the selected content in blue). Once copied, it will be pasted into Windows Notepad or Notepad++.

5/ Select from the beginning to the end including the "Total Equities" line. This may include several sheets if your statement is long.

Trick: If you select at the beginning, press the "shift" key and scroll with the mouse wheel to the last sheet and click at the end of the last record of the "Total Equities".

6/ Once copied from the PDF, open Notepad and paste the content. You can save it with a '.CSV' extension such as "Portfolio_CharlesSchwab.csv". The result will look like this (you can delete the lines containing your personal data):

Note: If you filed the Form 720 previously, remember to download also the statement of the last year in which you filed the Form 720, as explained here.

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

ETRADE

Etrade deposits securities in the United States.

Etrade provides a year-end statement in PDF format for the last quarter, as shown in the example below.

In order to automate the 720 form, you need to obtain the PDF statement provided in your Etrade account.

Note: In the statement, the cash appears, but this will not be part of the Autodeclaro automation and you will have to include it by hand once you import the resulting form 720 into the tax tool you are going to file it with.

Note 2: Etrade does not provide the ISIN in the statement, but the security symbol. This is why Autodeclaro has a large list of symbols with the corresponding ISIN. However, it may be the case that a security is not found. Therefore, in the generated Form 720 the ISIN will be empty and would have to be entered manually.

1/ Log in to Etrade: https://us.etrade.com/e/t/user/login

2/ Download the PDF for 31 December 2022 or the year you wish to generate the Form 720.

3/ Open the PDF document, select and copy the content of the table to the end (in the image below you can see the selected content in blue). Once copied it will be pasted into Notepad or Windows Notepad++.

4/ Select from the beginning to the end including the header line. This may include several sheets if your extract is long.

Trick: If you select at the beginning, press the "shift" key and scroll with the mouse wheel to the last sheet and click at the end of the last record of the "Total Equities".

5/ Once copied from the PDF, open Notepad and paste the content. You can save it with a '.CSV' extension such as "Portfolio_etrade.csv". The result would look like this:

Note: If you filed the Form 720 previously, remember to download also the statement of the last year in which you filed the Form 720, as explained here.

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

INTERACTIVE INVESTORS

Interactive Investors deposits securities in the UK.

Interactive Investors provides a year-end statement in PDF which is that of the last quarter, as shown in the example below.

In order to automate the 720 model, you need to obtain the PDF statement provided in your Interactive Investors account.

Note: In the statement, the cash appears, but this will not be part of the Autodeclaro automation and you will have to include it by hand once you import the resulting form 720 into the tax tool you are going to file it with.

Note 2: Interactive Investors does not provide the ISIN in the statement, but the security symbol. For this reason, Autodeclaro has a large list of symbols with the corresponding ISIN. However, it may be the case that a security is not found. Therefore, in the generated Form 720 the ISIN will be empty and would have to be entered manually.

1/ Log in to Interactive Investors: https://secure.ii.co.uk/webbroker2/

2/ Download the PDF for 31 December 2022 or the year you wish to generate the Form 720.

3/ Open the PDF document, select and copy the content of the table to the end (in the image below you can see the selected content in blue). Once copied it will be pasted into Notepad or Windows Notepad++.

4/ Select from the beginning to the end including the header line. This may include several sheets if your extract is long.

Trick: If you select at the beginning, press the "shift" key and scroll with the mouse wheel to the last sheet and click at the end of the last record of the "Total Equities".

5/ Once copied from the PDF, open Notepad and paste the content. You can save it with a '.CSV' extension such as "Portfolio_InteractiveInvestors.csv".

For those lines where the "Stock Symbol" is not indicatedAdd any text, e.g. XXX. The result would be as follows:

Note: If you filed the Form 720 previously, remember to download also the statement of the last year in which you filed the Form 720, as explained here.

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

XTB

XTB deposits securities in the country of origin of the securities themselves. In other words, shares belonging to Spanish companies are deposited in Spain. In this case, we would not have to include them in form 720.

However, if we have shares from any country other than Spain, these are deposited in the country in question, so we will be obliged to declare them on form 720.

XTB will provide a statement with the list of securities as of 31 December, as shown in the example below.

To automate the 720 model, you must obtain the XTB statement provided by XTB in the "Client's Corner". To do this you need to log in to your XTB account.

1/ Go to XTB's xStation 5: https://xstation5.xtb.com/?branch=es#/_/login

2/ Go to "My Account" -> "Customer Corner".

3/ Go to "My Profile -> Documents . Download the document "Foreign OMI Portfolio Statement 31 December 2022 - XXXX.pdf"..

 

4/ Open the PDF document, select and copy the contents of the table from the first line position to the end (indicated in yellow in the image below). Once copied it will be pasted into Notepad or Windows Notepad++.

Note: the extracts have been changing according to the year, here are the examples for the years 2021 and 2022

Extract 2021

You can save it with a '.CSV' extension such as "Portfolio_XTB.csv".

Extract 2021

Extract 2022

Note: If you filed the Form 720 previously, remember to download also the statement of the last year in which you filed the Form 720, as explained here.

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

Trading 212

Trading 212 provides a "monthly statement" where you will find your open trades up to the last day of that month. To get the position summary, you will have to wait for the monthly statement email for December, which is usually on the 2-3rd of January.

In the example below you select and copy the contents of the table underneath "Open positions at the end of the day".:

Then select and copy the contents of the table from the header to the end (in the image above it is indicated inside a red frame). Once copied, it will be pasted into Notepad or Notepad++ of Windows.

You can save it with a '.CSV' extension such as "Portfolio_T212.csv".

 

Note: If you filed the Form 720 previously, remember to download also the statement of the last year in which you filed the Form 720, as explained here.

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

Admiral Markets

1/ Admiral Markets provides a "daily statement" in your email in which you will find your open trades up to that day. To file Form 720 we will need to open the 31 december email.

2/ Then select and copy the contents of the table from the header to the end (in the image above it is indicated inside a red frame). Once copied, it will be pasted into Notepad or Notepad++ of Windows.

You can save it with a '.CSV' extension such as "Portfolio_ADM.csv".

3/ The Admiral Markets statements do not include the currency of the amounts indicated, so it must be entered manually in the CSV file. In the header, include the new "Currency" field at the end, tab separated. In the subsequent lines, enter the currency code (USD, EUR, GBP, etc), as shown in the example below.

Note: If you filed the Form 720 previously, remember to download also the statement of the last year in which you filed the Form 720, as explained here.

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

DIF Broker

DIF broker provides a complete PDF as of 31 December of the previous fiscal year. To create the CSV file or extract, follow the steps below.

1/ Copy from the PDF all the positions in the section "Open Positions: 2021-12-31".It starts from the header to the end (in the image below you can see the selected content in blue). Once copied, it will be pasted into Notepad or Notepad++ of Windows.

Note: It is recommended to open the PDF with Chrome browser. We have detected that with PDF acrobat or Microsoft Edge, it does not allow copying from the pdf.

2/ Select from the beginning to the end of the last position. This may include several sheets if your extract is long.

Trick: If you select at the beginning, press the "shift" key and scroll with the mouse wheel to the last sheet and click at the end of the last position.

3/ Once copied from the PDF, open Notepad and paste the content. You can save it with a '.CSV' extension such as "Portfolio_DIF.csv". The result would look like this:

Note: If you see personal data on your statement, delete these lines, there is no problem and they are not necessary for the process.

Note: If you filed the Form 720 previously, you have to do step 2, twice (open positions of the year you are filing and the last one filed), as the last year in which you filed the Form 720 is also required, as explained here.

For example if you want the years 2022 and 2021, you should get two excels in which you have to indicate the year at the end of the filename. "Portfolio_DIF_2021.csv" and "Portfolio_DIF_2022.csv".

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

Scalable Capital Broker

Scalable Capital broker does not provide a CSV of positions as of a given date, but does so through its custodian bank. Baader Bank.

provides a complete PDF as of 31 December of the previous fiscal year. To create the CSV file or extract, follow the steps below.

1/ Go to Baader Bank customer section: https://konto.baaderbank.de

Enter your passwords in the "User ID" and "PIN" fields.

Note: If you don't know these details, look for an e-mail from Kundenservice@baaderbank.de with the issue "Account Opening Confirmation where a PDF with this information is attached.

2/ Once inside, go to the "Downloads" section and look for the following CSV of type WDP.

Period: last working day of the year. For 2022 indicate 30 December 2022 and in 2023 it is 29 December 2023.

3/ Once you have downloaded the CSV of type WDP, you can use it to obtain your Model 720.

Note: If you filed the Form 720 previously, you have to do step 2, twice (open positions of the year you are filing and the last one filed), as the last year in which you filed the Form 720 is also required, as explained here.

For example if you want the years 2022 and 2021, you should get two excels in which you have to indicate the year at the end of the filename. "Portfolio_Scalable_2021.csv" and "Portfolio_Scalable_2022.csv".

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

Generic template

If you have a broker or crowdlending platform that is not on the list of supported ones, you can contact us at to see if it is possible to integrate it.

However, we offer the option of entering the information in a generic template where you can fill it in yourself.

1/ Go to the available staff.

2/ Follow the instructions to download or copy to your Google Drive space.

3/ Download the template in CSV format. To generate your form 720.

Note: If you filed the Form 720 previously, you have to do step 2, twice (open positions of the year you are filing and the last one filed), as the last year in which you filed the Form 720 is also required, as explained here.

For example if you want the years 2022 and 2021, you should get two excels in which you have to indicate the year at the end of the filename. "Portfolio_Template_2021.csv" and "Portfolio_Template_2022.csv".

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

VIAINVEST

Viainvest deposits the Notes in the country of origin of the securities themselves. That is to say, Notes belonging to Poland are deposited in Poland.

Note: Autodeclaro discards those positions from the extract that are not Notes, i.e. do not have an ISIN.

Viainvest will provide a statement with all your account information as of 31 December, as shown in the example below. This tax statement to fill in the tax form 720 must be requested directly to Viainvest's support team.

To automate the model 720, we need to obtain the extract from Viainvest which is in .HTML format (Web page). But we need the CSV format. The steps to obtain the CSV format are detailed below.

1/ Go to Google Drive and open a new spreadsheet.

2/ Open the extract in .HTML format in your web browser.

3/ Select the table (including header) of the section "Active investments in financial instruments at closing date"..

5/ Paste the content into the spreadsheet that we have opened in Google Drive. And it will look like this:

6/ go to "File" -> "Download -> "comma separated values (.csv)".

7/ Once the file has been downloaded in .CSVis ready for use in Autodeclaro.

Note: If you filed the Form 720 previously, remember to download also the statement of the last year in which you filed the Form 720, as explained here.

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---

MINTOS

Notes are deposited by Mintos in Latvia, which is the country where the securities are located, and are not dependent on the originator. That is, for Notes originated in Poland, these securities are issued and held in Latvian entities controlled by the Mintos Group, which has its tax headquarters in Latvia.

Currently each "note" has a nominal value of €0.01. In other words, if you have €1.25, you would have 125 notes or number of securities.

Note: Autodeclaro discards those positions from the extract that are not Notes, i.e. do not have an ISIN.

Mintos will provide a statement with a list of "Notes" and "Loans" as of 31 December, as shown in the example below. This tax statement to fill in the tax form 720 must be requested directly from Mintos through its SAC (Customer Service) .

To automate the 720 model, we need to get the extract from Mintos which is in XSLX (Excel) format. But we need the CSV format. The steps to obtain the CSV format are detailed below.

1/ Go to Google Drive and upload the file provided by mintos in XSLX format.

2/ Open the file in Google Drive and go to "File" -> "Download -> "comma separated values (.csv)".

3/ Once the file has been downloaded in .CSVis ready for use in Autodeclaro.

IMPORTANT: Remove the numeric identifier at the beginning of the file name. Any number at the beginning of the filename indicates the number of holders.

Note: If you filed the Form 720 previously, remember to download also the statement of the last year in which you filed the Form 720, as explained here.

Once you have all the statements ready, you can buy your completed Form 720 in a few minutes.

---