UC-081
AFE and JIB Invoice Reconciliation
Matches vendor invoice and JIB statement lines to AFEs and rate contracts, flagging duplicates, off-contract rates and over-billing.
6-10Build Duration
12-37xIndicative ROI
The Challenge
Non-operated billing arrives as JIB statements a lean team can only sample, so $0.5-1.5M a year of duplicates and off-contract rates is paid. Volume and month-end lag make full line review impossible.
How It Works
- Ingests vendor invoices, JIB statements, AFEs and rate contracts from finance and SharePoint.
- Matches every line to its AFE and contracted rate, scoring duplicates and off-contract charges.
- Finance reviewers get a flagged exception list with the disputed amount before the payment run.
What It Removes
- Sampling invoices instead of checking every line
- Duplicate charges paid before anyone notices
- Off-contract rates absorbed at month-end
Input Data RequirementsVendor invoices, partner JIB statements, AFEs, rate contracts, payment records, cost allocation tables
Output FormatLine-level exception register, duplicate and off-contract flags, recovery claim pack for partners
“I get the disputed lines with the AFE they should have hit, instead of finding them at month-end.”