Converting Monthly Royalty History Into a Valuation Baseline

Direct answer

Build a royalty-history valuation baseline by entering each statement line under the correct production month, property, well or lease, and product; preserving the reported volume, price, owner decimal, taxes, deductions, adjustments, and net payment; and documenting missing or corrected periods. The result is historical owner cash-flow evidence, not a forecast or a complete mineral valuation.

Key takeaways

• Use the production month as the primary time axis. Statement dates and check dates can lag production and can combine more than one property, product, or accounting period.
• Preserve the statement components instead of recording only the check total. A similar net payment can arise from different combinations of volume, price, decimal interest, taxes, deductions, and adjustments.
• Keep reported history separate from normalized history. Every exclusion, correction, reclassification, or one-time adjustment needs a source and an explanation.
• Public production and benchmark-price data can provide context, but they do not prove title, the owner decimal, private contract pricing, deductions, or future cash flow.

This article provides general owner education. It does not provide a professional valuation opinion, title opinion, reserve report, engineering forecast, audit conclusion, or individualized legal, tax, accounting, or investment guidance. MRX may have an economic interest in a mineral transaction. An owner-specific conclusion requires the controlling documents, complete statement history, property records, and qualified professional review.

Answer first

Convert monthly royalty history into a valuation baseline by rebuilding the history at the statement-line level, using production month as the primary time axis and keeping volume, price, owner decimal, taxes, deductions, adjustments, and net payment in separate fields. Preserve the original statements, document every gap or correction, and summarize only comparable periods.

That baseline answers a narrow but important question: what cash-flow evidence did this owner actually receive from identified properties and production periods? It does not, by itself, answer what the minerals are worth today or what future checks will be.

The distinction matters because the same check amount can result from very different facts. Production may rise while the realized price falls. A payment may include several properties, a suspense release, a prior-period correction, or a changed decimal interest. Recording only the deposit total hides those differences.

What a royalty-history baseline is

A royalty-history baseline is a documented record of historical owner revenue, not a forecast. It connects each payment component to the best available source:

• the payor and owner account;
• the property, lease, well, or unit identifier shown on the statement;
• the product reported, such as oil, gas, condensate, or plant products;
• the production month;
• the gross volume and price reported;
• the owner’s decimal interest;
• gross owner value;
• taxes and itemized deductions;
• adjustments, reversals, or suspense releases; and
• the resulting net payment.

Texas law provides a useful field checklist. Texas Natural Resources Code Section 91.502 requires a payor, unless otherwise agreed, to provide specified information on a check stub, attachment, or other remittance advice. The listed information includes the lease, property, or well identification; the month and year of sales; total volumes; price; total amount attributed to the payment; taxes; other deductions; net value; and the owner’s fractional interest expressed as a decimal. The statute controls the legal requirement; an owner’s worksheet should preserve whatever the actual statement reports and mark missing or unclear fields for follow-up.

This creates a better foundation than a folder of check totals because each monthly result remains traceable to the underlying statement.

Do not confuse three different dates

Royalty records commonly contain at least three dates:

1. Production month: when the oil or gas was produced or sold for statement purposes.
2. Statement month: when the payor prepared the remittance detail.
3. Payment date: when the check, ACH, or other payment was issued or received.

Use production month for the analytical series. Keep statement month and payment date in their own columns for reconciliation.

The payment date is not a reliable substitute for production month. Payment timing depends on the governing documents, sales, title information, statutory rules, minimum-payment provisions, suspense, and payor processing. Texas Natural Resources Code Section 91.402 addresses time for payment of oil and gas proceeds and identifies circumstances that can affect payment. It should not be reduced to a universal owner-calendar rule without reviewing the facts and controlling documents.

If one check covers several production months, enter each statement line under its stated production month. If the statement does not support an allocation, preserve the combined amount as unresolved rather than inventing monthly values.

Build the monthly royalty history worksheet

Create one row for each unique combination of payor, owner account, property or well, product, production month, and statement line. Retain a link or filename for the source document.

Identity fields

Record the payor, owner number, statement date, payment reference, property name, property number, lease number, well identifier, county, state, and product code exactly as reported. Keep internal account numbers private; do not place unredacted statements in a shared valuation package.

Do not merge records merely because the property names look similar. Payors can abbreviate or change names, and multiple wells or products can appear under one property. Build an alias note only after identifiers support the match.

Quantity and price fields

Preserve the reported gross volume, unit of measure, and realized price for each product. Do not add oil barrels to gas volumes or combine product prices into a single average. If a statement provides both gross and allocated volume, label each field precisely.

The U.S. Energy Information Administration publishes dated petroleum data and natural-gas data, including historical price series. Those series can help describe broad market context. A benchmark is not necessarily the price realized at a particular property: quality, location, basis, transportation, contract terms, processing, timing, and product mix can create differences.

Ownership and value fields

Enter the owner decimal exactly as shown for each line. Preserve gross owner value, taxes, deductions, adjustments, and net value separately.

A changing decimal is a review flag, not automatic proof of error. It may reflect a title update, division-order change, unit or allocation change, transfer, correction, payor-system change, or a different property or product line. Compare the statement with deeds, leases, amendments, pooling or unit documents, division orders, and owner correspondence before reaching a conclusion.

Adjustment fields

Give adjustments their own rows or clearly linked columns. Identify whether the entry is a reversal, rebooking, prior-period price correction, volume correction, tax adjustment, deduction adjustment, suspense release, recoupment, or another stated category.

Never replace the original month with the corrected result and discard the audit trail. Preserve the as-paid record, the correcting entry, the resulting restated amount if it can be supported, and the source for each change.

Reconcile payments without overstating what public data proves

The Railroad Commission of Texas publishes production data compiled from information reported by Texas operators. It includes monthly production resources and query tools. The Commission also provides downloadable oil and gas data sets for broader research.

Use those records as a reasonableness check when the identifiers and reporting levels align. For example, a worksheet can compare whether the statement and public record point to activity in the same production period or whether an apparent gap deserves further investigation.

Do not treat a public-production match as proof of the owner’s payment. Public data generally does not establish:

• the owner’s title or decimal interest;
• the private sales contract or realized property price;
• the payor’s allocation among products or owners;
• lease-specific deduction rights;
• every adjustment, tax treatment, or suspense event; or
• the amount legally due to a particular owner.

Reporting can also be amended. Record the date on which public data was retrieved and preserve the version or query result used. If a later report changes, document the difference rather than silently updating the worksheet.

Separate recurring history from one-time activity

Before calculating averages, classify each entry as recurring production revenue, a timing shift, or an unusual item. Common review flags include:

• a first payment that includes several production months;
• a suspense release or accumulated minimum-payment balance;
• a correction affecting an earlier period;
• a sale or transfer that changes the ownership period;
• a changed decimal interest;
• a property added to or removed from the statement;
• a shut-in, workover, curtailment, weather event, or other downtime;
• a new well or newly reported product stream;
• a tax or deduction change; and
• a payor or operator change.

An unusual item should not automatically be deleted. Keep the reported history intact, then create a separate normalized view with a written reason for any reclassification or exclusion.

Taxes and deductions deserve separate treatment. The Texas Comptroller’s current crude oil production tax and natural gas production tax resources explain state tax administration, rates, exemptions, fees, and filing context. They do not determine how every payor should present an individual owner’s statement or how an owner should report taxes. Preserve the amount and label shown, note exemptions or adjustments when supported, and send tax questions to a qualified adviser.

Calculate summaries only after the data is clean

Once the line-level history is complete enough to use, calculate several transparent summaries rather than one unexplained average:

• total and average net payment for each clearly defined trailing period;
• median monthly net payment, with the months included identified;
• gross owner value, taxes, deductions, adjustments, and net value by period;
• product-specific volume and revenue trends;
• property- or well-specific contributions;
• months with no statement, zero production, or unresolved data; and
• year-over-year or comparable-period changes where the underlying properties are consistent.

There is no universal lookback period that fits every mineral interest. A shorter trailing window may better reflect the current well set and price environment but can overstate or understate recurring results after a disruption, correction, or new-well flush production. A longer window can reveal cycles and changes but may include properties, decimals, products, or market conditions that no longer match the current interest.

Label each summary with its beginning and ending production months, included properties, treatment of adjustments, and unresolved gaps. Keep the raw history beside the normalized view so another reviewer can reproduce the result.

Why historical cash flow is not future value

Historical royalty payments are an important input when the interest is producing, but a trailing total is not a valuation formula.

The Texas Comptroller’s Manual for Discounting Oil and Gas Income discusses income analysis for Texas property-tax appraisal, including production, price, expenses, taxes, decline, remaining reserves, discounting, and risk. That manual serves a specific statutory appraisal context; it is not a private-sale pricing rule. Its broader lesson is still useful: future economic analysis requires more than multiplying a recent check by a fixed number.

A current valuation review may need to address:

• what interest and depths the owner actually owns;
• current lease terms and effective royalty burden;
• producing wells and their product-specific histories;
• supported decline behavior and remaining reserves;
• realized prices, basis, quality, processing, and transportation;
• taxes and permitted deductions;
• operating, title, counterparty, timing, and concentration risk;
• existing-well cash flow separately from unproved future development; and
• the valuation date, method, and discount assumptions.

Future locations, permits, offset activity, operator plans, commodity forecasts, or hoped-for title resolution should remain separate scenarios unless supported. The monthly baseline establishes historical evidence. It does not turn uncertainty into a promise.

A practical owner workflow

Use this sequence to make the history reviewable:

1. Gather every available statement, check record, deposit record, division order, lease, amendment, deed, tax form, and owner notice.
2. Inventory the files by payor, owner account, property, payment date, and statement period without changing the originals.
3. Enter each statement line in the worksheet under its production month and product.
4. Preserve the reported decimal, volume, price, taxes, deductions, adjustments, and net value in separate fields.
5. Flag gaps, duplicates, combined periods, changed identifiers, unusual items, and unresolved allocations.
6. Reconcile totals to payments and compare public production or price data only for appropriate context.
7. Create a normalized view with a written source and reason for every change from the reported history.
8. Calculate clearly labeled trailing and comparable-period summaries.
9. Keep historical results separate from future production, price, development, and risk assumptions.
10. Have the controlling documents and high-impact discrepancies reviewed by the appropriate land, legal, accounting, tax, engineering, or valuation professional.

This workflow makes a future conversation more efficient. Instead of handing a reviewer a stack of checks, the owner can show what was paid, for which production period and property, which fields support the result, and which questions remain unresolved.

When to investigate further

Escalate rather than guessing when the worksheet shows:

• a decimal change without a supporting document or explanation;
• repeated missing production months for an otherwise active property;
• a payor, property, lease, or well identifier that cannot be matched;
• material adjustments that cannot be traced to an earlier line;
• deductions that are not described clearly enough to classify;
• a difference between statement and public-production timing that persists after checking identifiers and reporting levels;
• a title transfer, probate, trust, entity, or depth issue; or
• conflicting statements, division orders, leases, deeds, or owner correspondence.

A discrepancy is a reason to gather evidence, not proof of underpayment or wrongdoing. The correct reviewer depends on the issue: the payor or operator for statement detail, a land professional for ownership research, an attorney for legal rights, an accountant or tax professional for reporting, and a petroleum engineer or valuation professional for technical or economic analysis.

The decision-ready baseline

A decision-ready royalty history has four qualities:

1. Traceable: every amount points to a retained source statement.
2. Comparable: properties, products, production months, and ownership periods are not mixed without explanation.
3. Reproducible: another reviewer can follow each adjustment from the raw record to the normalized view.
4. Bounded: the worksheet states what the history proves and what it does not.

That is the right role for a monthly royalty history valuation baseline. It converts scattered payment records into organized historical evidence while preserving the distinction between past owner cash flow and a supported opinion about future value.

If you want help organizing the property and statement record for a review, book a conversation with MRX. Bring unaltered source files and redact sensitive account information before sharing documents electronically.

---

MineralRightsXchange provides educational information, not legal, tax, accounting, engineering, investment, or valuation advice. Mineral ownership, payment rights, production reporting, deductions, taxes, and value depend on the controlling instruments, title, jurisdiction, property facts, market conditions, and review date. MRX may benefit economically from a mineral transaction. Consult qualified professionals for decisions involving your specific property.

Frequently asked questions

How many months of royalty history should I use?

Use the complete reliable history available, then label the periods included in each summary. A shorter window may reflect current conditions but miss seasonality, downtime, corrections, or price cycles. A longer window provides context but may include wells, decimals, prices, or deductions that no longer represent the current interest.

Should I organize statements by check date or production month?

Use production month as the primary analytical time axis, while retaining statement date and payment date as separate fields. Payments often lag production, and one check can contain multiple production months, properties, wells, or products.

Can I use the check total as monthly royalty income?

Not without reading the detail. A check can combine multiple properties and products and can include prior-period adjustments, reversals, taxes, deductions, suspense releases, or minimum-payment accumulation. Allocate only when the statement provides support.

Can Railroad Commission production data verify my royalty payment?

It can help compare operator-reported production by lease, well, field, county, or period where identifiers align. It does not prove ownership, title, the owner decimal, private price terms, all deductions, payor accounting, or the amount due to a particular owner.

Does a trailing royalty average determine mineral rights value?

No. A trailing average describes selected historical net payments. A valuation may also require title and lease review, product-specific production and price assumptions, decline analysis, reserves or development evidence, costs and deductions, taxes, risk, timing, and an appropriate valuation method.

Sources

• Texas Natural Resources Code Chapter 91, including Sections 91.402 and 91.502 (accessed 2026-08-11)
• Railroad Commission of Texas production data (accessed 2026-08-11)
• Railroad Commission of Texas downloadable oil and gas data sets (accessed 2026-08-11)
• Texas Comptroller Manual for Discounting Oil and Gas Income (accessed 2026-08-11)
• Texas Comptroller crude oil production tax (accessed 2026-08-11)
• Texas Comptroller natural gas production tax (accessed 2026-08-11)
• U.S. Energy Information Administration petroleum and other liquids data (accessed 2026-08-11)
• U.S. Energy Information Administration natural gas data (accessed 2026-08-11)