“Treasury workstations have evolved into robust systems that manage cash, support position and portfolio management and offer sophisticated risk management functionality,” says Ann Rodriguez, director of financial services consulting at BDO Seidman, LLP. Treasury workstation benefits include increased efficiency, better rates on investments and more stringent expense control. They allow companies to automate most core treasury operations seamlessly with a database and communicate directly with banks, other financial institutions and sometimes even customers and suppliers. Treasury workstations eliminate the need for multiple system spreadsheets; increase reliability in financial reporting and decision making; streamline administrative efforts; and reduce manual errors. Not long ago such sophisticated information technology tools were too expensive for any but the world’s largest corporations. Today treasury workstation vendors are focusing on marketing to businesses of all types and sizes and price ranges. With off-the-shelf enterprise resource planning (ERP) software for midsize companies widely available (see “How Midsize Companies Are Buying ERP,” JofA, Sept.99, page 41), vendors are selling treasury management modules both as separate units or part of larger systems. For midsize companies, a treasury management application compatible with existing systems may be affordable. If a corporate treasurer’s company has annual revenues in the $50-million-to-$100-million range, now may be the time to take another look at what treasury workstations have to offer.
HOW THEY WORK A treasury workstation is an information system that allows a corporate treasurer or other financial officer to manage a company’s treasury operations, comprising all accounting functions, funds transfers, investments and cash—including an organization’s working capital and daily cash position. It consists of software, hardware, and a database. The hardware and database often are used for other purposes as well. Some more sophisticated treasury workstations have extensive access to external databases including real time information on capital markets and e-commerce connections with customers, suppliers, investors and providers of financial services such as banks and insurance companies. “External interfaces may be established to the existing accounting system for complete end-to-end processing,” Rodriguez says. THE BENEFITS Vancouver-based Selkirk Financial Technologies has a client list ranging from Armonk, New York–based IBM Corp. to a municipality in New Zealand with a population of 60,000. Lyndon J. Harvey, Selkirk’s chief operating officer, says businesses as diverse as a regional electric utility, a small boutique retailer and a major manufacturer use treasury workstations today. (For user perspectives, see the sidebars, “Times Mirror, Reflecting Trend, Relies on Treasury Workstation,” and “Ingram’s System Saves $30,000 a Year.”) Treasury workstations offer big savings. For example, one vendor says his company might work with a client company that has average daily cash balances of $10 million, spread among banks all over the country. Given the minimal yields many banks offer, money that sits there is “not doing anything for you,” he says. Treasury workstations can reallocate, reducing the amount of working capital sitting idle in bank accounts by as much as 75% and sweeping cash from low interest accounts and investing it. The company can put $7.5 million of that average daily cash balance into higher-yielding treasury bonds or money-market accounts. It’s estimated these systems can pay for themselves within 6 to 12 months, in hard dollars, cost savings or investment earnings. One case in point: Walter Stark, assistant treasurer at Humana Inc., a Louisville-based healthcare provider with six million members nationally, says his company’s treasury workstation is already paying big dividends. He estimates that over the next three years the treasury workstation—which cost Humana $150,000—will save the company $213,000 directly, as well as $45,000 in efficiencies and $60,000 in additional interest income. That $318,000 in total savings equates to an internal rate of return of 37%. Another big benefit:
standardizing and simplifying. Treasury workstations make it
possible to replace multiple spreadsheet systems with a
single standardized tool. Such standardization may increase
the reliability of the company’s financial reports and
financial decision making; reduce administrative work; and
enhance internal controls with automated checks. In
addition, the workstations can help improve implementation
of best practices in areas such as documenting daily
procedures, cash forecasting, benchmarking, improving
efficiency and monitoring profitability.
Treasury workstations do this by constantly monitoring both external data on capital markets and internal data on a company’s cash position. That can be especially useful for a large company with multiple entities operating in several countries but may benefit a retail chain with a half-dozen locations, too. Companies cite other reasons for using treasury workstations: They enable businesses to conduct repetitive transactions without rekeying data; they are very effective with reconciliations; they provide timely data; and they can perform complex financial calculations. Those calculations include helping businesses identify their financial exposure, quantify it, and specify their cash positions in any currency. Such calculations are essential for companies using derivative instruments. Another popular selling point: The current crop of treasury workstations can interface with a company’s general ledger (GL). Edward Gordon, senior vice-president at Wachovia Treasury Consulting, a unit of Atlanta-based Wachovia Bank, says that’s important because companies are looking for a single database instead of the multiple systems many companies still use. Companies using multiple systems may keep staff busy calling several banks to get transaction reports, printing them manually and forwarding them to accounting, Gordon says. “The beauty of treasury workstations is that they [replace] a lot of daily transactions done by people with an automated process.” In turn, Gordon says, that allows people to redirect their energies to more important matters, such as analyzing the company’s investment position or developing methods to improve efficiency. NOT PERFECT YET Like most off-the-shelf software, treasury workstations don’t always do everything well, however. According to Anne Bacher, cash manager of Times Mirror Co., the Los Angeles–based news and information giant, “What the majority do very well is automate manual treasury and accounting tasks, saving time and money as well as reducing errors.” Her company has used a treasury workstation, or rather, two systems from two different vendors, for about three years. The first unit she tried did not work out well and needed enhancements the vendor could not provide. Her company’s second try—Treasury Manager from Selkirk—offers investment and debt capabilities that improved system performance. Five to ten years ago treasury workstations were rudimentary information reporting machines. Although the technology has changed dramatically, offering graphics and more system compatibilities, the downside is that the new systems are harder to install. It used to be that a bank or vendor could install an old-style basic information reporting system in about two weeks. In comparison, installations today can take three to six months—and they are major investments for most companies.
CHEAPER AND MORE POWERFUL Wachovia’s Gordon estimates that a midsize company can purchase and have a treasury workstation installed for as little as $30,000 to $50,000, but those prices certainly are not the average. Industry experts say the systems—including hardware, software and installation—can cost up to $300,000, depending on the user’s needs and the system’s functionality and complexity. The variables affecting the cost of a treasury
workstation include the number of applications a company
needs, the number of people who will be using the system and
the number of feeds that integrate the system. “If you need
FX, debt and investment functions, it can easily be in the
six figures,” says Selgrad. She says banks—the traditional
vendors of treasury workstations—are getting out of the
business and being replaced by third-party vendors that
basically provide the software, implement the various
functions and get the systems running. (See resource list,
at right.) A treasury workstation allows a company the option to deal with one or more banks. But users still need “a stem” that links them to the global banking system. The reason: Banks settle transactions, transfer funds or exchange currencies primarily with other banks. The treasury workstation translates corporate data into the electronic language that banks all over the world use to communicate with each other. Midsize companies can buy treasury workstations with software that they can operate on a basic PC network, including a Windows NT environment or client-server platform. A diverse range of modules to fit accounting, investment or cash management needs makes this possible. The modules can be customized to fit company needs and be expanded as required. How a treasury workstation interacts with other financial systems a company may already have in place is key when considering buying one. “Controls and reconciliations must be consistent with the level of automation, to keep pace with the complexity of treasury deals and ensure accurate and timely accounting information,” Rodriguez cautions. A financial manager needs to know how a workstation and the existing financial software dovetail. Today’s treasury systems have modules offering the following capabilities: Cash management. Cash management modules are used for scheduling and forecasting, bank account data retrieval, electronic funds transfer (EFT), real-time position reporting and targeting, in-house banking and pooling, reconciliation and multicurrency transactions. Investment management. Treasury workstations can handle multiple portfolio environments for money markets and mutual funds, short-term and fixed-income investments, equities and options. Other functions track secondary market trades, interface with pricing services and produce mark-to-market reports. Debt issuing and tracking. The debt capabilities of treasury workstations include tracking of short term debt with a link to a dealer-based commercial paper program. They can also be used to manage fixed and floating rate long-term debt instruments with automatic recalculation of payment schedules. Risk analysis. Risk management modules allow a user to perform “what if” modeling through yield-curve manipulation and scenario analysis. The user can determine performance on a risk-adjusted basis and calculate “value at risk”—a measure of what could be lost in a certain timeframe given certain assumptions. IS IT YOU? A financial manager wondering which way to go should do some careful homework to determine whether a treasury workstation will help his or her organization. “The approach to treasury management should be based on several considerations: corporate strategy, system functionality, technology and process design,” Rodriguez says. Approach cautiously and get answers from vendors to the following questions.
Do sufficient research to have a solid understanding of the system’s suitability for the company’s current and future needs. Become familiar with the vendor’s product capabilities. Calculate the total cost of implementing the workstation and project the payback period. To help determine how well a treasury workstation will work for a company’s treasury operations, industry experts say potential users should request a cost/benefit analysis from vendors. That analysis should specify how the workstation will contribute to current and future company objectives, how it will make internal and external accounting functions more efficient and what the bottom line effect should be. Other questions might include
Also seek
A GROWING MARKET If a company is not quite ready for a treasury workstation, not to worry. The market is growing fast. Brian McDonough, a research analyst at International Data Corp., a Framingham, Massachusetts–based firm that researches and analyzes the software industry, says the treasury workstation market “will only expand.” He thinks that’s good news for potential users, because that will help drive down the costs of the systems, increase their functionality and make them more practical. “Growth rates will increase after 2000, when the portion of companies’ treasury budgets formerly allocated to solving Y2K issues becomes available for the purpose of other packaged applications such as treasury workstations,’’ McDonough says. The bottom line is that treasury workstations can be a vital resource for midsize organizations. The systems help companies minimize interest expense, mitigate their risks and maximize investment returns. Much as other advances in information technology have helped transform many aspects of business, treasury workstations have put treasurers in closer touch with their banks and other financial suppliers, allowing them to make better decisions faster and giving their companies a useful tool for managing working capital more effectively. |
Breaking News
- Feature
- BANKING
Latest News
PODCAST
Most Read
SPONSORED REPORT
2019 State of Financial Reporting Survey
We surveyed nearly 600 finance and accounting professionals on their month-end close and reporting processes. See the results.
VIDEO
What RPA is and how it works
Robotic process automation is like an Excel macro that can work on multiple applications, says Danielle Supkis Cheek, CPA. RPA can complete routine, repetitive tasks such as data entry, freeing up employee time from lower-level chores.
From The Tax Adviser
From CPA Insider