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 




Domain: Country Accounting



Responsibility area: N/A


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)

ZE1FGESTCONCI; SM35; FBL3N; F-03; FS10N


Forms

7. Insert the links accordingly and change the link text with the OP name


Attachments

BBVA Net Cash



Previous OP << >> Next OP



1. Objective and Scope

1.1. Objective of this Operation

This procedure explains how perform the Bank reconciliation for Spain. 

1.2. Scope

The scope is SPAIN company code (0245). 


2. Definitions

See Finance Glossary.


3. Tasks description

3.1. Periodicity

This procedure will be performed monthly at day D+4.

3.2. I extract the bank statements from BBVA Netcash

This procedure is done one time by month on the D+4 of each month. 
To have access to the bank statements enter in the web site of BBVA Net Cash. 
Once logged on site choose:

1) Información de cuentas

2) Módulo de tesorería

3) Histórico

4) Rango de fechas (the complete month for which we are performing the reconciliation)

5) Tipo de fichero (todos)


6) Aceptar


7) Select all (marcar todos)

8) Generar Fichero

It will be display another screen asking if you want to received the file. Select " Recibir fichero" and save in your computer. 


The document will be, by default, saved under name "Modulo tesoreria.ISM".

 


3.2.1. I perform the processes for Torrelavega

Once you have the file save on your desktop go to sap and enter in transaction ZE1FGESTCONCI.

Select Load file BBVA Torrelavega and execute the transaction. 

 


  • Posting date is the first day of the following month. 
  • File name – go to your computer and select the file extracted from Netcash.


Execute the transaction by clicking execute  and the list of documents will be produce. 

This doesn't mean that the documents were posted. The transaction generates batch inputs that have to be proceed in SM35.

Usually the batch codification is similar with ZE1FFIBBV****. 


After proceeded the batch input, return again to transaction ZE1FGESTCONCI.

Select Transfer Account SAP to Reflect Account Torrelavega. 


 


  • G/L Account- Fill with account 50601eur30 
  • Open items at key date: the date you are performing this task( D+4) 
  • For all the other fields no change is done.

Click the button dynamic selection .




Open the field Posting date and select the range all the month of the reconciliation.


And execute the transaction. 
This doesn't mean that the documents were posted.The transaction generates batch inputs that have to be proceed in SM35. 


3.3. I perform the reconciliation

Go to transaction FBL3N with account O596013430, fill the company code.  

  • Open items: the day you are performing the bank reconciliation (D+4) 
  • Layout: /CONCILIAC 


Execute the transaction 
Once you are inside transaction FBL3N do a subtotal  for Value date.
You have to do perform a analyse of what you can compensate:

  • Traspaso Agrupado with Traspaso Agrupado
  • Talon with payment of the bank
  • Recibo with recibo


Go to transaction F-03 and clear , account O596013430.

Go to transaction FS10N to verify the balance of the account for the month you are performing the reconciliation.


Go again to transaction FBL3N and verify that the open item are only the amounts no reconcile and this amount should match the amount on transaction FS10N. 

In case the reconciliation is not zero balance, report to Accounting Platform and CAM.

End of document.