1. Objective and Scope

1.1. Objective of this Operation

The objective of this procedure is to prepare and book the monthly accruals and calculate actual tax amount of coal.   

The tax on coal is calculated by € of material consumption which is measured in GJ (Giga Julios – unit measure of energy). Due to this fact it is necessary to apply a conversion factor.

When each boat arrives (usually from Russia) to the port, the coal is analised and the calorific power of the coal is measured. When the quantities are low most probably the coal was transported by truck but is rare.

This coal is used to generate:

• steam for Sodium Carbonate production
• electricity
  • self consumption
  • sold to external parties or rarely self consumed in emergency situations 

1.2. Scope

This procedure applies to company 0245 Solvay Quimica SL.

2. Definitions

Definitions should be added in the Finance Glossary - Add definition and link it to respective Letter in Finance Glossary 

See Finance Glossary:

• ...

3. Tasks description

Part 1 - Monthly Accrual regarding Tax on Coal - Recurrent ES0245T144, performed monthly. 

Part 2 – Calculate actual tax amount of coal, has to be done until 15^th day and quarterly. 

Select the level of heading in the "Paragraph" option.

3.1. I prepare and book the monthly accruals

This task should be performed after the reception of the email from the plant, from david.polanco@solvay.com, with subject: “IMPUESTO HULLA MM/YYYY”. This e-mail send us the prevision in tons of the consumption of coal.

1)     It is necessary to fill this information in file in google docs: 

Note: Only yellow cells are to be filled. Tab YYYY in the respective month in field regarding “toneladas consumo”.

2) Go to transaction FBL3N variant /TAX_ON_COAL, layout TAX_ON_COAL and update period to month n-1, to know the amount to fill in “Ton. compradas con impto”, add quantity and material 103995: 

Look to each invoice to search for any national purchase of coal to add. If there are any fill in “Ton. compradas con impto”: 

3)     To fill the information in cell “Factor conversion”:

Go to BW: queue iMEP – Energy Interface - BW_WBK_CO_0001

 Fill out the prompt with the following information:

The amount of “Houille” in GJ and TO, by doing QTD GJ/ QTD TO we get the amount to fill in “Factor conversion”.

On folder Cons.Quant. It will be able to take the necessary information:

4)     After, fill the recurrent ES0245T144 with these two values:

3.1.1. I perform the recurrent ES0245T144

Fill the posting file with these two values: 

3.2. I Calculate actual tax amount of coal 

This step consists in calculating the tax with the percentages of last year provided by the auditors in the first trimester. 

1)     Open the following file:

A)    To check the amount to consider in “Ton. compradas con impto” (purchases with tax):

Go to transaction FBL3N variant /TAX_ON_COAL, layout TAX_ON_COAL and update period to month n-1, to know the amount to fill in “Ton. compradas con impto”, add quantity and material 103995: 

Note: update to quartely period n-1 

It is possible that we have purchases to spanish vendors. These should also be included in the tax calculation. Look for the image of each invoice (related to the WE documents displayed) to see if there is any nacional purchase of coal to add.

(example in tab “Tn con impuesto 1o trimestre 2019” in the support file)

B)    Real quantities in yellow copied from BW support file “0245 Tax Coal Support File” Tab “Query”  in the link below:

Example for March 2020:

After full filing the yellow cells post recurrent document with reference ES0245T149, as mentioned in file Impuesto hulla tab “Pago Xo  Trimestre YYYY” (X=Trimestre; YYYY=Year).

Make sure the amount calculated in the file equals the open amount in account 2450000000:

3.3. I Regularize the previous year with the new percentages provided by the auditors (trimestral)

Example of regularization of year 2018 in 2019:

1)     Columns from A to D need to be fulfilled based on file Impuesto hulla;

2)     Consumo Y-1 Electricidad and Consumo Y-1 Autoconsumo need to be fulfilled based on previous year data which is in the same file

Note: 2018 and previous years are stored in a separate folder. See data below regarding year 2018 for a better understanding

Document to be posted based on recurrent posting with referrence ES0245T149:

Amounts from file 595 - 583 -560 - SQ 0245:

Send the necessary information to E&Y

Every trimester, send the file below to E&Y (Anna.LozanoQuesada@es.ey.com>, Joel.Sanas.Del.Pino@es.ey.com ) before day 15:

It is important to monitor the account 2450000000 to ensure that the assignments are correct and previous months cleared.

End of document.