How to Reconcile a JIB Account Step-by-Step

Goal: Practical process improvement
Audience: Oil & gas accountants (operator side)

If month-end in oil and gas accounting has ever felt like your JIB process was controlling you instead of the other way around, you are not alone.

Joint Interest Billing (JIB) reconciliation is one of the most detailed, high-risk parts of the accounting cycle. When it breaks down, the consequences add up quickly:

• Partner disputes
• Billing delays
• Audit findings
• Extended close cycles
• Reduced trust with non-operating partners

The good news is that JIB reconciliation becomes far more manageable when approached through a disciplined, repeatable workflow.

This guide walks through the full reconciliation process—from source documents to final statements—so you can close each month with confidence.

What Is JIB Reconciliation — And Why Does It Matter?

Joint Interest Billing is the process by which an operator allocates joint account costs to non-operating working interest owners based on their ownership percentage under the Joint Operating Agreement (JOA).

These costs may include:

• Drilling
• Completion
• Lease operating expenses (LOE)
• Overhead
• Workovers
• Capital expenditures

JIB reconciliation ensures:

• Costs billed match actual costs incurred
• Charges comply with the JOA and COPAS guidelines
• AFE approvals are properly followed
• Working interest decimals are accurate
• Statements are supportable during audits

When JIB reconciliation is weak, overbilling, underbilling, and unsupported charges create financial and reputational risk.

Step 1: Gather and Review Source Documents

Before reconciliation begins, pull together all supporting records.

Essential documents:

• Joint Operating Agreement (JOA)
• COPAS accounting procedure exhibit
• Vendor invoices for the billing period
• Approved AFEs and supplemental AFEs
• Current Division of Interest (DOI) records
• Prior month JIB statement
• Outstanding disputes or prior period adjustments
• Accounts payable detail by well/property

Why this matters:

Many reconciliation issues begin with bad source data:

• Invoice coded to the wrong well
• Expired AFE
• Ownership changes are not reflected
• Missing support

Best practice: Verify DOI records before running allocations. An outdated ownership table affects every calculation downstream.

Step 2: Verify Cost Coding and AFE Alignment

Every charge should be assigned correctly by:

• Property
• Well
• Cost category
• AFE (if capital)

Review line by line:

• Is the invoice tied to the correct well?
• Is it capital or operating?
• Does the charge align with approved AFE limits?
• Is overhead compliant with COPAS?

Common issue:

Charges exceeding approved AFE amounts without supplemental authorization are among the most common causes of partner disputes.

Control tip: Build exception reporting for invoices without valid AFE references.

Step 3: Apply Working Interest Decimals

Once costs are verified, allocate them by ownership percentage.

Allocation workflow:

1. Confirm current partner decimals
Review DOI effective dates carefully.

2. Multiply the total cost by each partner’s decimal

3. Confirm decimals total 100% (1.000000)

4. Compare manual calculations to system output

Common mistakes:

• Outdated DOI after ownership transfer
• Decimal rounding errors
• Wrong effective date
• Duplicate ownership records

Even small decimal errors can materially affect partner balances over time.

Step 4: Reconcile to the Lease Operating Statement (LOS)

Your JIB expense base should tie directly to your Lease Operating Statement.

Reconciliation goal:

Total expenses per LOS = Total expenses per JIB before partner allocation

Investigate variances immediately:

Potential causes include:

• Timing differences
• Prior period adjustments
• Coding errors
• Missing AP postings
• Duplicate entries

Unexplained variances create audit red flags and undermine statement credibility.

Step 5: Run a Simulation JIB Before Finalizing

Simulation is your quality control checkpoint.

Before distributing statements, generate a preliminary JIB and review it carefully.

Review for:

• Unexpected partner variances
• Missing charges
• Charges outside the AFE scope
• Incorrect overhead
• Negative balances
• Prior period adjustments lack an explanation

Why simulation matters:

Catching an error before statement distribution protects:

• Close timelines
• Partner confidence
• Audit defensibility

Skipping this step often creates avoidable disputes.

Step 6: Issue Final Statements and Retain Documentation

Once the simulation is validated, finalize JIB statements.

Retain support for every billing cycle:

• Vendor invoices
• Field tickets
• Payroll allocations
• Approved AFEs
• DOI records
• Adjustment explanations

Important:

Most JOAs grant audit rights extending back multiple years.

If documentation is missing, unsupported charges may be disallowed.

Documentation is your defense.

Step 7: Track Collections and Open Balances

JIB reconciliation does not end at statement issuance.

Ongoing responsibilities:

• Monitor partner receivables
• Review payment terms per JOA
• Apply interest on overdue balances when allowed
• Maintain aging by partner and well
• Follow up on unpaid balances promptly

Why this matters:

Delayed collections affect cash flow and may signal broader partner issues.

Strong AR discipline supports healthier operator-partner relationships.

Common JIB Reconciliation Mistakes to Avoid

Using outdated DOI decimals

Ownership changes must be reflected immediately.

Skipping simulation

A five-minute simulation review can prevent weeks of dispute resolution.

Mixing capital and LOE

Incorrect classification affects:

• AFE approval
• Billing treatment
• Financial reporting

Weak prior period adjustment support

Unexplained true-ups create partner friction.

Letting receivables age

Open balances should be reviewed monthly.

Monthly JIB Reconciliation Checklist

A repeatable monthly checklist can significantly improve consistency.

Core checklist:

• Verify DOI
• Review invoices
• Validate AFE alignment
• Confirm LOS tie-out
• Run simulation
• Issue statements
• Archive documentation
• Track collections

Standardization reduces both errors and close time.

Final Thoughts

JIB reconciliation is one of the most operationally important accounting workflows for oil and gas operators.

When done well, it creates:

• Faster closes
• Fewer partner disputes
• Better audit outcomes
• Improved cash flow
• Greater trust

When done poorly, small issues compound into billing disputes and damaged credibility.

A structured process is the difference.

Download the JIB Reconciliation Checklist

To support your monthly close, create a downloadable JIB Reconciliation Checklist that your accounting team can use every cycle.

Your checklist should include:

• Source document review
• AFE validation
• DOI verification
• LOS reconciliation
• Simulation review
• Statement release
• Collections follow-up

This type of checklist helps transform JIB from a recurring headache into a controlled process.

Simplify JIB Reconciliation with Pivoten

JIB reconciliation requires precision across ownership, costs, AFEs, and partner billing. Manual spreadsheets often increase risk, slow down the close, and create avoidable disputes.

Pivoten’s oil and gas accounting application helps operators:

• Manage DOI records accurately
• Validate AFEs and cost coding
• Automate JIB allocations
• Run simulation billing before final release
• Generate partner-ready statements
• Maintain audit-ready support

If your accounting team is spending too much time reconciling JIB manually, Pivoten can help create a faster, more accurate workflow.

Learn how Pivoten streamlines Joint Interest Billing from source documents to final statements.