1. Objective and Scope

1..1 Objective of this Operation

The purpose of this document is to explain how to perform the monthly ISTAT declaration for company 8090 – Solvay Solutions Italy. 
The Italian National Institute for Statistics (ISTAT) is the main supplier of official statistical information in Italy. It collects and produces information on Italian economy and society and made it available for study and decision-making purpose. 
ISTAT currently produces the monthly survey of sales and industrial orders involving about 8,000 companies active in the sectors of mining and manufacturing. Solvay Solutions Italia SpA is one of the firms from which is requested a monthly update regarding the revenue of the company.
The monthly survey "Indagine fatturato e ordinativi" refers to internal/external revenue, where "internal" means in Italy and "external" out of Italy, to be divided in UE and extra UE.

1.2. Scope

This procedure applies to RCS Italian Company 8090.

2. Definitions

See Finance Glossary:

• ISTAT
• RCS

3. Tasks description

The procedure should be done by Operations Team every month until D10.

3.1. I extract the SAP information

3.1.1. I run the SAP transaction KE30

In order to extract the past month revenue figures information we go to transaction KE30 and choose "Operating Concern: Z006".

1) Choose report ZZZ-SOLV00
and execute.

2) Select variant "ISTAT 8090"

• • Update the year and period
  • Make sure the option "Object List (more than one lead column) is active

and execute.

3.1.2. I prepare the KE30 report

Once the result is displayed change the layout to /ISTAT 8090 as it is selecting only the columns that are necessary for this analysis plus some information about the shipping country and text to highlight the unassigned items.

This will be the result at this point:

At the End Export to Excel and save it.

List Save Local File Spreadsheet

3.1.3. I prepare the EXCEL template

The Template has 5 sheets:

• 2 with the full database of customers and related countries and region:
  
  
  • Anagrafia = List of customers with their country (simple extraction of report S_ALR_87012180), update, whenever, a new partner appear.
  • TabellaPaesi = Area where the countries are (Italy, UE or extra UE)

• 3 to prepare the information to declare:

1. • KE30 Report = SAP Data
   • KE30 Final = KE30 Total amounts by Region
   • Out KE30 Accs + Amount to Declare = Amounts to consider that are not in KE30

• Sheet KE30 report

1) Open the file with the extraction from KE30 and perform a subtotal by customer summing the columns B00 Net Sales Period, B20 Add N.Sales Int Period, B10 Net Sales Corr. Period.
The result has to be similar to:

2) Open the support excel file and copy the information to sheet – KE30 Report (columns A to D).

Note that column "Total Invoiced /FATTURATO" is just the sum the 3 previous columns.

• Sheet KE30 Final

This sheet is a copy of the previous data, the Customer Code and the Total Invoiced/FATTURATO.
Then we will need to add the Country of the customer and determine the Country code (if it's Italian, European or out of Europe).

3^rd column formula "=VLOOKUP(A313;anagrafia!A;4;FALSE)" is retrieving the country from sheet "anagrafia" where you have the full list of customers, update, if necessary.
4^th column formula "=VLOOKUP(C313;'tabella paesi'!A:C;3;FALSE)" is retrieving the necessary country code from sheet "tabella paesi".

Steps to ensure:

1) Check that the total amount of the extraction is according KE30;

2) When the KE30 report is extracted and there is a line with Not Assigned we need to search for the corresponding Customer/s.

In SAP we should go to the normal view of the KE30 report selecting "Classic drilldown report", select the Not assigned costumers and then select GoTo – Line items:

• • • Search for the sender cost center and go to KSB1 to see the details.
    • Then select the customer number in column: Offsetting Acct
      

• Add this Information in the file by Customer Number

1) Confirm that there are no errors in the formulas.

If you have missing information for the customers you will have to extract from see in FD03 – customer master data the country of the customer and update sheet "anagrafia".

2) The final result should be sum of Country Code and for that you just need to refresh the pivot table.

• Sheet Out KE30 Accs + Amount to Declare

We have also to consider the Revenue that is not included in KE30.
We have to do an extraction on the general account 98100400 and 98100450 for the month treated.

• • • Enter in FBL3N transaction and select the period of the previous month and he accounts 98100400 and 98100450
    • Insert column: "Trading Partner" in the Variant
    • Subtotal by Trading partner
    • Copy this information to the Excel Sheet

NOTE: Important to retrieve the trading partner and as a reference service invoice is always charged to companies 0001 – 0279 – 4274 – 75233 – 0270.
Afterwards we need to work the data:

• The geographical area:
  • FERALCO + 0279 + 0270 = Italy (Internal)
  • 4274 + 0001 = EU (External)
  • 75233 =Out of EU (External)

Sum these amounts in column "Out of KE30".

• Last table will compile all the information by internal, external and Europe you just need to confirm that in amount to be declared in ISTAT is congruent with the amounts calculated previously.

The amount in Orange should be the total amount / 1000

3.2. I report the figures in ISTAT Website

Insert the Figures in the Following Link:

• ISTAT portal

Insert:

• "Codice Utente"
• Password

Note: Password and "Codice Utente" available in Google doc "BANKS AND OTHER ACCESSES"

Go to "Rilevazioni"

After choose option "FATT" of the year.

Click again on the model you need to fulfill:

At the end you have to fulfill the figures (remember that they are expressed in k€!) using data retrieved during the previous steps:

NOTE: The field related to "Orders" ("ordinativi/ordini " in Italian) is not mandatory so don't fill it.

• After you select on "Invia" the model is submitted so you should save the model (pdf version) and the related transmission receipt (pdf version).

• Send the PDF files retrieved from the web and Excel Template to the CAM of the company.

3.3. I submit the PPI_D - Rilevazione dei prezzi alla produzione dei prodotti industriali (please confirm this title)

3.3.1. I retrieve information from KE30

On a Monthly basis we need to declare to ISTAT the Average price for 3 products (selected randomly).

Go To KE30, and select ZZZ-SOLV00 report.

Insert the period and the company code 8090

Perform the dynamic selection:

• Ship-to-party: Only IT
• Commercial Product: 90004493, 90004501 & 90004507

Here you should take the Quantity Invoiced and the Average Price.

Note: the materials that we should select are in G-drive file, link:

(give a name to the file and link it)   G-Drive for materials 

https://docs.google.com/spreadsheets/d/1s02g5zJhqCd_v8G2MMgx9NMVgPE3eiIp5fi0St_IpWo/edit?ts=5b46ff31#gid=1674110441

You need to fill in the google drive and ISTAT portal with the information retrieved from KE30.

3.3.2. I report the figures in ISTAT Website

1) Follow step 4 until “Rilevazioni”.

2) Select PPI_D on the correspondent year:

3) Select the month you want to report, execute and select “Entra”

4) Enter and choose: “Procedi alla Relivazione”

The following window will appear:

5) Select Inserimento Dati

6) Insert the average price on the following field:

7) Save and Exit

End of document.