XBRL: Improving Corporate Actions Communications

Written by Bob Schneider
Posted on June 26, 2010 Comments
June 26, 2010 | General | Bob Schneider

Written by Bob Schneider     Posted on June 26, 2010

In a recent interview with this blog, Max Mansur, Global Market Manager in Securities Markets at SWIFT, defined a corporate action as:

…Any activity that impacts a security that has been traded, cleared, and settled on behalf of the investor. Typically initiated by the public company issuing an equity or offering a bond, the action needs to be described and communicated to all investors and holders of the security as well as the public. The announcement of the action can include dates, rates, periods, prices, options, conditions, terms, exclusions, identifiers, and other characteristics.

Recognizing the significant shortcomings in paper-based corporate actions communications and the positive impact XBRL could bring to the process, the Depository Trust & Clearing Corporation (DTCC), SWIFT, and XBRL US joined together in May 2009 to create the Issuer to Investor: Corporate Actions Initiative. In September 2009, they announced the creation of a Stakeholder Group comprising three subgroups -- issuers, intermediaries, and investors -- to provide input and make recommendations for the Initiative.  Work is now proceeding on building an XBRL corporate actions taxonomy, expected to be completed in the third quarter, that is aligned with ISO 20022 repository elements.

A week ago, the three organizations published A Business Case to Improve Corporate Actions Communications. Making use of a case study of Pfizer’s acquisition of Wyeth in 2009, the Document analyzes the corporate actions environment, presents the various risks in the current procedures, and makes three recommendations which can be summarized as follows:

(a) Adopt a single set of global information and technology standards for corporate action announcements;
(b) Tag corporate action documents in XBRL based on the global ISO data standard; and
(c) Have intermediaries consume and “seamlessly disseminate” the XBRL data as close to real-time as possible or within a timeframe as requested by investors.

As the Document describes, disclosures of corporate actions are made in “free text” documents – press releases, regulatory filings, prospectuses, and letters of transmittal – issued in PDF, HTML, and ASCII formats, which must be read from start to finish to gather all the information needed by shareholders. In some cases, there is no clear guidance on which regulatory forms must be used and, furthermore, “the issuer’s message follows no standard on what information to include and how it should be structured beyond general filing requirements that are focused on content.”

Moreover, as the Rube Goldberg-like flow chart on page 6 of the Document amply demonstrates, the corporate actions announcement process is enormously complex, with information flowing in many directions from and to many parties, including issuers, wire services, transfer agents, information agents, stock exchanges, securities depositories, brokers, custodial banks, and, not least, investors. 

The upshot is that the same corporate action can be communicated several times from various parties, causing investment managers to review multiple sources of the same information. This task is made still more complicated by the lack of a single ID for each corporate action event. And, as the case study beginning on page 24 notes, the dates of information dissemination can vary widely:

One mutual fund company that received information about the Pfizer acquisition from more than one custodial bank noted that the timing of information received differed from bank to bank. Some custodial banks sent information as early as January 28, while others sent their first notification as late as June or early July. 

All these factors taken together indicate that corporate actions are unusually well suited for the rationalization and normalization benefits that XBRL can bring.

As I read over the well-crafted and convincing Business Case, I did have a few concerns. Currently “the issuer bears the liability for accuracy in the source document and the intermediary bears the liability for data extracted from those documents and presented to the investor. By tagging the data, the issuer will be responsible for both the accuracy of the source document and accuracy of the tagging.” On page 19, the Document discusses the ways in which liability might be shifted from downstream consumer to the issuer.

Will issuers balk at the increase in both their costs (as the Document predicts) and their liability burden? Even if their new responsibilities are mandated, are their sufficient incentives and tangible benefits to make them more than reluctant participants in the process?  

The Document further states:

The business case does not propose replacing the traditional issuer documents with XBRL, merely supplementing them. Issuers have stated that they would feel comfortable with the process as long as the traditional document is seen as the final word from the issuer, as concerns have been expressed that the “nuances” of the originating document might be lost in the tagged items.

I wonder about the utility of XBRL data if the traditional documents are still to be the “final word.” The situations are not strictly analogous, but it is worthwhile to note that the accuracy of corporate XBRL filings under the mandate appears to be significantly greater than those made under the VFP program. And unlike a 10-Q, corporate actions often require shareholder action. Will fiduciaries be willing to put their trust in an XBRL communication that is anything less than the “final word”?  On the other hand, Business Case does recommend that liability for the XBRL instance be equal to that of the traditional document (as with corporate filings, it would be phased in), which may ensure trust in the XBRL data.

Finally, the Document states “For the initial taxonomy, it is recommended that the number of elements be limited and simplified as much as possible to ensure ease of tagging for the issuer and to provide greater certainty around what needs to be tagged.”

Elegance and brevity are always preferred. But big taxonomies, like those of US GAAP, are big for a reason. The taxonomy for mutual fund risk/return summary data can be a mere few hundred tags because the information required is highly prescriptive and limited in scope. Whether or not the same can be said of corporate actions, I’m more concerned that the tagged data be useful than merely that it can be easily tagged.

Even if my concerns are wrong-minded, there’s little doubt that substantial challenges lie ahead. But it’s also obvious that corporate action announcements is a field where XBRL adoption would have enormous benefits. I would encourage you to read the highly interesting and useful A Business Case to Improve Corporate Actions Communications.
 

The SEC’s Mutual Fund XBRL Education Seminar

Written by Bob Schneider
Posted on June 19, 2010 Comments
June 19, 2010 | General, SEC | Bob Schneider

Written by Bob Schneider     Posted on June 19, 2010

With the adoption of Rule 33-9006 last year, the SEC mandated that mutual funds (i.e., open-end management investment companies) provide their risk/return summaries in XBRL format. Gearing up for the compliance date of January 1, 2011, the SEC held a seminar for filers on June 4, which is now posted online along with the accompanying slides. (The presentation is embedded on the page, but click the Windows Media Player link below it for a better view and a lot more flexibility.)

Here’s a roadmap to the 2 ¼-hours presentation which highlights key points and, I hope, helps readers find what they need.

(0:00 to 28:45) These introductory presentations by David Blaszkowsky, Director of the Office of Interactive Data (OID), as well as Andrew “Buddy” Donohue, Stephen Sadoski, and Brent Fields, all of the Division of Investment Management, will be of primary use to those new to XBRL.

(28:45 to 40:00, Slides 7 to 14) Mr. Fields’s discussion of which mutual fund filings require interactive data exhibits, requirements for posting XBRL data on company websites, penalties for noncompliance, liability issues, and so forth will be mostly of interest to practitioners with specific responsibilities for mutual fund filings. Mr. Fields reiterates that on April 12 the SEC announced completion of the updating of all the technology infrastructure necessary for filing risk/return data in XBRL; the risk/return taxonomy, Previewer, Viewer, and EDGAR validator have all been updated.

(40:00 to 1:02:00, Slides 15 to 24) Much of this general overview of XBRL and its use by the SEC by Mr. Sadoski is not specific to mutual funds, but it will be helpful for those relatively new to XBRL. At 49:00 – 50:30, he makes the useful distinction between mapping – the matching of line items within traditional statements to elements in a taxonomy that is typically done by accountants – and tagging, the technical process of representing those elements in XBRL files which is typically performed by IT staff. At 58:00 – 59:15 (Slide 27), Mr. Sadoski’s discussion becomes specific to mutual funds as he describes exactly what XBRL data needs to be posted to the fund’s website. At 1:00:00 to 1:01:00, he discusses important documentation for guidance in filing (Slide 28). 

(1:03:00-1:13:00) Walter Hamscher of the OID begins his talk by discussing the key points (Slide 31) he wants to emphasize:

The 2010 risk/return (R/R) taxonomy:

Is like the US GAAP Taxonomy
"[The 2010 risk-return taxonomy] is intended to be…very consistent with the architecture of the US GAAP and the corporate filings and the other XBRL activities that we are undertaking here at the SEC.”  As with corporate XBRL filings, there is heavy use of text blocks and dimensional tables.

Is only 2% the size of the US GAAP Taxonomy
The taxonomy is not only considerably smaller but considerably simpler. He urges listeners to pay very close attention to the samples the SEC has provided.

Requires few custom elements for most filings
While extensions are common for XBRL corporate filings, they will be relatively rare in risk/return filings. The only extension elements that will need to be created will be those based on series and class identifiers associated with the funds being reported. (Later on, he adds that where there are multiple prospectuses, sometimes there will need to be extensions for those too.)

The SEC Viewer/Previewer upgrades:

Support different layout and styles of tables
The Previewer and Viewer have been substantially upgraded and now offer more flexibility for layouts and table styles.

Renders distinct series in a filing consecutively
Mr. Hamscher says that the corporate filing Previewer did a “rather poor job” of reporting on multiple entities. An enhancement allows mutual fund series to be handled much better.

Integrates closely with the risk/return 2010 taxonomy
The risk/return taxonomy is tightly integrated with the rendering engine enhancements, and the Viewer and taxonomy now work much better together. Mr. Hamscher urged filers to take advantage of this improvement.

(1:13:30, Slide 32) Mr. Hamscher describes three resources that technical staffs will find crucial for successful compliance: Architecture, Rendering Guide, and Sample Instances. (The URL given on Slide 32 for the last item generated an error message for me; I believe I have provided the correct URL here; but please let me know if that's not the case.) He emphasizes that the Sample Instances will be very helpful for filers.

UPDATE 6/22/10    In my original post, the Samples Instances link in the paragraph above pointed to an earlier, superseded group of files. I have corrected the link, and the SEC is correcting the URL on Slide 32.  

(1:15:00-1:48:00) Mr. Hamscher walks the audience through four filing samples with varying numbers of series, classes, and prospectuses (Slide 33). For each, he shows the original document; the rendering on the SEC website; a rendering of the details, i.e., a data view that will help filers check their work; the extension taxonomy; and finally the code in the instance document. He wraps up with a discussion of formatting enhancements. 

(1:50:00 - 2:10:00) The Q&A session. One point Mr. Hamscher emphasizes is that filers should download the Previewer on their own machines (which the SEC has made it easy to do) and use it locally, rather than struggle with wait times on the SEC site.

(2:10:00) – 2:14:00) Mr. Blaszkowsky makes his closing remarks.

As with other SEC seminars, this presentation was highly useful and informative. If your time is limited, I suggest you listen to Walter Hamscher’s talk for about the first half of the second hour to get the gist of the presentation.
 

SPARQL/RDF Is a Cost-Effective Way to Search XBRL Data

Written by Bob Schneider
Posted on June 9, 2010 Comments
June 9, 2010 | General | Bob Schneider

Written by Ashu Bhatnagar     Posted on June 9, 2010

Ashu Bhatnagar is CEO of Good Morning Research, a Softpark company that specializes in building Semantic XBRL technology. The Good Morning Research machine automates XBRL tagging of Excel data in RDF format with one-click Save As XBRL functionality. Mr. Bhatnagar also moderates the Semantic XBRL group on LinkedIn.

Serious financial research analytics rarely start and finish by querying a single database source, no matter how comprehensive that database source may be. Instead, the most common practice involves accessing data from multiple databases and information sources; aggregating, normalizing, and making appropriate adjustments and calculations to the data; and co-mingling it to make it ready for meaningful queries and analytics.

The increasing use of XBRL and standardized taxonomies is not only making source data more normalized and more comparable than before; it is also rendering it amenable to far more efficient and error-free data manipulation, as data re-keying is eliminated.

However, these aspects of the XBRL transformation lie just at the beginning of the analyst’s work-flow, which demands greater automation and improved cost-effectiveness. In other words, there is still more work ahead before this data is ready for analytical queries and alpha mining.

For example, a query to find fourth-quarter revenue data of several large-cap metal, mineral, and mining companies around the globe for a particular year from more than one data source would require the analyst to (a) normalize currencies to a common currency, (b) make reasonable adjustments to account for hyper-inflationary country data, and, finally, (c) apply business rules to account for common differences in companies’ fiscal years (e.g., December versus March year-ends). Such differences make apples-to-apples comparisons on raw data less meaningful and useful.

Enter the Semantic Web technologies of RDF and SPARQL, which create a pathway for cost-effective, efficient, and powerful data analysis:

1. The XBRL file set -- including file, schema, and linkbases – comprises XML files and is therefore highly suited for automated and error-free transformation into RDF/XML format. At this point, we’re still in the “raw data” stage.  
2. Automated machine processing enables aggregating these RDF files into a RDF data store as SPARQL endpoints.
3. The use of SPARQL, a powerful contextual interactive language and tool specifically designed to search/query RDF data store.

SPARQL queries enable selection based on binding variables such as fiscal Q4 to calendar months and other pre-defined business rules, thereby returning a more comparable result set from an underlying raw RDF data store.

Simply put, the task of normalizing and financial adjustments can now be performed interactively and at runtime, which allows more advanced, customized, and meaningful queries to be run against an underlying as-reported raw data set. 

Additionally, unlike a traditional SQL database with its well designed and controlled schema, this RDF data store is highly flexible and dynamic in nature, allowing co-mingling of other Excel datasets transformed into RDF format as well.

In summary, SPARQL and XBRL together enable a more flexible and cost-efficient data store with advanced query tools when compared to simpler queries on more complex and more expensive databases.

Editor’s note: Mr. Bhatnagar will be speaking on the topic of XBRL and SPARQL/RDF at the 2010 Semantic Technology Conference session on June 23 in San Francisco. His earlier posts on the Semantic Web and XBRL are Introducing Semantic XBRL, Semantic XBRL Data Search Using SPARQL, and Semantic XBRL Transparency, Verification, and ‘Raw Data Now’.

 

XBRL Will Help Streamline Corporate Lending in Japan

Written by Bob Schneider
Posted on June 3, 2010 Comments
June 3, 2010 | General | Bob Schneider

Written by Makoto Shibata     Posted on June 3, 2010

Makoto Shibata is Principal Analyst, eBusiness & IT Initiatives Division at The Bank of Tokyo-Mitsubishi UFJ and Chair, Financial Services Working Group at XBRL Japan.

XBRL has been adopted in key financial areas in Japan, including corporate disclosure, tax filing, and regulatory reporting. In 2003, the Tokyo Stock Exchange took its first step toward adopting XBRL by enhancing its Timely Disclosure Network, or TDnet, to support the data standard.  In 2004, the National Tax Agency adopted XBRL for its online tax return filing and tax payment system, known as e-Tax. The Bank of Japan (BOJ) adopted XBRL in 2006 for gathering financial data from banks and, in 2008, the Financial Services Agency (FSA)  renovated its electronic corporate disclosure system (EDINET) for XBRL and mandated its use for financial reporting by public companies.  

A natural consequence of the adoption of XBRL by Japan’s regulatory bodies is that private-sector users of financial information are increasingly using XBRL data to their own advantage. In corporate disclosure, for example, new analytical tools and web sites have been created for EDINET and TDnet data.  It is interesting to note that some of the new approaches are coming from outside of the XBRL community.

An excellent example of the way the financial community is now utilizing XBRL is the use of e-Tax filing data by bankers.  The National Tax Agency now mandates that corporations attach XBRL financial statements with their electronic corporate tax filings and, for the fiscal year ended March 2010, more than 1.2 million corporations used e-Tax filing.

For many years, Japanese banks have been using the attached financial results of corporate tax filings for credit analysis.  However, it takes a significant amount of time for banks to manually enter data into their loan processing systems from the paper financial statements obtained from borrower corporations.  The inefficiencies of this process are especially notable in May and June, when banks need to allocate major resources to process their financial reports for March-end statements.

To cope with this challenge, various attempts had been made in the past to acquire financial information in digital format. But they have been far from successful, because the data format and account items were not standardized. Now, if banks can obtain borrowers’ financial data in XBRL format, the efficiency of lending and credit management functions can be improved dramatically by processing the data systematically.   

My bank, The Bank of Tokyo-Mitsubishi UFJ, was the first bank to begin using XBRL e-Tax filing data in 2006, and other mega-banks in Japan followed soon after. As the graphic below indicates, dedicated web sites were set up to allow banks to download the data.  

Makoto52710

 

The loan customer (or their tax accountant) requests the National Tax Agency to download their filed e-Tax data and, once downloaded, it is sent to the lending institution. It is important to note that the bank does not obtain data directly from the National Tax Agency; it only receives data with the permission of the loan customer who filed it.  At that point, the bank can utilize this XBRL data for credit analysis without entering figures manually.

Although only the Japanese mega-banks are currently accepting XBRL e-tax data and the number of customers submitting e-Tax data to banks this way is still limited, the progress made thus far nevertheless represents a significant advance for XBRL usage in the banking industry.  I look forward to continuing efficiencies and improvements in data processing and analysis from the adoption of XBRL by Japan’s financial institutions.