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. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow |
| Domain: Country Accounting |
Responsibility area: N/A |
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)
1. Objective and Scope
1.1. Objective of this Operation
The purpose of this document is to explain how to check the variation in stock accounts (Balance sheet) compared to the consumptions in 6* accounts in the P&L for specific cases.
1.2. Scope
This procedure applies to all BE companies.
2. Definitions
See Finance Glossary:
- Add if necessary
3. Tasks description
3.1. Responsibilities
Responsibilities of Finance Operations:
- Check the variation of stock at D+6 in a monthly basis for all Belgium companies;
- Post the correspondent adjustment, in the last day of the closed period, to correct the variation of stocks on a monthly basis;
- Check if the variation of stock was corrected after the posting.
Responsibilities of Local Finance:
- Check if the adjustment posting done has been performed correctly.
3.2. I run the report S_ALR_87012284
Go to report S_ALR_87012284 and choose the variant below by clicking in
Company | Varient |
|---|---|
| 1 | 0001_STOCK CTR |
| 5 | 0005_STOCK CTR |
| 237 | 0237_STOCK CTR |
| 5978 | 5978_STOCK CTR |
| 5985 | 5985_STOCK CTR |
Only for cy 0001 the variant is: REAL STOCK BE |
In the report, fill as the example below for, choose your company code and execute
Extract the outcome to Excel:
- Export - Spreadsheet
1) Select - Excel (In Existing XXL Format)
2) Select - Table
3.3. I check the absolute difference
Task performed in quarter basis, Timing defined in closure after receiving the last invoicing.
Stage 1
We should check the absolute difference between the value that is accumulated until the month that we are analyzing and the total amount of the stock in beginning of the year (that is the amount in stock in the end of the previous year ) as the example for month 06 2008:
Look for the account 2010010000 Produits finis achetés-val acq MM
The value marked in red should be compared with the following 6* accounts from P&L by doing the sum as demonstrated:
200806
+ B: Var en-cours fabric, PF et cdes 71 +1.243.265,18
- 609400001 Variation ETC -(-119.227,88)
+ 2.Variation des stocks +(-2.159.515,82)
+ 6310000000 Stocks-réd val + 0
_______________________________________________________________
Total Amount -797.022,76
Now we should compare the Absolute difference in Stocks with the Total Amount :
786.513,39 + (-797.022,76) = - 10.509,37
This means that we have to do a posting to adjust the variation of stocks in 6* accounts according to the total variation in stock accounts (balance sheet).
Before doing this adjustment, check if the last invoicing has run for all the Belgium companies in the quarter and if there are no pending movements with the concerned company.
This check is automatically done in the template file attached.
Stage 2
Perform the following operations in posting file attached.
Copy the Excel extraction and paste it in sheet “Report”.
In sheet “Calculations” insert the report date on cell F3 with format DDMMYYYY (the last day of the closed month will be the posting date. Fill in the yellow field with the concerned company code in cell F10.
Save it and upload it through transaction ZZF_POSTING_FILE.
When a company has a balance in accounts 6310000000 and 6311000000, this amount should be accounted as well for the calculation of the adjustment:
|
Attach the excel file extracted in report S_ALR_87012284 justifying the calculations made to the document posted.
3.4. I perform the ETC check
This check is done for company 0001.
We should check the absolute variation between the value that is accumulated until the month that we are analyzing and the total amount of ETC in the beginning of the year as the example below for month 06 2008.
Look for the cell with the account B. Commandes en cours 37 :
2170000000-Commandes en cours d'exécution
2140000000-Stock ETC
2160000000-Acomptes verses s/achats sur stocks
The value marked in red should be compared with the following 6* account and 7* account from P&L by doing the sum as demonstrated.
+ 609400001 Variation ETC +(-119.227,88)
+ 7446400001 Acomptes sur ventes ETC + 15.958,17
___________________________________________________________
Total Amount - 103.269,76
Now we should compare the two values of the Absolute Difference and Total Amount
103.269,76+ (-103.269,76) = 0
In this case the check is ok and there is no posting to do.
This check is automatically done in the Link file attached .
Normally this check should be ok, if not please contact Olivier Gaspar for company 0001. |
3.5. I perform the final check
After the posting we should check again as in the previous steps the report S_ALR_87012284 .
This check can be done manually as described before or it can be done with the support of the excel file as described in page 7.
In sheet “Calculations” the adjustment posting should be equal to:
|
End of document.