1. Objective and Scope

1.1. Objective of this Operation

The purpose of this procedure is to explain how to perform the posting of payment of pension fund allowance to Solvay Group employees "CADRES" and "EMPLOYES ET OUVRIERS" (EEO).

1.2. Scope

This procedure applies to the all Belgium company and the environment is SAP-PF1.

2. Definitions

See Finance Glossary:

• EEO
• PF1

3. Tasks description

The payment of pension fund allowance will be divided in several postings according:

• The nature of employees: Cadres or EEO, and
• The cost center allocated.

For CADRES, the posting generates:

• A debit on account 6220033200 (Pension fund-managers), and
• A credit on account 2456003251 (Pension fund-managers, employer allowance).

For EEO, the posting generates:

• A debit on account 6220030300 (Pension fund-employees), and
• A credit on account 2456003253 (Pension fund- employees).

3.1. Responsibilities

HR Team is responsible to sent 2 files via fresdesk: Cadres and EEO (in general around 20th of the next month).
Finance Operations is responsible for performing the split and the posting of allowances; and checking the posting consistency.
FO are responsible for checking the final consistency on HR accounts.

3.2. Periodicity

The posting of pension fund allowance has to be performed on a monthly basis, after the reception of 2 files: Cadres and EEO by HR team (in general around 20th of the next month).

• The EEO and Cadres files are sent by distribution list : HRO-Benefits BE hro-benefits.be@solvay.com

3.3. I calculate and post pension fund allowances for CADRES and EEO

Save all documents received from HR Team, regarding pension fund allowance for Cadres/EEO. Open BE PENSION FUND Allowances Cadres PF1 and BE PENSION FUND Allowances EO PF1, according to what you are doing. The steps for both are basically the same.

3.3.1. I perform the posting of allowances

3.3.1.1. I paste the data received

Copy the data from HR file and paste it in sheet File from HR:

3.3.1.2. I

run Macro

Go to sheet "PIVOT 1-POSTINGDATABASE" and make refresh in the pivot tablerun the macro:

Image Removed Image RemovedImage Added

3.3.1.3. I check the results

Before making the post, consider the following checks:

1) The Grand Total of your pivot table (sheet PIVOT 1-POSTING) has to be equal to sum of amounts in original data base (sheet File from HR):

2) In sheet "ZZF_POSTING_FILE" check if amount in line of account 2456003251 is equal to the Grand Total of pivot table & Sum of amounts in Original data base:

 
Remarks:

1. 1. In case the values don't match is because some amount is missing in the posting file. You need to review data base and see if all CC are assigned to the respective company code, and if some is wrong correct the company code and make new refresh of pivot table and check again the total amounts.
   2. Pay attention: For companies company 0237 and 0292 the split is done by Establishment code (CADRES):

3) In sheet "ZZF_POSTING_FILE, check carefully also the following

1. 1. Header Text: Update with the sales force case number (the one of HR team)Freshdesk number;
   2. CO Code & Cost Centers & CO Order& WBS: Update only if needed;
   3. G/L account-Debit:
   4. Post the debit of all lines copied, use the account 6220033200 for CADRES and 6220030300 for EEO;
   5. G/L account-Credit:
      1. Use account 7050010000 for cost remaining in Cy 0001;
      2. Post the credit on account 2456003251 for CADRES and 2456003253 for EEO, of total amount and update the date in related Text;

Final check before posting: Make sure that the sum of the credit amount (in posting file-column N) is the same as in pivot table and original data base.

3.3.1.4. I perform the posting

Save the file you are working while displaying the sheet "ZZF_POSTING_FILE ".
Go to transaction ZZF_POSTING_FILE and post the file.

3.3.2. I perform the posting of Statistical Key Figures

3.3.2.1. I create the file to upload

In order to have the SKF upload go to sheet database and press the button 
This macro will pick the amounts and cost centers from company 0001 and 5697 in
 sheet and copy past them into  sheet.

Confirm if the total amounts are equal to the ones in sheet PIVOT 1-POSTING. 
The Key figure values will be different according to the file that is being used: (= ZZFDPC for CADRES and ZZFDPE for EO);
Save the sheet SKF-upload in TXT format and upload it according to the instruction below.

3.3.2.2. I perform the posting

In SAP, run transaction Z1K_ACTUAL and select option Z1K_UPLOAD_RATIOS:

Then go to transaction SM35 and launch the batch input created considering the following options:

1. 1. Processing Mode: Display errors only
   2. Additional functions: Expert mode & Dynpro standard size
      
      

3.3.2.3. I check the results

Run transaction GR55 => ZBM4 - SKF Analysis in order to check if values are OK in each SKF created. Select the Fiscal Year and SKF Value ZZFDPC for CADRES and ZZFDPE for EEO:

3.3.3. I inform HR local team

Inform HR local team that allowances of pension fund for CADRES and EEO were calculated and posted in BE companies, by giving feedback in the Freshdesk ticket.
Add in CC filed the correspondent locals:

• 0001, 0003, 0007, 1205, 4301, 5697, 5974, 5990:

.

• 0005, 0237, 6070, 6233, 6234:

alain.sarens@solvay.com; christine.vanaudenhove@solvay.com;

• 0292, 1426, 5672, 1419:

claude.jocet@solvay.com; viviane.vandyck@solvay.com;
belinda.hazaer@solvay.com; jean-francois.mies@solvay.com;

• 6050, 5978:

End of document.