From dull numbers to smart data: A new era of cash visibility is dawning

By Hubert Rappold | 5 March 2018

Building on information that is now more readily available than ever before, advances in technology help create new insights for corporate treasurers.

For the last decade or so, many treasury departments have focused on getting their hands on the data required for establishing daily, or at least weekly, visibility of group-wide cash. Countless projects have revolved around collecting electronic bank balance data – think MT940 and others – and considerable time and resources have been invested in automating and speeding-up data retrieval from TMS, ERP, trading platforms and other source systems. After all, besides bank balances, data on bank and IC loans and deposits, intercompany clearing accounts and other financial positions needed to be incorporated as well to allow for a realistic assessment of the group’s financial status and available headroom. However, reporting based on these data has remained a painful exercise for most treasury teams as it typically involved exporting information from various, isolated data silos to numerous spreadsheets containing a plethora of handcrafted reports. The result: the number of hours spent on consolidating data, updating reports and correcting errors often reached double-digits, on a weekly basis.

The first step: Compiling information

In recent years, the provision of relevant data has become much more automated and common place since the goal of having electronic account statements of all bank accounts worldwide centrally available was high on the priority list of many corporates. Very often, this was part of a larger effort to streamline and centralise cash management and payments. In many cases, a TMS was introduced to replace Excel spreadsheets and the treasury modules of popular ERP suites started to offer more sophisticated features, providing corporates with a preference for all-in-one solutions with a viable alternative to a standalone TMS. A mix of tried-and-tested, file-based connectors and more sophisticated web-services allowed for even speedier data interchange between source systems such as TMS, ERP or trading platforms. And any data not centrally available to the treasury department was collected from subsidiaries – facilitated in the best case by easy-to-use, web-based applications. With this kind of information basis established, dedicated treasury reporting solutions were leveraged to achieve close to 100% visibility of cash. At the same time, the rise in business intelligence software allowed end users to easily retrieve data without having to resort to spreadsheets and accessing reports online or even via smart devices became the norm rather than the exception.

The next step: Turning information into insight

For many corporates, these steps were already a big leap forward. But what next, now that all the integration challenges have been mastered and information is readily available? Of course, the ‘data puddles’ turned ‘data pools’ mentioned above can be used for plain and simple financial status reporting. But, given that it is 2018 and self-driving cars will soon hit the road in California: should that really be it? For us, the answer is a clear ‘no’. Today, treasurers have access to a whole new range of applications which make use of information that is now more readily available than ever, and which leverage recent advances in technology such as artificial intelligence to provide value-added services to treasury departments. While we are very careful when talking about ‘revolutions’ in treasury, the advances we want to highlight below surely are a noteworthy evolution. Until recently, data analysis in treasury was still very much a manual task. This no longer needs to be the case as smart tools greatly reduce the time needed for performing even in-depth data analyses, thus allowing more time to be spent on acting on the results of such analyses. Let us take you on a quick ‘tour d’horizon’ using five examples of how smart applications can take your cash visibility to the next level:

1. Policy checks

In a typical treasury policy, one finds numerous rules and regulations relating to the opening of new bank accounts, the maximum allowed number of these accounts, acceptable account purposes, etc. Why not replace email-based processes for new bank account requests with intelligent workflows that not only ensure an end-to-end audit trail, but which also ensure that new bank accounts are automatically fed into all relevant systems such as ERPs, TMS or reporting tools once finally approved.

2. Compliance controls

Combined with smart request workflows as described above, regular, system-supported compliance checks further enhance group treasury’s grip on what is going on around the group. Whether these checks relate to the number, currency or counterparty of bank accounts or other financial positions, or the timeliness of data on authorised signatories in the system, outliers can easily be identified, and compliance can be swiftly restored.

3. Fraud detection

When electronic account statements are merely used as a means of importing end-of-day balances, much of their potential is lost. Based on smart search patterns, data provided as part of the remittance information can be used for valuable insights: Where in the group do frequent cash-based transactions occur? Banks’ business transaction codes (BTCs) or other related text snippets can point you in the right direction and responsible, local or regional finance staff can be notified automatically, using workflow-based notification processes so the background and soundness of such cash movements can be checked.

4. Performance KPIs

KPIs as a means of systematically measuring treasury performance are high on the agenda of many of the more advanced treasury departments out there. Whether they relate to the efficiency of core treasury processes (think request and approval workflows once again) or to other indicators such as the overall number of bank accounts, the percentage of accounts included in cash pooling arrangements, the share of trapped cash in overall cash – to name only a few basic KPIs: a well-compiled set of such figures that covers not only cash management but other areas as well – presented in the form of a clearly laid out KPI dashboard, finally provides the treasurer with a strategic steering wheel.

5. Bank fee controlling

You wonder what bank fee controlling has to do with cash visibility. The short answer: everything. Regular, system-supported bank fee analysis is not only about penny pinching but equally about developing an in-depth understanding of what is going on further up the process chain. A strikingly high number of fax payments in a country where you wouldn’t expect them? Fees titled ‘Others’ which amount to thousands of euros every month? If nowhere else, then you’ll find this information in the electronic fee statements (e.g. camt.086) provided by your bank. A smart analysis tool allows you to interactively drill down from cruising altitude to the line item level and within minutes you can reach out to either your bank’s customer service, your subsidiary or both to clarify what’s going on.


If you would like to know more and find out how technology can help you go one step beyond cash visibility and ease your daily life as a treasurer, get in touch with us. We are looking forward to helping you unleash your data’s full potential.  

Become a bobsguide member to access the following

1. Unrestricted access to bobsguide
2. Send a proposal request
3. Insights delivered daily to your inbox
4. Career development