What is it about?

SII stands for "Suministro Inmediato de Información del IVA".
“The obligation to file the VAT registers data on real time electronically.
The Official Gazette of 6 December 2016 published Royal Decree 596/2016, of 2 December, for the modernization, improvement and promotion of the use of electronic means in the management of the Value Added Tax. Among other novelties, the obligation to file in almost “real time” basis the data corresponding to all the transactions included at the VAT books is introduced (the, so-called, “Immediate Information System” or SII). The filing is to be made electronically through the website of the Spanish Tax Agency.
The obligation to file the VAT registers data on real time electronically is in force since 1st July 2017. It affects companies, resident or not, filing monthly VAT returns, namely:
Those considered as “large entrepreneurs” for VAT purposes
(turnover in Spain over EUR 6.000.000).
Those applying the so called REDEME
(special monthly VAT refund regime).
Those belonging to
Spanish VAT Groups.
Companies are meant to submit the required data in a XML meeting the requirements set up by the authorities, to be directly uploaded at the AEAT’s website every 4 days (exceptionally, 8 days during 2017) . The possibility to set up a webserver which automatize the filing procedure is contemplated by the authorities.” [ https://www.siispain.com/ ]
You can find more official information at this link: https://sede.agenciatributaria.gob.es/Sede/iva/suministro-inmediato-informacion.html

What do we have in Odoo?

A. DATA ARE AUTOMATICALLY SENT TO THE SPANISH TAX AGENCY

Starting from the latest 14 versions in Odoo there is a new module that allows to send invoices data in a XML file  directly to the Spanish tax agency (Agencia Tributaria Espanola). 

How to implement it?

1. Your database needs to have an accounting app and the spanish localization needs to be set. 

2. Select the application module and look for the module called “Spain-SII EDI Suministro de Libros” > Install it.

.

1. In your accounting settings you will now have a new menu called “Registro de libros connection SII” in which you can select the Spanish tax agency. 

1. If you are testing then be sure to check the box “check this box if test env:” such as in the screenshot of point (3).

2. To test it and to use it in production you will need to upload the certificate for EDI invoices in the menu “Accounting > Configuration > Certificates (ES) > Click on create”. You will need to upload your certificate and add the password.

3. Look at this short video to see the first 5 steps: https://watch.screencastify.com/v/nbh1g9o1I1n4saHclEGG 

4. Check that your company has the VAT correctly configured. Go to General settings > Companies > Manage companies > Click on companies > Select your company. Be sure that the VAT number contains ES at the beginning, otherwise the invoices will not be sent by Odoo and you will see this error: “Codigo[4122].Error en la cabecera” when you validate an invoice. The format to respect is the following: ESA12345674.

5. Test your flow. 

6. Create customer/supplier invoices with different fiscal localizations.

7. Validate them.

8. Click on process.

9. Review the xml files to check what is the data inside the document. 

Look at this video to see how it works: https://watch.screencastify.com/v/wpT7U5NnYBzYra5SDMir 

9. Start in production. 

After having successfully tested your different flows in accounting you can then start in production. 

To start in production you will have to follow the same steps until point 7. After that, remember to uncheck the box for the test environment. 

10. The data will be sent to the Spanish Tax Agency according to what is defined in the scheduled action “EDI: Ejecutar operaciones del servicio web”. In this case, the information is sent every 2 days. You can find the scheduled action in the technical menu > Scheduled actions.

11. You can check which invoices are already sent/to send/to cancel/canceled. You can use the filter “Electronic invoicing” that can be found in the invoices menu. 

Have a look at this video to see how it works: https://watch.screencastify.com/v/8nsbSx94wnvRTvdqZmJN 

12. Check the website of the Spanish tax agency if you have any doubts about how to create your invoices and SII. 

If you have PoS in your database applications, please have a look at this forum entry: https://www.odoo.com/forum/help-1/en-pos-localization-es-factura-simplificada-199743 

B. DATA CAN BE EXPORTED FROM THE DATABASE AND THEN SENT TO THE SPANISH TAX AGENCY

If you do not want your data to be automatically sent to the Spanish tax agency, you can also create exportation templates from the journal entry module and you can define which are the fields you want to see in the exported file. 

1. Go to accounting > Journal items> Select the journal items you need to send to the spanish tax agency according to their dates > click on action > Export

2. Add the fields you need to export and save your exportation template. 

3. Here you can find an example of a possible exportation template:

4. Export the file and transform it into an xml file and then upload the information inside the website of the spanish tax agency.