Tips on configuring Memo record creation through bank statement load
Generally big organizations receives bank files daily and it is parked in AL11 folder. In cash management module it is critical to have updated bank balances in SAP.
Through intraday statements bank balance is updated in every 10-15 mins. But intraday statements only carries transactions in delta manner throughout day. So it does not contain opening balance of banks.
So opening balance has to fetch from previous days ending balance. From daily bank recon files.
Let’s see how to achieve that:
Below is sample BAI file format
This is processed file format, generally when file is received from bank it needs some correction.
In above file format you can notice from line 4, there are codes like 010, 015 & 045 and after this code there are some values.
Let’s understand what these codes stands for:
010 – opening balance
015 – closing balance
045 – total balance
So while creating opening balance memo record, 045 is crucial code. Value afterwards 045 code is considered as opening balance for memo records.
045 code balance is stored in FEBIP-TOTAL field and then it is considered for opening bal memo records creation.
Read eBook: Manual and electronic bank reconciliation in SAP
Checkout the configuration required for this:
- Require Planning level for opening balance
- In OT83 transaction BTC Internal external allocation for code 045 (see below screenshot)
Notice first entry in above screenshot for external transaction 045 with processing type 20.
Without this opening balance memo records will be created without any balance.
Once this setup is in place you can use same bank statement to upload as cash memo records and it will update opening balance of banks in cash management.
Read blogpost: What is MT101 file format and it’s application in SAP
