| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
...
Author(s)
...
Verification
...
Approval
...
João Saramago
Operational Process Specialist L1
...
Madalena Freire
RtR SC Transversal Leader
...
Pascale Vauchez
GL Process expert
...
23-12-2016
...
30-12-2016
...
06-01-2017
...
Version
...
Date
...
Description
...
01
02
03
04
...
06-11-2016
25-11-2019
08-01-2020
10-01-2020
...
New Document
Revision
Revision
Revision
...
6.1 Schedule details
6.1.1 L4051 – Financial information for equity companies
6.1.2 L6605 – Borrowings by maturity
6.1.3 L6810 – Commitments and contingencies given
6.1.4 L6825 – Analysis of employee expenses
6.1.5 L6830 – Statutory auditor's fees and services
6.1.6 L6864 – Net Financial Indebtedness
6.1.7 L6880 – Overdues on receivables – Ageing balance
6.1.8 L7110 – Transactions with Related Parties
7 Appendix
...
SBS – Solvay Business Services
FA SL – Financial Accounting Service Line (Service Unit)
FA SL InterCo – Financial Accounting Service Line (Service Unit)
FIN OPS - Finance Operations
BFC – Consolidation tool
Actual 3 – Package inside BFC reporting tool, which aims to provide a deeper detail on items reported in previous BFC reporting packages (Actual 2)
CAM – Company Accounting Manager
GAR – Group Accounting and Reporting
PF1 – Solvay Legacy's SAP system
WP1 – Rhodia Legacy's SAP system
...
|
1 Objective and Scope
1.1 Objective of this Procedure
1.2 Scope
2 Reference Documents
3 Definitions
4 Responsibilities
5 Periodicity
6 BFC Actual 3 schedules
6.1 Schedule details
6.1.1 L4051 – Financial information for equity companies
6.1.2 L6605 – Borrowings by maturity
6.1.3 L6810 – Commitments and contingencies given
6.1.4 L6825 – Analysis of employee expenses
6.1.6 L6864 – Net Financial Indebtedness
6.1.7 L6880 – Overdue on receivables – Ageing balance
6.1.8 L7110 – Transactions with Related Parties
7 Appendix
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
The purpose of this document is to provide the guidelines to fill in BFC Actual3 package.
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
This operating procedure (OP) applies to all the companies under the scope of FA SL Service Center.
| Anchor | ||||
|---|---|---|---|---|
|
SBS – Solvay Business Services
FAC GL – Financial Accounting Service Line (Service Unit)
FAC Interco – Financial Accounting Service Line (Service Unit)
ACP - Accounting Platform
BFC – Consolidation tool
Actual 3 – Package inside BFC reporting tool, which aims to provide a deeper detail on items reported in previous BFC reporting packages (Actual 2)
CAM – Company Accounting Manager
GAR – Group Accounting and Reporting
PF2 – Solvay Legacy's SAP system
WP2 – Rhodia Legacy's SAP system
| Anchor | ||||
|---|---|---|---|---|
|
The BFC Actual 3 package has split responsibilities between FA SL, ACC PLAT and the CAM of the company, depending on the schedules and headings to fill in. Detailed information on "who does what" is included in each schedule details inside this procedure.
| Anchor | ||||
|---|---|---|---|---|
|
BFC Actual 3 is required for September closure and December closure. The deadlines for the publishing of this package are communicated by GAR.
| Anchor | ||||
|---|---|---|---|---|
|
The following BFC schedules are reported under Actual3:
L6605 - Borrowings by maturity
L6810 - Commitments and contingencies given
L6825 - Analysis of employee expenses
L6864 - Net Financial Indebtedness
L6880 - Overdue on receivables - Ageing balance
L7110 - Transactions with Related Parties
L4051 - Financial information for equity companies
BFC Actual 3 schedules for Equity method companies
L6810 - Commitments and contingencies given
L7110 - Transactions with Related Parties
Anchor _Toc463535091 _Toc463535091
Schedule details
| _Toc463535091 | |
| _Toc463535091 |
| Anchor | ||||
|---|---|---|---|---|
|
This schedule is under the responsibility of CAM.
This schedule only concerns the companies which have shares recorded under A24000.
You need to report balance sheet and P/L items of the affiliate companies that are consolidated under "Equity method".
| Anchor | ||||
|---|---|---|---|---|
|
This schedule is under the responsibility of the CAM, for PF2 and WP2 systems.
In this schedule, the closing values of long term and short term borrowings are retrieved from Actual 2 package. It is then required to split the values according to their maturity (period where the borrowed money must be returned to the loaner).
The headings that need to be split by maturity are the following:
- Long Term (from 1 year to over 5 years): L16100, L16800, L16830 and L16810: is classified with Fixed Rate
- Short Term (less than 1 year): L51900, L57000 and L58200: is mainly variable rate but need to be confirm upon the loan.
Short Term portion of Long Term debt: L56000, L56010, L 56030: follow the rate of the Long term loan (Fixed Rate)
Changes in the schedule L6605 - IFRS16 impact - A report is sent by MAC to fill this information.
Part 1. Book value
a. Insert L16830 LT lease IFRS16 under L16810 LT lease debt
b. Include L16830 in sub-total "Borrowings > 1 year"
c. Insert L56030 ST lease IFRS16 under L56010 ST lease debt
d. Include L56030 in sub-total "Borrowings < 1 year"
f. Include A46300 in sub-total "Borrowings < 1 year"
g. Include A26300 and split by flow.
Part 2. Nominal value
a. Insert X16109 Lease debt IFRS16 (incl.ST debt) Nominal value under X16108
b. Insert X16113F99 + Split per maturity flows
Part 3. Interest payments on LT loans
a. Insert X16129 Lease debt IFRS16 (incl.ST debt) Interest payment under X16128
b. Insert X16123F99 + Split per maturity flows
Reminder: IFRS16 leasing is a financial debt with a fixed interest rate.
L6810 – Commitments and contingencies given
...
L6605 - Borrowings by maturity
L6810 - Commitments and contingencies given
L6825 - Analysis of employee expenses
L6830 - Statutory auditor's fees and services
L6864 - Net Financial Indebtedness
L6880 - Overdues on receivables - Ageing balance
L7110 - Transactions with Related Parties
L4051 - Financial information for equity companies
BFC Actual 3 schedules for Equity method companies
L6810 - Commitments and contingencies given
L7110 - Transactions with Related Parties
...
This schedule is under the responsibility of the CAMFAC GL, for PF1 PF2 and WP1 systems.
In this schedule, the closing values of long term and short term borrowings are retrieved from Actual 2 package. It is then required to split the values according to their maturity (period where the borrowed money must be returned to the loaner).
The headings that need to be split by maturity are the following:
- Long Term (from 1 year to over 5 years): L16100, L16800, L16830 and L16810: is classified with Fixed Rate
- Short Term (less than 1 year): L51900, L57000 and L58200: is mainly variable rate but need to be confirm upon the loan.
Short Term portion of Long Term debt: L56000, L56010, L 56030: follow the rate of the Long term loan (Fixed Rate)
Changes in the schedule L6605 - IFRS16 impact - A report is sent by MAC to fill this information.
Part 1. Book value
a. Insert L16830 LT lease IFRS16 under L16810 LT lease debt
b. Include L16830 in sub-total "Borrowings > 1 year"
c. Insert L56030 ST lease IFRS16 under L56010 ST lease debt
b. Include L56030 in sub-total "Borrowings < 1 year"
Part 2. Nominal value
a. Insert X16109 Lease debt IFRS16 (incl.ST debt) Nominal value under X16108
Part 3. Interest payments on LT loans
a. Insert X16129 Lease debt IFRS16 (incl.ST debt) Interest payment under X16128
...
WP2 systems, also, the CAM needs to insert the values of guarantees, security interests and commitments given by the company for the acquisition of assets or other balance sheet items.
This schedule contains 2 parts:
1° - FAC GL - E6001 Commitments to acquire tangible and intangible assets (excluded Right of Use) - Extracted by BW through E6001 Template
In the first tab "Feuil1" - Click on Prompts and fill in accordingly and click ok
A filter on WBSE Syst. status should be done excluding WBS with status Closed and Technically completed and its WBS related to CAPEX (WBSE type IM) should include on this extraction.
Update the data tab with the relevant information take from the GAR List. In pivot tab, refresh de data after run BW prompt. Verify if there was any error, if not, please proceed with BFC upload.
2° - CAM - E6044 Security interests / bank guarantees - Each quarter Treasury Department will do Extraction of guarantees for GAR and forward it to all CAMs and FAC team- to know what must be declared in Actual3 schedule L6810 and which company must declare it the "Yes" must be selected in column "BFC disclosure".
The amount posted in the L6810 for the financial guarantees should correspond to the FARAWAY database of financial guarantees managed by Treasury. The "Fairway" database of the Treasury Dept. will contain the indication if it must be included in BFC and also by which company. The filing of the L6810 schedule must be based on Fairway. For most of your CAMs nothing would need to be disclosed as from Dec 2019.
Example:
- Filter on yes on column "BFC disclosure"
- Column P "Which party must declare it in BFC" give the company concerned
- if "principal" refer to column I and H "Principal code" "Principal Name" to retrieve the code
- if "guarantor" refer to column "L Guarantor Name" and retrieve the code of the company in the GAR list
- if "applicant" refer to column K and retrieve the code in the GAR list
- The amounts to report are in column R " Outset. Amount (end of day, base currency)"
| Anchor | ||||
|---|---|---|---|---|
|
This schedule is under the responsibility of FAC GL, for PF2 and WP2 systems.
Important: before the below step (extraction of the information from SAP) it is advisable to confirm if all the accounts that are included in the actual 3 headings are correct.
In transaction KAH3 - ZSOLV Please confirm that the accounts in the heading below are included in the Actual 3 headings
In order to compare please go to transaction ZZF_GL_BFC_Overview, just execute:
and then when you have a list of all the accounts, you can filter by heading and choose the actual 3 headings.
Also if for any reason a new account is created that should be included in Actual 3 please make sure it is included in the proper heading. For this please contact MAC Data Team .
Note: accounts use for Non-recurring entries (Flows F24/F37 and F56 should be excluded of Actual 3.
As the name implies, we need to insert in this schedule the values related with employee expenses of various natures, which can be found in multiple G/L accounts for each company.
To fill in the data, perform BFC extractions from ZZF_BFC_COLLECTIVE with variant B3_IAS19 SCO for PF2, WP2 and PI1.
After that run transaction ZZF_BFC_CONVERSION with the same variant B3_IAS19 SCO.
The last part is to extract the information in transaction ZZF_BFC_TRANSFER variant B3_IAS19 SCO, chose the path and run.
Note: Confirm the companies in your scope.
For those transaction check (and if needed change) the BFC Consolidation Parameter depending on:
ERP | Syensqo |
|---|---|
| PF2 | SYEP |
| WP2 | SYEW |
If you want to check the information extracted you can see by GR55 - Z4F1 report.
...
This schedule contains 2 parts:
- Commitments to acquire tangible and intangible assets (E6001) (excluded Right of Use)
- Contingencies (other headings) - Solvay will follow a lot more strictly the IFRS rules and a large number of guarantees presented up to now in the note of the annual report will be removed.
The amount posted in the L6810 for the financial guarantees should correspond to the FARAWAY database of financial guarantees managed by Treasury. The "Fairway" database of the Treasury Dpt will contain the indication if it must be included in BFC and also by which company. The filing of the L6810 schedule must be based on Fairway. For most of your CAMs nothing would need to be disclosed as from Dec 2019.
Each quarter Treasury Department will do Extraction of guarantees for GAR and forward it to all CAMs - to know what must be declared in Actual3 schedule L6810 and which company must declare it the "Yes" must be selected in column "BFC disclosure".
...
This schedule is under the responsibility of FIN OPS, for PF1 and WP1 systems.
As the name implies, we need to insert in this schedule the values related with employee expenses of various natures, which can be found in multiple G/L accounts for each company.
To fill in the data, enter transaction GR55 and call up report Z4F1 (Balance Sheet)
Afterwards, select the closing period and the company that you are closing. Run the report
After executing the report, select the field "BFC – Personnel Cost" on the top left corner.
You can now fill in the headings inside schedule L6825.
The values The values should be filled in with opposite signs (if positive in SAP, it should be negative in BFC and vice-versa).
In case a heading has no values, we should insert the amount as 0. If not, it will generate a blocking control.
...
Data are in local currency and not in K local currency !!!
Important: If we compare the BFC data to GR55 Z4F1, there can be discrepancies. These discrepancies are due to the exclusion of the restructuring costs (based on the specific restructuring costs centers codification - PF2 EE812/ WP2 CCCC-81 and ZFR3-82*) (for the companies where Restructuring provisions do exist) and also to the Defined contribution costs reclassification of the US).
Freinage costs reclass - cancelling from Social Security contributions to the Defined Contribution Expenses (from ACTUAL3 heading X9920 to X9923).
For US and Canada, Defined contribution is not recorded in a dedicated P&L account. We need to change in BFC from ACTUAL3 heading X9920 to X9923.
Open the Payroll file for US and filter for the following wage types:
3EZ1, 3EZ2, 3EZ3, 3RC1, 3RF0, 3RF1, 3RF4, 3RF5, 3RF6, 3RF7, 3RF8, 3RF9, 3RR0, 2588 and accounts
WP2 : 98320122 (US fringe) 98320241 (Payroll posting)
PF2 : 6220003320
For Canada the Wage type is 3R12, account 98320219
Then in BFC fill in X9923 that is empty with the amount found above. Remove the same amount from X9920 (The total Employee expensed does not change).
You need to fill X9935 and X9936 only - the rest of headings are obsolete for use, as are disclosure details of mentioned 2 headings.
X9935 - Audit fees- certification is the audit amount listed in Schedule 4 - negotiated and fixed amounts with the audit service provider for CENTRAL, LOCAL and COLLEGIO SINDICALE (Italy) audit fees that should be accrued in your books.
To identify amounts: go to the FBL3N and select all items for period 01JanYY -31DecYY.
PF1 2322010000 6450020000
WP1 40150310 98300350 (some entities may use different BS 46900400/ CE 98340500)
To validate amounts: go to AoDOCs Library and for X9935:
X9936 Audit Fees - additional missions is the Non Audit Service amounts that should be validated and authorized by Audit Committee - advisory/ consultancy/ etc. provided by auditors. The amounts should be in line with the AoDocs Library information.
At the end of financial period FA SU should issue preliminary report to all Country Accounting platform population on the Non Audit Services pending items to be accrued if the invoice still pending to be processed and to check the existing records for reporting needs.
...
| Anchor | ||||
|---|---|---|---|---|
|
This schedule is under responsibility of FIN OPSACP for PF1 system (can be verified by the CAM and adjusted if needed) and CAM for WP1 system.
In this schedule, the values to be justified and split are being extracted from Actual 2, namely items held with third parties (partner S9999).
If there are values reported under headings L16100 or L16800, we should also specify the type
Finally, for this schedule, we will need to provide further details on these items, namely the currency and the interest rate applied to the heading (between fixed rate, variable rate or no rate).
The currency can be obtained by checking in SAP the corresponding accounts under each heading.
If it is unclear where to fill in the data when filling the details by rate, we can perform the following split:
-Long term headings should be classified as Fixed Rate
-Short term headings should be classified as Variable Rate in the general case (but we can have some specificity depending of the loan.)
-Short term portion of a long term loan should be classified as the the original long term loan meaning fixed Rate
-Accruals should be classified as No Rate
, namely items held with third parties (partner S9999).
If there are values reported under headings L16100 or L16800, we should also specify the type
Finally, for this schedule, we will need to provide further details on these items, namely the currency and the interest rate applied to the heading (between fixed rate, variable rate or no rate).
The currency can be obtained by checking in SAP the corresponding accounts under each heading.
If it is unclear where to fill in the data when filling the details by rate, we can perform the following split:
-Long term headings should be classified as Fixed Rate
-Short term headings should be classified as Variable Rate in the general case (but we can have some specificity depending of the loan.)
-Short term portion of a long term loan should be classified as the the original long term loan meaning fixed Rate
-Accruals should be classified as No Rate
As the information in this schedule is also reviewed by the CAM of the company, we can also contact the CAM to solve any doubts related with this schedule.
New headings:
T A26300 A29630 & ST A46300 A49300 headings:
- Added to Net Financial Indebtedness (EFN) definition
- Split per type of rate (fixed - variable - no rate) and per Currency requested
- Note: “Fixed” rate expected on IFRS16 sublease contracts
Corresponding blocking controls :
- Existing L68-010:
- Split per Currency must be exhaustive
- Existing L68-020:
Split per Type of rate must be exhaustiveAs the information in this schedule is also reviewed by the CAM of the company, we can also contact the CAM to solve any doubts related with this schedule.
| Anchor | ||||
|---|---|---|---|---|
|
This schedule has mixed responsibilities, depending on the headings to fill in:
-X04011 and X04061: CAM responsibility for both PF1 PF2 and WP1 WP2 systems
-X04051: FA SL InterCo FAC GL responsibility for both PF1 PF2 and WP1 WP2 systems
In this schedule, we will need to report for the above 3 headings the split of the receivables by overdue items and how long they have been overdue.
The values initially calculated are derived from Actual 2 package. Below the list of headings that are reported under Actual 2 and their correspondence to the 3 headings inside this schedule.
X04051X04061X04011 
...
After logging in, go to Folders – WCAP – Working Capital Solvay Group – 2 – Accounting / Legal BFC view and select the below workbook:
When the "Prompts" window appears, perform the following selections:
The calendar day should be the last day of the Quarter closing (example 30.09.2016 for Q3 2016 closing or 31.12.2016 for Q4 2016 closing).
After confirming the data entered, the system will automatically retrieve for all companies the values for each item and an upload file for BFC (found under sheet "L6880 Overd."), which can be uploaded directly to BFC (for explanations on how to upload the data to BFC, please refer to the procedure with code SBS-OP-DRTR-05-004) 
When the upload is done, the blocking control related with heading X04051 should disappear. 
be uploaded directly to BFC
When the upload is done, the blocking control related with heading X04051 should disappear.
A few additional remarks regarding the amounts to be filled in for this schedule (applies to all the headings):
Column E18 must correspond to the sum of the gross value of the trade receivables that are impaired (totally or partially) ... and only these one !!!
Column E19 must correspond to the heading A49100
Column E20 must correspond to the sum of the trade receivables on which NO impairment have been recorded
Column E01, E21, E22, E23 & E27 must correspond to the ageing balance of the NOT impaired trade receivablesA few additional remarks regarding the amounts to be filled in for this schedule (applies to all the headings):
-Values reported under flow E19 should have a counterpart posted in flow E18, with an amount greater than or equal to the amount of E19. This means that the difference between the 2 flows should never be below 0.
-For flows E21, E22, E23 and E27, we should have no values below 0. For the situations that we have values below 0 (due to credit notes, payments, corrections, etc.), we should adjust the negative amount by adding the corresponding value with counterpart of flow E01 (not overdue).
What to do in case the upload doesn't solve the blocking control
In some cases, the blocking control is not solved, even after the upload of the data, there might be a case where the headings reported in the balance sheet with impact on this schedule are different from SAP and BW.
To check this, we can use the BW query BW_QRY_MVFIWC01_0006 (can be found by selecting "Area" view and the following path: Solvay –> Financials Management and Controlling -> Financial accounting -> Working Capital -> Working Capital Virtual Layer ->FIWC: MultiSystemsMultisystem)
The fields to be filled should be filled as below (only differences being the Calendar day and the Company Code to be analyzed)
For the remaining headings, the CAM has to fill in the data using the same logic as X04051 – split by impaired / not impaired value and the value that is not impaired should be split between "Not Overdue" and specific dates when it is considered as overdue.
When the query is executed, the column "FC Pack vs BW" will give you the amount of the difference between BW and SAP. You can, after this analysis, sent a request to the CAM asking if the item can be corrected. Usually the correction is done against flow E18 (GV Impaired) 
| Anchor | ||||
|---|---|---|---|---|
|
This schedule has mixed responsibilities. The split responsibilities between FA SL, FIN OPS between FAC Interco, ACP and the CAM of the company is done below:
- PF1PF2/WP1 WP2 system:
- Heading X5010 Revenues – FA SL InterCo FAC Interco
- Headings X5040 Trade and other receivables - Net value and X5060 Trade and other payables – FIN OPS– ACP
- Headings X5020 Purchase of goods ans and services, X5070 Financial X5070 Financial loans and XCQ200T – CAM
All headings beginning with "X50" inside this schedule need to be filled in with open items that the reporting company has open with "Associated companies" and "Non-consolidated companies" (these companies are companies that use consolidation method 20 – Not Consolidated, 50 – ME – Equity Method, 60 – Not Equity Method, or 70 – Interests 10%-20%).
...
For heading X5010 Revenues – For PF1PF2/WP1WP2, the information is filled in by FA SL InterCo FAC Interco.
In order to provide the figures, an excel file has been created with the BW query needed to perform the extraction. This file can be found under code SBS-FRM-DRTR-05-120
The file needs to have "Analysis for Microsoft Excel" working in order to be able to refresh the data in the BW query. Detailed instructions on how to operate and extract the needed information can be found inside the Excel file.
For heading X5020 Purchase of goods ans services –
Data filled in by by CAM. Detail of goods and services purchased for "Associated" companies and "Non-consolidated" companies.
For heading X5040 Trade and other receivables - Net value – ACP - Run transaction FBL5N and select the variant SBS_X5040 (same variant in both systems). This will insert in the Dynamic Selections, all the companies that belong to the previously indicated Consolidation Methods (Non consilidate consolidate companies and Associated companies). To be sure that all companies are included correctly in Trading partner field you can check this information based in LEGAL ENTITIES MANAGEMENT, consider the open item until the closure period.
...
For heading X5060 Trade and other payables – ACP - Run transaction FBL1N and select the variant SBS_X5060 (same variant in both systems). This This will insert in the Dynamic Selections, all the companies that belong to the previously indicated Consolidation Methods (Non consilidate consolidate companies and Associated companies). To be sure that all companies are included correctly in Trading partner field you can check this information based in LEGAL ENTITIES MANAGEMENT, consider the open item until the closure period.
...
To fill in the data in BFC, follow the same steps as found for heading X5040.
For heading X5070 Financial loans – Data filled in by CAM. Detail of financial loans to "Associated" companies and "Non-consolidated" companies
For heading XCQ200T – Data filled in by CAM. If the company has any transactions with "Other related parties" with an amount of 100k€, the field should contain "1". If not, it should contain "0". 
| Anchor | ||||
|---|---|---|---|---|
|
...
End of document