Balance Sheet Compare - SEC Filers
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
Use the File menu to 'Make a copy...' in your Google account, then authorize the XBRL API Access Add-on and change the ticker(s) to return data.developed & contributed by
2
Balance Sheet Compare - SEC Filers
Peter Guldberg
3
Insert 3 Company Ticker Symbols >>
gmnvobiduLimitations
4
Ticker to CIK >>000146785800003532780001329099This template displays data queried from the XBRL US Database of Public Filings for the most recent reports of three companies, based on tickers provided in row 3. The elements listed in cells A13 to A68 are common accounting concepts that are defined on the TaxonomyMap sheet and mapped to their equivalents under respectively GAAP and IFRS. The mapping only works correctly for non-financials. Use the +/- buttons in the left margin to fold/unfold lines in the balance sheet. Concepts are fetched through the API in two parts, since all of the concepts cannot be contained in one call.ShowData can only request around 60 specific facts in the same request, otherwise the url address becomes too long. This could maybe be fixed by using a URL shortener. This is why we are splitting the requests up into Assets and Liabilities+Equity
5
NOTE: report details below display in reverse chronological order, not by cell order of tickers listed above.
6
Company name links to SEC Viewer for this filing. Common Balance Sheet Concepts below are standardized. See TaxonomyMap sheet.General Motors CoBaidu, Inc.Novo Nordisk A S
7
#N/AFY 2019FY 2019ShowData can only return up to 50,000 characters
8
TaxonomyIFRSUS GAAPIFRS
9
CurrencyCNYDKKAlternative Calculation Area$A$220:$A$2500
10
ReconciledTRUETRUETRUE
11
Cash and Cash Equivalents#REF!33,443,000,00015,411,000,000
12
Short Term InvestmentsNIL112,924,000,000NILFirst row of Calculation Area220
13
Cash#REF!146,367,000,000 *15,411,000,000 *
14
Accounts ReceivableNIL7,416,000,00024,912,000,000000
15
Notes and Loans ReceivableNILNILNILReconciliationFiling 1Filing 2Filing 3
16
Other Current Receivables0 *0 *0 *Current Assets000
17
Trade and Other Current Receivables0 *7,416,000,000 *24,912,000,000 *In the currency cells in line 9, the currency can be defined in the cases where an issuer reports in more than one currency. (BIDU for example). For a list of the available currencies for that issuer see range A89:D91Noncurrent Assets000
18
InventoriesNILNIL17,641,000,000Assets000
19
Other Current Assets0 *11,779,000,000 *4,492,000,000 *Current Liabilities000
20
Current AssetsNIL165,562,000,00062,456,000,000Noncurrent Liabilities000
21
PP&E, netNIL18,311,000,00050,551,000,000Line 10 shows the result of a reconciliation check for the obtained data. If this shows up red, some of the numbers do not foot. This can be caused by the issuer having filed data that is at best controversial (See for example ADI in Q3 2018, they do not include PP&E in Noncurrent Assets, which is at least unusual, or CELG in Q3 2018 or TTWO in Q1 2019 who have reported Accumulated Other Comprehensive Income as Equity incl Portion Attr. to Noncontr. Interest). Occasionally there are calculation errors in the filed numbers (IBM in Q3 2018). It can also be caused by missing mapping concepts in the TaxonomyMap and in any event should be investigated further.Liabiliites000
22
Long Term Marketable SecuritiesNILNILNILTotal Equity000
23
Other Long Term InvestmentsNILNIL1,334,000,000Liabilities and Equity000
24
Long Term Investments0 *69,410,000,0001,334,000,000 *
25
Noncurrent Notes and Loans ReceivableNILNILNILPeriod Lookup for reportsFiling 1Filing 2Filing 3
26
GoodwillNIL18,250,000,000NILperiod.fiscal-period
2020-06-16 - 2020-06-17
YY
27
Other Intangible AssetsNIL7,887,000,0005,835,000,000period.fiscal-year202020192019
28
Intangibles0 *26,137,000,000 *5,835,000,000 *report.id294802276467268782
29
Deferred Taxes and Other Noncurrent AssetsNIL21,896,000,000 *5,436,000,000 *https://api.xbrl.us/api/v1/fact/search?report.id=294802,276467,268782&fact.ultimus-index=1&concept.local-name=DocumentPeriodEndDate&fact.has-dimensions=false&fields=period.fiscal-period,period.fiscal-year,report.id.sort(DESC)
30
Noncurrent Assets#REF!135,754,000,00063,156,000,000
31
Noncurrent Assets Held for Sale (IFRS)NILNILNIL
32
Assets#REF!301,316,000,000125,612,000,000
33
Each accounting concept is matched by a calculation area/box in the cells A218:D2016, where the calculation and decision is made between the filed concept and an alternative calculation. It would have seemed easier to implement this in an Apps Script function, but the circular nature of the calculation prevents that. If implemented in a function, Google Sheets will not recalculate when some of the data changes.
34
Short Term BorrowingsNIL2,618,000,0001,474,000,000
35
Current Portion of Long Term DebtNILNILNIL
36
Total Current Debt0 *2,618,000,000 *1,474,000,000 *
37
Accounts PayableNIL32,701,000,0006,358,000,000
38
Deferred RevenueNILNILNIL
39
Dividends PayableNILNILNIL
40
Accrued LiabilitiesNILNIL4,212,000,000
41
Total Accrued Liabilities0 *0 *4,212,000,000 *
42
Other Current Liabilities0 *22,061,000,000 *46,939,000,000 *
43
Current Liabilities0 *57,380,000,00058,983,000,000
44
45
Long Term DebtNILNIL3,009,000,000
46
Other LT Financial LiabilitiesNILNILNILTo help with flexibility and customization, the formulas in the cells A13:D68 are all similar and can be copied both vertically and horizontally without changing any parts of the formula. The cells in Column A are linked to the TaxonomyMap, and new lines added in the TaxonomyMap will be fetched along with the other data. Just be careful that the named ranges are maintained, and make sure no concept names have '+' or '-' characters in them. The calculation areas are all similar and can also be copied up and down. The only change from area to area is in the top left cell which is linked to a concept in A13:A68. They are linked with an Indirect formula to make deleting and adding lines in A13:68 easier. If a line in A13:68 becomes empty, its corresponding calculation area should also be deleted. If lines are added, remember to add a new calculation area.
47
Total Long Term Debt0 *0 *3,009,000,000 *
48
Deferred Taxes and Other Liabilities0 *71,121,000,000 *6,027,000,000 *
49
50
Noncurrent LiabilitiesNIL71,121,000,0009,036,000,000
51
Liabilities Held for Sale (IFRS)NILNILNIL
52
Liabilities#REF!128,501,000,00068,019,000,000
53
Temporary EquityNILNILNIL
54
Redeemable Noncontrolling InterestNIL1,109,000,000NIL
55
Total Redeemable Nonc. Interest0 *1,109,000,000 *0 *
56
Preferred Stock ValueNILNILNIL
57
Common Stock at Stated ValueNILNILNIL
58
Stock at Stated Value0 *0 *480,000,000
59
Additional Paid In CapitalNIL38,714,000,000NIL
60
Share Capital0 *38,714,000,000 *480,000,000 *
61
Accumulated Other Comprehensive IncomeNIL-1,383,000,000NIL
62
Retained EarningsNIL126,268,000,00057,817,000,000
63
Treasury Stock HeldNILNIL-10,000,000
*) Reported as positive, but has to be treated as negative
64
Other Equity ItemsNIL0 *-694,000,000 *
65
Stockholders Equity#REF!163,599,000,00057,593,000,000 *
66
Minority InterestNIL8,107,000,000NIL
67
Equity incl Portion Attr. to Noncontr. Interest
#REF!171,706,000,00057,593,000,000
68
Liabilities and Equity#REF!301,316,000,000125,612,000,000
69
* = calculated value from available data; NIL = not reported with corresponding element
70
71
1. Report query returns filing detailsFiling 1Filing 2Filing 3
72
https://api.xbrl.us/api/v1/report/search?entity.cik=0001467858,0000353278,0001329099&report.is-most-current=true&fields=unit,report.entity-name,report.state-of-incorporation,entity.cik,report.accession,report.document-type,report.entry-type,report.base-taxonomy,report.sec-url,report.creation-software,report.period-end,dts.id,report.id.sort(DESC),report.limit(3)Documentation for the XBRL API is at https://xbrl.us/xbrl-api-documentation.
73
If #NAME? or #ERROR? appears in cell A70 below, remove and re-insert the values on the Config tab in calls B2 and B3
3. Concept query returns additional elements (do not A-Z sort)
DTSNamespaceCr/Dr
Label Information
74
report.entity-nameGeneral Motors CoBaidu, Inc.NOVO NORDISK A Shttps://api.xbrl.us/api/v1/concept/search?dts.id=294802,276467,268782&concept.balance-type=credit,debit&concept.is-monetary=true&fields=concept.local-name.sort(ASC),dts.id,concept.namespace,concept.balance-type,label.text.sort(DESC)
75
report.state-of-incorporationE9concept.local-namedts.idconcept.namespaceconcept.balance-typelabel
76
entity.cik000146785800013290990000353278AccountsPayableCurrent268782http://fasb.org/us-gaap/2016-01-31credit
( 0 : ( label.text : Accounts Payable, Current; ) 1 : ( label.text : Accounts payable; ) )
77
report.accession
0001193125-20-172519
0001193125-20-073092
0001628280-20-001017
AccountsReceivableNetCurrent
268782http://fasb.org/us-gaap/2016-01-31debit
( 0 : ( label.text : Accounts Receivable, Net, Current; ) 1 : ( label.text : Accounts receivable; ) )
78
report.document-type8-K20-F6-K
AccretionofClosingandRepaymentFees
268782
http://www.quantenna.com/20171001
credit
( 0 : ( label.text : Plus: Accretion of closing and repayment fees; ) 1 : ( label.text : Accretion of Closing and Repayment Fees; ) 2 : ( label.text : Accretion of Closing and Repayment Fees; ) )
79
report.entry-typeinlineinlineinstanceAccruedCustomerRebates268782
http://www.quantenna.com/20171001
credit
( 0 : ( label.text : Accrued Customer Rebates; ) 1 : ( label.text : Accrued Customer Rebates; ) 2 : ( label.text : Accrued customer rebates; ) )
80
report.base-taxonomyUS GAAP 2019IFRS 2019AccruedInventoryPurchases268782
http://www.quantenna.com/20171001
credit
( 0 : ( label.text : Accrued Inventory Purchases; ) 1 : ( label.text : Accrued Inventory Purchases; ) 2 : ( label.text : Accrual for inventory purchases; ) )
81
report.sec-urlhttps://www.sec.gov/Archives/edgar/data/1467858/000119312520172519/0001193125-20-172519-index.htmhttps://www.sec.gov/Archives/edgar/data/1329099/000119312520073092/0001193125-20-073092-index.htmhttps://www.sec.gov/Archives/edgar/data/353278/000162828020001017/0001628280-20-001017-index.htm
AccruedLiabilitiesandOtherLiabilitiesCurrent
268782
http://www.quantenna.com/20171001
credit
( 0 : ( label.text : Accrued Liabilities and Other Liabilities, Current; ) 1 : ( label.text : Accrued Liabilities and Other Liabilities, Current; ) 2 : ( label.text : Accrued liabilities and other current liabilities; ) 3 : ( label.text : Accrued liabilities and other current liabilities; ) )
82
report.creation-softwareXBRL Document Created with Wdesk from WorkivaAccruedLiabilitiesCurrent268782http://fasb.org/us-gaap/2016-01-31credit
( 0 : ( label.text : Accrued Liabilities, Current; ) 1 : ( label.text : Accrued expenses; ) )
83
report.period-end2020-06-162019-12-312019-12-31
AccruedStockPlanContributions
268782
http://www.quantenna.com/20171001
credit
( 0 : ( label.text : ESPP employee contributions; ) 1 : ( label.text : Accrued Stock Plan Contributions; ) 2 : ( label.text : Accrued Stock Plan Contributions; ) )
84
dts.id395507372361363063
AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment
268782http://fasb.org/us-gaap/2016-01-31credit
( 0 : ( label.text : Accumulated Depreciation, Depletion and Amortization, Property, Plant, and Equipment; ) 1 : ( label.text : Accumulated depreciation and amortization; ) )
85
report.id294802276467268782
AccumulatedOtherComprehensiveIncomeLossNetOfTax
268782http://fasb.org/us-gaap/2016-01-31credit
( 0 : ( label.text : Accumulated other comprehensive loss; ) 1 : ( label.text : Accumulated Other Comprehensive Income (Loss), Net of Tax; ) )
86
Fiscal period of report#N/AFYFYAdditionalPaidInCapital268782http://fasb.org/us-gaap/2016-01-31credit
( 0 : ( label.text : Additional Paid in Capital; ) 1 : ( label.text : Additional paid-in capital; ) )
87
Fiscal year of report202020192019
AllocatedShareBasedCompensationExpense
268782http://fasb.org/us-gaap/2016-01-31debit
( 0 : ( label.text : Total stock-based compensation expense; ) 1 : ( label.text : Allocated Share-based Compensation Expense; ) )
88
#N/Ahttps://api.xbrl.us/api/v1/fact/search?report.id=276467&period.fiscal-year=2019&period.fiscal-period=Y&fact.has-dimensions=false&concept.local-name=Assets&fields=unithttps://api.xbrl.us/api/v1/fact/search?report.id=268782&period.fiscal-year=2019&period.fiscal-period=Y&fact.has-dimensions=false&concept.local-name=Assets&fields=unit
AmortizationOfDebtDiscountPremium
268782http://fasb.org/us-gaap/2016-01-31debit
( 0 : ( label.text : Amortization of Debt Discount (Premium); ) 1 : ( label.text : Accretion of discount on investments; ) )
89
#ERROR!unitunitAssets268782http://fasb.org/us-gaap/2016-01-31debit
( 0 : ( label.text : Total assets; ) 1 : ( label.text : Assets; ) )
90
Reporting currencyUSDDKKAssetsCurrent268782http://fasb.org/us-gaap/2016-01-31debit
( 0 : ( label.text : Total current assets; ) 1 : ( label.text : Assets, Current; ) )
91
CNYAssetsFairValueDisclosure268782http://fasb.org/us-gaap/2016-01-31debit
( 0 : ( label.text : Total cash equivalents and marketable securities; ) 1 : ( label.text : Assets, Fair Value Disclosure; ) )
92
4. Joining the Assets, Liabilities and Equity data into one data area
2. Fact queries return balance sheet Asset data
3. Fact queries return balance sheet Liability and Equity data
AvailableForSaleDebtSecuritiesAmortizedCostBasis
268782http://fasb.org/us-gaap/2016-01-31debit
( 0 : ( label.text : Total, amortized cost basis; ) 1 : ( label.text : Available-for-sale Debt Securities, Amortized Cost Basis; ) )
93
Filing 1: General Motors CoFiling 1: General Motors Co
Filing 1: General Motors Co
AvailableForSaleSecurities268782http://fasb.org/us-gaap/2016-01-31debit
( 0 : ( label.text : Marketable securities; ) 1 : ( label.text : Available-for-sale Securities; ) )
94
#N/A#N/A
AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax
268782http://fasb.org/us-gaap/2016-01-31credit
( 0 : ( label.text : Gross Unrealized Gains; ) 1 : ( label.text : Available-for-sale Securities, Accumulated Gross Unrealized Gain, before Tax; ) )
95
#ERROR!#ERROR!#ERROR!
AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax
268782http://fasb.org/us-gaap/2016-01-31debit
( 0 : ( label.text : Gross Unrealized Losses; ) 1 : ( label.text : Available-for-sale Securities, Accumulated Gross Unrealized Loss, before Tax; ) )
96
AvailableForSaleSecuritiesAmortizedCost
268782http://fasb.org/us-gaap/2016-01-31debit
( 0 : ( label.text : Available-for-sale Securities, Amortized Cost Basis; ) 1 : ( label.text : Amortized Cost; ) )
97
#ERROR!
AvailableForSaleSecuritiesDebtMaturitiesAfterOneThroughFiveYearsAmortizedCost
268782http://fasb.org/us-gaap/2016-01-31debit
( 0 : ( label.text : Due after one year to five years; ) 1 : ( label.text : Available-for-sale Securities, Debt Maturities, Year Two Through Five, Amortized Cost Basis; ) )
98
AvailableForSaleSecuritiesDebtMaturitiesAfterOneThroughFiveYearsFairValue
268782http://fasb.org/us-gaap/2016-01-31debit
( 0 : ( label.text : Due after one year to five years; ) 1 : ( label.text : Available-for-sale Securities, Debt Maturities, Year Two Through Five, Fair Value; ) )
99
AvailableForSaleSecuritiesDebtMaturitiesWithinOneYearAmortizedCost
268782http://fasb.org/us-gaap/2016-01-31debit
( 0 : ( label.text : Due in one year or less; ) 1 : ( label.text : Available-for-sale Securities, Debt Maturities, Next Twelve Months, Amortized Cost Basis; ) )
100
AvailableForSaleSecuritiesDebtMaturitiesWithinOneYearFairValue
268782http://fasb.org/us-gaap/2016-01-31debit
( 0 : ( label.text : Due in one year or less; ) 1 : ( label.text : Available-for-sale Securities, Debt Maturities, Next Twelve Months, Fair Value; ) )
Loading...