#Getting Paid Correctly Should Not Be This Hard
Royalty reconciliation is the process of verifying that the payments you receive from operators actually match what you are owed. In principle, it is straightforward: compare what was paid against what should have been paid based on production volumes, commodity prices, your net revenue interest, and the terms of your lease. In practice, it is one of the most time-consuming and error-prone tasks in oil and gas revenue management.
The challenge is not conceptual. The challenge is operational. Royalty statements arrive in different formats from different operators on different schedules. Production data lives in state commission databases that require manual lookups. Pricing benchmarks are published by multiple index services with varying methodologies. Lease terms differ from property to property. And every month, the entire exercise must be repeated for every well in your portfolio.
For decades, mineral owners and revenue managers have relied on spreadsheets, paper check stubs, and institutional knowledge to reconcile their royalty payments. That approach works — up to a point. This article compares manual and automated reconciliation processes, outlines best practices that apply regardless of your method, and offers guidance on when each approach makes sense.
#The Manual Reconciliation Process
Manual reconciliation is the baseline. It is how most individual mineral owners and smaller revenue teams have historically verified their payments, and it remains the default for organizations that have not invested in dedicated reconciliation technology.
The typical workflow looks like this:
Step 1: Collect check stubs. Royalty statements arrive as paper mail, PDF attachments, or downloads from operator portals. Each operator formats its statements differently — some provide granular well-level detail with separate lines for oil, gas, and NGL revenue, while others present a single lump-sum payment with minimal breakdown.
Step 2: Enter data into spreadsheets. The relevant figures from each check stub — production volumes, prices, deductions, net revenue interest, and payment amounts — must be manually keyed into a tracking spreadsheet. For mineral owners with interests across multiple operators, this step alone can consume hours each month.
Step 3: Pull production data from state regulatory sources. To verify the volumes reported on your statement, you need to cross-reference them against production filings with the relevant state commission. In Texas, that means querying the Railroad Commission. In Oklahoma, the Corporation Commission. In New Mexico, the Oil Conservation Division. Each state has its own portal, its own data format, and its own reporting lag. For a deeper look at how to use state production data in your audit process, see our guide on production volume verification using state regulatory data.
Step 4: Look up pricing benchmarks. To verify that the price applied to your production is reasonable, you need to pull published index prices — WTI or regional postings for crude oil, Henry Hub or basin-specific hubs for natural gas, Mont Belvieu or Conway for NGLs — and compare them against what appears on your statement. This requires accounting for basis differentials, gravity adjustments, and BTU factors that vary by basin and by product.
Step 5: Calculate expected payments. With verified volumes and benchmark prices in hand, you apply your net revenue interest and any permissible deductions to compute what you should have received. This calculation must be performed line by line, well by well, product by product.
Step 6: Compare actual versus expected. The variance between your calculated expected payment and the amount actually received is the signal you are looking for. A positive variance means you were underpaid; a negative variance means you received more than expected (which can happen with pricing lags or true-up adjustments).
Step 7: Document discrepancies and follow up. When variances exceed an acceptable threshold, you document the issue, draft an inquiry to the operator, and track the resolution. This follow-up process can take weeks or months, especially when the operator's revenue department is backlogged.
#The Pain Points of Manual Reconciliation
The manual process is thorough when executed diligently, but it has fundamental limitations.
Time. Industry estimates suggest that thorough manual reconciliation takes 15 to 30 minutes per well per month. For a portfolio of 200 wells, that translates to 50 to 100 hours of reconciliation work every month — more than a full-time job just for payment verification.
Error rates. Manual data entry introduces its own errors. Transposed digits, miskeyed decimals, and copy-paste mistakes can create phantom discrepancies or mask real ones. The irony of manual reconciliation is that the process designed to catch errors is itself error-prone.
Scalability. The manual approach works tolerably well for a handful of wells. It becomes impractical at scale. Revenue teams managing hundreds or thousands of interests simply cannot maintain the same rigor across every well every month, so they prioritize — and the wells that do not get scrutinized are the ones where errors persist undetected.
Institutional knowledge dependency. When the person who built the spreadsheet and knows the operator quirks leaves the organization, much of the reconciliation capability leaves with them. Manual processes rarely have adequate documentation, and training a replacement takes months.
#The Automated Reconciliation Process
Automated reconciliation follows the same logical steps as the manual process, but it replaces human data entry and lookup with software-driven ingestion, computation, and exception flagging.
Data ingestion. Automated systems ingest royalty statements through multiple channels. Optical character recognition (OCR) extracts structured data from PDF check stubs. Electronic data interchange (EDI) connections receive data directly from operators that support electronic remittance. Operator portal integrations pull statements automatically on a scheduled basis.
Production data retrieval. Rather than manually querying state commission websites, an automated system connects to state regulatory databases and APIs to pull production data for every well in your portfolio. This data is standardized across states, matched to your interests, and updated as new filings become available.
Pricing benchmarks. Published commodity indices — WTI, Henry Hub, regional basis differentials, NGL component prices — are fetched automatically from pricing services and applied to each production month based on the relevant product, basin, and delivery point.
Calculation engine. The system applies your net revenue interest, lease-specific deduction rules, and contractual terms to compute an expected payment for every well, every product, and every month. These calculations are consistent and repeatable — the same formula is applied every time, with no risk of a miskeyed cell reference.
Variance detection and exception reporting. Differences between actual and expected payments are flagged automatically, categorized by root cause (volume variance, price variance, deduction variance, interest variance), and prioritized by dollar impact. Exception reports surface the issues that matter most, rather than requiring you to scan rows of spreadsheet data looking for outliers.
Resolution workflow. Flagged discrepancies flow into a structured resolution workflow with status tracking, communication templates, and audit trail logging. Every inquiry, response, and resolution is documented — not in an email thread that someone has to search for later, but in a persistent record attached to the specific well and production month.
#The Benefits of Automation
Scale. An automated system reconciles a thousand wells with the same effort it takes to reconcile ten. The marginal cost of adding another well to your portfolio is negligible.
Consistency. Every well is reconciled using the same methodology every month. There are no wells that "fell through the cracks" because someone was on vacation or the spreadsheet formula broke.
Speed of detection. Automated reconciliation identifies discrepancies within days of receiving a statement, rather than weeks or months into a manual review cycle. Earlier detection means faster resolution — and in many states, it means catching errors before statutes of limitation on recovery claims begin to shorten your options.
Audit trail. Every data point, calculation, and decision is logged. When you need to demonstrate to an operator, an auditor, or a court exactly how you identified a discrepancy and what steps you took, the record is there.
#Best Practices Regardless of Approach
Whether you reconcile manually or use automated tools, certain disciplines separate organizations that catch errors from those that do not.
Reconcile monthly. Do not let errors accumulate. A pricing discrepancy that persists for six months before anyone notices is six months of lost revenue that may or may not be recoverable. Monthly reconciliation is the minimum cadence for any serious revenue verification effort.
Establish variance thresholds. Not every variance warrants investigation. Define clear thresholds: flag anything above 5% for investigation, review variances between 2% and 5% on a quarterly basis, and auto-approve variances below 2%. These thresholds should be calibrated to your portfolio — for high-value wells, even a 1% variance can represent significant dollars.
Track variances by category. A volume variance and a price variance have entirely different root causes and require different resolution approaches. Separate your analysis into at least four categories: volume variances (production quantity discrepancies), price variances (differences between realized and benchmark pricing), deduction variances (unexpected or excessive post-production charges), and interest variances (incorrect NRI or decimal errors). For more on how to detect and investigate the most common category — underpayments — see our royalty underpayment detection guide.
Maintain a resolution log. Every inquiry you send to an operator and every response you receive should be documented with dates, reference numbers, and outcomes. This log serves three purposes: it prevents duplicate inquiries, it creates a paper trail for potential legal action, and it allows you to measure how responsive each operator is over time.
Benchmark operator accuracy over time. Track each operator's error rate and average variance across months. An operator that consistently pays within 1% of expected is performing well. An operator that regularly shows 5% or greater variances may have a systemic issue — or may simply not prioritize accuracy. Either way, the trend data informs how much audit attention each operator deserves.
Prioritize by value. Audit effort should be proportional to revenue at stake. A 10% variance on a well producing 5 barrels per day is a smaller dollar issue than a 2% variance on a well producing 500 barrels per day. Prioritize your reconciliation queue by gross revenue, not by percentage variance alone.
Cross-reference multiple data sources. Never rely solely on the operator's data. State production filings, published pricing indices, and publicly available well completion data provide independent verification points that can reveal discrepancies the operator's own records would not surface.
#When Manual Reconciliation Makes Sense
Manual reconciliation is not obsolete. There are scenarios where it remains the right approach.
Very small portfolios. If you own interests in fewer than 10 wells, the overhead of implementing and maintaining an automated system may not be justified. A well-structured spreadsheet, updated diligently each month, can provide adequate verification.
One-time audits or spot checks. If you suspect a specific problem with a specific well or operator, a targeted manual review of the relevant statements and production data may be more efficient than onboarding an entire portfolio into an automated platform.
Complex situations requiring judgment. Title disputes, pending probate actions, contested pooling orders, and other legal or factual complexities sometimes require human interpretation that automated systems are not designed to handle. In these cases, manual analysis by someone who understands the specific facts is essential.
#When Automation Is Essential
The calculus shifts decisively toward automation as portfolio size and complexity increase.
Portfolios above 50 wells. At this scale, manual reconciliation either consumes an unreasonable amount of staff time or — more commonly — it simply does not get done consistently. Automation is the only way to maintain thorough, monthly reconciliation across a portfolio of this size.
Multi-state, multi-operator interests. When your portfolio spans multiple producing states with different regulatory agencies, reporting formats, and legal frameworks, and when you receive statements from dozens of different operators, the data management burden alone overwhelms manual processes.
Organizations with fiduciary obligations. Trusts, estates, investment funds, and other entities with fiduciary duties to beneficiaries or investors cannot afford the inconsistency of manual reconciliation. An automated system with a documented methodology and a complete audit trail demonstrates the kind of systematic oversight that fiduciary duty demands.
When speed of detection matters. State statutes of limitation on royalty underpayment claims vary, but they all have deadlines. The sooner you identify a discrepancy, the more historical production months you can potentially recover. Automated systems that flag issues within days of statement receipt give you the maximum window for recovery.
High-value wells. When a single well generates tens or hundreds of thousands of dollars in monthly revenue, even small percentage errors translate to large dollar amounts. The cost of automated reconciliation is trivial compared to the revenue at risk.
#The Hybrid Approach: Where Most Mature Organizations Land
In practice, the most effective reconciliation programs are neither purely manual nor purely automated. They are hybrid.
The automated system handles the heavy lifting: ingesting data from multiple sources, normalizing it into a consistent format, running calculations across the entire portfolio, and surfacing exceptions that warrant human attention. This is where automation excels — repetitive, data-intensive work that must be performed consistently at scale.
The human team handles what automation cannot: interpreting ambiguous lease language, exercising judgment on borderline variances, communicating with operator revenue departments, and making strategic decisions about which discrepancies to escalate and how aggressively to pursue them. Experienced revenue professionals bring contextual knowledge — about specific operators, specific basins, and specific legal frameworks — that no algorithm fully replaces.
The hybrid approach works because it plays to each side's strengths. Automation eliminates the drudgery and ensures nothing falls through the cracks. Human expertise ensures that the exceptions flagged by the system are resolved intelligently and that the relationships with operators are managed with appropriate nuance.
#Related Reading
- Automated Royalty Reconciliation ROI
- Cost of Manual Royalty Accounting
- A 5-Point Manual Reconciliation Checklist
#Reconciliation Is a Discipline, Not a Project
The most important best practice is the simplest one: reconciliation must be ongoing. It is not an annual audit or a one-time cleanup. It is a monthly discipline that compounds in value over time. Every month you reconcile, you catch errors earlier, you build a more complete picture of each operator's accuracy, and you strengthen your position if you ever need to pursue a formal claim.
Whether you execute that discipline with spreadsheets, with software, or with some combination of both, the key is consistency. The mineral owners and revenue teams who protect their income are the ones who verify it — every well, every month, without exception.
AGR's reconciliation platform implements the hybrid approach described in this article. It automates data ingestion, calculation, and exception flagging across your entire portfolio, while giving your team the tools to manage resolution workflows, track operator communications, and maintain a complete audit trail. The result is thorough, consistent reconciliation that scales with your portfolio and surfaces issues in days rather than months.