Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Hide If
groupconfluence-users

Tasks to be completed when documenting an operation (from creation to publication)

 1. Enter the Title of the operation / page

2. Add the following Labels

    • Scope of applicability: ww, country_accounting 

    • Country or group of countries (if applicable): belux, china, france, italy, lam, nam, uk_ie, bulgaria, dach, netherlands, iberia, poland, latvia, australia, india, japan, south_korea, thailand, singapore

    • Unit and Domain according to the List of labels to be used in the Finance Service Line space

      • E.g. 1: WW Operation in Financial Accounting under domain "Central Finance Processes & Compliance":
        • Labels to be used: ww, financial_accounting, central_fin_proc_compliance

      • E.g. 2: France Operation in Financial Accounting:
        • Labels to be used: country_accounting, france, financial_accounting
          (for country operations, the Domain is always country_accounting)


3. Fill in all fields as described above

 4. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow 


Panel
bgColor#F7F7F7
titleColor#ffffff
borderWidth1
borderStylenone
Domain: Country Accounting
Panel
bgColor#F7F7F7
borderWidth1
borderStylenone

Responsibility area: N/A

Table of contents 

Table of Contents
maxLevel2


Panel
borderStylenone
Scope

Image Modified


ERP

Image ModifiedImage RemovedImage RemovedImage RemovedImage Removed

(To be filled!)


Frequency

 Image ModifiedImage Modified Image Removed Image Removed

 Image Removed Image Removed Image Removed (To be confirmed!)(error)

References
Forms

SBS-FRM-DRTR-06-032 M303 VAT RETURN_TEMPLATE_2015 
SBS-FRM-DRTR-06-030 M349 Reconciliation_TEMPLATE 
SBS-FRM-DRTR-06-031 M340 vs M303 Reconciliation_TEMPLATE

Attachments

8. Add the link to attachments or external links

To be filled! <<

Page_title
>> To be filled!


S_ALR_87012357; S_EB5_05000379; S_ALR_87012403; Z1K_DETAIL; Z1F_DOWNLOAD_340; Z_ES_RFIDESM340; TC_RENT_M340_ES; FBL3N; FB03; FBL1N


Forms

M303 VAT RETURN_TEMPLATE_2015 

M349 Reconciliation_TEMPLATE 

M340 vs M303 Reconciliation_TEMPLATE

 

Attachments

 

 

Previous OP <<

Page_title
>> Next OP



1

. Objective and Scope

1.1. Objective of this Operation

This SOP document explains VAT process within Spain and how to perform quality checks in order to get the expected result, and how to fill in the Spanish authorities' website. 

The VAT reporting obligations in scope for Spain are the following:

  • VAT return (Form 303)Transactions listing (Form 340)
  • ESPL (Form 349)
  • Annual VAT return (Form 390), when applicable (only for companies not submitting SII)

1.2. Scope

This VAT LOP procedure compliance process manual is to be used as a step-by-step guideline to facilitate the VAT reporting (by RTR VAT SU team) of the operations made by Solvay entities in Spain. 

It describes the compliance process for the preparation of the VAT return, transaction listing, ESPL and annual return for the following companies:


 

Comp. code

Name

VAT n°

On SAP

Foreign VAT n°

VAT resp.

CAM

Site

1

5696

6301

Inovyn España

Solvay Solutions 

ESB62278205

ESN0030376H

Yes

No

Elsa Perez

Martorell

Yes in ES

Ronald Ketting

N/A

2

0245

6397

Solvay

Quimica

Servicios

ESB61474607

ESB16994345

Yes

No

Elsa Perez

Torrelavega

Carla Olivieira

N/A

3
3454
5835Solvay
Iberica
Specialty Polymers Italy
ESB61426177
ESN0057184DYes

No

Elsa Perez

Yes in ESFrancesco PiccoliN/A
Martorell
4

0005 6070 
6233 
6234

SCI BE

ESN01711270

6422Specialty Operations FranceESN0260591CYesYes in ES
Elsa Perez
Carla OliveiraN/A
5

 

1427

Inovyn Quimica ES

ESB66349705

Yes

No

Elsa Perez

Martorell


2. Definitions

See Finance Glossary:

6

1429

Inovyn Trade Services

ESN0172988H

Yes

Yes in ES

Elsa Perez

N/A

2. Definitions

See Finance Glossary:

  • SOP (add to Finance Glossary)
  • ESPL (add to Finance Glossary)


3. Tasks description

3.1. Periodicity and Deadlines

The proposed submission deadlines for the transfer of information between SBS Back office, and Solvay FTO are as follows:of the legal obligations are the following:


Deadline for return submission

Closing

Package sent to Solvay local

Internal payment date

Statutory deadline for return

and/or payment

VAT return (303)

6 WD after the period

3 WD before the statutory deadline

2 WD before the statutory deadline
End of the following month, if the company is in a credit position. In case of Debit position, the deadline is 12th of the following month.

ESPL (349)

20th of the month following the period

Transactions listing (340)

6 WD after the period

3 WD before the statutory deadline

N/A

20th of the month following the period

ESPL (349)

6 WD after the period

3 WD before the statutory deadline

N/A

20th of the month following the period

Annual VAT return (390)

6 WD after the period

8 WD before the statutory deadline

N/A

30thJanuary of the following year

3.2. M303 – Monthly VAT Return

This procedure is done on a monthly basis by SBS-BO, any inconsistency checked must be corrected before sending it to FTO.

3.2.1. M303 – Run SAP Ledgers

Run transaction S_ALR_87012357 and enter the appropriate variants:

  • IVAESPAÑA - for companies 0245, 5696, 3454 and 1427;
  • 0005+6070_ES – for companies 0005; 6070; 6233; 6234 and 1419.
E.g. for Solvay Química, reporting period 04/2012, fill in:
  • Company Code: 0245
  • Posting Date: From 01.04.2012 to 30.04.2012
Image Removed This report will show you the listing of all movements on vendors and customers for the company and period selected and the resume of all transactions by VAT code will be compiled in the different VAT models (303, 340 and 349). 
The outcome of this step should be as follows:

Image Removed 

Extract this information to excel by clicking on the button Image Removed . 

3.2.2. M303 – Preliminary quality checks

After lunching the transaction as explained in step 2.1.1, preliminary quality checks on the use of the tax codes should be performed before month end closing in order to allow the correction of potential errors in due course and limit manual adjustments a posteriori.
Any inconsistency detected in any of the checks hereafter should be addressed inside BO for confirmation and posterior corrections. 
Remark: On the 1rst September 2012 the tax rates applied in the country have changed:

  • General rate from 18% to 21%;
  • Reduced rate from 8% to 10%;
  • Super-reduced rate maintain the 4%.
Image Removed

Due to the possibility of having invoices issued/received with the previous VAT rates, in all sections of the LOP it will be mentioned the two SAP VAT related codes, to distinguish between the new and the old tax codes. 
Checks to perform:

1. Verify all tax codes with VAT rates different from the applicable rates in Spain, i.e. 0%, 4%, 10% and 21%

    1. If a tax code has another rate, e.g. 8% and 18% which is the Spanish VAT rates applied before September 2012, verify that:
      1. The invoice is dated before September 1, 2012.
      2. The invoice is not older than 4 years.
      3. If the invoice is older than 4 years, the input tax should not be recovered via the VAT return.

 b. If a tax code has another rate, e.g. 7% and 16% which is the older Spanish VAT rate applied before July 2010, verify that:

    1. The invoice is not older than 4 years.
    2. If the invoice is older than 4 years, the input tax should not be recovered via the VAT return.
    3. The invoice is dated before July 1, 2010.
  • Verify the Intra community Acquisitions of Goods (Tax codes RV – 18 % or 8R – 21%)
  • Check that all the movements done using this tax code have only foreign VAT Numbers. This means that invoices posted with these codes and Spanish VAT numbers are not correct.

    3. Verify the Operations with tax exemption (tax codes 8L/9L "OPERACIONES NO SUJETAS – EXENTAS IVA en COMPRAS/VENTAS)

    We must verify if the movements done using these taxes have costumers/vendors with non Spanish N.I.F. communitarian.

    4.  Tax code 8L (incoming invoices without VAT) relate to operations made ONLY WITH SPANISH SUPLLIERS, in this tax code we should not have amount in "IMPORTE A PAGAR" or "DEDUCIBLE"

    5. Tax code 9L (outgoing invoices without VAT) – relate to operations made ONLY WITH SPANISH CUSTOMERS, in this tax code we should not have amount in Tax to be paid "IMPORTE A PAGAR" or deductible tax "DEDUCIBLE".

     

    6. Verify movements with VAT code 9R

    New tax code 9R _ Plant abroad – ADQUISICIONES INTRACOM. DE BIENES must have the same treatment as code 8R, we need to insure that Code 9R should only be used in company SCI.

    7. Verify the tax codes 8G and 8O relate to operations made with specific suppliers:

    VAT Number

    Vendor Nº

    Name

    T. Code

    Comment

    Company 0245 – Solvay Quimica

     

     

     

     

     

    302301319

    GEARBULK POOL LIMITED

    8O

    Export freight supplier

    BE0403091220

    702703090

    SOLVAY S.A.

    8G

    Monthly amounts below 4 KEUR

    FR33537889354

    102129211

    SOLVAY QUIMICA S.L. (ESP)

    8G

     

     

    302309124

    EUROPEAN CHEMICALS AGENCY

    8G

     

    Company 5696 – Inovyn España

     

     

     

     

    BE0466279394

    702710028

    SOLVIN SA

    8G

     

    BE0403091220

    702703090

    SOLVAY S.A.

    8G

    Monthly amounts below 4 KEUR

     

    302309124

    EUROPEAN CHEMICALS AGENCY

    8G

     

    Company 3454 – Solvay Iberica

     

     

     

     

    PT500140693

    902050002

    SOLVAY INTEROX

    8G

     

    PT500270562

    902050001

    SOLVAY PORTUGAL

    8G

     

    BE0403091220

    702703090

    SOLVAY S.A.

    8G

    Monthly amounts below 4 KEUR

    8. Verify the invoices from the following suppliers/customers:

    COMPANY 0245

     

     

     

    VENDOR / COSTUMER

    NAME

    CHECK TO PERFORM

    CORRECTION

    302309985

    KEMIRA OYJ

    Verify if the invoices are booked with the correct VAT Reg. Number.

    If in the invoice is mentioned Spanish VAT Reg. Number the tax code should be 8D or 81 (not RS or 8R).

    702720978

    SYRAL BELGIUM NV

    Verify if the invoices are booked with the correct VAT Reg. Number.

    If in the invoice is mentioned Spanish VAT Reg. Number the tax code should be 8D or 81 (not RS or 8R).

    1100032444

    RHI AG

    Verify if the invoices are booked with the correct VAT Reg. Number.

    If in the invoice is mentioned Spanish VAT Reg. Number the tax code should be 8D or 81 (not RS or 8R).

    1003020792

    UGC

    Verify if the invoices are booked with the correct VAT Reg. Number.

    If in the invoice is mentioned Spanish VAT Reg. the tax code should be 99 or 8F.

    702701488

    PANALPINA WORLD TRANSPORT NV

    You might find invoices posted with this Belgium vendor it is a freight carrier and for the time being we accept all VAT codes since that depend on the final destination of the products.

     

    602603149

    SIEMENS SCHWEIZ AG

    You might find invoices posted with this Swiss vendor with code 8L and/or without VAT Reg. Number, we must check in the invoice the NIF code associated and book it correctly.

    • If it's a Swiss vendor we should not have VAT Reg. Number associated and should be booked with tax code 85.
    • In case the VAT Reg. Number is from a European Country the tax code should be 92 or 82.

    702712953

    AMERICAN EXPRESS BUSINESS TRAVEL

    You might find invoices posted with this Belgium vendor, booked with tax code 8L

    We must check in the invoice the NIF code associated and book it correctly, the tax code we must use is 92 or 82.

    4316

    ANTONIO BERRIO, S. L

    When invoicing this customer we must use tax code 9Y

     

    COMPANY 5696

     

     

     

    VENDOR / COSTUMER

    NAME

    CHECK TO PERFORM

    CORRECTION

    1003010312

    BASF SE

    Verify if the invoices are booked with the correct VAT Reg. Number.

    • VAT Reg. Number is from a European Country the tax code should be RS or 8R (DE eg).
    • VAT Reg. Number is Spanish the tax code should be 99 or 8F.

    702701692

    POLYTRA NV

    You might find invoices posted with this Belgium vendor it is a freight carrier and for the time being we accept all VAT codes since that depend on the final destination of the products.

     

    2818989

    COMPRESSOR PRODUCTS INTERNATIONAL LIMITED

    You might find invoices posted with this vendor with code RS or 8R and/or without VAT Reg. Number, we must check in the invoice the NIF code associated and book it correctly.

    • VAT Reg. Number is from a European Country the tax code should be RS or 8R (GB eg).
    • VAT Reg. Number is Spanish the tax code should be 99 or 8F.

    602603149

    SIEMENS SCHWEIZ AG

    You might find invoices posted with this Swiss vendor with code 8L and/or without VAT Reg. Number, we must check in the invoice the NIF code associated and book it correctly.

    • If it's a Swiss vendor we should not have VAT Reg. Number associated and should be booked with tax code 85.
    • In case the is from a European Country the tax code should be 92 or 82.

    702712953

    AMERICAN EXPRESS BUSINESS TRAVEL

    You might find invoices posted with this Belgium vendor, booked with tax code 8L .

    We must check in the invoice the NIF code associated and book it correctly, the tax code we must use is 92 or 82.

    9. Verify the invoices with retention:

    SBS-BO need to guarantee if all Invoices with retention, are correctly posted because the percentage of the retention is not the same as the tax code. So amount posted in account 2452030000 must be different from account 2411030034, according to the percentages in use: 
    27 - IVA sop. 21% con ret. IRPF 15 %
    28 - IVA repercutido 21% + 19,5% IRC Rent
    8( - IVA 21% con ret. IRPF 19%
    9( - IVA repercutido 21% + 20% IRC Rent 

    3.2.3 M303 - Launch SAP Report on Fixed assets

    On a monthly basis, is needed to inform the invoices of capital expenses posted on the month of the VAT report.
    This information is obtained performing the following actions:

    1. Launch the transaction Z1K_DETAIL
    2. Select Variant :

    Company 0245 : ESTORCF
    Company 5696: XZECOMAHIVA569
    Company 3454: ES3454-IVA

    3. Period : fiscal year and previous fiscal year:

    • Fiscal year: from 2011 to 2012
    • Period: From 01 to 12

    Image Removed

    4. Click on the button Image Removed

    5. Once the information is on the screen, change the view to an Excel- format view.

    To do it, click on the button Image Removed .

    6. In that screen select the layout "/ES VAT" only the following columns should be extracted from the report:

    TYPE

    Object

    TAX

    INV_Amount

    INVOICE_NR

    INV_Posting

    SUPPLIER

    CostElem

    PURCHASE Ord

    Purch-line

    ORIGIN Object-TEXT

    TXT CO DOC.(or PO/MA)

    The Layout selected is already excluding the doc type "COBK":

    Image Removed 

    7. Filter the column "INV_Posting" 

    Select only the period of the month of the VAT report. 
    For example, if March selected:

    Image Removed

    8. Download the information to an Excel File by clicking on Image Removed . 9. Once created the Excel File, perform the subtotals by tax code and insert a new column to calculate the VAT amount. As a template you can use the attached file. 10. Check the consistency of the information:

    Generally the tax codes to be reported in the VAT return Fund are 99 or 8F and 95 or 86;

    Tax code 8L should be excluded;

    In case of tax code different from the ones above they should be analyzed individually. For instance check the original invoice and confirm if the tax used is really a Spanish tax code;

    In case negative amounts are displayed, they should be checked line per line. (see egg. April 5696 below).

    For each document that you identify with a negative amount, go to SAP and open it:

    Image Removed 

    Confirm the VAT that is being calculated:

    Image Removed

    Now compare with the amounts reported in Z1k_Detail:

    Image Removed 

    We can see that in the first line the invoice amount 4.095,70 € is already considering the credit of 81, 91 € from the second line. This means that we should exclude the second line from our total to report in the VAT return fund. 

    11. Complete lines 31 to 34 of the VAT template (remark: these amounts will also automatically be deducted from lines 21 to 25). 
    REMARK:
    After extracting and analyze the assets data, the file created should be send following the format used as example in step 9

    3.2.4 M303 - Complete the VAT return template

     Open the Excel VAT return template

    1. Enter the figures in the cells of the VAT return template highlighted in blue based on the tax codes of the SAP report S_ALR_87012357 extraction (step 2.1.1.);
    2. Enter the figures extracted for the of capital expenses in the cells lines 31 to 34 of the VAT return template (step 2.1.3.);
    3. Verify that the remaining tax codes (i.e. those that are not reported in the Excel file) do not include VAT amounts in columns "Importe a pagar" or "deductible";
    4. If tax codes not included in the Excel file include VAT amounts, please print out the list of invoices and refer to BO;
    5. Reconcile VAT balances from the draft VAT return with the ones from the G/L account. In case of inconsistencies, BO must find the origin of the difference, and in last case contact FTO;

    Verify that the results of the below checks do not show inconsistencies. In case of inconsistencies, BO must find the origin of the difference, and in last case contact FTO;

    Periodical VAT returns

     

     

     

    Logical checks

     

     

     

    Check % VAT amount

     

     

     

    Compare ratio sales / purchases amounts

     

     

     

    Verify amount VAT position previous month

     

     

     

    Check reimbursement

     

     

     

    These checks are done automatically in the attached "ES VAT return template" and are highlighted or are included in the "Reconciliation" tab of the above mentioned file. 
    The draft VAT return will be automatically completed using the Excel VAT return template. 

    3.2.5. M303 - Finalization

    Once the above steps are completed, the VAT return can be considered as finalized. 
    In case the draft VAT return show results in a VAT payable position, please prepare the excel document, NRC which represents the payment request form, by filling in the missing data for the respective Solvay entities. 
    Finalize the VAT review package, i.e. the draft VAT return, the agreed reconciliation, the payment request form, the list of adjustments and the list of issues (if any).

    • If something needs to be changed, the package will be returned to RTR back office for reworking.
    • If no changes are necessary, the review package will be forwarded to the Solvay contact person in Spain for the final review and approval.
    • If the Solvay local contact person does not agree with the preparation, the RTR back office will be notified for any changes that need to be done.
    • If the Solvay local contact person approves the draft VAT return, he/she will proceed with the filing of the return and perform any VAT payment due.
    RTR-BO must follow up with the Solvay local contact person to confirm the receipt of the package and get back a copy of the submitted VAT return for archiving.

    3.3. M340 - Transactions listing

    In this declaration we must detail line by line all the accounting registrations, with detailed information of all invoices registered with VAT.

    3.3.1. M340 - Run SAP ledgers

    To have all the necessary information you must perform the following: 

    1. Enter in the table using transaction TC_RENT_M340_ES and fill it with all the documents with VAT 9E/9O, 9(/8( and 27/28 for all companies for the month we are closing. To check the documents to add, enter transaction S_ALR_87012357 and make sure that "Output/Input tax: line items" are selected and search for invoices with the tax codes mentioned (the information about the documents can also be retrieved when performing quality checks). 
    Once in the transaction the information you must fill in the table is:
  • Document Number;
  • Year
  • Cadastral Reference according with:

    Name

    Refª Cadastral

    0245 - Solvay Quimica

    5734001VP1053D0001YU

    3454 - Solvay Iberica

    9738305DF0993N0001AP

    5696 – Inovyn España

    0235401DF1903N0001WO

    The final result should be similar to:

    Image Removed
    In case you want to add/remove lines, select the edit mode Image Removed and on Image Removed you can add new information and on Image Removed delete the selected lines. 2. Run transaction S_EB5_05000379 and enter the appropriate variant "ES-M340 (2011)" for Spanish Companies (0245, 5696, 3454). 
    Since January 2012 SCI (companies 0005; 6070; 6233; 6234 and 1419) must submit also this form, the transaction to be used is Z_ES_RFIDESM340 and the variant to select is "ES-M340 SCI"
    E.g. for Solvay Quimica, reporting period 04/2012, fill in:

    Annual VAT return (390)

    From 1st January to 30th January of the following year


    3.2. I prepare the M303 – Monthly VAT Return

    This procedure is done on a monthly basis by VAT SU Team and any inconsistency must be checked.

    3.2.1. I run the SAP ledgers

    Run transaction S_ALR_87012357 and enter the appropriate variants:

    • IVAESPAÑA - for companies 0245;
    • 0005_ES – for company 0005
    • ZFR3 - ZFR3_VAT_ES
    • The remaining companies don’t have a specific variant.


    E.g. for Solvay Química, reporting period 11/2021, fill in:

    • Company Code: 0245
    • Posting Date: From 01.11.2021 to 30.11.2021


     Image Added


    This report will show you the listing of all movements on vendors and customers for the company and period selected and the resume of all transactions by VAT code will be compiled in the different VAT models (303 and 349). 


    The outcome of this step should be as follows

    Image Added 


    Extract this information to excel by clicking on the button Image Added . 

    3.2.2. I perform the preliminary quality checks

    Spanish VAT Rates

    • Standard Rate 21%;
    • Reduced Rate 10%;
    • Super-reduced Rate 4%.


    Checks to perform:

    1) Verify the Intra community Acquisitions of Goods (Tax codes 8R – 21%)

    Check/validate that all the postingsdone using this tax code have only EU VAT id Numbers to guarantee that no acquisitions made to Spanish suppliers are considered.


    2) Verify the Operations with tax exemption (tax codes 8L/9L "OPERACIONES NO SUJETAS – EXENTAS IVA en COMPRAS/VENTAS)

    We must verify if the movements done using these taxes have customers/vendors with Spanish VAT numbers which perform exempt operations.

     

    3) Tax code 8L (incoming invoices without VAT) relate to operations made ONLY WITH SPANISH SUPLLIERS, in this tax code we should not have amount in "IMPORTE A PAGAR" or "DEDUCIBLE"

     

    4) Tax code 9L (outgoing invoices without VAT) – relate to operations made ONLY WITH SPANISH CUSTOMERS, in this tax code we should not have amount in Tax to be paid "IMPORTE A PAGAR" or deductible tax "DEDUCIBLE".


    5) Verify movements with VAT code 9R

    Tax code 9R _ Plant abroad – ADQUISICIONES INTRACOM. DE BIENES must have the same treatment as code 8R (movement of goods between the same legal entity and between EU countries).

     

    6) Additional checks 

    a) Posting P-Cards documents:

    Run: Report S_ALR_87012357

    Variant: ES_VAT CHECK-1


    Check documents with document type S6 and Tax code 8F, only to be check the VAT Spanish numbers. The remaining documents with foreign VAT number, we only can recover the VAT through the 8ª Directive.


    b) Posting of DUA's:

    We need to consult the “Agencia Tibutaria” website and check all the import documents that need to be posted linked to the month of closure.


    E.g.:

    https://www1.agenciatributaria.gob.es/wlpl/inwinvoc/es.aeat.dit.adu.adip.ivaDif.qry.QIVADifInt


    Image Added



    c) Self Billing:

    Add the reference in document  posted for vendor “Cuñado”, otherwise the document will not have the correct correspondence in SII.

    Run transaction: FB03

    Select document type RP and the month of closure


    Image Added



    3.2.3. I launch the SAP report on fixed assets

    On a monthly basis, is needed to inform the invoices of capital expenses posted on the month of the VAT report.
    This information is obtained performing the following actions:

    1) Launch the transaction Z1K_DETAIL

    2) Select Variant :

      • Company 0245 : 0245 ASSETS

    3) Period : fiscal year and previous fiscal year:

      • Fiscal year: from 2020 to 2021
      • Period: From 01 to 12

    Image Added


    4) Click on the button Image Added

     

    5) Once the information is on the screen, change the view to an Excel- format view.

    To do it, click on the button Image Added .


    6) In that screen select the layout "/ES VAT" only the following columns should be extracted from the report:

    TYPE

    Object

    TAX

    INV_Amount

    INVOICE_NR

    INV_Posting

    SUPPLIER

    CostElem

    PURCHASE Ord

    Purch-line

    ORIGIN Object-TEXT

    TXT CO DOC.(or PO/MA)

     

    7) Filter the column "INV_Posting" 

    Select only the period of the month of the VAT report. 
    For example, if November selected:

    Image Added


    8) Download the information to an Excel File by clicking on Image Added . 


    9) Once created the Excel File, perform the subtotals by tax code and insert a new column to calculate the VAT amount. 


    10) Check the consistency of the information:

    Generally the tax codes to be reported in the VAT return Fund are 8F and 86;

    Tax code 8L should be excluded;

    In case of tax code different from the ones above they should be analyzed individually. For instance check the original invoice and confirm if the tax used is really a Spanish tax code;

    In case negative amounts are displayed, they should be checked line per line. 


    3.2.4. I complete the VAT return template

     Open the Excel VAT return template

    1) Enter the figures in the sheets of the VAT return template highlighted in blue based on the tax codes of the SAP report S_ALR_87012357 extraction;

    2) Verify that the remaining tax codes (i.e. those that are not reported in the Excel file) do not include VAT amounts in columns "Importe a pagar" or "deductible";

    3) Reconcile VAT balances from the draft VAT return with the ones from the G/L account.


    Verify that the results of the below checks do not show inconsistencies


    Periodical VAT returns

     

     

     

    Logical checks

     

     

     

    Check % VAT amount

     

     

     

    Compare ratio sales / purchases amounts

     

     

     

    Verify amount VAT position previous month

     

     

     

    Check reimbursement

     

     

     


    These checks are done automatically in the attached "ES VAT return template" and are highlighted or are included in the "Reconciliation" tab of the above mentioned file. 
    The draft VAT return will be automatically completed using the Excel VAT return template. 

    3.2.5. I finalize the M303

    Once the above steps are completed, the VAT return can be considered as finalized. 


    Once the VAT Return analysis is completed we need to access to the “Agencia Tributaria – Sede Electrónica” site: https://sede.agenciatributaria.gob.es/Sede/inicio.html using the Digital Certificate of the Company:


    Image Added


    We must complete the boxes with the info below:

    Image Added


    Then if the company is in a Credit position we need to fulfil the amount of reimbursement to be requested in the form. In case of Debit position, the payment is automatically done when submitting the VAT Return, in Agencia Tributaria.

     

    • Data to be fulfilled in case of reimbursement (Example Cy 0245):

    Image Added


    • Data to be fulfilled in case of payment (Example Cy 0245):

    Image Added


    The VAT returns for companies 7794, 5835, ZFR3 and 6301 are submitted by an external provider.

    3.3. I prepare the M349 - European Sales and Purchase Listing

    This procedure is done on a monthly basis by VAT SU team.

    3.3.1. I run the SAP ledgers

    Run transaction S_ALR_87012403, after select the appropriate variant > ES-M349 and the appropriate release date to determine the reporting period, filling in:

    • Sociedad (name of the company) = 0245;
    • Fecha de contabilizacion (release date) = e.g. 01.11.2021 until 30.11.2021.


    Image Added


    3.3.2. I make consistency checks

    1) Make sure that the totals of the SAP transactions match with the totals of intra-community acquisitions and supplies in the VAT return for the respective period.


    2) ) To perform checks between M349 and M303 you can use template file named: M349 VAT Return Template.

    • The tax code 8D or 81 even if it is intracommunitary is not reported in the ESL report (Modelo 349).
    • Complete the totals in file M303 VAT Return Template.


    3) Examples of modifications that may be required:

      1. Missing VAT numbers: in this case, check the underlying invoices and complete the missing information;
      2. VAT number is from a Spanish supplier: as this listing relates to European transactions, this is not correct. In this case, check the underlying invoices. If it appears that a purchase from a Spanish supplier was wrongfully included as an EU purchase of goods/services, please inform SBS-PtP and amend the posting. Note that this amendment will also have an impact on the VAT return (model 303).
      3. Credit notes: in this case, check the underlying invoices and complete the missing information (i.e. invoice number and period of the return in which the invoice was reported – explained in detail in the next step).

    3.3.3. I prepare the filing

    We need to run the transaction S_ALR_87012401 in order to create the upload file which is an xml format. Then we upload this file to Agencia Tributaria Site:.

    Image Added


    3.4. I finalize the monthly process (M303 / M349)

    Once all the steps are completed we must always send the information regarding company 0245 to Ernest Farran, with all documents like the proof of submission of Modelo 303 and Modelo 349 - example below of the email sent each month.

    Image Added

    We must also add comments with all the problems encountered during the VAT process.

    • Company code: 0245
    • Posting Date: From 01.04.2012 to 30.04.2012
    • Reporting Period or Quarter: 04/2012
    • File name: ES_340_0245_MM (where MM is the month 04)
    Image Removed

    Image Removed

    Image Removed

    • The outcome of this step should be as follows:

    Image Removed

    Extract this information to excel by clicking on Image Removed . This information will be very useful to identify all the possible errors that will be displayed when working in the WEB site. 
    After saving the data click on the arrow Image Removed and make sure that the field "Decleration I" has the corresponding number, at this moment the table for the txt file data is uploaded. 

    Image Removed
    3. Go to transaction Z1F_DOWNLOAD_340 and select the variant "ES-M340" in this transaction we will download a TXT file with the information from the previous transaction that will be treated on the web site.
    You need to guarantee:
    Source file - same name from transaction Z1F_ES_MODEL340
    Target File: Replace the company code xxxx (eg. 0245) 
    Target Disk Drive: Always "C" Image Removed 
    The outcome will be a TXT file to be upload into the web form.

    Image Removed

    3.3.2. M340 - WEB SITE AGENCIA TRIBUTARIA (AEAT)

    3.3.2.1. M340 - Required information before working on the web site

    1. TXT files available to upload; 
    2. Subsidies Information (the information will be sent by MO):
    The information about subsidies is not totally automatically uploaded from SAP we must pick the information from accounts 7400000000 - subsidies received and from account 6441000000 - subsidies given. 
    To extract the data run report FBL3N with variant "ES_SUBSIDIES", extract the information to excel and perform a consistency check per each document:

    • Identify the Vendor name and VAT Reg. number code;
    • Identify if the amounts to be added in the M340 (invoices with VAT are not considered);
    • Define where should be inserted: If 7400000000 - subsidies received should be added as "Facturas Expedidas"; If it's 6441000000 - subsidies given should be added as "Facturas Recibidas "

     

    1. DUA – Tax code 9Q or 8J

    Check if for all SAP documents posted with tax codes 9Q or 8J you have attached copy of the official document. If not attached to the SAP document RTR-BO should contact Front Office to obtain the input tax amounts + document numbers relating to imports of goods.

    3.3.2.2. M340 - Web Site Work

    Open the web and type the following address: 
    https://www.agenciatributaria.gob.es/AEAT.sede/Inicio/Componentes/Tramites_destacados/Presentar_y_consultar_declaraciones/Presentar_y_consultar_declaraciones.shtml 
    Select "MODELO340" 

    Image Removed

    Another screen will appear and you must select "Programa de ayuda para la cumplimentación y presentación 2013 (Recuerde que se exige certificado electrónico para la presentación)

    Image Removed

    You will enter on the below screen, there you will start to work on the information to be delivered to the fiscal authorities. Errors in the upload may occur if within the txt file we have non common characters, we may change to be able to upload the file. 

    Image Removed
    To perform the upload of the files downloaded with transaction Z1F_ES_MODEL340 you must select "Archivo" and then "Leer Declaración", then you will have to select the txt file you want to upload:

    Image Removed 

    You'll get the following screen with the information within the txt file: 

    Image Removed

    3.3.2.3. M340 - Consistency checks to be performed on the web site

    After uploaded the following check's and corrections need to be performed:

    • Errors could occur due to transactions under tax code 8L and 9L (error message will appear) since the transactions (without VAT amount) should in principle not be reported in the VAT return.

     

    • Search for Visa and American Express movements and delete them from the list (except records linked to vendor AMERICAN EXPRESS BARCELO VIAJES) ;

     

    • In company 5696 if appear an error linked to account P04004168 - MA. ANGELS OLIVE QUEROL we should remove it from the list. This is a movement linked to an employee expense.

     

    Delete wrong records (no identified third parties such as "compras contado" (codes 4235 and 2971) or "ventas contado" - code 1100000731)
  • Search via the function "Buscar", enter the subject "Contado" for "Apellidos y nombre" and search trough the uploaded ledgers.
  • Image Removed

    Once you get the information just click on the button B "borrar" to delete these records:

    Image Removed

    • If the taxcode 9Q or 8J appears in the VAT ledgers the following information has to be checked/added in the web site as Invoices received - "Facturas Recibidas":
        1. Name of the vendor (that appears in the DUA as "Exportador" not the Declarante/Representante);
        2. Country Code;
        3. "Clave Ident. Fiscal País Residencia" select "Documento Oficial de identificación expedido por el pais o território de residência";
        4. In "Identificación de la factura" we must add the following information: DUA IMPORT +Document number of the document (attached to this movement in SAP).

    Image Removed

    • Premises Renting

    h7.When the company receives invoices of renting:

    To identify the invoices received in the period open transaction FBL3N with variant "ES_RENTAL", after filter the text column by "Alquileres" to search for the invoices:

    Image Removed

    For these documents we must add as "clave de operación" in M340 an "R".

    Image Removed

    h7.When the company issues the invoices of renting:

    With the development of transaction TC_RENT_M340_ES, there is an automatic way to add to the M340 the information about all invoices issued with tax code 9E or 9O, to these documents we must check that "clave de operación" in M340 has "R", in field "Situación del inmueble" option "1" and the below information for the "refª cadastral":

    Name

    Refª Cadastral

    0245 - Solvay Quimica

    57434001VP1053D00014U

    3454 - Solvay Iberica

    9738305DF0993N0001AP

    5696 – Inovyn España

    0235401DF1903N0001WO

    Like the example:

    Image Removed

    SUBSIDIES

    As mentioned the information about subsidies is not totally automatic and must be prepared previously. 
    In the website we need to confirm the information and change/select in field "Clave de Operación" the option "S" for all the documents identified. In the field "Identificación de la factura" we have to insert the corresponding document number showed in SAP. 
    Image Removed

    PROPERTY SALE - This is not a usual transaction. If any, Solvay Local will give the information.

    After all the changes is extremely important to click on "Recalcular Declaración" and "Guardar Declaración" to save all the manual input done before and confirm that no errors remain.

    Image Removed 

    All these modifications can be saved and a new TXT file will be created. 
    Once all transactions are correctly reported, go to tab sheet "Resumen" on the AEAT website and verify whether the VAT amount in line "Importe total de la cuota" matches with the total VAT amount reported for sales and purchases.
    In this respect, please complete the reconciliation in the above ES VAT return template called "M340 vs M303 Reconciliation_TEMPLATE" and clarify the differences. 

    Image Removed

    3.3.2.4. M340 - Finalization

    Finalize the transaction listing review package, i.e. the draft transaction listing, the agreed reconciliation, the list of adjustments and the list of issues (if any). The review package should be done within back office:

    • If no changes are necessary, the review package will be forwarded to the Solvay contact person in Spain for the final review and approval.
    • If the Solvay local contact person does not agree with the preparation, the RTR Back Office will be notified for any changes that need to be done.
    • If the Solvay local contact person approves the draft transaction listing, he/she will proceed with the filing of the return.
    Follow up with the Solvay local contact person to confirm receipt of the package and get back a copy of the submitted transaction listing for archiving. 
    Remark: 
    It is usual to have small differences between M340 and M303 e.g. employee travel expenses and other no identified third parties. 

    3.4. M349 - European Sales and Purchase Listing

    This procedure is done on a monthly basis by RTR-BO.

    3.4.1 M349 - Run SAP ledgers

    Run transaction S_ALR_87012403, after select the appropriate variant > ES-M349 and the appropriate release date to determine the reporting period, filling in:

    • Sociedad (name of the company) = 3454;
    • Fecha de contabilizacion (release date) = e.g. 01.02.2011 until 28.02.2011.
    Image Removed
    NOTE: make sure that in the SAP extract a column for the tax codes and the name of supplier / customer is included in order to make the reconciliation with the amount reported in the VAT return and in order to prepare the ESPL return in the "informativas 340" software per transaction flow.
    • The outcome of this step should be as follows:

    Image Removed
    Remark:
    For SCI (companies 0005 + 6070 + 6233 + 6234) this process needs to be done for each company code and the outcome have to be added manually in one single file.

    3.4.2. M349 - Consistency checks to be performed

    1. Make sure that the totals of the SAP transactions match with the totals of intra-community acquisitions and supplies in the VAT return for the respective period.

    2. To perform checks between M349 and M303 you can use template file named:

    M349 Reconciliation_TEMPLATE.

    • Within the file "Cuadre 349 - OPERACIONES INTRACOMUNITARIAS" for company 5696 we have a column with Operac Triang. 9x we can retrieve that information after lunching the report S_ALR_87012403 in collumn "Tri.deal - EU triangular deal" we must filter to see if we have any document to be considered in this column – normally appears with an "X".

     

    • The tax code 8D or 81 even if it is intracomunitary is not reported in the ESPL report (Modelo 349).

     

    • Complete the totals in file "M303 VAT RETURN_TEMPLATE". In case of inconsistencies, BO must justify and report to Local team.
    3. Examples of modifications that may be required:Missing VAT numbers: in this case, check the underlying invoices and complete the missing information;
    VAT number is from a Spanish supplier: as this listing relates to European transactions, this is not correct. In this case, check the underlying invoices. If it appears that a purchase from a Spanish supplier was wrongfully included as an EU purchase of goods/services, please inform SBS-PtP and amend the posting. Note that this amendment will also have an impact on the VAT return (model 303) and potentially on the transaction listing (model 340);
  • Credit notes: in this case, check the underlying invoices and complete the missing information (i.e. invoice number and period of the return in which the invoice was reported – explained in detail in the next step).
  • 3.4.3. M349 - Preparation for filing

    Go to transaction Z1F_DOWNLOAD_340 and select the variant "ES-M349" in this transaction we will download a TXT file with the information from the previous transaction that will be treated o the web site.

    Image Removed

    You need to guarantee that:
    Source file - same name from transaction S_ALR_87012403
    Target File: Replace the company code xxxx (eg. SCI) 
    Target Disk Drive: Always "C" 
    Enter the transaction txt file into the program "Informativas 349" software installed in your computer, to create the file to submit on the website of the Spanish tax authorities. 
    See below how to complete the process to prepare the ESPL return:
    1. To import data from the txt file created in Z1F_DOWNLOAD_340 you need to select:

    Importar > Importar registros con fornato BOE 

    Image Removed

    2. Once uploaded, confirm the boxes of the company data as follows:

      • Datos del Declarante
      • NIF: VAT number of the company
      • Apellidos y nombre (…): Name of the company
      • Apellidos y nombre de la persona (…): Contact person (always Elsa Perez Moreno)
      • Teléfono de contacto: Phone number of the contact person (always 93 773 44 71)

     

    3. With the upload all figures must be according to the txt file, you may confirm it selecting "Operaciones" and compare to your file.

    The program is able to perform an analysis of the data uploaded and gives you a list of errors that have to be corrected. Click on Image Removed to check them. 
    It can occur that we have some rectifications or corrections related the previous months reported. 
    For example, we may find negative balances in the file for the M349 upload, for instance:

    Image Removed

    The correct procedure is to check in FB03 the document(s) with the negative amounts and check for what month these are related (in this case the credit note was posted in February but it was related with an Invoice posted in November of the previous year), we can also check FBL1N the Vendor account or the image of the Credit note to search for more information. 
    After identifying all data we can insert in the ESPL return within the Rectificaciones tab:

    Image Removed

    Always having in consideration the month to which the rectification refers to maintaining also the same "Clave de Operacion":

    Image Removed

    4. Once all the data is entered and all rectifications/corrections performed, the ESPL file must be obtained and saved in your computer. On the left side of the screen, click on the line created by your return. Then click on the "world" icon :

    Image Removed

    5. A window will pop up. Click on Siguiente:

    Image Removed

    6. Select the period that you are working and click on "Siguiente":

    Image Removed´

    7. Click on Presentación telemática and then on Siguiente:

    Image Removed

    8. In the following screen create a folder within the C:aeat folder to save your return there.

    Note: Since the name of the file (VAT number ended by .349) does not give any data on the period. We suggest you to create one folder for each period. 
    Select also the option "Deseo una copia en papel de la declaración" then click on Siguiente.

    Image Removed

    Note: When the software was downloaded, a folder called AEAT was automatically created under your C: All your returns must be saved under this folder in order to be subsequently uploaded on the website of the Spanish tax authorities.

    9. Click on Finalizar to generate the file

    Image Removed

    10. Your ESPL file is now created and saved.

    11. There is also the possibility to save the return in pdf format (not applicable in 2013): 
    For that, click on the print logo at the top right corner of the page. 
    A window like this will pop-up, click on Si.

    Image Removed 

    A window like this will pop-up, click on Finalizar 

    Image Removed 

    Choose a folder to save the PDF. 

    3.4.4. M349 - Finalization

    As a final step finalize the ESPL review package, i.e. the draft ESPL return, the agreed reconciliation, the list of adjustments and the list of issues (if any). The review package should be done within back office:

    • If no changes are necessary, the review package will be forwarded to the Solvay contact person in Spain for the final review and approval.
    • If the Solvay local contact person does not agree with the preparation, the RTR back office will be notified for any changes that need to be done.
    • If the Solvay local contact person approves the draft ESPL return, he/she will proceed with the filing of the return.
    Follow up with the Solvay local contact person to confirm receipt of the package and get back a copy of the submitted ESPL return for archiving. 
    The ESPL return filing will in principle be done in Spain by the Solvay local contact person. For information purposes, please find below attached the instructions on how to file an ESPL return in Spain.

    3.5. Finalization of the monthly process (M303 / M340 / M349)

    Once all the steps are completed we must always send the information to Elsa Perez, one e-mail for each company code, with all documents like:
    • Print screen of the SAP summary report
    • Completed Excel VAT template including the draft VAT return and the reconciliation sheet
    • Draft transaction listing (form 340)
    • Draft ESPL (form 349)
    • Dashboard of Intra communitarian Operations
    • Payment Order (when applicable)
    We must also add comments with all the problems encountered during the VAT process.

    3.6. M390 - Annual VAT return

    3.6.1 M390 - Run SAP ledgers

    No specific process exists in SAP for the annual VAT return. This return summarizes all figures reported in the monthly VAT returns. The steps mentioned hereafter will be done locally it's just for information.

    3.6.2 M390 - Perform quality and consistency checks

    The form 390 is filed once a year and summarizes all figures reported in the monthly VAT returns (303). Please reconcile the amounts reported in the periodical VAT returns with the year-end amounts to be reported in the annual VAT return. There should be no differences between the VAT positions of the periodical VAT returns and the final result of the annual VAT return. 
    No corrections can be made in the form 390. Any corrections required need to be made in the related periodical VAT returns.

    3.6.3 M390 - Preparation for filing

    To prepare the 390 form with the Spanish tax authorities, specific software needs to be installed on the computer of the person preparing the 390. In the below attached manual you will find instructions on how to install the necessary software. The instructions refer to the software for the 2011 form. Note that every year new software is released. However, the steps to install it remain in principle the same.

    • The 390 return can be prepared through the software. Note that the boxes in the 390 form that is released every year may differ from the ones in the below manual.
    • The actual filing of the annual VAT return will be done by RTR-BO and submitted by the local responsible

    3.7. Contact persons

    The contact person at Solvay Local is the following:

    Name: Elsa Perez

    Email address: elsa.perez@solvay.com 


    End of document.

    Viewtracker
    hidetrue