| 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: |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Responsibility area: |
Table of contents
| Table of Contents | ||
|---|---|---|
|
| Panel | ||
|---|---|---|
| ||
ScopeERPPF2 WP2 PE2 PI2 Frequency
ReferencesFormsAttachmentsThis task should be performed monthly on D+3 twice after SAP vs Tagetik internal control. Attachments
<<
|
1. Objective and Scope
1.1. Objective of this Operation
The purpose of this internal control is to check the consistency of the data of Tagetik and BFC.
All data in Tagetik must the same as in BFC.
1.2. Scope
All companies WW with consolidation method Fully Consolidated and Proportionally Consolidated.
2. Definitions
See Finance Glossary:
- ...
3.
Tasks descriptionTagetik vs BFC Internal Control
Download the file attached Tagetik vs SAP MM.YYYY and follow the steps in "Read Me".
Save the file with MM.YYYY updated with the month we're closing - Example Tagetik vs SAP 03.2026
The internal control should be performed after the SAP vs Tagetik Internal Control in D+3.
3.1. BFC Data
Each month in closure, we receive the following email:
- Emails sent of D+3, D+4 and D+5 of every month
- Emails sent on an hourly basis on D+3 and D+4 and on each 4 hours at D+5;
After receiving the email from BFC save the file in your computer.
This is a text document so we need to format it to open in Excel
Open excel and open the txt document
In the first menu, use Delimited option , Semicolon and Text
Copy the data and paste it to BFC DATA sheet
3.2. Tagetik Data
Open Tagetik and the select the month we're closing in processes
Select detail summary tab, select one company and choose Forms
Open the form TM_TO_BFC
Select Filters panel and SAP and Non SAP node and refresh
Go to Utility tab and extract the file to excel and copy the file to Tagetik Data sheet
3.3. Calculation
This sheet will format the data of the sheets BFC data and Tagetik data, please ensure that the formulas are applied to all lines.
3.4. In Tagetik Not BFC
This sheet will let us know the data that we have in Tagetik but not in BFC. In case there is amount higher than 1000 EUR we need to upload the company to BFC.
The differences may occur when we upload the companies in D2 but there were corrections in SAP and Tagetik after and the company was not reuploaded to BFC.
Deselect the amount 0 in column F and H
It's normal to have the differences with the oxygen companies since the data of this companies is normally only uploaded to BFC on a quarter basis. Any other difference not related to Oxygen Companies it either needs to be justified or the company reuploaded to BFC.
3.5. In BFC Not In Tagetik
This sheet will let us know the data that we have in BFC but not in Tagetik. In case there is amount higher than 1000 EUR we need to upload the company to BFC.
The differences may occur when we upload the companies in D2 but there were corrections in SAP and Tagetik after and the company was not reuploaded to BFC.
Deselect the amount 0 in column F and H
3.6. Publish Internal Control
Once internal control is finished and all data from Tagetik is in BFC , save the file in our drive.
3.1. I do something...
3.1.1. Step 1 of Task 1 (I do something...)
3.1.2. Step 2 of Task 1 (I do something...)
...
3.2. I do something...
3.2.1. Step 1 of Task 2 (I do something...)
3.2.2. Step 2 of Task 2 (I do something...)...
End of document.
| Viewtracker | ||
|---|---|---|
|