(Is this operation concluded?)
In the "old" procedure the index has more titles than the ones in the text.
| Hide If | ||
|---|---|---|
| ||
Tasks to be completed when documenting an operation (from creation to publication)1. Enter the Title of the operation / page2. Add the following Labels :
3. Fill in all fields as described above4. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow |
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
| Domain: Country Accounting |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Responsibility area: N/A |
Table of contents
| Table of Contents | ||
|---|---|---|
|
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 codes code (3454,5696 and 0245).
2. Definitions
See Finance Glossary:
Add if necessary.
3. Tasks description
3.1. Periodicity
This procedure will be performed monthly at day D+4.
3.
12. 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****.
| Expand | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
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 SM35in SM35.
| Expand | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
3.3. I perform the reconciliation
Go to transaction FBL3N with with account O596013430, fill the company code. An after also for account O596033430.
- Open items: the day you are performing the bank reconciliation (D+4)
- Layout: /CONCILIAC
Execute the transaction 
Once you are inside transaction FBL3N do 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 and clear , account O596013430 and account O596033430.
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 and verify that the open item are only the amounts no reconcile and this amount should match the amount on transaction FS10N.
In case of the reconciliation is not zero balance, report them to Front Office (change Front Office)to Accounting Platform and CAM.
End of document.
| Viewtracker | ||
|---|---|---|
|