The Ops Accountant

Oil & gas operations accounting

Follow the money from invoice to revenue check

Every cost on a well enters through accounts payable, gets billed to the working interest owners through the JIB, and should be matched by revenue on every producing property. This site explains each step in plain language, with calculators and checklists you can use during close.

How the money flows

Step 1 · Accounts payable

Costs enter

Invoices and field tickets come in, get coded to a well, an AFE and an account, and get approved and paid.

  • Invoice coding and approval routing
  • Vendor setup and field tickets
  • Month-end cutoff
2 resources · Open the AP section →
Step 2 · Joint interest billing

Partners get billed

Each well's costs are split by working interest, overhead and recurring entries are added, and partners are invoiced.

  • Capital vs. LOE and AFEs
  • Ownership decimals and COPAS overhead
  • Accruals, SWD and water gathering, transfers, JIB-AR
  • The month-end close
8 resources · Open the JIB section →
Step 3 · Revenue

Revenue should match

Production is sold and paid out by net revenue interest. Every well billing costs should be paying revenue that ties to its decimals.

  • Operated revenue distribution
  • Non-op check detail review
  • JIB-to-revenue matching
Matching tool · Open the Revenue section →

One well, one month, all three steps

A simple example on a single well, the Smith 1H, cost center CC-1001. Three working interest owners, one 3/16 royalty, and one workover invoice.

1 · AP codes the invoice

VendorWell service co.
WorkPump repair
WellSmith 1H
AccountLOE · Repairs
Gross invoice$48,000.00

2 · JIB bills the partners

Operator Co. · 0.60 WI$28,800.00
Partner A · 0.25 WI$12,000.00
Partner B · 0.15 WI$7,200.00
Total$48,000.00

3 · Revenue pays out

Gross sales$180,000.00
Royalty · 0.18750000$33,750.00
Operator Co. · 0.48750000$87,750.00
Partner A · 0.20312500$36,562.50
Partner B · 0.12187500$21,937.50

The matching check: Partner A is billed at 0.25 WI and paid at 0.203125 NRI, which is 0.25 × (1 − 0.1875). Both sides agree. When a partner is billed costs on a producing well but isn't on the revenue deck, or the two decimals don't tie, that's an exception. The JIB-to-revenue matching check finds them for you, matching on well name and cost center.

Data analysis

Analyze · 5 case studies

Reviewing the flow with data

Case studies built on a sample dataset of wells, AFEs, invoices, JIB lines and revenue. They show how to consolidate, reconcile and report on operations accounting data at scale, and most run live in your browser. Open the Analyze section →

Power QueryCombining non-op JIBs from many operators
Power BILOE per BOE, AFE spend vs. authorized
SQLJIB-to-revenue exception queries
ExcelXLOOKUP and pivot-based accrual review

Who it's for

AP and JIB accountants

Quick references for coding, overhead and decimals during close.

New staff

The concepts behind the work, explained without assuming years of experience.

Non-operated partners

Context for reviewing the JIBs, AFEs and revenue checks you receive.

Revenue and land teams

How decimals and ownership changes flow into billing and payment.

About

Written by a JIB supervisor who reviews the work behind each step: monthly expense accruals, oil and gas payouts, AFEs, new well setups, expense allocations, non-operated JIB invoices, and monthly entries for salt water disposal, gathering, COPAS overhead and material transfers. The guides cover the gray areas honestly, because that's where review notes come from.

Coming next

AP: month-end cutoff checklist JIB: new well setup JIB: AFE lifecycle Revenue: non-op check detail review Revenue: severance tax rates by state

The material on this site is general educational information, not legal, accounting or tax advice. Your joint operating agreements, accounting procedures and company policies govern. All examples use made-up wells, companies and figures.