Financial statements API: income statement, balance sheet and cash flow from XBRL
Each record is one fiscal period of one company: revenue down to free cash flow, total assets, debt and equity, in the same field names for every filer. Fourth quarters are derived from the annual report, and splits are applied the way the company restated them.
- Endpoint
- POST https://api.quantisnow.com/v1/financials
- Coverage
- 5,297 filers, 195,000 periods, from each company's first XBRL filing (2009 for large filers)
- How fresh
- Updated daily from new 10-K, 10-Q, 20-F and 40-F filings
- Source
- XBRL financial data in 10-K, 10-Q, 20-F and 40-F filings
What were Apple's revenue and net income in each of the last eight quarters?
A quarterly series for a model or a chart, already split into quarters.
curl -X POST https://api.quantisnow.com/v1/financials \
-H "Authorization: $QUANTISNOW_API_KEY" \
-H "Content-Type: application/json" \
-d '{
"query": "ticker:AAPL AND fiscalPeriod:(Q1 OR Q2 OR Q3 OR Q4)",
"from": 0,
"size": 5,
"sort": [
{
"periodEnd": {
"order": "desc"
}
}
]
}'Response
{
"total": {
"value": 40,
"relation": "eq"
},
"data": [
{
"cik": "0000320193",
"ticker": "AAPL",
"companyName": "Apple Inc.",
"fiscalYear": 2026,
"fiscalPeriod": "Q4",
"periodStart": "2026-06-28",
"periodEnd": "2026-09-26",
"form": "10-K",
"accessionNo": "0000320193-26-000026",
"derived": true,
"incomeStatement": {
"revenue": 114477000000,
"grossProfit": 54820000000,
"operatingIncome": 35631000000,
"netIncome": 30711000000,
"epsDiluted": 2.11
},
"balanceSheet": {
"cash": 36305000000,
"totalAssets": 404548000000,
"totalDebt": 78114000000,
"equity": 112093000000
},
"cashFlow": {
"operatingCashFlow": 28101000000,
"capex": 2242000000,
"freeCashFlow": 25859000000,
"shareRepurchases": 24296000000
}
},
{
"cik": "0000320193",
"ticker": "AAPL",
"companyName": "Apple Inc.",
"fiscalYear": 2026,
"fiscalPeriod": "Q3",
"periodStart": "2026-03-29",
"periodEnd": "2026-06-27",
"form": "10-Q",
"accessionNo": "0000320193-26-000020",
"derived": false,
"incomeStatement": {
"revenue": 109417000000,
"grossProfit": 54770000000,
"operatingIncome": 35695000000,
"netIncome": 29789000000,
"epsDiluted": 2.02
},
"balanceSheet": {
"cash": 39544000000,
"totalAssets": 383266000000,
"totalDebt": 82347000000,
"equity": 107520000000
},
"cashFlow": {
"operatingCashFlow": 34369000000,
"capex": 2455000000,
"freeCashFlow": 31914000000,
"shareRepurchases": 25105000000
}
},
{
"cik": "0000320193",
"ticker": "AAPL",
"companyName": "Apple Inc.",
"fiscalYear": 2026,
"fiscalPeriod": "Q2",
"periodStart": "2025-12-28",
"periodEnd": "2026-03-28",
"form": "10-Q",
"accessionNo": "0000320193-26-000013",
"derived": false,
"incomeStatement": {
"revenue": 111184000000,
"grossProfit": 54781000000,
"operatingIncome": 35885000000,
"netIncome": 29578000000,
"epsDiluted": 2.01
},
"balanceSheet": {
"cash": 45572000000,
"totalAssets": 371082000000,
"totalDebt": 82714000000,
"equity": 106491000000
},
"cashFlow": {
"operatingCashFlow": 28702000000,
"capex": 1971000000,
"freeCashFlow": 26731000000,
"shareRepurchases": 12288000000
}
},
{
"cik": "0000320193",
"ticker": "AAPL",
"companyName": "Apple Inc.",
"fiscalYear": 2026,
"fiscalPeriod": "Q1",
"periodStart": "2025-09-28",
"periodEnd": "2025-12-27",
"form": "10-Q",
"accessionNo": "0000320193-26-000006",
"derived": false,
"incomeStatement": {
"revenue": 143756000000,
"grossProfit": 69231000000,
"operatingIncome": 50852000000,
"netIncome": 42097000000,
"epsDiluted": 2.84
},
"balanceSheet": {
"cash": 45317000000,
"totalAssets": 379297000000,
"totalDebt": 88512000000,
"equity": 88190000000
},
"cashFlow": {
"operatingCashFlow": 53925000000,
"capex": 2373000000,
"freeCashFlow": 51552000000,
"shareRepurchases": 24701000000
}
},
{
"cik": "0000320193",
"ticker": "AAPL",
"companyName": "Apple Inc.",
"fiscalYear": 2025,
"fiscalPeriod": "Q4",
"periodStart": "2025-06-29",
"periodEnd": "2025-09-27",
"form": "10-K",
"accessionNo": "0000320193-26-000026",
"derived": true,
"incomeStatement": {
"revenue": 102466000000,
"grossProfit": 48341000000,
"operatingIncome": 32427000000,
"netIncome": 27466000000,
"epsDiluted": 1.84
},
"balanceSheet": {
"cash": 35934000000,
"totalAssets": 359241000000,
"totalDebt": 90678000000,
"equity": 73733000000
},
"cashFlow": {
"operatingCashFlow": 29728000000,
"capex": 3242000000,
"freeCashFlow": 26486000000,
"shareRepurchases": 20132000000
}
}
]
}Every request is a JSON body with a query in Lucene syntax, from and size for paging (at most 50 a page and 10,000 a query), and an optional sort. The query syntax page has the operators, errors and rate limits.
Fields
Every field is searchable and sortable. Nested fields use dots: issuer.ticker:AAPL.
| Field | Type | What it holds |
|---|---|---|
| cik | string | Filer CIK. |
| ticker | string | Primary ticker. |
| companyName | string | Company name. |
| fiscalYear | number | Fiscal year the period belongs to. |
| fiscalPeriod | string | Q1, Q2, Q3, Q4 or FY. |
| periodStart | date | First day of the period. |
| periodEnd | date | Last day of the period. |
| form | string | Form the numbers came from: 10-K, 10-Q, 20-F, 40-F. |
| accessionNo | string | Filing the numbers came from. |
| derived | boolean | True when the quarter was computed as the year minus the first three quarters. |
| incomeStatement.revenue | number | Total revenue. |
| incomeStatement.grossProfit | number | Gross profit. |
| incomeStatement.operatingIncome | number | Operating income. |
| incomeStatement.netIncome | number | Net income attributable to the company. |
| incomeStatement.epsDiluted | number | Diluted earnings per share. |
| balanceSheet.cash | number | Cash and equivalents. |
| balanceSheet.totalAssets | number | Total assets. |
| balanceSheet.totalDebt | number | Short and long-term debt. |
| balanceSheet.equity | number | Stockholders' equity. |
| cashFlow.operatingCashFlow | number | Cash from operations. |
| cashFlow.capex | number | Capital expenditure. |
| cashFlow.freeCashFlow | number | Operating cash flow minus capex. |
| cashFlow.shareRepurchases | number | Cash spent on buybacks. |
More examples
Which companies with over $10 billion in revenue had negative free cash flow last fiscal year?
A screen across every filer in one call, which needs the same field names for every company to work.
curl -X POST https://api.quantisnow.com/v1/financials \
-H "Authorization: $QUANTISNOW_API_KEY" \
-H "Content-Type: application/json" \
-d '{
"query": "fiscalPeriod:FY AND fiscalYear:2025 AND incomeStatement.revenue:>10000000000 AND cashFlow.freeCashFlow:<0",
"from": 0,
"size": 5,
"sort": [
{
"incomeStatement.revenue": {
"order": "desc"
}
}
]
}'Response
{
"total": {
"value": 76,
"relation": "eq"
},
"data": [
{
"cik": "0001913510",
"ticker": "VFS",
"companyName": "VinFast Auto Ltd.",
"fiscalYear": 2025,
"fiscalPeriod": "FY",
"periodStart": "2025-01-01",
"periodEnd": "2025-12-31",
"form": "20-F",
"accessionNo": "0001104659-26-052266",
"derived": false,
"incomeStatement": {
"revenue": 90178628000000,
"grossProfit": -40910520000000,
"operatingIncome": -74094201000000,
"netIncome": -99384659000000,
"epsDiluted": -42488
},
"balanceSheet": {
"cash": 7351998000000,
"totalAssets": 182622042000000,
"totalDebt": 82164164000000,
"equity": -173936583000000
},
"cashFlow": {
"operatingCashFlow": -44461239000000,
"capex": 22979265000000,
"freeCashFlow": -67440504000000,
"shareRepurchases": null
}
},
{
"cik": "0000889132",
"ticker": "PKX",
"companyName": "POSCO HOLDINGS INC.",
"fiscalYear": 2025,
"fiscalPeriod": "FY",
"periodStart": "2025-01-01",
"periodEnd": "2025-12-31",
"form": "20-F",
"accessionNo": "0001193125-26-188766",
"derived": false,
"incomeStatement": {
"revenue": 68986938000000,
"grossProfit": 5137361000000,
"operatingIncome": 1477393000000,
"netIncome": 690686000000,
"epsDiluted": 9134
},
"balanceSheet": {
"cash": 7049800000000,
"totalAssets": 105287678000000,
"totalDebt": 28492000000000,
"equity": 55759204000000
},
"cashFlow": {
"operatingCashFlow": 4571910000000,
"capex": 5665151000000,
"freeCashFlow": -1093241000000,
"shareRepurchases": null
}
},
{
"cik": "0000715153",
"ticker": "HMC",
"companyName": "Honda Motor Company Ltd.",
"fiscalYear": 2025,
"fiscalPeriod": "FY",
"periodStart": "2024-04-01",
"periodEnd": "2025-03-31",
"form": "20-F",
"accessionNo": "0001193125-26-274991",
"derived": false,
"incomeStatement": {
"revenue": 21688767000000,
"grossProfit": 4663979000000,
"operatingIncome": 1213486000000,
"netIncome": 835837000000,
"epsDiluted": 178.93
},
"balanceSheet": {
"cash": 4528795000000,
"totalAssets": 30775867000000,
"totalDebt": 11451267000000,
"equity": 12326529000000
},
"cashFlow": {
"operatingCashFlow": 292152000000,
"capex": 510803000000,
"freeCashFlow": -218651000000,
"shareRepurchases": null
}
},
{
"cik": "0000067088",
"ticker": "MUFG",
"companyName": "Mitsubishi UFJ Financial Group Inc.",
"fiscalYear": 2025,
"fiscalPeriod": "FY",
"periodStart": "2025-04-01",
"periodEnd": "2026-03-31",
"form": "20-F",
"accessionNo": "0001628280-26-047095",
"derived": false,
"incomeStatement": {
"revenue": 11867264000000,
"grossProfit": null,
"operatingIncome": 2365400000000,
"netIncome": 1729359000000,
"epsDiluted": 151.09
},
"balanceSheet": {
"cash": 90378397000000,
"totalAssets": 425581652000000,
"totalDebt": 21884349000000,
"equity": 19573133000000
},
"cashFlow": {
"operatingCashFlow": -3366465000000,
"capex": 302858000000,
"freeCashFlow": -3669323000000,
"shareRepurchases": 500066000000
}
},
{
"cik": "0001335730",
"ticker": "MFG",
"companyName": "Mizuho Financial Group Inc. Sponosred ADR (Japan)",
"fiscalYear": 2025,
"fiscalPeriod": "FY",
"periodStart": "2024-04-01",
"periodEnd": "2025-03-31",
"form": "20-F",
"accessionNo": "0001193125-26-283791",
"derived": false,
"incomeStatement": {
"revenue": 8169900000000,
"grossProfit": null,
"operatingIncome": null,
"netIncome": 593393000000,
"epsDiluted": 234.52
},
"balanceSheet": {
"cash": 73435979000000,
"totalAssets": 276741152000000,
"totalDebt": 14914120000000,
"equity": 10065015000000
},
"cashFlow": {
"operatingCashFlow": 59044000000,
"capex": 338013000000,
"freeCashFlow": -278969000000,
"shareRepurchases": 102921000000
}
}
]
}Good to know
- Values are in the filing's reporting currency; foreign filers carry
currencyand ausdcopy converted at the quarter-end Treasury rate. - Banks and insurers have no gross profit, and their revenue is total revenue as they report it.
Guides that use it
- How to load SEC financial statements into pandas
Pull quarterly income statement, balance sheet and cash flow data from XBRL filings into a pandas DataFrame, and screen every filer on one metric.
- How to search SEC filings from Claude, ChatGPT or Cursor with MCP
Connect the Quantisnow MCP server to an AI assistant and ask about filings, insider trades, 13F holdings and financials in plain English.
- SEC's free EDGAR APIs vs a filings search API: what each is for
What data.sec.gov, EDGAR full-text search and the bulk files give you for free, where they stop, and when a search API saves the work.