Tag Archives: Phil

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 , , , , , , , , , , , , , ,