How Negative Entries Affect Federal Oil and Gas Royalty Totals American Mineral Registry Research Evidence scope: ONRR fiscal-year data, Federal oil and gas royalties, FY 2004 through FY 2026. Suggested citation Removing negative entries would overstate ONRR’s FY 2014 federal oil and gas royalties by $195.79 million, the largest dollar difference from FY 2004 through FY 2026. https://americanmineralregistry.com/research/negative-federal-oil-gas-royalty-records#key-takeaways Individual findings Removing negative entries would overstate ONRR’s FY 2014 federal oil and gas royalties by $195.79 million, the largest dollar difference from FY 2004 through FY 2026. The comparison holds all other ONRR source filters fixed. Study scope: ONRR fiscal-year data, Federal oil and gas royalties, FY 2004 through FY 2026. https://americanmineralregistry.com/research/negative-federal-oil-gas-royalty-records#largest-dollar-gap The largest proportional overstatement would be 2.7% of net royalties in FY 2016. This divides the magnitude of negative rows by the signed total, not the nonnegative subtotal. Study scope: ONRR fiscal-year data, Federal oil and gas royalties, FY 2004 through FY 2026. https://americanmineralregistry.com/research/negative-federal-oil-gas-royalty-records#largest-relative-gap ONRR’s FY 2026 federal oil and gas royalty file contains 62 negative rows in the selected subset, totaling negative $9.40 million. Rows are published data groupings. They do not identify or count individual payment transactions. Study scope: ONRR fiscal-year data, Federal oil and gas royalties, FY 2004 through FY 2026. https://americanmineralregistry.com/research/negative-federal-oil-gas-royalty-records#negative-rows-latest Across FY 2004 through FY 2026, dropping negative entries would add $1.41 billion to ONRR’s signed federal oil and gas royalty total of $208.71 billion, an overstatement of 0.68%. AMR sums the negative-entry gaps over all 23 years and divides by the sum of signed annual totals, using nominal dollars. Study scope: ONRR fiscal-year data, Federal oil and gas royalties, FY 2004 through FY 2026. https://americanmineralregistry.com/research/negative-federal-oil-gas-royalty-records#signed-aggregate-gap The five largest annual omission gaps account for 55.4% of the total negative-entry magnitude across FY 2004 through FY 2026. The five years contribute $781.10 million of $1.41 billion in total omitted amounts. Study scope: ONRR fiscal-year data, Federal oil and gas royalties, FY 2004 through FY 2026. https://americanmineralregistry.com/research/negative-federal-oil-gas-royalty-records#signed-top-five-concentration Dropping negative entries changes the rank of only two years in ONRR’s 23-year federal oil and gas royalty series. FY 2015 and FY 2018 swap 16th and 17th place. The comparison ranks the same years by signed nominal total and by nonnegative subtotal, with the largest value ranked first. Study scope: ONRR fiscal-year data, Federal oil and gas royalties, FY 2004 through FY 2026. https://americanmineralregistry.com/research/negative-federal-oil-gas-royalty-records#signed-ranking-swap In 15 of 23 fiscal years, omitting negative entries would raise the federal oil and gas royalty total by less than 1% of its signed value. The median annual percentage gap was 0.34%, giving each fiscal year equal weight. Study scope: ONRR fiscal-year data, Federal oil and gas royalties, FY 2004 through FY 2026. https://americanmineralregistry.com/research/negative-federal-oil-gas-royalty-records#signed-typical-year FY 2020 had the most negative published federal oil and gas royalty rows in ONRR’s FY 2004 through FY 2026 series, 95 of 1,205, or 7.88%. The greatest negative dollar subtotal occurred in FY 2014. The count and share use published fiscal-year rows. The dollar comparison uses the magnitude of the signed negative subtotal. Study scope: ONRR fiscal-year data, Federal oil and gas royalties, FY 2004 through FY 2026. https://americanmineralregistry.com/research/negative-federal-oil-gas-royalty-records#evidence-signed-frequency-peak ONRR recorded 57 negative federal oil and gas royalty rows in both FY 2006 and FY 2013, yet the negative subtotal magnitude was $292,156.50 in FY 2006 and $138,740,738.46 in FY 2013. Identical counts of published rows corresponded to very different dollar magnitudes. The rows are public aggregates. Study scope: ONRR fiscal-year data, Federal oil and gas royalties, FY 2004 through FY 2026. https://americanmineralregistry.com/research/negative-federal-oil-gas-royalty-records#evidence-signed-matched-frequency Primary sources ONRR original fiscal-year natural resource revenue CSV: https://revenuedata.onrr.gov/downloads/fiscal_year_revenue.csv Department of the Interior coverage and metadata: https://catalog.data.gov/dataset/fiscal-year-revenue-of-u-s-natural-resources ONRR revenue downloads and field definitions: https://revenuedata.onrr.gov/downloads/revenue/#data-dictionary DOI monthly natural resource revenue catalog: https://catalog.data.gov/dataset/monthly-revenue-of-u-s-natural-resources DOI calendar-year natural resource revenue catalog: https://catalog.data.gov/dataset/calendar-year-revenue-of-u-s-natural-resources DOI fiscal-year natural resource disbursements catalog: https://catalog.data.gov/dataset/fiscal-year-disbursements-of-u-s-natural-resources-revenue GAO federal oil and gas adjustments and refunds study: https://files.gao.gov/reports/GAO-26-107669/index.html Credit American Mineral Registry for the analysis and cite the primary source for its original figures. AMR analysis and original figures: CC BY 4.0, https://creativecommons.org/licenses/by/4.0/