...

Blog

XBRLAnalyst takes Excel deeper into XBRL!

View Statements screenshot

XBRLAnalyst takes Excel deeper into XBRL!

Excel cells with a single XBRL value, formula or even user-defined metric are fully linked to XBRL financial statements.

You wonder what it means?

  • Cell annotation shows what XBRL tags were used to return the value in the cell, whether it is a single tag value, a formula or even a user defined metric that combines multiple XBRL tags. You will also find there the list of labels for all the tags.
  • If you select the cell and click “View Statements“, Excel opens the financial statement viewer (see the screenshot above) where the corresponding XBRL accession, the financial statement and the XBRL values have already been selected and highlighted. It tremendouslysimplifies the audit/verification of XBRL financial data in Excel.
  • If you select the cell and click “Search Tags/Data“, Excel opens another viewer of all XBRL tags present in the corresponding accession. Double click the tag and you will see all it’s values for different periods reported in the accession and also the dimensional information associated with the tag in that accession.
  • When defining your own metrics using our tool “Edit My Definitions“, you can add a plus sign at the end of the metric name and XBRLAnalyst will add together all values of the tags from your definition list found in the specified accession. See the example [Other Non-current Assets+] on the screenshot below or download our example of Valuation Modelwhere the screenshot was made.
Composite user-defined metric
Register and try XBRLAnalyst

XBRLFact function in Excel got more powerful!

Now, you can find values using XBRL tag pattern with percent sign % as a wildcard. Try for example  XBRLFact(“GE”,”%sales%”,”2013-Q2″)
It will find SalesRevenueGoodsNet  XBRL tag and return its value in Excel.

No Comment

Post A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.