Robust XML Technologies Provide an Ideal Foundation for XBRL

Written by Bob Schneider
Posted on March 25, 2010 Comments
March 25, 2010 | General | Bob Schneider

Written by Liz Andrews    Posted on March 25, 2010

Liz Andrews is Technical Marketing Manager at Altova.

There has been a tremendous spike of interest in XBRL over the past year, with the establishment of global mandates and standards, reporting deadlines approaching, and new technologies arising to meet the challenge. But it feels like we are all still treading carefully in the way that we present the promises of XBRL to our key audiences -- and why not? Everyone is a little apprehensive about regulations, businesses are often slow to embrace new technologies, and let's face it, the economy has not bounced back quite yet.

To help us get a better understanding about what XBRL can do, we need to comprehend its underpinnings. In this post, I want to take a closer look at what XBRL can do from a more technical perspective.  So let's meet the wizard behind the curtain:

eXtensible Markup Language (XML) is the enabling technology behind XBRL. Not only does it provide XBRL with its extensibility (i.e., the ability to build extensions to augment base taxonomies), but it also exposes it to a whole family of related technologies that facilitate validation, intelligent search/query, data mining, data analysis and aggregation, transformation to different formats, localization, processing by other programming languages, automation… the list goes on. Here’s just a few of these languages and how they can help us work with XBRL.

eXtensible Stlyesheet  Language (XSLT) 2.0 is a language for transforming XML documents (like XBRL instances) into HTML/XHTML pages, other XML documents, or even simple text files. This lets us render XBRL reports for presentation on Web pages and also to other output formats. XSLT lets us keep the actual back-end financial data intact, eliminating any need for re-keying or any other error-prone human interaction; thus XML data is "repurposed" rather than rewritten, allowing many different presentation formats from a single source. XSLT is also very powerful technology for intelligent data search and analysis, as it can be used to return a subset of the source data based on style sheet requirements.

XML Query (XQuery) is also used to extract data from XML documents, and was designed to open XML to querying in the same way that SQL can be used with databases. XQuery is an ideal language for manipulating structured and semi-structured data and can perform complex operations, such as (1) on-the-fly result-set transformations, (2) record selection based on FLWOR expressions, (3) joins, and (4) recursion based on built-in functions.

XPath, another member of the XML family, empowers both XSLT and XQuery with a standard for easily navigating through files to extract specific data. XPath provides flexibility through wildcards, variables, data filtering, and many other built-in features.

XML's inherent ability to provide an open, flexible, and programmatically accessible medium for developers to work with provides an ideal foundation for XBRL to be built upon.  XML has such a widespread presence that most companies already have several XML-savvy employees lurking among their numbers. The opportunity here for many companies is that XBRL – while it may seem initially daunting – may be easier for companies to adopt, simply because their existing resources understand how XML works.  

Does XBRL Adoption Reduce Information Asymmetry?

Written by Bob Schneider
Posted on March 23, 2010 Comments
March 23, 2010 | General | Bob Schneider

Written by Hyungwook Yoon, Hangjung Zo, and Andrew P. Ciganek     Posted on March 23, 2010

Hyungwook Yoon and Hangjung Zo are, respectively, a Doctoral Candidate and Assistant Professor at the Korea Advanced Institute of Science and Technology. Andrew Ciganek is an Assistant Professor at the University of Wisconsin-Whitewater.
        
With the increased use of XBRL, we are finding new opportunities to research this technology.  Based on the popular belief that XBRL adoption within the financial industry leads to reductions in the costs to both obtain and integrate what was once disparate financial data, we decided to examine whether such benefits were actually occurring.

We examined data from 550 companies in the Korean stock market. All publicly-held Korean firms have been required since October 2007 to electronically file their periodic and other financial reports in XBRL format through the DART (Data Analysis, Retrieval and Transfer) system, which is equivalent to the EDGAR system in the U.S.. Therefore, the Korean stock market presented an opportunity for us to examine the influence that XBRL adoption has for organizations.

The primary objective of our research was to determine whether XBRL adoption leads to a corresponding reduction in information asymmetry, where a select few investors have better access to information. We did this by investigating the bid-ask spread of those Korean companies, which is often used as a substitute for information asymmetry.  Monthly relative spread data was collected for seven years from September 2001 to August 2008, since this period was the most recent stable period in the Korean stock market. (The Korean market was extremely unstable for nearly four years before September 2001 because Korea experienced a severe economic crisis.  Korea officially escaped economic turmoil in August 2001.) The period after August 2008 was not included as a target period because the global financial crisis, caused by the collapse of major investment banks in the U.S., severely affected the Korean financial market.  

The result of a multiple regression analysis showed that XBRL adoption did reduce the information asymmetry of the Korean stock market, creating a more balanced system of transactions. In particular, this study confirmed that the effect of XBRL adoption on reducing information asymmetry is significant only for large companies. This relationship between firm size and information asymmetry was expected since previous research has shown that larger companies are likely to have more trading transactions, attention from analysts, and media coverage than smaller companies.  

XBRL adoption increases the transparency and quality of corporate information in the capital market and reduces the time and cost to circulate corporate information in stock markets, as well as enhances the compatibility of this information for integration among different information systems.  By facilitating corporate disclosure, information asymmetry of the capital market is notably reduced.

Our research paper with our methodology, findings, and conclusions can be purchased online.   

My XBRL Reading List, Take Three

Written by Bob Schneider
Posted on March 16, 2010 Comments
March 16, 2010 | General | Bob Schneider

Written by Bob Schneider     Posted on March 16, 2010

In 2007, I wrote a post titled My XBRL Reading List. Take out my window dressing, and you had a pretty short list. Two years ago I did a post that added more materials, but it was still relatively scanty.

Since then, as XBRL adoption has expanded, resources both on and off the Internet have increased substantially. I wouldn’t call it an embarrassment of riches -- for example, there are still few XBRL books -- but certainly there is a healthy flow of information and commentary on interactive data developments from numerous sources. 

As I noted in my post on social media, monitoring Twitter Search results for XBRL will keep you up-to-date on most XBRL-related blog posts, articles, and events -- an objective that can be aided by creating a Google Alert for XBRL or a search on that term at Google Blogs.

One resource these searches may easily miss, however, is the Yahoo Group XBRL-Public.This is one of the the oldest XBRL resources on the Internet, and it still offers the best forum for debating XBRL issues. The recent thread on Building an Inhouse XBRL Viewer is a vigorous clash of opinion among the best minds in the field. The thread’s title doesn’t do any sort of justice to the robustness of a debate that centers on Inline XBRL, but ranges from the potential of the Semantic Web to the perverse utility of white fonts for information camouflage.

At the same time, XBRL novices can expect courteous assistance from this group. Just yesterday, Charlie Hoffman provided a list of sources for someone who does not know “the first thing about it.”

I’ve provided Internet and print resources below that offer the latest XBRL news and commentary, as well as more permanent content such as taxonomies and primers. Relative newcomers will probably find it most useful, but I hope long-time practitioners also discover one or more entries worthy of subscription or bookmark.  I’m sure I have omitted useful resources through oversight or ignorance; readers should feel free to suggest their favorites in a Comment.

Blogs
The writers at these blogs are passionate about XBRL and do a great job of exploring news, ideas, and trends.

CPASuccess This blog from the Maryland Association of CPAs often has stories on recent XBRL developments.

Financial Reporting Using XBRL Probably better known as Charlie Hoffman’s blog, the Father of XBRL writes prolifically and provocatively on both technical and nontechnical interactive data issues.

CoreFiling’s Insight Blog CEO John Turner doesn’t blog often, but whenever he does, it’s must reading. Recently, he and his staff have been doing a series on Inline XBRL.

FEI Financial Reporting Blog often has posts about XBRL-related news and events.

PaulWilkinson.com The senior adviser to former SEC Chairman Chris Cox writes on big-picture financial issues, often from an XBRL perspective.

Random Thoughts Dan Roberts, former National Director of Assurance Innovation at Grant Thornton, provides his thought-provoking take on XBRL issues.  

Rivet Software Blog Stuart McKie and others offer interesting commentary from this leading software vendor.  

The XBRL Canada Blog Gerald Trites’s focus is XBRL use in Canada, but he covers other interactive data topics as well.

Trintech Chethan Gorur (Director, Interactive Data at the firm) has begun posting technical but clearly-written XBRL articles at this new blog.  

Out of the Clouds and Into Reality: XBRL for the Business User Rob Blake of Bowne & Co. (slated to be acquired by RR Donnelley) doesn’t post often; but whenever he does, his remarks on the XBRL filing process are revealing.

Aggregator Sites
These sites collect and publish materials from various Internet resources; to varying degrees, they also include original content from the webmaster.

XBRL Blog Magazine  Ilija Šuša aggregates XBRL commentary, announcements, and tweets; he also writes posts and conducts interviews.    

XBRL Network Among other content, Miles Jennings, Jr. provides loads of links to XBRL companies, blogs, organizations, etc.

XBRLSpy Articles and announcements from XBRL Evangelist Dianne Mueller, as well as other articles from XBRL resources.  

Books
As I mentioned, books on XBRL are still few and far between, and the economics of publishing computing books these days doesn’t augur well for many more. The Hoffman/Watson XBRL for Dummies listed below is certainly a welcome addition to the list.

Building XBRL Into Accounting Information Systems As I stated in my review, this book provides readers “…with an outstanding introduction to XBRL — one they can finish on an airplane ride from New York to Atlanta.” 

Financial Reporting Using XBRL: IFRS and US GAAP Edition This reference work by Charlie Hoffman is for the technically minded.

XBRL for Dummies Charlie Hoffman and Liv Watson, two XBRL pioneers, provide an excellent, wide-ranging introduction in easy-to-digest language.

XBRL for Interactive Data: Engineering the Information Value Chain This book is not a comprehensive primer but it does provide useful information.

Websites
The sites listed below have important resources and archives, such as taxonomies, speeches, specifications, etc.  For sites of XBRL providers, see the XBRL Products and Services page at XBRL.org. and the vendors page at XBRL-US. All of the big accounting firms also have XBRL pages: PwC, Deloitte, KPMG, EY,and GT.

AICPA XBRL resources from the leading organization of US accountants.

CoreFilingTaxonomy Library You can open and explore taxonomies ranging from Australian SBR to XBRL GL.

International Accounting Standards Board This page at the IASB website has XBRL news and provides access to IFRS taxonomies.

SEC’s Office of Interactive Disclosure (OID) This essential website from the SEC’s XBRL unit  offers links to XBRL filings, staff interpretations, FAQs, transcripts, and roundtable discussions.

XBRL Education Resource Center Sponsored by Bryant University, the site offers links to articles, news, and tutorials about XBRL.

XBRL International First stop for learning about both XBRL the standard and XBRL the organization.

XBRL Planet Great place for learning about XBRL developments across the globe. There’s also a late-2009 update for Europe.

XBRL.US: The site of the US jurisdiction of XBRL includes the most recent release of the US GAAP taxonomies as well news, events, announcements, etc.

 

XBRL: Using Formulas for Label Changes and Detail Tagging

Written by Bob Schneider
Posted on March 4, 2010 Comments
March 4, 2010 | General | Bob Schneider

Written by Peter Bortiz    Posted on March 4, 2010

Peter Boritz is the architect and chief technical officer for Snappy Reports XBRL and can be reached via e-mail.

In one of my recent posts, I mentioned the problem of handling changes to labels between filings to the SEC. I noted that:

An element contains a label which provides human readability for spoken languages. There can be only one label for any given language and label category combination. A problem occurs if the label changes from filing to filing…For example, the label “Property Plant and Equipment net of Accumulated Depreciation” is a static label. Typically, however, a label may more likely resemble “Property Plant and Equipment net of Accumulated Depreciation of $x and $y”. This label is no longer static, because the values of $x and $y are tied to the filing based on data facts within the filing.

An optimal reporting solution to this problem would minimize changes to the extension as much as possible; this would provide maximum reusability and minimizes labor costs and time. Three solutions present themselves: cloning, footnotes, and formulas.

Cloning
One solution is to clone a new extension for each filing and then change labels for each clone. Utilities may be used to clone one filing to another. This gets cumbersome, however, and it requires manual operations and extensive quality control review. This solution is not scalable and is the most primitive of the options presented.

Footnotes
Another option is to keep the label as a constant and use a footnote to denote the variable portion. This solution works nicely. The taxonomy label remains “Property Plant and Equipment” for all filings, but each filing would footnote the variable portion of the disclosure as “net of accumulated depreciation of $x and $y”.

The problem with this solution is that many viewers do not display footnotes – most notably, the SEC’s. Their viewer may be the yardstick with which your clients and peers are measuring the quality of your work. The reality is that your clients and peers need to see a complete rendering that includes everything. The use of footnotes to disclose the variable portion of labels works nicely, but it is missing a mechanism for quality control purposes.

Formulas
The best choice is to use the same extension without the use of footnotes to accent labels. This can be done with variables.

A variable in a filing pulls the instance value for a specific element and context combination. This is particularly handy with labels and disclosures. Variables are defined in the XBRL functions and formulas specification. However, the specification does not apply variables to labels. We can use a subset of functions and formulas for processing labels.

Our goal is to derive one or more instance values based on variables. For a specific element, we may want to obtain the current instance value for the current period or previous period. A previous period may be a year, semester, or quarter for an equivalent period in the previous year.

Our label problem with may be solved with pseudo syntax similar to:

Labor Expense including stock-based compensation of
{ GetValue(us-gaap:StockBasedCompensation,CurrentDuration<12>):$#,###,##0 } and
{ GetValue(us-gaap:StockBasedCompensation,CurrentDuration<12> - 12):$#,###,##0 }

The above is a fabricated syntax for display purposes only. We are telling an XBRL processor to make two substitutions in our label. Based on a given element, we are getting the data facts for a specific reporting period. The syntax is:

    GetValue(Element, Reporting Period<Length> - months)

For example, we are taking the current 12-month duration (current year) and comparing it to the equivalent reporting period in the previous year (Period – 12 months). If our current period is year ended 2009-12-31, then year minus 12 months would be 2008-12-31. The beauty of this is that our syntax is relative to our filing and it is totally reusable.

In the first instance, we are taking the value of stock-based compensation for the current period and placing its value in the label labor expense. For the second portion, we are asking for the equivalent value for the previous year; it could also be for the prior quarter, or an equivalent quarter in the previous year.

The “funny piece” I have included is $#,###,##0. We need a way to tell the processor how to format the number. In this example, I am using standard Microsoft formatting code to format the value with a preceding dollar sign, thousands comma separated, and no decimals.

The processor makes the required substitutions and places them into the label at run time. This means the same functionality always pulls applicable values based on your current filing period. Once you set the label, you never have to change it from filing to filing. This solves scalability issues and makes our life easier.

The instance or report would display the label similar to the following.

Labor Expense including stock-based compensation of $1,000 and $1,200.

Function is an important aspect to dynamic labels. We are not always looking for the value of the data fact. We may also be looking for a date value based on context -- for instance, cost of sales of $1,000 as of 12-31-2009.

A formula for obtaining a date may look something similar to the following.

{ GetDate(CurrentDuration<12>.– 12,End):MM-dd-yyyy }

GetDate returns a binary date/time. You can format it any way yhou want. The format yyyy would return the year only, as in 2010. European dates are dd-MM-yyyy. Another option is to use localization. This would set the date format according to the localization set in the computer. GetDate requires either an End or a Start parameter for duration periods. You need to know if we are requesting the date at the start or end of the period.

The use of formulas may also be handy in disclosures where the text block makes reference to the value of an element elsewhere in the taxonomy. For instance, if a numeric value within a disclosure refers to an element, a formula could be used for populating the numeric fact within the disclosure. This not only provides reusability and scalability within your filings over a span of time, but it also sets you up for detail tagging. The formula not only obtains a value, but it also identifies that the element from which the data is being pulled is a detail tag for that disclosure.

If force of habit requires you to always use formula based numeric facts within your text blocks rather than static text-based numbers, you would have fairly high assurance that your detail tagging is complete and reliable for all detail tagging within the filing. The detail tag would be the element referenced in the formula.