XBRL : the Best Answer to the Business Register Interconnection Directive in Europe (Part II)

Written by Alexandre Lezmi and Thomas Verdin
Posted on June 12, 2013 Comments
June 12, 2013 | General | Barron King

The XBRL standard and the xEBR taxonomy

In our opinion, XBRL may be the best answer to BRIS. It may probably be associated to other solutions, such as the e-CODEX network that brings the infrastructure but needs a BR-specific message format.

It seems that XBRL is the best candidate just because many initiatives launched by business registers are already using it in Europe. Millions of XBRL balance sheets are currently available online. It is the only common language shared by so many registers and it is therefore the best language to speak together.

One other important asset is the XBRL Europe Business Registers Working Group (xEBR WG). Created as a technical committee of XBRL Europe in 2008, to increase the coordination and interoperability for European business registrars’ XBRL efforts, the xEBR WG gathers members of the European XBRL jurisdictions, business registrars, data providers and software editors settled in the European Union.

Since 2010, it provides a common core reference taxonomy that includes main concepts for company identity and financial statements in Europe. This taxonomy has been presented previously on this blog: Interoperability Within Business Registers Using XBRL and is now available online on the XBRL Europe webpage. The xEBR members have built up a mapping of their national accountability systems and taxonomies with the xEBR core taxonomy. The latest use case set up by the working group proves the feasibility of a cross border analysis and rendering of local documents based on local taxonomies linked via the xEBR model and mappings.

Based on the xEBR taxonomy, the xEBR WG has more recently built up an electronic model for interconnection messages, which meets the directive requirements regarding the information that the registers will pass from one to another. The model relies on data defining the issuer as well as the addressee amongst the European registers, the nature of the occurred events (cross-border mergers, head-branch relationship, crossing off…), and the profile (identity) and financial information of the concerned companies.

The xEBR taxonomy has the advantage to cover all the required data and to structure them through a common logical architecture. As the registers already dispose of files in the XBRL format (especially for financial data), they can benefit from the existing direct mappings to link their data with the xEBR elementnames in the xEBR taxonomy. Moreover, the proposed model has the essential advantage to incorporate links which leads to the original and verified data registered in the official register data base instead of copying them in the message. This methodology meets the fundamental requirement that each register will always keep the control on data that it stores locally.

Some registers acting on behalf of the working group presented this model to the European Commission representatives on February 28th 2013 in Brussels. And confirmed their hope to develop this initiative with the global community of registers, to meet the directive requirements and offer additional exchanges.

Going further than the directive’s requirements

Indeed, the use of XBRL and of the xEBR taxonomy also offers the opportunity to go further than the directive requirements. Business registers such as Infogreffe (France) and Infocamere (Italy) decided to capitalize on the work undertaken by the xEBR working group in order to set up a regular data exchange between them. It uses the same message model as those that were presented to the EC. Web Services (some of them are presently under development) provide the technical infrastructure to send and receive the messages.

In this example, XBRL is used to connect two registers in an extended use of the taxonomy, which covers a large perimeter of concepts, wider than the data required by the draft implementing acts or wider than the existing dataset which are currently exchanged on EBR or forecasted by UBL.

Even if not foreseen by the directive, XBRL also allows including electronically signed PDF documents. This is quite useful to attach the legal acts to the interconnection messages. This benefit is to facilitate the agreement between registers on the transmitted information; even if the related companies do not transmit it by themselves (as some national laws require the reception of the official act before doing any change in the registered data).

In addition, XBRL provides consistency checks that ensure the quality of exchanged data and provide multilingual labels (the xEBR taxonomy is translated into nine languages). For all these reasons, we consider that XBRL represents today the most advanced solution to fulfill the European Commission Interconnection Directive requirements. Eventually, as it is extensible by nature, it also appears to be the best option to offer extended services.

 

XBRL : the Best Answer to the Business Register Interconnection Directive in Europe (Part I)

Written by Alexandre Lezmi and Thomas Verdin
Posted on June 5, 2013 Comments
June 5, 2013 | General | Barron King

This article aims to analyze XBRL as a solution to answer the technical and organizational requirements of the EC Interconnection Directive for business registers in Europe. It also explains why the XBRL standard better fits with the directive requirements than any other proposed solution, and how XBRL may bring further opportunities to the first interconnection steps made by the directive.

The EC Interconnection Directive

A business register is the official body in charge of collecting and publishing legal and economic data from private companies.

The European Parliament and the European Council adopted on June 13th, 2012 the Interconnection Directive (2012/17/UE) for business registers in Europe. This new text amends the former 89/666/EC, 2005/56/EC and 2009/101/EC directives. It aims to improve cross-border access to company information by requiring Member States to electronically link their business registers.

The European Commission targets to facilitate transparency and reliability of the information, as the directive requires available data on companies should be more regularly updated, especially for cross-border operations. This will help to promote confidence in the European internal market.

Furthermore, the directive introduces the use of a unique identifier for company’s branches. This may be a significant progress as today there is no standard numbering format for companies across Europe, or even in some cases across a single country.

Each Member State shall pass a national transposition of the Directive no later than July 7th 2014 for entry into force in 2017. However, the European Commission has first to define and confirm the data content, the practical organization, the system and technologies that will be used to create the Business Registers Interconnection System (BRIS), so called by the directive. This has to be defined by implementing acts, which are to be published before July 2015.

Different solutions are proposed to interconnect the business registers in Europe, but none of them has been selected yet.

The available technical solutions

Of course, XBRL is used by many business registers in Europe. So it may appear as a good starting point. However some alternative ideas have been proposed to meet the directive requirements. One can name various candidates, such as the UBL standard (Universal Business Language), the EBR infrastructure (an existing network of business registers and information providers), the RMS project (a system to exchange messages proposed by Germany) or the eCODEX project (a EU-funded project to connect national Ministry of Justice).

The Universal Business Language (UBL) is an XML-based dedicated format to exchange electronic data between companies (mainly SMEs). The format contains information that is exchanged via commercial paper forms (orders, product catalogs, delivery notification, and invoices). UBL was developed by OASIS (Organization for the Advancement of Structured Information Standard), a US consortium that drives the development and convergence of electronic standards applicable to e-business and web services. UBL was not initially designed and is therefore not immediately suitable for the exchange of legal information on the identity of the companies.  It doesn’t neither provide data model for financial items. As it is only used in English, this format does not completely meet the multilingual requirements of the Directive.

The European Business Register (EBR) organization is the result of many years of voluntary cooperation between business registers. The mission of EBR is to promote legal and practical coordination between registers including the provisions of a platform for inter-register communications. The legal entity responsible for the operation of EBR is the “European Business Register EEIG”, a European Economic Interest Grouping registered in Belgium. Even if the messages exchanged between EBR members use standardized templates, they are not as widely recognized and opened as the XBRL format is. It also seems that currently the electronic signatures, essential to ensure the legal certainty of the messages, are not in operation on the EBR system and require further developments, which implementations may be uneasy.

The e-Justice Communication via Online Data Exchange (e-CODEX) is another possible line of inquiry. It is a European-wide project for the interconnection of Ministries of Justice. The goal of e-CODEX is to improve the cross-border access of citizens and businesses to legal means in Europe as well as to improve the interoperability between legal authorities within the Union. Even if it may be a bit complex to adapt, as business registers do not exactly relate to the Ministry of Justice in many countries, e-CODEX appears as an interesting infrastructure for electronic exchanges; when XBRL should be a candidate to describe the structure of the exchanged data.

The latest initiative is RMS. It is a solution for registered messaging system development in Germany. We do not have much more information about it and that translates the fact that it is not really used by the business registers.

Part II coming soon...

XBRL Data – What is it Good For?

Written by Dave Frankel
Posted on May 29, 2013 Comments
May 29, 2013 | General | Barron King

If you ask reporting managers, C-level executives and professional investors today about the value of XBRL, they are likely to channel the classic Edwin Starr anthem “War! (What is it Good For?)” by responding with a resounding “Absolutely nothin’!”

This is not exactly what the SEC had in mind when it handed down its mandate. The good news is that XBRL no longer has to be this way. As my colleague David Anderman stated, when reporting managers combine a disciplined approach to disclosure authoring with an understanding of how the data will be analyzed, the result is an extremely valuable dataset that can be leveraged for corporate governance, risk and compliance (GRC) efforts and that investors can use as a basis for investing decisions.

So what is quality XBRL data good for? When used with the right analytics solutions, there are three benefits to consider:

  • Transparency: Disclosures that are authored accurately and with the end result in mind allow consumers to gain a clearer picture of what is occurring within a company. Institutional investors are pushing for increased transparency and greater insight into what is driving corporate operations. While many executive teams may look at this requirement as a burden, accurate XBRL filings can be a valuable investor relations tool to clearly communicate the true story of a company’s value to its stakeholders.  For example, companies listed on the OTC market are not required to submit XBRL disclosures to the SEC, but are deploying this technique in order to provide institutional investors with key data points to better understand the businesses in which they are investing. This reporting both increases liquidity in their shares and allows investors to spot emerging areas of growth faster.
  • Comparability: There are two primary ways XBRL can be used for analysis: internal benchmarking historically and across peers. Overuse of extensions makes comparability nearly impossible, as it creates holes in historical comparisons and renders peer-to-peer analysis useless. Where is the benefit in creating technically accurate data if the consumer finds it irrelevant? By deploying a consistent, disciplined approach to XBRL tagging, particularly using solutions that can suggest tags, reporting managers create data that is BOTH accurate and relevant. This enables corporate executives to more quickly spot trends in their company information and allows investors to use analytics to dig deep into company-to-company comparisons.
  • Risk management: Enterprise risk management is not just a C-suite concern; it is now a board of directors concern. XBRL disclosures should be integral to corporate risk assessment, mitigation and management within an organization. With the organization authoring thoughtful disclosures and making appropriate tagging decisions, the ability to do deeper risk analysis across all areas of the business and financial statements improves significantly. With the growing proliferation of data within an organization, executives are under a tremendous amount of pressure to make better decisions faster. Quality XBRL tagged data combined with powerful analytics applications is becoming a core tenet of this initiative.

So again, I ask, “XBRL: What is it good for?” Once disclosure authoring shifts from an accounting compliance task to a key step in accurate data production, the answer will be more rewarding for producers and consumers.

By Dave Frankel, president of EDGAR® Online, an RR Donnelley Company

The Chicken and Egg of XBRL Data

Written by David Anderman
Posted on May 22, 2013 Comments
May 22, 2013 | General | Barron King

While the volume of publicly available XBRL financial data has exploded with the SEC mandate, the utility of that data has lagged far behind. Most issuers today would characterize XBRL as an additional regulatory burden from which they derive no benefit. The XBRL promise of faster and more accurate data for better comparability has not been realized. The high use of custom extensions makes comparing all but the simplest financial statements very difficult. If we accept that XBRL will continue to be a reporting requirement, particularly in light of the calls for more market (and government) data transparency, then it is incumbent upon issuers to focus on the quality of their XBRL data to increase its utility. Higher quality data will increase investor usage of XBRL and will provide issuers a new avenue for shareholder engagement.

Quality data begins with XBRL tag selection and minimizing the use of custom extensions. In addition to facilitating comparability for the investor community, the use of standard tags can benefit a company through more effective competitive benchmarking. Creating business rules that are directly tied to an XBRL data set can complement best practices around enterprise risk management. As more sophisticated tools for the consumption of XBRL data become available, issuers will benefit from more insight about the specific areas of their disclosure on which investors are focusing. For an organization to focus on XBRL quality, it needs to look at the tools and teams available to help it realize the benefits of data consumption and analysis.

From a software perspective, organizations should select a tool that helps streamline content creation, review and distribution of XBRL disclosure to improve efficiency, governance and the overall quality of all financial reports. Any tool must be supported by a team with XBRL expertise. If the expertise does not exist in house, then an organization must look for a partner that is willing to do as much or as little of the process as needed. The goal is to create an integrated approach to support the organization’s financial disclosure process. With a collaborative process where various members of the executive team have input – including those financial executives who will use the data for downstream analysis – additional significance is added to how the data is tagged.

When disclosure authors commit to this level of care with the data, organizations will begin using it more frequently and investors will begin to rely upon it, as my colleague Dave Frankel will discuss in our upcoming post about the future of XBRL data consumption.

 

By David Anderman, vice president, marketing and business development, RR Donnelley Financial Services Group

 

Calcbench’s Web-Based Tool Gives Easy Access to XBRL Data

Written by Tammy Whitehouse
Posted on May 8, 2013 Comments
May 8, 2013 | General | Barron King

As founders of a small technology data start-up company, Alex Rapp and Pranav Ghai have become big names in the burgeoning world of XBRL. They have engineered a tool for viewing and analyzing data in XBRL, and it’s freely available on their website through a simple registration process.

In developing the tool -- and it’s a work in progress -- they’ve learned a great deal about the potential and the limits of XBRL as it is used presently in capital markets. First of all, they’ve come to recognize the seriousness of the error problem that the Securities and Exchange Commission keeps pounding.

“The common complaint we hear from users is about errors, extensions, and other inconsistencies,” said Rapp at an AICPA conference session devoted to XBRL use. As Rapp and Ghai have worked to develop their open-source application, they’ve discovered and corrected an estimated 1 million errors, he said. With the Securities and Exchange Commission reporting it has gathered 35 million separate financial statement data points in XBRL, that represents an error rate of about 2.8 percent.

As an example, Rapp said errors in simply describing the submitted document and the entity are “epidemic,” present in 3 to 5 percent of all filings. Companies also make mistakes in creating extensions where elements are present and available in the taxonomy, making comparability difficult or impossible.

Rapp said he and Ghai also hear investors say the XBRL repository doesn’t yet contain enough information to be useful, although that’s a problem that only time can correct. He said investors and analysts also are frustrated by how difficult it is to learn and use XBRL given the present limited availability of user-friendly applications.

Ghai provided accountants and preparers with a “test drive” of its website, flipping quickly through individual company filings, side-by-side filings, and aggregate industry data. “Five, eight, ten years ago, you were paying someone a lot of money to do this for you,” he said. He acknowledged there’s a great deal of demand for MD&A and data like audit fees to be presented in XBRL.

Calcbench won the inaugural XBRL US Challenge by developing an open-source application that would enable investors to begin using XBRL data.

 

Companies Say They Find Little Use for XBRL-Formatted Data

Written by Tammy Whitehouse
Posted on April 17, 2013 Comments
April 17, 2013 | General | Barron King

Corporate finance executives are getting more vocal over their frustration with XBRL. At a recent Financial Executives International conference, executives said they aren’t using financial data formatted in XBRL for their own data research purposes. They’re simply submitting their financial data in the XBRL format to meet a regulatory requirement.

“This isn’t something I’ve heard my analysts say is useful,” said Nick Cyprus, vice president, controller and chief accounting officer at General Motors at the FEI conference, according to CFO magazine. Finance chiefs at McCormick & Co. and at Johnson & Johnson echoed Cyprus.

Stephen Cosgrove, vice president, corporate controller and chief accounting officer at Johnson & Johnson, reportedly said his own research tools are more sophisticated and capture more than XBRL provides. “We see absolutely no use for it,” Cosgrove said. “It’s just redundant to what we already have.”

Michael Kaplan, a partner at international law firm Davis Polk, asserted that companies are having a hard time adhering to the reporting requirement, whether they perform the job entirely in house or outsource some portion of the tagging. Companies also are finding that the filings and formatting are targeted to investors needs, not internal corporate needs.

The Securities and Exchange Commission isn’t oblivious to the concerns. Paul Beswick, acting chief accountant at the SEC, reportedly said at the FEI conference that his staff has heard from many people who have shared their challenges and their concerns about whether investors are making good use of XBRL-formatted information. He said the SEC’s economic analysis group has found that data aggregators are using XBRL information and find it helpful.

Charles Hoffman, an accountant who helped develop and promote XBRL, said acceptance and utility will follow software development. “There’s no way you can bolt on or send out to a financial printer to have more work done and then have the CFO say with a straight face that there’s any value being created,” he said. The value comes, he said, in changing systems so that numbers are managed and financial statements are created in XBRL rather than converted to XBRL after the fact.

Hoffman predicts the advent of newer and better software will make XBRL more useful to companies internally. He predicts new releases will be rolling into the market in mid to late 2013.

 

India: On the Road to XBRL-Enabled Financial Reporting

Written by Chandan Goyal
Posted on April 10, 2013 Comments
April 10, 2013 | General | Barron King

XBRL enabled Financial Reporting is not new to India, it was one of the initial countries who adopted the XBRL enabled Financial Reporting in as early as October of 2008; though the scope of reporting was very limited. It was introduced on a larger scale in the Financial Year of 2010-11. In India, a majority of companies follow the Financial Year starting the 1st of April and ending on the 31st of March. In the 1st year of applicability, approximately 25,000 to 30,000 companies were covered, which constituted merely 3% of approximately 900,000 companies registered in India with the Ministry of Company Affairs (MCA).

Recently, we completed the 2nd year of XBRL enabled Financial Reporting for commercial companies.

In the 2nd year (Financial Year 2011-12), it was expected that the number of companies covered for XBRL Reporting would be increased to at least twice of the present number, but it was kept at the same level. The tagging requirement in the 1st year was not very elaborate, which impacted the quality to a greater extent. So, instead of increasing the number of companies covered for XBRL reporting, MCA increased the scope of detailed tagging and asked the companies to focus on quality of data conversion in XBRL format.

To achieve the real benefit of XBRL enabled Financial Reporting, all companies need to be brought under the applicability net and a mass Education cum Training and Development program should be launched by MCA in collaboration with various Professional Bodies and Corporate Institutions.  Furthermore, MCA also needs to focus on the quality of XBRL software being developed by the software companies.

MCA’s verdict on the quality aspect for 2nd year filing is awaited, and at the close of 3rd Financial Year (2012-13) there is no clarity about the class of additional companies to be covered under XBRL reporting. Timely communication on this aspect will help companies to prepare themselves in advance to adopt XBRL reporting.

 

A Digital Guide to Accounting Using XBRL

Written by Neal Hannon
Posted on April 3, 2013 Comments
April 3, 2013 | General | Barron King

Lying just under the surface in the markup language and taxonomy designed for SEC financial reporting, the extensible business reporting language (XBRL) carries a wealth of accounting information that has never been as accessible as it is today. Within seconds, you can examine the 10K or 10Q of a publically traded company and find out the definition of each line item on the financial statements and gain further insight into the information contained inside notes to the financial statements. Want to see how companies big and small are dealing with the latest accounting standards change? Look no further than XBRL. All of this and more is available now and it is free.

A little later in this article I’ll introduce you several online and smart phone tools that will help you unlock the accounting heretofore hidden in financial reporting. First, let’s take a look at where accounting was prior to XBRL, the SEC’s mandate and the ASC or Accounting Standards Codification as maintained by the Financial Accounting Standards Board (FASB).

Prior to 2004 and the start of the SEC’s Voluntary Reporting Program (Rallying Around the Final XBRL Rule and SEC Proposes Rule Mandating XBRL Financial Reporting), accountants who needed to know more about the accounting backing a company’s SEC filing, little information was publically available. When a company reported “deferred tax liability” for example, no one but the firm and their outside CPA assurance team knew for sure what they had in mind and what accounting authoritative literature was being followed. The SEC, working with the FASB and XBRL US (see http://xbrl.us/Pages/about.aspx) set the stage for higher accounting visibility in corporate business reporting by requiring most financial disclosures sent to the SEC be coded in XBRL that contain real information about the accounting behind the submissions.

Accounting Definitions and ASC
Inside XBRL each accounting concept in the US GAAP taxonomy receives two specific links to accounting. The first link is a definition that explains the accounting concept represented by the taxonomy. The second link is a reference to official US GAAP as described in the Accounting Standards Codification (ASC). Each definition and link to ASC are reviewed by FASB, the SEC and the public before they are included in the official taxonomy release.

Refinements to the definitions and links to the ASC contained in the US GAAP taxonomy are maintained by the Financial Accounting Standards Board (FASB). Updates to US GAAP as published in the ASC now include implementation guides detailing suggested accounting treatments and suggested XBRL treatments.

The XBRL Implementation Guide series is part of the continuing effort of the Financial Accounting Foundation (FAF) and the FASB to improve use of the Taxonomy (See http://www.fasb.org/jsp/FASB/Page/SectionPage&cid=1176160665046 for access to the implementation guides).

On March 28, 2013 the FAF published the fifth in a series of implementation guides. J. Louis Matherne, Chief of Taxonomy Development for the FASB, commented "FASB is committed to providing guidance to the preparers of financial statements through the issuance of implementation guides. Demonstrating updates to the ASC using possible XBRL implementations will help preparers get the changes right."
A Quick Guide to Online Accounting Resources
Ok, short of carrying an SEC financial reporting professional around in your back pocket, here are a few great places to find up to date accounting information at the tip for your fingers.

  • XBRL Cloud’s EDGAR Dashboard: Features a quick guide to recent SEC filings including and in-depth look at the accounting definitions and authoritative literature backing each element chosen. Use the interactive viewer to see the accounting. All company filings are visible which allows you to see how companies are mapping actual reporting to the official US GAAP taxonomy.
  • WebFiling’s Taxonomy Analyzer: Type in an accounting concept and you will see all the XBRL elements associated with the concept, a view of where it appears in financial statements and a method for seeing what other elements in the taxonomy are closely related. In the comparative mode, the taxonomy analyzer allows you to view the accounting treatments of up to five companies side by side.
  • XBRL.US’s taxonomy viewer was developed by CoreFilings and features a pre-load of the world’s most popular taxonomies. Curious about IFRS reporting? The Yeti tool will allow you to load the IFRS taxonomy and explore concepts. A preview of the new XBRL US GAAP taxonomy (SEC pending) is now available.
  • SEC XBRL Viewer: Using United Technologies as an example, click on a financial statement and then hover over a reporting concept. What will be displayed is the definition of the accounting concept and a link to the authoritative literature that stands with the definition.
  • The BRIX Project app for the IPhone. This tool can be used to do some very cool things. First, you can look up accounting concepts, and then you can ask the app to find companies that are using the concept in actual filings. Talk about having a financial reporting expert in your pocket! Want to provide accounting help in a meeting? Pull out your smart phone and dial up the accounting treatment of your choice.
  • ASKaRef is an online tool for accountants to discover the link between an accounting concept and the XBRL definition and the ASC. This very easy to use tool has the US GAAP 2012 taxonomy as the base for finding the accounting linkage. The beauty of the tool is how quickly you can find the ASC that backs up the taxonomy. Straight forward accounting concept to taxonomy element to ASC. No actual financial reporting can be seen with this tool.
  • FASB’s Implementation guides and reference guide: From the FASB.org website, “The objective of the U.S. GAAP Financial Reporting Taxonomy (UGT) Implementation and Reference Guides is to provide preparers with additional insight and supplemental guidance for utilizing the UGT as they create their XBRL documents.” The guide can also be used by non-taxonomy accountants to discover how to implement new ASC pronouncements.
  • XBRL.US XBRL Challenge entries. For the past three years, XBRL US and sponsors have offered a challenge to the financial community to create innovative tools using XBRL. The results can be found on the link above. An example of a winning entry is the 2012 winner CalcBench, a free online benchmarking and industry analysis tool.

Each of the above applications and websites has tools that can get you a whole lot closer to the accounting that stands behind SEC reporting. As always, you should seek the help of trained professionals to find the best way to represent your company’s financial accounting. However, you now have just as much access to the most current and up to date accounting information as most accounting firms. Good luck!

9W Search Demonstrates Consumption Potential for Data Formatted into XBRL

Written by Tammy Whitehouse
Posted on March 27, 2013 Comments
March 27, 2013 | General | Barron King

For years, XBRL proponents have provided the upstream push for interactive data, believing tech savvy entrepreneurs would see opportunity in producing applications that would enable consumer uses for financial data never before imagined. Susan Strausberg is one such entrepreneur. She is the founder and former CEO of EDGAR Online, and she is now getting a new technology venture off the ground, 9W Search. Hitachi Data Interactive recently caught up with her at her Austin, Texas headquarters to learn more about the venture.

What is 9W Search?

9W Search is a new technology firm founded by my partner, Marc Strausberg and myself. It is a next-generation financial platform that makes it easy for consumers of financial information to simply ask questions and get answers -- any time, anywhere, on any device. 9W relies on the financial data that is generated by XBRL to answer virtually any question a prospective consumer of that data might imagine asking. After we left EDGAR Online, we started looking for the next breakthrough in information technology where we could apply our skills and experience. This is it.

How does it work?

Consumers ask questions, from simple to complex, through a point-and-click interface comprised of well-defined criteria, and they get answers in seconds. The system gathers and sorts data provided by the thousands of U.S. registrants who comply with the Securities and Exchange Commission’s XBRL filing requirement. Consumers at 9W Search aren’t concerned with tagging or elements. 9W Search is a consumption tool, so XBRL is completely under the hood. 9W Search is a productivity tool for anyone who already uses financial data, but it’s also next generation because it can provides information for uses never before envisioned. It allows endless scenarios and models to answer questions almost instantly. It is the next step in the democratization of access to financial information.

Who might use 9W Search?

As an example, a sales person preparing for a sales call might benefit from some deep insight into a prospect before picking up the phone. It might be nice for that sales person to know how quickly the company pays its bills, whether its inventory is growing or shrinking, how quickly it turns its inventory, or what its payables look like. Under traditional methods, it could take a great deal of time to unearth that kind of information. Using 9W Search, the answers are available almost as quickly as the questions are asked. The potential market for such research seems almost limitless. It could be useful for executives in the “C” suite, for investor relations purposes, for M&A activity, for auditors, for sales and marketing staff, for traders or investors, even educators and regulators. Companies using the application can get information quickly on competitors, suppliers, channel partners, customers, and takeover targets.

How does a consumer get started?

We have a tour on the home page of our website Users need to register and there are plenty of features available for free, so it’s easy to check it out and get a sense of its potential before investing in more advanced features. 9W has taken a unique approach in providing a simple, quick accessible solution for the vast numbers of people who have been underserved in the marketplace until now.

 

 

 

IFRS Foundation Publishes Draft 2013 Taxonomy

Written by Tammy Whitehouse
Posted on March 20, 2013 Comments
March 20, 2013 | General | Barron King

The IFRS Foundation has published an exposure draft of the 2013 IFRS Taxonomy for public review and comment. The proposed Taxonomy consolidates all IFRS Taxonomy interim releases that were published in 2012, as well as concepts reflecting some industry practices based on analysis of financial statements prepared by companies in the banking, insurance, and mining and energy sectors.

The Foundation says the proposed Taxonomy is consistent with International Financial Reporting Standards, including International Accounting Standards and IFRS for Small and Medium Entities. It includes changes to IFRS that were adopted by the International Accounting Standards Board through the end of 2012.

Even with the publishing of a newly proposed Taxonomy for IFRS, the Securities and Exchange Commission is not expected to accept the Taxonomy for use by IFRS filers in the United States. The SEC has said it is not satisfied that the IFRS Taxonomy is adequate for use by IFRS filers to meet the XBRL mandate for U.S. public companies.

The SEC has expressed concerns that the IFRS Taxonomy design is different from the GAAP Taxonomy in a way that raises concerns about comparability among filers. The SEC also has expressed concern that the reduced number of tags or elements in the IFRS Taxonomy compared with the GAAP Taxonomy increases the likelihood of companies creating extensions, or custom tags, in their XBRL submissions, which is a further cause for a concern about comparability.

As such, it is not holding IFRS filers responsible for meeting the mandate to submit their financial statements in XBRL as is expected of GAAP filers. GAAP filers began submitting their financial statements under a three-year phased in approach, with the largest companies submitting in 2009. IFRS filers were originally expected to comply with the third wave of companies in 2011.

The SEC said during a November 2012 meeting with the Center for Audit Quality that it does not expect IFRS filers to have to comply with the XBRL financial statements when filing their 2012 financial statements. The SEC has not said when or how it expects to approve a taxonomy for IFRS filers.

During their meeting with the CAQ’s SEC Regulations Committee, SEC staff said they are seeing some determined efforts by IFRS filers to submit financial statements in XBRL by following the GAAP Taxonomy. The SEC staff said such an approach should be abandoned, however, because it carries a risk of providing investors with incorrect or confusing information. Instead, the SEC staff advised IFRS filers to wait for the SEC to approve an IFRS Taxonomy, whenever that may happen.

 

 

 

FASB Offers New Implementation, Style Guides — First in a Planned Series

Written by Tammy Whitehouse
Posted on March 14, 2013 Comments
March 14, 2013 | General | Barron King

The Financial Accounting Standards Board has issued some new guidance to help users of the GAAP Taxonomy understand how certain disclosures are structured in the Taxonomy, along with a style guide to provide additional insight into design criteria.

The U.S. GAAP Financial Reporting Taxonomy Implementation Guide -- Subsequent Events is the first in what is expected to become a series of XBRL implementation guides. Its purpose is to demonstrate the modeling for disclosures that are required about subsequent events, or those that occur after the financial reporting date but before financial statements are published. The modeling has been completed using elements in the GAAP Taxonomy. FASB says the examples are not intended to encompass all potential modeling configurations or to dictate a specific appearance or structure of a company’s XBRL documents.

The Definition Components & Structure is a style guide that is also expected to be the first in a series of style guides. The guide is actually targeted at FASB staff to provide guidance for creating useful, consistent element definitions as contained in documentation labels within the Taxonomy. However, FASB says it might also serve as a helpful reference for users of the Taxonomy to clarify meaning and support consistent use of the Taxonomy.

“Both the implementation guide and the style guide will be effective tools to help drive consistency in use of the Taxonomy,” said Louis Matherne, chief of Taxonomy development for FASB. That will be good news for companies that are hearing frequent guidance from the Securities and Exchange Commission to correct some common errors in their XBRL filings. The board is planning further guidance that will be targeted directly to the needs of preparers and users of the Taxonomy, he said.

“We’re always focused on making the Taxonomy as self-documenting as possible,” said Matherne. “Our expectation is everything you need to know is built into the Taxonomy, but we’ve come to learn that there are Taxonomy element selections and modeling choices that are simply not obvious from viewing the Taxonomy.” The implementation guide, and other guides to follow, are intended to address that, he said.

Matherne said he is very interested in getting comments on the implementation guide and the style guide from users of the Taxonomy to get their views on whether they achieve the intended objective and if there are changes Matherne and his staff should consider.

Matherne also said his staff is working hard on getting the Taxonomy to a point so that changes in the future need to be made only or primarily as a result of changes in accounting standards. “We’re highly focused on a stable taxonomy going forward,” he said. “We’ve spent considerable effort over the last three years getting the Taxonomy to a robust and stable point.”

 

 

Australian Prudential Regulation Authority (APRA) Plain English Taxonomy (PET)

Written by Bill Donoghoe
Posted on March 6, 2013 Comments
March 6, 2013 | General | Barron King

The Plain English Taxonomy (PET) on-line documentation is the primary user documentation for the three hundred and fifty XBRL taxonomies for the APRA regulatory forms. PET exposes the XBRL taxonomy information and how that information maps to the data entry screens in the APRA D2A software.

One of the most important aspects of the documentation is the ability to see the relationship between each data entry field on an APRA form and the XBRL concept and/or dimension that represents that field in the form's taxonomy. The documentation consists of a series of interlinked web pages that allow the user to navigate the XBRL Taxonomy information in various ways. Below is a logical representation of the PET structure followed by an explanation of each page type:

PET

PET Home

The home page for the Plain English Taxonomy documentation. It contains links to:

XBRL Concept Index

This is an alphabetically sorted list of XBRL Items used in the APRA SBR Reporting Taxonomies. Each entry in the list has:

  • the XBRL Item label with a link to the XBRL Concept page; and
  • a list of APRA Form codes where that concept is used in the SBR XBRL Reporting Taxonomy. Each form code has a hyperlink to the SBR Form page entry.
Example XBRL Concept Index entry
Capital Expenditure Intangible Assets Amount ARF_332_0_D, ARF_332_0_L, RRF_332_0

XBRL Dimension Index

This is an alphabetically sorted list of XBRL Dimensions used in the APRA SBR Reporting Taxonomies. Each entry in the list has:

  • the XBRL Dimension label with a link to the XBRL Dimension page; and
  • the description of the dimension (from the label linkbase)
Example XBRL Dimension Index entry
ABN This is a unique public identifier issued to all entities registered in the Australian Business Register (ABR), to be used in their dealings with government. Companies registered under the Corporations Law and business entities carrying on an enterprise in Australia are entitled to an ABN.

XBRL Data type Index

This page is not currently populated.

XBRL Concept

A plain English rendering of the XBRL Item definition plus links to the usage of the item in the APRA SBR Reporting Taxonomies. The concept pages contain:

  • Label. The plain English name for the XBRL item
  • TREF ID. The SBR Taxonomy Reference Identifier. This is the persistent unique identifier allocated to each XBRL element within the SBR taxonomies (i.e. It is used as the id value in the XML schema element declaration)
  • Data type. The XBRL data type for the XBRL item.
  • Period type. The XBRL period type value for the XBRL item (either instant or duration)
  • Balance type. The XBRL balance type for numeric items (either credit or debit)
  • Business description and Guidance. The business description and guidance label linkbase entries for the XBRL item (in the SBR definitional taxonomy)
  • Usage. A table containing a row for each APRA SBR form which uses the XBRL item. Each row contains:
    • D2A Form code with a hyperlink to the SBR form page
    • Label. The label for the XBRL item in the SBR Reporting Taxonomy (for the form code)

XBRL Dimension

A plain English rendering of the XBRL Dimension definition plus links to the usage of the item in the APRA SBR Reporting Taxonomies. The dimension pages contain:

  • Name. The XBRL element name for the dimension.
  • Label. The plain English name for the XBRL dimension
  • TREF ID. The SBR Taxonomy Reference Identifier. This is the persistent unique identifier allocated to each XBRL element within the SBR taxonomies (i.e. It is used as the id value in the XML schema element declarations)
  • Type. Either "Predefined" for explicit dimensions (the dimension has dimension members) or "Not Predefined" for typed dimensions (i.e. the dimension values are not constrained by a predefined set of enumerations)
  • Description. The business description and guidance label linkbase entries for the XBRL dimension (in the SBR definitional taxonomy)
  • Usage. A list of D2A form codes where this dimension is used. each form code hyperlinks to the SBR Form page.
  • Dimension Members. For "Predefined" dimensions, a table containing a row for each dimension member. Each row contains:
    • Name. The XBRL element name for the dimension member.
    • Label. The label for the XBRL dimension member in the SBR Definitional Taxonomy
    • TREF ID. The SBR Taxonomy Reference Identifier. This is the persistent unique identifier allocated to each XBRL element within the SBR taxonomies (i.e. It is used as the id value in the XML schema element declarations)
    • Description. The business description and guidance label linkbase entries for the XBRL dimension member in the SBR definitional taxonomy

Industry Index

These index pages contain an entry for each of the APRA regulatory forms for that industry grouping. Each entry has:

  • The form description;
  • APRA form code;
  • a hyperlink to the D2A form page
  • a hyperlink to the D2A attribute page
  • a hyperlink to the form SBR XBRL page

D2A Form

The D2A Form page is a HTML rendering of the Direct to APRA (D2A) client version of an APRA Regulatory form. The data entry cells in the form contain the D2A attribute codes which hyperlink to the relevant SBR Form Concept page. The page also contains hyperlinks to the form's D2A Attribute and SBR form pages.

Here is a link to the D2A form page for form ARF 222.0 Exposures to Related Entities

D2A Attributes

This page contains a list of all of the attribute codes in the D2A version of an APRA Regulatory form. Each attribute code has a hyperlink to the relevant SBR Form Concept page. This page also has hyperlinks to the equivalent SBR Form and D2A Form pages.

This page also lists APRA D2A validation rules associated with the form. These rules are expressed in APRA's own rules language which can perform validations across multiple forms and multiple submission periods for the reporting entity (which is beyond the present capabilities of XBRL Formula

SBR Form

This page contains information about all of the XBRL items and their contextual constraints. This is a plain English representation of the SBR XBRL Reporting Taxonomy for the APRA form. The page contains links to the equivalent D2A Attributes and D2A Form pages.

The first table on this page contains the XBRL dimensions that apply to every XBRL item in the form. The use of these form level dimensions is to enable the XBRL data to be processed independently of the form used in the collection of the data (e.g. enabling the aggregation of data across very similar forms). Each of the entries in this table has three fields:

  • Form code. The APRA D2 Form code.
  • Dimension Source. The D2A form header "Reporting Consolidation" value ; and
  • XBRL Dimension name and dimension member value (for the dimension source value). In a small number of cases a D2A attribute code appears instead of a dimension member value. This means that all dimension member values are valid for the dimension but that every item in an XBRL Instance of the form will have the same dimension member value (for that dimension).

The second table on this page has entries for each XBRL item with its allowable contextual constraints and links to the forms with the same constraints. The entry fields are:

  • XBRL Item label with a hyperlink to the XBRL Concept page
  • Variants. There will be a separate row for each distinct set of constraints (a variant). Each variant can have zero or more individual constraints of the following types:
    • Explicit Dimension constraint. A dimension name and a dimension member name (in brackets);
    • Variable Dimension constraint. A dimension name and a D2A attribute name(in brackets). The XBRL Item can occur multiple times, once for each valid value of the Dimension in the Reporting Taxonomy definition linkbase. The presence of the D2A attribute value is to document the mapping between the D2A data entry cell and the XBRL Dimensions and their members (N.B. it is possible for a single D2A data entry cell to be mapped to multiple XBRL dimensions).
    • Negate Form Dimension. One of the form dimensions doe not apply to this particular XBRL item and its constraints. This is an exceptional situation and only occurs in a small number of APRA forms.
    • Tuple membership. The XBRL Item is to appear as the child of an XBRL tuple.
    • Period. There is a period constraint for the XBRL Item that is different to the normal case for APRA forms (i.e. the reporting period for duration items and end of the reporting period for instant items). The possible values are: Start, End and Any (unconstrained).
    • Conditional. This variant only applies to reporting entities with particular organisational metadata (e.g. APRA subsector classification). This constraint is not expressed in the XBRL Reporting Taxonomy.
    • Duplicate. Technically, this is not a constraint but rather documentation that there are multiple data entry cells on a D2A Form that map to the same XBRL representation.
  • Forms. A list of APRA D2A Form codes that have an XBRL item with the same distinct set of constraints.

Here are some examples of APRA forms with the various types of constraints:

SBR Form Concept

This page maps a D2A form data entry cell to an SBR XBRL concept and dimension contexts. The page contains links to the SBR form, D2A Attributes and D2A Form pages.

The page contains:

  • Attribute. The APRA D2A form attribute code.
  • Concept. The SBR Definitional taxonomy label for the XBRL item mapped to the D2A attribute.
  • Label. The SBR reporting taxonomy label for the XBRL item
  • Concept Guidance. The reporting guidance label linkbase entry for the XBRL item (in the SBR reporting taxonomy).
  • Dimensions. A table of dimension constraints associated with the mapping of the XBRL item to the D2A attribute code (N.B. Report level dimensions are not listed in this table). Each entry in the dimension table contains:
    • Dimension name
    • Dimension member name or D2A attribute value. When a D2A Attribute value appears then the XBRL Item can occur multiple times, once for each valid value of the Dimension (in the Reporting Taxonomy definition linkbase). This occurs where the D2A attribute is inside a row in a table in a D2A form (see ARF_220_2); and
    • Dimension or dimension member description (from the label linkbase)
  • Validation. An APRA D2A client validation rules explicitly associated with this attribute.

For an overview of the APRA SBR implementation see: XBRL and Regulatory Reporting in Australia

The PET documentation can be viewed at: http://apra.gov.au/sbr-pet

More information about the APRA SBR XBRL 2.1 Taxonomies is available at Adopting Standard Business Reporting (SBR)

The Australian Government SBR home page is: www.sbr.gov.au

N.B. All of the hyperlinks work in the Chrome browser. Some of the hyperlinks have been known not work in other browsers

 

Exploring Search With XBRL Data

Written by Qinlin Luo
Posted on February 28, 2013 Comments
February 28, 2013 | General | Barron King

This article is a follow-up to “An XBRL Search Engine May Help Financial Analysts Get Started With XBRL”.

It is a challenge for some financial analysts to find XBRL data without knowing the exact financial concepts (including the standard concepts in the taxonomy and the extensions companies created). Even they know some of the concepts, it could still be a challenge if they are querying for many companies at the same time.

Prime Aim uses modern search technologies to help financial analysts to get around this hurdle and help financial analysts find the right data without much knowledge of the taxonomy concepts. As a by-product, financial analysts can identify those concepts used by companies relatively easily.

The feedbacks on our first version are generally positive based on what we have received from a limited number of financial analysts in the last two months.

What users like about our search:

  1. Ability to find data with one or two keywords in the labels, concepts or disclosures.
  2. The semantics of XBRL data that allow them to expand or narrow down the search results.
  3. Ability to identify the most used concepts related to a keyword in a company or in an industry.

What they don’t like about our search:

  1. Difficulty finding the concepts if keywords are not good enough.
  2. Difficulty linking the numbers to the original footnotes to verify that those numbers are correct.

The search can be improved. If you are curious about how our current search works, please visit our homepage.

Once financial analysts have identified the right concepts, the rest could be relatively smooth depending on the nature of tasks. With the tools in the market now, they can pull data into their financial models in Excel, aggregate data in their own ways, automate some financial analysis when new data are available, get notified when a concept value reaches a pre-set threshold, and more.

I am encouraged by the initial feedbacks we have so far. Despite the data quality issues (See http://hitachidatainteractive.com/2013/02/13/persistent-errors-inhibit-consumers-from-using-xbrl-data/), XBRL data could still be used in many ways. I was able to observe how an analyst was able to gather data rapidly in Excel. I have reasons to believe that, once financial analysts are used to the XBRL data – the standard, vendor independent and timely data, they won’t want to go back to the non-XBRL data.

 

Grocery Store Managers & Financial Executives: Bolt-on or Built-in to Realize Process Benefits?

Written by Mike Willis
Posted on February 20, 2013 Comments
February 20, 2013 | General | Barron King

What do grocery store managers and financial executives have in common? Amongst other similarities, both are at the end of a long supply chain (trade products and business reporting data, respectively) and stand between that supply chain and the external consumer. How can Financial Executives in 2013 benefit from lessons learned previously by the grocery store managers? Read on!

Almost 40 years ago, in 1974, a package of Wrigley’s Juicy Fruit chewing gum was the first product bar coded and scanned using the now omnipresent Universal Product Code (UPC), the bar code designed for retail point-of-sale. That was the spark leading to grocery store managers realizing an adage of supply chain standardization: it’s one thing to apply the bar code to the products when they show up at the store and get put on the shelf; it’s another to push standardization back – potentially, to the beginning of the supply chain.

When grocery store managers were able to push the application of the UPC back to the product’s manufacture, they realized an increased range of process benefits over the already beneficial more automated check-out and physical inventory, including: lowered costs; automated inventory management; more timely and accurate fulfillment; and consumer purchasing insights through behavioral marketing; as well as many others.

Grocery store managers initially had inventory clerks apply the bar codes while stocking the shelves. This was a simple replacement to the legacy pricing gun; instead of a fixed price, the bar code would automate the benefits moving forward and didn’t have to be changed if prices changed. But there were other benefits available, at a lower cost. Are you doing the same thing with XBRL? Are you applying XBRL after-the-fact, as a bolt-on to an existing manual report assembly and review process?  If so, you may be experiencing the same outcome that grocery store managers experienced with their initial adoption of the UPC: unnecessary costs and time, mislabeling, and poor quality processes.

When facing regulatory XBRL mandates, many financial executives have chosen to outsource the XBRL tagging and creation process, viewing it only as a compliance requirement; initially relying on third party assistance to ‘tag their reports’. This is perceived as bringing minimal disruption, but also providing minimal potential benefit to the company – and there is incremental cost, guaranteed. Others have seen a net cost reduction, as they have chosen to integrate and push the standardization earlier in their process. The costs (or savings) and benefits realized will be largely dependent upon how financial executives view XBRL mandates: either narrowly, as a simple compliance requirement, or more broadly, as a business reporting supply chain standardization opportunity to streamline a broad range of compliance processes.

Based on a recent survey by the Financial Executives Research Foundation, financial executives are now planning a migration similar to the grocers - away from the initially pervasive bolt-on (or outsourcing) approach to a more integrated in-sourcing implementation model.   While there is a range of implementation effectiveness, companies with best practice 'built-in' implementations are realizing 25%+ net cost reduction … and time enhancements as well.

Like the forty year old UPC story, the story of potential benefits for financial executives is not new. A 2009 FEI Issue Alert titled: "Year 2 of the SEC's XBRL Mandate: Caution and Opportunities on Compliance Requirements" highlighted some of the common potential process enhancements and may be useful to companies now considering in-sourcing of XBRL Compliance Requirements.  The FEI Issue Alert notes that mapping of disclosure elements to the U.S. GAAP Taxonomy within company report writers (Built-in) rather than subsequently applying XBRL to completed company reports (Bolt-on) provides opportunities for potential process enhancements. This is the purpose of Disclosure Management systems, which facilitate:

* Automation of the assembly process of the monetary debits and credits, as well as the narrative and numeric footnote and MD&A disclosures (compared with manual assembly using word processing and spreadsheets);

* Automation of analytical and validation controls (compared with manually-applied controls using word processing and spreadsheets);

* Automation of the aggregation processes for information relevant to closing, elimination, and other adjusting entries (as opposed to manual aggregation commonly executed with worksheet templates);

* Facilitating contextual review of draft report disclosures by relevant management team members (e.g. enabling simultaneous (parallel) review of disclosure content by topic rather than waiting in line for serial review);

* Enabling collaborative review of draft reports (e.g., online review rather than individual review of hard-copy documents);

* Automation of multiple, alternative, report presentation of the reported disclosures (e.g., annual report, summary report, summary tables, graphs, etc.) using standardized presentation templates enabled by XBRL (instead of hand-crafting individual report each period);

* Transparent access by company management to supporting transaction level information (as opposed to more opaque trial balance access with limited or cost-prohibitive access to more detailed information

* Automated documentation of explicit links to technical sources, accounting and reporting memos, subject matter experts, specific and relevant company policies, creating a sustainable knowledge base.

A 2012 blog posting “How to Differentiate Disclosure Management Features” may help companies differentiate individual application feature strengths and weaknesses of different Disclosure Management tools and how they relate to company specific reporting environment process, controls and diversity of reporting requirements.

The January 2013 Center for Excellence in Accounting and Security Analysis  (CEASA) white paper “An Evaluation of the Current State and Future of XBRL and Interactive Data for Investors and Analysts”, provided a number of recommendations, noting that financial executives should work on improving the quality of their own data, as well as on making their own data more useful and accessible to consumers of their information.  For many companies with manual review processes, this may be easier said than done.

While the common errors outlined by US Securities and Exchange Commission (SEC) Staff are basic accounting / reporting issues; many financial executives limit their review to comparing the rendered view of their XBRL report with their traditional report as their primary assessment method.  This approach, which ignores mappings and other vital messages about their information, makes it  difficult to effectively identify common errors within their XBRL reports; it is like trying to validate formulas in an Excel file by reviewing a fax transmittal of the worksheet.  Undoubtedly, this rendering review results in a very frustrating process for both financial executives and the potential users of the XBRL reports.

The common errors are largely found in subjective and or judgmental areas including: backward amounts (e.g. debits reflected as credits and vice-versa); inappropriate company specific extensions; disclosures not tagged; totals that don’t add up; missing or incorrect contextual data (e.g., “I am six gallons tall”); and other subjective or judgmental items. These subjective errors cannot be automatically detected – they require someone with business savvy to catch them - and thereby are commonly found in company reports.  Using appropriate analytical tools that enable more effective identification of these types of subjective error types is a great step towards more efficiently identifying errors and resolving them. Tools that can help financial executives effectively identify judgmental errors range from open source products (free) to $2,500 and include applications like: Arelle; Corefiling Magify, Fujitsu XWand, XBRLCloud and XBRL US Consistency Suite, to name a few.

At the end of the day, grocery store managers’ reliance on the accurate and cost-effective application of supply chain standardization at the beginning of the supply chain (rather than at the end) enabled a broad range of economic benefits.  The costs and benefits realized by financial executives will be largely dependent upon how the XBRL mandates are viewed; narrowly, as a compliance requirement, or more broadly as a business reporting supply chain standardization opportunity to streamline a broad range of external and internal compliance processes and controls.

 

 

Persistent Errors Inhibit Consumers from Using XBRL Data

Written by Tammy Whitehouse
Posted on February 13, 2013 Comments
February 13, 2013 | General | Barron King

Preparers and service providers making some of the most common mistakes in their XBRL filings are typically unaware that they are the target of the frequent calls from the Securities and Exchange Commission for corrections.

That’s the view of Mike Willis, a partner at PricewaterhouseCoopers and an active leader with XBRL International. He likens the scene to a parent investigating a broken lamp. “When something is broken, you ask the kids: who did it?” Willis said. “What do they say? Not me. That’s what a lot of the companies are saying right now. They think the SEC is talking about someone else. They perceive that their review process is adequate.”

Many preparers and those working with XBRL still don’t yet understand the difference between the physical rendering and the underlying metadata, according to Willis. They believe as long as their filing looks OK, it must be OK. “That’s like faxing an Excel worksheet and asking someone to validate the formula,” he said. “You can’t see the formula on a sheet of paper.”

Consumers want to take the data and put it into their own presentation programs, Willis said, but they need properly structured data to rely on it. As companies continue making routine errors, they inhibit the ability of consumers to use and rely on the data, he said. “In many cases, the errors are incredibly simple and wildly obvious,” he said.

Companies are still having a lot of problems with negative values, inadvertently expressing them in opposite terms, Willis said. It leads to expense items looking like revenue or dividends paid looking like dividends received, for example. “That’s the most common, prolific error in company reports, and many company reports have dozens of those errors,” he said. “It’s not like they have one or two.”

Most companies filing in XBRL are now liable for the accuracy of their filings, he said. The SEC’s limited liability protection for the first two years of filing was meant to give preparers time to get accustomed to working in XBRL. The SEC has reminded companies repeatedly that they are still making a great many small but important mistakes, and they’re now exposed to liability for those errors, Willis said.

If the metadata is not correct, consumers of XBRL data are putting erroneous data into their models, and arriving at the wrong answers as a result, he said. “So they relied on something that’s an error,” he said. That’s one of the big reasons investors and other consumers of XBRL data have been slow to make greater use of structured data. he said.

“The SEC has said they’re not going to hold people accountable,” Willis said. “The market is. The market is a more efficient model for holding people accountable for their quality issues.” The market has so far not brought a significant case forward, he said, but it’s likely just a matter of time. “An investor could say I relied on your information and the value went down, so write me a check,” he said.

Willis said companies need to make greater use of any number of validation tools that are available in the market to spot and correct their errors. “The error issue is preventing greater use of the data,” he said. “The analyst community has complained about the quality of the data. They like XBRL and want to use it, but what hinders they from using it all out is the level of errors. It requires them to do a lot of manual rework.”

Sidebar:

Correcting Errors:

Willis suggests a number of resources companies should explore to get a handle on the common errors that persist in their XBRL filings:

Webinar: Avoiding Common Errors in XBRL

http://www.zimbio.com/XBRL+-+Extensible+Business+Reporting+Language/articles/01FBG66BqvQ/Webinar+Replay+Available+Avoiding+Common+Errors

Webinar: XBRL Data Quality: Beyond Validation and the Importance of XBRL

http://www.prnewswire.com/news-releases/free-webinar-from-vintage-filings-xbrl-data-quality-beyond-validation-and-the-importance-of-xbrl-183000721.html

Avoiding Common Errors of XBRL Implementation

http://www.journalofaccountancy.com/Issues/2010/Feb/20092058.htm

Avoiding Common Errors in XBRL Creation

xbrl.us/research/documents/avoidingerrorswhitepaper.pdf

XBRL US Best Practices

http://xbrl.us/research/Pages/BestPractices.aspx

Recent SEC Staff Observations on Common Errors:

http://www.sec.gov/spotlight/xbrl/staff-review-observations-121311.shtml

Three common reasons for Not using XBRL: What CFOs should really know

http://hitachidatainteractive.com/2007/07/31/three-common-reasons-for-not-using-xbrl-what-cfos-should-really-know/

The New Math for Transparency

http://hitachidatainteractive.com/2011/02/22/the-new-math-for-transparency/

Webinar archive: XBRL: Finding a better way:

http://www.pwc.com/us/en/cfodirect/events/webcasts/xbrl-finding-a-better-way-forward-webcast-archive-june-6-2012.jhtml

An explanation of the liability provisions of the SEC XBRL mandate:http://merrillcompliancesolutions.wordpress.com/2012/08/21/liability-for-xbrl-filings/

 

 

XBRL Challenge Draws Nearly 40 Entries So Far

Written by Tammy Whitehouse
Posted on February 6, 2013 Comments
February 6, 2013 | General | Barron King

XBRL US reported recently that it has 37 entries so far and more expected for its 2nd Annual “XBRL Challenge” software development contest. Entries have arrived from not only U.S. developers, but from Asia and Europe as well. Most entrants are entrepreneurs, individuals and even a few academics, XBRL US said.

The contest is meant to flesh out the top open-source analytical tools that can mine XBRL-formatted corporate financial statement data. The winner of the $20,000 grand prize will be an individual or team that submits the most useful, user-friendly application that will enable investors and other users of financial statements to conduct innovative analysis of public companies.

The Securities and Exchange Commission has heard the groaning from public companies that they are investing the time and money necessary to produce the XBRL-formatted data as required, but make little use of the data internally and see little investor use as well. Many XBRL experts are hopeful that will change as companies continue to populate the EDGAR system with historical, comparative, detail-tagged data across all companies, and as software developers produce more user-friendly tools to make the data more useful.

The winner of the inaugural XBRL Challenge contest, Calcbench, has made its open-source tool freely available on its website. Co-founders Alex Rapp and Pranav Ghai continue to refine the tool to process and store all XBRL filings in their structured, cloud-based data universe. They spend a great deal of time, they have said, scrubbing data to identify and correct errors and increase comparability across companies. They say they have identified and fixed nearly half a million errors so far.

XBRL US has said they are looking for innovative tools that provide highly functional, strong analytics, such as multi-company year-to-year comparisons, ratio analyses, or other functions that help investors make critical decisions. The second annual contest opened in July and is accepting submissions through Feb. 28, with final judging and prizes awarded in late March 2013.

Judges for the contest include Alfred Berkeley, vice chairman of Gentag, Inc.; Eric Gillespie, founder and CEO of Poplicus; Kaitlin Lee, senior developer at Sunlight Foundation; Philip Moyer, managing director in the technology group at Safeguard Scientifics; and Paul Ratnaraj, director of advanced initiatives at Wharton Research Data Services.

FASB Publishes Nearly Approved 2013 U.S. GAAP Taxonomy

Written by Tammy Whitehouse
Posted on January 30, 2013 Comments
January 30, 2013 | General | Barron King

If you’ve been waiting for the 2013 GAAP Taxonomy to be available in more finished form before investigating how it might affect your particular filing situation, your wait is over. The Financial Accounting Standards Board has published the all-but-approved 2013 Taxonomy to give preparers, service providers, software vendors and anyone else who might be interested time to get familiar with the changes.

The 2013 Taxonomy must be approved by the Securities and Exchange Commission before it can be relied on fully by public companies to meet their XBRL filing requirement. If history is a fair indicator, that approval is likely to come late in the first quarter. It was mid-March last year when the SEC approved the 2012 Taxonomy.

In theory, that wouldn’t give preparers or their service providers a great deal of time to learn the new taxonomy before they would be expected to use it to meet first quarter filing deadlines. That’s likely why the FASB provides it in finished-but-not-quite-final fashion. It’s probably safe to assume the SEC won’t make or require any further changes to the 2013 Taxonomy before it is approved for use.

Before preparers or service providers dig into the full Taxonomy looking for changes, it’s probably wise to begin with the 15-page release notes published by FASB that summarize the changes. FASB’s release notes can serve as a roadmap to the Taxonomy to make it easier to spot where specific changes might be important to a given company’s filing.

In the release notes, FASB said that the majority of the changes to the Taxonomy are inspired by updates to accounting standards and common reporting practices that are noticed in studying company filings. Changes also have been made to correct errors and rationalize duplicated concepts, to update modeling of existing taxonomy structures, and to make other architectural changes.

FASB said it kept in mind the impact of changes on instance documents and tried to minimize the disruption. For example, where elements were not changed from the 2012 Taxonomy, the element names are identical so that year-to-year comparability is not affected. However, there are some substantive changes that need to be studied, FASB said. The 2013 Taxonomy contains some new elements, some changes in element attributes, and some deprecated elements that must be explored.

In addition to the release notes, FASB has published a variety of guidance and support materials designed to help preparers, service providers, and other identify the important changes.

More Events, More Audiences for XBRL

Written by Michelle Savage
Posted on January 23, 2013 Comments
January 23, 2013 | General | Barron King

Training and education about XBRL continues to be in demand and 2013 will be no exception.  XBRL US, the nonprofit consortium for XBRL reporting, continues to offer programs geared to multiple audiences at different stages in the learning process.  The SEC rollout of XBRL for corporate reporting is at the phase where filers need more in-depth, intensive training to make sure they get their XBRL filing right. In addition, data consumers and developers are now looking for more awareness-building and instructional programs to help them understand how to work with the vast amount of data now available.  Development work and pilot programs in corporate actions mean a growing number of stakeholders are eager to learn more.  Even government officials are starting to awaken to the benefits of greater consistency, comparability, timeliness and accuracy that XBRL can offer.

In 2013, we will provide more support for the filing community with monthly webinars covering core filing concepts, best practices and case studies delivered by XBRL experts.  In late September, the 5th Annual XBRL US National Conference in Las Vegas will focus on hands-on, collaborative, software-agnostic training and best practices.  This event is the largest gathering of XBRL vendors and public company filers in the United States, featuring more hands-on practical sessions on detailed footnotes and best practice issues critical to preparers.  Regulators (SEC and FASB) will give progress updates, cover new and revised accounting standards and address how to implement them in XBRL.

We’ll also expand our one-day Springtime Detailed Tagging Workshop in 2013, with both east and west coast sessions for filers.  These interactive workshops take place before the end of the limited liability provision for every public company filer.  The emphasis will be on making sure you “get it right” with tips, best practices and validation to ensure filers can create the best possible XBRL data.

In addition, we’ll roll out the XBRL US GAAP Certificate Program – an online training program created with the AICPA, providing detailed instruction on creating high quality XBRL financial statements.  That program is slated to launch in late spring with over 30 hours of Web-based, CPE content.

We’re also expanding events for software developers and data consumers, e.g., investors, analysts.  On March 27, we will hold our XBRL and Financial Analysis Conference jointly with the NY Society of Securities Analysts (NYSSA). In late September the XBRL Data Forum will target developers and IT professionals at buy- and sell-side firms to educate on building XBRL databases and working with XBRL data.  Later in the year, we will hold more programs targeting the corporate actions stakeholder, to continue moving that important initiative forward.

We look forward to bringing together XBRL experts to help educate and inform XBRL creators, processors and consumers in the expanding XBRL market.

 

Milestones on the Road to Transparency

Written by Susan Yount
Posted on January 14, 2013 Comments
January 14, 2013 | General | Barron King

The journey to improve financial information available to investors will reach an important milestone in 2013.  For a number of years, we’ve asked filers and investors to imagine a world with machine-readable financial information available at the same time as filings in more traditional formats.  In 2013, they won’t have to imagine it – it will be a reality.

The 500 largest public companies began filing their financial statements and footnotes in XBRL format in June 2009.  They began detail tagging their financial information in June 2010, but because of the extended phase-in period, the last group of 7,000 filers didn’t begin detail tagging their financial information until June 2012.  These smaller company filers, who represent 80% of the companies filing in XBRL format, are now preparing their first detail tagged 10-K filings.  By the end of March 2013 we expect to get our first look at a substantially complete set of detail tagged 10-K information for all XBRL filers.

What’s particularly important about this milestone is that, for the first time, investors will have access to machine-readable financial information for virtually all public companies.  Starting in 2013, investors will have access to the same timely, detailed financial information for small companies that historically has only been available for the largest companies. Equally important, the playing field will start to be leveled for thousands of smaller, high-quality companies who want to raise capital through our markets.

It’s remarkable that investors and data aggregators are already using or evaluating existing XBRL data, given that the data available today only includes detail tagged information for a small fraction of filers, and a limited amount of historical financial information.  Clearly, the benefit of this data will only increase as investors have access to more timely and detailed information about the companies they invest in.

The journey doesn’t end here, of course. To reach that final destination, more work will need to be done to improve data quality, and to develop user-friendly tools to get this information to investors in a format that is useful to them.

 

 

XBRL in the New Year

Written by Dean Ritz & Timothy Randle
Posted on January 7, 2013 Comments
January 7, 2013 | General | Barron King

Attend almost any CPE conference and one will walk away with the perception that XBRL is an unnecessary evil. In fact, you will hear executives describe it as useless and even agents from the SEC, who don’t work in the Office of Interactive Data (OID), won’t be able to provide a good response as to the benefits of XBRL.

However, XBRL has come a long way since last year when it was described as painful. Invariably, changes and new ideas moving from being described as “painful” to “useless,” is very promising and represents progress.

In the next year, this perception of negligible use of XBRL data beyond the regulatory community will continue to change. By April 2013 nearly every public company reporting in the United States will have provided detailed XBRL financial reports for at least one year. Filers’ and regulators’ focus will change from ensuring everything is tagged to focusing on quality. In fact, the SEC has been commenting even more about the quality of XBRL filings and that will only continue to increase. The FASB regularly analyzes how the taxonomy is used and works with filers and service providers in improving the quality of the taxonomy and advising on how specific elements should be used. XBRL experts have learned a great deal over the last few years and are turning this into better taxonomies, software and processes, and suites of automated tests. Once we reach a critical mass of quality production of XBRL-formatted data and business user-friendly software that provides transparency of data, the perception of XBRL will change from “useless” to being an inseparable part of the reporting process.

Progress in 2012

This year brought significant efficiencies in the XBRL reporting process. While there are some service offerings and tools that continue to struggle with efficiencies and user experience, the majority of filers have had a significantly easier time with XBRL. This is due to experience, building time for XBRL in the close process, leveraging of existing tagged data, and software improvements. Some current software even makes aspects of XBRL document creation nearly as easy as authoring the visual document itself.

XBRL in 2013 and Beyond

2013 will be a big year for registrants and investors. The emergence of better consumption tools will provide flexible ways for viewing XBRL documents, but more importantly will also provide visibility into the underlying meaning of the data. In fact, the loudest requests for transparency and comparability come from registrants themselves. Filers want to know how they and how their reports compare with their peers; if they are using similar tags for similar meaning and how their respective extension elements align. New tools are going to readily provide useful answers to these important questions in this next year as the wide availability of both preparation and consumption software that makes creating and viewing structured data easy will continue to grow and improve.

Another improvement that will facilitate greater investor use is the continued improvement of the US GAAP Taxonomy. The XBRL developer community has learned a great deal as a result of dealing with what is considered by some the hardest financial reporting use case. Regulators, standards bodies and filers are all collaborating and succeeding in improving the quality of the US GAAP Taxonomy. In addition, there is work among industry peers to standardize their extensions and element selections rather than each having unique incomparable elements.

Moving forward, more consistent and leveraged use of taxonomy templates—focused on meaning rather than visual presentation of data—will serve to further improve the quality of information for analysis and consequently bring value to investors. Transition to structured digital financial reporting will help resolve another difficulty; that there are too many ways of representing the same concepts, and sometimes no apparent way of representing the obvious. The ultimate step that software and hence the conversation about XBRL will take, is to be focused on consistent models that express information, rather than simply expressing data.

On other fronts, XBRL is going beyond the SEC mandate for public filers and is percolating into other reporting domains. There are groups currently involved in developing XBRL taxonomies for the not-for-profit community as well as for state and local governmental reporting. The Global Reporting Initiative (GRI) Taxonomy brings comparability to Corporate Social Responsibility (CSR) efforts. The U.S. "DATA act" legislation continues to propagate structured digital data because of its clear benefits for reporting and transparency. We are now even seeing the use of XBRL for some internal corporate reporting.

In Conclusion

In the beginning of the Internet, most experts believed that it would only be used by those in academia. For those of us who searched the Internet in the early days, found it to be a novel idea but one that was painful to use and thus useless. We are still in the very early stages of XBRL but the ubiquity of XBRL structured financial data will eventually be met.

Attend any CPE conference in the future and XBRL will be the norm. As we progress throughout the next few years, tagging quality will improve, user experience will develop, and smart data will be inseparable from reporting. Get ahead of the XBRL curve as it will help separate data from information.