DEV Community

Karlandersson5
Karlandersson5

Posted on

Complete Company Financial Statements Data Via API

It’s good to be back! Being developers with a background in finance, we have built this Financial Statements API for our fellow developers. I will provide sample outputs that I think you might find useful 💡

I want to inspire ideas on how you can integrate financial statement data into your project. With the rise of personal finance and investment tracking apps, financial statement API is a useful tool to run cash flow, balance sheet and income statement data behind these. Moreover, historical financial statement data can be key in financial analysis and business accounting. People like to keep an eye out for new entries and the performance of current investments – which is dependent on data. So, the right API can just be why they will pick yours over your competitors.

Image description

Cash Flow Data, Balance Sheet Data and Income Statements Data Under One API

This API covers all information points in 3 key company financial statements which are cash flows, balance sheets and income statements. This is definitely time and cost-friendly considering the alternative of separate research for API providers.

I will start with example outputs for each report type so you can see the data points they include. All accessible with the same personal API key.


Cash Flow API Output

I'm using a simple, filter-free request for META:

https://api.finnworlds.com/api/v1/cashflows?key=APIKEY&ticker=META

{
    "status": {
        "code": 200,
        "message": "OK",
        "details": ""
    },
    "result": {
        "basics": {
            "ticker": "META",
            "period": "quarterly"
        },
        "output": {
            "cash_flow": [
                {
                    "date": "2023-09-30",
                    "asset_impairment_charge": "340000000",
                    "beginning_cash_position": "29804000000",
                    "capital_expenditure": "-6543000000",
                    "cash_flow_from_continuing_financing_activities": "-5875000000",
                    "cash_flow_from_continuing_investing_activities": "-6077000000",
                    "cash_flow_from_continuing_operating_activities": "20402000000",
                    "change_in_account_payable": "612000000",
                    "change_in_accrued_expense": "78000000",
                    "change_in_other_current_assets": "-36000000",
                    "change_in_other_current_liabilities": "-72000000",
                    "change_in_payable": "621000000",
                    "change_in_payables_and_accrued_expense": "699000000",
                    "change_in_prepaid_assets": "-908000000",
                    "change_in_receivables": "-678000000",
                    "change_in_working_capital": "-995000000",
                    "changes_in_account_receivables": "-678000000",
                    "changes_in_cash": "8450000000",
                    "common_stock_payments": "-3569000000",
                    "deferred_income_tax": "3049000000",
                    "deferred_tax": "3049000000",
                    "depreciation_amortization_depletion": "2859000000",
                    "depreciation_and_amortization": "2859000000",
                    "effect_of_exchange_rate_changes": "-354000000",
                    "end_cash_position": "37900000000",
                    "financing_cash_flow": "-5875000000",
                    "free_cash_flow": "13859000000",
                    "income_tax_paid_supplemental_data": "509000000",
                    "interest_paid_supplemental_data": "120000000",
                    "investing_cash_flow": "-6077000000",
                    "issuance_of_debt": "0",
                    "long_term_debt_issuance": "0",
                    "long_term_debt_payments": "-267000000",
                    "net_business_purchase_and_sale": "-38000000",
                    "net_common_stock_issuance": "-3569000000",
                    "net_income_from_continuing_operations": "11583000000",
                    "net_investment_purchase_and_sale": "467000000",
                    "net_issuance_payments_of_debt": "-267000000",
                    "net_long_term_debt_issuance": "-267000000",
                    "net_other_financing_charges": "-2039000000",
                    "net_other_investing_changes": "-10000000",
                    "net_ppepurchase_and_sale": "-6496000000",
                    "operating_cash_flow": "20402000000",
                    "other_non_cash_items": "74000000",
                    "purchase_of_business": "-38000000",
                    "purchase_of_investment": "-1007000000",
                    "purchase_of_ppe": "-6543000000",
                    "repayment_of_debt": "-267000000",
                    "repurchase_of_capital_stock": "-3569000000",
                    "sale_of_investment": "1474000000",
                    "sale_of_ppe": "47000000",
                    "stock_based_compensation": "3492000000"
                },
               ...
            ]
        }
    }
}

Enter fullscreen mode Exit fullscreen mode

TIP: What can you use as filters for the Cash Flow API output?

  • Cash flow statement type. Was it an annual report? Quarterly? &type= year, quarter, ttm (trailing twelve months). This way you can fetch certain report types only. When not added, the default is quarterly.
  • Date range. Set the &date_from and &date_to parameters to get reports within this specific window. When not added, you will get the cash flow data on recent reports only.

Balance Sheet API

Example Balance Sheet API output based on META.

https://api.finnworlds.com/api/v1/balancesheets?key=APIKEY&ticker=META

{
    "status": {
        "code": 200,
        "message": "OK",
        "details": ""
    },
    "result": {
        "basics": {
            "ticker": "META",
            "period": "quarterly"
        },
        "output": {
            "balance_sheet": [
                {
                    "date": "2023-09-30",
                    "accounts_payable": "4372000000",
                    "accounts_receivable": "12944000000",
                    "accumulated_depreciation": "-30848000000",
                    "additional_paid_in_capital": "71224000000",
                    "available_for_sale_securities": "6142000000",
                    "buildings_and_improvements": "35422000000",
                    "capital_lease_obligations": "17834000000",
                    "capital_stock": "0",
                    "cash_and_cash_equivalents": "36890000000",
                    "cash_cash_equivalents_and_short_term_investments": "61123000000",
                    "cash_equivalents": "31557000000",
                    "cash_financial": "5333000000",
                    "common_stock": "0",
                    "common_stock_equity": "142873000000",
                    "construction_in_progress": "22945000000",
                    "current_accrued_expenses": "9422000000",
                    "current_assets": "78378000000",
                    "current_capital_lease_obligation": "1460000000",
                    "current_debt_and_capital_lease_obligation": "1460000000",
                    "current_liabilities": "30531000000",
                    "dueto_related_parties_current": "770000000",
                    "gains_losses_not_affecting_retained_earnings": "-3556000000",
                    "goodwill": "20668000000",
                    "goodwill_and_other_intangible_assets": "21481000000",
                    "gross_ppe": "135653000000",
                    "invested_capital": "161256000000",
                    "investmentin_financial_assets": "6142000000",
                    "investments_and_advances": "6142000000",
                    "land_and_improvements": "1900000000",
                    "leases": "6841000000",
                    "long_term_capital_lease_obligation": "16374000000",
                    "long_term_debt": "18383000000",
                    "long_term_debt_and_capital_lease_obligation": "34757000000",
                    "net_ppe": "104805000000",
                    "net_tangible_assets": "121392000000",
                    "ordinary_shares_number": "2571000000",
                    "other_current_assets": "4311000000",
                    "other_current_liabilities": "4931000000",
                    "other_equity_adjustments": "-3556000000",
                    "other_intangible_assets": "813000000",
                    "other_non_current_assets": "5468000000",
                    "other_non_current_liabilities": "1281000000",
                    "other_properties": "68545000000",
                    "other_short_term_investments": "24233000000",
                    "payables": "9750000000",
                    "payables_and_accrued_expenses": "19172000000",
                    "pensionand_other_post_retirement_benefit_plans_current": "4968000000",
                    "properties": "0",
                    "receivables": "12944000000",
                    "retained_earnings": "75205000000",
                    "share_issued": "2571000000",
                    "stockholders_equity": "142873000000",
                    "tangible_book_value": "121392000000",
                    "total_assets": "216274000000",
                    "total_capitalization": "161256000000",
                    "total_debt": "36217000000",
                    "total_equity_gross_minority_interest": "142873000000",
                    "total_liabilities_net_minority_interest": "73401000000",
                    "total_non_current_assets": "137896000000",
                    "total_non_current_liabilities_net_minority_interest": "42870000000",
                    "total_tax_payable": "4608000000",
                    "tradeand_other_payables_non_current": "6832000000",
                    "working_capital": "47847000000"
                },
             ...
            ]
        }
    }
}

Enter fullscreen mode Exit fullscreen mode

TIP: Same as the Cash Flows API. The ticker is a required field. You can filter the balance sheet API data more by adding type, date_from and date_to parameters.


Income Statements API

Finally, one example of Income Statements API output for META.

https://api.finnworlds.com/api/v1/incomestatements?key=APIKEY&ticker=META

{
    "status": {
        "code": 200,
        "message": "OK",
        "details": ""
    },
    "result": {
        "basics": {
            "ticker": "META",
            "period": "quarterly"
        },
        "output": {
            "income_statement": [
                {
                    "date": "2023-09-30",
                    "basic_average_shares": "2576000000",
                    "basic_eps": "4.5",
                    "cost_of_revenue": "6210000000",
                    "diluted_average_shares": "2641000000",
                    "diluted_eps": "4.39",
                    "diluted_niavailto_com_stockholders": "11583000000",
                    "ebit": "14159000000",
                    "ebitda": "17018000000",
                    "gain_on_sale_of_security": "-98000000",
                    "general_and_administrative_expense": "2070000000",
                    "gross_profit": "27936000000",
                    "interest_expense": "139000000",
                    "interest_expense_non_operating": "139000000",
                    "interest_income": "534000000",
                    "interest_income_non_operating": "534000000",
                    "net_income": "11583000000",
                    "net_income_common_stockholders": "11583000000",
                    "net_income_continuous_operations": "11583000000",
                    "net_income_from_continuing_and_discontinued_operation": "11583000000",
                    "net_income_from_continuing_operation_net_minority_interest": "11583000000",
                    "net_income_including_noncontrolling_interests": "11583000000",
                    "net_interest_income": "370000000",
                    "net_non_operating_interest_income_expense": "370000000",
                    "normalized_ebitda": "17116000000",
                    "normalized_income": "11664340000",
                    "operating_expense": "14188000000",
                    "operating_income": "13748000000",
                    "operating_revenue": "33853000000",
                    "other_gand_a": "2070000000",
                    "other_income_expense": "-98000000",
                    "pretax_income": "14020000000",
                    "reconciled_cost_of_revenue": "6210000000",
                    "reconciled_depreciation": "2859000000",
                    "research_and_development": "9241000000",
                    "selling_and_marketing_expense": "2877000000",
                    "selling_general_and_administration": "4947000000",
                    "tax_effect_of_unusual_items": "-16660000",
                    "tax_provision": "2437000000",
                    "tax_rate_for_calcs": "0.17",
                    "total_expenses": "20398000000",
                    "total_operating_income_as_reported": "13748000000",
                    "total_other_finance_cost": "25000000",
                    "total_revenue": "34146000000",
                    "total_unusual_items": "-98000000",
                    "total_unusual_items_excluding_goodwill": "-98000000"
                },
               ...
            ]
        }
    }
}

Enter fullscreen mode Exit fullscreen mode

Financial Statements Data - Conclusion

I hope this article inspired you about what you can build with Finnworlds financial statements data which you can access here. To sum up, you can access the complete content of 3 key financial statements in JSON format by using this financial statements API. It is possible to set a date and a ticker to get the exact historical or recent financial statement you want.

Top comments (0)