# The Oil and Gas Accounting Handbook: companion files

Julian R. Sterling, julianrsterling.com/asc932

## What is here

- **Oil_and_Gas_Accounting_Model.xlsx**: the workbook behind every figure of the book (appendix A). The case is fictional: Varnholt Exploration, Inc., a listed independent producer with two proved fields, an exploration program and a full cost ledger kept for comparison, at 31 December 2025 and 2026. Every case figure is a teaching assumption, never a market figure.

## The thirteen tabs, in the order to read them

1. **Inputs**: every typed number of the case, in blue: prices, costs, the production profile, reserves movements, spending, opening balances, asset retirement layers, excluded costs and the operator month.
2. **Checks**: nine tests, each TRUE, and a status cell that must read ALL PASS.
3. **Reserves**: the roll-forward by field and year, company totals and future development costs.
4. **Operations**: revenue, lease operating expense and severance tax.
5. **ARO**: the asset retirement layers, accretion and the roll-forward.
6. **Successful Efforts**: the ledger by field, DD&A, unproved properties, the suspended well, net capitalized costs and results.
7. **Valuations**: the yearly cash flows behind every reserve valuation.
8. **Full Cost**: the pool, the amortization base, DD&A, the ceiling, the write-down and results.
9. **Impairment**: the recoverability test of each field in 2026.
10. **Standardized Measure**: the discounted future net cash flows at each date.
11. **Changes**: the changes in the standardized measure, line by line.
12. **Disclosures**: costs incurred, capitalized costs, and the two methods side by side with the gap explained.
13. **Operator Month**: one month of revenue distribution and a joint interest bill.

## How to use it

Change one input at a time on Inputs, follow it to depletion, the ceiling and the disclosures, and read Checks before any figure. The workbook takes the reserve quantities as inputs: it rolls and values them but does not estimate them.

The workbook needs a spreadsheet program that recalculates formulas when the file opens (Excel or LibreOffice).

Rules are described as read in November 2026. This is education, not accounting, engineering or audit advice: your company's facts govern, and its accountants, reserve engineers and auditors decide.
