JIB · Guide and calculator
Monthly expense accruals
Field work happens this month; the invoices show up next month or later, and operators' JIBs can run two or three months behind. Accruals put those costs in the month they were incurred, by well and cost center, so the books, the LOS and the AFE tracking aren't a month or more out of date.
Two methods, operated and non-operated alike
LOE and AFE accruals each follow one method, whether you operate the well or another company does. Only the sources change.
LOE · operated and non-operated
Recurring operating costs that haven't been invoiced or billed by cutoff.
- Method: 5-month average of actual LOE by cost center, adjusted by guidance from Operations, minus what's already been invoiced for the month.
- Why Operations: they know what's happening on the ground: a workover, a failed pump, a well that's been shut in. History can't tell you that.
- Support: LOE history by cost center, plus Operations' guidance in writing.
AFEs · operated and non-operated
Work on open AFEs, accrued by AFE type: Workover, Capital (drilling, completion, facilities) or P&A.
- Method: the greater of (a) the field operations estimate of cost incurred to date minus costs posted to the AFE, or (b) unposted invoices routing for approval.
- Why the greater: if invoices already in approval exceed what the field estimate implies, the estimate is behind and the invoices are the better evidence.
- Support: field cost estimates, daily drilling and completion reports, the approval queue, the AFE.
| Input | Operated wells | Non-operated wells |
|---|---|---|
| LOE history | Vendor invoices posted by cost center | LOE billed on the operator's JIBs, by cost center |
| Invoiced so far | Vendor invoices already received for the month | Operator JIB charges already received for the month |
| Field estimate | Your field operations' cost estimate to date | The operator's cost reports and daily drilling or completion reports, reviewed with your Operations team |
| Posted to date | Invoices posted to the AFE | Operator JIB charges posted to the AFE |
| Unposted in approval | Vendor invoices routing for approval | Operator JIBs and AFE invoices received, not yet posted |
Accruals are booked at net. The estimate is built at 100% of the well's cost, then multiplied by your company's working interest. Only that net share is accrued. Partners' shares aren't accrued; they're billed on the JIB once the actual invoices post.
The entry: Debit the accrued account for the cost type · Credit Accrued liabilities, reversing on the first day of the next month. LOE accrues to LOE - accrued (net); AFE work accrues by AFE type to AFE-Workover-accrued (net), AFE-Capital-accrued (net) or AFE-P&A-accrued (net).
Accrual calculator
Paste each kind from Excel, one row per well and cost center, then calculate. Enter amounts at 100% of the well; WI is your company's working interest, and the net accrual is the estimate × WI. Operated and non-operated tabs use the same columns. Leave a tab empty if it doesn't apply this month.
Operated LOE · 5-month average with Operations guidance
Well name · Cost center · WI · Actual month 1 · Month 2 · Month 3 · Month 4 · Month 5 · Invoiced so far this month · Operations guidance (+ or −)
Accrual = average of the 5 months + Operations guidance − invoiced so far (never below zero), × WI. Use a negative guidance amount for a well that's down or running below its average.
Operated AFEs · Workover, Capital and P&A
Well name · Cost center · WI · AFE type (Workover, Capital or P&A) · AFE gross · Field estimate of cost to date · Posted to date · Unposted invoices in approval
Accrual = the greater of (field estimate − posted to date) or unposted invoices in approval, × WI. Flags which one drove it, and committed cost over the AFE.
Non-op LOE · same method, operator JIBs as the source
Well name · Cost center · WI · Actual month 1 · Month 2 · Month 3 · Month 4 · Month 5 · JIB charges received so far this month · Operations guidance (+ or −)
Accrual = average of the 5 months + Operations guidance − invoiced so far (never below zero), × WI. Use a negative guidance amount for a well that's down or running below its average.
Non-op AFEs · same method, operator JIBs as the source
Well name · Cost center · WI · AFE type (Workover, Capital or P&A) · AFE gross · Field estimate of cost to date · JIB charges posted to date · Unposted JIBs in approval
Accrual = the greater of (field estimate − posted to date) or unposted invoices in approval, × WI. Flags which one drove it, and committed cost over the AFE.
Accruals by well and cost center
| Type | Well / cost center | WI | Estimate at 100% | Net accrual (× WI) | Review |
|---|
Journal entry preview · net
| Account | Debit | Credit |
|---|
Book as an auto-reversing entry dated the last day of the month, reversing on the first day of the next. Code each line to its well and cost center. Operated and non-operated accruals post to the same accounts by type.
Reviewing accruals
- True up last month. Compare last month's accrual by cost center with the invoices that actually came in for that month. Wells that miss by a wide margin every month need a better estimate, or a conversation with Operations.
- Get Operations' guidance in writing. An email or a note on the accrual file showing what they expect and why is the support for every guidance adjustment.
- Compare to prior months. A cost center with an accrual far above or below its usual level needs a reason: a workover, a shut-in, a new well.
- Watch AFE overruns. When the field estimate, or posted plus unposted invoices, passes the AFE, flag it for a supplemental AFE before partners see it on a JIB.
- Close the gap with the field. When unposted invoices drive the accrual, the field estimate is behind. Ask field operations to update it so next month's estimate is reliable.
- Skip wells that are down. Shut-in, sold or plugged wells shouldn't carry an average-based accrual. Operations guidance should bring them to zero.
- Avoid double counting. Invoices received after cutoff but before the accrual is booked belong in "invoiced so far" or "posted to date", or the cost lands twice until the reversal. An unposted invoice used as the accrual basis must not also be posted in the same month.
- Use the right cost center. Accrue on the same well name and cost center the invoice will use, or the LOS swings between lookalike cost centers when the accrual reverses.
- Keep the support. Save the 5-month history, Operations' guidance, field estimates, the approval queue and operator JIB history behind each number. Auditors ask.
Accruals are booked in the "Cutoff and cost review" phase of the JIB month-end close checklist. For whether a cost belongs on the capital or the LOE side, see the capital vs. LOE guide.
Your data stays in this page: nothing you paste is sent anywhere or saved. Accrual methods vary by company; follow your accounting policy and auditor guidance. The material on this site is general educational information, not legal, accounting or tax advice. Sample data uses made-up wells, companies and figures.