Financial data is informational and may be inaccurate. See Disclaimer.

drillr.ai
API keys →

Financials

Balance sheet

GET/api/v2/balance-sheets
Coverage
US / CN / JP, the last 3 years
Billing
20 cr / thousand calls

Point-in-time balance sheet values, one row per period, with 41 line-item columns plus the 12 common fields from the section preamble; period_start is always null. total_debt / net_debt are derived columns (not as-reported lines); the remaining columns are as-reported line-item values.

The example shows only a selection of line-item columns; the response field table is authoritative for the complete key set.

Shared financials conventions

US / CN / JP, the last 3 years; markets out of scope return 404 . The three statement endpoints take the same parameters (ticker / period / limit) and return one row per period, aligned on (ticker, fiscal_year, period); for each ticker they return the most recent limit periods in descending report_period order. Valuation and derived financial metrics are provided separately by /financial-metrics-snapshot.

period: FY (default) / Q1Q4 / H1. Accepts multiple comma-separated values. Periods actually disclosed per market: US FY Q1Q3 (no standalone Q4 single-quarter figure), CN FY Q1 H1 Q3, JP FY H1 (no quarterly reports); a period that does not exist returns an empty array (Q4 is currently not disclosed separately in any of the three markets and is always an empty array; the caller computes fourth-quarter flow figures itself: US = FY − Q1 − Q2 − Q3, CN = FY − Q3 (Q3 is year-to-date cumulative), and JP has no quarterly figures; /balance-sheets holds point-in-time values, so no such subtraction applies). There is no date filter; limit counts back from the most recent period.

Common fields (present on every row of all three statements):

FieldTypeDescription
tickerstringCanonical ticker (US has no suffix, e.g. AAPL; CN is 600519.SH; JP is 7203.T)
marketstringMarket code: US / CN / JP
fiscal_yearintFiscal year
periodstringFY / Q1Q4 / H1
period_startdatePeriod start date; null for /balance-sheets
report_perioddatePeriod end date
currencystringReporting currency
accounting_standardstringUS-GAAP / IFRS / CN-GAAP / JP-GAAP
accession_numberstringNative document number from the official source: US is the SEC accession (e.g. 0000320193-25-000123), JP the EDINET docID, CN the cninfo announcement id
form_typestringType of the source filing, in the market's native encoding (US: SEC form names such as 10-K / 10-Q; JP: EDINET numeric codes; CN: annual_report and the like)
filing_urlstringDeep link to the official filing; opens the source document directly
filing_datedateFiling date: the date the document became public on the official channel

Value conventions (common to all three statements):

  • Field names are cross-market canonical line-item names; values are numbers in the base unit of currency; line items that do not apply are null.
  • Cash outflows are negative, inflows positive.
  • Flow line items are as reported, no de-cumulation is applied, and the value corresponds to the [period_start, report_period] range: US quarterly reports carry single-quarter figures; the CN third-quarter report (Q3) is year-to-date cumulative, the single-quarter figure = Q3H1 and the fourth quarter = FYQ3; the semi-annual report (H1) is cumulative for the first half.
  • For derived line items (ebitda / total_debt / net_debt / free_cash_flow), missing components count as 0; the value is null only when all components are missing.
  • Only GAAP / statutory-basis figures are returned; for non-GAAP numbers, use /filing-search.

Query parameters

ParameterTypeRequiredDescription
tickerstringrequiredUp to 10 tickers, comma-separated.
periodstringoptionalFY / Q1–Q4 / H1; multiple values allowed, comma-separated; see the head of this section for which periods each market has. Default FY.
limitintoptionalNumber of periods per ticker, counting back from the most recent period; maximum 40. Default 4.

Response fields

FieldTypeDescription
tickerstringCanonical ticker (US has no suffix, e.g. AAPL; CN is 600519.SH; JP is 7203.T)
marketstringMarket code: US / CN / JP
fiscal_yearintFiscal year
periodstringFY / Q1–Q4 / H1
period_startdatePeriod start date; null for /balance-sheets
report_perioddatePeriod end date
currencystringReporting currency
accounting_standardstringUS-GAAP / IFRS / CN-GAAP / JP-GAAP
accession_numberstringNative document number from the official source: US is the SEC accession (e.g. 0000320193-25-000123), JP the EDINET docID, CN the cninfo announcement id
form_typestringType of the source filing, in the market's native encoding (US: SEC form names such as 10-K / 10-Q; JP: EDINET numeric codes; CN: annual_report and the like)
filing_urlstringDeep link to the official filing; opens the source document directly
filing_datedateFiling date: the date the document became public on the official channel
cash_and_cash_equivalentsnumberMonetary funds / cash and cash equivalents
short_term_investmentsnumberShort-term investments / financial assets held for trading
accounts_receivablenumberAccounts receivable (net)
inventoriesnumberInventories
prepaid_expensesnumberPrepayments
other_current_assetsnumberOther current assets
current_assetsnumberTotal current assets
property_plant_equipmentnumberProperty, plant and equipment, net
right_of_use_assetsnumberRight-of-use assets (includes all leases; the US-GAAP operating lease ROU is merged in)
goodwillnumberGoodwill
intangible_assetsnumberIntangible assets
long_term_investmentsnumberLong-term investments (including long-term equity investments)
deferred_tax_assetsnumberDeferred tax assets
other_non_current_assetsnumberOther non-current assets
non_current_assetsnumberTotal non-current assets
total_assetsnumberTotal assets
accounts_payablenumberAccounts payable
short_term_debtnumberShort-term borrowings. When a US filing discloses only a combined line for short-term debt and long-term debt due within one year, the entire line is recorded in this column and current_portion_of_long_term_debt is null (total_debt is unaffected)
current_portion_of_long_term_debtnumberNon-current liabilities due within one year / current maturities
employee_compensation_payablenumberEmployee compensation payable
income_taxes_payablenumberIncome taxes payable
accrued_liabilitiesnumberAccrued liabilities
deferred_revenuenumberContract liabilities / deferred revenue (current portion only)
other_current_liabilitiesnumberOther current liabilities
current_liabilitiesnumberTotal current liabilities
long_term_debtnumberLong-term borrowings / bonds payable
lease_liabilitiesnumberLease liabilities (current + non-current, includes all leases)
deferred_tax_liabilitiesnumberDeferred tax liabilities
other_non_current_liabilitiesnumberOther non-current liabilities
non_current_liabilitiesnumberTotal non-current liabilities
total_liabilitiesnumberTotal liabilities
common_stocknumberShare capital
additional_paid_in_capitalnumberCapital reserve
retained_earningsnumberRetained earnings / undistributed profits (CN includes the surplus reserve)
treasury_stocknumberTreasury stock (negative)
accumulated_other_comprehensive_incomenumberAccumulated other comprehensive income
equity_attributable_to_parentnumberEquity attributable to parent
noncontrolling_interestsnumberNoncontrolling interests
total_equitynumberTotal equity
total_debtnumberDerived (not an as-reported line) = short_term_debt + current_portion_of_long_term_debt + long_term_debt
net_debtnumberDerived (not an as-reported line) = total_debt - cash_and_cash_equivalents - short_term_investments

No key yet? Create one under API Keys — it is shown once, so store it where your shell can read it. Connecting an agent over MCP instead? That signs in through the browser and needs no key at all.

Authentication, conventions, rate limits and error shapes are the same for every endpoint — they live on REST API.