| Hide If | ||
|---|---|---|
| ||
Tasks to be completed when documenting an operation (from creation to publication)1. Enter the Title of the operation / page2. Add the following Labels :
3. Fill in all fields as described above4. 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 |
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
| Domain: Country Accounting |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Responsibility area: N/A |
Table of contents
| Table of Contents | ||
|---|---|---|
|
| Panel | ||
|---|---|---|
| ||
ScopeERPFrequency
ReferencesFormsInvestment _ Equity check - Template Attachments<<
|
1. Objective and Scope
1.1. Objective of this Operation
The aim of this report is to provide an operational guide to reconciliation of Investments and Borrowing to US companies. The US Company 4290 has Investment in some companies of Solvay Group. The monthly equity method is recorded on alpha numeric accounts, respecting the accounting rules that says that we cannot report interest in activities within the same company. It has to be performed right after the closing is done.
1.2. Scope
Solvay Chemicals, Inc. (4290); Solvay Soda Ash Joint Venture (4291); Solvay Soda Ash Expansion JV (5650) and Solvay Chemicals Elimination (ZUS1).
2. Definitions
See Finance Glossary.
3. Tasks description
3.1. Responsibilities
SBS Responsibilities:
- Retrieve the data in SAP and make the needed analyzes.
3.2. Periodicity
- It must be performed monthly on D+8.
3.3. I retrieve and update the data
3.3.1. I retrieve the data
Enter in the transaction S_ALR_87012277 and insert the variant US_SCI_CHECK. The variant will fill all the accounts needed for this check, which are 1530000000, 1700200000, 2000030000, 2200008610, 2201000000, 2300000060, 2700100000, 2731100000, 3000000000, 3012000000, 3012000010, 3012000011, 3012000020, 3012000021, 3031204000, 3031204001, 3031300002, 3031300003, 3042000000, 3042100000, 3042200000, 5105004291, 5105005650, 5200004290, 8151004291, 8151005650, A532000000, C042000000, C042000002, C042000010, C042100000, C042100001, C042100010, F960000001, 2700100000, 2731100000, 3020003904 and 3031300001.
It will also include the company codes 4290, 4291, 5650 and ZUS1, the current Fiscal year, the Reporting periods, which is from January until the last month closed. Execute it.
Once the report is generated, save it in a excel file. Go to System > List > Save > Local File. Save it in your desktop as .xls type.
Copy and paste all the information 'only values' in the tab S_ALR_87012277 in Investment _ Equity check - Template. Include or exclude lines if it is needed, just to keep this tab organized and clear.
After that, enter in the transaction AR01 and insert the variant SCI-CONCIL. This variant will fill the fields Company with the code 4290, the Asset number 350000004291, 350000005650 and 350000006028, the Report date is the last day of the last period closed, Depreciation area as 42 (Write-down L) and Sort Variant 0001.
Once the data is generated, copy and past the information related to the assets in the tab Manual input.
If the total filled manually does not match with the total of the account A532000000 ( Extrated S_ALR_87012277), the cells will be filled in red. If it happens, make a double check in the amounts filled.
Below the table related to assets, there are few other tables that have to be filled as well. Most of the information is needed only once a year, but the information related to the heading L12000 and ZFC-L100-E need to be updated monthly.
Use the transaction GR55, Report group Z4F1.
Fill the Fiscal year, the period and the company code. Execute it.
Find out the headings L12000 and ZFC-L100-E. Copy the accumulated amount and past it in the respective field in the tab Manual input. Repeat it for all companies.
Compare the information filled with the information on tab Reconciliation L12000 Current Year (Income) / Loss (Z4S1) Before MI and Check Net Equity (Z4F1 Cummulative).
In case the information does not match, the field related to the company will be filled in red.
Regarding to the account 1530000000, use the transaction FBL3N to retrieve the information. Include the company code 4290, G/L Account 1530000000 and the open items as the last day of the closed period.
Include the column Assignment in your layout and make a subtotal on this. The total per Assignment is what you must fill in the respective field. The balances use to change once a year, generally in December.
Regarding to the account 3042100000, it does not have a pattern. Thus, keep the current balance related to the other periods and update only the current posting according to the Assigment, where SSAEJV is the trading partner 5650 and SSAJV is 4291. The balances use to change once a year, generally in December.
Regarding to the account C042100000, it is the same as the account 3042100000, keep the current balance and update it when needed according to the Assignment. The balances also change once a year, generally in December.
Also, if any of the accounts is not matching with the information extracted in the transaction S_ALR_87012277, it will be filled in red.
Regarding for both accounts (3042000000 and 3042100000) in both companies (4291 and 5650), the split between the SCI and Asahi is only a percentage, being 80% to SCI and 20% to Asahi.
To have the correct amount, use the transaction GR55, Report group Z4F1, the same way as retrieving the information related to L12000, but looking for the account instead. The balances use to change once a year, generally in December.
Regarding to the account 3012000000, it does not have a pattern. Thus, keep the current balance related to the other periods and update only the current posting according to the Assigment, SSAEJV and SSAJV. The balances use to change once a year, generally in December.
In the tab Reconciliation, there are all information filled before, split by company per column. So, all the information that has to match between the companies 4290, 4291, 5650 and ZUS1 are filled with different collorscolors. For example, all the accounts that have to match between 4290 and 4291 are filled in yellow.
If it is not matching there is something wrong, either the information related to manual input or something was posted incorrectly in SAP and it has to be corrected as soon as possible. Also, all the cells filled in red means that something is not correct.
The pink check (A and B) are related to the investment and gain/loss between the companies. In the company 4290 it takes all the accounts filled in yellow or blue, depending the company that it is going to be compared with, and the total invested by the company ZUS1, which are the accounts filled in green. In the other company it takes the total of the heading L12000 less the RNSC, per year.
There are a few more few checks and it can be followed by the letters. Most of them must be zero, except the letters K and L that are rounding, the letter M that has to be equal to the total of gain/loss of the company ZUS1, and O and P that is the same amount as the Minority Interest posted.
3.3.2. I inform CAM and Controllers.
Send a case to CAM and Controllers with the excel file attached.
End of document.
| Viewtracker | ||
|---|---|---|
|