Log in / create account
Openbravo.com
Issues
Forge
University
View source | Discuss this page | Page history | Printable version   

Spainaeatmodelo303/Functional Documentation

Contents

Document sign-off

Role Name Sign-off date
PM Richard Morley
QA Pablo Sarobe
Development Victor Martinez
Development David Alsasua

Document Status

Date Author or editor Description of change Document status Document version
June 11th, 2010th Patricia San Juan Document creation Draft V1
June 12th, 2010th Patricia San Juan Document sent for review Final V1

Overview & Justification

Purpose

The purpose of this document is to describe the functional specifications for a new commercial module which is the “303 VAT Settlement” as a valid file.

303 VAT Settlement is aimed to allow the end-user to calculate the amount to pay or collect from the Public Treasury as the difference between the VAT -fiscal Debit (In Spanish = "IVA repercutido") and the VAT-fiscal Credit (In Spanish = "IVA soportado").

303 VAT Settlement must be sent to the Tax Authorities either monthly or quarterly within the 20 days of the next Month/Quarter, respectively.

This report must be mandatory sent through the INTERNET – on line submission of a valid 303 file in case of monthly submission, otherwise (quarterly submission) end-user can choose between on-line submission or paper submission.

On line submission implies that the Spanish companies must have a Tax ID as well as a user Certificate X.509.V3 issued by FNMT or any other valid Certificate according to tax authorities requirements.

This new feature is going to be developed and delivered as a new commercial module which will be part of the Professional Edition of the Spanish Pack which will be implemented according to the Technical Documentation which can be found here : Spain AEAT Modelo 303 Technical Documentation

Scope

In Scope:

303 VAT Settlement submission as a valid txt file which can be submitted through below AEAT (Spanish Public Treasury) link:

303 On-line submission

This functionality takes into account as Deductible VAT, the VAT included in any "Account Payable" related transaction such as a purchase invoice or a payment to a vendor, which is 100% deductible.

New in the Scope!!

Due to the fact that there are new VAT Tax Rates valid From July 1st 2010 in Spain, a new version of the module needs to be develop. "Normal" VAT Tax rate valid starting from July 1st, 2010 is 18% (instead of 16%) "Reduced" VAT Tax rate valid starting from July 1st, 2010 is 8% (instead of 7%)

This new version of the module "303 VAT declaration" will allow the end-user to get a valid file according to the Spanish Tax authorities requirements detailed below:

"303 VAT declaration, for tax periods beginning July 2010 could have taxable transactions under the new tax rates (18%, 8%) together with others under the old tax rates (16%, 7%). In such cases:

Rest of File positions should remain the same.

Justification

303 VAT settlement is a legal requirement in Spain under "Orden EHA/3786/2008, dated on December 29th (BOE December 30th, 2008); which describes 303 VAT Settlement logical and physical design as well as the way and time for its submission to the Spanish tax authorities.

As said above 303 VAT Settlement main purpose is to calculate either the VAT to pay or the VAT to collect to/from the Spanish Tax Authorities as the difference between:

Above calculation must be mandatory done on a regular basis, either monthly or quarterly by all the VAT-payers.

New definitions and acronyms

VAT => Value-added tax

VAT Payable => Value-added tax included in any "Account Receivable" related transactions such a "sales invoice or a collection from a customer", in Spanish (IVA Devengado)

VAT Deductible => Value-added tax included in any "Account Payable" related transactions such a "purchase invoice or a payment to a vendor" which is 100% deductible, in Spanish (IVA Deducible) .

AEAT=> Acronyms for the Spanish Public Treasury = “Agencia Estatal de Administración Tributaria”

Tax Base Amount => it is the same as "Taxable Amount", which means the net amount VAT is calculated for, in Spanish "Base Imponible".

Tax Amount => VAT amount, in Spanish "Cuota"

Tax Rate => VAT %, in Spanish "Tipo %"

Total Amount => this one is the gross amount including VAT.

Users & business process description

User goals

303 VAT Settlement will allow the end user to:

  1. Get the VAT rates to be included in the 303 VAT Settlement properly Setup by getting them linked to the corresponding 303 output parameters.
  2. Generate 303 VAT Settlement for a given period, either a month or a quarter as a valid file according to Spanish Tax Authotities requirements.
  3. Review the 303 file generated by here "Formulario del modelo 303 para su presentación(predeclaración)"
  4. Submit 303 file to the tax authorities via INTERNET (on-line submission), in the following link: 303 Online Submission

User Roles and Personas

The following roles are involved:

Accounting Manager (Mary):
Mary is the accounting manager. She is the accountant responsible therefore she needs to make sure that the Company complies with the Law and the Tax requirements.

She should be able to review 303 tax report setup provided by OB and adjust it if required based on her company specific needs.

She should also be able to launch 303 tax report whenever needed in order to submit it to the tax authorities as a valid file.

Sales staff (Mike): Mike is an employee part of the sales staff. He will be the one issuing sales invoices including VAT in the system, which therefore must be part of the 303 VAT Settlement.

Purchase staff (Alice): Alice is an employee part of the purchase staff. She will be the one entering purchase invoices including VAT in the system, which therefore must be part of the 303 VAT Settlement.

Business scenario/s

Small Bazaar is an enterprise located in Spain made of several subsidiaries. Small Bazaar Holding is the parent company while, Small Bazaar Pamp and Small Bazaar Barc are two subsidiaries. Each subsidiary is modeled in OB ERP as a legal entity organization.

Sales transactions (June):

  1. On June 7th Mike issues a sales invoice to customer A (a National Small Bazaar Pamp customer).

Sales invoice amount is 11,600.00€ and it does include a VAT Payable = 1.600,00 €
VAT Rate = Entregas IVA 16%
Taxable Amount = 10.000,00€ Purchase transactions (June):

  1. On June 8th Alice enters in the system a purchase invoice from vendor Z (a National Small Bazaar Pamp vendor).

Purchase amount is 2,900.00€ and it does include a VAT Deductible = 400,00 €
VAT Rate = Adquisiciones IVA 16%> Taxable Amount= 2.500,00€

Dated on July 20th, Mary generate 303 VAT Settlement for June 2010 and she gets that Small Bazaar company needs to pay to the Tax authorities 1.200,00€ because
VAT Payable = 1.600,00€ > VAT Deductible = 400,00.

Sales transactions (July):

  1. On July 7th Mike issues a sales invoice to customer B (a National Small Bazaar Pamp customer).

Sales invoice amount is 11.800.00€ and it does include a VAT Payable = 1.800,00€
New VAT Rate valid starting July 1st, 2010 = Entregas IVA 18%
Taxable Amount = 10.000,00€

  1. On July 30th Mike issues a sales invoice to customer UE (an Intracommunity Small Bazaar Pamp customer).

Sales invoice amount is 7.500,00€ and it does include a VAT Payable = 0€
VAT Rate = Entregas intracouminitarias (N%=>0%)
Taxable Amount = 7.500,00€

Purchase transactions (July):

  1. On July 8th Alice enters in the system a purchase invoice from vendor USA (an International Small Bazaar Pamp vendor).

Purchase amount is 8.398,40€ and it does include a VAT Deductible = 1.158,40 €
VAT Rate = Importaciones 16%> Taxable Amount= 7.240,00€

  1. On July 30th Alice enters in the system a purchase invoice from vendor UE (an Intracomunity Small Bazaar Pamp vendor).

Purchase amount is 3.000,00€ and it does include a VAT Payable/Deductible = +/- 240,00€
VAT Rate = Adquisiciones Intracomunitarias 8%> Taxable Amount= 3.000,00€

Other transactions (July):

  1. On July 30th Peter enters in the system a payment of 1.180,00€ do not related to an invoice which includes a VAT amount = 180,00€, this last one linked to a VAT Rate = "Arrendamiento 18% (pagos)"

Dated on August 20th, Mary generate 303 VAT Settlement for July 2010 and she gets that Small Bazaar company will collect from the Tax authorities 18,40 € because
VAT Payable = 1.800,00€ + 0,00 - 240,00€ = 1.560,00€ < VAT Deductible = 1.158,40 + 240,00€ + 180,00€ = 1.578,40

Functional requirements

Functional Requirement 1 - Accounting Date

Transaction/Documents Accounting date is the date to take into account while retrieving tax transactions.

Companies must take into account:

In order:

Base on all of the above, the accounting date of the invoices/transactions is the date to be taken into account because:

VAT Settlements Periods, in case of monthly declaration, will go from the 1st day of the month to the last day of the month, which means:

Functional Requirement 2 - AEAT303 File Structure

303 File structure can be found in the following link:

303 File Structure - 1353 Positions

New!!

Functional Requirement 3- AEAT303 Constant Parameters

Based on above 303 VAT Settlement file structure there are several constant parameters which should always be enter by having same value/constant as listed below:

Position From Lenght Description (in spanish) Constant
1 2 Inicio del identificador de modelo y página "<T"
3 3 Modelo "303"
6 2 Página "01"
8 1 Fin de identificador de modelo ">"
70 2 Devengo (2) - Periodo "01", "02", "03",...,"12", "1T", "2T", "3T" or "4T"
1343 9 Identificador de Fin de Registro "</T30301>"


Above constant parameters should be setup by default in the Application path: Financial Management || Accounting || Setup || Tax Report || Tax Report - for a new record named "AEAT303_M" (Description = Modelo 303 Mensual) and "AEAT303_Q" (Decription = Modelo 303 Trimestral); and a Tax Report Group named "Constans".

Functional Requirement 4 - AEAT303 Input Parameters

Based on above 303 VAT Settlement file structure there are several inut parameters which should always be enter by the end-user while launching the 303 VAT Settlement:

Position From Lenght 303 VAT Settlement box Description (in spanish) Input data
10 1 n/a Tipo Declaración end user should select one of below values (in Spanish):

"C" = "Compensación" in case [48]<0
"D" = Devolución in case [48]<0 and
"Inscrito en el Registro de Devolución mensual = "1" = Yes
"I" = Ingreso in case [48]>0
"N" = Resultado cero in case [48]=0
"U" = Ingreso domiciliación bancaria
"G" = Ingreso Cuenta Corriente Tributaria
"V" = Devolución Cuenta Corriente Tributaria
(*) sys
"Inscrito en el Registro de Devolución mensual = "1" = Yes

65 1 n/a Inscrito en el Registro de Devolución Mensual

(*) this one could also be setup as a "Constant"

"1"= "Si" or "2" = "No"
391 17 [24] Liquidación (3)

IVA deducible - operaciones interiores corrientes bienes de inversión
Base Imponible [24]

Numeric
408 17 [25] Liquidación (3)

IVA deducible - operaciones interiores corrientes bienes de inversión
Cuota [25]

Numeric
459 17 [28] Liquidación (3)

IVA deducible - importaciones de bienes de inversión
Base Imponible [28]

Numeric
476 17 [29] Liquidación (3)

IVA deducible - importaciones de bienes de inversión
Cuota [29]

Numeric
527 17 [32] Liquidación (3)

IVA deducible - adquisiciones intracomunitarias de bienes de inversión
Base Imponible [32]

Numeric
544 17 [33] Liquidación (3)

IVA deducible - adquisiciones intracomunitarias de bienes de inversión
Cuota [33]

Numeric
561 17 [34] Liquidación (3) - Compensación Régimen Especial A.G y P [34] Numeric.

End user must enter here "ompensación Régimen Especial A.G y P" amount

578 17 [35] Liquidación (3) - IVA Deducible - Regularización Inversiones [35] Numeric.

End user must enter here "Regularización de las deducciones por Bienes de Inversión" amount

595 17 [36] Liquidación (3) - IVA Deducible - Regularización por aplicación del porcentaje def.de prorrata [36] Numeric.

End user must enter here "Regularización de las deducciones por Bienes de Inversion" amount based on the final %.
Only required in 4T or month 12.

646 5 [39] Liquidación (3) - Atribuible a la Administración del Estado % [39]

(*) this one could also be setup as a "Constant"

Numeric

Those VAT Payers of both Public Treasury="Administración del Estado" and "Diputaciones Forales del Pais Vasco o Navarra" must enter here the
% of transactions under Public Treasury.
For those VAT Payers of Public Treasury the % must be 100,00%

668 17 [41] Liquidación (3) - Cuotas a compensar de periodos anteriores [41] Numeric.

End user must enter here positive Tax Amounts to compensate coming from previous periods.

736 17 [45] Liquidación (3) - Exclusivamente tributación conjunta [45]
Resultado de la regularización anual 		Numeric.

End user must fill in here (for 4T or month 12) the anual regular amount.

770 17 [47] Liquidación (3) - A deducir (D.Complementaria) [47]
 Numeric.

End user must fill in here the positive VAT settlement amount already submitted for the same period, just in case Complementary Declaration.

821 1 n/a Marca sin actividad

which means that there have not been any VAT Payable and VAT deductible for a given period.

"0" = "No", "1"= "Si"
839 4 n/a Devolucion (6) - Código Cuenta Cliente - Entidad

(*) this one could also be setup as a "Constant"

An - Bank Account - Bank
843 4 n/a Devolucion (6) - Código Cuenta Cliente - Oficina

(*) this one could also be setup as a "Constant"

An - Bank Account - Office
847 2 n/a Devolucion (6) - Código Cuenta Cliente - DC

(*) this one could also be setup as a "Constant"

An. Bank Account - Control Digit
849 10 n/a Devolucion (6) - Código Cuenta Cliente - Número de cuenta

(*) this one could also be setup as a "Constant"

An. Bank Account - Account number
859 1 n/a Ingreso (7) - Forma de Pago

(*) this one could also be setup as a "Constant"

"0" = No consta
"1" = Efectivo
"2" = Adeudo en cuenta
"3"= "Domiciliación"
877 4 n/a Ingreso (7)- Código Cuenta Cliente - Entidad

(*) this one could also be setup as a "Constant"

An. Bank Account - Bank
881 4 n/a Ingreso (7) - Código Cuenta Cliente - Oficina

(*) this one could also be setup as a "Constant"

An. Bank Account - Office
885 2 n/a Ingreso (7) - Código Cuenta Cliente - DC

(*) this one could also be setup as a "Constant"

An. Bank Account - Digit Control
887 10 n/a Ingreso (7) - Código Cuenta Cliente - Número de cuenta

(*) this one could also be setup as a "Constant"

An. Bank Account - Account number
897 1 n/a Complementaria (8) Indicador de Autoliquidación Complementaria "0" = "No" , "1" = Si
898 13 n/a Complementaria (8) Nº justificante de la declaración anterior mismo periodo Numeric

Above input parameters should be entered by the end-user in the Application path: Financial Management || Accounting || Analysis Tools || Tax Report Launcher - "Input Parameters" process button, once AEAT303 data such as:

have been entered by the end-user

Functional Requirement 5 - AEAT303 Ouput Parameters

Position From Lenght 303 VAT Settlement box Description (in spanish) OB Data
11 9 n/a Identificación (1) - NIF Organization Tax ID
20 30 n/a Identificación (1) - Apellidos o Razón Social Organization Name
66 4 n/a Devengo (2) - Ejercicio Year selected by the end-user while launching 303 tax report
70 2 n/a Devengo (2) - Periodo Month or Quarter selected by the end-user while launchig 303 tax report

IVA Devengado

Position From Lenght 303 VAT Settlement box Description (in spanish) OB Data
72 17 [01] Liquidación (3)

IVA Devengado - Régimen general - Base Imponible [01]

The sum-up of all the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed below:

Arrendamiento 16% (cobros)
Arrendamiento 18% (cobros)
Arrendamiento 21% (cobros)
Arrendamientos 16% -18%R (cobros) (+16%)
Arrendamientos 16% -19%R (cobros) (+16%)
Arrendamientos 18% -19%R (cobros) (+18%)
Arrendamientos 18% -21%R (+18%)
Arrendamientos 21% - 21%R (+21%)
Entregas Bienes Inversión 18%
Entregas Bienes Inversión 21%
Entregas IVA 16%
Entregas IVA 18%
Entregas IVA 21%
Entregas IVA+Recargo 16+4% (+16%)
Entregas IVA+Recargo 18+4% (18%)
Entregas IVA+Recargo 21+5,2% (21%)
Servicios prestados nacional 16%
Servicios prestados nacional 16% -15%R (+16%)
Servicios prestados nacional 16% -7%R (+16%)
Servicios prestados nacional 18%
Servicios prestados nacional 18% -15%R (+18%)
Servicios prestados nacional 18% -7%R (+18%)
Servicios prestados nacional 21%
Servicios prestados nacional 21% -21%R (21%)
Servicios prestados nacional 21% -9%R (21%)
Transmisión B.Inmuebles 16%
Transmisión B.Inmuebles 18%
Transmisión B.Inmuebles 21%
New 2014 - The negative side of the "Inversión Sujeto Pasivo UE" and "Inversión Sujeto Pasivo no UE" Tax Rates, is removed from this box as specific boxes have been created for it, those are "Adquisiciones Intracomunitarias de bienes y servicios" [Casillas 10 y 11] and "Otras operaciones con inversión del sujeto pasivo," [Casillas 12 y 13] respectively.

89 5 [02] Liquidación (3)

IVA Devengado - Régimen general - Tipo % [02]

A Tax Rate (integer + 2 decimals) calculated as the division between

The sum-up of all the Tax Amounts linked to any of the VAT Payable Tax Rates listed below in [03] /
The sum-up of all the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed above in [01]

94 17 [03] Liquidación (3)

IVA Devengado - Régimen general - Cuota [03]

The sum-up of all the Tax Amounts linked to any of the VAT Payable Tax Rates listed above in [01]
111 17 [04] Liquidación (3)

IVA Devengado - Régimen general - Base Imponible [04]

The sum-up of all the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed below:

Entregas IVA 10%
Entregas IVA 7%
Entregas IVA 8%
Entregas IVA+Recargo 7+1% (+7%)
Entregas IVA+RE 8+1% (+8%)
Entregas IVA+RE 10+1.4% (10%)
Servicios prestados nacional 10%
Servicios prestados nacional 7%
Servicios prestados nacional 8%
Transmisión B.Inmuebles 7%
Transmisión B.Inmuebles 8%
New 2014 - The negative side of the "Inversión Sujeto Pasivo UE" and "Inversión Sujeto Pasivo no UE" Tax Rates, is removed from this box as specific boxes have been created for it, those are "Adquisiciones Intracomunitarias de bienes y servicios" [Casillas 10 y 11] and "Otras operaciones con inversión del sujeto pasivo," [Casillas 12 y 13] respectively.

128 5 [05] Liquidación (3)

IVA Devengado - Régimen general - Tipo % [05]

A Tax Rate (integer + 2 decimals) calculated as the division between

The sum-up of all the Tax Amounts linked to any of the VAT Payable Tax Rates listed below in [06] /
The sum-up of all the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed above in [04]

133 17 [06] Liquidación (3)

IVA Devengado - Régimen general - Cuota [06]

The sum-up of all the Tax Amounts linked to any of the VAT Payable Tax Rates listed above in [04]
150 17 [07] Liquidación (3)

IVA Devengado - Régimen general - Base Imponible [07]

The sum-up of the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed below:

Entregas IVA 4%
Entregas IVA + Recargo 4+0,5% (+4%)
Servicios prestados nacional 4%

167 5 [08] Liquidación (3)

IVA Devengado - Régimen general - Tipo % [08]

04,00
172 17 [09] Liquidación (3)

IVA Devengado - Régimen general - Cuota [09]

the sum-up of the Tax Amounts linked to any of the VAT Payable Tax Rates listed above in [07]
189 17 [10] Liquidación (3)

IVA Devengado - Recargo de Equivalencia - Base Imponible [10]

The sum-up of the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed below:

Entregas IVA+RE 16+4% (+4%)
Entregas IVA+RE 18+4% (+4%)
Entregas IVA+RE 21+5,2% (5,2%)

206 5 [11] Liquidación (3)

IVA Devengado - Recargo de Equivalencia - Tipo % [11]

A Tax Rate (integer + 2 decimals) calculated as the division between

The sum-up of all the Tax Amounts linked to any of the VAT Payable Tax Rates listed below in [12] /
The sum-up of all the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed above in [10]

211 17 [12] Liquidación (3)

IVA Devengado - Recargo de Equivalencia - Cuota [12]

The sum-up of the Tax Amounts linked to any of the VAT Payable Tax Rates listed above in [10]
228 17 [13] Liquidación (3)

IVA Devengado - Recargo de Equivalencia - Base Imponible [13]

The sum-up of the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed below :

Entregas IVA+Recargo 7+1% (+1%)
Entregas IVA+RE 8+1% (+1%)
Entregas IVA+RE 10+1,4% (1,4%)

245 5 [14] Liquidación (3)

IVA Devengado - Recargo de Equivalencia - Tipo % [14] = 01,00

A Tax Rate (integer + 2 decimals) calculated as the division between

The sum-up of all the Tax Amounts linked to any of the VAT Payable Tax Rates listed below in [15] /
The sum-up of all the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed above in [13]

250 17 [15] Liquidación (3)

IVA Devengado - Recargo de Equivalencia - Cuota [15]

The sum-up of the Tax Amounts linked to any of the VAT Payable Tax Rates listed above in [13]
267 17 [16] Liquidación (3)

IVA Devengado - Recargo de Equivalencia - Base Imponible [16]

The sum-up of the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed below:
Entregas IVA+Recargo 4+0,5% (+0,5%)
284 5 [17] Liquidación (3)

IVA Devengado - Recargo de Equivalencia - Tipo % [17] = 00,50

0,5%
289 17 [18] Liquidación (3)

IVA Devengado - Recargo de Equivalencia - Cuota [18]

The sum-up od the Tax Amounts linked to any of the VAT Payable Tax Rates listed above in [16]
306 17 [19] Liquidación (3)

IVA Devengado - Adquisiciones Intracomunitarias - Base Imponible [19]

The sum-up of the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed below:

Adquisiciones intracomunitarias 16% (-16%)
Adquisiciones intracomunitarias 4% (-4%)
Adquisiciones intracomunitarias 7% (-7%)
Adquisiciones intracomunitarias 18% (-18%)
Adquisiciones intracomunitarias 8% (-8%)
Adquisiciones intracomunitarias 21% (-21%)
Adquisiciones intracomunitarias bienes de inversión 18% (-18%)
Adquisiciones intracomunitarias bienes de inversión 21% (-21%)

323 5 [20] Liquidación (3)

IVA Devengado - Adquisiciones Intracomunitarias - Cuota [20]

The sum-up of the Tax Amounts linked to any of the VAT Payable Tax Rates listed above in [19]
340 17 [21] Liquidación (3)

IVA Devengado - Total cuota devengada [21]

Total Tax Amount for VAT Payable = [03]+[06]+[09]+[12]+[15]+[18]+[20]

IVA Deducible

Position From Lenght 303 VAT Settlement box Description (in spanish) OB Data
357 17 [22] Liquidación (3)

IVA deducible - operaciones interiores corrientes[22]

The sum-up of the Tax Base Amounts linked to any of the VAT Deductible Tax Rates listed below:

Adquisiciones B. Inmuebles 18%
Adquisiciones B. Inmuebles 21%
Adquisiciones B. Inmuebles 10%
Adquisiciones B. Inmuebles 8%
Adquisiciones IVA 16%
Adquisiciones IVA 4%
Adquisiciones IVA 7%
Adquisiciones IVA 8%
Adquisiciones IVA 10%
Adquisiciones IVA 21%
Arrendamiento 16% (pagos)
Arrendamiento 18% (pagos)
Arrendamientos 21% (pagos)
Arrendamientos 16% -18%R (pagos) (+16%)
Arrendamientos 16% -19%R (pagos) (+16%)
Arrendamientos 18% -19%R (pagos) (+18%)
Arrendamientos 18% -21%R (pagos) (+18%)
Arrendamientos 21% -21%R (pagos) (+21%)
Inversión Sujeto Pasivo no UE 16% (+16%)
Inversión Sujeto Pasivo no UE 18% (+18%)
Inversión Sujeto Pasivo no UE 21% (+21%)
Inversión Sujeto Pasivo no UE 21%-24.75%R (+21%)
Inversión Sujeto Pasivo no 7% (+7%)
Inversión Sujeto Pasivo no 8% (+8%)
Inversión Sujeto Pasivo no UE 10% (+10%)
Prestación servicios nacional 10%
Prestación servicios nacional 10% -9%R (+10%)
Prestación servicios nacional 16%
Prestación servicios nacional 16% -15%R (+16%)
Prestación servicios nacional 16% -7%R (+16%)
Prestación servicios nacional 18%
Prestación servicios nacional 18% -15%R (+18%)
Prestación servicios nacional 18% -1%R (+18%)
Prestación servicios nacional 18% -7%R (+18%)
Prestación servicios nacional 21% (+21%)
Prestación servicios nacional 21% -1%R (+21%)
Prestación servicios nacional 21% -21%R (+21%)
Prestación servicios nacional 21% -9%R (+21%)
Prestación servicios nacional 4%
Prestación servicios nacional 4% -9%R (+4%)
Prestación servicios nacional 7%
Prestación servicios nacional 8%
New 2014 New 2014 - The positive side of the "Inversión Sujeto Pasivo UE" is removed from this box as a specific box has been created for it, that is "Adquisiciones Intracomunitarias de bienes y servicios corrientes" [Casillas 36 y 37].

374 17 [23] Liquidación (3)

IVA deducible - operaciones interiores corrientes[23]

The sum-up of the Tax Amounts linked to any of the VAT Deductible Tax Rates listed above in [22]
425 17 [26] Liquidación (3)

IVA deducible - importaciones de bienes corrientes[26]

The sum-up of the Tax Base Amounts linked to any of the VAT Deductible Tax Rates listed below:

Adquisiciones a Canarias,Ceuta y Melilla 16%
Adquisiciones a Canarias,Ceuta y Melilla 18%
Adquisiciones a Canarias,Ceuta y Melilla 4%
Adquisiciones a Canarias,Ceuta y Melilla 7%
Adquisiciones a Canarias,Ceuta y Melilla 10%
Adquisiciones a Canarias,Ceuta y Melilla 21%
Importaciones 16%
Importaciones 4%
Importaciones 7%
Importaciones 10%
Importaciones 21%
Adquisiciones a Canarias,Ceuta y Melilla 18%
Adquisiciones a Canarias,Ceuta y Melilla 8%
Importaciones 18%
Importaciones 8%

442 17 [27] Liquidación (3)

IVA deducible - importaciones de bienes corrientes[27]

The sum-up of the Tax Amounts linked to any of the VAT Deductible Tax Rates listed above in [26]
493 17 [30] Liquidación (3)

IVA deducible - adquisiciones intracomunitarias de bienes corrientes[30]

the sum-up of the Tax Base Amounts linked to any of the VAT/Tax Rates below:

Adquisiciones intracomunitarias 16% (+16%)
Adquisiciones intracomunitarias 4% (+4%)
Adquisiciones intracomunitarias 7% (+7%)
Adquisiciones intracomunitarias 18% (+18%)
Adquisiciones intracomunitarias 8% (+8%)
Adquisiciones intracomunitarias 10% (+10%)
Adquisiciones intracomunitarias 21% (+21%)

510 17 [31] Liquidación (3)

IVA deducible - adquisiciones intracomunitarias de bienes corrientes[31]

The sum-up of the Tax Amounts linked to the any of the VAT Deductible Tax Rates above in [30]
612 17 [37] Liquidación (3)

IVA deducible - total a deducir [37]

Tota Tax Amount for VAT Deductible = [23]+[25]+[27]+[29]+[31]+[33]+[34]+[35]+[36]

Otros

Position From Lenght 303 VAT Settlement box Description (in spanish) OB Data
629 17 [38] Liquidación (3)

Diferencia [38]

Total VAT Payable - Tota VAT Deductible = [21]-[37]
651 17 [40] Liquidación (3) - Atribuible a la Administración del Estado [40] This one will be same as [38] in case [39] box is = 100,00%, otherwise [40]= [38] x [39]
685 17 [42] Liquidación (3)

Entregas Intracomunitarias [42]

The sum-up of the Tax Base Amounts linked to any of the VAT Payable listed below:

Entregas intracomunitarias (%N=>0%)
Entregas intracomunitarias (%R=>0%)
Entregas intracomunitarias (%SR=>0%)

702 17 [43] Liquidación (3)

Exportaciones y Operaciones asimiladas [43]

The sum-up of the Tax Base Amounts linked to any of the VAT Payable listed below:

Entregas a Canarias,Ceuta y Melilla (%N=>0%)
Entregas a Canarias,Ceuta y Melilla (%SR=>0%)
Entregas a Canarias,Ceuta y Melilla (%R=>0%)
Exportaciones (%N=>0%)
Exportaciones (%R=>0%)
Exportaciones (%SR=>0%)

719 17 [44] Liquidación (3)

Operaciones no sujetas o con Inversión de sujeto pasivo [44]

The sum-up of the Tax Base Amounts linked to any of the VAT Payable listed below:

Servicios a Canarias, Ceuta y Melilla (%N=>0%)
Servicios a Canarias, Ceuta y Melilla (%SR=>0%)
Servicios a Canarias, Ceuta y Melilla (%R=>0%)
Servicios prestados internacional (%N=>0%)
Servicios prestados internacional (%R=>0%)
Servicios prestados UE (%N=>0%)
Servicios prestados UE (%R=>0%)

753 17 [46] Liquidación (3)

Resultado [46]

Result = [40]-[41]+[45]
787 17 [48] Liquidación (3)

Resultado de la liquidación[48]

VAT Settlement Result = [46]-[47]
804 17 [49] Compensación (4)-Importe a compesar [48], in case [48] is <0 - Declaration Type = "C"
822 17 [50] Devolución (6) - Importe a devolver [48], in case [48] is <0 - Declaration Type = "D"

because "Inscrito en el Registro de Devolución mensual = "1" = Yes

860 17 Ingreso (7) - Importe a ingresar [48], in case [48] is >0 - Declaration Type = "I"

because "Inscrito en el Registro de Devolución mensual = "1" = Yes

Functional Requirement 6 - Transactions or Document types to take into account

303 VAT Settlement must take into account below transactions/document types for each type of VAT:

VAT Payable - Account Receivable related transactions:

Sales Invoices above described applies to both type of Invoices detailed below:

VAT Deductible - Account Payable related transactions:

Purchase Invoices above described applies to both type of Invoices detailed below:

Functional Requirement 7 - 303 VAT Settlement setup & 303 tax parameters

In order to check 303 VAT Settlment and 303 parameters setup he should navigate to Financial Management / Accounting / Setup / Tax Report and check that there is a Tax Report with a Search key => AEAT303_M or AEAT303_Q with below setup:

Persona based scenarios = Sales/Purchase Invoices

Sales Invoices

New!!! National Sales Invoice (Goods and Services) - different VAT rates

Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.

Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.

In case of a National Sales Invoice, below data must be entered:

and then go to "Lines" tab. Once there Mike must enter below data:

Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:

1.160,00 Customer (Debit)
1.000,00 Income (Credit)
160,00 VAT Payable (Credit)

Besides, Mike enters in the system a new sales invoice, as explained below:

and then go to "Lines" tab. Once there Mike must enter below data:

Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:

1.070,00 Customer (Debit)
1.000,00 Income (Credit)
70,00 VAT Payable (Credit)

After that, Mike enters in the system a new sales invoice, as explained below:

and then go to "Lines" tab. Once there Mike must enter below data:

Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:

1.180,00 Customer (Debit)
1.000,00 Income (Credit)
180,00 VAT Payable (Credit)

And finally, Mike enters in the system a new sales invoice, as explained below:

and then go to "Lines" tab. Once there Mike must enter below data:

Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:

1.080,00 Customer (Debit)
1.000,00 Income (Credit)
80,00 VAT Payable (Credit)

Above VAT Payable must be captured in the VAT Settlement for July period - VAT Payable section as shown below:


New!!! National Sales Invoice (Goods and Services) - different VAT rates Invoice and Void Invoice

Same as explained in the scenario below would happen in case Mike needs to : - issue a sales invoice dated on July 25th at a 18% VAT Rate, tax base amount 1.000,00 and tax amount 180,00 - and void a June sales invoice dated on July 27th at a 16% VAT Rate, tax base amount 500,00 and tax amount 80,00

In this scenario the result must look like:

National Sales Invoice (Goods and Services) - 2 VAT rates in the same invoice

Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.

Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.

In case of a National Sales Invoice, below data must be entered:

and then go to "Lines" tab. Once there Mike must enter below data:

Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:

4.318,00 Customer (Debit)
3.800,00 Income (Credit)
518,00 VAT Payable (Credit)

Above VAT Payable must be captured in the VAT Settlement for June period - VAT Payable section:

National Sales Invoice (Goods) - under "Recargo Equivalencia" Regimen

Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.

Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.

In case of a National Sales Invoice to a customer under "Recargo de Equivalencia", below data must be entered:

and then go to "Lines" tab. Once there Mike must enter below data:

Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:

2.280,00 Customer (Debit)
2.000,00 Income (Credit)
280,00 VAT Payable (Credit)

Above VAT Payable must be captured in the VAT Settlement for June period - VAT Payable section:

National Sales Invoice (Goods or Servies) - (negative Sales Invoice)

(same should apply in case Mike uses either a negative AR Invoice or a positive AR Credit Memo)

Mike must issued the negative Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.

Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.

In case of a National negative Sales Invoice, below data must be entered:

and then go to "Lines" tab. Once there Mike must enter below data:

Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:

1.160,00 Customer (Credit)
1.000,00 Income (Debit)
160,00 VAT Payable (Debit)

Above VAT Payable must be captured in the VAT Settlement for June period - VAT Payable section:

In case there is no other positive Invoice for that period, otherwise it would look like:

Same applies in the case of Services in relation to 303 data to be retrieved, in that case the VAT rates will the ones linked to the Tax Categories "IVA Normal Servicios", "IVA Reducido Servicios" or "IVA Super Reducido Servicios" at the same % rates as VAT Categories for Goods "IVA Normal", "IVA Reducido" and "IVA Super Reducido".

National Sales Invoice (Goods or Services) - Reversed Invoice of a previous period

Dated on July 25th, Mike needs to issue a corrective invoice because part of the goods send and invoiced to Customer A have been returned.

For doing the above Mike must navigate to : Sales Management || Transactions || Sales Invoice || Header and enter a new sales invoice by entering below data:

and then go to "Lines" tab. Once there Mike must enter below data:

Under the tab "Reversed Invoices", Mike will be able to select the original invoice being reversed.

Once the negative sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:

580,00 Customer (Credit)
500,00 Income (Debit)
80,00 VAT Payable (Debit)

Above VAT Payable must be captured in the VAT Settlement for July period - VAT Payable section but having a 16% VAT instead of 18%:

In case there is no other positive Invoice for that period at 16% and another one at 18%, otherwise it would look like:

Same applies in the case of Services in relation to 303 data to be retrieved, in that case the VAT rates will the ones linked to the Tax Categories "IVA Normal Servicios", "IVA Reducido Servicios" or "IVA Super Reducido Servicios" at the same % rates as VAT Categories for Goods "IVA Normal", "IVA Reducido" and "IVA Super Reducido".

EU Sales Invoices (Goods)

Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.

Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.

In case of an EU Sales Invoice, below data must be entered:

and then go to "Lines" tab. Once there Mike must enter below data:

Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below, there will not be any VAT posting:

2.000,00 Income (Credit)
2.000,00 Customer (Debit)

Above VAT Payable must be captured in the VAT Settlement for June period - Settlement Section:

EU Sales Invoices (Goods) negative

(same should apply in case Mike uses either a negative AR Invoice or a positive AR Credit Memo)

Mike must issued the negative Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.

Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.

In case of a National negative Sales Invoice, below data must be entered:

and then go to "Lines" tab. Once there Mike must enter below data:

Under the tab "Reversed Invoices", Mike will be able to select the original invoice being reversed.

Once the negative sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:

1.000,00 Customer (Credit)
1.000,00 Income (Debit)

Above VAT Payable must be captured in the VAT Settlement for June period - VAT Settelement section:

In case there is no other positive Invoice for that period, otherwise it would look like:

Same applies in the case of Services in relation to 303 data to be retrieved, in that case the VAT rates will the ones linked to the Tax Categories "IVA Normal Servicios", "IVA Reducido Servicios" or "IVA Super Reducido Servicios" at the same % rates as VAT Categories for Goods "IVA Normal", "IVA Reducido" and "IVA Super Reducido".

EU Sales Invoices (Services)

Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.

Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.

In case of an EU Sales Invoice, below data must be entered:

and then go to "Lines" tab. Once there Mike must enter below data:

Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below, there will not be any VAT posting:

3.750,00 Income (Credit)
3.750,00 Customer (Debit)

Above VAT Payable must be captured in the VAT Settlement for June period - Settlement Section:

EU Sales Invoices (Services) Negative

(same should apply in case Mike uses either a negative AR Invoice or a positive AR Credit Memo)

Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.

Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.

In case of an EU Sales Invoice, below data must be entered:

and then go to "Lines" tab. Once there Mike must enter below data:

Under the tab "Reversed Invoices", Mike will be able to select the original invoice being reversed.

Once the negative sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:

3.750,00 Income (Debit)
3.750,00 Customer (Credit)

Above VAT Payable must be captured in the VAT Settlement for June period - Settlement Section:

In case there is no other positive Invoice for that period, otherwise it would look like:

Exports (Goods)

Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.

Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.

In case of an "Export" Sales Invoice, below data must be entered:

and then go to "Lines" tab. Once there Mike must enter below data:

Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below, there will not be any VAT posting:

20.000,00 Income (Credit)
20.000,00 Customer (Debit)

Above VAT Payable must be captured in the VAT Settlement for June period - Settlement Section:

Same applies in case of a negative Sales Invoice for an Export (Goods) of an amount = 5.000,00 by example. The VAT payable must be captured in the VAT Settlement for June period - Settelment Section as shown below:

Exports (Services)

Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.

Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.

In case of an "Export" Sales Invoice, below data must be entered:

and then go to "Lines" tab. Once there Mike must enter below data:

Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below, there will not be any VAT posting:

20.000,00 Income (Credit)
20.000,00 Customer (Debit)

Above VAT Payable must be captured in the VAT Settlement for June period - Settlement Section:

Same applies in case of a negative Sales Invoice for an Export (Services) of an amount of -3.500,00. VAT payable must be captured for June period - Settlement Section as shown below:

Purchase Invoices

New!!! National Purchase Invoices (Financial Invoices)

Alice must enter the Purchase Invoices in the application path: Produrement Management || Transactions || Purchase Invoice || Header.

Alice can enter in the system diferent purchase invoices types depending on the BP (vendor) and the Products/Services for which a purchase invoice has been sent to Alice's company by a vendor.

In case of a National Purchase Invoice, below data must be entered:

and then go to "Lines" tab. Once there Alice must enter below data:

Once the purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:

1.000,00 Expense (Debit)
160,00 VAT deductible (Debit)
1.160,00 Vendor (Credit)

Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:

Note = Same applies to Sales Financial Invoices

Financial Invoice:
Financial invoice.png

GL Item:
Glitem.png

National Purchase Invoices (Goods and Services)

Alice must enter the Purchase Invoices in the application path: Produrement Management || Transactions || Purchase Invoice || Header.

Alice can enter in the system diferent purchase invoices types depending on the BP (vendor) and the Products/Services for which a purchase invoice has been sent to Alice's company by a vendor.

In case of a National Purchase Invoice, below data must be entered:

and then go to "Lines" tab. Once there Alice must enter below data:

Once the purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:

4.000,00 Expense (Debit)
370,00 VAT deductible (Debit)
4.370,00 Vendor (Credit)

Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:

National Purchase Invoices (Goods and Services) - Reversed Invoices

Alice must enter the Purchase Invoices in the application path: Produrement Management || Transactions || Purchase Invoice || Header.

Alice can enter in the system diferent purchase invoices types depending on the BP (vendor) and the Products/Services for which a purchase invoice has been sent to Alice's company by a vendor.

In case of a National Purchase Invoice, below data must be entered:

and then go to "Lines" tab. Once there Alice must enter below data:

Under the tab "Reversed Invoices", Alice will be able to select the original invoice being reversed.

Once the negative purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:

847,50 Vendor (Debit)
750,00 Expense (Credit)
97,50 VAT deductible (Credit)

Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:

National Purchase Invoices/Imports/Intracommunity Acquisitions of Capital Goods

In case of Capital Good purchase such as a car, a building or whatever, the VAT Deductible is not be 100% deductable within the same period that good was purchased. That type of VAT can be deducted in a period of time well defined by the Tax Authorities.

Therefore and for a give period (month or quarter) Alice must manually filled in below data as input if any:

National Purchase of Capital Goods:

[24] Por cuotas soportadas en operaciones interiores con bienes de inversión.
Base Imponible

[25] Por cuotas soportadas en operaciones interiores con bienes de inversión.
Cuota.

Imports of Capital Goods:

[28] Por cuotas soportadas en importaciones de bienes de inversión.
Base Imponible

[29] Por cuotas soportadas en importaciones de bienes de inversión.
Cuota.

Intracommunity Acquisitions of Capital Goods:

[32] Por cuotas soportadas en adquisiciones intracomunitarias de bienes de inversión.
Base Imponible

[33] Por cuotas soportadas en adquisiciones intracomunitarias de bienes de inversión.
Cuota.

Imports (Goods)

Alice must enter the Purchase Invoices in the application path: Produrement Management || Transactions || Purchase Invoice || Header.

Alice can enter in the system diferent purchase invoices types depending on the BP (vendor) and the Products/Services for which a purchase invoice has been sent to Alice's company by a vendor.

In case of a Import, below data must be entered:

and then go to "Lines" tab. Once there Alice must enter below data:

Once the purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:

4.000,00 Expense (Debit)
370,00 VAT deductible (Debit)
4.370,00 Vendor (Credit)

Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:

Imports (Goods) - Reversed Invoices

Alice must enter the Purchase Invoices in the application path: Produrement Management || Transactions || Purchase Invoice || Header.

Alice can enter in the system diferent purchase invoices types depending on the BP (vendor) and the Products/Services for which a purchase invoice has been sent to Alice's company by a vendor.

In case of a Import, below data must be entered:

and then go to "Lines" tab. Once there Alice must enter below data:

Under the tab "Reversed Invoices", Alice will be able to select the original invoice being reversed.

Once the negative purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:

348,00 Vendor (Debit) 300,00 Expense (Credit) 48,00 VAT Deductible (Credit)

Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:

EU Purchase Invoices (Goods)

Alice must enter in the system the Purchase Invoices in the application path: Procurement Management || Transactions || Purchase Invoice || Header.

Alice can enter in the system diferent purchase invoices types depending on the BP (Vendor) and the Products/Services for which a purchase invoice has been received.

In case of an EU Purchase Invoice, below data must be entered:

and then go to "Lines" tab. Once there Alice must enter below data:

Once the purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:

1.000,00 Expense (Debit)
160,00 VAT Deductible (Debit)
160,00 VAT Payable (Credit)
1.000,00 Vendor (Credit)

Above VAT Payable must be captured in the VAT Settlement for June period - VAT Payable section:

And Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:

EU Purchase Invoices (Goods) - Reversed Invoices

Alice must enter in the system the Purchase Invoices in the application path: Procurement Management || Transactions || Purchase Invoice || Header.

Alice can enter in the system diferent purchase invoices types depending on the BP (Vendor) and the Products/Services for which a purchase invoice has been received.

In case of an EU Purchase Invoice, below data must be entered:

and then go to "Lines" tab. Once there Alice must enter below data:

Under the tab "Reversed Invoices", Alice will be able to select the original invoice being reversed.

Once the negative purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:

100,00 Expense (Credit)
16,00 VAT Deductible (Credit)
16,00 VAT Payable (Debit)
100,00 Vendor (Debit)

Above VAT Payable must be captured in the VAT Settlement for June period - VAT Payable section:

And Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:

EU Purchase Invoices / Imports (Services)

Alice must enter in the system the Purchase Invoices in the application path: Procurement Management || Transactions || Purchase Invoice || Header.

Alice can enter in the system diferent purchase invoices types depending on the BP (Vendor) and the Products/Services for which a purchase invoice has been received.

In case of an EU Purchase Invoice of Services, below data must be entered:

and then go to "Lines" tab. Once there Alice must enter below data:

Once the purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:

2.000,00 Expense (Debit)
230,00 VAT Deductible (Debit)
230,00 VAT Payable (Credit)
2.000,00 Vendor (Credit)

In case of an Import of Services, below data must be entered:

and then go to "Lines" tab. Once there Alice must enter below data:

Once the purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:

2.000,00 Expense (Debit)
230,00 VAT Deductible (Debit)
230,00 VAT Payable (Credit)
2.000,00 Vendor (Credit)

Above VAT Payable must be captured in the VAT Settlement for June period - VAT Payable section:

And Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:

EU Purchase Invoices / Imports (Services) - Reversed Invoices

Alice must enter in the system the Purchase Invoices in the application path: Procurement Management || Transactions || Purchase Invoice || Header.

Alice can enter in the system diferent purchase invoices types depending on the BP (Vendor) and the Products/Services for which a purchase invoice has been received.

In case of an EU Purchase Invoice of Services, below data must be entered:

and then go to "Lines" tab. Once there Alice must enter below data:

Under the tab "Reversed Invoices", Alice will be able to select the original invoice being reversed.

Once the negative purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:

200,00 Vendor (Debit)
23,00 VAT Payable (Debit)
200,00 Expense (Credit)
23,00 VAT Deductible (Credit)

In case of an Import of Services, below data must be entered:

and then go to "Lines" tab. Once there Alice must enter below data:

Under the tab "Reversed Invoices", Alice will be able to select the original invoice being reversed.

Once the negative purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:

200,00 Vendor (Debit)
23,00 VAT Payable (Debit)
200,00 Expense (Credit)
23,00 VAT Deductible (Credit)

Above VAT Payable must be captured in the VAT Settlement for June period - VAT Payable section:

And Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:

“303 VAT Settlement” generation

Mary can launch the 303 VAT Settlement in the application path: Financial Management / Accounting / Analysis Tools / Tax Report Launcher and once there enter below information:

After the above, the end-user should press "Input Parameters" and a new window showing "input parameters" will pop-up.

Once the end-user has entered the required of needed input parameters, he/she should press the button "Generate Electronic File" and the file will be generated.

“303 VAT Settlement” validation

Once the 303 file is generated from OB, it can be pre-verified and submit here:

Assumptions & Dependencies

Assumptions

N/A

Dependencies

N/A

Design & Technical considerations

Design considerations

303 VAT Settlement must be implemented as a commercial module which will be later on part of the Spanish Professional Localization Pack.

Technical constraints

None

Technical Requirements

303 file generation must be based on an existing feature named “Tax Report Launcher” so there is no need for new fields/tables/parameters creation.

User interface

New User Interface

N/A

User interface changes

License

License code description

The Spanish Professional Pack is released under the "Openbravo Commercial License" (OBCL) as opposite as the Openbravo Public License (OPL) for open source modules

The OBCL needs to be accompanied by a "term sheet" that describes the specific licensing terms per module.

It is likely that a number of enhancements to modularity will be needed in order to store the term sheet as attributes of the module and to display them when the user acknowledges the license.

Product Strategy is responsible for publishing the license on the Openbravo web site. Developers are responsible for putting a reference to that license in the file header and to declare it in the module definition.

Functionality enabled by the license code

The functionality enable by the license code will be “303 VAT Declaration as a valid file”

Discussion items

Open discussion items

Closed discussion items

Appendix

Appendix I

Appendix II

Retrieved from "http://wiki.openbravo.com/wiki/Spainaeatmodelo303/Functional_Documentation"

This page has been accessed 8,276 times. This page was last modified on 23 November 2018, at 10:38. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.