1. Objective and Scope

1.1 Objective of this Operation

This procedure explains how to handle the personal costs in Spain once HR system has been moved to EuHreka. 
Based on the data in EuHreka, on a monthly basis a payroll posting by company is generated via ALE from HR SAP systems (EuHreka) to FI SAP system (ERP or SAPHEGA). This posting includes the payroll expenses paid but also the smoothing expenses of other payroll payments done in a yearly basis (like Extra payment of June and November, end of year premium, bonus …etc.). Additionally, this posting includes also the booking of other expenses related to personnel costs like: pension costs and insurance life premiums.
In this monthly FI posting the expenses are allocated directly to the cost center of the employee with his own primary cost elements. 
This LOP describe the actions to be done on a recurrent basis in order to assess the accuracy of the Financial Statements at company level. These actions are mainly focus on:

• Check if the posting via ALE has been posted;
• Split the information posted by the Euhreka document in different assignments, to allow a better follow up of the personal cost operations and provisions;
• Check that the amounts of balance sheet accounts related to provisions in FI are equal with the amounts from Euhreka system;
• Clearing and checking the B/S payroll account, 2455000000 to follow up the payments done and the payroll posting amount.

1.2 Scope

This OP is only valid for all Spanish companies (…).

2. Definitions

See Finance Glossary:

• ERP
• FI
• HR (link to Finance Glossary)

3. Tasks description

3.1. Personal Costs operations

On the 25^th of each month, 3S (change 3S) will receive from Local Finance and through Salesforce (change Salesforce) some files with the HR details. These files will allow the consistency check between HR and FI. 
The files naming follow the same criteria each month, the only variable information is the company code, the month and the year the information refers to. This way, the files you may receive for each company and use along the LOP are:

• E1_Final Pay_CCCC_MMYY_Accounting List.XLS
• E1_Final Pay_CCCC_MMYY_Accounting Document.XLS
• E1_Provisions_CCCC_MMYY.XLS
• E1_TOR Withholding_MMYY.XLS
• E1_SQ_MART - Withholding_MMYY.XLS
• E1_DNE Withholding_MMYY.XLS

From time to time it might occur that more files are sent, for example:

• E1_Match Code W_0245 (5696)_0512_Accounting Document.XLS
• E1_Match Code W_0245 (5696)_0512_Accounting List.XLS

Following the example, this means that two postings were done in the company 0245 and to perform the LOP we must add the information of the file "E1_Match Code W_0245 (5696)_0512_Accounting List.XLS" to the list provided in the file "E1_Final Pay_0245_MMYY_Accounting List.XLS" to have the total amounts posted in the period. 
Attached to this LOP is also one excel file "ES PAYROLL_TEMPLATE" (see attachments) that will help 3S (change Salesforce) performing all the steps, calculations and postings required and explained through the LOP (each month you will need to create one file per company

The posting to be done is:

For a better understanding see example below:

• On the "E1_Final Pay_CCCC_MMYY_Accounting List" file we summarized the total amount of that wage types on account 2455003230 – 376.605,06 €. 
  
  
  
  
• The posting document created was the following one: 
  
  
  
  

  Account 2455005501

  
  Due to a voluntary customization of the wage types , in a monthly basis must be checked if there are any amounts to be transferred from the account 6250000000 ( estimation of personnel cost ) to account 6200000000 ( Personnel cost). 
  
  The amounts to be transferred, if any (most of the months won't be anyone), are the ones detailed on the HR Excel File on the account 2455005501 with the wages types:

  
  

  409E	Regul Pagas Extras

  
  

  
  The posting to be done is:

  Company:XXXX
  Posting and document date:31/MM/YY
  Document Type: H1
  	Line 1	Line 2
  Posting Key	"50" (if Wage type amount is >0) or "40" otherwise	"40" (if Wage type amount is >0) or "50" otherwise
  Account	6250000000	6200000000
  Amount	The total amount for those wage types on account 2455005501 showed in the HR Excel File	The total amount for those wage types on account 2455005501 showed in the HR Excel File
  Cost Center	See table by company	See table by company
  Text	Nomina Mes MM	Regularizacion Pagas Finiquito Mes MM

  
  

  Cost centers by company

   

  Company Code	Cost center
  0245 - Solvay Quimica	SQ80000080
  3454 - Solvay Iberica	SO80000080
  5696 - Solvin Spain	HK80000082

  
  

  NOTE: 
  Using the template ES PAYROLL_TEMPLATE this information is being retrieved automatically you just have to confirm that the company code is filled on sheet with the step 2.1.3. and confirm the cost center. 
  

  3.1.5. Check Personal Accruals amounts

  We have to check if the amounts on accounts 245500009, 2455005501 and 2455003230 on FI statements at company level are the same as the ones recorded in EuHreka employee by employee at company level. 
  This check will be done by comparing the HR-Provision Excel File and the detail by assignment of that accounts. 
  3S (change Salesforce) should list the open items of that accounts, summarized by company/account/assignment and compare the amounts in SAP FI with the ones on HR at wage type level, taking into account that the wage type code in HR Provisions Excel file are defined as the first 3 position of the assignment code on SAP postings. 
  
  Detailed operations: 
  1 - We open the HR Provisions Excel file received named "E1_Provisions_CCCC_MMYY" with a format like : 
  
  
  
  Copy this information to sheet "E1_Provisions" of the "ES PAYROLL_TEMPLATE" file. 
  
  2 - Then we need to list the open items for the mentioned accounts at 31/MM/YYYY with the transaction FBL3N using variant ES-CTB02 and layout /ES-CTB01. 
  
  We will obtain a list by company/assignment as exemplified hereafter : 
  
   
  
  With this information you must will fill the table in sheet "Step 2.1.4 – table INPUT from SAP" of the "ES PAYROLL_TEMPLATE" file and we will obtain the comparison as follows: 
  
  
  
  The table is making a comparison between the information sent by HR and the splitting done at account and wage type level. 
  
  Whenever there is a difference 3S should communicate the difference to Local FI by sending this file although it's usual to have differences and there are some checks that can be done before reporting to Local Finance: 
  
  3 - Go to FBL3N and check the assignments - they should follow the exact codification of the file. It's easy to see if there is something wrong "612-BONUS-2012" is not the same as "612-BONUS 2012" 
  
  
  
  4 - Confirm that the assignment 609-CGIQ values are compared with the addition of the values of wage type codes 609A-619A-629A; 6A6-SUPL compared with the addition of 6A6A+ 6A6P and 6I0-IPC compared with the addition of 6I0A+6I0P; 
  
  5 - There are moments where we have amounts reflected in accounting referring to two different years, this happens because we are accruing something that will be paid next year. During the current year the provision assumes the code A, when the year changes and until it's paid assumes the code P thing that may generate some differences. 
  To resume:
  • Wage type finishing with A – concerns to the actual amount of the provision at the current date.
  • Wage type finishing with P – concerns to the cumulated provisions that are accrued and paid one year after the accrual period. 
    
    For a better understanding of the analysis to be done, look to the example for wage type 6V0 - Provision Bonus+ROE: 
    
    
    We have the information that the wage type 6V0P is zero in HR provisions file although in accounting we have a credit balance of 438.429,24. 
    Analyzing the details of the posting done we can see that besides the accounting of the provision for the current month 6V0R there are also other wage types booked. 
    
    
    This means that there was a payment of BONUS + ROE + Rem Variable in March 2012 that concerns to 2011 and besides that there was also calculated a delta between what was accrued and effectively paid. 
    In this specific case the difference highlighted in the table is not real and we just need to change the assignment for those specific lines to reduce the difference: 
    
    
    After this final adjust a small difference remains: 
    
    
    This check must be done on a monthly basis since we have different payment dates for each HR accruals and even among the sites the payments can be different. For that reason is not easy and possible to have these assignments correctly filled when performing the postings through the file "ES PAYROLL_TEMPLATE". 
    

    3.1.6. Clearing of the Payroll payment account

    On D-1, 3S will clear the following documents lines in account 2455000000, considering the conditions below:
    • The lines of the payroll posting document of Month M
    • The payments postings ( document Type G*) in month M
    • Any other documents in that account with assignment : MM or KM 
      
      
      The following rules must be applied:

1. If there is a difference of 5 EURO or less , the documents will be cleared by posting the difference as follows : 

   	0245	3454	5696
   Cost center	SQD725	SOD850	HKD344
   Limit	5,00 €	5,00 €	5,00 €

   
   

   If is…	Counterpart account
   Expense  Income	6470000000  7470000000

   
   

2. If the difference is bigger, the assignment field of the line items should be changed to "MMYY" (where MM is the month and YY the year). 
   
   In this case no clearing should be done 
   

   3.1.7. Miscellaneous Postings

   There are some recurrent operations that must be posted once the payroll has been issued, the amount of this operations are detailed in the HR Payroll Excel file. 
   
   3S must search in that file the amounts related to the following wage types and should create a posting using FB01 as follow:

• • Document type H1;
  • Postings keys 40 ( debit) or 50 (credit ) / 14 (for costumer);
  • Due date: last day of the month;
  • Entry date as posting and document date;

  • And the following fields: 

    
    

    CC	Wage Type	Debit Account	Credit Account	CO Object Acc 6 * or 7*	Text
    5696	3311	2416220000	7440000000	ORD 3559000164	Recuperación Comedor MM
    5696	6542	2416220000	2416220000	-	Recuperación Seguro colectivo vida MM
    5696	7511	2416220000	7440000000	ORD 3559000047	Recuperación Vivienda MM
    5696	7543	2416220000	2456000000	-	Recuperación Seg. Accidentes MM
    5696	7551	2416220000	2456000000		Recuperación Seg. Accidentes MM
    5696	7557	2416220000	2456000000		Recuperación Seg. Accidentes MM
    245	7543	2416220000	2456000000	-	Recuperación Seg. Accidentes Suria MM
    245	3311	2416220000	7440000000	ORD 1059001861	Recuperación Comedor MM
    245	3312+3314	2416220000	7440000000	ORD 2011000204	Recuperación Comedor MM
    245	7511	2416220000	7440000000	ORD 2059000073	Recuperación Vivienda MM
    245	7551	2416220000	7440000000	ORD 2059000010	Recuperación Seguro MM
    245	3134	2416220000	7440000000	ORD 2011009727	Consumo SAL MM
    245	3135	2416220000	2971	'-	Consumo Prod. SOLVAY MM

    
    

    
    NOTE: 
    Using the template ES PAYROLL_TEMPLATE this information is being retrieved automatically you just have to confirm that the company code is filled on sheet with the step 2.1.3 and delete the sheet not required.

    3.1.8. Posting of the reversal of previous year estimation of personal costs

    This step will be done once a year on March, D+15. 
    
    The accrued estimations related to Bonus of year N posted on account 625000000 should be reversed on year N+1 on the account 6251000000 at company level. The posting date of the estimations should be link to the payment of the expenses estimated , but as the amounts are known since the closing of the year N , we will define that the postings will be performed at the same entry date ( March D+15 ): 
    
    1- To prepare the posting we will use the data obtained running the transaction FBL3N, variant ES-CTB02 and layout /ES-CTB01, for open line items in posting period 31/12/Y-1. 
    
    We will obtain a list by company/assignment as : 
    

1. Only for assignments 6VO we will perform a posting as follows :

• Posting Date and Posting Document: see table below (It depends from the assignment)
• Debit Account: 6250000000
• Credit Account: 6251000000
• Cost Center: see table below
• Amount: Total amount at assignment level obtain in previous step

• Text : Reversal Estimation Y-1 + Assignement code 
  
  
  Cost centers by company:

  
  

  Company Code	Cost center
  0245-Solvay Quimica	SQ80000080
  3454-Solvay Iberica	SO80000080
  5696-Hispavic Iberica	HK80000082

  
  

  
  
  Posting and document date:

  
  

  Assignment Code	Posting /Document Date
  6VO***	31/MM/YYYY

  
  

  3.1.9. Miscellaneous Interplant postings

  
  In that step we post some revenues collected from Solvay Iberica employees for which the source of the information are files named "E1_xxx_witholding_MMYY.xls". 
  The files will contain several amounts splitted by wage type. Each wage type will mean a line on the posting and we explain the posting to be done in function of the name of the file. 
  

  3.1.9.1. File E1_TOR_ Witholding_MMYY.xls. (Posting on company 0245)

  
  We receive a file like the following, if we display the file we see the following information: 
  
  
  We will create on company 0245 a posting with transaction FB01, document type S1 and posting / document date end of month and take the assignment model ES0245-001. 
  
  The following operations should be done 
  1- Change the amounts retrieve from the assignment model and replace it by the ones of the file taking as a key the column " CC Nomina " from the file and the first four position of the field " Text " of the posting; 
  2- Change on the posting document the values MM ( month ) and YY ( year ) by the ones of the posting date; 
  3- Record in the last line number the total amount indicated in the file (by this way in case of any mistake on the previous updated amounts the posting will be unbalanced ); 
  4- Enter base line date (end of month) for posting in account 2416220000. 
  
  Note: In case other wage types appear in the HR file and are not mentioned in the posting to be performed please inform Local finance. 
  
  The following display show the operations described above. 
  
  
  Finally post the intercompany document. 
  
  

  3.1.9.2. File E1_DNE_ Witholding_MMYY.xls.

  
  We receive a file like the following, if we display the file we see the following information

  
  

  CC-nómina	Texto expl.CC-nómina	Ctd.	Importe	Mon.
  3311	Comedor	21	-43,47	EUR
  6542	Seg.colectivo vida	0	-72	EUR
  7551	Seguro colectivo Acc.	0	-191,29	EUR
  *	21	-306,76	EUR

  
  

  We will create two excel file posting with that information: one in company 3454 and another for company 5696. 

  3.1.9.3. Posting in company 3454

  
  Use the following Excel file model and update the fields ( in red ) : 
  

• 
  

• Posting date/document : end of the month
• Amount : copy the values from the Excel file ( for each line on the posting file choose the amounts where the values of column " CC Nomina " of the E1_DNE_witholding:_MMAA file match with the first positions of the field " Text " on the posting file )
• Text: change the values MM ( month ) and YY ( year ) for the ones of the posting document. 
  
  
  Post the document with the transaction ZZF_POSTING_FILE. 
  
  See an example of the Excel posting file : 
  
  
  Note: In case other wage types appear in the HR file and are not mentioned in the posting to be performed please inform Local finance. 
  
  
  

  3.1.9.4. Posting in company 5696

  
  We save the file and create a ticket to 3S AP in order to post the file.
  
  We open the attached field : 
  and replace :
• the amounts for the one related to the line 6542 Seguro Colectivo de vida of the file E1:DNE_witholding_MMYY
• The document and posting date by the end of current month
• The values MMYY ( month and year ) of the text , for the ones related to the posting document. 
  
  

  3.1.10. CO Posting – MA Kilometers costs

  
  In the production companies of Martorell ( 5696 ) there is a need to transfer the Kilometers expenses posted through the payroll process from the cost center to a defined orders. This should be done each month posting the following CO Posting. 
  Reference doc. 201790821 (4/2011). 
  
  But before post it, is necessary to check if the amounts by company and by cost center has been changed from the last update of the file. 
  
  For that reason, each month should be compared the amounts posted in FI-GL on account 6141030000 and document type H0 (dynamic selections) with the amounts on the file (use the transaction FBL3N, layout /MA_KM_2.1.9). 
  
  For Company 5696 sender Cost center is MH* or HK*. 
  For Company 0303 sender Cost center is HR*. 
  
  Copy from SAP the cost centers and the respective amount into sheet 2.1.9 in Macro ES Payroll. 
  In case of any difference (delta column), send the Excel file to CTB-Martorell asking to update it. 
  In case of new cost center with the amount in SAP please contact Local accountant through e-mail: ctbmartorell@solvay.com
  
  

  3.1.11. Distribution Social Security of Expatriates

  
  For SOLVIN, company 5696, the cycle MA0210 must be launch using transaction KSV5. 
  For SOLVA IBERICA, company 3454, the cycle SO0210 must be launch using transaction KSV5. 
  For SOLVAY QUIMICA, company 0245 the following must be done:
• Run Cycle SQZ100 using transaction KSV5;
• Settle Orders – 1059002440 and 1059002441 / 1059002480 and 1059002481
• Settle Associated Croco Order – 2052005720 / 2052005860

Generate the Croco Invoice 

3.1.12. PLUSACTIVIDAD

At February 2014 it was booked the yearly provision correspondent to the PLUSACTIVIDAD in company 0245. This amount must be manually allocated to the corresponding cost centers during 2014. 

We need to take the amounts in column "Importe Mes", and book these amounts manually on a monthly basis. 

You can see in the file the detail of CECO and the general account must be 6200000000. 



You can use document number 5010014372/0245 as reference, just change the vase number and the month. 

3.2. CCN /352 y PA20 - "EXCESO CUOTA PATRONAL" and "SALARIO ACCIDENTADOS"

On a monthly basis, we will receive from HR local team an Excel file with the details of wage types /352 and PA20 (salesforce case description 0245_CCN / 352 y PA20 MMYYYY). 

We will take this information, prepare the booking and perform the necessary postings in accounting taking the attached file as a template.

• Wage type /352 - EXCESO CUOTA PATRONAL (PROPIOS ASEGURADORES) 
  
  Debit account 2454000000 and credit account 621000000 (by cost center, in case there is no cost center available in one of the lines use ST80084109).
• Wage type PA20 - SALARIO ACCIDENTADOS (PROPIOS ASEGURADORES) 
  
  Debit account 2454000000 and credit account 6230000000 (by cost center, in case there is no cost center available in one of the lines use ST80084109). 
  
  

3.3. Person of Contact

1. Solvay Quimica : Maria del Mar Llata
2. SOLVIN Spain : Josep Lluis Duran / Visitación Balfagon
3. Solvay Ibérica : Josep Lluis Duran / Visitación Balfagon 

End of document.