Skip to content

Invalid data in financial statements #28

@bbkrr

Description

@bbkrr

SEC-API provides financial statements in separate tables such as BalanceSheet, StatementsOfIncome and many others.

But looking at some of the companies/cik the xbrl_to_json api is providing data from some other tables which does not belong to the Balancesheet or the StatementsOfIncome

One such company is 0000764897

If we select only the RevenueFromContractWithCustomerExcludingAssessedTax of the company in StatementsOfIncome,
it gives some extra data which is not present in StatementsOfIncome, rather in some other tables.

from sec_api import XbrlApi

xbrlApi = XbrlApi(api_key)

url = "https://www.sec.gov/Archives/edgar/data/0000764897/000156459021018959/brst-10k_20201231.htm"

json_statements = xbrlApi.xbrl_to_json(htm_url=url)

revenues = [rev for rev in json_statements['StatementsOfIncome']['RevenueFromContractWithCustomerExcludingAssessedTax'] 
 if rev['period']['endDate'] == '2020-12-31']

print(revenues)

Output:

[{'decimals': '-3',
  'unitRef': 'U_iso4217USD',
  'period': {'startDate': '2020-01-01', 'endDate': '2020-12-31'},
  'segment': {'dimension': 'srt:ProductOrServiceAxis',
   'value': 'brst:CommissionsMember'},
  'value': '2437000'},
 {'decimals': '-3',
  'unitRef': 'U_iso4217USD',
  'period': {'startDate': '2020-01-01', 'endDate': '2020-12-31'},
  'segment': {'dimension': 'srt:ProductOrServiceAxis',
   'value': 'brst:ManagementAndOtherFeesMember'},
  'value': '1358000'},
 {'decimals': '-3',
  'unitRef': 'U_iso4217USD',
  'period': {'startDate': '2020-01-01', 'endDate': '2020-12-31'},
  'segment': [{'dimension': 'srt:ProductOrServiceAxis',
    'value': 'brst:LeasingCommissionsMember'},
   {'dimension': 'us-gaap:AdjustmentsForNewAccountingPronouncementsAxis',
    'value': 'us-gaap:AccountingStandardsUpdate201409Member'},
   {'dimension': 'us-gaap:TimingOfTransferOfGoodOrServiceAxis',
    'value': 'us-gaap:TransferredAtPointInTimeMember'}],
  'value': '2313000'},
 {'decimals': '-3',
  'unitRef': 'U_iso4217USD',
  'period': {'startDate': '2020-01-01', 'endDate': '2020-12-31'},
  'segment': [{'dimension': 'srt:ProductOrServiceAxis',
    'value': 'us-gaap:AssetManagement1Member'},
   {'dimension': 'us-gaap:AdjustmentsForNewAccountingPronouncementsAxis',
    'value': 'us-gaap:AccountingStandardsUpdate201409Member'},
   {'dimension': 'us-gaap:TimingOfTransferOfGoodOrServiceAxis',
    'value': 'us-gaap:TransferredOverTimeMember'}],
  'value': '711000'},
.....
.....
.....
]

Extra data are fetched from the following tables,

Screen Shot 2022-04-06 at 15 57 50

Screen Shot 2022-04-06 at 15 58 04

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions