The Ops Accountant · AP · Tools

AP · Guide and tool

Invoice coding guide and checker

Coding is where an invoice picks up its well, its partners and its accounting treatment. A wrong cost center bills the wrong partners and throws off two LOS statements; a missing AFE number gets the line held by every partner. These are the rules, and a checker that tests a batch of coded lines before they post.

The coding rules

Where it goes

  • Code to well name + cost center, never the name alone. Wells on the same pad or unit often share most of a name.
  • The cost center must belong to that well in the well master. If the name and cost center point at different wells, stop and ask the field.
  • Don't code to a well that's been sold or plugged unless the work is the P&A itself.

What kind of cost it is

  • LOE: routine operating costs. No AFE number.
  • Workover, Capital or P&A: AFE work. Every line carries an open AFE number for that same well and cost center.
  • The cost type must match the AFE's type: Workover work on a Workover AFE, P&A work on a P&A AFE.
  • A closed AFE takes no new charges. Get a supplement or a new AFE first.

For the line between LOE and capital, see capital vs. LOE. For why partners hold AFE charges, see JIB-AR.

Coding checker

Paste from Excel. The well list and open AFE list are what the invoice lines are checked against; the more complete they are, the more the checker catches. Nothing you paste leaves this page.

Coded invoice lines

Vendor · Invoice no. · Invoice date · Well name · Cost center · AFE no. (blank for LOE) · Cost type (LOE, Workover, Capital or P&A) · Amount

Well list

Well name · Cost center · Status (Producing, Drilling, Shut-in, Sold, Plugged…)

AFE list

AFE no. · Well name · Cost center · AFE type · Status (Open or Closed)

What the checker looks for

CheckFlags when
Well and cost centerThe cost center belongs to a different well, the well is set up under a different cost center, or the well isn't in the list at all (with a suggestion when a similar name exists).
Well statusThe well is sold, or plugged and the cost isn't P&A. Shut-in wells with LOE get a softer flag to confirm.
Missing AFEWorkover, Capital or P&A work has no AFE number. If the well has an open AFE of that type, it's suggested.
AFE problemsThe AFE isn't in the list, is closed, belongs to a different well or cost center, or is a different type than the line is coded.
LOE on an AFEA line coded LOE carries an AFE number.
DuplicatesSame vendor and invoice number as an earlier line; or same vendor, amount and date under a different invoice number (possible duplicate).

The material on this site is general educational information, not legal, accounting or tax advice. Follow your company's coding policy and chart of accounts. Sample data uses made-up wells, vendors and figures.