List of XML Fields for Spain Online VAT Reports
The following tables include list of XML fields that are available on the generated Spain Online VAT Reports:
XML Fields for Spain Invoices Issued
XML Field |
Description |
Fixed Value |
NetSuite Field |
---|---|---|---|
Cabecera |
Header |
||
IDVersionSii |
Identification of the schema version used to exchange information |
1.1 |
— |
Titular |
|||
NombreRazon |
Company or Subsidiary legal name of the owner of the invoices issued ledger |
— |
Company or Subsidiary > Legal Name If the Legal Name is blank, this is sourced from the Name field. |
NIF |
The taxpayer ID or NIF (Número de Identificación Fiscal) associated with the owner of the ledger |
— |
Company or Subsidiary > VAT Registration No. |
TipoComunicacion |
Communication Type |
A0 -For Registration A1 -Error Correction |
— |
Registro |
|||
PeriodoLiquidacion |
|||
Ejercicio |
Tax Year of the invoice |
— |
This is sourced from the year in the Transaction Date field. |
Periodo |
Tax Period of the invoice |
— |
This is sourced from the month in the TransactionDate field |
IDFactura |
|||
IDEmisorFactura |
|||
NIF |
The NIF associated with the issuer of the invoice |
— |
Company or Subsidiary > VAT Registration No. |
NumSerieFacturaEmisor |
Invoice Number |
— |
Invoice # or Cash Sale # |
Num |
The serial number and invoice number details that identifies the last invoice entered in an invoice summary entry. |
— |
Transaction > Spain SII Reporting > Last Document Number of Summary Invoice |
Fecha |
Date the invoice was issued |
— |
Transaction Date |
FacturaExpedida |
|||
TipoFactura |
Details of the invoice type to be registered that can be any of the following:
|
In Issued Invoices, the default value for Invoice is F1 |
For Issued Amending reports, go to Transaction > Spain SII Reporting > Correction Type. For Issued Invoices, go to Transaction > Spain SII Reporting > Issued Invoice Type. |
TipoRectificativa |
Corrected Invoice Type |
For Issued Amending reports, the value is fixed to I. |
— |
FacturasRectificadas |
|||
IDFacturaRectificada |
|||
NumSerieFacturaEmisor |
Number Series that identifies the invoice issued |
— |
For Issued Amending Reports, the value is sourced from the credit memo or cash refund transaction's Created From field. If the Created From field is blank, or unavailable in the transaction, the value is sourced from the Original Invoice field in the Spain SII Reporting subtab. |
Num |
The serial number and invoice number details that identifies the last invoice entered in an invoice summary entry. |
— |
Transaction > Spain SII Reporting > Last Document Number of Summary Invoice |
Fecha |
Date the invoice was issued |
— |
For Issued Amending Report, this is sourced from the Transaction Date of the Invoice or Cash Sale Being Corrected. |
FechaOperación |
Transaction date that is different from the date of issue. |
— |
Transaction > Spain SII Reporting > Operation Date |
Clave |
Code that identifies the type of transaction or special tax scheme |
— |
For Issued Invoices Report, go to Transaction > Tax Reporting > Special Scheme Code or Effect on Invoices Issued For Issued Amending Report, go to Sourced from Invoice or Cash Sale being corrected > Special Scheme Code or Effect on Invoices Issued |
ImporteTotal |
Total invoice amount |
— |
Transaction Total Amount |
DescripciónOperación |
Description of the items in the invoice |
— |
Transaction > Memo (Header) |
RefExterna |
Free content field where internal information related to the transaction can be added |
— |
Transaction > Spain SII Reporting > External Reference |
Factura |
Simplified invoices that identify the recipient |
— |
Transaction > Spain SII Reporting > Simplified Invoice Article 7.2 7.3 |
Reg |
Identify invoices that may not be submitted to the tax agency on time because of a possible delay in the company’s compliance with SII requirements. |
— |
Transaction > Spain SII Reporting > Billing Record Cannot Be Submitted On Time |
Macrodato |
Identifies invoices with an invoice amount that is greater than €100 million. |
— |
Automatically set to S when ImporteTotal is equal to or greater than €100 million |
Factura |
Identify invoices with no counterpart information |
— |
Transaction > Spain SII Reporting subtab >Invoice With No Counterpart Article 6.1.D |
DatosInmueble |
|||
DetalleInmueble |
|||
SituaciónInmueble |
Identifier that specifies the location of the property |
— |
Transaction > Spain SII Reporting > Property Location |
ReferenciaCatastral |
Land register reference of the property |
— |
Transaction > Spain SII Reporting > Land Register/Cadaster Reference |
Emitida |
|
— |
Transaction > Spain SII Reporting > Issued by Third Party |
Contraparte |
|||
NombreRazón |
Company name of the Counterparty of the transaction |
— |
Customer Name |
NIF |
Identifier of the NIF of the Counterparty |
— |
Customer VAT Registration Number |
IDOtro |
|||
CodigoPais |
Country Code associated with the issuer of the invoice |
— |
Customer Billing Address country code |
IDType |
Type of identification in the country of residence |
— |
Customer > Financial > Tax Information > ID Type in the Country of Residence |
ID |
Identification Number in the country of residence |
— |
Customer > Financial > Tax Information > ID Number in the Country of Residence |
TipoDesglose |
|||
DesgloseFactura |
Reporting by Invoice |
||
Sujeta |
|||
Exenta |
|||
DetalleExenta |
|||
CausaExencion |
Field that specifies the cause of exemption, where applicable |
— |
Transaction > Spain SII Reporting > Tax Exemption Details |
BaseImponible |
The amount in euro that corresponds to the taxable and exempt amount |
— |
Transaction Total Amount |
NoExenta |
|||
TipoNoExenta |
Type of the subject and non-exempt transaction |
Depending on the transaction lines, the value is set to the following:
|
— |
DesgloseIVA |
|||
DetalleIVA |
|||
TipoImpositivo |
Percentage applied to the Taxable Base to calculate the tax payable |
— |
Tax Code Rate |
BaseImponible |
Amount that is subject to tax |
— |
Taxable Amount |
CuotaRepercutida |
Tax payable after applying a specific tax rate to the taxable base |
— |
Tax Amount (TipoImpositivo ×BaseImponible) |
TipoRecargoEqivalencia |
Associated percentage based on VAT rate |
— |
Tax Code Rate with Surcharge property |
CuotaRecargoEquivalencia |
Tax payable after applying the equivalence surcharge percentage to the taxable base |
— |
Tax Amount (TipoImpositivoEquivalencia ×BaseImponible) |
NoSujeta |
|||
Importe |
Net amount in euro if the item is not subject to tax due to location rules. |
— |
Transaction > Tax Exemption Details This tag shows when:
|
Importe |
Net amount in euro if the item is not subject to tax due to Article 7.14. |
— |
This tag shows when:
|
Desglose |
Reporting by transaction type |
||
PrestacionServicios |
|||
Sujeta |
|||
Exenta |
|||
CausaExencion |
Field that specifies the cause of exemption, where applicable |
— |
Transaction > Spain SII Reporting > Details of Subject and Exempt Transactions |
BaseImponible |
The amount in euro that corresponds to the taxable and exempt amount |
— |
Transaction Total Amount |
NoExenta |
|||
TipoNoExenta |
Type of the subject and non-exempt transaction |
Depending on the transaction lines, the value is set to the following:
|
— |
DesgloseIVA |
|||
DetalleIVA |
|||
TipoImpositivo |
Percentage applied to the Taxable Base to calculate the tax payable |
— |
Tax Code Rate |
BaseImponible |
Amount that is subject to a tax rate |
— |
Taxable Amount |
CuotaRepercutida |
Tax payable after applying a specific tax rate to the taxable base |
— |
Tax Amount (TipoImpositivo ×BaseImponible) |
NoSujeta |
|||
Importe |
Net amount in euro if the item is not subject to tax due to location rules. |
— |
Transaction > Tax Exemption Details This tag shows when:
|
Importe |
Net amount in euro if the item is not subject to tax due to Article 7.14. |
— |
This tag shows when:
|
Entrega |
|||
Sujeta |
|||
Exenta |
|||
DetalleExenta |
|||
CausaExencion |
This field specifies the cause of exemption, where applicable |
— |
Transaction > Spain SII Reporting > Tax Exemption Details |
BaseImponible |
The amount in euro that corresponds to the taxable and exempt amount |
— |
Transaction Total Amount |
NoExenta |
|||
TipoNoExenta |
Type of the subject and non-exempt transaction |
Depending on the transaction lines, the value is set to the following:
|
— |
DesgloseIVA |
|||
DetalleIVA |
|||
TipoImpositivo |
Percentage applied to the Taxable Base to calculate the tax payable |
— |
Tax Code Rate |
BaseImponible |
Amount that is subject to a tax rate |
— |
Taxable Amount |
CuotaRepercutida |
Tax payable after applying a specific tax rate to the taxable base |
— |
Tax Amount (TipoImpositivo ×BaseImponible) |
TipoRecargoEquivalencia |
Associated percentage based on rate of VAT |
— |
Tax Code Rate with Surcharge property |
CuotaRecargoEquivalencia |
Tax payable resulting from applying the equivalence surcharge percentage to the taxable base |
— |
Tax Amount (TipoImpositivoEquivalencia ×BaseImponible) |
No Sujeta |
|||
Importe |
Net amount in euro if the item is not subject to tax due to location rules. |
— |
Transaction > Tax Exemption Details This tag shows when:
|
Importe |
Net amount in euro if the item is not subject to tax due to Article 7.14. |
— |
This tag shows when:
|
XML Fields for Spain Invoices Received
XML Field |
Description |
Fixed Value |
NetSuite Field |
---|---|---|---|
Cabecera |
Header |
||
IDVersionSii |
Identification of the schema version used to exchange information |
1.1 |
— |
Titular |
|||
TipoComunicacion |
Type of operation, registration, or modification |
A0 – For Registration A1 – Error Correction |
— |
NombreRazon |
Company or Subsidiary legal name of the owner of the invoices received ledger |
— |
Company or Subsidiary > Legal Name If the Legal Name is blank, this is sourced from the Name field. |
NIF |
The NIF associated with the owner of the ledger |
— |
Company or Subsidiary > VAT Registration No. |
TipoComunicacion |
Communication Type |
A0 – For Registration A1 – Error Correction |
— |
Registro |
Record Book of Invoices Received |
||
Periodo |
|||
Ejercicio |
Tax Year of the invoice |
— |
This is sourced from the year indicated in the Accounting Date field of the Spain SII Reporting subtab. If this field is blank, this is sourced from the year indicated in the Date field of the transaction. |
Periodo |
Tax Period of the invoice |
— |
This is sourced from the month indicated in the Accounting Date field of the Spain SII Reporting Subtab. If this field is blank, this is sourced from the month indicated in the Date field of the transaction. |
IDFactura |
|||
IDEmisorFactura |
|||
NIF |
The NIF associated with the issuer of the invoice |
— |
Vendor VAT Registration Number |
IDOtro |
|||
CodigoPais |
Country Code associated with the issuer of the invoice |
— |
Country Code: From Vendor Billing Address |
IDType |
Type of identification in the country of residence |
— |
Vendor > Financial > Tax Information > ID Type in the Country of Residence |
ID |
Identification Number in the country of residence |
— |
Vendor > Financial > Tax Information > ID Number in the Country of Residence |
Num |
NumSerieFacturaEmisor Number Series that identifies the invoice issued |
— |
Transaction > Reference No. |
Num |
The serial number and invoice number details that identifies the last invoice entered in an invoice summary entry. |
— |
Transaction > Spain SII Reporting > Last Document Number of Summary Invoice |
Fecha |
Date on which the invoice was issued |
— |
Transaction > Spain SII Reporting > Invoice Date |
FacturaRecibida |
|||
TipoFactura |
Details of the invoice type to be registered that can be any of the following:
|
In Received Invoices reports, the default value for Invoice is F1 |
For Amending Transactions, go to Transaction > Spain SII Reporting > Correction Type. For Received Invoices, go to Transaction > Spain SII Reporting > Received Invoice Type. |
Facturas |
|||
IDFactura |
|||
Num |
Number Series that identifies the invoice issued |
— |
For Issued Amending Reports, the value is sourced from the Created From field of a credit memo or cash refund transaction. If this field is blank, or unavailable in the transaction, the value is sourced from the Original Invoice field in the Spain SII Reporting subtab. |
Fecha |
Date on which the invoice was issued |
— |
Transaction > Spain SII Reporting > Invoice Date or Transaction Date of the Bill being corrected |
FechaOperación |
Transaction date that is different from the date of issue. |
— |
Transaction > Spain SII Reporting > Operation Date |
Clave |
Code that identifies the type of transaction or special system with tax effect |
— |
For Received Invoices Report, go to Transaction > Spain SII Reporting > Special Scheme Code or Effect on Invoices Received For Received Amending Report, this is sourced from the Special Scheme Code or Effect on Invoices Received field of the corrected Bill. |
ImporteTotal |
Total invoice amount |
— |
Transaction Total Amount |
Descripcion |
Description of the items in the invoice |
— |
Transaction > Memo (Header) |
RefExterna |
This is a free content field where you can add internal information related to the transaction |
— |
Transaction > Spain SII Reporting > External Reference |
Factura |
Simplified invoices that identify the recipient |
— |
Transaction > Spain SII Reporting subtab > Simplified Invoice Article 7.2 7.3 |
Reg |
Identify invoices that may not be submitted to the tax agency on time because of a possible delay in the company’s compliance with SII requirements. |
— |
Transaction > Spain SII Reporting subtab > Billing Record Cannot Be Submitted On Time |
Macrodato |
Identifies invoices with an invoice amount that is greater than €100 million. |
— |
Automatically set to S when ImporteTotal is equal to or greater than €100 million |
DesgloseFactura |
|||
Inversion |
|||
DetalleIVA |
|||
TipoImpositivo |
Percentage applied to the Taxable Base to calculate the tax payable |
— |
Notional Rate |
BaseImponible |
Amount that is subject to a tax rate |
— |
Notional Taxable Amount |
CuotaSoportada |
Tax payable after applying a specific tax rate to the taxable base |
— |
Notional Tax Amount (TipoImpositivo ×BaseImponible) |
Tipo |
Associated percentage based on rate of VAT |
— |
Notional Rate of tax code with Surcharge property |
Cuota |
Tax payable resulting from applying the equivalence surcharge percentage to the taxable base |
— |
Notional Tax Amount (TipoImpositivoEquivalencia ×BaseImponible) |
DesgloseIVA |
|||
DetalleIVA |
|||
TipoImpositivo |
Percentage applied to the Taxable Base to calculate the tax payable |
— |
Tax Code Rate |
BaseImponible |
Amount that is subject to a tax rate |
— |
Taxable Amount |
CuotaSoportada |
Tax payable after applying a specific tax rate to the taxable base |
— |
Tax Amount (TipoImpositivo ×BaseImponible) |
Tipo |
Associated percentage based on rate of VAT |
— |
Tax Code Rate with Surcharge property |
Cuota |
Tax payable resulting from applying the equivalence surcharge percentage to the taxable base |
— |
Tax Amount (TipoImpositivoEquivalencia ×BaseImponible) |
Porcent |
Percentage compensation for special VAT arrangements for agriculture and fisheries |
— |
Tax Code Rate that is available when the Special Scheme Code is 02. |
Importe |
Compensation for special VAT arrangements for agriculture and fisheries |
— |
Tax Amount that is available when Special Scheme Code is 02. (PorcentCompensacionREAGYP ×BaseImponible) |
Contraparte |
|||
NombreRazón |
Company name of the Counterparty of the transaction |
— |
Vendor Name |
NIF |
Identifier of the NIF of the Counterparty |
— |
Vendor VAT Registration Number |
IDOtro |
|||
CodigoPais |
Country Code associated with the Counterparty of the transaction |
— |
The Country Code information from the Vendor Billing Address |
IDType |
Type of identification in the country of residence |
— |
Vendor > Financial > Tax Information > ID Type in the Country of Residence |
ID |
Identification Number in the country of residence |
— |
Vendor > Financial > Tax Information > ID Number in the Country of Residence |
FechaRegContable |
Transaction accounting date. To be used to calculate the deadline for invoices received |
— |
Transaction > Spain SII Reporting > Accounting Date. If this field is blank, the value is sourced from the Transaction Date. |
CuotaDeducible |
Deductible tax payable |
— |
This tag shows zero (0) in the reports when:
|
XML Fields for Spain Cash Collections
XML Field |
Description |
Fixed Value |
NetSuite Field |
---|---|---|---|
Cabecera |
Header |
||
IDVersionSii |
Identification of the schema version used to exchange information |
1.1 |
— |
Titular |
|||
NombreRazon |
Company or Subsidiary legal name of the owner of the cash collection ledger |
— |
Company or Subsidiary > Legal Name If the Legal Name is blank, this is sourced from the Name field. |
NIF |
The NIF associated with the owner of the ledger |
— |
Company or Subsidiary > VAT Registration No. |
TipoComunicacion |
Communication Type |
A0 |
— |
RegistroLRCobrosMetalico |
Record Book of Cash Collections |
||
PeriodoLiquidacion |
|||
Ejercicio |
Tax Year |
— |
This is sourced from the year in the Transaction Date field. |
Periodo |
Tax Period |
0A |
— |
Contraparte |
|||
NombreRazon |
Company or Subsidiary Name of the Counterparty of the transaction |
— |
Customer Name |
NIF |
Identifier of the NIF of the Counterparty |
— |
Customer VAT Registration Number |
IDOtro |
|||
CodigoPais |
Country Code associated with the Counterparty of the transaction |
— |
This is sourced from the country code of the invoice or Customer Billing Address |
IDType |
Type of identification in the country of residence |
— |
Customer > Financial > Tax Information > ID Type in the Country of Residence |
ID |
Identification Number in the country of residence |
— |
Customer > Financial > Tax Information > ID Number in the Country of Residence |
ImporteTotal |
Amounts over €6,000 that were paid in cash by the same person or entity |
— |
This is sourced from the value in the Amount field of a customer payment. |
XML Fields for Spain Investment Goods Register
XML Field |
Description |
Fixed Value |
NetSuite Field |
---|---|---|---|
Cabecera |
Header |
||
IDVersionSii |
Identification of the schema version used to exchange information |
1.1 |
— |
Titular |
|||
NombreRazon |
Company or Subsidiary legal name of the owner of the capital asset ledger |
— |
Company or Subsidiary > Legal Name If the Legal Name is blank, this is sourced from the Name field. |
NIF |
The NIF associated with the owner of the ledger |
— |
Company or Subsidiary > VAT Registration No. |
TipoComunicacion |
Communication Type |
A0 |
— |
RegistroLRBienes Inversion |
Record Book of Capital Assets |
||
PeriodoLiquidacion |
|||
Ejercicio |
Tax Year |
— |
This is sourced from the year in the Accounting Date field. If this field is blank, it is sourced from the Transaction Date field. |
Periodo |
Tax Period |
0A |
— |
IDFactura |
|||
IDEmisorFactura |
|||
NombreRazon |
Vendor Name |
— |
Vendor Name |
NIF |
Vendor NIF |
— |
Vendor VAT Registration Number |
IDOtro |
|||
CodigoPais |
Country Code associated with the Counterparty of the transaction |
— |
This is sourced from the Country Code in the Vendor Billing Address. |
IDType |
Type of identification in the country of residence |
— |
Vendor > Financial > Tax Information > ID Type in the Country of Residence |
ID |
Identification Number in the country of residence |
— |
Vendor > Financial > Tax Information > ID Number in the Country of Residence |
NumSerieFacturaEmisor |
Invoice document sequence name and number |
— |
Vendor Bill Transaction > Reference No. |
Fecha |
Date of Issue |
— |
Transaction > Spain SII Reporting > Invoice Date If the invoice date is not available, this is sourced from the Transaction Date field |
BienesInversion |
|||
IdentificaciónBien |
Description of the goods |
— |
Vendor Bill: Item Name |
FechaInicioUtilizacion |
Start date when the item is used |
— |
Transaction > Items > Service Date |
ProrrataAnualDefinitiva |
Final Annual Prorate |
— |
Transaction > Items > Annual Prorate |
RefExterna |
Free content field where internal information related to the transaction can be added. |
— |
Transaction > Spain SII Reporting > External Reference |
XML Fields for Specific Intra-Community Transactions
XML Field |
Description |
Fixed Value |
NetSuite Field |
---|---|---|---|
Cabecera |
Header |
||
IDVersionSii |
Identification of the schema version used to exchange information |
1.1 |
— |
Titular |
|||
NombreRazon |
Company or Subsidiary legal name of the owner of the Intra-community transactions ledger |
— |
Company or Subsidiary > Legal Name If this field is blank, the value is sourced from the Name field. |
NIF |
The NIF associated with the owner of the ledger |
— |
Company or Subsidiary > VAT Registration No. |
TipoComunicacion |
Communication Type |
A0 -For Registration A1 -Error Correction |
— |
Registro |
Record Book of Intra-community Transcations |
||
PeriodoLiquidacion |
|||
Ejercicio |
Tax Year of the invoice |
— |
This is sourced from the year in the Accounting Date field. If this field is blank, it is sourced from the Transaction Date field. |
Periodo |
Tax Period of the invoice |
— |
This is sourced from the month in the Accounting Date field. If this field is blank, it is sourced from the Transaction Date field. |
IDFactura |
|||
IDEmisorFactura |
|||
NombreRazon |
Issuer of Invoice |
— |
For Received Invoices, this is sourced from the Vendor Name. For Issued Invoices, go to Company or Subsidiary > Legal Name. If the Legal Name is blank, this is sourced from the Name field. |
NIF |
The NIF associated with the issuer of the invoice |
— |
For Received Invoices, this is sourced from the Vendor VAT Registration Number field. For Issued Invoices, this is sourced from value entered in the Company or Subsidiary's VAT Registration Number field. |
IDOtro |
|||
CodigoPais |
Country code associated with the issuer of the invoice |
— |
This is sourced from the country code entered in the Vendor Billing Address. |
IDType |
Type of identification in the country of residence |
— |
Vendor > Financial > Tax Information > ID Type in the Country of Residence |
ID |
Identification Number in the Country of Residence |
— |
Vendor > Financial > Tax Information > ID Number in the Country of Residence |
NumSerieFacturaEmisor |
Invoice Number |
— |
Vendor Bill Transaction > Reference No. Cash Sale Transaction > Transaction Number |
FechaExpedicionFactura Emisor |
— |
— |
Transaction > Spain SII Reporting > Invoice Date If not available, this is sourced from the Transaction Date field. |
Contraparte |
|||
NombreRazon |
Company or Subsidiary legal name of the Counterparty of the transaction |
— |
For Received Invoices, this is sourced from the Company or Subsidiary Name. For Issued Invoices, this is sourced from the Customer Name. |
NIF |
Identifier of the NIF of the Counterparty |
— |
For Received Invoices, this is sourced from the Company or Subsidiary’s VAT Registration No. field. For Issued Invoices, this is sourced from the Customer VAT Registration No. field. |
IDOtro |
|||
CodigoPais |
Country Code associated with the Counterparty of the transaction |
— |
This is sourced from the Country Code value of the Invoice or Customer Billing Address |
IDType |
Type of identification in the country of residence |
— |
Customer > Financial > Tax Information > ID Type in the Country of Residence |
ID |
Identification Number in the country of residence |
— |
Customer > Financial > Tax Information > ID Number in the Country of Residence |
Operacion |
|||
TipoOperacion |
Identifier of the intra-community transaction type |
— |
Transaction > Spain SII Reporting > Intra-Community Transaction Type |
ClaveDeclarado |
Intra-community transaction code |
For Invoices Issued, this is equal to D. For Invoices Received, this is equal to R |
— |
EstadoMiembro |
Code of Member State Origin or Transmission |
— |
Company or Subsidiary > Billing Country Code |
DescripcionBienes |
Description of Assets Acquired |
— |
Transaction > Memo (Header) |
DireccionOperador |
Address of Intracommunity Operator |
— |
Company or Subsidiary > Billing Address |
RefExterna |
Free content field where internal information related to the transaction can be added. |
— |
Transaction > Spain SII Reporting > External Reference |
Reg |
Identify invoices that may not be submitted to the tax agency on time because of a possible delay in the company’s compliance with SII requirements. |
— |
Transaction > Spain SII Reporting > Billing Record Cannot Be Submitted On Time |