From dull numbers to smart data: A new era of cash visibility is dawning
| 06-03-2018 | TIPCO | Sponsored content |
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 world-wide 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 depart-ments. 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.
TIPCO Treasury & Technology GmbH
[button url=”https://www.treasuryxl.com/community/companies/tipco-treasury-technology-gmbh/” text=”View company profile” size=”small” type=”primary” icon=”” external=”1″]
[separator type=”” size=”” icon=””]

The DACT (Dutch association of Corporate Treasurers) will be holding their annual Treasury Fair in Noordwijk at the Hotel van Orange on 23rd and 24th November 2017 – the most important annual treasury event in the Netherlands. Discover treasury best practices, learn about the latest trends and exchange experiences. It will contain 9 practical workshops spread out throughout the day on topics including, among others, trade finance, supply chain finance, liquidity forecasting, cyber security and the Blockchain. There are more than 50 exhibitors present at the Trade Fair including Treasury Intelligence Solutions GmbH- a partner of treasuryXL.
The DACT (Dutch association of Corporate Treasurers) will be holding their annual Treasury Fair in Noordwijk at the Hotel van Orange on 23rd and 24th November 2017 – the most important annual treasury event in the Netherlands. Discover treasury best practices, learn about the latest trends and exchange experiences. It will contain 9 practical workshops spread out throughout the day on topics including, among others, trade finance, supply chain finance, liquidity forecasting, cyber security and the Blockchain. There are more than 50 exhibitors present at the Trade Fair including Treasury Services- a partner of treasuryXL.
Na de vorming van de euro is het toezicht op financiële instellingen en markten geïnternationaliseerd. Hierbij is het logisch om een ‘level playing field’ binnen de eurozone te realiseren om reguleringsarbitrage te voorkomen.
Ontvang via treasuryXL korting op deze e-learning en/of de
Zonder banken en financiële markten zou onze huidige economie en welvaart niet mogelijk zijn. En of u het nu leuk vindt of niet, banken waren en zijn onmisbaar voor onze moderne maatschappij. Iedereen doet, al dan niet bewust, dagelijks zaken met of via banken. Sinds de jaren ’80 heeft er een ongekende schaalvergroting plaatsgevonden in de financiële sector. Door deze schaalvergroting hebben banken zich ontwikkeld tot gigantische financiële supermarkten die een zeer uitgebreid aantal financiële diensten en producten aanbieden. Banken zijn tegenwoordig IT-bedrijven waar een grote groep specialisten werkt met beperkte financiële vakkennis.
TIS and 2FX Treasury organize a webinar that we would like to bring to your attention. On October 19th between 04:00 and 04:45 PM TIS and 2FX Treasury will host: Corporate Payments Optimization: How to reduce complexity in your business. An interesting session for treasury professionals.
When they hear e-invoicing, companies often think that this is sending invoices by e-mail. However, e-invoicing is more than that. Not only sending the invoice is part of this, but also the electronic booking, payment and collection of the money belongs to this process. Electronic invoicing leads to a major save of costs. For the sender, but especially for the receiver. Since e-invoicing is digitalizing invoicing for the sender as well as the receiver, a PDF-invoice is not seen as electronic invoicing.
Facturis
