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 




Domain: Country Accounting



Responsibility area: N/A


Table of contents 

By default the table of contents displays Heading 1 & Heading 2 (other levels can be added)



Scope

3. Remove the icon when not applicable


ERP

4. Remove the icon(s) when not applicable


Frequency

5. Remove the icon(s) when not applicable

 

References

6. Add the link to SAP transaction(s) (when it exists)


Forms

8090 – ISTAT Monthly Declaration


Attachments

G-Drive for materials

Banks and other accesses

ISTAT portal



To be filled! << >> To be filled!




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 operating procedure (OP) applies to RCS Italian Company 8090.

2. Definitions

See Finance Glossary:

3. Tasks description

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

3.1. Extract SAP Information

3.1.1. KE30 Transaction

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. 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. 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.
Tabella Paesi = Area where the countries are (Italy, UE or extra UE)


  • 3 to prepare the information to declare:

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).



3rd column formula "=VLOOKUP(A313;anagrafia!A(big grin);4;FALSE)" is retrieving the country from sheet "anagrafia" where you have the full list of customers, update, if necessary.
4th 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. Report the Figures in ISTAT Site

Insert the Figures in the Following Link: 

https://imprese.istat.it/
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. PPI_D - Rilevazione dei prezzi alla produzione dei prodotti industriali

3.3.1. KE30 Retrieve

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


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


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. Report the Figures in ISTAT Site

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.