This operation is applicable for the following entities:



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


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)

FEBAN

FBL3N

F-03


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

WP1 Bank Reconciliation: The bank reconciliation it’s a daily task that consist in ensure the information between the bank transaction and SAP records it’s consistent. 

With this control we guarantee the reliability, accuracy, confidence and control. 

The objective of the document is to explain the bank reconciliation process for accounts from 7723 company.


1.2. Scope

This operation is applicable only for 7723 company.


2. Definitions

See Finance Glossary:

  • Bank reconciliation
  • WP1



3. Tasks description

We have two mirror accounts in 7723 company, the account 51000801 that is used to pay the local bills, for example water, local tax, lodge card, electrical energy and the "PECA" account, 51000823, is used to pay the "pedimentos". These "pedimentos" are an specific tax that we paid for the local goods movements.

These mirror accounts will reflect in transitory accounts.



WHAT and HOW - Main content of the operation

The content should be mainly organized in 2 levels of Headings to ensure a proper link with the Table of Contents.

Select the level of heading in the "Paragraph" option.


3.1. I reconcile the banks

The reconciliation process is specific for each bank; however the general process is the same for all of them. The main guidelines are described in the steps below.


Regarding the specificities of each bank, they are included in the excel file attached to this procedure.

3.1.1. I check bank statement balance in SAP

To check the bank statement balance you will use the SAP extract accounts 51000801 and 51000823 in transaction FBL3N and check the balance until the current date.

Go to transaction FBL3N: 

Complete the fields: 

  • Accounts: 510000801 and 51000823
  • Company Code: 7723 
  • Open Items: (Current date)
  • Layout: /CONCILIAÇÃO

Then, you will check the balance with the transaction FBL3N with the bank statement, you should make an subtotal by G/L account and check the balance, as you see below.

In the SAP:

Example: Citibank Statement


3.1.2. I create the global posting file with bank statement amounts only from the "PECA" account 

After check the balance from SAP and the bank statement, you should create the global posting file with the new amounts from the bank statements and upload in SAP with the Global Posting File attached to this procedure.

After create the posting file you need upload the file by RPA posting.

3.1.3. I process the FEBAN transaction

The bank statement is posted automatically by the Thailand team, only from the account 51000801 and should be charged with FEBAN transaction: 

If after process the transaction, the bank 


3.2. I perform the bank reconciliation

The bank reconciliation is made only with the transitional accounts, you will used the mirror account only to check the bank statement balance. 



In general, to perform the reconciliation you have to compensate documents type SK (bank documents uploaded by FEBAN and with the global posting file) only with others documents types. Usually the SAP show the documents that will need be compensate in F-03, but you need to check if you could clean then or not. 

To check the documents posted you need check the transaction FBL3N.

* Important: You never shouldn't compensate document SK with another SK document. *

(A unica exceção são os estornos e lançamentos errados)

To check if you could clean these documents: 

  • Check if both documents are in the same G/L account;
  • Check if one of them are not SK;
  • Check if the amounts are the same;
  • Check if the documents dates are close;


If after check all these information, before to clean you will need check one more thing.

We recommended check if you have more than one document with the same amount, for example.

Go in the document KZ and click in the button , Environment and Payment Usage. 

And them you need to go in the document RE and click in the bottom ;


  • Check if the document header text is the same from the reference;

    *ajustar: este check é para todas.



If the document header text and the reference are the same, so you can clear the documents in transaction F-03.

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.