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

To be confirmed!

ERP

4. Remove the icon(s) when not applicable

To be confirmed!

Frequency

5. Remove the icon(s) when not applicable

 To be confirmed

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

BE PENSION FUND Allowances Cadres PF1

BE PENSION FUND Allowances EO PF1 

Attachments

8. Add the link to attachments or external links

OP BE PENSION FUND Allowances Cadres.xls

OP BE PENSION FUND Allowances EO.xls

(to be confirmed!)



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



1. Objective and Scope

1.1 Objective of this Operation

The purpose of this LOP 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 LOP applies to the all Belgium company and the environment is SAP-PF1.
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 files are usually sent by Barbara Sine and the CADRES files by Patricia Michaux.

2. Definitions

See Finance Glossary:


(To confirmed where the following text - before the tasks descripton - belongs)

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


Pay attention: for the costs concerning company 0001, we will debit the account 7050010000 instead account 622*.

3. Tasks description

3.1. Responsibilities

The locals are responsible for sending the 2 files: Cadres and EEO by HR team (in general around 20th of the next month). If they came just by email, create a sales force case for them.
RtR is responsible for performing the split and the posting of allowances; and checking the posting consistency.
The locals are then responsible for checking the final consistency on HR accounts.

3.2. Pension fund allowances for CADRES and EEO


Save all documents received from HR Team, regarding pension fund allowance for Cadres/EEO. Open SBS-FRM-DRTR-07-023 BE PENSION FUND Allowances Cadres PF1.xlsor SBS-FRM-DRTR-07-024 BE PENSION FUND Allowances EO PF1.xls, according to what you are doing. The steps for both are basically the same.

3.2.1. Perform the posting of allowances

3.2.1.1. Paste data received

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

3.2.1.2. Refresh pivot table

Go to sheet "PIVOT 1-POSTING" and make refresh in the pivot table:

 

3.2.1.3. Check 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. 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 0237 and 0292 the split is done by Establishment code (CADRES):


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

    1. Header Text: Update with the sales force case number (the one of HR team);
    2. CO Code & Cost Centers & CO Order: 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.2.1.4. Make 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.
Don't forget to attach all the document justification: Excel file with the original data base, calculation and posting.

3.2.2. Perform the posting of Statistical Key Figures

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


In case the macro doesn't work, just copy and paste the needed figures in the correspondent columns:



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.2.2.2. Make 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. Processing Mode: Display errors only
    2. Additional functions: Expert mode & Dynpro standard size

3.2.2.3. Check 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.2.3. 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 sales force case.
Add in CC filed the correspondent locals:

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

teamlux.holding@solvay.com; sara.ramos@solvay.com;

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

nathalie.meskens@solvay.com. 


End of document.