Home Forums The XBRL API Revenue Pull

Viewing 1 reply thread
  • Author
    • #214696
      Jeremie Hicks

      i got it linked up with google sheets, and now i just want to pull a company annual revenue. is that to simple?

    • #214762
      David Tauriello

      Hi Jeremie – after you login and re-open the the spreadsheet extension, there are a number of filters to guide this search. On the fact function, you’ll want to use the ‘Get Facts by Entity Name’ for the company (ie. type and select Adobe Inc. when it appears), remove all but the 10-K value in the Filter by Document Type field and add the fiscal year 2022 and period Y (for year) in the corresponding form fields for the search.

      Adobe Inc. uses Revenues * in its reporting, so put that in the Filter by Concept Name field, set “Get Latest Facts’ to true and then click ‘Get’ for a result. If you remove the year from the query, you’ll get Adobe’s revenues for all years as reported in XBRL.

      We’ve posted several templates on the Data Community page linked at right, along with documentation for the parameters and fields you can use with the XBRL API.

      * There are a number of concepts companies can use to report revenue – this decision-making process is guided by the company’s research of the Financial Accounting Standards Board’s US GAAP Taxonomy, where these concepts are defined. Annual versions of the taxonomy are available from the XBRL API, and you can also get details from the ‘Taxonomy Viewer’ link on the right side of this page.

      Some of the most common concepts used are:

      • Revenues
      • RegulatedAndUnregulatedOperatingRevenue
      • InterestAndDividendIncomeSecurities
      • ResultsOfOperationsRevenueFromOilAndGasProducingActivities
      • LeaseIncome
      • RevenueFromContractWithCustomerIncludingAssessedTax
      • RevenueNotFromContractWithCustomerExcludingInterestIncome
      • RevenueFromContractWithCustomerExcludingAssessedTax
      • RevenueFromCollaborativeArrangementExcludingRevenueFromContractWithCustomer
Viewing 1 reply thread
  • You must be logged in to reply to this topic.

Upcoming XBRL US Events

Center for Data Quality Committee Meeting
Thursday, June 27, 2024

Get Ready for SEC Fee Based Filing Payments Modernization
Thursday, July 11, 2024

Domain Steering Committee Meeting
Tuesday, July 16, 2024

Communications & Services Steering Committee Meeting
Tuesday, July 16, 2024

GovFin 2024: Municipal Reporting Workshop
Tuesday, July 30, 2024

FERC: How Regulators Use Technology to Improve Efficiency
Wednesday, September 11, 2024