This document has the objective to show the FEBAN transaction process.
Click "Enter"
Select the document that you want to compensate clicking twice in the numbers,
Responsibility area: N/A
Table of contents
Scope
ERP
Frequency
References
Forms
Attachments
<< CL: Bank Reconciliation >>
1. Objective and Scope
1.1. Objective of this Operation
This document has the objective to show the Bank reconciliation process.
1.2. Scope
The procedure is applied to company 7725 and 7722 in WP1.
2. Definitions
See Finance Glossary:
- ...
3. Tasks description
Master Data Accounts.
DETAILS ON HOW TO POST FROM BANK STATEMENTS.
In WP1, the posts from the Bank Statement are made in bank statement accounts (51000***) and transitory accounts (50060*** for payments; 50050*** for income ; 50990*** for others) in SAP.
For some accounts the posting is automatic, but for the accounts which the posting isn't automatic, posts must be made manually.
For automatic posting to be counted, you must go to the FEBAN transaction, and release according to the instructions:
Every movement in the bank statement is posted in the account 51000***, the last three digits correspond to the bank. This account in SAP is a "mirror" of the bank statement and its parameterized not to be cleared.
The movements in the bank statement will always be posted in the account 51000*** and its counterpart in one of the transitory accounts, depending on the nature of the movement (Payment, Income or Others).
When it is a Payment:
(50) Credit 51000*** - Bank Statement
(40) Debit 50060*** - Payments
When it is a Icome:
(40) Debit 51000*** - Bank Statement
(50) Credit 50050*** - Income
Posting when automatic upload does not recognize the parameters of the other two accounts:
(50) Credit 51000*** - Bank Statement When it is a Payment
(40) Debit 50990*** - Others
(40) Debit 51000*** - Bank Statement When it is a Income
(50) Credit 50990*** - Others
Example:
There is a Payment in the bank Citibank, company 7725
Bank Statement information:
Document posted in SAP after bank statement upload:
It is the same for every movement in the Bank Statement.
How can be done the bank conciliation
In WP1 conciliation, the compensations of bank reconciliation are done only in transitory accounts.
*E.G.: 51000797 is a statement account of Itaú and 50020797, 50050797, 50990797, 50010797 and 50060797 are transitory accounts of this statement account (Citibank)
*When the account has a check mark in the left side in SAP, this means that the account can't be compensated.
The day in compensation is always the day before the currently day,(yesterday or Friday if is Monday).
E.G.: today is Monday 18/09/20xx, I will do the compensation of the Friday 15/09/20xx. This happens because the bank movimentation is uploaded to SAP only in the end of the day, so the information about today will be uploaded in SAP just tomorrow or next working day.
In the transitory accounts we have the bank posting (document type SK) and the accounting posting (ZP, DG, DZ, ZC, SB, G1,H1,... Etc.)
To compensate the transitory accounts, we always compensate a bank document (SK) with other type of document. Never SK with SK.
To see all the open items in the transitory accounts use the transaction FBL3N:
In FBL3N.
Select the variant '7725_CONC_CLP' which will fill the G/L account, company code, and posting period information.
Run 
Posts that can be compensated.
E.g. 01: Payroll. Account 50060797
Always compensate a document SK with a document of different type - ZC, G1, DZ, DG, SB, G1, H1... Etc
The transaction used to compensate the documents is F-03.
Fill the account, date, period, company code and currency.
Click "Enter"
Select the document that you want to compensate clicking twice in the numbers.
*If the field "Not Assigned" is 0,00, then you can compensate the documents,
To compensate, click in the icon 
Fill the field "Reference" with BO-Conciliation check if the value is 0,00 (zero),
Save
End of Document.
3.1. I do something...
3.1.1. Step 1 of Task 1 (I do something...)
3.1.2. Step 2 of Task 1 (I do something...)
...
3.2. I do something...
3.2.1. Step 1 of Task 2 (I do something...)
3.2.2. Step 2 of Task 2 (I do something...)
...