Spain - SII

SII and monthly data reconciliation. An advisable simple routine

With the experience gained after, almost, three months of helping companies with their SII obligations, we think worthwhile stressing the importance of a very simple routine which many may be tempted to dismiss as unnecessary.

We refer to the convenience to formally check and keep evidence that the data declared by the company at its monthly VAT returns is consistent with the data resulting from the SII registers for the same period. 

This routine is especially important at this initial stage when, assumedly, the SII has not been fully automated by companies and, as a result, it cannot be ascertained that all sets of data are fully consistent, namely: the ERP’s accounting data, the SII reporting data and the data that is produced for VAT declaration purposes.

When carrying-out the reconciliation between SII registers and VAT returns, a plus of attention must be paid to those set of data which may be especially problematic for SII reporting purposes, as may happen with those transactions that are to be specifically declared at the following boxes of form 303: 


It must be noted that the SII registers which have been filed by the company can be consulted at the website of the Spanish Tax Agency. So to help with the process Mr Jose Antonio Salas Caamaño provides a model template at the LinkedIn group “Suministro Inmediato de Información (SII)”, which allows to generate the XML file that is to be submitted to the Tax Agency’s site in order to retrieve the SII registers filed.

The template also includes instructions as to how to download the SII registers by period from the Tax Agency’s site, namely:

  1. Open de file named “SII extractor from AEAT.xlsx”.
  2. Fill in the sheet named “datos” correctly.

NIF: Type in the Spanish ID number.

RAZON SOCIAL: Type in the company name.

LIBRO: Select the type of book you want to get from the AEAT.



EJERCICIO: Select the year of the invoices.

Periodo: Select the period of the invoices.

  1. Copy the content of the sheet named “XML” (44 rows) and paste it in a .txt file you have previously created for this purpose.
  1. Save the .txt file in UTF-8 Codification.
  2. Access this link with a valid Spanish electronic signature certificate: AEAT WEB
  1. In the field named “URL endpoint (sin dominio)” select the same type of book you have already selected in the excel sheet named “datos”.

SuministroFactEmitidas = Issued invoices.

SuministroFactRecibidas = Received invoices.

  1. Browse the .txt file you have created and click on “Enviar”.
  2. Click on “Descargar respuesta” to save the answer from the AEAT.
  3. You can open this file in excel. Once you open it, please select the option “Import as XML table” to view the invoices properly. 

The above information was kindly provided by IVA Consulta, Spain. If you need any further information you can contact Pablo Lujan, email to:

Join incoming Conference

Linked In

News from the Board

Meeting with the French Tax Authorities

Representatives of the Board of the Association, Stephen Dale, Emmanuel Cottessat and Cyrille Konter, met with the DINR, the Non-Resident Unit of the French tax authorities in charge of EU companies not established in France but registered for VAT purposes in France.

Read more ...

News from IVA members

Sweden – Latest News

The Swedish Board for Advance Rulings has stated that rental of doctors should be regarded as a staffing service subject to VAT, despite the fact that the doctors providing VAT exempt medical services...

Read more ...

News from EC

COUNCIL DIRECTIVE amending Directive 2006/112/EC

COUNCIL DIRECTIVE amending Directive 2006/112/EC as regards the introduction of the detailed technical measures for the operation of the definitive VAT system for the taxation of trade between Member States.

Read more ...

Disclaimer:  The information contained in the present page is general and does not constitute legal advice. Before taking any decision or action on the above information you should take the appropriate professional advice.