We are looking for help in creating semi-automatic loading of bank statements in the MT940 format and configuring the automation of the accounting process of individual transactions in the SAP S4 Hana system.
At the moment, everything is posted manually and we want to improve this process a bit.
We are thinking about creating two additional technical accounts in SAP for inbound and outbound transactions.
After manually uploading the bank statement in the MT940 format using the FF_5 transaction, we expect SAP to transfer all transactions to technical accounts and further to Vendor and Customer accounts (probably it should search for the agreed scope and invoice number and by the amount) and to GL accounts ( searching for repeatable transactions, e.g. Bank charges looking for a transaction name).
At end of the semi-automatic process we would like to be able to checked on the SAP side if everything was poste correctly using transaction FEBAN and if not, then we would like to be able to make some necessary postings/corrections .
We can provide:
- bank statements with sample transactions for any period
- access to the SAP development and test systems
- help in testing of the solution
- providing other necessary data as required (list of Vendors, Customers, invoice numbers, accounts, etc.)
- quick answer to any questions such as what we actually expect
At the beginning, we want to check how it works for one bank account and if we will be satisfied with the result and the price will be acceptable, we are considering transferring this solution to several other accounts and banks used by our company, but we will also need help with it.
From experience in another company, I know that for a person who is proficient in this subject, it could take several hours of work + tests that may be partially / fully on our side.
In general, the traffic on the accounts in our company is very small (max 300 transactions per month / per account) and therefore there has been no emphasis on automation so far, but as a new accountant in the company I would prefer to start automating some processes in order to have more time for other tasks.
If you are interested in such a small project let me know.