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

What Companies need to know to prepare for Brexit

The United Kingdom will leave the European Union (EU) at 11:00 pm of 29 March 2019...

Read more ...

News from IVA members

Federal Fiscal Court: Postal address on invoice permitted – no bad faith despite domicile address

In an invoice issued for the purpose of input VAT deduction, the supplier’s address is not required to be the place of his or her economic activity. This was decided by the German Federal Fiscal Court in two judgments of 21 June 2018 (V R 25/15 and V R 28/16). The German Federal Fiscal Court thus follows the EUCJ in the German rulings in Geissel and Butin – C-374/16 and C-375/16...

Read more ...

News from EC

News from Accountancy Europe September 2018

Luxembourg has adopted a new VAT grouping regime (article 11 of Directive 2006/112/EC refers). It replaces a previous regime which was restricted to entities only engaged in activities in the public interest...

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.