wordpress blog stats
Connect with us

Hi, what are you looking for?

XBRL Levels the Information Field (Introduction) – Deepak Shenoy, Capital Mind

Deepak writes on Money, Markets and Trading at Capital Mind. He has co-founded MarketVision, a financial knowledge startup and has traded the Indian Markets for nearly a decade. Deepak lives in Gurgaon and fears using long words. He is @deepakshenoy on Twitter. In this guest column, he writes about Extensible Business Reporting Language, a structured and uniform way to describe financial data.

Extensible Business Reporting Language (XBRL) is the new game in town. It’s just a structured way to describe business data, by which I mean this:

a) People release their financial data in multiple formats

b) For example: What some call revenue, others call it income, yet others call it Total sales.

c) But they all mean the same thing.

d) In such a circumstance, it’s useful to define a single term for whatever means the same thing. If I hear the word revenue I know it means revenue, and not something else.

Advertisement. Scroll to continue reading.

Additionally, to have the data structured in a manner that is computer decodable is useful. Today, no one can easily scan through thousands and thousands of pdf documents. To do any serious level of analysis, either comparing a company with others, or to its own past, you need a computer. And for a computer, it’s altogether too painful to read:

Revenue: 100.10 (Crores)

versus

Revenue: Rs. 10,010.00 (Lakhs)

An Introduction to Markup

One of the ways to solve this is the language of the world wide web: HTML. It’s called “HyperText Markup Language”, where, when if you view the source of any web page, it is always plain text, with strange things inside < and > brackets. The strange things are the “markup” – essentially, stuff that doesn’t get displayed but defines some other stuff that does. Okay, that’s too confusing. Assume I wanted to something in bold. I would do:

This is my boldness. And this is not.

Advertisement. Scroll to continue reading.

which, when a browser sees it, translates to:

This is my boldness. And this is not.

The and are tags that define the boundaries of whatever was to be bold. So italics would be and and so on. HTML has a predefined set of tags. But you could describe anything with such tagging. Books can be:

Michael Crichton
Something

The structure is thus hierarchical – An author and ISBN tags come INSIDE a Book tag. This is kinda open markup, where we’re just going about describing anything. XML (Extensible Markup Language) is the mother of all such markups (based on < and > limiters).

There are other forms of “markup languages” that use XML style tags. Of them XBRL is one – to the extent that you will hear that XBRL is a dialect of XML. Don’t worry about definitions – XML historians will cringe, but I don’t think it’s important and I’ve worked on XML for a long time (wrote this paper for a conference in 2000)

So, if we had a balance sheet and wanted to describe it, we could use

Advertisement. Scroll to continue reading.

100.10

Or something of that sort. But what sort?

Enter the XBRL Taxonomy

If you tell people what needs to go in what tag, it’s effectively a dictionary of terms. This, for XBRL is ataxonomy. Nothing to do with tax. Or the economy. It’s just a word, machan as they say in Bangalore.

The full taxonomy of XBRL for Commercial and Industrial Companies (essentially, non-banks) is here.  It sounds very complex, and it is. Probably unnecessarily, but who cares, eventually there will be tools to decode this (and I could write one in a couple of days, it’s that easy).

So the sample instance document – this a technical jargon for the word “example” – for M&M has gloriously unreadable lines like this:

91418100000

76255100000

The in-gaap is a prefixed namespace identifier, which tells a program in what context the FixedAssets tag applies. In other words, it’s useless for you. You should care about FixedAssets which is a term you understand.

Advertisement. Scroll to continue reading.

There are two FixedAssets tags. What’s the difference? The contextRef (case sensitive) is an attribute that is different for the two rows; one is I2009 and one is I2008.

That simply means different years, though in reality it refers to different areas in that XML document, which tell you that the I2009 refers to the period ending 31/3/2009. The rest is self explanatory except thedecimals=”-5″ which in this context is that the number has been rounded up to lakhs and then pushed back to INR.

Coolness

This kind of structure ensures that we can get data into excel sheets for each company, and then compare them once we have the XBRL. That means I could also aggregate across sectors and compare easily – that is, find out how much the average debt/equity ratio of the auto sector is, which companies are debt free etc. The point is not that this data is not available today – it is, but much of that data is just wrong – it’s that it lowers the bar for good analysis.

On the other side, companies have to work harder to file using XBRL. This involves a lot of cross checking and tools and training. There is a fairly good business model around the compliance area as well, with both accountants and company finance officials needing to know more about the format and specification.

Mandatory Filing

The government of India has made it mandatory for all companies (except banks and FIs) to file returns using XBRL this year.

I presume that once results are filed in XBRL, that we will be able to get the XBRL as well and therefore easily move the data into databases, structured appropriately.

Advertisement. Scroll to continue reading.

(c) 2011 Deepak Shenoy. Reproduced with permission from Capital Mind. The views expressed above are those of the author, and not necessarily representative of the views of MediaNama.com

Written By

MediaNama’s mission is to help build a digital ecosystem which is open, fair, global and competitive.

Views

News

When news that Walmart would soon accept cryptocurrency turned out to be fake, it also became a teachable moment.

News

The DSCI's guidelines are patient-centric and act as a data privacy roadmap for healthcare service providers.

News

In this excerpt from the book, the authors focus on personal data and autocracies. One in particular – Russia.  Autocracies always prioritize information control...

News

By Jai Vipra, Senior Resident Fellow at Vidhi Centre for Legal Policy The use of new technology, including facial recognition technology (FRT) by police...

News

By Stella Joseph, Prakhil Mishra, and Yash Desai The Government of India circulated proposed amendments to the Consumer Protection (E-Commerce) Rules, 2020 (“E-Commerce Rules”) which...

You May Also Like

News

Rajesh Kumar* doesn’t have many enemies in life. But, Uber, for which he drives a cab everyday, is starting to look like one, he...

News

By Aroon Deep and Aditya Chunduru You’re reading it here first: Twitter has complied with government requests to censor 52 tweets that mostly criticised...

Advert

135 job openings in over 60 companies are listed at our free Digital and Mobile Job Board: If you’re looking for a job, or...

News

Google has released a Google Travel Trends Report which states that branded budget hotel search queries grew 179% year over year (YOY) in India, in...

MediaNama is the premier source of information and analysis on Technology Policy in India. More about MediaNama, and contact information, here.

© 2008-2021 Mixed Bag Media Pvt. Ltd. Developed By PixelVJ

Subscribe to our daily newsletter
Name:*
Your email address:*
*
Please enter all required fields Click to hide
Correct invalid entries Click to hide

© 2008-2021 Mixed Bag Media Pvt. Ltd. Developed By PixelVJ