Dimensions redux

[mpreiss9]

Issue Type

• [X ] Data Quality Issue (incorrect financial values, missing data)
• XBRL Parsing Issue (statement rendering, concept mapping)
• Filing Access Issue (download failures, attachment problems)
• Performance Issue (slow operations, memory problems)
• Compatibility Issue (platform/dependency conflicts)
• Documentation Issue (unclear instructions, missing examples)

Environment

EdgarTools Version: 5.7.1
Python Version: 3.14
Operating System: macOS 14.0

Bug Description

There's been a lot of back on forth on the dimensions issue. Although I think we're heading in the right direction, I don't think we're at the destination yet.

The major remaining problem I want to call out it that using xbrl.statements.income_statement(include_dimensions=False) or
xbrl.statements.income_statement() or xbrl.statements.balance_sheet(include_dimensions=False) or
xbrl.statements.balance_sheet()
will in MANY CASES produce and incomplete and out of balance statement that does not match the printed, reported financial statements. Why? Because some filers choose to report a line item in their financials with ONLY dimensional xbrl lines. Anyone using the default xbrl statement calls needs to be aware that they may have an incomplete statement.
This seems to be an income statement issue. I have not yet found a case like it in the balance sheet.

Reproduction

A small subset of problems
Cost of Goods Sold: BA 2023+, CARR 2020+, CHH 2022, CHRW 2018+, GD 2020+, HII 2020+, INTU 2018+, NOC 2019+, OTIS 2020+, RTX 2019+, SLB 2018+, STE 2019, TT 2019+, UPS 2018, VZ 2020+, WDAY 2019+, GEHC 2024+
SGA: CTAS 2020+
Depreciation/Amortization: EXPD 2018, CHH 2022, MAR 2022
LongTermDebtAndCapitalLeaseObligations: ADP 2023+, CAT 2020+
ContractWithCustomerLiabilityCurrent: BBY 2021+
Goodwill: BSX 2019, IBM 2023+, JKHY 2016+
Intangible assets: JKHY 2016+
PPE: BSX 2019, CSX 2015 +, HLT 2022+
Short term debt: CAT 2020+
Payables: COP 2023, 2024, HLT 2019+( and many other categories), LYB 2023+
Receivables: COP 2023 2024, FIS 2024+, GEHC 2023+, GEV 2024+, LYB 2023+

There are many many more line items and filings with this problem, more than I can list.
There are some line items but these are the common ones.
Relevant Forms: 10-K

Additional Context

If there is going to be a default dimensions=False option, I see two possible paths to improvement:

1. Document that dimensions=False or not providing this parameter may lead to an incomplete and out of balance balance sheet or income statement
2. Add some more sophistication to the default option so certain dimensional data is provided anyway if and only if it's required to make the xbrl match the printed (i.e. html) statement. This will be hard - I've been working on doing this with the dimensional xbrl data for a couple months and still find corner cases that can't be resolved. Filers have been VERY creative in misusing the xbrl standards!

---

This issue will be handled using EdgarTools' systematic issue resolution workflow. A reproduction test will be created to verify the fix.

[mpreiss9]

Further data. The below list provides instances where my code can verify that the statement cannot be balanced or complete without this dimensional data. For many of these companies there are more instances like this but my logic is not yet able to verify. I can see it by inspecting the data by hand but that's too laborious. Anyway, this gives you a start and an indication of the size of the problem.

ADP, 2020, BS, us-gaap:OperatingLeaseLiabilityNoncurrent
APD, 2023, BS, us-gaap:LongTermDebtAndCapitalLeaseObligations
APD, 2024, BS, us-gaap:LongTermDebtAndCapitalLeaseObligations
APD, 2025, BS, us-gaap:LongTermDebtAndCapitalLeaseObligations
APD, 2025, BS, us-gaap:LongTermDebtAndCapitalLeaseObligations
BA, 2023, IS, us-gaap:CostOfGoodsAndServicesSold
BBY, 2021, BS, us-gaap:ContractWithCustomerLiabilityCurrent
BBY, 2022, BS, us-gaap:ContractWithCustomerLiabilityCurrent
BBY, 2023, BS, us-gaap:ContractWithCustomerLiabilityCurrent
BBY, 2024, BS, us-gaap:ContractWithCustomerLiabilityCurrent
BBY, 2025, BS, us-gaap:ContractWithCustomerLiabilityCurrent
BBY, 2026, BS, us-gaap:ContractWithCustomerLiabilityCurrent
BDX, 2020, BS, us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax
BG, 2025, BS, us-gaap:CashAndCashEquivalentsAtCarryingValue
BG, 2025, BS, us-gaap:AccountsReceivableNetCurrent
BG, 2025, BS, us-gaap:InventoryNet
BG, 2025, BS, us-gaap:OtherAssetsCurrent
BG, 2025, BS, us-gaap:ShortTermBorrowings
BG, 2025, BS, us-gaap:LiabilitiesOfDisposalGroupIncludingDiscontinuedOperationCurrent
BG, 2025, BS, us-gaap:OtherLiabilitiesCurrent
BIIB, 2025, BS, us-gaap:AccountsReceivableNetCurrent
BIO, 2018, BS, us-gaap:TreasuryStockValue
BIO, 2018, BS, us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax
BIO, 2019, BS, us-gaap:TreasuryStockValue
BIO, 2019, BS, us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax
BIO, 2020, BS, us-gaap:TreasuryStockValue
BIO, 2020, BS, us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax
BIO, 2021, BS, us-gaap:TreasuryStockValue
BIO, 2021, BS, us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax
BIO, 2022, BS, us-gaap:TreasuryStockValue
BIO, 2022, BS, us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax
BIO, 2025, BS, us-gaap:TreasuryStockValue
BSX, 2019, BS, us-gaap:PropertyPlantAndEquipmentNet
BSX, 2019, BS, us-gaap:Goodwill
BSX, 2019, BS, us-gaap:IntangibleAssetsNetExcludingGoodwill
BSX, 2019, BS, us-gaap:OtherAssetsNoncurrent
CARR, 2020, IS, us-gaap:CostOfGoodsAndServicesSold
CARR, 2021, IS, us-gaap:CostOfGoodsAndServicesSold
CARR, 2022, IS, us-gaap:CostOfGoodsAndServicesSold
CAT, 2020, BS, us-gaap:ShortTermBorrowings
CAT, 2020, BS, us-gaap:LongTermDebtAndCapitalLeaseObligationsCurrent
CAT, 2020, BS, us-gaap:LongTermDebtAndCapitalLeaseObligations
CAT, 2021, BS, us-gaap:ShortTermBorrowings
CAT, 2021, BS, us-gaap:LongTermDebtAndCapitalLeaseObligationsCurrent
CAT, 2021, BS, us-gaap:LongTermDebtAndCapitalLeaseObligations
CAT, 2022, BS, us-gaap:ShortTermBorrowings
CAT, 2022, BS, us-gaap:LongTermDebtAndCapitalLeaseObligationsCurrent
CAT, 2022, BS, us-gaap:LongTermDebtAndCapitalLeaseObligations
CAT, 2023, BS, us-gaap:ShortTermBorrowings
CAT, 2023, BS, us-gaap:LongTermDebtAndCapitalLeaseObligationsCurrent
CAT, 2023, BS, us-gaap:LongTermDebtAndCapitalLeaseObligations
CAT, 2024, BS, us-gaap:ShortTermBorrowings
CAT, 2024, BS, us-gaap:LongTermDebtAndCapitalLeaseObligationsCurrent
CAT, 2024, BS, us-gaap:LongTermDebtAndCapitalLeaseObligations
CAT, 2025, BS, us-gaap:ShortTermBorrowings
CAT, 2025, BS, us-gaap:LongTermDebtAndCapitalLeaseObligationsCurrent
CAT, 2025, BS, us-gaap:LongTermDebtAndCapitalLeaseObligations
CDNS, 2022, IS, us-gaap:CostOfGoodsAndServicesSold
CDNS, 2025, IS, us-gaap:CostOfGoodsAndServicesSold
CHH, 2022, IS, us-gaap:DepreciationDepletionAndAmortization
CHH, 2022, IS, us-gaap:CostOfGoodsAndServicesSold
CHH, 2024, IS, us-gaap:DepreciationDepletionAndAmortization
CHH, 2024, IS, us-gaap:CostOfGoodsAndServicesSold
CHRW, 2018, IS, us-gaap:CostOfGoodsAndServicesSold
CHRW, 2018, IS, us-gaap:LaborAndRelatedExpense
CHRW, 2019, IS, us-gaap:CostOfGoodsAndServicesSold
CHRW, 2019, IS, us-gaap:LaborAndRelatedExpense
CHRW, 2020, IS, us-gaap:CostOfGoodsAndServicesSold
CHRW, 2021, IS, us-gaap:CostOfGoodsAndServicesSold
CHRW, 2022, IS, us-gaap:CostOfGoodsAndServicesSold
CHRW, 2023, IS, us-gaap:CostOfGoodsAndServicesSold
CHRW, 2025, IS, us-gaap:CostOfGoodsAndServicesSold
CHRW, 2025, IS, us-gaap:OtherSellingGeneralAndAdministrativeExpense
COP, 2023, BS, us-gaap:AccountsAndNotesReceivableNet
COP, 2023, BS, us-gaap:AccountsPayableCurrent
COP, 2024, BS, us-gaap:AccountsAndNotesReceivableNet
COP, 2024, BS, us-gaap:AccountsPayableCurrent
CSX, 2015, BS, us-gaap:PropertyPlantAndEquipmentNet
CSX, 2015, BS, us-gaap:InvestmentsInAffiliatesSubsidiariesAssociatesAndJointVentures
CSX, 2015, BS, us-gaap:OtherAssetsNoncurrent
CSX, 2016, BS, us-gaap:PropertyPlantAndEquipmentNet
CSX, 2016, BS, us-gaap:InvestmentsInAffiliatesSubsidiariesAssociatesAndJointVentures
CSX, 2016, BS, us-gaap:OtherAssetsNoncurrent
CSX, 2017, BS, us-gaap:PropertyPlantAndEquipmentNet
CSX, 2017, BS, us-gaap:InvestmentsInAffiliatesSubsidiariesAssociatesAndJointVentures
CSX, 2017, BS, us-gaap:OtherAssetsNoncurrent
CSX, 2018, BS, us-gaap:PropertyPlantAndEquipmentNet
CSX, 2018, BS, us-gaap:InvestmentsInAffiliatesSubsidiariesAssociatesAndJointVentures
CSX, 2018, BS, us-gaap:OtherAssetsNoncurrent
CSX, 2019, BS, us-gaap:PropertyPlantAndEquipmentNet
CSX, 2019, BS, us-gaap:InvestmentsInAffiliatesSubsidiariesAssociatesAndJointVentures
CSX, 2019, BS, us-gaap:OperatingLeaseRightOfUseAsset
CSX, 2019, BS, us-gaap:OtherAssetsNoncurrent
CTAS, 2020, IS, us-gaap:CostOfRevenue
CTAS, 2020, IS, us-gaap:SellingGeneralAndAdministrativeExpense
CTAS, 2021, IS, us-gaap:CostOfRevenue
CTAS, 2021, IS, us-gaap:SellingGeneralAndAdministrativeExpense
CTAS, 2022, IS, us-gaap:CostOfRevenue
CTAS, 2022, IS, us-gaap:SellingGeneralAndAdministrativeExpense
CTAS, 2023, IS, us-gaap:CostOfRevenue
CTAS, 2023, IS, us-gaap:SellingGeneralAndAdministrativeExpense
CTAS, 2024, IS, us-gaap:CostOfRevenue
CTAS, 2024, IS, us-gaap:SellingGeneralAndAdministrativeExpense
EMR, 2023, IS, us-gaap:InterestIncomeOperating
EMR, 2024, IS, us-gaap:InterestIncomeOperating
EXPD, 2018, IS, us-gaap:DirectOperatingCosts
EXPD, 2018, IS, us-gaap:DepreciationDepletionAndAmortization
FIS, 2024, BS, us-gaap:AccountsReceivableNetCurrent
FIS, 2025, BS, us-gaap:AccountsReceivableNetCurrent
G, 2019, IS, us-gaap:NetIncomeLoss
GD, 2020, IS, us-gaap:CostOfGoodsAndServicesSold
GD, 2021, IS, us-gaap:CostOfGoodsAndServicesSold
GD, 2022, IS, us-gaap:CostOfGoodsAndServicesSold
GD, 2023, IS, us-gaap:CostOfGoodsAndServicesSold
GD, 2024, IS, us-gaap:CostOfGoodsAndServicesSold
GD, 2025, IS, us-gaap:CostOfGoodsAndServicesSold
GEHC, 2023, BS, us-gaap:AccountsAndOtherReceivablesNetCurrent
GEHC, 2023, BS, us-gaap:OtherLiabilitiesCurrent
GEHC, 2024, BS, us-gaap:AccountsAndOtherReceivablesNetCurrent
GEHC, 2024, BS, us-gaap:OtherLiabilitiesCurrent
GEHC, 2024, IS, us-gaap:CostOfRevenue
GEHC, 2025, IS, us-gaap:CostOfRevenue
GEV, 2024, BS, us-gaap:ReceivablesNetCurrent
GEV, 2024, BS, us-gaap:ContractWithCustomerAssetNetCurrent
GEV, 2024, BS, us-gaap:AccountsPayableAndOtherAccruedLiabilitiesCurrent
HII, 2020, IS, us-gaap:CostOfGoodsAndServicesSold
HII, 2021, IS, us-gaap:CostOfGoodsAndServicesSold
HII, 2022, IS, us-gaap:CostOfGoodsAndServicesSold
HII, 2023, IS, us-gaap:CostOfGoodsAndServicesSold
HII, 2025, IS, us-gaap:CostOfGoodsAndServicesSold
HLT, 2019, BS, us-gaap:AccountsPayableAndAccruedLiabilitiesCurrent
HLT, 2019, BS, us-gaap:LongTermDebtAndCapitalLeaseObligationsCurrent
HLT, 2019, BS, us-gaap:DeferredRevenueCurrent
HLT, 2019, BS, us-gaap:ContractWithCustomerLiabilityCurrent
HLT, 2019, BS, us-gaap:LongTermDebtAndCapitalLeaseObligations
HLT, 2019, BS, us-gaap:OperatingLeaseLiabilityNoncurrent
HLT, 2019, BS, us-gaap:DeferredRevenueNoncurrent
HLT, 2019, BS, us-gaap:DeferredTaxLiabilitiesNoncurrent
HLT, 2019, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
HLT, 2019, BS, us-gaap:OtherLiabilitiesNoncurrent
HLT, 2020, BS, us-gaap:ContractWithCustomerLiabilityCurrent
HLT, 2020, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
HLT, 2021, BS, us-gaap:FiniteLivedIntangibleAssetsNet
HLT, 2021, BS, us-gaap:PropertyPlantAndEquipmentNet
HLT, 2021, BS, us-gaap:ContractWithCustomerLiabilityCurrent
HLT, 2021, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
HLT, 2022, BS, us-gaap:FiniteLivedIntangibleAssetsNet
HLT, 2022, BS, us-gaap:PropertyPlantAndEquipmentNet
HLT, 2022, BS, us-gaap:ContractWithCustomerLiabilityCurrent
HLT, 2022, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
HLT, 2023, BS, us-gaap:FiniteLivedIntangibleAssetsNet
HLT, 2023, BS, us-gaap:PropertyPlantAndEquipmentNet
HLT, 2023, BS, us-gaap:ContractWithCustomerLiabilityCurrent
HLT, 2023, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
HLT, 2024, BS, us-gaap:FiniteLivedIntangibleAssetsNet
HLT, 2024, BS, us-gaap:PropertyPlantAndEquipmentNet
HLT, 2024, BS, us-gaap:ContractWithCustomerLiabilityCurrent
HLT, 2024, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
HLT, 2025, BS, us-gaap:FiniteLivedIntangibleAssetsNet
HLT, 2025, BS, hlt_OtherFiniteLivedIntangibleAssetsNet
HLT, 2025, BS, us-gaap:ContractWithCustomerLiabilityCurrent
HLT, 2025, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
IBM, 2023, BS, us-gaap:OperatingLeaseRightOfUseAsset
IBM, 2023, BS, us-gaap:DefinedBenefitPlanAssetsForPlanBenefitsNoncurrent
IBM, 2023, BS, us-gaap:Goodwill
IBM, 2023, BS, us-gaap:FiniteLivedIntangibleAssetsNet
IBM, 2025, BS, us-gaap:Goodwill
IBM, 2025, BS, us-gaap:FiniteLivedIntangibleAssetsNet
INTU, 2018, IS, us-gaap:CostOfGoodsAndServicesSold
INTU, 2018, IS, us-gaap:SellingAndMarketingExpense
INTU, 2019, IS, us-gaap:CostOfGoodsAndServicesSold
INTU, 2020, IS, us-gaap:CostOfGoodsAndServicesSold
INTU, 2021, IS, us-gaap:CostOfGoodsAndServicesSold
INTU, 2023, IS, us-gaap:CostOfGoodsAndServicesSold
INTU, 2026, IS, us-gaap:CostOfGoodsAndServicesSold
ITT, 2018, BS, us-gaap:MinorityInterest
JKHY, 2016, BS, us-gaap:PropertyPlantAndEquipmentNet
JKHY, 2016, BS, us-gaap:FiniteLivedIntangibleAssetsNet
JKHY, 2016, BS, us-gaap:Goodwill
JKHY, 2017, BS, us-gaap:FiniteLivedIntangibleAssetsNet
JKHY, 2017, BS, us-gaap:Goodwill
JKHY, 2018, BS, us-gaap:FiniteLivedIntangibleAssetsNet
JKHY, 2018, BS, us-gaap:Goodwill
JKHY, 2019, BS, us-gaap:FiniteLivedIntangibleAssetsNet
JKHY, 2019, BS, us-gaap:Goodwill
JKHY, 2020, BS, us-gaap:FiniteLivedIntangibleAssetsNet
JKHY, 2020, BS, us-gaap:Goodwill
JKHY, 2021, BS, us-gaap:FiniteLivedIntangibleAssetsNet
JKHY, 2021, BS, us-gaap:Goodwill
JKHY, 2022, BS, us-gaap:FiniteLivedIntangibleAssetsNet
JKHY, 2022, BS, us-gaap:Goodwill
JKHY, 2023, BS, us-gaap:FiniteLivedIntangibleAssetsNet
JKHY, 2023, BS, us-gaap:Goodwill
JKHY, 2024, BS, us-gaap:FiniteLivedIntangibleAssetsNet
JKHY, 2024, BS, us-gaap:Goodwill
JKHY, 2025, BS, us-gaap:FiniteLivedIntangibleAssetsNet
JKHY, 2025, BS, us-gaap:Goodwill
JKHY, 2026, BS, us-gaap:FiniteLivedIntangibleAssetsNet
LII, 2020, IS, lii_LossgainfromnaturaldisasternetofInsurancerecoveries
LSTR, 2018, IS, lstr_PurchasedTransportationCosts
LSTR, 2018, IS, us-gaap:SalesCommissionsAndFees
LYB, 2023, BS, us-gaap:AccountsReceivableNetCurrent
LYB, 2023, BS, us-gaap:AccountsPayableCurrentAndNoncurrent
LYB, 2024, BS, us-gaap:AccountsReceivableNetCurrent
LYB, 2024, BS, us-gaap:AccountsPayableCurrentAndNoncurrent
LYB, 2025, BS, us-gaap:AccountsReceivableNetCurrent
LYB, 2025, BS, us-gaap:AccountsPayableTradeCurrent
MAR, 2018, BS, us-gaap:ContractWithCustomerLiabilityCurrent
MAR, 2018, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
MAR, 2019, BS, us-gaap:ContractWithCustomerLiabilityCurrent
MAR, 2019, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
MAR, 2020, BS, us-gaap:ContractWithCustomerLiabilityCurrent
MAR, 2020, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
MAR, 2021, BS, us-gaap:ContractWithCustomerLiabilityCurrent
MAR, 2021, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
MAR, 2022, BS, us-gaap:ContractWithCustomerLiabilityCurrent
MAR, 2022, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
MAR, 2022, IS, us-gaap:CostOfRevenue
MAR, 2022, IS, mar_DepreciationAmortizationandOtherExcludingCapitalizedContractCostAmortization
MAR, 2023, BS, us-gaap:ContractWithCustomerLiabilityCurrent
MAR, 2023, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
MAR, 2024, BS, us-gaap:ContractWithCustomerLiabilityCurrent
MAR, 2024, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
MAR, 2025, BS, us-gaap:ContractWithCustomerLiabilityCurrent
MAR, 2025, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
MCD, 2023, BS, us-gaap:Goodwill
MCD, 2023, BS, us-gaap:OperatingLeaseRightOfUseAsset
MCD, 2023, BS, us-gaap:OperatingLeaseLiabilityCurrent
MCD, 2023, BS, us-gaap:OperatingLeaseLiabilityNoncurrent
NOC, 2019, IS, us-gaap:CostOfGoodsAndServicesSold
NOC, 2020, IS, us-gaap:CostOfGoodsAndServicesSold
NOC, 2021, IS, us-gaap:CostOfGoodsAndServicesSold
NOC, 2023, IS, us-gaap:CostOfGoodsAndServicesSold
NOC, 2024, IS, us-gaap:CostOfGoodsAndServicesSold
NOC, 2025, IS, us-gaap:CostOfGoodsAndServicesSold
OTIS, 2020, IS, us-gaap:CostOfGoodsAndServicesSold
OTIS, 2022, IS, us-gaap:CostOfGoodsAndServicesSold
OTIS, 2023, IS, us-gaap:CostOfGoodsAndServicesSold
PEP, 2020, BS, us-gaap:TreasuryStockValue
PFE, 2022, BS, us-gaap:EquityMethodInvestments
PFE, 2022, BS, us-gaap:PropertyPlantAndEquipmentNet
PFE, 2022, BS, us-gaap:OtherAssetsNoncurrent
PFE, 2022, IS, us-gaap:CostOfGoodsAndServicesSold
PFE, 2022, IS, us-gaap:OtherNonoperatingIncomeExpense
PG, 2016, BS, us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax
PG, 2017, BS, us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax
PG, 2018, BS, us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax
PG, 2019, BS, us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax
PG, 2022, BS, us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax
REGN, 2019, IS, us-gaap:CostOfGoodsAndServicesSold
REGN, 2020, BS, us-gaap:AccountsAndNotesReceivableNet
REGN, 2020, BS, us-gaap:ContractWithCustomerLiabilityCurrent
REGN, 2020, BS, us-gaap:ContractWithCustomerLiabilityNoncurrent
REGN, 2020, BS, us-gaap:OtherLiabilitiesNoncurrent
ROL, 2021, BS, us-gaap:IntangibleAssetsNetExcludingGoodwill
ROL, 2022, BS, us-gaap:IntangibleAssetsNetExcludingGoodwill
ROL, 2023, BS, us-gaap:IntangibleAssetsNetExcludingGoodwill
ROL, 2024, BS, us-gaap:IntangibleAssetsNetExcludingGoodwill
RSG, 2015, IS, us-gaap:InterestExpense
RSG, 2015, IS, us-gaap:GainsLossesOnExtinguishmentOfDebt
RTX, 2019, IS, us-gaap:CostOfGoodsAndServicesSold
RTX, 2021, IS, us-gaap:CostOfGoodsAndServicesSold
RTX, 2022, IS, us-gaap:CostOfGoodsAndServicesSold
SLB, 2018, IS, us-gaap:CostOfGoodsAndServicesSold
SLB, 2019, IS, us-gaap:CostOfGoodsAndServicesSold
SLB, 2020, IS, us-gaap:CostOfGoodsAndServicesSold
SLB, 2021, IS, us-gaap:CostOfGoodsAndServicesSold
SLB, 2022, IS, us-gaap:CostOfGoodsAndServicesSold
SLB, 2023, IS, us-gaap:CostOfGoodsAndServicesSold
SLB, 2024, IS, us-gaap:CostOfGoodsAndServicesSold
SLB, 2025, IS, us-gaap:CostOfGoodsAndServicesSold
STE, 2019, IS, us-gaap:CostOfGoodsAndServicesSold
STE, 2020, IS, us-gaap:CostOfGoodsAndServicesSold
STZ, 2024, BS, us-gaap:TreasuryStockCommonValue
STZ, 2025, BS, us-gaap:TreasuryStockCommonValue
STZ, 2026, BS, us-gaap:TreasuryStockCommonValue
TT, 2021, IS, us-gaap:CostOfGoodsAndServicesSold
TT, 2022, IS, us-gaap:CostOfGoodsAndServicesSold
TT, 2023, IS, us-gaap:CostOfGoodsAndServicesSold
TT, 2024, IS, us-gaap:CostOfGoodsAndServicesSold
UPS, 2018, IS, us-gaap:CostOfGoodsAndServicesSold
UPS, 2018, IS, us-gaap:DepreciationAndAmortization
VZ, 2020, IS, us-gaap:CostOfGoodsAndServicesSold
VZ, 2022, IS, us-gaap:CostOfGoodsAndServicesSold
VZ, 2024, IS, us-gaap:CostOfGoodsAndServicesSold
VZ, 2025, IS, us-gaap:CostOfGoodsAndServicesSold
WAT, 2025, IS, us-gaap:CostOfGoodsAndServicesSold
WDAY, 2019, IS, us-gaap:CostOfGoodsAndServicesSold
WDAY, 2020, IS, us-gaap:CostOfGoodsAndServicesSold
WDAY, 2021, IS, us-gaap:CostOfGoodsAndServicesSold
WDAY, 2022, IS, us-gaap:CostOfGoodsAndServicesSold
WDAY, 2023, IS, us-gaap:CostOfGoodsAndServicesSold
WDAY, 2024, IS, us-gaap:CostOfGoodsAndServicesSold
WDAY, 2025, IS, us-gaap:CostOfGoodsAndServicesSold
WDAY, 2025, IS, us-gaap:CostOfGoodsAndServicesSold
WDC, 2023, BS, us-gaap:AccountsPayableCurrent
WDC, 2024, BS, us-gaap:AccountsPayableCurrent
WMB, 2021, BS, us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax
WMB, 2024, BS, us-gaap:RetainedEarningsAccumulatedDeficit
WMB, 2024, BS, us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax
YUM, 2017, BS, us-gaap:CashAndCashEquivalentsAtCarryingValue
YUM, 2017, BS, us-gaap:AccountsNotesAndLoansReceivableNetCurrent
YUM, 2017, BS, us-gaap:InventoryNet
YUM, 2017, BS, yum_PrepaidExpensesAndOtherCurrentAssets
YUM, 2017, BS, yum_AdvertisingCooperativeAssetsRestricted
YUM, 2017, BS, us-gaap:PropertyPlantAndEquipmentNet
YUM, 2017, BS, us-gaap:Goodwill
YUM, 2017, BS, us-gaap:IntangibleAssetsNetExcludingGoodwill
YUM, 2017, BS, us-gaap:OtherAssetsNoncurrent
YUM, 2017, BS, us-gaap:DeferredTaxAssetsNetNoncurrent
YUM, 2017, BS, us-gaap:AccountsPayableAndAccruedLiabilitiesCurrent
YUM, 2017, BS, us-gaap:AccruedIncomeTaxesCurrent
YUM, 2017, BS, yum_AdvertisingCooperativeLiabilities
YUM, 2017, BS, us-gaap:LiabilitiesOtherThanLongtermDebtNoncurrent
YUM, 2017, BS, us-gaap:RetainedEarningsAccumulatedDeficit
YUM, 2017, BS, us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax
YUM, 2018, BS, us-gaap:LiabilitiesOtherThanLongtermDebtNoncurrent
XOM, 2023, BS, us-gaap:PensionAndOtherPostretirementDefinedBenefitPlansLiabilitiesNoncurrent
XOM, 2023, BS, us-gaap:OtherLiabilitiesNoncurrent
XOM, 2024, BS, us-gaap:PensionAndOtherPostretirementDefinedBenefitPlansLiabilitiesNoncurrent
XOM, 2024, BS, us-gaap:OtherLiabilitiesNoncurrent
XOM, 2025, BS, us-gaap:OtherLiabilitiesNoncurrent

[dgunning]

Since releasing 5.7.0 and handling the issues it triggered I have come to the realization that dimension is not the top level flag that maps between what a company displays in their public financials and the underlying breakdown data.

For one Statement Of Equity and Comprehensive Income contain dimensioned concepts important to the public display. Then as you note a lot of companies include dimensioned concepts in their balance sheet.

The North Star I am chasing with the XBRL work is to satisfy 2 use cases

1 . Seeing the financial statement as close to the actual filing as possible. This satisfies uses who look at the SEC Viewer and compare against edgartools
2. Providing the dataframes with all the concepts plus supporting information in columns so sophisticated users can include the data in their pipelines and apply their own logic

For #2 this means show everything dimensions=True
For #1 it's not about dimensions=False. This is what I thought and I no longer do

Face Value and Breakdowns

This idea came up during research - please restate it if unclear - a face value is the top level value of a concept as seen in the presentation. This can be a concept with no dimensions or the axis of a dimension that the other axes roll up into.

Breakdowns are the segments of the dimensions - like region or product

Companies can choose to include

• concept with no dimensions
• concept with dimensions but no breakdowns
• concepts with dimensions and breakdowns

which is what you are finding in your research

So for #1 we need to find the face value of the concept. I think we are missing some logic and I have a plan to use some information from the XBRL presentation file to find it.

[mpreiss9]

I'm not completely certain about your dimensions vs. breakdowns discussion. If I understand what your saying, that's not really the problem I'm seeing. To be as clear as possible, if we look at a company like WDAY or SLB for example, it is impossible to:

1. Produce an Income Statement that correctly adds up if dimensions = False
2. Impossible to find Cost of goods and services sold with dimensions=False
3. Impossible to calculate gross margin with dimensions=False.
   Furthermore, it is extremely difficult to:
4. Create a mathematically correct Income Statement if dimensions = True because it's hard to know which rows to use
5. Determine the correct Cost of goods and services sold if dimensions = True
6. Calculate gross margin if dimensions =True
   Ditto for other concepts and also on the Balance Sheet.

I've been working on this problem using edgartools for several months now and I still find about 10% of filings where my heuristics can't find correct solutions. What's interesting, and cause for optimism, is that the flat files the SEC produces each month (https://www.sec.gov/data-research/sec-markets-data/financial-statement-notes-data-sets) based on the same xbrl data edgartools downloads are much cleaner in this respect. I'm able to produce correct statements in over 99% of cases using these files. So somehow they are able to "decode" the dimensional complexity to produce good data.

[dgunning]

@mpreiss9 Thank you for the extensive research and the detailed list of affected filings. Your work has been invaluable in understanding the scope of this problem.

Good News: Fix Implemented

We've implemented definition linkbase-based dimension filtering that addresses the core issue you identified. The fix will be in v5.7.4 (coming soon - it's merged but not yet released).

What Changed

Instead of treating all dimensions the same, EdgarTools now distinguishes:

• Face dimensions (like ProductOrServiceAxis) → Preserved in default view
• Breakdown dimensions (like StatementGeographicalAxis) → Filtered by default

The classification uses a tiered approach:

1. Definition linkbase (authoritative) - The XBRL filing itself declares valid dimensions
2. Curated axis lists - Known face vs breakdown axes based on empirical analysis
3. Pattern matching - Fallback heuristics

Verified Results

I tested WDAY and SLB with the fix:

WDAY 2025 Income Statement:

Cost of Goods Sold:
  Subscription services    $1,266M  ✓
  Professional services      $803M  ✓

Revenue - OpEx = $8.446B - $8.031B = $0.415B = Operating Income ✓

SLB 2024 Income Statement:

Cost of Goods and Services Sold:
  Product     $10,982M  ✓
  Services    $17,847M  ✓

Both statements now balance correctly.

Your List is Now Our Test Suite

We incorporated many of the companies from your research into our regression tests:

• Income Statement: BA, CARR, GD, HII, INTU, NOC, RTX, SLB, WDAY
• Balance Sheet Goodwill: BSX, IBM, JKHY
• Balance Sheet PPE: BSX, CSX, HLT

Documentation

I've written comprehensive documentation explaining how dimension handling works:

• Understanding Dimensions in Financial Statements - User guide with examples from your research

One Remaining UX Issue

You may notice that "total" rows sometimes show NaN when only dimensional values exist:

COGS rows:
  Total COGS                 NaN      ← No non-dimensional value in XBRL
  Subscription services   $1,266M    ← Dimensional (preserved)
  Professional services     $803M    ← Dimensional (preserved)

The values ARE there - you just need to sum them for the total. We're considering auto-calculating these totals in a future release.

Your Insight About SEC Flat Files

You mentioned the SEC Financial Statement Data Sets produce correct statements in 99%+ of cases. This is great validation that the problem IS solvable. I'm working on using these to validate.

Next Steps

1. v5.7.4 release - The fix will be published soon
2. Testing - Please try the fix when released and let us know if you find cases that still don't work
3. Expanding coverage - Your comprehensive list helps us identify gaps

Thank you again for the detailed research. This kind of community contribution makes EdgarTools better for everyone.

---

Note: This fix addresses the dimensional face value problem. Statement of Equity matrix rendering (GH-572) is a separate issue being tracked for v5.8.0.

[dgunning]

Sorry, closed accidentally.

Also can you comment on https://github.com/dgunning/edgartools/blob/main/docs/xbrl/statement-view-plan.md

[mpreiss9]

this looks very promising - I can't wait to get my hands on this release!

[dgunning]

Fixed in v5.7.4 - Implemented definition linkbase-based dimension filtering

[mpreiss9]

Out of curiosity, are you going to be making this available through the xbrl.current_period path? If not, I will need to rewrite my calls to parse out the current period myself - not terrible but wasted effort if you're going to implement on xbrl.current_period anyway.