If you’re involved in financial reporting, regulatory compliance, or corporate accounting, you’ve probably heard about XBRL. This standardized format is now required by regulators worldwide, including the SEC, HMRC, and many other financial authorities. Converting financial statements to XBRL might seem challenging at first, but this guide will show you exactly how to do it\u2014whether you’re a finance professional or a business owner handling your own reporting.<\/p>\n\n\n\n
Converting financial statements to XBRL involves tagging each financial data point with standardized labels that computers can read and process. The process typically includes preparing your financial data, selecting the appropriate taxonomy, mapping your line items to XBRL tags, validating the output, and generating the final XBRL files.<\/p>\n\n\n\n
There are several methods to convert your financial statements to XBRL format:<\/p>\n\n\n\n
Using specialized XBRL software<\/strong> – Commercial tools like Workiva, Certent, or Fujitsu XWand provide user-friendly interfaces for tagging and validation.<\/p>\n\n\n\n Excel-based conversion<\/strong> – Using add-ins that work within Microsoft Excel, allowing you to tag cells directly in your familiar spreadsheet environment.<\/p>\n\n\n\n Python programming<\/strong> – For technical users who need automation, Python libraries like Arelle enable custom XBRL generation.<\/p>\n\n\n\n Online conversion services<\/strong> – Web-based platforms where you upload your statements and receive XBRL files.<\/p>\n\n\n\n Professional XBRL service providers<\/strong> – Outsourcing to specialists who handle the entire conversion process for you.<\/p>\n\n\n\n The best method depends on your technical expertise, budget, filing frequency, and complexity of your financial statements. Let’s explore each approach in detail.<\/p>\n\n\n\n XBRL stands for eXtensible Business Reporting Language. Think of it as a universal language for financial data that allows computers to automatically read, process, and compare financial information across different companies and countries.<\/p>\n\n\n\n Here’s why XBRL is important:<\/strong><\/p>\n\n\n\n Unlike traditional PDF or paper financial statements, XBRL tags each piece of financial data with a specific label. For example, instead of just showing “Revenue: $1,000,000” as text, XBRL marks it as “us-gaap:Revenue” with the value 1000000 and the currency USD. This makes the data machine-readable and searchable.<\/p>\n\n\n\n Key benefits of XBRL:<\/strong><\/p>\n\n\n\n Public companies<\/strong> – Required by SEC for 10-K, 10-Q, and other regulatory filings in the United States.<\/p>\n\n\n\n Private companies filing in certain jurisdictions<\/strong> – UK companies filing with HMRC, European companies under ESEF regulations, and companies in other countries with XBRL mandates.<\/p>\n\n\n\n Financial institutions<\/strong> – Banks and insurance companies often have specific XBRL reporting requirements.<\/p>\n\n\n\n Listed companies globally<\/strong> – Stock exchanges in Japan, India, Singapore, China, Australia, and many other countries require XBRL submissions.<\/p>\n\n\n\n Companies seeking transparency<\/strong> – Even if not required, some companies voluntarily use XBRL to improve data accessibility for investors.<\/p>\n\n\n\n Accounting firms<\/strong> – Preparing XBRL filings for multiple clients requires efficient conversion processes.<\/p>\n\n\n\n Before converting, you need to understand XBRL taxonomy\u2014essentially the dictionary that defines all the tags and labels used in financial reporting.<\/p>\n\n\n\n Common taxonomies include:<\/strong><\/p>\n\n\n\n US GAAP Taxonomy<\/strong> – Used for companies following US Generally Accepted Accounting Principles. This is required for SEC filings and includes thousands of predefined elements for income statements, balance sheets, cash flows, and footnotes.<\/p>\n\n\n\n IFRS Taxonomy<\/strong> – Used by companies following International Financial Reporting Standards. Common in Europe, Asia, and other international markets.<\/p>\n\n\n\n Country-specific taxonomies<\/strong> – Many countries have their own versions, like UK GAAP, Indian Accounting Standards, Japanese GAAP, or Australian Accounting Standards.<\/p>\n\n\n\n Industry-specific extensions<\/strong> – Banking, insurance, real estate, and other industries may have specialized taxonomies with additional elements.<\/p>\n\n\n\n Custom extensions<\/strong> – When standard taxonomy doesn’t have an appropriate tag, companies can create custom extensions (though regulators prefer using standard tags when possible).<\/p>\n\n\n\n This is the most practical approach for businesses that need reliable, compliant XBRL conversions without extensive technical knowledge.<\/p>\n\n\n\n Workiva (Wdesk)<\/strong><\/p>\n\n\n\n Workiva is one of the most popular enterprise-level solutions for XBRL reporting.<\/p>\n\n\n\n How it works:<\/strong><\/p>\n\n\n\n Best for:<\/strong> Large public companies, those with complex reporting needs, and teams requiring collaboration features.<\/p>\n\n\n\n Pricing:<\/strong> Enterprise pricing (typically $10,000-$50,000+ annually depending on features and company size)<\/p>\n\n\n\n Certent (formerly DataTracks)<\/strong><\/p>\n\n\n\n Certent offers comprehensive XBRL creation and validation tools with strong focus on regulatory compliance.<\/p>\n\n\n\n Features:<\/strong><\/p>\n\n\n\n Best for:<\/strong> Mid to large companies, CFOs and financial controllers managing regular filings.<\/p>\n\n\n\n Pricing:<\/strong> Subscription-based, starts around $5,000-$15,000 annually<\/p>\n\n\n\n Fujitsu XWand<\/strong><\/p>\n\n\n\n A cost-effective solution particularly popular in Asia and Europe.<\/p>\n\n\n\n Key features:<\/strong><\/p>\n\n\n\n Best for:<\/strong> Small to medium enterprises, international companies.<\/p>\n\n\n\n Pricing:<\/strong> More affordable than enterprise solutions, around $2,000-$5,000 annually<\/p>\n\n\n\n Arelle (Free Open-Source Option)<\/strong><\/p>\n\n\n\n Arelle is a free, open-source XBRL platform that’s surprisingly powerful.<\/p>\n\n\n\n What it does:<\/strong><\/p>\n\n\n\n Best for:<\/strong> Technical users, small companies on a budget, developers building custom solutions, academics studying XBRL.<\/p>\n\n\n\n Pricing:<\/strong> Completely free (donations welcome)<\/p>\n\n\n\n Download:<\/strong> arelle.org<\/p>\n\n\n\n Let me walk you through the general process using any XBRL software:<\/p>\n\n\n\n Step 1: Prepare Your Financial Statements<\/strong><\/p>\n\n\n\n Make sure your financial statements are complete and accurate. You’ll need:<\/p>\n\n\n\n Have these in Excel or Word format for easier data mapping. Clean formatting helps the software better identify line items.<\/p>\n\n\n\n Step 2: Choose Your Taxonomy<\/strong><\/p>\n\n\n\n Select the appropriate taxonomy based on your reporting requirements:<\/p>\n\n\n\n Your software will download the latest version of the taxonomy automatically.<\/p>\n\n\n\n Step 3: Map Your Data to XBRL Tags<\/strong><\/p>\n\n\n\n This is the most important step. You’ll assign XBRL tags to each line item in your financial statements.<\/p>\n\n\n\n For example:<\/p>\n\n\n\n Most modern software provides intelligent suggestions based on your line item descriptions. Review these carefully to ensure accurate mapping.<\/p>\n\n\n\n Step 4: Add Context and Dimensions<\/strong><\/p>\n\n\n\n XBRL isn’t just about the numbers\u2014you need to provide context:<\/p>\n\n\n\n Step 5: Validate Your XBRL Document<\/strong><\/p>\n\n\n\n Run validation checks to ensure:<\/p>\n\n\n\n Most software will flag errors in red and warnings in yellow, providing suggestions for fixes.<\/p>\n\n\n\n Step 6: Review Rendering<\/strong><\/p>\n\n\n\n Check the human-readable rendering of your XBRL to ensure it displays correctly:<\/p>\n\n\n\n Step 7: Generate and Export<\/strong><\/p>\n\n\n\n Once validation passes, generate your XBRL instance document. You’ll typically get:<\/p>\n\n\n\n Step 8: Test Filing<\/strong><\/p>\n\n\n\n Before submitting officially:<\/p>\n\n\n\n Step 9: Submit to Regulator<\/strong><\/p>\n\n\n\n Upload your XBRL files to the appropriate filing system:<\/p>\n\n\n\n If you’re comfortable with Excel and want more control over the process, Excel add-ins can be an excellent middle ground between manual work and full software suites.<\/p>\n\n\n\n Several add-ins convert Excel spreadsheets directly to XBRL:<\/p>\n\n\n\n RDG Filings Tagger<\/strong><\/p>\n\n\n\n How to use:<\/strong><\/p>\n\n\n\n Certent Excel Add-in<\/strong><\/p>\n\n\n\n CoreFiling Excel Add-in<\/strong><\/p>\n\n\n\n Advantages of Excel add-ins:<\/strong><\/p>\n\n\n\n Disadvantages:<\/strong><\/p>\n\n\n\n If you want to build your own process:<\/p>\n\n\n\n Here’s an example structure in Excel:<\/p>\n\n\n\n Sheet 1: Financial Data<\/strong><\/p>\n\n\n\n Sheet 2: XBRL Mapping<\/strong><\/p>\n\n\n\n Sheet 3: Context Information<\/strong><\/p>\n\n\n\n This structured approach makes it easier to automate XBRL generation using scripts.<\/p>\n\n\n\n For developers or those needing automated, repeatable processes, Python offers powerful XBRL libraries.<\/p>\n\n\n\n Installation:<\/strong><\/p>\n\n\n\n bash<\/p>\n\n\n\n Basic Python Script to Create XBRL:<\/strong><\/p>\n\n\n\n python<\/p>\n\n\n\n python<\/p>\n\n\n\n Excel Template Structure:<\/strong><\/p>\n\n\n\n Sheet: FinancialData<\/strong><\/p>\n\n\n\n Sheet: Mapping<\/strong><\/p>\n\n\n\n Sheet: CompanyInfo<\/strong><\/p>\n\n\n\n Several online platforms offer XBRL conversion as a service, ideal for occasional filers or small companies who prefer not to invest in software or technical expertise.<\/p>\n\n\n\n SEC XBRL Prep Services<\/strong><\/p>\n\n\n\n How it works:<\/strong><\/p>\n\n\n\n Pricing:<\/strong> Per-filing basis, typically $1,500-$5,000 depending on complexity<\/p>\n\n\n\n Popular providers:<\/strong> Toppan Merrill, Donnelley Financial Solutions (DFIN), Workiva Services<\/p>\n\n\n\n DataTracks Online Portal<\/strong><\/p>\n\n\n\n Process:<\/strong><\/p>\n\n\n\n Pricing:<\/strong> Subscription or pay-per-use, typically $500-$2,000 per filing<\/p>\n\n\n\n iXBRL Solutions<\/strong><\/p>\n\n\n\n Benefits of iXBRL:<\/strong><\/p>\n\n\n\n TagniFi<\/strong><\/p>\n\n\n\n Process:<\/strong><\/p>\n\n\n\n Pricing:<\/strong> Affordable monthly subscriptions starting around $50-$200\/month<\/p>\n\n\n\nWhat is XBRL and Why Does It Matter?<\/h2>\n\n\n\n
\n
Who Needs to Convert Financial Statements to XBRL?<\/h2>\n\n\n\n
Understanding XBRL Taxonomy<\/h2>\n\n\n\n
Method 1: Using XBRL Software Tools (Recommended for Most Users)<\/h2>\n\n\n\n
Popular XBRL Software Solutions<\/h3>\n\n\n\n
\n
\n
\n
\n
Step-by-Step: Converting with XBRL Software<\/h3>\n\n\n\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
Method 2: Excel-Based Conversion with Add-ins<\/h2>\n\n\n\n
Using Excel Add-ins for XBRL<\/h3>\n\n\n\n
\n
\n
\n
\n
\n
\n
DIY Excel Method<\/h3>\n\n\n\n
\n
Line Item20242023Revenue1,000,000850,000Cost of Sales600,000510,000Gross Profit400,000340,000Operating Expenses250,000220,000Net Income150,000120,000<\/pre>\n\n\n\n
Line ItemCell ReferenceXBRL TagPeriod TypeDebit\/CreditRevenueB2us-gaap:RevenuesDurationCreditCost of SalesB3us-gaap:CostOfGoodsSoldDurationDebitNet IncomeB6us-gaap:NetIncomeLossDurationCreditTotal AssetsB10us-gaap:AssetsInstantDebit<\/pre>\n\n\n\n
Context IDTypeStart DateEnd DateEntity CIKCY2024Duration2024-01-012024-12-310001234567CY2023Duration2023-01-012023-12-310001234567CY2024EndInstant-2024-12-310001234567<\/pre>\n\n\n\n
Method 3: Python Programming for Custom Solutions<\/h2>\n\n\n\n
Using Python XBRL Libraries<\/h3>\n\n\n\n
pip install arelle-release\npip install xbrlpy\npip install pandas openpyxl lxml<\/code><\/pre>\n\n\n\nfrom lxml import etree\nimport pandas as pd\nfrom datetime import datetime\n\ndef create_xbrl_instance(financial_data, company_info, output_file):\n \"\"\"\n Create XBRL instance document from financial data\n \n Args:\n financial_data: Dictionary with financial line items\n company_info: Dictionary with company details\n output_file: Path for output XBRL file\n \"\"\"\n \n # Define namespaces<\/em>\n NSMAP = {\n None: \"http:\/\/www.xbrl.org\/2003\/instance\",\n 'xsi': \"http:\/\/www.w3.org\/2001\/XMLSchema-instance\",\n 'link': \"http:\/\/www.xbrl.org\/2003\/linkbase\",\n 'xlink': \"http:\/\/www.w3.org\/1999\/xlink\",\n 'iso4217': \"http:\/\/www.xbrl.org\/2003\/iso4217\",\n 'us-gaap': \"http:\/\/fasb.org\/us-gaap\/2024\",\n 'dei': \"http:\/\/xbrl.sec.gov\/dei\/2024\"\n }\n \n # Create root element<\/em>\n root = etree.Element('xbrl', nsmap=NSMAP)\n \n # Add schema reference<\/em>\n schema_ref = etree.SubElement(root, \n '{http:\/\/www.xbrl.org\/2003\/linkbase}schemaRef',\n {'{http:\/\/www.w3.org\/1999\/xlink}type': 'simple',\n '{http:\/\/www.w3.org\/1999\/xlink}href': \n 'https:\/\/xbrl.fasb.org\/us-gaap\/2024\/entire\/us-gaap-entryPoint-std-2024.xsd'})\n \n # Add contexts<\/em>\n # Duration context for income statement items<\/em>\n context_duration = etree.SubElement(root, 'context', id='FY2024')\n entity = etree.SubElement(context_duration, 'entity')\n identifier = etree.SubElement(entity, 'identifier',\n scheme='http:\/\/www.sec.gov\/CIK')\n identifier.text = company_info['cik']\n \n period = etree.SubElement(context_duration, 'period')\n start_date = etree.SubElement(period, 'startDate')\n start_date.text = '2024-01-01'\n end_date = etree.SubElement(period, 'endDate')\n end_date.text = '2024-12-31'\n \n # Instant context for balance sheet items<\/em>\n context_instant = etree.SubElement(root, 'context', id='FY2024End')\n entity2 = etree.SubElement(context_instant, 'entity')\n identifier2 = etree.SubElement(entity2, 'identifier',\n scheme='http:\/\/www.sec.gov\/CIK')\n identifier2.text = company_info['cik']\n \n period2 = etree.SubElement(context_instant, 'period')\n instant = etree.SubElement(period2, 'instant')\n instant.text = '2024-12-31'\n \n # Add unit (USD)<\/em>\n unit = etree.SubElement(root, 'unit', id='USD')\n measure = etree.SubElement(unit, 'measure')\n measure.text = 'iso4217:USD'\n \n # Add company information facts<\/em>\n entity_name = etree.SubElement(root, '{http:\/\/xbrl.sec.gov\/dei\/2024}EntityRegistrantName',\n contextRef='FY2024End')\n entity_name.text = company_info['name']\n \n cik_fact = etree.SubElement(root, '{http:\/\/xbrl.sec.gov\/dei\/2024}EntityCentralIndexKey',\n contextRef='FY2024End')\n cik_fact.text = company_info['cik']\n \n # Add financial facts<\/em>\n for item_name, item_data in financial_data.items():\n xbrl_tag = item_data['tag']\n value = item_data['value']\n context_ref = item_data['context'] # 'FY2024' or 'FY2024End'<\/em>\n \n fact = etree.SubElement(root, \n f\"{{http:\/\/fasb.org\/us-gaap\/2024}}{xbrl_tag}\",\n contextRef=context_ref,\n unitRef='USD',\n decimals='0')\n fact.text = str(value)\n \n # Write to file<\/em>\n tree = etree.ElementTree(root)\n tree.write(output_file, \n pretty_print=True,\n xml_declaration=True,\n encoding='utf-8')\n \n print(f\"\u2713 XBRL instance created: {output_file}\")\n\n# Example usage<\/em>\ncompany_info = {\n 'name': 'Example Corporation',\n 'cik': '0001234567'\n}\n\nfinancial_data = {\n 'revenue': {\n 'tag': 'Revenues',\n 'value': 1000000,\n 'context': 'FY2024'\n },\n 'cost_of_sales': {\n 'tag': 'CostOfGoodsSold',\n 'value': 600000,\n 'context': 'FY2024'\n },\n 'net_income': {\n 'tag': 'NetIncomeLoss',\n 'value': 150000,\n 'context': 'FY2024'\n },\n 'assets': {\n 'tag': 'Assets',\n 'value': 5000000,\n 'context': 'FY2024End'\n },\n 'liabilities': {\n 'tag': 'Liabilities',\n 'value': 3000000,\n 'context': 'FY2024End'\n },\n 'equity': {\n 'tag': 'StockholdersEquity',\n 'value': 2000000,\n 'context': 'FY2024End'\n }\n}\n\ncreate_xbrl_instance(financial_data, company_info, 'financial_statement.xbrl')<\/code><\/pre>\n\n\n\nMore Advanced Python Example with Excel Input<\/h3>\n\n\n\n
import pandas as pd\nfrom lxml import etree\nfrom datetime import datetime\n\ndef excel_to_xbrl_advanced(excel_file, output_file):\n \"\"\"\n Read financial statements from Excel and create XBRL\n \n Excel should have sheets:\n - FinancialData: Line items with values\n - Mapping: XBRL tag mappings\n - CompanyInfo: Entity details\n \"\"\"\n \n # Read Excel sheets<\/em>\n financial_df = pd.read_excel(excel_file, sheet_name='FinancialData')\n mapping_df = pd.read_excel(excel_file, sheet_name='Mapping')\n company_df = pd.read_excel(excel_file, sheet_name='CompanyInfo')\n \n # Extract company information<\/em>\n company_name = company_df.loc[company_df['Field'] == 'Name', 'Value'].values[0]\n company_cik = company_df.loc[company_df['Field'] == 'CIK', 'Value'].values[0]\n fiscal_year_end = company_df.loc[company_df['Field'] == 'FiscalYearEnd', 'Value'].values[0]\n \n # Create XBRL structure<\/em>\n NSMAP = {\n None: \"http:\/\/www.xbrl.org\/2003\/instance\",\n 'xsi': \"http:\/\/www.w3.org\/2001\/XMLSchema-instance\",\n 'link': \"http:\/\/www.xbrl.org\/2003\/linkbase\",\n 'xlink': \"http:\/\/www.w3.org\/1999\/xlink\",\n 'iso4217': \"http:\/\/www.xbrl.org\/2003\/iso4217\",\n 'us-gaap': \"http:\/\/fasb.org\/us-gaap\/2024\",\n 'dei': \"http:\/\/xbrl.sec.gov\/dei\/2024\"\n }\n \n root = etree.Element('xbrl', nsmap=NSMAP)\n \n # Add schema reference<\/em>\n schema_ref = etree.SubElement(root,\n '{http:\/\/www.xbrl.org\/2003\/linkbase}schemaRef',\n {'{http:\/\/www.w3.org\/1999\/xlink}type': 'simple',\n '{http:\/\/www.w3.org\/1999\/xlink}href':\n 'https:\/\/xbrl.fasb.org\/us-gaap\/2024\/entire\/us-gaap-entryPoint-std-2024.xsd'})\n \n # Create contexts based on period types in mapping<\/em>\n contexts_needed = mapping_df['PeriodType'].unique()\n \n for period_type in contexts_needed:\n if period_type == 'Duration':\n context = etree.SubElement(root, 'context', id='Current_Duration')\n entity = etree.SubElement(context, 'entity')\n identifier = etree.SubElement(entity, 'identifier',\n scheme='http:\/\/www.sec.gov\/CIK')\n identifier.text = str(company_cik)\n \n period = etree.SubElement(context, 'period')\n start_date = etree.SubElement(period, 'startDate')\n start_date.text = '2024-01-01'\n end_date = etree.SubElement(period, 'endDate')\n end_date.text = fiscal_year_end\n \n elif period_type == 'Instant':\n context = etree.SubElement(root, 'context', id='Current_Instant')\n entity = etree.SubElement(context, 'entity')\n identifier = etree.SubElement(entity, 'identifier',\n scheme='http:\/\/www.sec.gov\/CIK')\n identifier.text = str(company_cik)\n \n period = etree.SubElement(context, 'period')\n instant = etree.SubElement(period, 'instant')\n instant.text = fiscal_year_end\n \n # Add unit<\/em>\n unit = etree.SubElement(root, 'unit', id='USD')\n measure = etree.SubElement(unit, 'measure')\n measure.text = 'iso4217:USD'\n \n # Merge financial data with mapping<\/em>\n merged_df = financial_df.merge(mapping_df, on='LineItem', how='left')\n \n # Create facts<\/em>\n for _, row in merged_df.iterrows():\n if pd.notna(row['XBRLTag']) and pd.notna(row['Value']):\n xbrl_tag = row['XBRLTag']\n value = row['Value']\n period_type = row['PeriodType']\n \n context_ref = 'Current_Duration' if period_type == 'Duration' else 'Current_Instant'\n \n fact = etree.SubElement(root,\n f\"{{http:\/\/fasb.org\/us-gaap\/2024}}{xbrl_tag}\",\n contextRef=context_ref,\n unitRef='USD',\n decimals='0')\n fact.text = str(int(value))\n \n # Write to file<\/em>\n tree = etree.ElementTree(root)\n tree.write(output_file,\n pretty_print=True,\n xml_declaration=True,\n encoding='utf-8')\n \n print(f\"\u2713 Successfully converted {excel_file} to {output_file}\")\n print(f\"\u2713 Company: {company_name}\")\n print(f\"\u2713 Facts created: {len(merged_df)}\")\n\n# Usage<\/em>\nexcel_to_xbrl_advanced('financial_statements_template.xlsx', 'output.xbrl')<\/code><\/pre>\n\n\n\nLineItemValueYearRevenue10000002024Cost of Goods Sold6000002024Net Income1500002024Total Assets50000002024Total Liabilities30000002024<\/pre>\n\n\n\n
LineItemXBRLTagPeriodTypeNamespaceRevenueRevenuesDurationus-gaapCost of Goods SoldCostOfGoodsSoldDurationus-gaapNet IncomeNetIncomeLossDurationus-gaapTotal AssetsAssetsInstantus-gaapTotal LiabilitiesLiabilitiesInstantus-gaap<\/pre>\n\n\n\n
FieldValueNameExample CorporationCIK0001234567FiscalYearEnd2024-12-31TickerEXAM<\/pre>\n\n\n\n
Method 4: Online XBRL Conversion Services<\/h2>\n\n\n\n
Cloud-Based XBRL Services<\/h3>\n\n\n\n
\n
\n
\n
\n
\n
\n
\n
\n