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 Fields for Spain Invoices Received

• XML Fields for Spain Cash Collections

• XML Fields for Spain Investment Goods Register

• XML Fields for Specific Intra-Community Transactions

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	—
RegistroLRfacturasEmitidas
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 #
NumSerieFacturaEmisorResumenFin	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
FechaExpedicionFacturaEmisor	Date the invoice was issued	—	Transaction Date
FacturaExpedida
TipoFactura	Details of the invoice type to be registered that can be any of the following: Normal invoice Correction invoice tickets Invoice issued to replace invoices	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.
NumSerieFacturaEmisorResumenFin	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
FechaExpedicionFacturaEmisor	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
ClaveRegimenEspecialOTrascendencia	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
FacturaSimplificadaArticulos7.2_7.3	Simplified invoices that identify the recipient	—	Transaction > Spain SII Reporting > Simplified Invoice Article 7.2 7.3
RegPrevioGGEEoREDEMEoCompetencia	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
FacturaSinIdentifDestinatarioArticulo6.1.d	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
EmitidaPorTercerosODestinatario		—	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: S1 – When there are no reverse charge lines S2 – When all the lines are reverse charge S3 – When there are both lines	—
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
ImporteTAIReglasLocalizacion	Net amount in euro if the item is not subject to tax due to location rules.	—	Transaction > Tax Exemption Details This tag shows when: The Tax Exemption Details you select is N2. The Special Scheme Code you select is Code 08.
ImportePorArticulos7_14_Otros	Net amount in euro if the item is not subject to tax due to Article 7.14.	—	This tag shows when: The Tax Exemption Details you select is N1. The Special Scheme Code you select is Code 10.
DesgloseTipoOperacion	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: S1 – When there are no reverse charge lines S2 – When all the lines are reverse charge S3 – When there are both lines	—
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
ImporteTAIReglasLocalizacion	Net amount in euro if the item is not subject to tax due to location rules.	—	Transaction > Tax Exemption Details This tag shows when: The Tax Exemption Details you select is N2. The Special Scheme Code you select is Code 08.
ImportePorArticulos7_14_Otros	Net amount in euro if the item is not subject to tax due to Article 7.14.	—	This tag shows when: The Tax Exemption Details you select is N1. The Special Scheme Code you select is Code 10.
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: S1 – When there are no reverse charge lines S2 – When all the lines are reverse charge S3 – When there are both lines	—
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
ImporteTAIReglasLocalizacion	Net amount in euro if the item is not subject to tax due to location rules.	—	Transaction > Tax Exemption Details This tag shows when: The Tax Exemption Details you select is N2. The Special Scheme Code you select is Code 08.
ImportePorArticulos7_14_Otros	Net amount in euro if the item is not subject to tax due to Article 7.14.	—	This tag shows when: The Tax Exemption Details you select is N1. The Special Scheme Code you select is Code 10.

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	—
RegistroLRfacturasRecibidas	Record Book of Invoices Received
PeriodoLiquidacion
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
NumSerieFacturaEmisor	NumSerieFacturaEmisor Number Series that identifies the invoice issued	—	Transaction > Reference No.
NumSerieFacturaEmisorResumenFin	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
FechaExpedicionFacturaEmisor	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: Normal invoice Correction invoice tickets Invoice issued to replace invoices	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.
FacturasRectificadas
IDFacturaRectificada
NumSerieFacturaEmisor	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.
FechaExpedicionFacturaEmisor	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
ClaveRegimenEspecialOTrascendencia	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
DescripcionOperacion	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
FacturaSimplificadaArticulos7.2_7.3	Simplified invoices that identify the recipient	—	Transaction > Spain SII Reporting subtab > Simplified Invoice Article 7.2 7.3
RegPrevioGGEEoREDEMEoCompetencia	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
InversionSujetoPasivo
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)
TipoRecargoEquivalencia	Associated percentage based on rate of VAT	—	Notional Rate of tax code with Surcharge property
CuotaRecargoEquivalencia	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)
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)
PorcentCompensacionREAGYP	Percentage compensation for special VAT arrangements for agriculture and fisheries	—	Tax Code Rate that is available when the Special Scheme Code is 02.
ImporteCompensacionREAGYP	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: The Issued Invoice Type you select is Simplified Invoice (ticket). The Special Scheme Code or Effect on Invoices Issued you select is Code 08 or 13. The ID Type in the Country of Residence field in the customer record is set to any of the following: Passport Official identification document issued by the country or territory of residence Residence certificate Other proof document

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.
FechaExpedicionFacturaEmisor	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	—
RegistroLRDetOperacion Intracomunitaria	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
OperacionIntracomunitaria
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
RegPrevioGGEEoREDEMEoCompetencia	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

General Notices