My second blog post on the subject of using account modifications in bank statements as well as my fourth on the subject of search strings in bank statements can be found here. At the end of this essay, I’ll include links to my earlier writings on the subject.
I’ll describe in this blog post how to set up a search string to find account modifications in bank statements. The following is a possible business scenario for this blog post:
– BTC 004, which is linked to a posting rule, is the BTC number that your bank is using to provide information regarding bank costs (e.g., Z-01).
– This BTC is subject to two different sorts of fees: an operating daily fee (for example, 1 EUR for each outgoing payment) and a monthly fee, which is a set sum imposed at the end of the month.
You wish to post monthly charge to one GL account and operating fee to another.
– A set sentence, such as “Month Cost,” is included in the bank statement for the monthly fee. Below is a screenshot of an example bank statement:
2. Customizing of account symbol & posting rule
Transaction OT83 defined posting rule Z-01 for bank fees and allocated external BTC 004 to it. An overview of the configuration is shown in the photos below:
Account symbol BANK_CHARGES has account modification MONTH:
A dedicated GL account for monthly bank charges, namely 119999, will be retrieved by the application if you can specifically identify a line in the bank statement with monthly costs and enter the value “MONTH” in the field FEBEP-KFMOD during bank statement upload.
This can be done in a number of ways. Please see my prior post, which outlines the enhancement strategy and considers several alternate possibilities. This blog post will describe how the search string’s capability can be applied in this situation.
3. Configuration of search string
Search string was defined in transaction OTPM as follows:
The search string examines outgoing payments in bank statements with the BTC code “004” and looks for the fixed text “MONTH” in the note to payee. The target field FEBEP-KFMOD will be updated with a fixed value of “MONTH” after this text has been located. The “Account modification” update scenario is called EBKFMOD.
After uploading a bank statement for the house bank KREAG, view the application log that is generated. You can see that the account modification served as the basis for determining the GL account for home bank:
This is the fourth article in the series on search strings, as I mentioned at the beginning of the piece.