As if there wasn’t enough interest in electronic bank account management (eBAM) already! SunGard’s AvantGard business has been working on their own de novo development of an eBAM offering and it seems to us that it will be ready for the market in the early part of 2011.

There are a few interesting and a few parochial points about their offering that we’ll note. Please also note that they shared a few of the simple ‘form screenshots’ that we can reproduce here. They wouldn’t share any workflow images at this time, but, maybe we can coax those out of them at a later date closer to the launch.

  • eBAM System
    • Supports all 15 XML eBAM messages
    • Able to send and receive these messages by leveraging their communication hub (– called Echos)  (when the banks are ready)
    • Output can be in XML or in a Custom PDF (for the banks that aren’t ready, or who won’t be ready for some time)
    • Is planned to work with all other TWS/TMS systems –this is in line with recent announcements at client summits regarding SunGard’s AvantGard development strategy whereby web based services such as eBAM will be made available in the “cloud” and can be accessed from any of their solutions (treasury and payments)
    • Financial messaging is managed between the treasury and payments solutions via the Echos platform which is a communication hub – the hub includes access to the SunGard SWIFT Service Bureau
  • “Center of The Chessboard” Strategy
    • This application has been built from the ground up on their Infinity platform. While this is not the first SunGard application to be built from the ground up on this new platform, it is the first AvantGard application that enjoys this claim. (This is making good on their promises and overall strategy to occupy the “center of the chessboard” from a process ownership and technology basis).
    • Workflow management is part of base, out of the box offering. Configuration of workflows will be possible and this further advances their business process strategy and software/service delivery engine.
    Sungard eBAM Account Details (images used by permission)

    Sungard eBAM Account Details (images used by permission)

  • Acquisitions to Innovation?
    • Sungard Avantgard has long been known for acquiring firms and bringing them into their fold and them supporting them for…well…forever. We haven’t heard anyone accuse them of being innovators. However, with the release of Treasury XE (their cash TWS) and the pending release of eBAM, they seem to want to leverage some of their new technology tools and make some new toys for treasurers. But, let’s see a few more products delivered before we get ahead of ourselves.

While another eBAM offering is certainly noteworthy and interesting news, that is, in our opinion, the minor story here. We think that five years or so, the fact that SunGard began delivering on their new “center of the chessboard” strategy will prove to be the bigger and more important story.

Sungard eBAM Account List

Sungard eBAM Account List

-c

See related blog entries: Weiland Acquired, Wallstreet Systems Acquires Speranza

 

OpenSolutions Acquires Weiland Financial Group

July 26, 2010 brought with it the announcement that Weiland Financial Group has been acquired in friendly transaction by OpenSolutions.  See press releases for more information. This brings the well-respected Weiland brand into a much larger organization at an opportune time.  OpenSolutions has acquired one of the premier names in treasury technology. Our analysis is that the acquisition/transaction makes tremendous sense in a number of ways for various parties interested in the transaction:

Weiland Financial Group

  • Provides additional funding and resources of a larger organization as they grow the Account Analysis and Bank Account Management (eBAM) parts of their business. This is good timing – right when more investment is needed to further drive good growth as interest in (particularly) eBAM is accelerating.
  • Strengthens the long-term plan for the firm as it appears to have well-positioned both Steve/Pat and their employees for long term growth and expansion before any questions about ‘what are they going to do with the company’ could create distraction.

OpenSolution

  • Moves them into an increasingly stronger position in the corporate treasury space by acquiring a highly-respected firm who covers the Bank Billing (Account Analysis) and electronic Bank Account Management (eBAM).
  • Captures a number of  intellectual leaders in the treasury technology space just as the business is heating up.

It is quite interesting that now the two main eBAM providers have been acquired within a three month period.  See TWS: Acquisition: Wallstreet Acquires Speranza for the last eBAM acquisition. This was not an overpopulated field and firms are rushing to develop offerings that can leverage the SWIFT messages that support eBAM.

-caj

 

Wallstreet Systems announced today that they have acquired City Financials. The stated reason for this acquisition is that it fills in the Treasury Workstation (TWS) or Treasury Management Systems (TMS) gap they have between Wallstreet Treasury (WST) and Wallstreet Suite (WSS).  See some of the news postings:

Finextra

Forbes

Bob’s Guide

Readers  who have seen our classification of the TWS landscape note that WST falls into our “Cash TWS” vertical and that WSS sits in the rightmost vertical called “Enterprise TWS”. The middle vertical in our model is called “Cash and Risk TWS”. Sitting in this space most comfortably are Sungard’s Avantgard (AG) Integrity and IT2’s offering.  CityFinancials falls into this category as well. Their stated 50-75 clients are predominately located in Europe with some initial success in penetrating the North American market lately.

It will be quite interesting to hear and report:

  • How their new plans fit with their previous ‘center of the chessboard’ strategy they were pursuing with WST.
  • About their ability and plans to market the three TWS offerings and the trading-related platforms. How will they ensure the focus isn’t on the largest systems (WSS and trading-related)?
  • It would be particularly good to hear the development strategies for WST and CityFinancials (to say nothing of the integration plans).

caj

 

At NACHA’s Payments 2010 Conference, there is a very timely and interesting topic being presented on changes to wire transfer information. Additional information will be able to be included with the wire transfer in the near future…we encourage you to attend the session. The session details can be found at the Payments Website. The session description is from their website.

B2B Payments Take A Big Leap Of Convenience

613/614

10:00 a.m. – 11:15 a.m.

The Payments Biz

At the end of 2010, a new era of B2B electronic payments will begin for banks and their corporate customers. That’s when the nation’s two wire transfer systems, CHIPS and Fedwire, will be able to include remittance information with a wire payment. For payments professionals, this change will rationalize the front end of the payments system by creating parity between the ACH and wire transfer in terms of convenience, ease of use, cost, efficiency, and environmental benefits. Panelists discuss the potentially significant impacts this development will have on all parties in the payments value chain. Topics include: opportunities for banks to embrace the wire remittance standard as it becomes effective at the end of 2010; potential impact to wire and ACH usage and volumes; steps banks, corporations, and vendors should take to prepare payments professionals to realize the benefits of the new standard; and best practices for implementing a comprehensive native electronic payments strategy.

Level: Advanced

Susan Boeri

Manager, Treasury Services, GE Corporate Treasury

Claudia Swendseid

Senior Vice President, Federal Reserve Bank of Minneapolis

Paul Trozzo

SVP, Product Group Manager, PNC Bank Treasury Management

Moderator: Rossana F. Salaris, AAP

Senior Vice President, The Clearing House

 

Forecasting Series #3: Achieving Visibility part 2: How can I get at the data INTERNALLY?

“Are we there yet?” call the kids from the back seat for the umpteenth time. “You can see it from here, it’s not far…just to the base of the mountain range” comes the increasingly more agitated response. Each adult silently wondering how come it seems like the end point magically stays at the same distance. And, will we have enough gas to get there without stopping to fill up…again?

Getting at data internally is really easy if you have never attempted it before. Really easy. Then, when you attempt to acquire it there is always ‘something you didn’t expect’ about it that makes getting good data elusive. Just like the hotel at the foot of the mountain range…elusive.

This is a blog entry and not a book on overcoming forecasting challenges. Accordingly, I’ll lay out some of the thorny issues about getting at data INTERNALLY, and mention some options. But, this isn’t going to be the exhaustive decision tree about solving all of your internal data needs. Hopefully this will get you thinking that it requires a bit more work than the simple diagram you drew on the whiteboard. You know, the one with the boxes of information sources that had the line running over to your treasury data repository, reporting tool/cube or treasury workstation? That simple line is nice for drawing, but it is really only the “Fallacy of the Line”. What does the line mean? Is every line we draw equivalent? A line can be the same size and length but mean different things:

Fallacy of the Line

The fallacy of the line

Here is a starter list of issues to get your heart racing and the stomach creating an overabundance of acid:

  • All of the data is in SAP/Oracle (some wonderful ERP systems that was supposed to solve all of our data issues)?
    • Not everything is in the system.
    • There are multiple instances of the ERP.
    • We have multiple entities that are not on the same type of platform
    • The data is different because the data we need isn’t crucial for the other area to process/analyze things correctly.
    • Data sits is so many disparate systems
    • The data is in different formats.  Japanese Yen is listed as YEN, JPY, JPN, Y… The normalization of this data is either a huge project or is addressed via a formatting process or via associative tables.
    • Stuff isn’t in the system

“We would have been able to deliver this on time if we didn’t have such data problems. No one could have anticipated xxx, yyy and zzz.”

Here are some primary ways of getting at data and some strengths and weaknesses of these models:

  • Manual Entry. Major items that primarily sit in someone’s head can be captured on a web form and included in a cashflow forecast. This requires relentless feedback and retraining when people move.
  • Feed of Data. This method works great for the ‘static’ aspect of reporting, forecasting or executing transactions. The constancy of the process can work well. However, as soon as you need to do some analysis (what was the cause…and root cause of this variance) you can only dig into the data that you have captured.
  • Connection. A live connection can interrogate the data either when needed or real time. Some methods can degrade performance. Other methods are non-intrusive. Connecting allows treasury to perform additional analysis and ask better questions more quickly.

Your treasury information design is crucial. And, your plan and approach to getting at data that resides within an organization is far harder to achieve than most people can imagine due to disparate systems, processes and business requirements of the data. Underestimating the effort means a lot of extra work and extra explaining.  It is possible to get at internal data and manage through the non-normalized information effectively. Run from those who have never done it, but draw a line between two boxes and say it is easy. They will be the first ones to offer up the excuse of ‘we didn’t expect the data to be this bad’.

/caj

 

To Windows 7…

Not seeing any follow up posts made some people worry a problem ensued (others wondered why we are writing about Windows…). No problems – there are time restrictions on posting to blogs with real work needing to be done -and journal articles to be completed etc..  Here is the run down of what happened and my interpretation:

  • It took just over  two hours to run the complete upgrade (after uninstalling my anti-virus software – more on that in a moment).
  • Recognize that two hours is a long time – but that is what they said it might take – and I have a ton of software on this machine.
  • Once it ran through the process (rebooting along the way as Microsoft indicated it would) I was presented with essentially all of my stuff in a new operating system. It looked relatively close the Vista system with some minor changes.

What had to be ‘fixed’. Not everything worked perfectly right off. Here is what happened that needed to be fixed:

  • Had to reinstall the Anti-virus to be able to connect to the outside world. We use a firewall that ENFORCES updated AV software (a good idea). Then, we had to install it again.  Then today, had to reinstall it again to get an outside internet connection.
    • Called our IT guy over to resolve the AV issue. After a few minute search on the AV site he performed a firmware update to our firewall to handle Win7 clients (this took a few minutes).
    • Later on, once again we couldn’t connect outside (after working for awhile). The AV site showed that the Microsoft Firewall was blocking access. Their firewall was working fine. Apparently two firewalls might be too much.  Disabled the extra firewall and it works great.
  • Nothing

What seems neat or worked well:

  • With a significant upgrade, they caution that you may need to have your software disks ready to reinstall. Besides the AV stuff, the aircard software ran its own install/change (of course we had to give it  permission). Everything else has worked as it did before.
  • Printing, networking, backup services, etc.
  • The speed of the system generally seems a bit faster. Though Vista for this configuration was always pretty fast.
  • The mouse over options on the bottom are pretty effective for navigating – you see all 6 email files and can simply move to the image and you open that on your desktop
  • They have a warning flag system if anything is not up to security standards (if you remove the AV – all of a sudden a red circle with an ‘X’ in the middle shows up saying – you don’t have an Anti-virus software…
  • The extended desktop options for viewing multiple screens works even better than Vista.  Nice.

All in all a relatively painfree upgrade. Glad I went with Vista as it worked well. DELIGHTED  I went with Vista since upgrading from Vista to Win7 is a non-event.

-C

 

From Vista to Windows 7

Embarking on the upgrade from Vista to Windows 7 today. Having enjoyed Vista’s capabilities and even performance (with the service packs) I am looking forward to experiencing Windows 7. It seems that even those who didn’t enjoy Vista like Windows 7 quite well.

I am no software tester, but thought it would be useful to document the upgrade on my live laptop.

-C

 

February 24, 2010’s WallStreet Journal ran an article entitled Lehman’s Ghost Haunts California. This article is well worth a good and critical read. Emphasis on the critical. It covers, essentially, one side of the story about San Mateo County and their loss of $155mm (reported by them) from the collapse of Lehman Brothers. We’ll be more frank in this blog entry even if it makes people feel uncomfortable.

The article states that “San Mateo’s board of supervisors ordered an independent review of the way the county investment fund was run, but found no wrongdoing.” And, a little later “San Mateo’s treasurer had invested in highly rated securities and put no more than 10% of the fund in any single issuer.”  Okay, no laws were broken. Nobody violated the written investment policy as written. However, this fails to tell all of the key points about what was going on at the time. I would like to see the reporter dig up some useful information to tell us – such as:

  • Why, according to San Mateo County’s own research (as shown in a chart in the same WSJ article) did they hold $155mm when the next seven largest county/municipal holders of Lehman paper held less than that in total?
  • Since everyone was talking about Lehman issues before its collapse – and most were reducing their holdings – what was San Mateo doing to stay situationally-aware? By everyone – we include treasurers of municipalities and counties.
  • If they were increasing these holdings, why? For the yield?

“If there are warning signs all over the place about ice on the road -  and snow is falling, anyone who doesn’t slow down to adjust for conditions is responsible for flying off the road. Claiming they didn’t break the posted speed limit isn’t going to be a good argument – especially if they were accelerating into the corner when they hit the ice.”

The article highlights a push to try to secure bailout funds for municipalities that held Lehman paper and makes comparisons to the bank bailout. While we can all argue about appropriateness of the ‘voluntary’ capital infusions to banks, there are some important differences that are not noted:

  • Bank bailouts didn’t seem to be voluntary
  • The US Government – and taxpayers – appear to be getting their principle back with substantial interest
  • Bailout for the banks equates to temporary loan with interest
  • Bailout, if given, to those who held Lehman Bros paper equates to a gift with nothing coming back

Lessons Re-Learned:

  1. Ensure you are plugged into the discussions so you can remain situationally-aware.
  2. Remain diversified (% of holdings, total amount of any one holding, source of ratings or proxy for ratings).
  3. Ensure the technological tools are in place to monitor your holdings, counterparty risk levels, changes in quality of issuers, etc.
  4. Take responsibility.

If anyone thinks that reducing treasury staff levels or eliminating funding for treasury systems and tools is a good idea, they may need some shock therapy or recent (and old) history lessons. However, no system can completely prevent operator error.