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


ERP

4. Remove the icon(s) when not applicable


Frequency

5. Remove the icon(s) when not applicable

 

References

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

SM35; ZZF_POSTING_FILE; Z1K_ACTUAL; GR55


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




Previous OP << >> Next OP



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:


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


For the costs concerning company 0001, we will debit the account 7050010000 instead account 622*.

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

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 "DATABASE" and run the macro:



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. 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 company 0237 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 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.

Don't forget to attach all the document justification: Excel file with the original data base, calculation and posting.

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.


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



End of document.