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: 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




Previous operation << >> Next operation



ARA Dashboard User Guide:

Qlik Sense path:

https://qliksensedev.solvay.com/solvay/hub/stream/e51a77ce-5738-4648-8ac6-d0cf287907c8


The ARA OPI Dashboard has the following sheets:

Explanation of the sheets:

1- Sheet: Total Reconciliations

In this sheet we have 3 differences graphs:

1° - This graphic provides the total number of reconciliations (manual and automatic) to be done per month.

2°  This graphic provides by period the percentage of what has been reconciled automatically (in blue), manually (in yellow) and wasn't reconciled (in red).



3° This 3rd graphic sheet provides the % of automatic, manual or not reconciled item accounts by each team. 


Data are cumulative of reconciliations performed by each team. 


2 - Sheet: Total of Reconciliations by Type


This sheet provides the total number of reconciliations taking in consideration the type of reconciliation – Automatic, Manual and Semi-Automatic.

Automatic Reconciliation: When the reconciliation of the accounts is performed by the system (example: accounts without balance or within threshold that are closed automatically)

Manual Reconciliation: When the reconciliation is performed manually by the reconciler

Semi-Automatic Reconciliation: When the reconciliation is done manually by the reconciler but there are some reports that are attached automatically by the system in the account item (example: roll-forward of assets is automatically attached)

In this tab you can perform filters according to your requirements:


3- Sheet: Trend of Reconciliations

This sheet provides an overview when the account items by period were reconciled (Example: % of reconciliations done between D1 and D5 for the period 2021-03). 

This timeline enables us to see that most of the accounts are reconciled in a short period of time. 





4-  Sheet: Internal Control

This sheet provides the list of not reconciled accounts that are under the scope of the Internal Control defined for ARA (High risk accounts for Key Legal Entities). This will allow an easier way to perform a follow up on the Internal Control.

The data is compressed but if you click on you can see the different layers of information:



Good Tips to navigate in qlik sense:

To change to another sheet go to the following field( i.g. Total Reconciliations):

To make the filters you need to go to: 

You can filter by each dimension:


Select the dimension that you need to filter and select the criteria and click on the







End.