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 : 

  3. Fill in all fields as described above

  4. Once the procedure is completed, ensure it is published by using 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

financial_accounting

country_accounting

service_invoicing

ERP

4. Remove the icon(s) when not applicable


Frequency

Monthly


  

References

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



Forms

7. Insert the links accordingly and change the link text with the OP name


Attachments



Previous OP << >> Next OP





1. Objective and Scope

1.1. Objective of this Operation

The objective of this document is to explain the main concepts behind the Residual Sodium Chemicals (RSC/PSR) invoicing.

We need to invoice the PSR treatment and transport in the 1st day of the month. This process has to be completed until 12H Italian time because the majority of the customers are public institutions owned by the state, very burocratic and they need to receive the invoice for verification and payment early in the month.

Known in italian as "PSR - Prodotti Sodici Residui" this procedure exists to ensure a good understanding of the different contracts and how to calculate the amounts to be invoiced every month end. 

1.2. Scope

This procedure applies to Italian company 0270 Solvay Chimica Italia. 

2. Definitions

See Finance Glossary:

  • PSR - Prodotti Sodici Residui in italian.

  • RSC - Residual Sodium Chemicals in English.

3. Tasks description

3.1. Responsibilities

 - Local team > Luca Pelagatti / Marco Sardi / Luca del Rio responsible for the sharing of the contracts and the activity of the month to be invoiced.

 - Accounting Platform > Will perform the analysis, update and calculation of the monthly invoicing.

 - SU FAC Interco > Will perform the invoicing whenever necessary ensuring all master data creation, share it with the customer and submit the electronic invoice. 

3.2. I understand what is PSR treatment and transport Invoicing 

"Solval®  operates the first recycling plant for RSCs from waste-to-energy facilities. The facility is in Rosignano and near Solvay’s legacy soda ash plant in Italy, which uses the purified brine produced by Solval as raw material to produce soda ash."

For more information about this market access the following link: https://www.solvairsolutions.com/en/who-we-are/services/recycling-services

This plant is part of SOLVAY CHIMICA and is responsible to treat and transport the waste on site for which we charge a fee to the costumers for the service and has two production lines:

  1. One more general where the residues are treated for customers:

2. Another line dedicated to a specific customer that has two plants but only one is active:


We receive the deliveries of waste followed with a certificate, with all the information mandatory to the transport like delivery date and time, code, quantity and final destination and if there is an intermediate. Sometimes we are also intermediates.

For each customer there is an agreement, these agreements are revised and re-negotiated not only when they expire but from time to time changes occur during the year that will be duly communicated. The contracts have different conditions and we need to pay attention to the different details (like is transport price, should we apply a discount, penalties, text to apply in the invoices...).

You will find the resume in the following table: 

    

     \\ITROSFS01\Groups\Solval\IMPIANTO\PSR DA FATTURARE X MESE\tabelle prezzi\ CONTRATTI_PSR_2012-21

Another important remark is about the transport, we have two types of transport, one where we just pick up the residues to the costumers and another combined when we use the same truck to deliver the final product and pick up the residues. The result is two different prices.

You will find the resume in the file “Ripartizione costi Trasporto PSR” (look for the sheet with the most updated figures)

     

      \\ITROSFS01\Groups\Solval\IMPIANTO\PSR DA FATTURARE X MESE\tabelle prezzi\ Ripartizione costi Trasporto PSR

How do you know the prices to apply in the monthly invoicing?

You will receive from the plant this information, a resume file with activity of the month. In this case each "Formulario" represents one trip with reference to the treatment “1ª fascia” or “2ª fascia” and transport “Combinato” or Espresso”.

To determine the Transport amount we need to multiply the number of trips, each "Formulario" by the price agreed with the costumer and present also in the virtual folder.

There is one last step…

As the plant has two main business, the residues business and the sale of sodium bicarbonate we split the price in two parts, one part is charged to the sodium bicarbonate business another part to SOLVAL business (you can take the example below: column K and L and with the sum of both we will obtain column H). This split is useful to reverse the benefit of this combined transport to the Solval Business every end of the month (reference TPT CARS).

File location: \\ITROSFS01\Groups\Solval\IMPIANTO\PSR DA FATTURARE X MESE\tabelle prezzi| Ripartizione costi Trasporto PSR - sheet Tabella Prezzi Gen2018

For this we need to calculate the contribution, for example, customer IREN – TRM Torino we have applied a price of 985,15 EUR for combined transport; for the sodium bicarbonate business we are charging 559,45 EUR (column K) and Solval is paying 425,67 EUR (column L). At the end of the month for each transport, the sodium bicarbonate business will give to Solval the difference between the normal transport of only “BICAR espresso” (column I) and BICAR combined price “BICAR Combinato” (column K).

This difference is showed in the resume file sheet TRANSPORT where we already did the highlight of amount calculated - 183,15 for each delivery.

 

Whenever there is an update, a new sheet is add with the most recent calculations like below:


To ensure you are fully autonomous and that you have access to all the information please see the documentation available in shared drive \\ITROSFS01\Groups\Solval\IMPIANTO:

  • Select folder PSR DA FATTURARE X MESE\tabelle prezzi and inside you will find two files “CONTRATTI_PSR_2012-21” with the detail about all contracts and “Ripartizione costi Trasporto PSR” with the detail about the transport.

  • Select folder Stima_PSR_Cake_Salamoia, then folder Linea 1 file “DR04-YYYY PI” and Linea 2 file “DR04-YYL2” to check all the details of the treatment/transport that occurred during the month for the two production lines;

  • Select folder Intermediazione PSR, then select file “Intermediazione” to see the details.

3.3. I prepare the information

To facilitate the work and the calculations, we have compiled all the information in one single file that serves as the base for the invoices preparation. 

It is compose by:

  • INSTRUCTIONS to support the checks and the invoices to be issued;

  • DATABASE composed by general information with the location of the files and the customer data (to be updated whenever we have changes);

  • RESUME of the invoicing of the month (automated to have an overview of the invoicing of the month);

  • ZZF_POSTING_FILE with the posting template and specifications to post the invoices;

  • TRANSPORT: Exact copy of the file with the prices to apply available \\ITROSFS01\Groups\Solval\IMPIANTO\PSR DA FATTURARE X MESE\tabelle prezzi\ Ripartizione costi Trasporto PSR

  • PSR Contabilità: The information to be filled here is coming from Marco Sardi’s file sent on D1 early in the morning where we have the information about the form number (column formulario num.); the quantities (column KG) to be applied divided by 1000 and the type of treatment 1° fascia or 2° fascia (column % Insolubili).

To complement you have also available in a different file all the details about the transport. Select folder Stima_PSR_Cake_Salamoia, then folder Linea 1 file “DR04-YYYY PI” and Linea 2 file “DR04-YYL2” (in very specific cases you will have to check the information in this file to determine the price to apply in 2ª fascia).

  • PIGLIACELLI+VACCARI: Information received from Luca del Rio file sent on D1, use file named PIGLIACELLI and VACCARI with the number and type of transports that occurred in the month (to double check spelling in column E);

 

The "Formulario num." represents the number which is associated to the transport and we also have the information about the type of transport (Combinato is a 2 way trip Espresso is only one way trip, and the cost are different as the previous agreement setup).

  • One sheet for each customer taking in consideration the different specifications to apply for each costumer and the details to be included in the invoice: AMBIENTHESIS / A2A / CHIMET / HERA / ACSM AGAM / IREN / MARANGONI.

          See example for AMBIENTHESIS:

          

         

         


3.4. I fill the central file 

3.4.1. I fill the central file - Actions before D1

Before month end we must ensure that all relevant information has the most updated figures meaning that, we must ensure pricing to apply to each customer is according to the agreement in place as well as the transport price and the texts to apply in the invoice.

Every time the agreements are renew or changed, you will receive an alert from Luca Pelagatti. As you can see in the example below, there is always clear reference to the customer and what changes in the contracts, so you can go to the dedicated sheet of the customer and update it accordingly:

3.4.2. I fill the central file - Actions at D1


At D1 the source of information is:


  - Marco Sardi send the “Nuovo File Solval Transporti PSR” email “Tabella arrivi PSR mese MMMM YYYY”;

  - Luca del Rio send the "Vaccari"; “Pigliacelli” and “Pigliacelli Conto Dedicato” with the details of the transport;

  - Luca Pelagatti is sending the “Certificates of Analysis” to be attached to the invoices issued. He is also the final validator before sending the invoices to the customers (by email and SdI (Italy Sistema di Interscambio) real-time e-invoices.).


Open the files:

 1. "Nuovo File Solval Transporti PSR > Contabilitá" and copy to excel template sheet "PSR Contabilità";

 2. "Vaccari" and copy to excel template sheet "PIGLIACELLI+VACCARI" only the resume table.

 3. "Pigliacelli" and copy to excel template sheet "PIGLIACELLI+VACCARI" only the resume table.


3.4.2.1. I fill the central file - AMBIENTHESIS

Costumer AMBIENTHESIS invoicing is based on the current activity of the month. There is only a check to the total tons, if we reach the 1000 we should contact Luca to understand if new prices should be applied. 

With all the prices updated, to perform the calculations of the activity of the month (treatment and transport) you should:

 - Copy the formulario nr in column "DESCRIPTION - PSR Contabilità";

 - Copy from file DR04-20YY PI row 10 the reference number associated to each formulario.

Once the information is complete, you will see that calculations are automatic (columns in grey) and you can double check to ensure correctness and on top, the accounting scheme is correct and the text to include in the invoice is complete with all the formularios and details required for the costumer invoicing.

These are important because they are the details you will copy to the posting file long text:


3.4.2.2. I fill the central file - A2A AMBIENTE - Milano / Bergamo and ACSM AGAM


Same methodology as explained for costumer AMBIENTHESIS although for this costumer there are additional conditions to confirm and invoice when applicable: 

With all the prices updated, to perform the calculations of the activity of the month (treatment and transport) you should:

 - Copy the formulario nr in column "DESCRIPTION - PSR Contabilità";

 - Copy from file DR04-20YY PI row 10 the reference number associated to each formulario.

 - Copy from file DR04-20YY PI row 16 the % associated to each formulario.


Once the information is complete, you will see that calculations are automatic (columns in grey) and you can double check to ensure correctness and on top, the accounting scheme is correct and the text to include in the invoice is complete with all the formularios and details required for the costumer invoicing. The text in the invoice has to be in conformity with the requirements indicated.


EXTRA PRICE - % Insoluble

A2A Group is composed by 3 production plants A2A Milano / A2A Bergamo and ACSM-AGAM Como. Every Production Plant has its own Insoluble Limit:

A2A Milano: 12%

A2A Bergamo: 17 %

ACSM-AGAM Como: 12%

In case the PSR in the truck exceeds the above-mentioned limits, a 5€/ton extra price will be charged for each % point (rounded down).

Take as e.g.:

Truck from Milano= 27,3 tons;
Insoluble = 14,6% (rounded down: 14%)
Price = 177€/ton + (5€/ton x (14-12)) = 187€/ton
Total for the Truck: 187€/ton x 27,3ton = 5.105,10 €


In practise you will find in "PSR Contabilitá" the reference to 2º FASCIA, afterwards we look into file "DR04-20YY PI" and look for the formulario nr and retrieve from the file the Insol H2O %  (available in column 16 of the file).


ESPRESSO Extra Cost

In case we have Espresso Transport a 160€ extra cost will be charged after the 1st 20 Espresso transports. This means that for A2A Group (in total, for all the 3 production plants), the first 20 Espressos during the contract year (1st Oct - 30th Sep) are for free.

In practise you will have to maintain a cumulated view of all transports "Espresso" of A2A and ACSM-AGAM that are shared every month and invoice the 21st Espresso that occur in the year.


The invoice has to contain the following text:

Forfait Trasporto Espresso
n° Formulario Prezzo
131155 160,00 €
131175 160,00 €


PARTIAL LOAD Penalty

The Partial Load Penalty is applied in addition to the normal price for the service in case of PSR load < 20ton. The penalty to apply is 30€/ton.

The penalty is calculated on the difference between the weigh of the PSR and the full load, i.e. 25ton. 

Take the following as example:

      In case we receive a truck with only 18 ton.

1) on the invoice we create a line for the service cost as usual: 18ton*177€/ton= 3.186€
2) in addition to that, on the invoice we create a further line for the Partial Load Penalty: (25ton-18ton)*30€/ton= 210€

The invoice has to contain the following text:

Indennizzo per carico parziale
DESCRIZIONE QT PREZZO IMPORTO
n°formulatio ton EUR/ton
131174 7,00 € 30,00 € 210,00


3.4.2.3. I fill the central file - HERAMBIENTE - Coriano/Ferrara/Modena/Forli


Same methodology as explained for costumer AMBIENTHESIS although for this costumer there are additional conditions to confirm and invoice when applicable: 


EXTRA PRICE - % Insoluble

For each production plants Coriano/Ferrara//Modena and Forli we need to apply the Insoluble Limit of:

               HERAMBIENTE Coriano: 5 %

HERAMBIENTE Ferrara/Modena/Forli: 12 %


In case the PSR in the truck exceeds the above-mentioned limits, a 3,5€/ton extra price will be charged for each % point (rounded down).


In practise you will find in "PSR Contabilitá" the reference to 2º FASCIA, afterwards we look into file "DR04-20YY PI" and look for the formulario nr and retrieve from the file the Insol H2O %  (available in row 16 of the file).


3.4.2.4. I fill the central file - ACSM AGAM - Como


Same methodology as explained for costumer A2A AMBIENTE. Pay attention to the details as explained previously. 


3.4.2.5. I fill the central file - TRM/IREN Group 


Same methodology as explained for costumer A2A AMBIENTE.  Pay attention to the details as explained:


PRICE to apply (transport included in price):
  - for all the plants the price to apply for each treatment is 183€/ton.


In case of TRM Torino exceeds 7500ton from Gen to Dec the price becomes 185€/ton for all the plants. The year after the price will be back at 183€/ton until TRM exceeds 7500ton again.


ESPRESSO Extra Cost

For IREN Group (in total, for all the 3 Production Plants), the first 20 Espressos during the Year (1st Gen - 31st Dec) are for free.

In case of Espresso Transport a 160€ extra cost will be charged in a dedicated line of the invoice.

The text has to be clear and contain:

Forfait Trasporto Espresso
n° Formulario Prezzo
131155 160,00 €
131175 160,00 €


UPDATE 05.2021


UPDATE 10.2021


Partial Load Penalty

The Partial Load Penalty is applied in addition to the normal price for the service in case of PSR load < 20ton. The penalty to apply is 30€/ton.

The penalty is calculated on the difference between the weigh of the PSR and the full load, i.e. 25ton. 

Take the following as example:

      In case we receive a truck with only 18 ton.

1) on the invoice we create a line for the service cost as usual: 18ton*183€/ton= 3294€
2) in addition to that, on the invoice we create a further line for the Partial Load Penalty: (25ton-18ton)*30€/ton= 210€


The invoice has to contain the following text:

Indennizzo per carico parziale
DESCRIZIONE QT    PREZZO     IMPORTO
n°formulatio      ton    EUR/ton
131174             7,00   € 30,00        € 210,00

3.4.2.6. I fill the central file - MARANGONI


Same methodology as explained for costumer A2A AMBIENTE.




  •  

  •  End of document.