Toolbox

Date	Author or editor	Description of change	Document status	Document version
June 11th, 2010^th	Patricia San Juan	Document creation	Draft	V1
June 12th, 2010^th	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:

Box 01 - File position 72 to 88- will get the the sum of the 18% and 16% related tax base amounts
- by example 1.000,00 + 2.000,00 = 3.000,00

Box 03 - File position 94 to 110 - will get the sum of the 18% and 16% related tax amounts
- by example (18% * 1.000,00) + (16% * 2.000,00) = 180,00 + 320,00 = 500,00

Box 02 - File position 89 to 93 - will get a tax rate (integer part + 2 decimals), calculated as sum of the 18% and 16% related the tax amounts / sum of the 18% and 16% related tax base amounts
- by example (500,00 / 3.000,00) * 100 = 16,66

Box 04 - File position 111 to 127 - will get the the sum of the 8% and 7% related tax base amounts
- by example 4.000,00 + 5.000,00 = 9.000,00

Box 06 - File position 133 to 149 - will get the sum of the 8% and 7% related tax amounts
- by example (8% * 4.000,00) + (7% * 5.000,00) = 320,00 + 350,00 = 670,00

Box 05 - File position 128 to 132 - will get a tax rate (integer part + 2 decimals), calculated as sum of the 8% and 7% related tax amounts / sum of the 8% and 7% related tax base amounts
- by example (670,00 /9.000,00) * 100 = 7,44

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:

"VAT Payable" = "IVA repercutido" (In Spanish), this VAT is the one included in any Account Receivable related transaction such as a "Sales invoices" or a "Collection/Receipt" from a customer.
and "VAT Deductible" = "IVA soportado/deducible" (In Spanish), this VAT is the one included in any Account Payable related transaction such as a "Purchase Invoice" or a "Payment" to a vendor.

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:

Get the VAT rates to be included in the 303 VAT Settlement properly Setup by getting them linked to the corresponding 303 output parameters.
Generate 303 VAT Settlement for a given period, either a month or a quarter as a valid file according to Spanish Tax Authotities requirements.
Review the 303 file generated by here "Formulario del modelo 303 para su presentación(predeclaración)"
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):

On June 7^th 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):

On June 8^th 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):

On July 7^th 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€

On July 30^th 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):

On July 8^th 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€

On July 30^th 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):

On July 30^th 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:

Devengo del IVA (in Spanish) => which means Companies must take into account when the "VAT is chargeable" and therefore must be submitted to the Tax Authorities - the VAT Payable and the VAT Deductible must be submitted to the Tax Authorities in the period when the Goods/Services have either been delivered (Sales-VAT Payable) or received (Purchase-VAT Deductible); let's say June.

Obligaciones de Facturación (In Spanish) => Besides the above, companies must invoice within the next 30 days after the delivery/receipt of the Goods/Services, but within the same settelment period, which in our case is June, therefore invoices must be issued July 16th the latest, as June VAT Settlement must be submitted to the tax authorities dated on July 20th; the latest.

In order:

not to loose these invoices dated from 1st July to 20th July in our example,
which could either belong to June VAT Settlement in case the operation date was June or belong to July VAT Settelemnt in case operation date was July
and which could also do not have either a good receipt/shipment for us to easly know the operation date
and because of the fact that Purchase invoices can have an invoice date dated on February, 2010; while are entered in the system later on, let's say June; so we could miss the period when the VAT Deductible was supposed to be submitted.

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

Sales invoices must be issued in the same period that the operation took place and at the same time/period must be posted, most cases
Purchase invoices can be recognized in the system when are posted, most cases.

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:

June period to be submitted to the tax authorities July 20th the latest, will take into account Invoices/Transactions having as "From Date" = or > June 1st and as "Date To" = or < June 30th.
Those transactions with Invoice date "From Date" = or > July 1st and as "Date To" = or < July 20th, wll be taken into account in July VAT Settlement period, regardless could be related to June transactions.

Functional Requirement 2 - AEAT303 File Structure

303 File structure can be found in the following link:

303 File Structure - 1353 Positions

New!!

Box 01 - File position 72 to 88- will get the the sum of the 18% and 16% related tax base amounts
Box 02 - File position 89 to 93 - will get a tax rate (integer part + 2 decimals), calculated as sum of the 18% and 16% related the tax amounts / sum of the 18% and 16% related tax base amounts
Box 03 - File position 94 to 110 - will get the sum of the 18% and 16% related tax amounts
Box 04 - File position 111 to 127 - will get the the sum of the 8% and 7% related tax base amounts
Box 05 - File position 128 to 132 - will get a tax rate (integer part + 2 decimals), calculated as sum of the 8% and 7% related tax amounts / sum of the 8% and 7% related tax base amounts
Box 06 - File position 133 to 149 - will get the sum of the 8% and 7% related tax amounts

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:

Organization
Tax Report = AEAT303_M or AEAT303_Q
Accounting Schema
Calendar (not editable)
Year
Period

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 (>0) -> Application path = Sales Management || Transactions || Sales Invoice - Document type = AR Invoice(>0).
- For for this type 303 VAT Settlement must get:
  - Tax Base Amount (>0)
  - Tax Amount (>0)
  - Total Amount (>0)

Sales invoices (<0) -> Application path = Sales Management || Transactions || Sales Invoice - Document type = AR Invoice(<0).
- For for this type 303 VAT Settlement must get:
  - Taxable Amount (<0)
  - Tax Amount (<0)
  - Total Amount (<0)

Sales credit memos (>0) -> Application path = Sales Management || Transactions || Sales Invoice - Document type = AR Credit Memo(>0).
- For for this type 303 VAT Settlement must get:
  - Tax Base Amount (<0)
  - Tax Amount (<0)
  - Total Amount (<0)
  - it is important to highlight that AR Invoice (<0) & AR Credit Memo (>0) should behave exactly same way.

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

Product/Services related Sales Invoices
Financial Sales Invoices by using a GL item setup as "Enable in Financial Invoices".

VAT Deductible - Account Payable related transactions:

Purchase invoices -> Application path = Purchase Management || Transactions || Purchase Invoice - Document type = AP Invoice(>0).
- For for this type 303 VAT Settlement must get:
  - Taxable Amount (>0)
  - Tax Amount (>0)
  - Total Amount (>0)

Purchase invoices (<0) -> Application path = Purchase Management || Transactions || Purchase Invoice - Document type = AP Invoice(<0).
- For for this type 303 VAT Settlement must get:
  - Tax Base Amount (<0)
  - Tax Amount (<0)
  - Total Amount (<0)

Purchase credit memos (>0) -> Application path = Purchase Management || Transactions || Sales Invoice - Document type = AP Credit Memo(>0).
- For for this type 303 VAT Settlement must get:
  - Tax Base Amount (<0)
  - Tax Amount (<0)
  - Total Amount (<0)
  - it is important to highlight that AP Invoice (<0) & AP Credit Memo (>0) should behave exactly same way.

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

Product/Services related Purchase Invoices
Financial Purchase Invoices by using a GL item setup as "Enable in Financial Invoices".

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:

Tax Report (Header):
- Client=> OB Client for which 303 is setup.
- Organization => OB organization or legal entity for which 303 is setup.
- Name=> 303 VAT Settlment name (AEAT303_M : Liquidación de IVA Mensual and AEAT303_Q : Liquidación de IVA Trimestral)
- Description=> 303 VAT Settlment description (AEAT303_M : Liquidación de IVA Mensual and AEAT303_Q : Liquidación de IVA Trimestral)
- Period=> it should be Monthly or Quarterly
- Java Class name=> Java class for this declaration should be here
- Active=> YES
Tax Report Group. There should as many Tax Report groups as needed babed on the parameters type (constant, input and output) defined in Functional Requirements sectios above.

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:

Transaction Document type = AR Invoice
Invoice date = 01-07-2010
Accounting date = 02-07-2010
Business Partner = "National Customer A" (located in Spain)

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

Line 10
Product = "Product A" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Entregas IVA 18%" (system will show up this Tax type based on setup)
- but as this transaction took place dated on 28th June (operation date) the end-user manually select "Entregas IVA 16%" as applicable tax rate.
Tax Base Amount = 1.000,00
Tax Amount = 160,00
Tax Rate = 16,00

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:

Transaction Document type = AR Invoice
Invoice date = 01-07-2010
Accounting date = 02-07-2010
Business Partner = "National Customer B" (located in Spain)

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

Line 10
Product = "Product B" (which belongs to Tax Category "IVA Reducido")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Entregas IVA 8%" (system will show up this Tax type based on setup)
- but as this transaction took place dated on 28th June (operation date) the end-user manually select "Entregas IVA 7%" as applicable tax rate.
Tax Base Amount = 1.000,00
Tax Amount = 70,00
Tax Rate = 07,00

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:

Transaction Document type = AR Invoice
Invoice date = 17-07-2010
Accounting date = 20-07-2010
Business Partner = "National Customer A" (located in Spain)

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

Line 10
Product = "Product A" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Entregas IVA 18%" (system will show up this Tax type based on setup)
Tax Base Amount = 1.000,00
Tax Amount = 180,00
Tax Rate = 18,00

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:

Transaction Document type = AR Invoice
Invoice date = 18-07-2010
Accounting date = 25-07-2010
Business Partner = "National Customer B" (located in Spain)

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

Line 10
Product = "Product B" (which belongs to Tax Category "IVA Reducido")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Entregas IVA 8%" (system will show up this Tax type based on setup)
Tax Base Amount = 1.000,00
Tax Amount = 80,00
Tax Rate = 08,00

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:

Tax Base Amount = 1.000,00 + 1.000,00 = 2.000,00 [01]
Tax Rate % = (490,00 / 2.000,00)*100 = 17,00[02]
Tax Amount = 160,00 + 180,00 = 340,00 [03]

Tax Base Amount = 1.000,00 + 1.000,00 = 2.000,00 [04]
Tax Rate % = (150,00 / 2.000,00)*100 = 07,50 [05]
Tax Amount = 70,00 + 80,00 = 150,00 [06]

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:

Tax Base Amount = 1.000,00 - 500,00 = 500,00 [01]
Tax Rate % = (100,00 / 500,00)*100 = 20,00[02]
Tax Amount = 180,00 - 80,00 = 100,00 [03]

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:

Transaction Document type = AR Invoice
Invoice date = 17-06-2010
Accounting date = 20-06-2010
Business Partner = "National Customer A" (located in Spain)

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

Line 10
Product = "Product A" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Entregas IVA 16%" (system will show up this Tax type based on setup).
Tax Base Amount = 1.000,00
Tax Amount = 160,00
Line 20
Product = "Product B"(which belongs to Tax Category "IVA Reducido")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Entregas IVA 7%" (system will show up this Tax type base on setup).
Tax Base Amount = 1.000,00
Tax Amount = 70,00
Line 30
Product = "Service A" (which belongs to Tax Category "IVA Normal Servicios")
Invoice quantity = "1"
Net Unit Price = "1.800,00"
Tax = "Servicios prestados nacional 16%" (system will show up this Tax type based on setup).
Tax Base Amount = 1.800,00
Tax Amount = 288,00

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:

Tax Base Amount = 2.800,00 [01]
Tax Rate % = 16,00 [02]
Tax Amount = 448,00 [03]
Tax Base Amount = 1.000,00 [04]
Tax Rate % = 7,00 [05]
Tax Amount = 70,00 [06]

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:

Transaction Document type = AR Invoice
Invoice date = 18-06-2010
Accounting date = 20-06-2010
Business Partner = "National Customer M" (located in Spain)

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

Line 10
Product = "Product A" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Entregas IVA 16 % + 4 %" (system will show up this Tax type based on setup).
Tax Base Amount = "1.000,00"
Tax Amount = "160,00" + "40,00"
Line 20
Product = "Product B"(which belongs to Tax Category "IVA Reducido")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Entregas IVA 7% + 1%" (system will show up this Tax type base on setup).
Tax Base Amount = "1.000,00"
Tax Amount = "70,00"+ "10,00"

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:

Tax Base Amount = 1.000,00 [01]
Tax Rate % = 16,00 [02]
Tax Amount = 160,00 [03]
Tax Base Amount = 1.000,00 [04]
Tax Rate % = 7,00 [05]
Tax Amount = 70,00 [06]
Tax Base Amount = 1.000,00 [10]
Tax Rate % = 4,00 [11]
Tax Amount = 40,00 [12]
Tax Base Amount = 1.000,00 [13]
Tax Rate % = 1,00 [14]
Tax Amount = 10,00 [15]

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:

Transaction Document type = AR Invoice
Invoice date = 25-06-2010
Accounting date = 25-06-2010
Business Partner = "National Customer A" (located in Spain)

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

Line 10
Product = "Product A" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "-10"
Net Unit Price = "100,00"
Tax = "Entregas IVA 16%" (system will show up this Tax type based on setup).
Tax Base Amount = "-1.000,00"
Tax Amount = "-160.00"

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:

Tax Base Amount = -1.000,00 [01]
Tax Rate % = 16,00 [02]
Tax Amount = -160,00 [03]

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

Tax Base Amount = 5.000,00 - 1.000,00 = 4.000,00[01]
Tax Rate % = 16,00 [02]
Tax Amount = 800,00 -160,00 = 640,00 [03]

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:

Transaction Document type = AR Invoice
Invoice date = 25-07-2010
Accounting date = 27-07-2010
Business Partner = "National Customer A" (located in Spain)

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

Line 10
Product = "Product A" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "-5"
Net Unit Price = "100,00"
Tax = "Entregas IVA 16%" (the system will not show up this Tax type because dated on = or > July 1st, 2010; system will show up "Entregas IVA 18%" unless the original invoice is fully voided, therefore Mike must select the Tax Rate used in the original invoice being corrected).
Tax Base Amount = "-500,00"
Tax Amount = "-80,00"

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%:

Tax Base Amount = -500,00 [01]
Tax Rate % = 16,00 [02]
Tax Amount = -80,00 [03]

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

Tax Base Amount = 5.000,00 - 500,00 = 4.500,00[01]
Tax Rate % = 16,00 [02]
Tax Amount = 800,00 -80,00 = 720,00 [03]
Tax Base Amount = 1.000,00 [04]
Tax Rate % = 18,00 [05]
Tax Amount = 180,00 [06]

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:

Transaction Document type = AR Invoice
Invoice date = 17-06-2010
Accounting date = 20-06-2010
Business Partner = "EU Customer A" (located in France)

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

Line 10
Product = "Product A" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Entregas intracomunitarias (%N=>0%)" (system will show up this Tax type based on setup).
Tax Base Amount = "1.000,00"
Tax Amount = "0,00"
Line 20
Product = "Product B"(which belongs to Tax Category "IVA Reducido")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Entregas intracomunitarias (%R=>0%)" (system will show up this Tax type base on setup).
Tax Base Amount = "1.000,00"
Tax Amount = "0,00"

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:

Tax Base Amount = 2.000,00 [42]

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:

Transaction Document type = AR Invoice
Invoice date = 25-06-2010
Accounting date = 25-06-2010
Business Partner = "EU Customer C" (located in Belgium)

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

Line 10
Product = "Product A" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "-10"
Net Unit Price = "100,00"
Tax = "Entregas intracomunitarias (%N=>0%)" (system will show up this Tax type based on setup).
Tax Base Amount = "-1.000,00"
Tax Amount = "0.00"

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:

Tax Base Amount = -1.000,00 [42]

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

Tax Base Amount = 5.000,00 - 1.000,00 = 4.000,00 [42]

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:

Transaction Document type = AR Invoice
Invoice date = 17-06-2010
Accounting date = 20-06-2010
Business Partner = "EU Customer A" (located in France)

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

Line 10
Product = "Service A" (which belongs to Tax Category "IVA Normal Servicios")
Invoiced quantity = "1"
Net Unit Price = "3.750,00"
Tax = "Servicios prestados UE (%N=>0%)" (system will show up this Tax type based on setup).
Tax Base Amount = "3.750,00"
Tax Amunt = "0,00"

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:

Tax Base Amount = 3.750,00 [44]

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:

Transaction Document type = AR Invoice
Invoice date = 17-06-2010
Accounting date = 20-06-2010
Business Partner = "EU Customer A" (located in France)

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

Line 10
Product = "Service A" (which belongs to Tax Category "IVA Normal Servicios")
Invoiced quantity = "-1"
Net Unit Price = "3.750,00"
Tax = "Servicios prestados UE (%N=>0%)" (system will show up this Tax type based on setup).
Tax Base Amount = "-3.750,00"
Tax Amunt = "0,00"

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:

Tax Base Amount = -3.750,00 [44]

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

Tax Base Amount = 5.000,00 - 3.750,00 = 1250,00 [44]

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:

Transaction Document type = AR Invoice
Invoice date = 17-06-2010
Accounting date = 20-06-2010
Business Partner = "Customer USA" (located in United States)

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

Line 10
Product = "Product A" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "100"
Net Unit Price = "100,00"
Tax = "Exportaciones (%N=>0%)" (system will show up this Tax type based on setup).
Tax Base Amount = "10.000,00"
Tax Amount = "0,00"
Line 20
Product = "Product B"(which belongs to Tax Category "IVA Reducido")
Invoiced quantity = "100"
Net Unit Price = "100,00"
Tax = "Exportaciones (%R=>0%)" (system will show up this Tax type base on setup).
Tax Base Amount = "10.000,00"
Tax Amount = "0,00"

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:

Tax Base Amount = 20.000,00 [43]

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:

Tax Base Amount = 20.000,00 - 5.000,00 = 15.000,00 [43]

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:

Transaction Document type = AR Invoice
Invoice date = 17-06-2010
Accounting date = 20-06-2010
Business Partner = "Customer USA" (located in United States)

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

Line 10
Product = "Service A" (which belongs to Tax Category "IVA Normal Servicios")
Invoiced quantity = "100"
Net Unit Price = "100,00"
Tax = "Servicios prestados internacional (%N=>0%)" (system will show up this Tax type based on setup).
Tax Base Amount = "10.000,00"
Tax Amount = "0,00"
Line 20
Product = "Service B"(which belongs to Tax Category "IVA Reducido Servicios")
Invoiced quantity = "100"
Net Unit Price = "100,00"
Tax = "Servicios prestados internacional (%R=>0%)" (system will show up this Tax type base on setup).
Tax Base Amount = "10.000,00"
Tax Amount = "0,00"

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:

Tax Base Amount = 20.000,00 [44]

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:

Tax Base Amount = 20.000,00 - 3.500,00 [44]

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:

Transaction Document type = AP Invoice
Invoice date = 17-06-2010
Accounting date = 20-06-2010
Business Partner = "National Vendor A" (located in Spain)

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

Line 10
Financial Invoice Line flag = Yes (see screen below)
Account = "Item A" (GL item named "Item A" previously created at the application path = Financial Management || Accounting || Setup || G/L Item || G/L Item, set up as "Enable in Financial Invoices"=Yes and linked to "Iva Normal" Tax Category, see screen below)
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Adquisiciones IVA 16%" (system will show up this Tax type based on setup).
Tax Base Amount = "1.000,00"
Tax Amount = "160,00"

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:

Tax Base Amount = 1.000,00 [22]
Tax Amount = 160,00 [23]

Note = Same applies to Sales Financial Invoices

Financial Invoice:

GL Item:

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:

Transaction Document type = AP Invoice
Invoice date = 17-06-2010
Accounting date = 20-06-2010
Business Partner = "National Vendor A" (located in Spain)

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

Line 10
Product = "Product A" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Adquisiciones IVA 16%" (system will show up this Tax type based on setup).
Tax Base Amount = "1.000,00"
Tax Amount = "160,00"
Line 20
Product = "Product B"(which belongs to Tax Category "IVA Reducido")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Adquisiciones IVA 7%" (system will show up this Tax type base on setup).
Tax Base Amount = "1.000,00"
Tax Amount = "70,00"
Line 30
Product = "Service C"(which belongs to Tax Category "IVA Reducido Servicios")
Invoiced quantity = "8"
Net Unit Price = "250,00"
Tax = "Adquisiciones IVA 7%" (system will show up this Tax type base on setup).
Tax Base Amount = "2.000,00"
Tax Amount = "140,00"

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:

Tax Base Amount = 4.000,00 [22]
Tax Amount = 370,00 [23]

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:

Transaction Document type = AP Invoice
Invoice date = 24-06-2010
Accounting date = 24-06-2010
Business Partner = "National Vendor A" (located in Spain)

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

Line 10
Product = "Product A" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "-5
Net Unit Price = "100,00"
Tax = "Adquisiciones IVA 16%" (system will show up this Tax type based on setup).
Tax Base Amount = "-500,00"
Tax Amount = "-80,00"
Line 20
Product = "Service C"(which belongs to Tax Category "IVA Reducido Servicios")
Invoiced quantity = "-1"
Net Unit Price = "250,00"
Tax = "Adquisiciones IVA 7%" (system will show up this Tax type base on setup).
Tax Base Amount = "-250,00"
Tax Amount = "-17,50"

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:

Tax Base Amount = 4.000,00 - 750 = 3.250,00 [22]
Tax Amount = 370,00 - 97,50 = 272,50 [23]

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:

Transaction Document type = AP Invoice
Invoice date = 29-06-2010
Accounting date = 30-06-2010
Business Partner = "Vendor USA Z" (located in USA)

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

Line 10
Product = "Product A" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "10"
Net Unit Price = "300,00"
Tax = "Importaciones 16%" (system will show up this Tax type based on setup).
Tax Base Amount = "3.000,00"
Tax Amount = "480,00"
Line 20
Product = "Product B"(which belongs to Tax Category "IVA Reducido")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Importaciones 7%" (system will show up this Tax type base on setup).
Tax Base Amount = "1.000,00"
Tax Amount = "70,00"
Line 30

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:

Tax Base Amount = 4.000,00 [26]
Tax Amount = 370,00 [27]

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:

Transaction Document type = AP Invoice
Invoice date = 29-06-2010
Accounting date = 30-06-2010
Business Partner = "Vendor USA Z" (located in USA)

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

Line 10
Product = "Product A" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "-1"
Net Unit Price = "300,00"
Tax = "Importaciones 16%" (system will show up this Tax type based on setup).
Tax Base Amount = "-300,00"
Tax Amount = "-48,00"

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:

Tax Base Amount = 4.000,00 - 300,00 = 3.700,00 [26]
Tax Amount = 370,00 - 48,00 = 322,00 [27]

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:

Transaction Document type = AP Invoice
Invoice date = 17-06-2010
Accounting date = 20-06-2010
Business Partner = "EU Vendor A" (located in Italy)

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

Line 10
Product = "Product X" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Adquisiciones intracomunitarias 16%" (system will show up this Tax type based on setup).
Tax Base Amount = "1.000,00"
Tax Amount = "+/-160,00"

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:

Tax Base Amount = 1.000,00 [19]
Tax Amount = 160,00 [20]

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

Tax Base Amount = 1.000,00 [30]
Tax Amount = 160,00 [31]

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:

Transaction Document type = AP Invoice
Invoice date = 25-06-2010
Accounting date = 25-06-2010
Business Partner = "EU Vendor A" (located in Italy)

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

Line 10
Product = "Product X" (which belongs to Tax Category "IVA Normal")
Invoiced quantity = "-1"
Net Unit Price = "100,00"
Tax = "Adquisiciones intracomunitarias 16%" (system will show up this Tax type based on setup).
Tax Base Amount = "-100,00"
Tax Amount = "+/-16,00"

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:

Tax Base Amount = 1.000,00 - 100,00 = 900,00 [19]
Tax Amount = 160,00 - 16,00 = 144,00 [20]

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

Tax Base Amount = 1.000,00 - 100,00 = 900,00 [30]
Tax Amount = 160,00 - 16,00 = 144,00 [31]

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:

Transaction Document type = AP Invoice
Invoice date = 01-06-2010
Accounting date = 05-06-2010
Business Partner = "EU Vendor P" (located in France)

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

Line 10
Product = "Service C" (which belongs to Tax Category "IVA Normal Servicios")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Inversión Sujeto Pasivo 16%" (system will show up this Tax type based on setup).
Tax Base Amount = "1.000,00"
Tax Amount = "+/-160,00"
Line 20
Product = "Service D" (which belongs to Tax Category "IVA Reducido Servicios")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Inversión Sujeto Pasivo 7%" (system will show up this Tax type based on setup).
Tax Base Amount = "1.000,00"
Tax Amount = "+/-70,00"

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:

Transaction Document type = AP Invoice
Invoice date = 11-06-2010
Accounting date = 11-06-2010
Business Partner = "Vendor USA RR" (located in USA)

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

Line 10
Product = "Service E" (which belongs to Tax Category "IVA Normal Servicios")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Inversión Sujeto Pasivo 16%" (system will show up this Tax type based on setup).
Tax Base Amount = "1.000,00"
Tax Amount = "+/-160,00"
Line 20
Product = "Service F" (which belongs to Tax Category "IVA Reducido Servicios")
Invoiced quantity = "10"
Net Unit Price = "100,00"
Tax = "Inversión Sujeto Pasivo 7%" (system will show up this Tax type based on setup).
Tax Base Amount = "1.000,00"
Tax Amount = "+/-70,00"

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:

Tax Base Amount = 2.000,00 [01]
Tax Rate = 16.00 [02]
Tax Amount = 320,00 [03]
Tax Base Amount = 2.000,00 [04]
Tax Rate = 7.00 [05]
Tax Amount = 140,00 [06]

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

Tax Base Amount = 4.000,00 [22]
Tax Amount = 460,00 [23]

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:

Transaction Document type = AP Invoice
Invoice date = 20-06-2010
Accounting date = 22-06-2010
Business Partner = "EU Vendor P" (located in France)

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

Line 10
Product = "Service C" (which belongs to Tax Category "IVA Normal Servicios")
Invoiced quantity = "-1"
Net Unit Price = "100,00"
Tax = "Inversión Sujeto Pasivo 16%" (system will show up this Tax type based on setup).
Tax Base Amount = "-100,00"
Tax Amount = "+/-16,00"
Line 20
Product = "Service D" (which belongs to Tax Category "IVA Reducido Servicios")
Invoiced quantity = "-1"
Net Unit Price = "100,00"
Tax = "Inversión Sujeto Pasivo 7%" (system will show up this Tax type based on setup).
Tax Base Amount = "-1000,00"
Tax Amount = "+/-7,00"

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:

Transaction Document type = AP Invoice
Invoice date = 20-06-2010
Accounting date = 22-06-2010
Business Partner = "Vendor USA RR" (located in USA)

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

Line 10
Product = "Service E" (which belongs to Tax Category "IVA Normal Servicios")
Invoiced quantity = "-1"
Net Unit Price = "100,00"
Tax = "Inversión Sujeto Pasivo 16%" (system will show up this Tax type based on setup).
Tax Base Amount = "-100,00"
Tax Amount = "+/-16,00"
Line 20
Product = "Service F" (which belongs to Tax Category "IVA Reducido Servicios")
Invoiced quantity = "-1"
Net Unit Price = "100,00"
Tax = "Inversión Sujeto Pasivo 7%" (system will show up this Tax type based on setup).
Tax Base Amount = "-100,00"
Tax Amount = "+/-7,00"

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:

Tax Base Amount = 2.000,00 - 200,00 = 1.800,00 [01]
Tax Rate = 16.00 [02]
Tax Amount = 320,00 - 32,00 = 288,00 [03]
Tax Base Amount = 2.000,00 - 200,00 = 1.800,00 [04]
Tax Rate = 7.00 [05]
Tax Amount = 140,00 - 14,00 = 126,00 [06]

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

Tax Base Amount = 4.000,00 - 400,00 = 3.600,00 [22]
Tax Amount = 460,00 - 46,00 = 414,00 [23]

“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:

Organization
Report
Accounting schema
Calendar (not editable)
Year - to be selected by the end-user
Period
- in case of monthly declaration, reference list containing each month of the year
- in case of quarterly declaration, reference list containing each quarter of the year

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:

pre-verified option "Formulario de modelo 303 para su presentación (predeclaración)
submit option "Presentación del Modelo"

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,140 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.

Toolbox

PDF Books

Search

Participate

Spainaeatmodelo303/Functional Documentation

Contents

Document sign-off

Document Status

Overview & Justification

Purpose

Scope

Justification

New definitions and acronyms

Users & business process description

User goals

User Roles and Personas

Business scenario/s

Functional requirements

Functional Requirement 1 - Accounting Date

Functional Requirement 2 - AEAT303 File Structure

Functional Requirement 3- AEAT303 Constant Parameters

Functional Requirement 4 - AEAT303 Input Parameters

Functional Requirement 5 - AEAT303 Ouput Parameters

IVA Devengado

IVA Deducible

Otros

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

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

Persona based scenarios = Sales/Purchase Invoices

Sales Invoices

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

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

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

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

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

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

EU Sales Invoices (Goods)

EU Sales Invoices (Goods) negative

EU Sales Invoices (Services)

EU Sales Invoices (Services) Negative

Exports (Goods)

Exports (Services)

Purchase Invoices

New!!! National Purchase Invoices (Financial Invoices)

National Purchase Invoices (Goods and Services)

National Purchase Invoices (Goods and Services) - Reversed Invoices

National Purchase Invoices/Imports/Intracommunity Acquisitions of Capital Goods

Imports (Goods)

Imports (Goods) - Reversed Invoices

EU Purchase Invoices (Goods)

EU Purchase Invoices (Goods) - Reversed Invoices

EU Purchase Invoices / Imports (Services)

EU Purchase Invoices / Imports (Services) - Reversed Invoices

“303 VAT Settlement” generation

“303 VAT Settlement” validation

Assumptions & Dependencies

Assumptions

Dependencies

Design & Technical considerations

Design considerations

Technical constraints

Technical Requirements

User interface

New User Interface

User interface changes

License

License code description

Functionality enabled by the license code

Discussion items

Open discussion items

Closed discussion items

Appendix

Appendix I

Appendix II