1. Objective and Scope

1.1. Objective of this Operation

The purpose of this document is to complete the Italian monthly declaration for the purchases and sales of Services and Goods performed with vendors and customers that belong to countries in the EU (European Union).
Every transaction with these vendors or customers (in the OP "Traders") must be declared in the Intrastat declaration for Services and Goods.
Concerning the Services for every invoice issued or received from these Traders, there is a Service Code to match and to declare to the Fiscal Authorities. The Service Codes are defined by Italian tax authorities.
RtR BO (change RtR BO) extracts the Sales and Purchases reports from SAP and complete the excel files extracted with the Service Codes. 
We have to check the accuracy of the data comparing the data coming from the specific Intrastat declaration for Services transactions to the list of purchases and of sales of the period and to the VAT registers. Also has to be indicated some specific parameters useful for the upload in Intraweb of the CN.
Concerning the Goods, Sales and Purchases data has to be retrieved from SAP reports, after the extraction job scheduled at D+6. These reports have to be analyzed by checking the consistency between the FI side (VAT book) and the MM side (PO data); all the differences must be evaluated and the reasons behind them understood.
RtR BO (change RtR BO) has to perform the upload in Intraweb software for goods and services.
In the end, VAT book and the amount declared in Intraweb must be checked and be consistent, with all deltas justified in a support reconciliation file.
Since all data declared is checked and justified, RtR BO (change RtR BO)  send the declaration to the external study and collect the covers with the official protocol number.

1.2. Scope

This procedure applies to Italian companies that need to fill the Intrastat Services and Goods declaration. Company 0279 doesn't have movements of goods, only services:

• 0270
• 0279 (only Intrastat Services)
• 1425
• 5711
• 5835
• 5894
• 6070/0005

(for companies 0210, 1083,5916 we perform only the analyze for services and send the excel template to an external consultant - mauriziof@echiappe.it - for him to submit the declaration) 

The declaration retrieved from Intraweb software should be addressed to external consultant until the 24^th of the month, for them to submit it afterwards to Fiscal Authorities. The official deadline is the 25^th of the month. 
Continue checking Intrastat transactions even for company already merged or closed like 5881 and 0345, they can still have some movements, and confirm it with the VAT book.

2. Definitions

See Finance Glossary:

• CICC

• FI

• MM

• PF1

• PO

• VAT

• WP1

3. Tasks description

3.1. I extract information about Intrastat services

The transactions on the services, purchases and sales, work only the base of the FI module of SAP.
These transactions retrieve reports based on the VAT code inserted in the FI document, so there is no control on the documents with other VAT codes. 
The VAT code for the purchases is now KN and for the sales is V1 or V3.
Bear in mind that this is just the part concerning the extraction of the data to be declared.
For the analysis go directly to the point 3.3. of this procedure.

3.1.1. I extract the INTRASTAT Service Purchase declaration

Select the transaction: Z1F_IT_INT_SER_PUR
Choose the specific variant for each company: XXXX INTRA CTB (where XXXX is the company code) and insert: 

• Fiscal year: current year
• Posting Date: from the 1st of the previous month to the last day of the previous month. 

Flag "Download file" 
Execute the transaction 
The following screen will appear: 

 

SAP requires saving the file downloaded: 

Please, save the file with .txt extension.

Pay attention to save the file inserting in the file name "acq" for the Purchases and with "sal" for Sales.

3.1.2. I prepare the excel file for purchase declaration

Open Excel program.

Open in the excel program the .txt file just saved:

This screen will appear:

Please select "Delimited" and click "Next" 

 

Select "Other" and insert " ; " and click "Next". 
Then click "Next" again and "Finish" 
An excel file now is open. 

Please click on save Icon : 
Then select "No" 

Save 

 

Now you are ready to fill the excel with the Service Codes needed for the Intrastat Declaration. 
Make sure the file has been saved as "Excel 97-2003 Workbook", otherwise you'll get an error in Intraweb: 

3.1.3. I fill the excel purchase report

The purchase report will have the name "ACQUISTI" in the template.
The field that needs to be filled is the one presented in column 8, the ones that need to be checked are the ones in the columns 10, 11 and 12. 
It is provided a better explanation for these fields hereunder:

1) Column H "8_serv": this is the field for the Service Code.

Open the invoice, analyze the type of services purchased, and then select the Service Code that explains the service in the best way. Fill the cell with the code. 
For the Service Code list, see the official file provided by the Italian tax Authority. 
Or the database archived in SBS RtR BO (change RtR BO) Timetable: 
(update and link to the document)

2) Column I "9_E": in this field, you have to insert the type of relationship with the Trader:

• • I  it is for spot purchases or sales
  • R  it is for repetitive purchases or sales

3) Column L "10_I": in this field, you have to insert the type of payment:

• • B  bank transfer
  • X  CICC

4) Column K "11_PA": in this field, you have to insert the Countries (Code) in which the payment will flow. If the invoice is paid with CICC, always BE. Otherwise, please check the bank account on which the payment will go.

Once you have retrieved the data you have to copy and paste them (paste special values) into the file IT - Template Services Intrastat. Paste data in the blue cells of the template sheet "ACQUISTI". (please confirm if the file is correct)

3.1.4. I extract save images of the invoices for 1083, 5916

For Companies 1083, 5916, the images of the invoices declared are needed.
For every document declared, please save an image and sent all the images to Maurizio. FEDI together with the file excel.

3.1.5. I extract the INTRASTAT Service Sales declaration

Select the transaction: Z1F_IT_INT_SER_SAL -
Choose the specific variant for each company: XXXX INTRA CTB (where XXXX is the company code) and insert: 

• Fiscal year: current year 
• Posting Date: from the 1st of the previous month to the last day of the previous month. 

Flag "Download file" 
Execute the transaction 
The following screen will appear: 

 

And SAP requires saving the file downloaded:

 

Please, save the file with .txt extension. 
Pay attention to save the file inserting in the file name "acq" for the Purchases and with "sal" for Sales. 
Repeat the procedure explained in reference point 3.1.2. (confirm the section) and prepare the Excel File for Sales Declaration. 
Make sure the file has been saved as "Excel 97-2003 Workbook", otherwise you'll get an error in Intraweb: 

3.1.6. I fill the excel sales report

In the file excel report, we can find: 

1) Column F "6_codi": this in the field for the Service Code. 
Open the invoice, analyze the type of services sold, select the Service Code that explains the service in the best way. Fill the cell with the code. 
For the Service Code list, see the official file provided by the Italian tax Authority. 
Or the database archived in SBS RtR BO Timetable (change RtR BO): 
(update and link to the document)

2) Column G "7_E": in this field, you have to insert the type of relationship with the Trader: 

• • I  it is for spot purchases or sales
  • R  it is for repetitive purchases or sales 

3) Column H "8_I": in this field, you have to insert the type of payment 

• • B  bank transfer
  • X  CICC 

4) Column I "9_PA": in this field, you have to insert the Countries (Code) in which the payment will flow. If the invoice is paid with CICC, always BE. Otherwise, please check the bank account on which the payment will go. 

For Companies 5916 and 1083, the images of the invoices declared are needed. See reference in point 3.1.4. (confirm the section)
Once you have retrieved the data you have to copy and paste them (paste special values) into the file IT - Template Services Intrastat. (please confirm the file)Paste data in the blue cells of the template sheet "VENDITE". 

3.2. I extract information about Intrastat goods

The Intrastat for Goods recapitulates the statistical information regarding the intra-community flows of goods between the European Community state members:

• Entry of goods in and from an European member state (in the OP "Purchases");
• Exit of goods in and from a European member state (in the OP "Sales").

The analysis of these flows can be retrieved from SAP reports and are presented as confront between two modules of SAP: FI and MM.

In the process of Intrastat Goods Purchases, we will see, in FI module, all the invoices posted in the VAT book with the Italian Tax Codes for intra-community purchases (MB, ND, LU). This concerns strictly the documents, active and passive, posted in the period, normally by PtP (change PtP).

In the MM side we will see all the goods entries performed in the period, this data are partially filled by provisioning team and partially by local personnel on site. The information is caught by SAP from the Purchase Order.
From a system and accounting point of view we can have information present only in one of the sides. One example can be a good receipt whose invoice has not yet arrived; in this case we have the good receipt (MM side only). 

The process of Intrastat Goods Sales is also presented as confront between two modules of SAP: FI and MM.

In FI side we will see all the invoices/billings posted in the VAT book with the Italian Tax Codes for intra-community sales (V1, V3). Also tax code M1 for San Marino operations.
In the MM side we will see all the goods dispatched from Italy to European member state, performed in the period. 
The extraction of these movements of goods runs automatically by job at D+ 6 early mornings. Please see steps for this in reference point 3.2.1. (confirm the section)
If the automatic procedure stops in error, please call a support from SIS. 
PLEASE NOTE THAT POINTS 3.2.1. (confirm section) DETAILED BELOW ARE ONLY INFORMATIVE.

3.2.1. I perform the automatic procedure

The jobs run in background and all the PtP (change PtP) work on the orders will finish on D+5.

3.2.1.1. I check the jobs that run

For Italy, check the following job in SM37:

You are only able to see the spool list if the status is finished, if the status is released, this means that the job has not been run yet, you have to wait a little bit more. 
Double click on the Spool icon  and you will see the below list: 

 

In this list you should search for the transactions that you want to check: 

• RVEXST00 - Transaction VE01
• RVIVST00 - Transaction VI98
• RMEXST00 - Transaction VI99
• Z1F_CHECK_INTRASTAT - Transaction Z1F_CHECK_INTRASTAT 

For example transaction RVEXST00 - Transaction VE01 for company code 0307: 

You should select the transaction name and then click on  : 

To open the transaction you should click on  :
From top to bottom:

• The first line is the Incompletion log
• The second line is the Selection log
• The last line is to be ignored

3.3. I perform the analysis

3.3.1. I perform the services analysis

3.3.1.1. Overall recap

The services analysis consists in a serious of step that we perform before the upload in Intraweb interface. These steps are necessary to manage the soundness of the declaration about: credit notes, services codes and VAT errors. The services analysis is based on two files:

1) Template services, where we will find all the lines to be declared splitted in purchases and services.

The file called Template services is used only for the final declaration and to report some useful data about some CN (see next section for a better detail).

Hereunder the template:

• •  IT - Template Services Intrastat (confirm the file)

2) VAT reconciliation file, where we will insert the total of Intraweb and VAT to compare the two results. 

The file called VAT reconciliation file is the official file of reconciliation between VAT and Intrastat so it is filled only after the completion of the Template services and Intraweb fulfill. 

3.3.1.2. I manage credit notes in the reports

The credit notes are not uploaded automatically in Intraweb software we distinguish between 2 different kinds of situation: 

1) Credit note related to invoice declared in the same period: deduct the amount of the credit note from the invoice declared in the report (please remind that this is an official rule given by the Italian authorities). 
Delete the line of the credit note in the report (or in the Template file) and archive it in a separate file.
Please archive the deleted lines in VAT Reconciliation Files, in section "LINES DELETED IN MONTH M - CORRECTION OF THE MONTH" (reconciliation files are stored in RtR BO Timetable) (change RtR BO). (update the file and link it)

Considering these as correction in the month we will exclude invoice and CN in a way that the sum of the two has to be equal to 0. 
If it is a partial CN insert the part of the invoice that is cleared. 
If it is a CN for more invoices insert all the invoices cleared. 

2) Credit note related to invoice declared in the previous months: highlight the line in yellow and insert information about the referred invoice (the details needed are explained in IT - Template Services Intrastat. (confirm the file)

3.3.1.3. I manage errors and exceptions in the reports

The reports could have some errors/exceptions that must be corrected before sending the reports: 

a) Lines with Traders without VAT Code: normally it means that the Trader does not have a VAT code in its master data. 

It could be an association, a physical person or Traders that does not belong to UE. We need to check it. 

b) Lines with Traders with VAT code that does not belong to UE: it means that the Trader does not belong to UE. So the invoice should not be present in the Intrastat Services Declaration.

Check the invoice, analyze the reason of the missing VAT code, if necessary delete the line from the report. Add this information in Reconciliation VAT File stored in RTR BO Timetable (change RtR BO) (update the file and link it) to justify the delta between VAT book and Intrastat file and assess if tax code correction posting must be performed. 

c) Lines with Traders with Italian VAT code: it means that the Trader has an Italian VAT code. So the invoice should not be present in the Intrastat Services Declaration (it should be a domestic trade).

Check the invoice, if necessary delete the line from the report. Add this information in Reconciliation VAT File stored in RTR BO Timetable (change RtR BO) (update the file and link it) to justify the delta between VAT book and Intrastat file and assess if tax code correction posting must be performed.

d) Invoices that are for materials and not for services: it means that the invoice posted or received is for a material and not for a service. So the invoice should not be present in the Intrastat Services Declaration.

Check the invoice, if necessary delete the line from the report. Add this information in Reconciliation VAT File stored in RTR BO Timetable (change RtR BO) (update the file and link it) to justify the delta between VAT book and Intrastat file and assess if tax code correction posting must be performed. 
These errors/exceptions often are due to an incorrect use of the VAT tax code (KN/KD/KS) in the posting of the invoices (services-purchases). 

3.3.1.4. I check the accuracy of Intrastat Sales and Purchases reports

For Purchases, please check that the total amount of the column C "{}3_Imponibile" is equal to the amount of the tax codes KN+KD+KS in the VAT Register receivables (Z1F_IT_ZIFIVFR1 - Stampa Iva Fornitori) excluding the CN with reference to past invoices. 
For Sales, please check that the total amount of the column C "{}3_Imponibile" is equal to the amount of the tax code K9 in the VAT Register payables (Z1F_IT_ZIFIVCR1 - Stampa IVA Clienti) excluding the CN with reference to past invoices. 
Register the amounts retrieved above (VAT book VS total amount declared in Intrastat Services file) in Reconciliation VAT File stored in RTR BO Timetable (change RtR BO).  (update the file and link it)
In case of deltas, the amount must be justified with the correspondent documents/postings that are causing the difference. If detected wrong tax code postings, also detail them in reconciliation file, request the correction to General PtP (change PtP) Queue (don't forget to mention the correct tax code that should be used), control when corrections were performed and update this information also in Reconciliation VAT File stored in RTR BO Timetable (change RtR BO). (update the file and link it)

3.3.2. I perform the goods analysis

3.3.2.1. Overall recap

SBS RtR BO (change RtR BO) Italian team has to build a template file to collect the data and perform the analysis before the upload in Intraweb: IT - Template Intrastat Goods.

The file is composed by 5 sheets:

•  (the recap of the VAT comparing with the extraction results for sales/purchases)

•  (copy paste of the result of SAP transaction Z1F_Check_Intra for purchases -> see later points)

•  (copy paste of the result of the SAP transaction Z1F_Check _Intra for sales -> see later points)

•  (copy paste of the result of SAP transaction VE08 for sales -> see later points)

•  (copy paste of the result of of SAP transaction VE08 for purchases -> see later points)

This file template is archived in SBS BO (change BO) Timetable and should be created one file per Italian company and archived in the correspondent company code folder. 
After compiling all data, the first check that has to be performed is on the outcome of VE08. 
VE08 retrieves the data from the Purchase Orders (MM side) or the billings (SD side).

3.3.2.2. I check VE08

For Purchases, run VE08 transaction and select the variant "IT-CCCC-IMP" (where CCCCis the company code number). 
Below an example from company 0270 Solvay Chimica Italia: 

For Sales, run VE08 transaction and select the variant "IT-CCCC-EXP" (where CCCC is the company code number). 
Below an example from company 0270 Solvay Chimica Italia: 

Extract the data in excel, create a file template as described in reference point 3.3.2.1. (confirm the section) and copy the data. 
Checking the VE08 you control the last table that has to be uploaded (this report is the one that will be uploaded in Intraweb software). Also this report is the mirror of MM side from report Z1F_Check Intra. 
One of the columns in VE08 report is the "Procedure". In theory "Procedure" "1" indicates the common invoices; "5" for the credit notes and "6" for the debit notes. The system (Intraweb) inserts "Procedure" "5" and "6" in section I or II, but is not able to recognize the correct sign; we have to check and insert all them in section 2 with the correct sign (negative for "Procedure" "5" and positive for "6").
Check if all the fields are filled, namely "Net weight" and "Commodity code". 
In the column "Net weight" you should filter all the:

• Fields that are empty
• Fields with an amount equal to 0
• Fields with an amount equal to 1

For all these situations of missing data or wrong data you have to open the invoice image in SAP or/and check Purchase Order master data, if we are dealing with good movements registered in Purchase Orders (normally for "Purchases") or documents flow inside billings issued (for "Sales") 
After this check, if you find no evidence in invoices images, or PO master data, in case of Purchases, please contact the proper person in PtP (change PtP) Department (Ana Almeida/Marta Almeida). 

3.3.2.3. I check Z1F_CHECK_INTRASTAT

For Purchases, run Z1F_check_intrastat transaction and select the variant "IT-INTRACCCC-I" (where CCCC is the company code number). 
Below an example from company 0270 Solvay Chimica Italia: 

For Sales, run Z1F_check_intrastat transaction and select the variant "IT-INTRACCCC-E"(where CCCC is the company code number). 
Below an example from company 0270 Solvay Chimica Italia: 

Extract the data in excel and copy the data to file template created as described in point 3.3.2.1. (confirm the section)
This transaction gives you a detailed and completed analysis of the differences between the MM and the FI data.
It has several columns, on the left side of it we will find the FI side, it has to be equal to the VAT book.
In the process of Intrastat Goods Purchases, we will see, in FI module, all the invoices posted in the VAT book with the Italian Tax Codes for intra-community purchases (MB, ND, LU).
The FI side for Intrastat Goods Sales will collect all the invoices/billings posted in the VAT book with the Italian Tax Codes for intra-community sales (V1, V3). 
The right side of the file is the MM side, this data are retrieved by SAP from all the POs that have to be declared. We will see all the goods entries performed in the period. 
The differences are highlighted with a star on the right column of the MM side. 
All this lines in error have to be analyzed one by one, we have to open each invoice image, verify all the information that is coming from purchase orders or billings linked with that document. 
We can have several cases, mainly for Purchases, we've collected some of the errors in the file that you find hereunder: 

• IT - Errors from Check Intra (Goods) 

Above, you could find some common practical issues that have been detected, in all these situations we must confirm the countries involved in the goods movement (if they are really EU members), confirm the object of the invoice (if are really goods or simply services), verify if we are dealing with fiscal representations, with the purpose to assess if the tax code used is correct and if we should include or exclude these lines from Intrastat declaration. 
The amounts with the stars have to be treated in 3 possible ways:

1. Have to be declared
2. Do not have to be declared
3. Do not have to be declared and have to be inserted in Reconciliation VAT File. (update and link it)

In case of c) it means that the posting document was performed with a tax code used for EU purchase/sales of goods and it is wrong. As we are not going to include this line in Intrastat Declaration, but we have it registered in VAT book we will have a delta to justify. 
In case of deltas, the amount must be justified with the correspondent documents/postings that are causing the difference. Wrong tax code postings, must be detailed in reconciliation file, request the correction to General PtP (change PtP) Queue (don't forget to mention the correct tax code that should be used), control when corrections were performed and update this information also in Reconciliation VAT File (update and link it) (below the Reconciliation File from company 5835): 

3.3.2.4. I perform the final extraction

Since Check Intra errors and VE08 excel report have been analyzed, run VE08 and retrieve the txt file to upload in Intraweb software.

First launch transaction VE08 selecting the proper variant as explained above in reference point 3.3.2.2. (confirm the point)

Then, before executing, you have to fill "Sequential Number of Declar.":

This number should be sequential to the last one used in the previous Intrastat Declaration. 
*+All numbers used are registered in Timetable file:+* (update and link it)

Pick-up the last one used and run VE08 with the number after. And don't forget to register your new number in Timetable file so we can track the last number that has been used (below the numbers that have been used in June, all registered in the file):

We should bear in mind that it is not possible to upload a file named "scambi.cee" whose number of reference is already used in Intraweb or whose period of reference (month, quarter) is not the same of the one indicated. Please wait if the file is in use by another user, the selection of sequential number should be a very easy and fast operation.
The number file is stored in the Timetable in the section dedicated to the Italian team. It has to be sequential considering all the Solvay companies declared by Fedi. For all the companies that have goods to be declared you HAVE TO start from the goods declaration so you decide the sequential number; while for the company with services only you DO NOT DECIDE the sequential number (see reference section 3.4.2.5.) (confirm the section) because the "Elenco" is automatically created by the system.
After executing, confirm if you have items that have not been integrated (click on "processes not relevant for declaration"). If yes analyze if they will have impact in VAT reconciliation and assess if should be manually inserted in Intraweb:

Then click on the left side "create diskette":

If you have not yet created, please create in your drive H: a new folder named "SCAMBICEE" (before you extract VE08 this folder must be empty):

In the next screen you find, please insert only the fields below highlighted in red:

Now click  and you'll find this screen:

Don't modify the file name, only click "Save". You'll get this final screen; txt file has been archived in your drive H: inside "SCAMBICEE" folder.

Data is ready for the upload in Intraweb. Follow next steps of this procedure to know how to manage Intraweb. 

3.4. I perform the procedures related with Intraweb

3.4.1. I log on Intraweb

First you should check that Intraweb program is installed in all the VDIs that are going to be used. 
Open the folder "documents" in your VDI:

Enter in Drive  , click on  , then  and double click on 

This screen will appear: 
 

Insert only in field "Id utente" the word admin. Then click "OK".

Important: After logging on, you have to guarantee that basic data has been customized and you have available all the information declared since year 2010, all months, for Purchases and Sales, for all italian companies in the scope of this procedure (for example, print screen below confirm that all data is available for company 5711): 

Check if you have also the data for all the other companies in the scope, by selecting "anagrafica"/"cambio obbligato" 

When you log on, if no data is available, and before uploading new data for your Intrastat Declaration, please restore last declarations information – follow instructions in point 3.4.2.3. from this procedure. (confirm the point)
Below Intraweb when you have no data: 

After restoring data, and in case you are uploading Intrastat for Services, you might have also to customize excel file templates - follow instructions in reference point 3.4.2.2. from this procedure. (confirm the point)
Go to reference point 3.4.2.1. (confirm the point) only if you have to create new master data, as new company codes, for instance.

3.4.2. I customize the data

3.4.2.1. I customize new master data

3.4.2.1.1. I customize third party entity ("delegato")

(Delegato = third party responsible for the official upload) 
By using this function we can upload anagrafic datas of a delegated entity (obviously this is possible only if exists a specific and authorized third party, it is the case of Solvay Italy with the Study Chiappe represented by Mr. Fedi) 
In order to activate this function we should select Anagrafica/Delegato/Nuovo Delegatofrom the Intraweb homepage: 

Afterwards it will appear a window with datas that should be uploaded. 

These are the anagrafic data coming from CAD EUROPA (we just need to change only in case of changes in the delegato) 

3.4.2.1.2. I customize new company to declare Intrastat ("obbligato")

(Obbligato: subject that is obligated to do the declaration) 
By using this function we can upload datas of the "obligated"subject. Only after the completion of this phase we will be able to fill the Intrastat in Intraweb.
In order to activate this function we should select Anagrafica/Nuovo Obbligato from the Intraweb homepage: 

Afterwards it will appear a window with data that should be uploaded. We will fill it with all the companies data. 
Frequency: the declarations for the Italian companies are completed monthly. When we choose the frequency monthly, in the Intraweb screen the options will appear: "Annual value of purchases…." and "Annual value of sales..." WE HAVE TO FLAG BOTH OF THEM (without these flags we will fill a short form of the declarations, that is not indicated for the Italian companies of Solvay Group, further details at the following address: >HELP>AIUTO>ANAGRAFICA>OBBLIGATO) 

In the same screen, besides OBBLIGATO data, we have to insert DELEGATO data as indicated in the following example: 

Hereunder there are the anagrafic datas of the companies involved in Intrastat (we have to remind to upload and update data in Intraweb in case of future changing): 

• 0279 - SOLVAY S.A. – ITALIA - VIALE LOMBARDIA, 20 - 20021 BOLLATE (MI) – P. IVA 00089900492

• 0270 - SOLVAY CHIMICA ITALIA S.P.A. - VIA PIAVE, 6 - 57016 ROSIGNANO SOLVAY (LI) - P. IVA 00104340492 
• 0005+6070 - SOLVAY CHEMICALS INTERNATIONAL S.A. – VIA PIAVE, 6 – 57013 ROSIGNANO SOLVAY (LI) – P.IVA 00104469994 
• 5711 - SOLVIN ITALIA S.P.A. - VIA G. MARCONI, 73 – 44100 FERRARA (FE) – P.IVA 01323870491 
• 1425 - SOCIETÀ ITALIANA DEL CLORO S.R.L. - VIA PIAVE, 6 – 57016 ROSIGNANO MARITTIMO (LI) – P.IVA 08578190962 
• 3459 - SOLVAY BENVIC EUROPE - ITALIA S.P.A - VIA G. MARCONI, 73 - 44100 FERRARA (FE) - P.IVA 01445000381 
• 5894 - SOLVAY CHIMICA BUSSI S.p.A. - PIAZZALE ELETTROCHIMICA, 1 - 65021 BUSSI SUL TIRINO (PE) P.IVA 01451960494 
• 5835 - SOLVAY SPECIALTY POLYMERS ITALY S.p.A - VIALE LOMBARDIA, 20 – 20021 BOLLATE (MI) - P.IVA 03521920961

3.4.2.2. I customize excel template files for data upload

To upload the data from Services Intrastat, we need to create a template in Intraweb – "FORMATO RECORD" with the following path: DETTAGLI>NUOVO FORMATO FILE.

Through this function we can define a specific import format (called "tracciato record") where we have to indicate the detail of the labels for each column of the external file. In this way Intraweb will read the label of each column and will record each data in the right position.
In order to activate this function we should select from the menu "Dettagli" the line "Nuovo formato file". Then a new window will appear:

• Nome Formato: name linked to the import format file that is going to be imported
• Carattere delimitatore: this is the type of digit that is going to be used (e.g. ";") in a .txt format to divide the cells of "tracciato record"
• Tab : specific type of space, called tab, defined to divide cells in a file in .txt format
• Excel: specific function to divide the cells in .xls format of a "traccioato record" file
• Tipo operazione: function to indicate if the file we are uploading refers to: purchases/sales of services/goods
• Sezione: function to define which is the section of reference
• Periodicità: we should define if the detail refers to a monthly or quarterly record
  
  

3.4.2.2.1. I customize the template for services received (purchases)

Select in menu "Dettagli" the line "Nuovo formato file". Then a new window will appear that should be filled as the one showed hereunder:

After pushing the button OK we will see a window splitted in two parts: on the left we will find all the fields that represent the possible characteristics of each partners; the right side is blank and we should fill it with the data present in the file we are going to import.

We can select all or part of the fields and then move them to the right side using the proper button. The format of the file will be created only after pushing the button OK.
For the services received (purchases) we need the following fields:

We should not upload the progressive number, it is given directly by Intraweb (so we should insert VUOTO=EMPTY).
The sequence of the fields to be uploaded is automatically recognized from the services file:

3.4.2.2.2. I customize the template for services delivered (sales)

Select in menu "Dettagli" the line "Nuovo formato file". Then a new window will appear that should be filled as the one showed hereunder: 

After pushing the button OK we will see a window splitted in two parts: on the left we will find all the fields that represent the possible characteristics of each partners; the right side is blank and we should fill it with the data present in the file we are going to import.

We can select all or part of the fields and then move them to the right side using the proper button. The format of the file will be created only after pushing the button OK.

For the services delivered (sales) we need the following fields:

The sequence of the fields that should be imported is detected from the services file: 

3.4.2.3. I restore the data from last declarations

When you log on, if no data is available, and before uploading new data for your Intrastat Declaration, please restore last declarations information. 
You have to RESTORE the backup (with the last version) - PAY ATTENTION TO THE PATH.

Click on-> utilita' -> Archivi-manutenzione -> Restore -> Totale 

This screen will appear 

Enter in drive M: 

Enter in the folder of our team  , click on  , click on  , Pick up the fiscal month of the declaration EG June .
Now you have to choose the last back-up archived. 
This is an example of the format, to understand which is the last you should read the date: 
 
In this case the date is 24th July 2014, BUT CHECK ALWAYS WHICH IS THE LAST. 
Click on the file choosen. Then click on "Procedi" .
This screen will appear, click on OK.

The system will restore the data, the operation will take a while. 

ATTENTION: Try not to use the computer while is restoring. 
You can have two outcomes: 

OR

In case you find the first, there is an error, you have to repeat the operation from this screen (often it is necessary to repeat more than two times): 

If appears the second screen with the sentence "Restore terminato" you can move on. 
It means that we have now available all the data submitted in Intraweb from past months, concerning the Intrastat of Goods and Services.

3.4.2.4. I upload the data for goods in Intraweb

Log on in  and check if basic data has been customized and you have available all the information declared since year 2010, all months, for Purchases and Sales, for all italian companies in the scope of this procedure. If not, restore all data, as explained in reference step 3.4.2.3. (confirm the point)
You are ready to import data from Goods Intrastat as soon you retrieve in SAP the SCAMBI.CEE file from SAP (see reference point 3.4.2.4.) (confirm the point)
First make sure you have Intraweb opened in the company you are going to do the upload. 
We have to click on Anagrafica->Cambia obbligato 

It is very important to remind to do this action every time we would like to change otherwise we will work always in the same company.
By pushing the button "APRI" we will open the desired company, we have always to check the company name on the top of the Intraweb window.

Since the company you are working is already opened in Intraweb, to upload the data, select "importa->scambi.cee->file singolo": 

Then open the file "scambi.cee" you saved in drive H: inside folder "SCAMBICEE": 

In case you find no upload errors you'll get the following result: 

If you have upload errors, go to reference point 3.4.2.6. from this procedure. (confirm the point)

To analyze the data uploaded, you have to open the right year/month you are working. You will see this options:

• For Purchases:

• For Sales:

Choose the proper option, according to the information you've uploaded and then select the month you are reporting: 

Once selected interested month, click on "Visualizza dettagli" on the right: 

On this screen: 

We will see 8 tabs after explained: 

There are 4 sections in Intraweb:

• Section I - for invoices of goods
• Section II - for credit notes and debit notes of goods
• Section III - for invoices of services
• Section IV - for credit notes and debit notes of services

To check Goods Intrastat data, we select only "section I" and "section II".
For each Section , you have two options: 

In "vista completa" you will see the complete list of invoices for goods declared in that month. 

If you select "vista singola" you can add new entries (invoices) for goods.

Above you find an example from an invoice declared in Section I (Goods). 
To insert manually an invoice in section I you need to fill:

• Partita Iva Partner: VAT number from the supplier/customer;
• Amm. Operazione: invoice total amount
• In Valuta: only to fill in case of non european currency (total amount in the foreign currency)
• Nat. Transazione: put always "1"
• Nom. Combinata: commodity code
• Massa Netta: net weight
• Unita Supplem: only mandatory for some commodity codes (if required, this line will be in error until you fill this information; often the additional unit of measure is the number of pieces and you find this information when opening invoice image in SAP).
• Val. Statistico: incoterms defined in the purchase/sale (if it is EXW, the statiscal value is calculated applying 105% (invoice amount*105%); for other incoterms we apply 95% (invoice amount*95%)). Below an example of incoterm, that is not EXW, so to be applied 95%:

• Cond. Consegna: open the options and select the one corresponding to invoice incoterms
• ModoTransporto: put "3" unless you have a different information in the invoice
• Paese Provenien: dispatch country
• Paese Origine: country of origin
• Prov. Destinazione: destination (region)

To declare Credit Notes for Goods (Section II), you can only declare Credit Notes related to invoices from previous months; so if you have a credit note related to an invoice from the current month, you should deduct this amount in the respective invoice, that would be present in Section I.
Hereunder an example of a credit note that has been declared in Section II: 

To declare Credit Notes for Goods (Section II), you declare the exact amount of the credit note with negative sign, put the reference month of the original invoice, "Nat. Transazione" is always "1", insert the commodity code and the statistical value.

3.4.2.5. I upload the data for services in Intraweb

Before uploading Services data in Intraweb, confirm if it has been created the template format in Intraweb (see reference point 3.4.2.2.) (confirm the point)
Open IT - Template Services Intrastat (confirm the file) already with blue cells filled, according to point 3.1.2 (confirm the point) (for reference Purchases) and point 3.1.5 (confirm the point) (for reference Sales).

Copy the data in blue cells and paste them to a new excel file. Pay attention to not include the negative amounts (credit notes). Keep them in IT - Template Services Intrastat, (confirm the file) because you must include manually all credit notes in Intraweb ("sezione 4"). 

The file format to perform the upload is an excel file that has to be saved as "Excel 97-2003 Workbook", otherwise you'll get an error in Intraweb:

 . 

You have to do 2 uploads, one for the Purchases file and another for the Sales (see reference point 6.3 (change the point) for additional info). 
For non-administrative companies, do them after you complete the upload of Goods, so you can integrate inside the sequential number already created when you uploaded the Goods:  (see reference point 3.4.2.5.1.) (confirm the point)
The only exception is for the administrative companies, that have no goods, only services – this is the case of company 0279. To do it you have to create this number in Intraweb as explained in reference point 3.4.2.5.2. (confirm the point)

3.4.2.5.1. I upload the Intraweb data for services - non-administrative companies

After saving the data as explained above, open Intraweb in the company you are working: 

  

Expand the folders on the left and click in the year/month you are reporting. 
Inside  if you are uploading Services – Purchases or inside  if you are declaring Services – Sales (in the example below, we will upload Services –Purchases in July/2014 for Solvay Chimica Italia): 

Select "Dettagli"/"Leggi da File": 

Select "sezione 3", which corresponds to services: 

Click ok:

After, pick up the file you saved before as "Excel 97-2003 Workbook" (click "Apri"): 

You'll have now Purchases or Sales uploaded, but only for "sezioni 3" - you integrated only the invoices: 

The credit notes you have in IT - Template Services Intrastat  (confirm the file) must to be manually inserted in "sezioni 4". Go to reference point 3.4.2.5.3. (confirm the point) to know how to insert Credit Notes for Services. 

You have to run this steps twice, for Purchases and for Sales.

3.4.2.5.2. I upload the intraweb data for services – administrative companies

Open Intraweb in the administrative company you are working (0279 – Solvay S.A. – Italia; 5881 – SIS Italia SPA): 

These companies have no Intrastat for Goods, so to upload the data, the sequential number for the declaration is generated automatically in Intraweb tool based on the last number that has been used for Goods or Services. To create this new number, please click "Elenco" / "Nuovo": 

You will have this screen ("num. riferimento" is the sequential number provided by Intraweb) : 

Check if "num. riferimento" provided by the system is consistent with the register of all numbers used, that are archived and updated in Timetable document: 
Solvay Business Services - BO > TIMETABLE > R2R Italy Finland and Bulgaria Team > 2 - LOPs > ITALY > IT - INTRASTAT > PROGRESSIVE NUMBERS TO IMPORT (update and link it)
If "num. riferimento" is ok, fill "Tipo Operazione". Choose "Acquisti/Servizi ricevuti" if you are uploading Purchases or "Cessioni/Servizi resi" if you are uploading Sales and select the reporting month. 

Click "conferma". 
Expand the folders on the left and click in the year you are reporting. 
Go inside  if you are uploading Services – Purchases or inside  if you are declaring Services – Sales. Click in the month you are reporting (in the example below, we will upload Services –Purchases in August/2014 for company 5881): 

Select "Dettagli"/"Leggi da File": 

Select "sezione 3", which corresponds to services: 

Click ok:

After, pick up the file you saved before as "Excel 97-2003 Workbook" (click "Apri"): 

You'll have now Purchases or Sales uploaded, but only for "sezioni 3" - you integrated only the invoices: 

The credit notes you have in IT - Template Services Intrastat  (confirm the file) must to be manually inserted in "sezioni 4". Go to reference point 3.4.2.5.3. (confirm the section) to know how to insert Credit Notes for Services. 

You have to run this steps twice, for Purchases and for Sales.

3.4.2.5.3. I manage credit notes in Intraweb – services

All Credit Notes have to be manually included in Intraweb. Check the lines with negative amounts highlighted in yellow in IT - Template Services Intrastat (confirm the file)

Credit Notes in Intraweb for Services are integrated in  and can be inserted/modified through  
The amount to put in Section IV is the net amount between the original invoice declared in the past and the amount of the current credit note. 
We can have total credit notes (the amount of the credit note is equal to the invoice declared in the past) or partial credit notes (the amount of the credit note is less than the invoice declared in the past).
In case of total credit note, the net amount between invoice declared and credit note is zero, so the data you have to fill in section IV is only:

• "sezione doganale" – put always "055100"
• "year" – put the year of the referred invoice declared in the past
• "protocollo" – pick up the protocolo number archived in Timetable, based on the month/year of the referred invoice. Pay attention to pick up the correct protocol number, depending if we are declaring Sales-Services or Purchases-Services:

• "progressivo sez. III" – go to Intraweb inside the year/month where the referred invoice has been declared and take note of the the respective line number:

Below an example of a total credit note declared in section IV: 

In case of partial credit note, you have to declare the net amount between invoice declared and credit note. It is better to look in Intraweb the exact data declared in the past concerning the referred invoice so you can fill all the required fields in section IV to declare the present credit note. The data you have to fill in section IV is:

• "sezione doganale" – put always "055100"
• "year" – put the year of the referred invoice declared in the past
• "protocollo" – pick up the protocolo number archived in Timetable, based on the month/year of the referred invoice. Pay attention to pick up the correct protocol number , if we are declaring Sales-Services or Purchases-Services
• "progressivo sez. III" – go to Intraweb inside the year/month where the referred invoice has been declared and take note of the the respective line number
• "partita IVA partner" – VAT number
• "amm. operazione" – net amount between the original invoice and the credit note
• "nr. fattura" – SAP FI document number from the original invoice, the same declared in the past, in section III.
• "data fattura" – posting date of the original invoice, the same declared in the past, in section III.
• "codice servizio" – the same commodity code of the invoice declared in the past, in Intraweb – section III.
• "mod. erogazione" – I
• "mod. incasso" – B
• "paese pagamento" – country code of the payer.

Below an example of a partial credit note declared in section IV: 

For the data retrieved above to fill the credit note in section IV, we have to search in Intraweb, in section III, the complete information declared:

After inserting credit notes in section IV and all invoices in section III, check if all data is ok and consistent with VAT book. To perform this check, open Reconciliation VAT File and inside it open sheet "Sales services" or "Purchases services". Fill all linked sections, to check if amounts entered in Intraweb are correct and match VAT book.

3.4.2.6. I upload errors/modify data

3.4.2.6.1. I manage the upload errors

When Intrastat data is uploaded into Intraweb you can find some errors:

In case of errors not yet solved, the reporting month in Intraweb will have this status: 

To correct them click in  ,  , "sez I vista completa" (for goods) or "sez III vista completa" (for services). 
In Intraweb, the lines in error are highligted in red:

Double click in each line, to solve each error. 
Below some common errors that can be retrieved after Intrastat data upload:

• "E' richiesta l'unita supplementare" – for this error, besides the net weight, it is required an additional unit of measure. Check in the invoice or purchase order master data this information. Often, the additional measure is the number of pieces.

• "Nomenclatura Combinata: codice non valido" – the commodity code uploaded is wrong. We should search a similar code inside "nomenclature combinate" from Intraweb, with a general denomination "altri".

Example: wrong commodity code - 39019009. The commodity code to be used instead would be 39019090:

• "Paese Destinazione: codice non valido" – this happens recurrently for the transactions with Greece. In intraweb the outcome is "GR" like extracted from SAP but should be "EL" for "paese destinazione".

• "Partita Iva: codice non valido - dato fornito/ Natura Transazione: valori ammessi 1..9./ Il campo Nomenclatura Combinata e' obbligatorio./ Paese di destinazione: obbligatorio/ Provincia: obbligatorio" – all this errors combined are for San Marino operations (for the upload of Goods/Sales for company 0270 or company 0005).

Confirm if you are dealing with a San Marino transaction, by analyzing invoice image (VAT number starts with SM). 
If yes, you have only to fill San Marino VAT number and the total invoice amount: 

In the end, confirm if all upload errors have been corrected. You should have no  . 
You should find the reporting month with this status: 

3.4.2.6.2. I modify the uploaded data

There are some functionalities in Intraweb that you can take advantage when you are searching for data or when to modify or erase particular lines or even cancel the whole data. 
Hereunder we will explain how to:

• Search data
• Sort data
• Remove lines
• Delete/adjust an "Elenco" (= declaration)

To search data, enter in  or  , depending if you are checking Goods or Services, respectively. 
You'll find in the bottom several useful options: 

You can filter the data, by VAT number, for instance. 
Write the VAT number you need to filter in  and then click on  . 
To start a new search, before don't forget to click on  . 
You can also sort the data by column, by clicking in the column you want to sort. 
Below a print screen of data sorted by amount (click on  ): 

In case you need to duplicate one particular line, select the line you want to copy: 

Click on  , then  . 
The new line will appear in the last position of "vista completa". It will be also the last "progressivo number" in "vista singola". 
When using this option, you can use the information copied and then modify it according to your needs. 
To modify this line, double click in the line in "vista completa", or go to the last "progressivo number" in "vista singola": 

Particular lines, if needed, can be also be removed from Intraweb. 
To erase it, first select the line in "vista completa: 

Then click on  . The following message will appear: 

Click "Si" 
However, and for exceptional reasons, during the completion of the Intrastat you may need to delete some part or the entire declaration. 
If you have to delete ONLY one section you have to enter in the section, select all the lines and erase them. Deleting only one section you will not loose the "Elenco", the folder.
If you have to delete one "Elenco" you have to click with the right button on it (Ex M-07-102877-d) and then click on "Elimina". With this you will delete all the four sections and the folder.
If you are declaring a company with goods and services you have to upload the Intrastat goods again and then the services. Uploading the goods before, through VE08 outcome, we do not have to change the number of the declaration. 
If we are deleting an "Elenco" of a company with services only we have to track the number of the "Elenco" we are deleting because the system will consider this as used and will give you a new one when you will try to create a new "Elenco".
In this case we will use the number given by the system and we will use the number not used in the next company with the goods declaration, and consequently VE08 outcome.

3.4.2.7. I perform the final reconciliation Intraweb vs VAT

Since all Intrastat data has been uploaded in Intraweb, has been updated and corrected according to "check intra" and "VE08" analysis previously done, we have to validate if the amounts entered in Intraweb are consistent with VAT book. 

For Intrastat Services Purchases compare:

• VAT Register receivables (tax code KN+KD+KS) VS Intraweb (Section III - Section IV) 

For Intrastat Services Sales compare:

• VAT Register payables (tax code K9) VS Intraweb (Section III - Section IV) 

PAY ATTENTION:when running VAT Register for the Administrative Companies (0279) check if there is any amount in the Tax Codes used for Goods– if yes it is WRONG - ask correction to PtP (change PtP) and insert this information in Reconciliation VAT File.(upload the file and link it)

For Intrastat Goods Purchases compare:

• VAT Register receivables (tax code MB+ND+LU) VS Intraweb (Section I - Section II) 

For Intrastat Goods Sales compare:

• VAT Register payables (tax code V1+V3+M1) VS Intraweb (Section I - Section II)

(M1tax code used only for San Marino trades, for companies 0270, 1425 or 0005)

Register the amounts retrieved in all Intraweb sections vs VAT book in Reconciliation VAT Files.(upload the file and link it)

There is one Reconciliation File per company and each file has 4 sheets:

• Sales Services
• Purchases Services
• Sales Goods
• Purchases Goods

Before sending the declaration to our external consultant, fill there all the required information to check the consistency between VAT and Intraweb data. 
All deltas should be all justified and detailed in Reconciliation VAT File. (update and link it)
Normally are wrong documents posted by PtP (change PtP), that we should ask for the correction in the month after. For the corrections performed in the month after we will find in the following month the same delta with an opposite sign. Only after all corrections done, deltas are solved in the reconciliation file. 
Every month we should check and track if corrections previously requested have been performed, to erase and solve as much as possible all differences. The final purpose is to have a clean overview of all pending actions that should not exist or be few by the year end.

3.4.2.8. I prepare and send Intrastat declaration

Since consistency between Intraweb data and VAT book has been retrieved and justified in Reconciliation VAT File, you can prepare and send, by email, Intrastat final data to our external consultant.
To send the final data, you need to:

1. Block the data, so no more modifications are allowed. For each company, you have to block the Sales and block Purchases, separately.
2. Save the Declaration Cover + Aggregated Data from Section I + Aggregated Data from Section II + Aggregated Data from Section III + Aggregated Data from Section IV
3. Create the final txt scambi.cee file with all data compiled (Sales and Purchases from Intrastat Goods and Services)

1. BLOCK DATA

Select the reporting month  , inside  to block Purchases or inside  to block Sales.
Then go to Menu "Elenco"/ "Approva/Sblocca Approva": 

In the next screen click "Si": 

You'll get the information: 

In this stage, the "elenco" you blocked will have this status  . 
Repeat the same, but selecting the "elenco" for Sales. 
In the end, Intrastat data from the month we are declaring will be blocked, with no modifications allowed. Also the lines will be grouped, based on common VAT number and commodity code: 

2. DECLARATION COVER+ALL SECTIONS AGGREGATED DATA

After completing point a) select the Purchases "elenco" and go to Menu "File"/"Stampa":

Flag all options: 

You can get some information messages. Click "Ok". 
Intraweb will generate a PDF file with all compiled information for Purchases (Goods and Services). 
Then, repeat the procedure for Sales to save the PDF compiled file for Sales. 
Save them like the examples below: 

Save with company code denomination (not company code number), identify if you are saving Purchases or Services, write "GS" to identify that you are saving Goods and Services data and insert the declaration month and year.

3. COMPILED SCAMBI.CEE FILE

First make sure that the folder SCAMBICEE you have in H: drive is empty: 

Go to Menu "Web"/"Invio per Dogane"/"Prepara Invio": 

After click "Ok" in the next screen: 

In the following window:

Click in " » " to generate a single SCAMBI.CEE file with Sales+Purchases data (Goods+Services): 

Click "Salva":

Write "01" in "progressivo invio" if it is the first declaration you are submitting in the day (if no, put the sequential number): 

Scambi.cee file is now saved in H: drive/ folder "SCAMBICEE". 
You can control if the scambi.cee file generated has no errors. 
To verify the scambi.cee file go to Menu Web/ "verifica scambi.cee: 

Select the folder where the file has been saved: 

Click "Apri" 
Confirm if no errors have been detected: 

Click "Esci". 
Rename scambi.cee file according to the below template: 
 
Save with company code denomination (not company code number), write "GS" to identify that you are saving Goods and Services data and insert the declaration month and year. Keep the format SCAMBI.cee. 
Since you saved already all the documents detailed in previous points a), b) and c), you can send them to our external consultant Maurizio Fedi (mauriziof@echiappe.it). Follow the below example (subject and text considered in the email). 
Check the last email sent in the month before for the italian company you are sending, to identify all the email receivers for each company. 

Send the emails with the 3 attachments to mauriziof@echiappe.it and put in copy RtR (change RtR) Country Team Leader, the respective Operator Specialists and our local contacts:

• For company 5835/0279/5881: 
  • paola.gagianesi@solvay.com 
  • tiziana.macchia@solvay.com
  • lorenzo.roncoroni@solvay.com

• For company 0270 and 0005/6070:
  • silvia.menegazzi@solvay.com
  • lisa.carocci@solvay.com
  • giampiero.paperini@solvay.com

• For company 5894:
  • giampiero.paperini@solvay.com
  • christian.camarra@solvay.com

• For company 5711:
  • nicoletta.costantini@solvay.com

After sending this email to Maurizio Fedi, expect his reply. He sends back the Covers for each company with the official Protocol Number.
Archive the Official Cover in PDF format that he sends back, inside company code folder and take note of Protocol Number.
Save Protocol Numbers (one for Sales and another for Purchases) for each company in file "Intrastat – Protocol Number_YYYY" stored in RtR BO Italy Timetable (change RtR BO): 
 (update and link it)

3.4.2.9. I create a backup per company and a total backup

3.4.2.9.1. I create a backup per company

Intraweb data can be archived and saved separately, by company code. 
To do it, go to Menu "Utilita'"/"Archivi-Manutenzione"/"Backup"/"Soggetto Obbligato":

Select the desired company and click "Ok": 

Save it like the example below (with company code designation and backup data): 

3.4.2.9.2. I create a total backup

It is mandatory to SAVE a MONTHLY TOTAL BACKUP when the Intrastat declarations are completed. 
In order to activate this function we should select from the Menu "Utilita'"/"Archivi-Manutenzione"/"Backup"/"Totale": 

We should save it in a directory and name it properly.
Pay attention, we can restore data only with the right file name (not for instance when the name has this digits at the end: "_1"; it will not work).

3.4.2.10. I perform corrections on previous declarations submitted

It can happen that you want to add one or more lines in a declaration already submitted and sent to our external consultant. 
We can distinguish between two main types of correction. 
If you are still in time, before the 25th day of the month, you can create another "Elenco", pay attention at the number given by the system and write it down, and then declare it filling the only line missing. The earlier you will find these errors and communicate them to Fedi, the better it is. 
Potentially in Italy you can create and submit as many "Elenco" as the invoices are on time, the only problem is to track all the information sent to the government. Ideally we submit only one declaration per month for each company. 
If you want to declare one item after the deadline (25th day of the month), you have to consider one important element: the presence of transactions with this entity (supplier or customer) in the month of the missing invoice or CN.
If there are goods' movements declared with this supplier or customer in the month of the missing document, we just need to add a correction in Section 2 (change the section?) of the current month as we are declaring a CN or an invoice. This because the only constraint we have to insert lines in section two, is the presence of the VAT number of the supplier or customer in the month of the missing line.
If there are no goods' movements in the month of the missing line we have to create a new "Elenco" and declaration with reference to the past. 
In any of these two situations (after the deadline) and before deciding, please contact and share your decision with teammates and RtR FtO (change RtR FtO) Tax Advisor.  

3.5. I perform RCS procedure specificities

Procedure in WP1 follows the same Intrastat Italian rules in as in PF1.
The "Intraweb tool" is also using the same steps as in PF1 (see point 3.4. (confirm the section) of this procedure) 
As we are using different systems, the only change is in the SAP data extraction where in WP1 some transactions are not available and we retrieve in different way.

3.5.1. I extract and analyse the data

3.5.1.1. I extract and upload the service data

For Services we don't have a specific transaction yet in WP1 to retrieve the information as PF1.
We need to go to the VAT transaction to have the Intrastat invoices posted with the Intra tax code.

3.5.1.1.1. I extract the INTRASTAT service purchase

• Go to VAT transaction ZWFA97A and use variant "ITALIA_VEN_CEE"

Change the Posting date period for the month, change the Tax code correspondent and Execute: 

• Fill in the Template file Services-Intrastat Analysis MM.20YY for analysis. (confirm the file)

For Service import we copy the information retrieved with tax code SS (Until column L) and past it in sheet "Service Import for Intraweb" 
Note: Column M & N should not be deleted, contains formulas that will retrieve information in sheet "Service Codes Database"
If you find a new service supplier you need to update the sheet with it. 
Analyze the Credit notes and see if they should be included or not in Intrastat declaration depending on the situation.

3.5.1.1.2. I extract the INTRASTAT service sales

For Service Export the step is the same as described above.

• Go to transaction ZWFA97A and use variant "ITALIA_VEN_CEE", change the posting period and select Tax code 8D

Note: We usually don't have many invoices and customers are recurrent. Depending on the type of service we use the following Commodities Codes:

3.5.1.1.3. I perform the service data analysis

• Copy the information to sheet: "Services Export for Intraweb" and analyse the credit notes and if some document should be excluded from Intrastat declaration.

Same procedure as PF1 (see point 3.3. (please confirm the point) of procedure).

3.5.1.2. I extract and upload the goods data

3.5.1.2.1. I extract the INTRASTAT goods purchase

Template 8090-Intrastat Import analysis MM.20YY  will be used to analyze the information.

1) Go to VAT transaction ZWFA97A select import variant "ITALIA_ACQ_CEE"

Purchase Goods Tax Code: SN

2) Copy the information to sheet "ZWFA97A"

ZWFA97A retrieves the VAT information (it will pick up the FI side – invoices posted with goods import tax code)

3) Go to Transaction VEFU select import variant "IT_INTRA_8090I" and copy the Information to sheet "VEFU"

VEFU allow us to add or delete information and to correct intrastat errors.

4) Go to Transaction VE08, variant: "IT-8090-IMP" change Reporting Month and Reporting year and copy the information to sheet "VE08"

 
VE08 retrieves intrastat information (it will pick up the MM side – Good Receipts/Purchase Orders posted with goods import tax code)
See step 3.3.2.2. of this procedure (confirm the point)

5) Go to Transaction Z1F_CHECK_INTRASTAT, variant: "IT-INTRA8090-I" change Reporting Month and Reporting year and copy the information to sheet "Z1F_CHECK_INTRASTAT"

3.5.1.2.2. I extract the INTRASTAT goods sales

Template 8090-Intrastat Export analysis MM.20YY  will be used to analyze the information.

1) Go to VAT transaction ZWFA97A select import variant "ITALIA_VEN_CEE"

Sales Goods Tax Code: 1H

2) Copy the information to sheet "ZWFA97A"

ZWFA97A retrieves the VAT information (it will pick up the FI side – invoices posted with goods import tax code)

3) Go to Transaction VEFU select import variant "IT_INTRA_8090E" and copy the Information to sheet "VEFU"

VEFU allow us to add or delete information and to correct intrastat errors.

4) Go to Transaction VE08, variant: "IT-8090-EXP" change Reporting Month and Reporting year and copy the information to sheet "VE08"

 
VE08 retrieves intrastat information (it will pick up the MM side – Good Receipts/Purchase Orders posted with goods import tax code)
See step 3.3.2.2. (confirm the section) of this procedure

5) Go to Transaction Z1F_CHECK_INTRASTAT, variant: "IT-INTRA8090-E" change Reporting Month and Reporting year and copy the information to sheet "Z1F_CHECK_INTRASTAT"

3.5.1.2.3. I perform the goods data analysis

Z1F_CHECK_INTRASTAT retrieves the information between FI and MM (VAT transaction against VE08) 
We use this to perform the Import data analysis before Intraweb upload.
We check 1st the items with Errors: 

E.g.

At the end the information in VE08 should be the same as the information in VAT where the difference should be justified and declared why is not to be or to be included.
See step 3.3.2.2. (confirm the section) of this procedure explaining different types of situations.

3.5.2. I upload the data in Intraweb

3.5.2.1. I upload the data for goods in Intraweb

Step 3.4.2.4. (confirm the section) for Goods - procedure for Goods preparation and upload is the same.

3.5.2.2. I upload the data for services in Intraweb

As we don't have automatic transaction that retrieves the Intrastat in txt or excel format we use the information from the VAT transaction.

1. Service Import

• • Attach to this procedure you can find a template for Service import excel upload.

2. Service Export

• • Attach to this procedure you can find a template for Service export excel upload.

The upload in Intraweb is performed as PF1 (procedure step 3.4.2.4.) (confirm the section)

3.6. Persons of Contact (please change this title according to the methodology: I "do" something... e.g. I inform/send...)

• Valerio Vinter for Tax Code issues/doubts 
• Ana Almeida & Marta Almeida from WW Data & Analysis Team for Purchase Orders missing relevant data 
• Maurizio Fedi for Intraweb constraints 
• Local Accountants in case of company specificities 

End of document.