TREASURY DRAGONS
  • Home
  • Events
    • Dragons Pitch sessions >
      • Corporate Payments
      • FX Trading Platforms
      • Netting and Pooling
      • Cash Forecasting
      • Bank Account Management
      • Bank Fee Analysis
      • Fraud and Cybercrime
      • Cash Visibility
      • KYC, AML and Compliance
      • LIBOR
      • FX Risk Management
    • Dragons Round Tables >
      • In House Banking
      • The Spreadsheet Recovery Group
      • Fraud and Cybercrime
    • Dragons Fireside Chats >
      • TRI HoldCo and Trovata
      • Square and Trovata
      • Bandwidth and Trovata
    • Dragons Debates >
      • The future of FX - what do treasurers want from banks?
  • Solution Providers
    • Bottomline
    • Bureau van Dijk
    • CashAnalytics
    • Cashforce
    • Cobase
    • ComplyAdvantage
    • COUPA
    • Delega
    • Fides
    • GTreasury
    • Hedgebook
    • ION Treasury
    • Kyriba
    • Nomentia
    • nsKnox
    • Redbridge
    • RiskScreen
    • Salmon Software
    • TIS
    • Titan Treasury
    • TreasuryXpress
    • Trovata
    • Present your Solution
  • Technology news
  • TECHNOLOGY GUIDE

Dragons Talk
The Treasury Technology Review

Round table: Fight spreadsheet addiction with a treasury management system

3/5/2021

 
Picture
In the second Treasury Dragons virtual round table, sponsored by Bottomline TreasuryXPress, a group of senior treasury professionals met to discuss how to reduce reliance on spreadsheets as a treasury management tool.

This month’s group included treasurers from retail, media, manufacturing, healthcare and communications firms, all with differing challenges as their businesses emerged from the pandemic.

What rapidly became clear was that spreadsheets have their place in even the most developed treasury department. Some of the reasons for continuing to use spreadsheets were:
  • Flexibility: In companies where acquisitions had to be integrated, spreadsheets were often seen as  the only way of bringing together data from disparate sources such as Treasury management Systems (TMSs) and Enterprise Resource Planning (ERP) systems.
  • Ease of use: Several treasurers mentioned the ease of finding staff, freelancers and consultants with strong spreadsheet skills, compared to the difficulty of finding expertise in a specific TMS.
  • Cost: Spreadsheet software is inexpensive
  • Reporting: Some treasurers found the reporting functions of their TMS to be restrictive and used spreadsheets to generate the type of flexible reports demanded by the wider business.

Nevertheless, there were clearly identified limitations - and risks - where spreadsheets were used instead of a treasury management system.  Among the issues raised were:
  • Risk of error: Errors can creep into large spreadsheets, especially where the staff who had first created them were no longer with the business.
  • Compliance: Several members had used internal audits which had uncovered risks in the continued use of spreadsheets, triggering a search for a safer, more efficient solution. Compliance with Sarbanes-Oxley was very challenging in spreadsheet-dependent companies.
  • Password management: One group treasurer has invested in technology to manage passwords after realising that protected sheets, ranges, or cells could be impossible to edit if passwords were not stored centrally.
  • Extensive manual work: However well built the spreadsheet, there was a high level of manual intervention required, with one treasury team cutting and pasting balances for several hours a day.
​
Of the treasurers who were using spreadsheets extensively, all were considering introducing or upgrading their TMS to automate some functions, reduce eros and reduce risk. Getting board approval for the expenditure required was often a barrier - but so was the diversion of staff and resources to implementing such a major change.

A common theme was that the real driver for change came when outside consultants were brought in to audit data security and financial processes. “After their report came in, it became clear to our board that we had to invest in a TMS,” said one treasurer.
​
As the meeting closed, it was pointed out that the next wave of automation, including APIs and machine learning is already vastly improving the flexibility and adaptability of TMSs in many of the areas where spreadsheets have traditionally been used - and that bigger change is on the horizon.

Picture
This was the second Treasury Dragons Virtual Round Table, sponsored by Bottomline TreasuryXpress. 

​


Comments are closed.
    Dragons Talk
    Treasury Technology news from the experts at Treasury Dragons. 

    Archives

    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2021
    September 2021
    July 2021
    June 2021
    May 2021
    February 2021
    January 2021
    September 2020

    Categories

    All
    Bank Account Management
    Cash Forecasting
    Cash Management
    Fraud & Cybercrime
    FX
    In House Bank
    In-House Bank
    ION
    News

    RSS Feed

Picture

 © Adaugeo Media Ltd 2021
  • Home
  • Events
    • Dragons Pitch sessions >
      • Corporate Payments
      • FX Trading Platforms
      • Netting and Pooling
      • Cash Forecasting
      • Bank Account Management
      • Bank Fee Analysis
      • Fraud and Cybercrime
      • Cash Visibility
      • KYC, AML and Compliance
      • LIBOR
      • FX Risk Management
    • Dragons Round Tables >
      • In House Banking
      • The Spreadsheet Recovery Group
      • Fraud and Cybercrime
    • Dragons Fireside Chats >
      • TRI HoldCo and Trovata
      • Square and Trovata
      • Bandwidth and Trovata
    • Dragons Debates >
      • The future of FX - what do treasurers want from banks?
  • Solution Providers
    • Bottomline
    • Bureau van Dijk
    • CashAnalytics
    • Cashforce
    • Cobase
    • ComplyAdvantage
    • COUPA
    • Delega
    • Fides
    • GTreasury
    • Hedgebook
    • ION Treasury
    • Kyriba
    • Nomentia
    • nsKnox
    • Redbridge
    • RiskScreen
    • Salmon Software
    • TIS
    • Titan Treasury
    • TreasuryXpress
    • Trovata
    • Present your Solution
  • Technology news
  • TECHNOLOGY GUIDE