error |
Aggregate label 'OtherNoninterestExpense' starts with 'Other' |
input.sec.calculation_linkbase.edgar_model_mapping |
{} |
warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
Similarly named company. Duplicate? |
None |
{'details': [{'other_company': 'Commerce Bancshares INC Mo', 'shared_tokens': {'bancshares'}}]} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000356171', 'EntityCommonStockSharesOutstanding': 16076662, 'Assets': 2744066000, 'AssetsAndSecurities': 35880000, 'CashDepositsAndCashEquivalents': 598368000, 'Deposits': 2410483000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 15519000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 2493120000, 'LiabilitiesAndBorrowings': 1659071000, 'LiabilitiesAndStockholdersEquity': 2744066000, 'LoansAndLeasesReceivable': 1633762000, 'LongTermDebt': 0, 'NetIncome': 27399000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 31612000, 'Revenues': 0, 'remainder_Assets': 428925000, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': -1576434000, 'remainder_LiabilitiesAndStockholdersEquity': 250946000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4903409533811374, 'aggregate_val': 2379910000, 'exp_sum': 4669612000, 'exp_to_value': {'Deposits': 2289702000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1649188000, 'remainder_Liabilities': 730722000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.49157384886174516, 'aggregate_val': 2493120000, 'exp_sum': 4903603000, 'exp_to_value': {'Deposits': 2410483000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1659071000, 'remainder_Liabilities': 834049000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4835949110888776, 'aggregate_val': 2339156000, 'exp_sum': 4529692000, 'exp_to_value': {'Deposits': 2190536000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1752228000, 'remainder_Liabilities': 586928000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4903409533811374, 'aggregate_val': 2379910000, 'exp_sum': 4669612000, 'exp_to_value': {'Deposits': 2289702000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1649188000, 'remainder_Liabilities': 730722000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.49157384886174516, 'aggregate_val': 2493120000, 'exp_sum': 4903603000, 'exp_to_value': {'Deposits': 2410483000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1659071000, 'remainder_Liabilities': 834049000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000356171')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |