#The True Cost of "Good Enough"
Manual royalty accounting has been the default for decades, and for many organizations it still works. There is nothing inherently wrong with a well-managed manual process.
But the operating environment is changing. Portfolios grow through acquisition. Regulatory requirements tighten. Audit look-back periods stretch further. The analyst who built the master spreadsheet moves on. And at some point, the hidden costs of spreadsheet-based royalty accounting begin to exceed what anyone budgeted for.
This post breaks down those costs honestly — not to sell you on software, but to give you a framework for evaluating whether your current approach is still the most cost-effective one. We use real salary data, real penalty schedules, and conservative assumptions throughout.
#Direct Labor Costs
The most visible cost of manual royalty accounting is the people who do it. Revenue accountants and analysts in the oil and gas sector typically earn base salaries in the range of $55,000 to $85,000 per year, depending on geographic market, experience level, and portfolio complexity. In energy hubs like Houston, Midland-Odessa, and Oklahoma City, compensation tends to run toward the higher end of that range. The Bureau of Labor Statistics reports a median annual salary of approximately $95,000 for financial analysts as of its most recent Occupational Employment and Wage Statistics data (May 2023), and oil and gas revenue specialists in major producing regions may exceed that figure.
But base salary is only part of the picture. Once you factor in employer-paid benefits (health insurance, retirement contributions), payroll taxes (FICA, FUTA, state unemployment), office space, IT infrastructure, and general overhead, the fully loaded cost of an employee typically runs 1.3 to 1.5 times their base salary. That puts the all-in annual cost of a single revenue analyst at roughly $72,000 to $128,000, depending on market and benefits package.
Staffing ratios vary significantly based on how many operators are involved, the complexity of the interest types, and whether the organization handles its own suspense and escheatment. A commonly cited benchmark is one analyst per 100 to 300 wells for monthly reconciliation and payment processing. An organization with 500 wells might need two to five dedicated staff members, representing $144,000 to $640,000 in annual labor cost before considering management oversight, IT support, or outside accounting and legal resources.
These are real, necessary costs regardless of whether the work is done manually or with software. The question is not whether you need people — you do — but whether those people are spending their time on the highest-value activities.
#The Spreadsheet Tax
Spreadsheets are powerful, flexible tools. They are also the source of a significant hidden tax on productivity and accuracy in royalty accounting workflows.
Data entry and formatting consume disproportionate time. In a typical manual workflow, analysts spend the bulk of their month pulling data from operator portals, reformatting it, copying figures between workbooks, and reconciling across tabs. Industry surveys and our conversations with revenue teams suggest that 70% to 80% of analyst time goes to data gathering and formatting — leaving only 20% to 30% for the analytical work that catches errors and recovers revenue.
Version control is a persistent problem. When multiple people touch the same spreadsheets — or when one person maintains multiple versions for different time periods or operators — determining which file contains the authoritative numbers becomes genuinely difficult. The question "which spreadsheet is the latest?" is a daily source of friction in most revenue offices.
Formula errors are far more common than most people assume. Research by Ray Panko, a professor at the University of Hawaii and a leading figure in the European Spreadsheet Risks Interest Group (EuSpRIG), has found that approximately 88% of spreadsheets contain at least one error. That statistic, drawn from multiple audits of real-world spreadsheets across industries, is one of the most widely cited findings in spreadsheet risk research. Not every error is material, but in royalty accounting, even a small formula error in an allocation calculation can propagate across hundreds of interest owners and multiple months before anyone catches it.
There is no built-in audit trail. Spreadsheets do not track who changed what, when, or why. If a number is overwritten, the previous value is gone. This makes it difficult to respond to audit inquiries or reconstruct historical calculations.
Key-person dependency is a real operational risk. When the analyst who built the master spreadsheet is unavailable — due to vacation, illness, or departure — the remaining team may struggle to replicate the process. Undocumented macros, hidden columns, and institutional knowledge that lives only in one person's head create fragility that is hard to quantify until it becomes a problem.
#The Error Cost
Errors in royalty accounting flow in both directions, and both are costly.
Underpayments not caught. If your reconciliation process misses even a small percentage of revenue discrepancies, the dollars add up over time. Consider a scenario: if an organization manages $5 million in annual royalty distributions and its manual process fails to catch 0.5% of underpayments from operators, that represents $25,000 per year in unrecovered revenue. At a 1% miss rate, the figure doubles to $50,000. Over a five-year period, the cumulative impact could reach $125,000 to $250,000 — money that was owed but never collected because the discrepancy was not identified.
Overpayments to interest owners. Once a royalty check has been issued and deposited, recovering the overpayment requires notifying the owner, requesting a refund, and often negotiating an offset against future distributions. Some owners dispute the overpayment entirely. The administrative cost of recovery frequently exceeds the amount at stake for smaller errors, which means many overpayments are simply absorbed as losses.
Incorrect tax withholding. Royalty payments are subject to federal and state tax withholding requirements, including backup withholding when a valid W-9 is not on file. Errors in withholding calculations or in the 1099-MISC forms reported to the IRS can trigger inquiries from tax authorities. Even when the error is purely administrative, the time and cost of responding — gathering documentation, preparing a response, and potentially engaging outside counsel — can be significant.
These scenarios are not guarantees. A well-run manual process with experienced staff and strong review procedures can achieve high accuracy. But the margin for error narrows as portfolio size increases, and the cost of each error grows proportionally.
#Compliance and Audit Risk
Compliance exposure is where the cost calculus of manual accounting becomes most consequential, because the downside scenarios involve penalties and liabilities that can dwarf the underlying accounting costs.
State unclaimed property audits. Every state has escheatment laws requiring holders of unclaimed property — including undistributed royalty payments — to report and remit those funds after a dormancy period. State audits have become increasingly aggressive, with look-back periods of ten or more years. If your records are inadequate to demonstrate compliance, states can and do estimate liability using methodologies that tend to be conservative — against the holder. An organization that cannot produce auditable records of its suspense accounts and prior filings faces substantially greater exposure than one with clean documentation. For more on managing this risk, see our guide on unclaimed property management in oil and gas.
1099 reporting errors. The IRS imposes penalties under Internal Revenue Code Section 6721 for failure to file correct information returns, including 1099-MISC forms used to report royalty payments. Penalties range from $50 to $280 per incorrect return, depending on how quickly the error is corrected. For an organization issuing hundreds or thousands of 1099s each year, even a modest error rate can generate penalty exposure in the tens of thousands of dollars. These are not theoretical — the IRS assesses them routinely.
Audit defense costs. When a state initiates a formal unclaimed property examination — particularly through a third-party audit firm on a contingency basis — organizations report spending $50,000 to $200,000 or more on outside counsel, forensic accounting, and internal staff time. The range depends on the number of states involved, the volume of records at issue, and whether the examination is resolved through negotiation or proceeds to a formal assessment.
The common thread: the cost of compliance failures is heavily influenced by the quality of your records. Organizations with comprehensive, audit-ready documentation are in a fundamentally different position than those reconstructing history from a folder of spreadsheets.
#Opportunity Cost
Perhaps the most underappreciated cost of manual accounting is the opportunity cost of how your team spends its time.
When analysts devote 70% to 80% of their working hours to data gathering and formatting, only 20% to 30% remains for activities that directly protect and recover revenue: identifying pricing discrepancies, catching unauthorized deductions, flagging volume variances against state production data, and investigating suspense balances. These are the tasks that generate measurable financial returns, and they are precisely the tasks that get squeezed when manual processes consume available capacity.
With automation handling data aggregation, normalization, and routine reconciliation, that ratio can flip. Analysts spend the majority of their time on exception resolution and revenue recovery — work that has direct financial impact and requires human judgment rather than data entry skills.
Organizations that have made the transition consistently report that their teams identify more exceptions, resolve them faster, and recover more revenue in the first year of automation than in any prior year of manual operation. For a detailed look at how this plays out, see our analysis of automated royalty reconciliation ROI.
#When Does Automation Make Sense?
Not every organization needs royalty accounting software. A mineral owner with a handful of wells and a single operator may be perfectly well-served by a spreadsheet and a careful eye. But there are clear inflection points where manual processes become a liability rather than a cost-effective choice.
Portfolio size. As a general rule of thumb, organizations managing more than 50 to 100 wells across multiple operators begin to see diminishing returns from manual processes. The complexity of tracking different operator payment schedules, pricing methodologies, deduction structures, and division of interest calculations grows nonlinearly with portfolio size.
Growth trajectory. If your portfolio is expanding through acquisitions or new leasing, the manual workload scales with it but your team's capacity does not. Organizations in active growth mode frequently find that accounting infrastructure becomes a bottleneck that delays closings and increases error rates during transitions.
Fiduciary obligations. If you manage royalty interests on behalf of others — through a trust, fund, family office, or institutional vehicle — fiduciary obligations may require documented controls, audit trails, and reconciliation procedures that are difficult to maintain credibly in a spreadsheet environment.
Prior incidents. If your organization has already experienced a material error or audit finding related to royalty accounting, the risk calculus changes. The probability of recurrence is no longer theoretical, and the cost of a repeat incident includes reputational damage alongside direct financial impact.
#A Fair Comparison
Any honest evaluation has to acknowledge that software has costs too: licensing fees, implementation, data migration, training, and ongoing support. No one should adopt software on the assumption that it eliminates costs — it shifts them, and ideally in a direction that produces a net benefit.
The relevant question is not "is software free?" It is "does the net benefit exceed the cost, and over what timeframe?"
For most organizations above the 50-well threshold, the answer is yes within 12 to 18 months, based on a combination of labor efficiency, error reduction, improved revenue recovery, and reduced compliance risk. Below that threshold, the calculus is less clear and depends on specific circumstances. For a practical comparison of manual and automated reconciliation workflows, see our guide on royalty reconciliation best practices.
#Related Reading
- Automated Royalty Reconciliation ROI
- Royalty Reconciliation Best Practices
- A 5-Point Manual Reconciliation Checklist
#Evaluating Your Own Costs
If this framework is useful, consider applying it to your own operation. Start by documenting your current fully loaded labor costs for royalty accounting. Estimate the percentage of analyst time spent on data gathering and entry versus analysis and exception resolution. Review your error history — both overpayments and underpayments — over the past two to three years. Assess your compliance posture: are your records audit-ready, or would a state examination require significant reconstruction effort?
The answers to those questions will tell you more about whether automation makes sense for your organization than any vendor pitch ever could.
If you would like to talk through the analysis with someone who has seen it from both sides — manual and automated — our team is available for a no-pressure conversation. You can reach us through our contact page or explore our reconciliation solutions to see how the platform handles the workflows discussed in this post.