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, new_zealand, emea_transversal, apac_transversal

    • 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. Name the title of each section using OPD methodology naming convention - Infinitive verb without the “to”, mainly action verb...something) - " I do something..."

5. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow 


Domain: Treasury Accounting

Responsibility area: Ensure the Interest on Intercompany Loans and Borrowings calculation.

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

Please remove the icon when not applicable.


ERP

4. Remove the icon(s) when not applicable

Please remove the icon when not applicable.
Frequency

5. Remove the icon(s) when not applicable

Please remove the icon when not applicable.
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 Form name



Attachments

8. Add the link to attachments or external links


 

 

Previous operation << >> Next operation



1. Objective and Scope

1.1. Objective of this Operation

WHY - Describe the objective of the operation

Syensqo’s affiliates are funded exclusively through internal financing, in the affiliate’s currency and at arm’s length rates. The internal financing is originated from the Internal Structured Borrowing (ISB) for stable financing needs.

The purpose of this process is to compute the amounts of interest on loans subscribed with affiliates. This process will also allow to perform the transfer between long term and short term loans. Overall this process is making sure that accounting is reflecting what is being done at the level of the business (Treasury FO).

This process is currently automatic for the entity 2232.

The loans and borrowings contracts are communicated by the Treasury Corporate Front Office and/or Back Office to the Service Unit Treasury Accounting team. Ensure that the contracts attached in PI1 are complete is a key point in the process.

The Service Unit Treasury Accounting team needs to perform the following steps:

  • Run the automatic interests computation via SAP transaction or manually;
  • Ensure that all the entries are correctly posted in the accounting for the profit and loss and the accrued interests (BS);
  • Perform the reconciliation of respective balance sheet and profit and loss accounts with the data recorded by the front office team (via “treso file” and accounting data).

 

1.2. Scope

Detail the scope (legal entities, etc.)

This operating procedure (OP) applies to SAP PI1 company 2232 Syensqo SA - Treasury Division.

2. Definitions

Definitions should be added in the Finance Glossary - Add definition and link it to respective Letter in Finance Glossary 

See Finance Glossary:

  • ...


3. Tasks description

WHAT and HOW - Main content of the operation

The content should be mainly organized in 2 levels of Headings to ensure a proper link with the Table of Contents.

Select the level of heading in the "Paragraph" option.

3.1. I run FCC on D+1 and follow the steps in folder "2232: Loans / borrowings process".

3.1.1. I run the loans and borrowings interest calculation

Run transaction FCLOCO in SAP BW - WBP – choose task list Z_SCO_TRE for the month being closed and find the activity in D+1 tasks



This first step computes the interest on loans and borrowings for company 2232.


Go to the blue button – Interests on Loans and Borrowings and schedule the task. This action will open the transaction code TBB4 with the Variant 3S-2232-PROMS.

Update the date accordingly with the closing period.



Monitor the progress via the transaction code SM37 and post the Batch via SM35.


Run TBB4 transaction code to verify if there are no blocked postings.



3.1.2. Check the postings are completed in P&L and Balance sheet accounts

Next step is to follow if the Interests on Loans and Borrowings postings are performed accordingly in P&L accounts 7513000000 and 6504000000 (check that TM documents are posted).

Check Balance sheet accounts (2232): 2710100000/2720100000 (check that TM documents are posted).

For the old accounting scheme (2232 interest on borrowings): 2710200000 / 2720200000 / 2710300000



3.1.3. Check the last run of transaction code TBB1

Run the last steps in FCC first in test and after in real mode if needed.


This check shows if there are no outstanding postings to be performed by Treasury Corporate back Office Team. Usually when the new loan contract created after the last day of the month and is not yet validated by Back Office in the system.

Transaction: TBB1, Variant: D+2_60M_60P


3.1.4. Ensure Loan LT \ ST Transfer 

Run transaction Z3Y_TR_LOAN_LT2ST, variant CLOSURE LOANS, to make the reclassification of the ST portion amounts for the LT loans.



3.2. I check if the Interests on loans and Borrowings are performed accordingly in Balance Sheet and P&L accounts for 2232

Perform the Reconciliation of the respective Balance sheet accounts to verify if there are no missing postings.

One of the most common reasons is a technical program issue that is why it is very important to do reconciliation directly after Interest on Loan / Borrowings postings on D+1 evening or D+2 morning to catch mistakes and book the interests manually if required. This is critical to avoid intercompany differences between the affiliates.



In this step we should:

1)  Check if in GL accounts 271010000 and 272010000 there are payments to be cleared with the accruals


2) Check GL accounts 52* to see if there are items to be cleared (loans repayments, etc.)


3) Perform the control files stored at \\capfs01\LUCAP-USERS\TREASURY ACCOUNTING\MONTH END CLOSING\YYYY\MM.YYYY\2232\LOANS (steps below)


3.2.1. I perform the reconciliation using the suivi file

Using the suivi file - all accounts except 2710100000 (due to DTO different contract numbers, currently it is not possible to manage the good pivot filtering)


Reconciliation - SUIVI FILE to be prepared in D2 to avoid unreconciled differences.

5105000000 / 2720200000: Is reconciled with Suivi file / can be checked manually

Save as the file for the new respective month

CICC accounting\Month End Closing\YYYY\MM.YYYY

Using the Procedure upload the data from SAP - pretemprunt file

Update the pivot tables in 3 tabs for GL accounts reconciliations and Refresh

Do the same for 2 and 3 tab


Reconciliation will be done for:

1                                                         2                                          3

2710100000 n/a                             2720100000                      52*

2710200000 n/a                             2720200000                      5114000000

2720300000 &                               2720000000                      5105000000

2710300000                                   2710000000                     5030000000

Print the 3 tabs, sign, scan and store in the respective reconciliation folder



3.2.2. I perform the reconciliation for account 2710100000 - Interests receivable on Loans

RECONCILIATION for 2710100000 should be done 2 times:

D1 - after the Interest on Loans posting - pre-check

D5 - after the closing - final Reconciliation


Reconciliation for 2710100000 - First we run the summary of the existing loans:

Transaction code FS10N

Account 52* - 2232 20YY / click on YTD Balance / filter “Cleared/open item” / Sum by TPartner


List of all Loans by Trading Partner, by Currency, by Contract

Print screen or save in PDF, this will be the supporting document for Reconciliation

In some cases - to double check with Treasury FO (Edgars, Hatem)




The next step is to run FS10N or FBL3N for 2710100000 - Open items at the last day of the month being closed

Export the data to the Excel file.


Make the Filter by Trading Partner and check each Trading partner one by one.

You can use colors, borders, other grouping options for reconciliation purposes.

IMPORTANT: the Reconciliation should be reliable and accurate, clear for any 3rd party (Reconciliation approver, Treasury dpt, Deloitte)


An account is reconciled when:

+ Supporting detail is known

+ Differences are identified and properly supported

+ Unresolved reconciling items are investigated and escalated


The Loan contracts details can be checked with transaction code TM03 = TX.3



Reconciliation files to prepare and saved in Z:\TREASURY ACCOUNTING\MONTH END CLOSING\YYYY\MM.YYYY\2232\Loans:

  • 2232_Int on Loans MM.YYYY
  • Loans Accounts - 5200000000_5200200000_5200100000_MM.YYYY

2232_Int on Loans 10.2024.xlsx

3.2.3. I perform the reconciliation for account 2720100000 - Interests payable on Borrowings

Reconciliation file "2232_Int on Borrowings MM.YYYY" to be prepared and saved in Z:\TREASURY ACCOUNTING\MONTH END CLOSING\YYYY\MM.YYYY\2232\Loans.



End of document.