Tuesday, March 31, 2009

XBRL CANADA WEBINAR - APRIL 15TH

XBRL Canada is offering a FREE Webinar on April 15 on the subject of Regulatory Filings for Canadian Companies. There will be speakers outlining the impact of the SEC rules of Canadian companies, as well as the landscape for CSA filings. The focus of the Webinar will be on practical help in dealing with the new regulatory environment. A significant section of the Webinar will be devoted to a vendor showcase where their tools helpful in the filings process will be demonstrated.
XBRL Canada Members who are interested in participating in the Vendor showcase should contact info@xbrl.ca or gtrites@zorba.ca.
The Webinar will run from noon to 4:00PM Eastern.

Sunday, March 22, 2009

IASC Foundation XBRL Update

XBRL · Tags: ,

A few days ago the IASC Foundation released its quarterly (from now on) XBRL Update, a newsletter that covers XBRL activities related to IFRS. In the section reserved to Canada the newsletter features the Convergence Assistant (CA), a joint effort between the Canadian XBRL Jurisdiction, the XBRL Global Ledger Working Group and Iphix to provide a tool to facilitate the transition from Canadian GAAP to IFRS for Canadian businesses.

The CA is a free Web application that showcases the value of XBRL’s Global Ledger; you can upload a trial balance in text or XBRL GL format, and then create XBRL GL, multi-GAAP and IFRS XBRL instances based on predefined mappings between a Standard Chart of Accounts and the relevant XBRL taxonomies - in this particular version the Canadian GAAP and IFRS taxonomies, but the tool supports any XBRL taxonomy, including taxonomies for internal reporting . The XBRL instances can then be downloaded and used as desired.

The CA also includes a user interface to drill back down from the financial statements to the underlying trial balance detail, and to automatically reconcile different “views” of the financials based on different XBRL taxonomies. The use of the CA is free; sample data is also provided to test its functionalities.

Monday, March 16, 2009

How XBRL can help the Securitization Market
by Gerald Trites

Various people in the XBRL community have been saying that XBRL can help the market for securitized instruments, such as Mortgage backed Securities, and could have helped if used before the recent crunch. While XBRL may not be a panacea, nevertheless, part of the problem with complex instruments has been a lack of information about their true value. This has affected investors trying to determine a price and also has affected accountants bound by mark-to-market rules in determining a proper carrying value for reporting purposes.

XBRL US has been doing some interesting and valuable work in trying to explain how and why XBRL can help. Recently it issued a white paper, which can be downloaded free from the XBRL US site. The white paper explains how the various layers within the securities could be tagged such that investors could drill down through the layers to find the true cash value of the securities. This requires a different kind of XBRL implementation than we have generally seen so far. Indeed, it is akin to the idea of deep tagging, which is a methodology that has been espoused by several , including a research study published by the CICA last year called "Interactive Data - Integrating XBRL into Accounting Information Systems". That study explores how XBRL can be implemented within an information system, such that the tags can roll up through the system and carry the attributes of the information with them to the top.

To date, most companies have implemented XBRL by simply tagging the financial statements after they are completed. All this does is to put the statements into a different form, one that can be read by other computer systems and that can facilitate processing of the information by analysts, but one that does not look down into the data. One that does not achieve the real benefits of XBRL.

What XBRL US and others are trying to demonstrate is that XBRL has benefits that have not yet been tapped and the white paper shows how this would work.

Mark Bolgiano, CEO of XBRL recently testified before the Domestic Policy Subcommittee hearing of the Oversight and Government Reform Committee on a similar issue. He explained how "the use of a free, open-source technology standard (like XBRL) can be used to provide citizens, government and investors consistent, comparable reporting on the existing pool of securitized assets, help regulators track the disbursement and use of TARP funds and enable more effective regulation by government." Some details of his testimony are in set out in an XBRL US press release.

XBRL is a tool that is needed to enable investors to cope with sophisticated investment instruments and to enable accountants to report on them. While the market for such instruments is at a low (sic) right now, we can be sure that we haven't seen the last of complex layered investment securities. We need to be ready for the next round.

Wednesday, March 11, 2009

Free the Data: eGov and Open Standards


by Diane Mueller

When President Obama appointed his new federal CIO, Vivek Kundra, last week, Kundra announced ambitious plans to "democratize" federal government data by making it accessible in open formats and in data feeds. His plan calls for the creation of a single point of access to all public federal information. The idea is to enable the data to be accessed by developers whose applications will open up federal data to the sunlight of millions of citizens by encouraging them to scrutinize how the Recovery Act’s dollars will be spent.

As chief technology officer for the District of Columbia, Kundra raised the bar by making government data more readily accessible to its residents, leveraging pre-existing Web 2.0 technologies like Facebook and YouTube.

Federal agencies are now banding together to plan for how they are going to provide this information in an open, standardized manner that enables citizens to efficiently and accurately mine data, make comparisons, and perform analytics across all government sectors.

All this accessible data sounds well and good until you start looking at it from a developer’s point of view — there is currently little or no uniformity across government agencies for reporting granular federal financial data. With billions of dollars being funneled in grants, loans, and loan guarantees, there needs to be a standard ‘open’ format and shared re-usable taxonomy for both applications and reporting.

What Can We Anticipate from Kundra?

While Kundra’s announcement caused quite a stir in the technology sector, it still remains to be seen if he will have the authority to mandate change or if he will just be a technology advisor to Obama. His role may be limited to making technology recommendations which then have to be adopted into individual agency policies instead of presenting a common technology policy for the government as a whole.

One can only hope that one of Kundra’s first recommendations includes leveraging what has become the de facto global financial reporting open standard — XBRL — to tag and track the billions of Recovery Act dollars. The Obama Administration has committed to enabling an unprecedented level of transparency and accountability so Americans know where their tax dollars are going and how they are being spent.

Kundra will have to look no further than to the U.S. SEC’s use of RSS feeds and FTP sites to post the recent filings as XBRL. The SEC’s bold move enabled developers to build applications to consume and analyze the data in almost real-time with levels of data accuracy and granularity that could never before be achieved with screen-scraping from untagged data or PDF formats. Previously, the information was only available in normalized data feeds from pay-per-view data aggregators. In another encouraging example and move towards transparency from China, the Shenzhen Stock Exchange (SZSE) recently announced that it has rolled out a platform enabling the download of listed companies’ information tagged with XBRL. As the global financial community moves to free up data in a more accessible manner, the time is now for the U.S. federal government to take similar actions.

It remains to be seen if XBRL will be adopted to track the disbursement and use of the Troubled Asset Relief Program (TARP) funds, enabling more effective regulation and providing investors consistent, comparable reporting on the existing pool of securitized assets. Hopefully, Kundra will be listening when XBRL-US presents its report to the Domestic Policy Subcommittee of the Oversight and Government Reform Committee in a hearing today in the U.S. Congress on “Assessing Treasury's Efforts at Preventing Waste and Abuse of TARP Funds.” Yet another opportunity to leverage open standards to aid in federal transparency efforts.

In a recent memorandum , the Office of Management and Budget’s (OMB) Director, Peter Orszag, describes a planned May 5th launch of a series of Award Transaction Data Feeds. All federal agencies will now be required to provide all Recovery Act assistance transactions in the standard format currently provided to USASpending.gov. In the memo, Orszag placed a high priority on delivering an “accurate display ” of information related to the Recovery Act on Recovery.gov. Federal agencies are now scrambling to ensure they comply and that all reporting related to Recovery Act funding is complete and accurate.

It’s not a “window to the federal data” that will allow developers to leverage and create valuable applications, but rather access to the raw data itself , preferably with open standards-based tags from a shared common federal taxonomy of terms.

We’re tired of screen-scrapping and trying to data map disparate data sources across federal government agencies. Hopefully federal agencies like the OMB will listen to Kundra and take a page from Facebook and the iPhone and create an open standards-based platform. Then, the application developers will come in droves.

Building an app is easy when you don’t have to worry about shifting data sources, proprietary platforms, and an ever-changing myriad of web services.

Creating a Comprehensive Plan

The key to the success of this plan is to ensure that there is some agreement across all federal agencies that defines a shared common ‘open’ data standard and identifies how deeply they are willing to push the tagging of data gathered into the collection processes for Recovery Act funding applications and into the financial reporting between the federal, state, and local agencies who are to be the recipients of the Recovery Act funds. Currently, the plan is to only go one level deep — the federal agency will require recipient reporting only from the primary agency receiving the funds.

For instance, a grant could be given from the Federal government to State A, which then gives a sub grant to City B (within State A), which hires a contractor to construct a bridge, which then hires a subcontractor to supply the concrete. In this case, State A is the prime recipient and would be required to report the sub grant to City B. However, City B does not have any specific reporting obligations — nor does the contractor or subcontractor — for the purposes of reporting to the Recovery.gov website.

In Spain, XBRL has been used right down to the municipal level for the reporting and monitoring of Local Government Budget Reporting; there’s no reason not to encourage all levels of government agencies to increase information sharing.

Kundra’s Potential Impact on XBRL

Kundra could really drive XBRL forward by insisting that all the data, right down to actual recipients, be made available as long as that data did not breach privacy and security of individuals. As accounting packages and ERP vendors like SAP are all adding XBRL export functionality to their offerings to facilitate SEC filings, it would be a natural next step to get XBRL-tagged reports all the way down to the contractor and sub-contractor levels.

Obama's team should really take a close look at the Dutch and Australian efforts to breakdown the governmental information silos with their move to a Standard Business Reporting (SBR) approach. The Dutch and Australian governments recognized the interdependent nature of government agencies and the increased need for information-sharing via a standards-based approach and are relying heavily on the XBRL standard in their eGov efforts to give their countries an extra edge of efficiency.

Kundra should court developers by providing an open standards-based, open source tool chain, giving examples and explaining in clear language how to create applications in the same manner that Apple and Facebook have done. If built on the solid open data standard foundation laid by U.S. SEC and the XBRL consortium, this should ensure — as long as data is free and open — that applications will flourish and shine some long-awaited sunlight on government spending.

Empower the world's developers to make the Recover.gov data more useful and understandable for users rather than creating reliance on Federal government contractors to develop more websites for displaying data. Developers everywhere are eager to create meaningful applications that will connect users to financial data and solve real-world problems. Free the data, and the application developers will follow.

Diane Mueller has been actively involved in the development efforts of the XBRL standard for the past nine years. She is the Canadian representative to the XBRL International Steering Committee, serves as Vice Chair of that body, and chairs the XBRL Working Groups on Rendering and Software Interoperability. She currently serves as vice president of XBRL development at JustSystems, the largest independent software vendor in Japan and a worldwide leader in XML and information management technologies. Learn more about JustSystems at http://www.justsystems.com, and contact Diane at diane@justsystems.com.

Thursday, March 05, 2009

Here's the second part of the interview with Bob Schneider for the Hitachi Blog:


One of the issues discussed here is the question of how to handle the adoption of the IFRS taxonomy in Canada. XBRL Canada has a task force in place to investigate and support this implementation and to review the development of any extensions to the taxonomy to see that they meet CAnadian needs.