Tag Archives: Calculation

Don’t Be So Negative: XBRL Values (1/3)

Paul Warren recently revisited the popular discussion of negative values in XBRL . Many experts consider negative values the biggest quality/comparability issue in XBRL. If it’s that important, I want to chime in! This post is hopefully the first of a few on the subject. This post will focus on my experience in creating XBRL and the rationale I apply to the problem of “negative values”. Continue reading

Tagged , , , , , , , , , , , , , , ,

Part Two: The Query

In my previous post, I described the business problem:

Finding filers who made “backwards calculations”. “Backwards” in the sense that they’ve said that us-gaap_ProfitLoss is a calculation parent of the element of us-gaap_NetIncomeLoss. Remember, the former includes income attributable to the noncontrolling interest, and the latter does not. This is backwards because accountants typically subtract us-gaap_NetIncomeLossAttributableToNoncontrollingInterest from us-gaap_ProfitLoss to arrive at a total of us-gaap_NetIncomeLoss. But the above calculation relationship suggests that us-gaap_ProfitLoss is the total. Wrong element.

Confused? I’ll cover that in Part Four. For now, bear with me. Assume it’s “backwards” to go from us-gaap_ProfitLoss to us-gaap_NetIncomeLoss. So, how do we find who’s backwards?

Enter the XBRL-US Database!
To find these filings, I ran this query. I’ve bolded the important parts. Continue reading

Tagged , , , , , , , , , , , , , ,

Backwards Calculations, Part One: The Setup

XBRL US has made a great database available It’s in PostgreSQL  and they made it available as part of their Open Source XBRL competition (aka the XBRL Challenge) I’ve experimented a bit, and found that I can use their database with easy SQL queries, to answer some important XBRL questions, about all SEC-filed XBRL, and it’s lightning-fast! Today I wanted to post about one scenario in particular, called the “Backwards Calculation

My friend Phil Mennona (creator of great GAE apps like this ISO8601 converter or this report name checker) posed an interesting question about two us-gaap elements. Continue reading

Tagged , , , , , , , , , , , , , ,