Authorizations & Roles
Author(s) | Verification | Approval |
João Saramago | Madalena Freire | Pascale Vauchez |
23-12-2016 | 30-12-2016 | 06-01-2017 |
Version Control
Version | Date | Description |
01 02 03 04 | 06-11-2016 25-11-2019 08-01-2020 10-01-2020 | New Document Revision Revision Revision |
Table of contents
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.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
The purpose of this document is to provide the guidelines to fill in BFC Actual3 package.
This operating procedure (OP) applies to all the companies under the scope of FA SL Service Center.
(…).
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
The BFC Actual 3 package has split responsibilities between FA SL, FIN OPS 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.
BFC Actual 3 is required for September closure and December closure. The deadlines for the publishing of this package are communicated by GAR.
The following BFC schedules are reported under Actual 3:
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
L6810 - Commitments and contingencies given
L7110 - Transactions with Related Parties
This schedule is under the responsibility of FA SL, only impacting NAM/LAM companies under the scope of FA SL.
For this schedule, we need to report balance sheet and for P/L items that our companies have with companies that are consolidated under "Equity method".
This schedule is under the responsibility of the CAM, for PF1 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:
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
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
Reminder: IFRS16 leasing is a financial debt with a fixed interest rate.
This schedule is under the responsibility of the CAM, for PF1 and WP1 systems.
In this schedule, 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:
- Commitments to acquire tangible and intangible assets (E6001)
- 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 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.
This schedule is under responsibility of the CAM for both PF1 and WP1 systems.
In this schedule, it should be reported the costs related with auditing, split by type of fees paid. These values should contain ONLY fees paid to Deloitte.
This schedule is under responsibility of FIN OPS 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
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.
This schedule has mixed responsibilities, depending on the headings to fill in:
-X04011 and X04061: CAM responsibility for both PF1 and WP1 systems
-X04051: FA SL InterCo responsibility for both PF1 and WP1 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 
The information to be uploaded to heading X04051 is prepared with a BW workbook. To open it, go to the Start menu and select "Analysis for Microsoft Excel"
Select File – Analysis – Open Workbook – Open workbook from the SAP NetWeaver platform
When the system to connect is displayed, select WBP (Client 400)
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.
A 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).
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: MultiSystems)
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)
This schedule has mixed responsibilities. The split responsibilities between FA SL, FIN OPS and the CAM of the company is done below:
-PF1 system:
-WP1 system:
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 every transaction that your company has with another company (Revenues, Purchase of Goods and Services, Accounts Receivables, Accounts Payables, or Financial Loans) with one of these consolidation methods, you will need to report it in this schedule.
For heading X5010 – For PF1/WP1, the information is filled in by FA SL 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 – Data filled in by CAM. Detail of goods and services purchased for "Associated" companies and "Non-consolidated" companies.
For heading X5040 – 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. Warning: the variant contains all the companies for the system in the "Company Code" field. If needed, only insert the companies that you are responsible.
After the report is executed, insert the field "Trading Partner"
With this field, you will now be able to fill in the data by trading partner in BFC, by clicking on the "+" sign
When prompted, insert the trading partner company.
After clicking "OK", you will now be able to fill in the amounts related to that company.
For heading X5060 – Run transaction FBL1N and select the variant SBS_X5060 (same variant in both systems). This will insert in the Dynamic Selections, all the companies that belong to the previously indicated Consolidation Methods. Warning: the variant contains all the companies for the system. If needed, only insert the companies that you are responsible.
After the report is executed, insert the field "Trading Partner".
To fill in the data in BFC, follow the same steps as found for heading X5040.
For heading X5070 – 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".
SBS-FRM-DRTR-05-021 – procedure for DE Operating leases
SBS-FRM-DRTR-05-120 – procedure used for the filling of schedule L7110, heading X05010
End of document