At the period end your banker will give either an electronic statement or a manual statement. If you are getting an electronic statement then your job will become easier for the preparation of bank reconciliation statement if you have done your configuration right. You can also do your own development by which your sap system will be integrated with the bank system and online you can get your bank statement to sap. Most of the bigger companies are getting there bank reconciliation statement in this way. If you are getting it over mail or from some other source then use transaction FF_5 to import it to sap.
After importing the statement you need to process it for getting bank reconciliations statement. When you execute a BRS, it will post automatic posting to the general ledger (GL) account based on your configuration.
You can import electronic bank statement received from your bank in to sap by using transaction code FF_5 or following path;
SAP Menu > Accounting > Financial Accounting > Banks > Incomings > Bank Statement > FF_5 – Import
You need to enter following details;
Statement file: mention the path where the file exist (document header)
Line item file: mention the path where the file exist (document line items)
BELNR number interval: specify the search criteria (you can also enter different range applicable to you)
Now from the main screen select print posting log, print statistics and print bank statements
Press execute or F8
Then you will be displayed with the posting log. You can analyze it.
You can use transaction code FEBA to check whether all the documents are posted or not.
You can use transaction code FF68 for manual cheque deposit or use following path;
SAP Menu > Accounting > Financial Accounting > Banks > Incomings > Check Deposit > FF68 – Manual Entry