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

  Daily

 

 

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: 51000801 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 process the FEBAN transaction

The bank statement of these 2 accounts (51000801 and 51000823) are posted automatically, you should check in FEBAN transaction if the bank statement were uploaded correctly. 

If after perform the transaction, the transaction don't show any error you can start the next step.

If the FEBAN transaction show any problem, you should send an ticket to nutthanich.yingaree@solvay.com and inform that the bank statement wasn't process.  (eg. ticket #4690629)

You can see one example the FEBAN error below:


To correct the error, you can process the document manually. 

3.2. I perform the bank reconciliation

The bank reconciliation is made only with the transitional accounts, you will use the mirror account (510*) 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 documents uploaded 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, only when you posted documents incorrectly or charge backs *

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;




If the document header text and the reference are the same, so you can clear the documents.

To clear the account 50990801 you should reconcile the documents with the text "NOMINA SEMANA" and "INTERBANCARIO", usually the documents were sent weekly by Raquel De La Mora with document type "SB". The only action with this documents will be check the amount and adjust the assignment to clear in the transaction F-03. 

Besides that, once a month you must reclassify two documents to the correct accounts. These documents are uploaded automatically in account 50990801 and must be reclassified to the correct accounts. 

The first one is the document with text "GLOBAL BILLING", this document must be reclassify to the account 98546220. 

The second document usually are upload in the same day that the document and represent 16% of the document with Global Billing in the text. This document you must reclassify to the account 44700160, as the example bellow.  

Before clear the documents in transaction F-03, in transaction FBL3N you can change the assignment from these documents to facilitate cleaning.

To change you follow the next steps:

  • Select the documents;
  • Go to the bottom "Mass change";

And them, you change the assignments from the documents. 

 

After change the assignment you can clean these documents in transaction F-03. 

3.2.1. I clean the documents in G/L account

The bank reconciliation is made only with transitional accounts (5001*, 5002*, 5005*, 5006* and 5099). In general, to perform the reconciliation you have to compensate  documents type SK (bank documents) with other documents type. 

You can use this procedure to clean the documents:

F-03 - Clear G/L Account

--

Go to transaction F-03 and complete the fields:

In this example, I will use the documents from account 50060823, amounts 64.029,00 and -64.029,00 MXN. 

  • Select account: 50060823 (or account that you will clear)
  • Clearing date: 31.08.2020 (date from current month)
  • Period: (Same month from the clearing date - 08)
  • Company Code: 7723
  • Additional Selections: Others + Enter (We will select the option "Assignment")
  • Use the bottom Page Down (in your keyboard) to page 3. 


Them, you will use the assignment that you choose previously from these documents, and click in Process Open Items.


After you clean this documents, the G/L account shouldn't have any documents pending.  

End of document.