Financial Data API

Balance Sheet API

The Balance Sheet API returns annual and quarterly financial position data for over 60,000 publicly traded companies. Each response includes 75+ line items covering the complete balance sheet. current and non-current assets, current and non-current liabilities, and shareholders' equity. This gives you a full snapshot of what a company owns, what it owes, and what remains for shareholders at any point in time.

Balance sheet data is essential for assessing financial health, solvency, and capital structure. Use it to calculate leverage ratios (debt-to-equity, debt-to-assets), liquidity metrics (current ratio, quick ratio), and working capital. Combined with income statement and cash flow data, the balance sheet completes the fundamental analysis picture needed for credit analysis, valuation modeling, and investment screening.

The endpoint supports all standard company identifiers. ticker symbols, SEC CIK numbers, CUSIP codes, and ISIN codes. You can request up to 20+ years of annual data or 80+ quarters of historical results, with filtering by fiscal year or date range.

GEThttps://api.roic.ai/v2/fundamental/balance-sheet/{identifier}

Parameters

Path Parameters

identifierstringrequired

Company identifier — supports ticker symbol (e.g., `AAPL`), CIK, CUSIP, or ISIN.

Example: AAPL

Query Parameters

apikeystringrequired

Your API key for authentication.

periodstringoptional

Reporting period for financial data.

Default: annualValues: annual, quarterly
limitnumberoptional

Maximum number of periods to return.

Default: 10Example: 10
fiscal_year_startnumberoptional

Filter results starting from this fiscal year.

Example: 2020
fiscal_year_endnumberoptional

Filter results ending at this fiscal year.

Example: 2024
date_startstringoptional

Filter results starting from this date (YYYY-MM-DD format).

Example: 2020-01-01
date_endstringoptional

Filter results ending at this date (YYYY-MM-DD format).

Example: 2024-12-31
orderstringoptional

Sort order for time-series data.

Default: DESCValues: ASC, DESC
formatstringoptional

Response format. Use `json` for JSON (default) or `excel` for tab-separated values compatible with Google Sheets and Excel.

Default: jsonValues: json, excel

Code Examples

curl "https://api.roic.ai/v2/fundamental/balance-sheet/AAPL?apikey=YOUR_API_KEY"

Response

Response200 OK
[
  {
    "ticker": "AAPL",
    "date": "2025-09-30",
    "period": "annual",
    "period_label": "2025",
    "fiscal_year": "2025",
    "currency": "USD",
    "bs_c_and_ce_and_sti_detailed": 54697000000,
    "bs_cash_near_cash_item": 35934000000,
    "bs_mkt_sec_other_st_invest": 18763000000,
    "bs_acct_note_rcv": 72957000000,
    "bs_accts_rec_excl_notes_rec": 39777000000,
    "bs_other_current_receivable": 33180000000,
    "bs_inventories": 5718000000,
    "bs_other_inv": 5718000000,
    "bs_other_current_assets_detailed": 14585000000,
    "bs_cur_asset_report": 147957000000,
    "bs_net_fix_asset": 49834000000,
    "bs_gross_fix_asset": 125848000000,
    "bs_accum_depr": 76014000000,
    "bs_lt_invest": 77723000000,
    "bs_long_term_investments": 77723000000,
    "bs_other_assets_def_chrg_other": 83727000000,
    "bs_other_noncurrent_assets_detailed": 83727000000,
    "bs_tot_non_cur_asset": 211284000000,
    "bs_tot_asset": 359241000000,
    "bs_acct_payable_and_accruals_detailed": 91795000000,
    "bs_acct_payable": 69860000000,
    "bs_taxes_payable": 13016000000,
    "bs_accrual": 8919000000,
    "bs_st_borrow": 20329000000,
    "bs_short_term_debt_detailed": 20329000000,
    "bs_other_current_liabs_sub_detailed": 53507000000,
    "bs_st_deferred_revenue": 9055000000,
    "bs_other_current_liabs_detailed": 44452000000,
    "bs_cur_liab": 165631000000,
    "bs_lt_borrow": 78328000000,
    "bs_long_term_borrowings_detailed": 78328000000,
    "bs_other_noncur_liabs_sub_detailed": 41549000000,
    "bs_other_noncurrent_liabs_detailed": 41549000000,
    "bs_non_cur_liab": 119877000000,
    "bs_tot_liab": 285508000000,
    "bs_sh_cap_and_apic": 93568000000,
    "bs_common_stock": 93568000000,
    "bs_pure_retained_earnings": -14264000000,
    "bs_other_ins_res_to_shrhldr_eqy": -5571000000,
    "bs_eqty_bef_minority_int_detailed": 73733000000,
    "bs_total_equity": 73733000000,
    "bs_tot_liab_and_eqy": 359241000000,
    "bs_sh_out": 14773260000,
    "net_debt": 62723000000,
    "net_debt_to_shrhldr_eqty": 85.06774442922436,
    "tce_ratio": 20.524661717342955,
    "cur_ratio": 0.8932929222186667,
    "cash_conversion_cycle": -72.6412378367556
  }
]

Field Dictionary

FieldDescription
bs_c_and_ce_and_sti_detailedCash, cash equivalents & short-term investments
bs_cash_near_cash_itemCash & cash equivalents
bs_mkt_sec_other_st_investMarketable securities & short-term investments
bs_acct_note_rcvAccounts & notes receivable
bs_accts_rec_excl_notes_recAccounts receivable (excluding notes)
bs_other_current_receivableOther current receivables
bs_inventoriesTotal inventories
bs_other_invOther inventories
bs_other_current_assets_detailedOther current assets
bs_cur_asset_reportTotal current assets
bs_net_fix_assetNet property, plant & equipment
bs_gross_fix_assetGross property, plant & equipment
bs_accum_deprAccumulated depreciation
bs_lt_investLong-term investments
bs_long_term_investmentsLong-term investments (detailed)
bs_other_assets_def_chrg_otherOther non-current assets
bs_other_noncurrent_assets_detailedOther non-current assets (detailed)
bs_tot_non_cur_assetTotal non-current assets
bs_tot_assetTotal assets
bs_acct_payable_and_accruals_detailedAccounts payable & accruals
bs_acct_payableAccounts payable
bs_taxes_payableTaxes payable
bs_accrualAccrued expenses
bs_st_borrowShort-term borrowings
bs_short_term_debt_detailedShort-term debt (detailed)
bs_other_current_liabs_sub_detailedOther current liabilities (sub-detailed)
bs_st_deferred_revenueShort-term deferred revenue
bs_other_current_liabs_detailedOther current liabilities
bs_cur_liabTotal current liabilities
bs_lt_borrowLong-term borrowings
bs_long_term_borrowings_detailedLong-term borrowings (detailed)
bs_other_noncur_liabs_sub_detailedOther non-current liabilities (sub-detailed)
bs_other_noncurrent_liabs_detailedOther non-current liabilities
bs_non_cur_liabTotal non-current liabilities
bs_tot_liabTotal liabilities
bs_sh_cap_and_apicShare capital & additional paid-in capital
bs_common_stockCommon stock
bs_pure_retained_earningsRetained earnings
bs_other_ins_res_to_shrhldr_eqyOther comprehensive income / loss
bs_eqty_bef_minority_int_detailedEquity before minority interest
bs_total_equityTotal shareholders' equity
bs_tot_liab_and_eqyTotal liabilities & equity
bs_sh_outShares outstanding
net_debtNet debt (total debt minus cash)
net_debt_to_shrhldr_eqtyNet debt to shareholders' equity
tce_ratioTangible common equity ratio
cur_ratioCurrent ratio
cash_conversion_cycleCash conversion cycle (days)

Metadata

FieldDescription
tickerTicker symbol
datePeriod end date
periodReporting period (annual/quarterly)
period_labelHuman-readable period label
fiscal_yearFiscal year
currencyReporting currency

Use Cases

  • Calculate leverage ratios like debt-to-equity (total_debt / total_equity) and debt-to-assets (total_debt / total_assets) for credit analysis
  • Assess liquidity using current ratio (total_current_assets / total_current_liabilities) and quick ratio to evaluate short-term solvency
  • Track working capital trends by monitoring the difference between current assets and current liabilities over time
  • Analyze capital structure by comparing total debt, equity, and cash positions across reporting periods
  • Build net asset value models using book value (total_equity) and tangible book value (equity minus goodwill and intangibles)
  • Screen for financially healthy companies by filtering on low debt-to-equity ratios, strong current ratios, and growing retained earnings
  • Monitor cash positions by tracking cash_and_equivalents and net_debt over time to assess financial flexibility
  • Power AI-driven credit analysis by feeding structured balance sheet data into models that assess default risk and creditworthiness