The Authorization for Expenditure is the financial foundation of any drilling or completion project. It's supposed to tell you what the work will cost, and track what you've actually spent.
For most operators, the AFE is in a spreadsheet. That spreadsheet gets updated monthly. Maybe. Actuals lag by weeks. By the time you realize an AFE is running hot, half the invoices are already paid and your partners want to know why.
This is fixable.
What an AFE actually needs to track
A useful AFE has four components:
- Budget: the approved total, broken out by category (drilling, completion, facilities, and so on).
- Commitments: contracted amounts that haven't been invoiced yet.
- Actuals: invoiced amounts, regardless of payment status.
- Remaining: budget minus commitments and actuals.
Most spreadsheet AFEs only track budget and actuals, and actuals are always behind. That's why surprises happen.
The spreadsheet problem
Here's the typical workflow at a mid-size operator:
- Drilling engineer creates the AFE in Excel, gets approval from management and partners.
- The AFE lives in a shared folder, maybe on SharePoint.
- Invoices come in via email as PDFs.
- AP clerk enters them into QuickBooks or an ERP.
- Someone (usually an accountant or analyst) pulls a report monthly and updates the AFE spreadsheet.
- By the time anyone sees the update, some invoices are 30+ days old.
The lag problem
The gap between "invoice received" and "AFE updated" is usually 2 to 6 weeks. During that time, you're making decisions (approving more work, paying invoices, committing to additional services) without knowing your real AFE position. That's when over-budget surprises happen.
What good AFE tracking looks like
The fix isn't complicated. It just requires connecting the dots.
1. AFE assignment at invoice entry
Every invoice, at the moment it's received, gets tagged with the AFE it's charged against. Not later. Not at month-end. At entry. This is the single biggest change.
2. Real-time budget visibility
When someone looks at an AFE, they should see: budget, committed, invoiced, paid, remaining. Updated the moment an invoice is entered. Not a stale export from last week.
3. Over-budget alerts
When an AFE hits 80% spent, someone should know. When it hits 100%, everyone should know. Don't let AFEs quietly drift over budget.
4. Invoice-level traceability
When you click on an AFE, you should be able to see every invoice charged against it, in order, with vendor, amount, and service type. This is how you audit your own spending and catch errors.
Common AFE tracking failures
Wrong AFE assignments
Invoices get charged to the wrong AFE all the time. The vendor puts a well name on the invoice, the AP clerk matches it to an AFE that sounds similar, and it stays miscoded forever. Good systems make the correct assignment easy (dropdown of active AFEs with well name) and the wrong one hard.
Missing commitments
Your drilling contractor is $400K into the hole. That's committed but not yet invoiced. If your AFE tracker only shows invoiced amounts, you don't see that commitment and may approve additional work you can't afford.
No partner visibility
In joint operations, partners care about AFE status too. Most operators email them PDFs monthly. Better: give partners real-time AFE visibility (even if read-only).
Cross-AFE spending
One invoice can cover multiple AFEs. If your system can only assign to one, you end up with incorrect allocations. Good systems let you split line items across AFEs.
Practical recommendations
For small operators (1 to 10 active AFEs):
Even a spreadsheet can work if you commit to updating it weekly. The key is timing: weekly, not monthly. And the AFE assignment has to happen at invoice entry, not later.
For mid-size operators (10 to 50 active AFEs):
You're past the point where spreadsheets scale. You need either a dedicated AP/AFE system or disciplined use of your ERP's project tracking module. The answer is almost always software, not more spreadsheet rigor.
For larger operators:
You probably have SAP, Oracle, or a purpose-built oilfield ERP. The question is adoption. These systems work, but they're notoriously hard to use, so AP clerks find workarounds. Good training and UX matter as much as the software itself.
What to look for in an AFE tracking system
- Real-time updates: no month-end batch processing.
- Visual budget indicators: bars, colors, not just numbers in a cell.
- Invoice drill-down: click an AFE, see the invoices.
- Over-budget alerts: automated, not manual.
- Partner access: read-only views for partners.
- Close workflow: formal process to close an AFE when work is done.
- Historical reporting: compare AFEs across projects to improve future estimates.
The bigger picture
AFE tracking is a proxy for something more important: financial discipline in your operations. Operators that manage AFEs well tend to manage costs well generally. Operators that let AFEs drift tend to have other financial visibility problems too.
The good news is this is one of the most solvable problems in oilfield operations. The tools exist. The discipline is learnable. And the ROI (in avoided over-budget surprises, better partner relationships, and faster decision-making) is substantial.
See IronLedger in action
Real-time AFE tracking integrated with vendor AP, approval workflows, and spend analytics. Built for oilfield operators.
Learn more