queries regarding SAP R/3 bank reconcilation procedure

rabbit_star

Hello everybody,

I have learnt sap before but got stucked in the process of bank reconciliation procedure.

Just wonder if anybody could tell me those bank reconciliation process steps (FF67 and F03), please?

Thanks a lot!

myABAP

    FF_5 - Import Electronic Bank Statement   FI - Bank Statement
    FF.5 - Import Electronic Bank Statement   Financials - Basic Functions
    FEBA - Postprocess Electronic Bank Statmt   Financials - Basic Functions
    BIC - Transfer Bank Data from BIC Database   Cross Application - Bank
    FEBAN - Bank statement postprocessing   FI - Bank Statement
    FEBP - Post Electronic Bank Statement   Financials - Basic Function

myABAP

SAP Bank Reconciliation Process

•    System provides automatically as well as manually, transaction reconciliation facility for all receipts and payment entries in the bank statement and our bank book.
•    System provides list of un-reconciled entries, for further decision making and matching.
•    In SAP system the reconciliation process is known under two methods, viz. Manual and Automatic.
•    Every Bank account will have 4 General Ledger Accounts. First will be a Main GL for the bank, second will be “Incoming clearing” for all receipts, third will be “Outgoing Clearing” for all Payments. and fourth will be “unreconciled account”.
•    After the reconciliation process, payment and receipt entries in the incoming, outgoing and unreconciled GL will be transferred in to the bank Main GL.
•    The balances in the main bank account will be equal to the bank statement amount.
•    The bank book balance shall be equal to the net balance of the all four bank GLs put together.


Manual Bank reconciliation Process – (FF67) (Non-electronic bank statement)

In case of Non-Availability of bank statements in the desired electronic formats, we can create and upload Bank statement manually.

Every bank statements that are entered will be per bank account number and are identifiable by a unique number and statement date to be provided by the user.

In the header data, Bank statement opening balances and closing balances are provided before creating the bank statement. This is the control check after entering all the lines in the bank statement.

After providing the bank statement header data, we need to enter or create the bank statement in the system. The bank statement data can also be copied from an excel file to create the bank statement in the system.

The system then automatically makes the postings to the bank account, bank clearing account along with the payment clearing. We have two options here:

Immediate posting (recommended)
Create a batch input session, then run it.

The posting of this statement or after batch input session. This process creates postings in the main bank account. The accounting entries are passed as mentioned below.

Main Bank A/c                     Dr
Incoming Clearing A/c                 Cr

Outgoing Clearing A/c                Dr
Main Bank A/c                     Cr.

Unmatched entries generated by the system are to be matched manually through (FEBAN). Later on these unmatched entries need to  be manually transferred to “Unreconciled Account”.

Electronic Bank reconciliation Process – (FF_5)

For the process of automatic bank reconciliation, electronic bank statement is required in pre defined format only.

This formats can be either in “multicash format” or “MT940

Uploading the bank statements received from banks in the above mentioned format using transaction code FF_5.

After the uploading of this statement, the process creates postings in the main bank account. The accounting entries are passed as mentioned above.

The un-reconciled items will remain as open items in “unreconciled account”  which can be reconciled manually.

Reprocess Un-reconciled items – (FEBAN)

•    Through this session we can clear the un-posted (un-reconciled) items from the above mentioned manual & automatic processes.

•    The session enables us to select any of the bank statements created by us based on statement date and identification key.

•    We can correct the selected items one after another. At the end, post again for all changed items.


SAP T Code To be used

Manual Bank reconciliation Process – (FF67)
Electronic Bank reconciliation Process – (FF_5)
Reprocess Un-reconciled items – (FEBAN)

Hellopicasso

楼上的说的好清楚了 再小小补充一个
自动的话， 如果有Electronic Bank Statement就用FF-5 post，需要银行提供mt940形式statement, 由人手动bai file上传SAP between main GL &incoming GL or outgoing GL. 如果公司把这个过程自动化了，SAP每天特定时间会去指定folder自己upload.那就很省事了

手动的话，可以用F-02或者excel posting.

然后就是clearing bank GL and vendor/customer account

F-03 clear GL account and open item
F-53 vendor payment clearing
F-52 customer receivable clearing

rabbit_star

myABAP 发表于 2013-7-15 20:01
SAP Bank Reconciliation Process

•    System provides automatically as well as manually, transactio ...

Thank you very much for those professionals who answered my queries.

I am still a little confused and not sure whether my understanding is right or not.

I would like to show you a scenario as shown below to confirm my understanding is correct or no:

AR:
•        record the incoming payment using F28
•        make a refund using F31
AP
•        Record an outgoing payment using F53
•        dispatch the automatic payment using F110

For those transactions such as bank charges, loan repayment, automatic debit payment we post it through GL FB50

Manual bank reconciliation process

After all those above transaction (incoming, outgoing, GL) has been done,   then we use FF67 for processing manual transaction. In order to use FF67, we need to create a batch input session (excel file with set headings), then run it.  I Just tried to imagine how the excel file should look like. Could anyone show me how the excel file will look like, please?

Those transactions will be matched manually.  At the end we need to use F03, F52 and F53 to clear those transactions clearing account.

Automatic bank reconciliation process

After all those above transaction (incoming, outgoing, GL) has been done,   we upload the bank statement with MT940 format through FF_5, Those transactions will be matched manually.  At the end we need to use F03, F52 and F53 to clear those transactions clearing account.

I tried to do the journals for AR, AP, GL as shown below but couldn’t finalised all of them. Could anyone check and give me some advice, please?

AR Journal                        
                        
DR        Trade Debtors               
CR                Sales                                   customer invoice
                        
DR        customer receivable clearing               
CR                Trade debtors                    incoming payment
                        
DR        Bank                                           After FF67
CR                Incoming Clearing        
                        
DR        Incoming Clearing                      F52
CR                Customer receivable clearing        
                        
AP Journal                        
                        
DR        expense               
CR                Trade Creditors                  supplier invoice
                        
DR        Trade Creditors                          outgoing payment
CR                Vendor payment clearing        
                        
DR        Outgoing Clearing                       After FF67
CR                Bank        
                        
DR        Vendor payment clearing              F53
CR                Outgoing Clearing        
                        
GL journal                        
                        
DR        bank charge/automatic payment/loan repayment        
CR             GL Clearing ?????                                             FB50
                        
DR        GL Clearing ????                                                     After FF67
CR                Bank        
                        
DR       ???                                                                             F-03
CR                ???       

After scanning through those notes, I still not sure what kind of unreconciled transaction could use FEBAN.    And when and how it could be used?  Could anyone show those steps for me, please?

Thanks you very much!

miaowu81

Mark

Harry_chu

SAP不会

Oracle还可以

rabbit_star

Harry_chu 发表于 2013-7-19 17:06
SAP不会

Oracle还可以

it's okay thank for replying my message