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 |
The EntityCommonStockSharesOutstanding does not exist |
industry.us_generic |
{} |
warning |
Similarly named company. Duplicate? |
None |
{'details': [{'other_company': 'Commerce Bancshares INC Mo', 'shared_tokens': {'bancshares'}}, {'other_company': 'Southside Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'First Us Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'Merchants Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'Kentucky Bancshares INC Ky', 'shared_tokens': {'bancshares'}}]} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 7.0068807014364, 'aggregate_val': 18642028000, 'exp_sum': 2328251000, 'exp_to_value': {'LoansAndLeasesReceivable': 0, 'AssetsAndSecurities': 90657000, 'CashDepositsAndCashEquivalents': 0, 'Goodwill': 1671520000, 'PropertyPlantAndEquipment': 282925000, 'remainder_Assets': 283149000}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001068851', 'EntityCommonStockSharesOutstanding': 56430192, 'Assets': 14583573000, 'AssetsAndSecurities': 46099000, 'CashDepositsAndCashEquivalents': 326304000, 'Deposits': 11641844000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 1217162000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 12494184000, 'LiabilitiesAndBorrowings': 8936518000, 'LiabilitiesAndStockholdersEquity': 14583573000, 'LoansAndLeasesReceivable': 5127376000, 'LongTermDebt': 0, 'NetIncome': 0, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 205268000, 'Revenues': 0, 'remainder_Assets': 7661364000, 'remainder_ComprehensiveNetIncome': 163415000, 'remainder_Expenses': 0, 'remainder_Liabilities': -8084178000, 'remainder_LiabilitiesAndStockholdersEquity': 2089389000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 0, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001068851', 'EntityCommonStockSharesOutstanding': 65953559, 'Assets': 18642028000, 'AssetsAndSecurities': 90657000, 'CashDepositsAndCashEquivalents': 0, 'Deposits': 15291271000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 1671520000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 15855210000, 'LiabilitiesAndBorrowings': 11255287000, 'LiabilitiesAndStockholdersEquity': 18642028000, 'LoansAndLeasesReceivable': 0, 'LongTermDebt': 0, 'NetIncome': 0, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 282925000, 'Revenues': 0, 'remainder_Assets': 16596926000, 'remainder_ComprehensiveNetIncome': 217295000, 'remainder_Expenses': 0, 'remainder_Liabilities': -10691348000, 'remainder_LiabilitiesAndStockholdersEquity': 2786818000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001068851', 'EntityCommonStockSharesOutstanding': 70030090, 'Assets': 22037216000, 'AssetsAndSecurities': 9571080000, 'CashDepositsAndCashEquivalents': 563962000, 'Deposits': 17681119000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 1868827000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 18574306000, 'LiabilitiesAndBorrowings': 13120578000, 'LiabilitiesAndStockholdersEquity': 22037216000, 'LoansAndLeasesReceivable': 9357205000, 'LongTermDebt': 0, 'NetIncome': 286646000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 267996000, 'Revenues': 0, 'remainder_Assets': 408146000, 'remainder_ComprehensiveNetIncome': -1689000, 'remainder_Expenses': 0, 'remainder_Liabilities': -12227391000, 'remainder_LiabilitiesAndStockholdersEquity': 3462910000, '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.48081097091090214, 'aggregate_val': 18688761000, 'exp_sum': 35996063000, 'exp_to_value': {'Deposits': 17307302000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 13175039000, 'remainder_Liabilities': 5513722000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.48713013055384674, 'aggregate_val': 18763138000, 'exp_sum': 36584598000, 'exp_to_value': {'Deposits': 17821460000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 12812717000, 'remainder_Liabilities': 5950421000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.48161033100454526, 'aggregate_val': 8024233000, 'exp_sum': 15479153000, 'exp_to_value': {'Deposits': 7454920000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 6194105000, 'remainder_Liabilities': 1830128000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.49401948802561463, 'aggregate_val': 8255406000, 'exp_sum': 16315660000, 'exp_to_value': {'Deposits': 8060254000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 6140439000, 'remainder_Liabilities': 2114967000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.482342993635904, 'aggregate_val': 12494184000, 'exp_sum': 24136028000, 'exp_to_value': {'Deposits': 11641844000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 8936518000, 'remainder_Liabilities': 3557666000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4909469869164353, 'aggregate_val': 15855210000, 'exp_sum': 31146481000, 'exp_to_value': {'Deposits': 15291271000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 11255287000, 'remainder_Liabilities': 4599923000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4920771502665823, 'aggregate_val': 18262907000, 'exp_sum': 35956065000, 'exp_to_value': {'Deposits': 17693158000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 12840243000, 'remainder_Liabilities': 5422664000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4876820227593526, 'aggregate_val': 18574306000, 'exp_sum': 36255425000, 'exp_to_value': {'Deposits': 17681119000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 13120578000, 'remainder_Liabilities': 5453728000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.48081097091090214, 'aggregate_val': 18688761000, 'exp_sum': 35996063000, 'exp_to_value': {'Deposits': 17307302000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 13175039000, 'remainder_Liabilities': 5513722000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.48713013055384674, 'aggregate_val': 18763138000, 'exp_sum': 36584598000, 'exp_to_value': {'Deposits': 17821460000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 12812717000, 'remainder_Liabilities': 5950421000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('EntityCommonStockSharesOutstanding')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001068851')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |