The simplest questions are often the most difficult to answer. Not too long ago, when Microsoft CFO Peter Klein asked, "How much cash do we have this morning, and where is it?" it would precipitate a fire-drill response within treasury to come up with the answer. To make matters worse, there often would be discrepancies in the answer because different treasury groups had their own definitions for "cash." Those responsible for bank balances would produce a different number than portfolio managers, whose answer would differ from the tax team's.

"This is what got us on the quest of, when we say 'cash' that we all mean the same thing," explains Anita Prasad, general manager of treasury capital management at Microsoft. "It might sound simplistic, but when we got into the details, reconciling the definition of cash is very important. For example, accruals might be included. And if you look at actual hard cash that we can use, you also need to look at liquidity, whether it is invested in equities or in U.S. or foreign bonds."

To address this issue, treasury formed a small cross-functional team with stakeholders from the major groups within the department. After examining, and dismissing, various treasury workstations that lacked the necessary functionality or were too expensive, the team decided to leverage off-the-shelf Microsoft technology including Microsoft Exchange, Internet Explorer 9, Office 2010, Outlook 2010 and SharePoint, along with SWIFT's messaging architecture and connectivity, to build its own treasury dashboard, dubbed CashView.

Complete your profile to continue reading and get FREE access to Treasury & Risk, part of your ALM digital membership.

  • Critical Treasury & Risk information including in-depth analysis of treasury and finance best practices, case studies with corporate innovators, informative newsletters, educational webcasts and videos, and resources from industry leaders.
  • Exclusive discounts on ALM and Treasury & Risk events.
  • Access to other award-winning ALM websites including and

© 2024 ALM Global, LLC, All Rights Reserved. Request academic re-use from All other uses, submit a request to [email protected]. For more information visit Asset & Logo Licensing.