Versions Compared

Old Version 6

changes.mady.by.user Ramos, Fernanda

Saved on

compared with

New Version Current

changes.mady.by.user Ramos, Fernanda

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Hide If
groupconfluence-users

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

    • 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. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow 


Panel
bgColor#F7F7F7
titleColor#ffffff
borderWidth1
borderStylenone
Domain: Central Finance Processes & Compliance
Panel
bgColor#F7F7F7
borderWidth1
borderStylenone

Responsibility area: I prepare the figures to be reported for the monthly KPI in Qlikview

Table of contents 

Table of Contents
maxLevel2


Panel
borderStylenone
Scope


ERP

To be confirmed!(error)

Frequency

 

 

 To be filled!(error)

References


Forms


Attachments

8. Add the link to attachments or external links



I close the reconciliation accounts <<

Page_title
>> I train all end users in the process and tool



1. Objective and Scope

1.1 Objective of this Operation

We have defined threshold to close accounts with non-significant balance which should not be reconciliated (KLE=25K€/ NKLE=35K€).

1.2 Scope

Key legal entities

Non Key legal entities

2. Definitions

See Finance Glossary:

  • Add if necessary


3. Tasks description


3.1. I prepare the template to identify which accounts attend the treshold

We have 6 templates to be used according reconciliation month


Templates

WP1 KLE

WP1 NON KLE

PF1 KLE

PF1 NON KLE

PI1 KLE

PI1 NON KLE


3.1.1. I update the exchange rate

Use the information sent by BFC Admin or the Adoc file



3.1.2. I make the extraction and filters on template 

To extract from SAP the data go to /n/bsar/menu and “Audit” tab.

Image Added
In selection only choose month and year and extract full data.
When data is retrieved change to layout “Threshold”

Image Added
Copy paste to the calculation file

Image Added


On filter exclude on table the option below:


Do not consider for the threshold following accounts:

STATUS CLO + REV
AUTOCERTIFY
GROUPED
BANKS (PR) (WP1 e PF1) to PI1 A500* acc items
HR L600-100/L600-200/L600-300
RULE ENGINE


On filter Absolute Amounts make the filter according to the value:




4.1. I prepare the macro to close the accounts automatically.

We have a macro file to enter on SAP insert a comment and close the accounts automatically.

Macro file link

Based in the previous template you will copy and past  the following information on Macro file


After update every column as above I click on box Update ARA.


** This process should be run to WP1, PF1 and PI1.





End of document.

Viewtracker
hidetrue