1. Objective and Scope

1.1 Objective of this Operation

The purpose of this document is to explain how to prepare one of the monthly ISTAT declarations.
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 WP1 company 8090 and PF1 company 5835.

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 for 8090

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) Fill:

• • 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

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

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:

• 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

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.

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

Inform CAM and Accounting platform of the amounts reported.

4. I extract the SAP information for 5835

1. Open report GR55 Z4C1 for the previous period and expand ZFC-R10000-NPCA.




2. At the same time, open transaction FBL3N inserting variant ISTAT:

    Confirm that all the accounts presented in GR55 Z4C1 under ZFC-R10000-NPCA plus the account 7040000000 are selected:

   Confirm that you select all items from previous period and run the transaction. 

3. Open transaction KE30, report ZZZ-SOLV00 and select only previous period.

Confirm the total value to report in ISTAT by checking the total amount retrieved in FBL3N has to be the same as in KE30 Market product sales without VVC42 Sales royalty revenues. In case of delta (as in the example below) investigate the origin and just highlight it in the file.

4. If the values are the same go back and extract the details from FBL3N to sheet "FBL3N Extraction" of the template from column B to Column M.

5. Go to sheet resume you will see that the table is dynamic and the formulas fixed and need to be reviewed:

5.1.  Refresh the pivot table;

5.2. Review the amounts to report as Nazionali / Intra CEE / Extra CEE. These formulas are fized and we just need to the number of lines of the pivot table as: 

5.2.1  Nazionali is the sum of tax codes O5 / Q1 / O8 

5.2.2 Intra CEE is composed by the "Grand total - amount calculated Nazionali - Tax code 2B"

5.2.3 Extra CEE is composed by the sum of  "Grand total GBP + Grand total USD + Grand total JPY + Tax code 2B"

5.2.4 Cell D34 CONTROL has to be zero when we finish the report (the check is done by controlling the total amount calculated in TOTALE minus the total amount extracted from FBL3N.

6. As soon as you finish all controls send the report prepared to Simona Catalano that will submit the declaration in ISTAT website.

5. Points of Contact

     - 8090 CAM Matteo Marengo

     - 5835 Controller Simona Catalano

End of document.