Revenue · Tool
JIB-to-revenue matching check
Every producing property that's billing costs should be paying revenue, and the decimals on both sides should tie. Paste your JIB deck and your revenue for the month, and this check lines them up by well name and cost center, then lists every exception to review.
Match on the key, not the name
A name alone isn't enough
Well names repeat and look alike across pads, units and offset wells. Matching on well name plus cost center ties each cost and each dollar of revenue to exactly one place, and it surfaces the cases where the same well name sits under two different cost centers.
The wrong cost center breaks the LOS
The lease operating statement is built from cost centers. If revenue or costs land on a lookalike cost center, both properties' LOS are wrong: one shows revenue with no expenses, the other shows expenses with no revenue. Margins, LOE per BOE and economics for both go off, and nobody notices until someone asks why a good well looks uneconomic.
Run the check
Paste from Excel (tab-separated) or CSV. Use five columns in this order, with or without a header row: Well name · Cost center · Owner · Decimal · Amount. Matching ignores capital letters and extra spaces, but not punctuation, so "Davis 4H" and "Davis 4-H" are flagged for you to confirm. On the JIB side the decimal is the working interest; on the revenue side it's the net revenue interest. The sample data shows the most common exceptions.
JIB deck and costs
Well name · Cost center · Owner · WI · JIB amount
Revenue deck and revenue
Well name · Cost center · Owner · NRI · Net revenue
Max burden is the highest combined royalty and ORRI you'd expect on a property, as a decimal. Implied burden = 1 − NRI ÷ WI.
Exceptions
| Exception | Well / cost center | Owner | JIB WI | JIB amount | Rev NRI | Revenue |
|---|
What each exception means
| Exception | What it means | Common causes |
|---|---|---|
| Possible wrong cost center | A well name and cost center on one side isn't on the other, but the same or a very similar well name is there under a different cost center. | Revenue or costs coded to a lookalike cost center. Reclass to the right one so both LOS statements are correct. |
| Well name doesn't match | The cost center is on both sides, but the well name is spelled differently. | The same well typed two ways ("Davis 4H" vs. "Davis 4-H"). Confirm it's one well and correct the name on one deck so future months match. |
| Costs, no revenue | A well and cost center is billing costs and has no revenue at all. | New well not producing yet, not set up on the revenue deck, revenue in suspense, shut-in, or revenue coded elsewhere. |
| Revenue, no costs | Revenue on a well and cost center with no JIB costs. | ORRI or royalty-only interest, costs coded elsewhere, or a non-op well whose JIB hasn't arrived or been booked. |
| Billed, not paid | An owner is billed on a cost center but isn't on its revenue deck. | Missing from the DOI, in suspense (title, address, transfer), or payout or non-consent status differs between the decks. |
| Paid, not billed | An owner is paid revenue on a cost center but isn't billed. | Royalty or ORRI owner (expected), a non-consent penalty in effect, or missing from the JIB deck. |
| NRI exceeds WI | A working interest owner's NRI is greater than their WI. | Decimal keyed wrong, or an ORRI rolled into the owner's NRI. |
| Burden over limit | The implied burden is higher than your max burden setting. | Royalty or ORRI decimals too high, or a WI that's too high on the JIB deck. |
| Burden differs between owners | This owner's implied burden doesn't match most of the other owners on the same cost center. | Fine when the owner carries their own ORRI or a different tract share. Otherwise one of the two decimals is off. |
Reviewing the results
- Clear the wrong cost centers and name mismatches first. They create two exceptions each and throw off two LOS statements, so fixing them removes noise from the rest of the list.
- Sort out the expected exceptions. Royalty and ORRI owners, new wells before first sales, and properties in non-consent will show up every month. Keep a list so you can skip them quickly.
- Work the owner-level gaps with land and revenue. "Billed, not paid" is the one partners call about. Check the DOI, suspense reasons and payout status.
- Tie out the decimals last. When an implied burden looks off, rebuild the decimal from the title opinion or division order, or use the decimal interest calculator.
- Watch payout months. When a well pays out, the interest change has to hit the JIB deck and the revenue deck in the same month, or both this check and the partner's statements will be off.
Non-operated properties: operators name wells their own way. Keep a cross-reference from each operator's well name and number to your own well name and cost center, and map the operator's JIB and check detail through it before running this check.
Your data stays in this page: nothing you paste is sent anywhere or saved. The check is a starting point for review, not a substitute for the division order, title opinion or JOA. The material on this site is general educational information, not legal, accounting or tax advice. Sample data uses made-up wells, companies and figures.