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.

The objective of the document is to explain the bank reconciliation process for Brazil companies.

1.2. Scope

This procedure applies to BR companies: 7523, 6375 and 6511.

2. Definitions

See Finance Glossary:

• Bank Reconciliation

3. Tasks description

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

To check the bank statement balance you will use the SAP extract account (starts with 51000xxx, where the ‘xxx’ is defined by bank: e.g. 51000104 for the Itaú bank statement account).

Banco do Brasil - 51000100  ; Caixa Eco. - 51000102 - ; Bradesco - 51000103 ; Bradesco Energia - 51000219 - ; Caixa Eco SP - 51000494; Bradesco Itatiba - 51000768 ; JP Morgan - 51000769 ; CityBank - 51000803 ; Caixa Eco 51000918

Go to transaction FS10N:

Complete the fields: 

. G/L account

. Company code

. Fiscal year

Then you have to access the bank statement to check the balance with the transaction FS10N as you see below.

Example: Itaú Bank Statement

In the SAP

Look for the Accumulated Balance (Cum. Balance) in the period analyzed to compare with the bank statement. To do the balance control, fill the file “Planilha Saldos XX_20XX”, depending on the period, located in  Drive.

In this file, you can identify the bank by SAP account or bank account: The sum of the Automatic upload bank statement and the SAP statement account must be “0.00” (zero).

Proceed with the same steps with the other bank accounts.

If there is no automatic upload, we use the "Global Posting File" file to make bank statement entries: (e.g. 51000104 for the Itaú bank statement account)

• Bank statement:
  

• Transitional accounts 

          Starts with 5006xx - Payments

                            5005xx - Income

                            5099xx - Others

• Template (Scope, Currency & SK Document)

3.1.2. I perform the bank reconciliation

The bank reconciliation is made only with the transitional accounts (the one that starts with 5006, 5005 and 5099). In general, to perform the reconciliation you have to compensate documents type SK (bank documents) only with others documents types.

 Go to transaction F-03

Complete the fields:

. Account

. Clearing date (always the day before the current date)

. Period

. Company code

 ENTER:

You will see all the documents that are open in the account selected. To compensate the documents, you have to select them and go to save the clearing. Remember: In general, always select documents type SK with another documents type.

The sum at the end (Not assigned) must be “0,00” (zero).

Click in the icon 

Insert the reference BO-RECONCILIATION and save   .

3.1.3. I use the settings for reconciliation

Documents Type

SK: Bank Statement

Others Types ZP, DZ, DR, SB, ZC, KR, KZ, H1, G1…: The accounting document

End of document.