Compta Bretagne Services is a French company that manages several ACCOR hotels (Ibis, Mercure, MGallery) 30 in France and 5 in Switzerland.
Stéphanie Chevallier, the Administrative and Financial Director , explains why and how the choice of NEOFI facilitates the work of her treasury team.
Until 2019, Accor Hotels SA handled the accounting for the five Swiss hotels, before CBS29 decided to bring it in-house. Since then, account statements have been retrieved daily by CBS29 via Kyriba.
However, since these raw data were unusable, they were initially imported into Excel, manually processed by our team, and then integrated into the SAGE 1000 ERP system—a very time-consuming and error-prone task. This daily reprocessing of the files quickly became tedious, and it soon became necessary to consider automating it in order to free up staff time for higher-value tasks. We therefore began searching for a solution capable of retrieving bank statements from Kyriba , transforming them according to complex conditional rules, and then automatically loading them into the SAGE ERP system .
It was while searching for banking transformation solutions online that we found NEOFI. Once we contacted NEOFI's sales team, we were completely convinced after a demonstration of their solution . The criteria that guided our choice were the power of rules engine and the very rapid implementation time.
NEOFI has implemented a process that receives by email the account statements that Kyriba sends in Excel format (but the format doesn't matter, an MT940 would have done just as well), then reads each data from the statement before generating the corresponding accounting entries (1 line of movement generates 3 entries).
The complexity lies in reading the data related to the commissions charged by credit cards: present in the additional fields of the statement, these commissions are displayed in different forms depending on the card used and depending on the bank statement.
Thanks to its various nested functions, NEOFI can search for a particular string of characters and capture the numerical values that follow this string, then check the consistency of these numerical data with the overall amount debited.
The generation of the three related accounting entries is then a simple formality since it is linked to previously entered reference data.
It took a few weeks to adjust the adjustments and obtain a file that perfectly met all our expectations. It's crucial to clearly define the matching criteria between the source file and the requirements beforehand to ensure proper integration of the entries into the correct accounting accounts. The difficulty also lies in the fact that the banking format for supplementary fields often differs from one bank to another, and that data retrieval is not fixed because banks regularly create new interbank codes.
The deployment took place in a few weeks. responsiveness and efficiency reinforced our confidence for the continuation of our collaboration: all processes are now completely automated, allowing us to save 3 hours per day .
To further improve productivity, we would like to upgrade the tool so that it can adapt to changes as soon as the bank modifies its formats. We know we can count on the NEOFI team to support us in this project.
