|
|
Free XBRL to Spreadsheet Converter
XBRL
XBRL stands for Extensible Business Reporting Language. It is a format that the U.S. Securities and Exchange Commission (SEC) and many government agencies in the world have adopted, requiring companies to file their financial statement information in a form that will improve its usefulness to investors. In this format, financial statement information can be downloaded in a semantic form, analyzed using off-the-shelf software and used within financial models easily.
Currently, financial statement information is provided in text file or the Portable Document Format (PDF) format. In these formats, each of the fields in the financial statements can be described differently. For example, "Sales Revenue, Net" can be described as "Net Sales" by another company. It is possible for the investor to differentiate the fields but difficult for computers to process the information. It is also tedious for the investor to use the information further in financial modeling. For example, an investor calculating the Price over Earnings (P/E) ratio for several companies needs to identify and copy the "Earnings per Share" field from the income statements. This is a tedious process and is subjected to human errors.
There are also many companies that provide services to the investor by making the raw data in a more usable form. They employ analysts to go through the raw data, enter the information into a database and provide the information in a tabular form that can be easily retrieved by the investors. Investors using this information will be able to compare the numbers from different companies or from the same company at different times.
XBRL improves the usability of the raw data by providing a format where all companies can adopt when they file their financial statements. And the vision is that investors will be able to use commercial-off-the-shelf software and perform analysis on data on this format. The software will be able to recognize the different financial fields and automate the calculation of the different values that is required in an analysis. Existing companies that employ analysts to process raw data will also benefit with the use of automated software to convert the XBRL data to a usable form more quickly and easily.
XBRL adoption and the XBRL Mandate
XBRL is expected to gain widespread adoption as the U.S SEC has already mandated their use. A group of approximately 500 companies with a public float of $5 billion or higher has been required to file their financial statements in the XBRL format starting from June 15, 2009. All other large accelerated filers will be required to comply with the same requirements starting from June 15, 2010 and the rest of the companies will be required to comply from June 15, 2011.
XBRL to Spreadsheet Converter
XBRL to Spreadsheet Converter is a free tool for Microsoft Excel that converts XBRL based on the US GAAP Taxonomies to a spreadsheet. Information is extracted based on a template where user can choose to place the output in specific cells in the spreadsheet. This will assist financial analysts in extracting the semantic data from XBRL and using the data to perform analysis and financial modeling quickly and easily.
The Conversion Process
The diagram below illustrates the basic process of converting an XBRL file to a spreadsheet. The location of the XBRL file is specified by a Uniform Resource Locator (Input URL). The fields to extract, location to place the extracted fields and the look and feel of the output spreadsheet are all specified in the XBRL Template. The values of the extracted fields are finally placed in an output worksheet after the conversion.
Input URL
The StatementExtractInput worksheet allows you to specify the URL of the XBRL instance. Currently only the US SEC 10K instance is supported. US SEC 10K XBRL instance can be searched from the following :
http://www.sec.gov/edgar/searchedgar/companysearch.html
The Extract button in this worksheet will extract all the fields specified in the XBRL Template and placed the values in the output worksheet. The Extract and Trim button will perform the entire process carried out by the Extract button and also an additional trimming of fields with “Nil” values.
Besides searching for XBRL instance in the website specified above, a list of US SEC 10K instance URL up to 31 December 2009 is provided in the XBRL Filings worksheets for ease of use.
XBRL Template
The InternalTemplate worksheet is used for specifying the template used for the conversion process. Any cells in this spreadsheet from row 1 to row 1999 and from column 1 to column 30 will be treated as a potential XBRL field to be converted.
The following line shows a sample template field. Any fields of the following format will be treated as a template field. Any other values will simply be copied to the output worksheet. The “:” character is used as a separator.
:01:D:V:0001:us-gaap:CostOfGoodsSold
- 01 – Currently not used. In the future when the converter supports multiple XBRL instance, it will be used to identify the specific XBRL instance.
- D – ‘D’ for a Duration field and ‘I’ for an Instant field.
- V – ‘V’ used to indicate to extract the value of a field. Other indicators like ‘L’ for labels and ‘D’ for description will be supported in the future.
- 0001 – ‘0001’ is used to specify the latest period, for example, the current year. ‘0002’ is used to specify the previous period, for example, the previous year. ‘0003’ is used to specify two periods ago.
- us-gaap:CostOfGoodsSold – A valid field from the US GAAP Taxonomies.
The Converter also comes bundled with several templates to help you extract the different types of financial statements easily. This will be described in the following three sections.
Templates for Statement of Income
Template SOI
StatementOfIncome
Template SOIA
StatementOfIncomeAlternative
Template SOINCIBR
StatementOfIncomeInterestBasedRevenue
Template SOINSIBR
StatementOfIncomeInsuranceBasedRevenue
Template SOISBI
StatementOfIncomeSecuritiesBasedIncome
Template SOIREER
StatementOfIncomeRealEstateExcludingREITs
Template SOIREIT
StatementOfIncomeRealEstateInvestmentTrusts
Templates for Statement of Financial Position
Template SOFPC
StatementOfFinancialPositionClassified
Template SOFPUDBO
StatementOfFinancialPositionUnclassified-DepositBasedOperations
Template SOFPUIBO
StatementOfFinancialPositionUnclassified-InvestmentBasedOperations
Template SOFPUSBO
StatementOfFinancialPositionUnclassified-SecuritiesBasedOperations
Template SOFPUREOFA
StatementOfFinancialPositionUnclassified-RealEstateOperationsFirstAlternative
Template SOFPCREOFA
StatementOfFinancialPositionClassified-RealEstateOperationsFirstAlternative
Template SOFPUREO
StatementOfFinancialPositionUnclassified-RealEstateOperations
Template SOFPCREO
StatementOfFinancialPositionClassified-RealEstateOperations
Templates for Statement of Cash Flow
Template SOCI
StatementOfCashFlowsIndirect
Template SOCD
StatementOfCashFlowsDirect
Template SOCIDBO
StatementOfCashFlowsIndirectDepositBasedOperations
Template SOCIIBO
StatementOfCashFlowsIndirectInvestmentBasedOperations
Template SOCISBO
StatementOfCashFlowsIndirectSecuritiesBasedOperations
Template SOCIRE
StatementOfCashFlowsIndirectRealEstate
Spreadsheet Output
The StatementsExtractOutput worksheet contains all the output values extracted from the XBRL instance. The following diagram illustrates how the XBRL output looks like.
Download Free XBRL to Spreadsheet Converter - v1.0
System Requirements
Microsoft® Windows® 2000 ,Microsoft® Windows XP® and 2003, Microsoft® Windows Vista®, Microsoft® Windows 2007
512 MB RAM
5 MB of Hard Disk space
Excel 2002, 2003, XP or Excel 2007
License
By downloading this software from our web site, you agree to the terms of our license agreement.
Download
XBRLtoSpreadsheetConverter.zip (Zip Format - 775 KB)
Back to Excel Templates and Add-Ins
Get all the Finance Spreadsheets in one professional package
Get the Finance Spreadsheets individually
Other Free Finance Spreadsheets
Other Free Spreadsheet Software
Other Commercial Software
|
|
 |
 |
