JOA Cost Allocation & Partner Billing Tracker: Working Interest Splits & Invoice Reconciliation

Allocate AFE costs by partner WI, reconcile billed vs calculated shares, and audit JOA joint account billing — partner accounting, not earned-value AFE tracking.

Joint interest billing accountants and operations teams reconciling JOA partner cost allocations.

Registers partner WI, allocates all five AFE lines to each partner by working interest, and reconciles the allocation against actual spend (allocated vs actual, per line and in total). Compares year-to-date billed amounts with calculated shares and flags any partner outside a set tolerance; the review flags and the review count use the same label, so the count always matches the flags. A billing QC crossplot plots billed vs calculated per partner against a 1:1 line.

• Instructions & Legend • Partner Register — partner, WI, billed YTD, calculated YTD • AFE Line Items — budget and actual for five lines • Cost Allocation — every AFE line allocated by WI, with allocated vs actual reconciliation • Invoice Reconciliation — billed vs calculated, variance, review flag with tolerance input • Billing QC Crossplot — billed vs calculated per partner with 1:1 line • AFE Budget vs Actual Chart • Billing Summary — year-to-date: WI sum check, total billed, net under/(over)-billed, review count • Summary — total allocated, actual spend, unallocated difference, allocation check, review count

Partner share = AFE actual × WI; allocation difference = actual − allocated; variance = billed − calculated

• Excel 2016+; 120+ formulas; 4-partner sample; 5 AFE lines • Professional colour scheme throughout • Yellow cells = inputs; white cells = formulas

Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.com