1. Objective and Scope

1.1. Objective of this Operation

The purpose of this document is to explain how to perform the CBNR SG&A report for US and CA companies.

The Corporate controllers need to see what it is hitting the heading R33310 in CBNR market only. This report gives a detailed view of what is being reported on it.

1.2. Scope

It is done until D+10 after the quarterly closings.

All companies in US and CA that have values in heading R33310 + magnitude market CBNR (WP1) or act market 59 (PF1).

4045 SOLVAY AMERICA, INC
7424 SOLVAY USA INC
7651 SOLVAY CANADA INC (CAD)
6032 SOLVAY HOLDING INC.
5782 SOLVAY SPECIALTY POLYMERS USA, LLC
7008 Cytec Industries
7031 Garret Mountain Insurance
7427 Cytec Technology Corp
7752 Cytec Canada Inc (CAD)
6230 Solvay India Holding Inc.
4290 Solvay Chemicals
4291 Solvay Soda Ash JV
3384 Solvay Fluorides
6401 American Soda LLC
7180 Cytec Engineered Materials Inc.

Check the file Companies CBNR US and CA with the applicable companies. If some company is sold or merge or another company is created or acquired, remember to update this file.

2. Definitions

See Finance Glossary:

• ERP
• PF1
• SAP
• Value Field
• WP1

3. Tasks description

3.1. I Retrieve the Data

3.1.1. I Retrieve the Data

1 - In PF1:

Go to KE30, report ZZZ-SOLV00 Periods/Year, include:

the fiscal year and period;

company code;

currency type/reporting currency = 10

activity1(mkt) = 59 in PF1

PF1:

Find R33310 with Ctrl+F and check what are the value fields that have value in the first column, in this case only I25:

The possible value fields according to RtR RCS CO PA x BFC x BO Interface doc Q3 2019 tab KE30 layout Q3 2020 Optimic are:

I00
I20
I25 - most used

I45
I50
B34

2 - In WP1:

Go to KE30, report ZZZ-SOLV00 Periods/Year, include:

the fiscal year and period;

company code;

currency type/reporting currency = 10

After the report runs, include the magnitude market and select CBNR

The possible value fields according to RtR RCS CO PA x BFC x BO Interface doc Q3 2019 tab KE30 layout Q3 2020 Optimic are:

I00
I20
I25 - most used

I45
I50
B34

Search for each one to check where the value is. The value fields are in SGA group

 from now on, the procedure is the same for both systems.

3 - PF1/WP1 systems:

Double click on the line that there is value to go there.

Then, click on the Period value and press F9 to go to its line items.

Include the value field you have opened in the layout:

Check the box for aggregation:

Then, click on the value field column and click on filter button. Then, delete the empty lines:

Then make a subtotal in the sender cost center column to see what are the cost centers that send values to this value field.

In this case it is only one cost center:

After that, open the cost center in transaction KSB1:

The layout can be a particular layout or 1SAP, just need to have:

Cost Element; Cost element name; Value in Obj. Crcy; Object Currency; Dr/Cr indicator; Offsetting acct no.; Name of offsetting account; Document Header Text; Period; Fiscal Year;

After adjusting the layout, extract the data to excel.

Make that process to every cost center and all companies in US and CA scope.

Include all in one excel file to be easier to analyze, one tab per company code (make sure to check all companies, not only the ones in the screenshot):

After doing that, go to next step.

3.1.2. I Categorize Each Cost Center Line

For the items extracted from the cost centers, create a column in the right of the excel to categorize the items in groups.

Some cost centers have values that do not hit R33310, it depends of the cost element used. In this case, it should be checked in the cost center cycle.

The categories can be:

Fringe adjustments: - to fringe over/under;

CAT TAX - to intercompany invoice related to this procedure;

Standard & PSU Bonus;

IAS 19;

Closed sites - sites not productive and closed and no GBU, so everything goes under Corporate;

Withholding Tax Write-off

Balance sheet write-off

Others - values without a big impact as it does not matter so much to the controllers. Can not have a big number in this category;

The old categorization file can be found here CBNR Report folder or an example is CBNR Q4 2021.

3.2. I Prepare the Report and Send

3.2.1. I Prepare the Report

After categorizing the items, go to CBNR Report and include the values in the report "CBNR NAM YTD YYYY".

Include the value and description for each category by month and company code.

3.2.2. I Update the Values to EUR

After that, to update the column in EUR "Actual YTD YYYY in Euros", take the file received by email with subject "Exchange Rates - Month YYYY" sent by BFC Admin.

In tab Monthly Calculation, find 1 EUR = x USD and include the value on cell Z2 of the report.

Make the same with 1 EUR = x CAD and include the value on cell AB2.

In Column "Actual YTD YYYY in Euros", make sure it is updating to EUR correctly. In other words, the formula is total value in USD divided by the USD rate or CAD rate depending of the reporting company.

The CAD companies are 7651 and 7752. The others should be USD.

3.2.3. I Send the Report

Send the report link by email or the applicable tool.

Make sure the contacts below have access to the report in Gdrive.

The contacts are:

charles-antoine.jancovici@solvay.com - controller corporate WW

sofia.varandas@solvay.com - controller corporate WW - replacing Remy Julien - remy.julien@solvay.com - include him while he is a corporate controller.
jill.wilson@solvay.com - controller corporate US
ines.tomas@solvay.com - controlling platform

The email subject can be "CBNR - NAM YTD Month YYYY"

End of document.