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: Country Accounting 1. Enter the Domain identified in OPD matrix (for Country specific operations, Domain = Country Accounting)



Responsibility area: 2. Enter the responsibility area described in OPD matrix ("N/A" for Country Accounting Operations)


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


ERP

4. Remove the icon(s) when not applicable


Frequency

5. Remove the icon(s) 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

1430 - Chemplex Consolidated Results BFC

Chemplex Intercompany AR and AP

BFC Packages_Status for Tax Dept_rev



Previous operation << >> Next operation



1. Objective and Scope

1.1. Objective of this Operation

WHY - Describe the objective of the operation

The purpose of this document is to explain how to perform the BFC input for Chemplex company in BFC tool.

It is useful to organize and certify everything was included correctly.

1.2. Scope

Detail the scope (legal entities, etc.)

This procedure is applicable to 1430 company code Chemplex in SAGE system, which is part of WP1 system.

It is done normally on D+3 after preparation of Consolidation file for Chemplex.

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 Populate The Actual 2 BFC

3.1.1. I Retrieve The Chemplex Consolidation File

Download the month file "MM.YYYY Chemplex Consolidated Results BFC" in folder 1430 - Chemplex Consolidated Results BFC.

3.1.2. I Populate The Base Schedules

  • L2005+L2010 - Balance sheet.
    • populate the balance sheet with figures in file "MM.YYYY Chemplex Consolidated Results BFC" prepared in another procedure. The figures are in tab "BFC vs TB" at the right columns BH and BI. It can be included with ctrl+C and ctrl+V;
    • After populate it, check the blocking inside the schedule, it should be only the P&L value is different than liabilities, because P&L is not populated yet;
  • L2018 - P&L
    • Include the P&L value with information in column BH and BI in tab "BFC vs TB". It can be included with ctrl+C and ctrl+V;

3.1.3. I Populate the Specific Schedules

  • L3005 - Intagible Tangible Assets Flow
    • In the excel file, tab FA and include the flows in each heading;
  • L3050 - IFRS16
    • The IFRS16 team in SBS sends a file in the email with the Chemplex part for IFRS16 named "MM.YYYY - IFRS16 Chemplex balance". Download this file and include the flows information. It is at the bottom of the file in tab "Resume", where it is located the headings L16830 (long term) and L56030 (short term);
  • L3025 - Inventory write-down
    • Enter in the Actual 2 from the previous month and include the same value in the current month. It will generate a difference. With this, include this difference in F25 if it is a credit (negative) or in F36 if it is a debit (positive);
    • For January, include the difference directly as the flows are valid only for the year. It is not needed to enter in the Actual 2 from previous month;
    • Do it or Trade Receivables Write-Down as well;
  • L3035 - Equity
    • Certify there is no control in this schedule by now;
  • L5610 - Current Assets - Intercompany
    • Check the values with partner with what was sent to intercompany team on D+2 in the other procedure;
    • in A5400, it can not have any value in third party as everything is with 7424 (company which Chemplex is included). If there is any value, it can be adjusted directly in the Balance Sheet schedule if the difference is slow (less than $3k). If there is a higher difference, check with CAM and Chemplex controller;
  • L5205 - Purchase/Disposal of Tangible/Intangible Assets
    • Copy from last month. If any sales, include the C01 in third party (S9999);
    • in A21900 - include the value in third party (S9999);
  • L6755 - Depreciation and Impairment charges by Activity 1/ F99
    • It is all allocated in X27203 - Depreciation services and miscellaneous - Lease;
    • Click on the control of the schedule to see the value to include;
    • Add the market OGIP and include the entire value here as well;
  • L2016 - Income statement by activity
    • Include all the values in the market OGIP;
  • L6710 - Acquisition of tangible & intangible fixed assets by Activity
    • Include all the values in the market OGCGU094 - Oil and Gas Unallocated;
  • L6725 - External payables and Inventories - Advances paid - Receivables on fixed assets disposals by Activity
    • Include all the values in the market OGCGU094 - Oil and Gas Unallocated;
  • L6720 - Fixed Assets - Investments - Goodwil / Activity
    • Include all the values in the market OGCGU094 - Oil and Gas Unallocated;
  • L6723 - Breakdown of lease debt and fixed assets (GV) by activity 2 - F20 / F30 / F60 / F56
    • Include everything in Oil and Gas;
  • L6735 - External receivables - Advances received by Activity
    •  Include in market OGIP;
  • L6051 - External sales analysis by Country/ Activity
    • Insert OGIP + country;
    • Check with Chemplex controller for a report that shows the external sales by country;

The controls are over, but some more schedules need to be checked:

  •  L5625 - Intercompany analysis on Sales and Royalties
    • Take the YTD intercompany sales in gdrive file Chemplex Intercompany AR and AP for the closing month;
    • If not access, check with CAM or Chemplex controller;
  • L5626 - Sales & Royalties analysis by Activity partner
    • Everything is OGNR and North America in R10000 (certify about that);
    • include R10000 + partner OGNR > insert members and ok;
    • The value is the same included in schedule L5625 by partner;

If any additional control appears, it must be investigated and cleared.

3.2. I Release the Package to Tax Review

3.2.1. I Release the Package to Tax Review

Populate the gdrive file BFC Packages_Status for Tax Dept_rev and send an email to CAM and tax team and attach the consolidation file "MM.YYYY Chemplex Consolidated Results BFC".

The subject can be "MM.YYYY Chemplex Consolidated Results BFC":

End of document.