Versions Compared

Old Version 4

changes.mady.by.user Joana Tavares

Saved on

compared with

New Version Current

changes.mady.by.user Gomes, Susana

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



Hide If
groupconfluence-users

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 




Panel
bgColor#F7F7F7
titleColor#ffffff
borderWidth1
borderStylenone
Domain: Country Accounting



Panel
bgColor#F7F7F7
borderWidth1
borderStylenone

Responsibility area: N/A


Table of contents 

Table of Contents
maxLevel2



Panel
borderStylenone
Scope

Image Modified

To be confirmed!


ERP
Image RemovedImage RemovedImage Removed

Image RemovedImage ModifiedTo be filled!


Frequency

 Image RemovedImage Removed Image Removed

 Image Removed Image Removed Image Removed

 To be filled

References


References

BL3N; FBL3N


Forms

BE - Pension Fund Debit Notes Cadres

BE - Pension Fund Debit Notes EEO


Attachments

8. Add the link to attachments or external links



To be filled! Previous OP <<

Page_title
>> To be filled!Next OP



1. Objective and Scope

1.1. Objective of this Operation

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

1.2. Scope

This operating procedure (OP) applies to all Belgium companies.


2. Definitions

See Finance Glossary:


3. Tasks description

3.1. Responsibilities

Responsibility of SBS RtR BOFinance operations:

  • Perform the split and the posting of debit notes;
  • Check the posting consistency.

3.2.

Procedure

Background

The posting of pension fund debit notes has to be performed on a monthly basis, after the reception of 2 files : Cadres and EEO by TOWA (in HRO-Benefits BE sents in general around 20th of the next month). REMARK: All files received needs to be approved before posting, by HR team: Stephanie Donneux, Françoise Larcin or Barbara Sine.

  • TOWA send the file with the amounts concerning pension funds to Cy 0001.

  • Then, Cy 0001 will re-invoice the pension funds to the other companies.

  • Re-invoice will be divided in several postings according:

 The nature of employees: Cadres or EO. 
 The cost center allocated.


  • For CADRES, the posting of debit notes generates:

 A debit of account 6220033200 (Pension fund-managers)
 A credit of account 2456003251 (Pension fund-managers, employer allowance).


  • For EEO, the posting of debit notes generates:

 A debit of account 6220030300 (Pension fund-employees) 
 A credit of account 2456003253 (Pension fund- employees). 


REMARK:


Warning
titleRemark
  • For re-invoicing costs from 0001 to Cies out of ERP, we will debit the account 7050010000 instead of account 622*.
  • For these allocations, we use the account 705001000 and the respective
order of each Cy: 07016PERXXXX, where the last four digits corresponds to the CY code that will receive the cost
  • wbs (see template).
  • A profit account is used in order to not mix costs of company 0001 with costs incurred for others (and maybe show those as profit for reporting purposes).


3.3.

Debit

I perform the posting of debit notes for CADRES

Each month, save all documents received from TOWA (AND validated by HR team –simply ask to Stephanie Donneux if figures sent by TOWA are correct) regarding pension fund for Cadres. Copy paste special values the entire sheet received from HR into sheet "original HR" in file LOP BE PENSION FUND - Debit notes . (see template
In sheet "original HR" in column of "Societe" and in column "costcenter" all cell must be converter into numbers:Image Removed.


Click on button "Check & Postrun macro" in sheet "database" and everything is done automatically:

Image Removed Image Added


The macro is making several steps at the same time:

3.3.1.

Check

I check the posting for debit notes of CC 9999999999

In sheet "check M-1" check the total amount equal to SAP posting of last month in account 2456003251 (in this sheet it was filter all lines with CC 9999999999):

Image Added                                                                          

Image Removed 

BL3N FBL3N to check (Pension fund-managers, employer allowance), corresponding to sum calculated before account 2456003251 in company 0001 in open items: 

Image RemovedImage AddedImage Removed


Image Added

3.3.2.

Posting

I perform the posting of current month CC 8888888888

In sheet "original HR 8" there is made a short of all Cost Centers 8888888888 to help the preparation of the posting file in sheet "ZZF_Posting_file 8". 
The total amount of lines with cost centers 8888888888 in sheet "original HR 8" must be equal to amount in account 2456003251 in sheet "ZZF_Posting_file 8". 

Image Removed Image AddedImage Removed 

Image Added                                       



Make the ZZF POSTING File from these data:

  1. Reference: Update with the sales force case number (the one of HR team)
  2. G/L account-Debit
    • Post the debit of all lines copied, use the account 7050010000
    • Use account 2456003252 for amount concerning Cy 0001
    • For "ZZZZ" line, use the account 6200050000 and the CC SM16400090
  3. G/L account-Credit
    • Post the credit on account 2456003251 of total amount and update the date in related Text.


Post the ZZF posting file and don't forget to attach all the document justification: Calculation, PDF and ZIP files.

3.3.3.

Posting

I perform the posting for current month – remaining amounts

In sheet "original HR R" all the costs centers excluding the 99* and 88* will generate a second posting for the current month. 
The total amount of lines without cost centers 99* and 88* in sheet "original HR R" must be equal to amount in account 2456003251 in sheet "ZZF_Posting_file Remaining". 

Image Removed 

Image Removed

The only operation that must be done manually is in sheet "ZZF_Posting_file Remaining" is the replacement of cells in RED:

Image Added

Image Added


  • Replace CC 7777777777 by SM800R6200 for Cy 0001
  • Replace CC 7777777777 by C4800R6351 for Cy 0292
  • Replace CC 7777777777 by IS862R2900 for Cy 5697

Image Removed Make the ZZF POSTING File 
G/L account: Copy/paste text of column F

    • Post the debit of all lines copied on the account 6220033200 for lines with Cost Center, and on the account 7050010000 for
    • CO Order
    • wbs (see template)
    • Post the credit on account 2456003251 of total amount and update the date in related Text.


Note
NOTE:

Please update the assignment and text for credit line (With the previous month)

;

.


Post the ZZF posting file and don't forget to attach all the document justification: Calculation, PDF and ZIP files.

3.4.

Debit

I perform the posting of debit notes for EEO

Each month, save all documents received from TOWA (AND validated by HR team –simply ask to Stephanie Donneux if figures sent by TOWA are correct) regarding TOWA  regarding pension fund for EEO. Copy paste special values the entire sheet received from HR into sheet "original HR" in file LOP BE PENSION FUND – Debit Notes EEO (see template)
Click on button "Check & PostRun macro" in sheet "database" and everything is done automatically: 

Image RemovedImage Added 



The macro is making several steps at the same time:

3.4.1.

Check

I check the posting for debit notes of CC 9999999999

In sheet "check M-1" check the total amount equal to SAP posting of last month in account 2456003253 (in this sheet it was filter all lines with CC 9999999999):

Image RemovedImage Added 


FBL3N to  to check (Pension fund-employees), corresponding to sum calculated before account 2456003253 in company 0001, with selection open items:

Image RemovedImage Added                                      

3.4.2.

Posting

I perform the posting of current month

In sheet "original HR 2" all the costs centers excluding the 99* will generate a posting for the current month. 
The total amount of lines without cost centers 99 in sheet "original HR 2" must be equal to amount in account 2456003253 in sheet "ZZF_Posting_file". 

Image RemovedImage Added 

Image Removed 
Image Added

Make the ZZF POSTING File File.
G/L account: Copy/paste text of column F:

  • Post the debit of all lines copied on the account 6220030300 for lines with Cost Center, and on the account 7050010000 for CO Orderwbs(see template)
  • Post the credit on account 2456003253 of total amount and update the date in related Text.
NOTE:


Note
titleNote

Please update the assignment and text for credit line (With the previous month

; 

).


Post the ZZF posting file and don't forget to attach all the document justification: Calculation, PDF and ZIP files. 

3.5. I inform the HR local team 

Inform HR local team that debit notes of pension fund for CADRES and EEO were calculated and posted in all BE companies.


End of document.

Viewtracker
hidetrue