What haql-revenue does
haql-revenue compares production, lease records, purchaser statements and optional run tickets or contracts. It looks for missing statements, price and volume variances, unscheduled deductions, duplicate lines and value that does not add up.
In one sentence: It turns “the statement looks about right” into a dollar-ranked exception list.
Recover the difference
Review every lease and purchaser instead of spot-checking one.
Test the terms
See where a price or deduction departs from the contract.
Prioritise the work
Start with the exceptions that carry the largest dollar impact.
Why it matters
Differences that look like rounding on one lease become real money across hundreds of wells and several purchasers. A revenue accountant does not have time to re-derive every lease, so the check becomes a spot check that never reaches the quiet shortfall.
- Production can be booked with no statement line at all.
- A stale price or keying error can repeat every month it goes unnoticed.
- Paid volume can fall below the produced and ticketed volume.
- Deductions can exceed the contract, or a line can be paid twice.
One purchaser is spot-checked and the rest are paid as received. Differences under a thousand dollars per lease stay invisible against the month's gross.
Every lease, product and month is reconciled; exceptions are ordered by dollars and arrive with the statement line and source file behind them.
What goes in
The tool uses the CSVs you already export. Purchaser names are matched through aliases, not guessed silently.
| What goes in | What it means |
|---|---|
| Lease master | Lease identities and the purchaser's spellings as aliases. |
| Production by lease, product and month | The volumes that should be accounted for. |
| Purchaser statements | The statement lines that stand in for invoices. |
| Run tickets (optional) | Ticket volumes for a second volume check. |
| Contracts (optional) | Fixed prices and allowed deductions for variance checks. |
What comes out
The report is designed for a controller or revenue accountant to review and act on.
| What comes out | How to use it |
|---|---|
| Reconciliation | JSON, text, CSV and a self-contained HTML report. |
| Dollar-ranked exceptions | Each finding carries severity, confidence, dollar impact and an evidence trail. |
| Evidence trail | Statement ID, source filename and line number. |
| Summary | Dollars reviewed and the implied leakage rate. |
What it checks
The checks cover the full statement chain, from missing lines to value arithmetic.
| Check area | What it flags |
|---|---|
| Missing statement or production | A booked volume with no statement line, or a paid line with no production behind it. |
| Volume variance and zero volume | Paid volume differs from produced volume beyond tolerance, or production pays zero. |
| Price variance | Statement price differs from the fixed contract price. |
| Unscheduled deduction | Deductions exceed the allowed contract rate. |
| Value mismatch | Net value does not equal volume times price minus deductions. |
| Duplicate and negative lines | Identical lines for one lease/product/month, or an unexplained negative adjustment. |
| Unmapped lease and unit mismatch | A purchaser name with no alias, or units that cannot be converted. |
| Run-ticket checks | A missing ticket or a ticket volume that disagrees with production. |
Severity follows dollar impact: high at $10,000 or more, medium at $1,000, low below that. Thresholds are configurable, and findings are advisory questions with evidence.
What it does not do
A useful tool should be clear about its boundaries. These are the current limits, not hidden caveats.
- No PDF or scanned statement extraction yet; the CSVs must come from an export or data file.
- Index-based formulas such as West Texas Intermediate (WTI) plus a differential, or a gas basis, are not applied in this version.
- Multiple purchasers on one lease are aggregated; price and deduction checks are skipped with a warning.
- No gas-plant or natural gas liquids (NGL) settlement, prior-period accruals, recoupment, severance tax or net revenue interest.
- No enterprise resource planning (ERP), accounting or supervisory control and data acquisition (SCADA) connector; the bundled review UI is a local pilot surface, not a hosted multi-tenant app.
Findings are advisory. The tool names a contradiction or a risk with the evidence behind it. The engineering, legal or commercial judgement remains with you.
How to try it
Send one month of production and statements for a free exception list, or request a private build to run locally.
- Send a month of production and purchaser statements, anonymised if preferred.
- Receive the full exception list and evidence packet at no cost.
- Review the highest-dollar findings with the statement line and source file in hand.
Access
| Access | What you get |
|---|---|
| Sample check | Free. One month of production and statements, no key and no card. |
| Team | $349/month. Annual commitment, up to 10 users and unlimited leases. |
| On-premise | $1,750/month. Annual, per site, unlimited users on that site. |
Nothing leaves your machine. The paid tools run offline. The free libraries have no account, cloud call or telemetry.
Common questions
Does it read PDF statements?
Not yet. The current version works from CSV exports and data files.
Does it decide whether a deduction is legal?
No. It flags a variance against the supplied contract and evidence; the commercial or legal judgement remains with you.
Can it handle multiple purchasers on one lease?
It aggregates them and skips price and deduction checks for that key with a warning. Per-purchaser allocation is a future feature.
What is a purchaser statement?
The monthly statement from the company that buys the oil or gas. It records volumes, prices, deductions and net value.