Tasks to be completed when documenting an operation (from creation to publication)

 Prior Day Match Reconciliation in Quantum 

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

Responsibility area: Follow-up of payments.

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

Please remove the icon when not applicable.


ERP

4. Remove the icon(s) when not applicable

Please remove the icon when not applicable.
Frequency

5. Remove the icon(s) when not applicable

Please remove the icon 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



1. Objective and Scope

1.1. Objective of this Operation

I ensure the bank account reconciliation in Quantum. 


1.2. Scope

EMEA and NAM entities


2. Definitions

Definitions should be added in the Finance Glossary - Add definition and link it to respective Letter in Finance Glossary 

See Finance Glossary:

  • ...


3. Tasks description


3.1. I check the Prior Day Match report in Quantum.

3.1.1. I launch the Prior Day Match reconciliation in Quantum every day (the reconciliation should be completed until 8 AM LIS Time).


I use query EMEA Accounts

 and select the variant unreconciled accounts

To change the variant I select icon 



3.1.2. I analyze and justify all the unreconciled items related to all the bank accounts in the variant. 

I select each line corresponding to a bank account and currency and then to see the details I select tab "Flows".

On the left side of the screen there are the bank flows and on the right side the cash flows.

In the above example there are no bank flows but only cash flows. It means that there are no unmatched bank flows on that that day

but there is unmatched cash flow.

3.1.2.a. I analyze the cash flows

If there is any unmatched cash flow with value date the same day when I analyze the report

there is no further action needed, it will be matched automatically when we receive the bank statement the next day.  

In case there is any cash flow with value date in the past I analyze what is missing. 

I analyze the followings:

  • Was the bank statement received and correctly interfaced into Quantum?
  • Were the settlement and payment correctly done ?
  • Was the payment of the deal done according to the cut-off time of the currency?
  • Was there any issue at the bank side to credit/debit the amount on the bank account?

3.1.2.b. I analyze the bank flows

I analyze all the unmatched bank flows. 

There can be different scenarios as below

  • Manual payment via FAX (no deal recoded in Quantum)


I select "view details" by using right click

From the details displayed I see that it is referring to a manual payment. 

I proceed with the manual reconciliation by selecting the below icon

and select "New Actual"


I select instrument Bank matching Manual - Unknown

Then I select save and match. 

The item is reconciled as below 

  • Payment via Treasury Online


I find the clearing number 600* referring to the Treasury Online payment

so as there is no deal recorded in Quantum related to this operation 

I do the manual reconciliation as described above. 

  • Bank flow with banking fees

I check the amount of the bank fees and in case it is justified I do the manual reconciliation by selecting both lines and instrument Bank Matching Manual - Bank charges.

In case it is needed I contact the bank to get more information on the bank fees charged.

  • Bank flow with different value date then the cash flow 

I analyze why the requested value date was not respected by the bank and if I do not find any justification I contact the bank to request a value date correction. 

  • Recurrent bank flow with no cash flow 

I request the creation of bank matching rules for the automatic matching. 

3.1.3. I inform the International Treasury Team in case there is any significant amount remained unreconciled until 8 am Lisbon time. 

...

End of document.