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.
TITLE
JOA Cost Allocation & Partner Billing Tracker — Working Interest Splits & Invoice Reconciliation
PRICE
$79 USD — one-time purchase
TAGLINE
Allocate AFE costs by partner WI, reconcile billed vs calculated shares, and audit JOA joint account billing — partner accounting, not earned-value AFE tracking.
WHO IT'S FOR
Joint interest billing accountants and operations teams reconciling JOA partner cost allocations.
WHAT IT DOES
Registers partner WI, allocates AFE line items by interest, reconciles billed vs calculated amounts, and flags variance for audit. Dedicated crossplot tabs support visual QC of model vs measured data.
TABS INCLUDED (9)
• Instructions & Legend • Partner Register • AFE Line Items • Cost Allocation • Invoice Reconciliation • Billing Summary • Billing QC Crossplot — billed vs calculated with 1:1 • AFE Budget vs Actual Chart • Summary
KEY FORMULAS
Partner share = actual × WI; variance = billed − calculated
TECHNICAL SPECS
• Excel 2016+; 380+ formulas; 4-partner sample; 5 AFE lines • MDT professional color scheme throughout • Yellow cells = inputs; white cells = formulas
SHOP COPY
7-tab JOA tracker: WI allocation, invoice reconciliation, billing summary. Includes QC crossplots with 1:1 reference lines.
SUGGESTED TAGS
JOA, cost allocation, partner billing, working interest, AFE
ABOUT RESERVOIR RISK SOLUTIONS
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. reservoirrisksolutions.com
ETSY LISTING
TITLE: JOA Cost Allocation Excel Tracker | Partner Billing WI Split Invoice Reconciliation PRICE: $79 USD — suggested; set your price in Etsy shop manager TAGS: JOA, joint operating agreement, cost allocation, partner billing, working interest, AFE tracking, oil gas accounting, Excel template, joint interest, petroleum accounting, digital download, invoice reconciliation
DESCRIPTION:
Professional Excel workbook for upstream engineers. Registers partner WI, allocates AFE line items by interest, reconciles billed vs calculated amounts, and flags variance for audit. Dedicated crossplot tabs support visual QC of model vs measured data.
Who it's for: Joint interest billing accountants and operations teams reconciling JOA partner cost allocations.
What's included: • Instructions & Legend • Partner Register • AFE Line Items • Cost Allocation • Invoice Reconciliation • Billing Summary • Billing QC Crossplot — billed vs calculated with 1:1 • AFE Budget vs Actual Chart • Summary
Technical specs: Excel 2016+; 380+ formulas; 4-partner sample; 5 AFE lines. Excel 2016+, no plugins, sample data pre-loaded.
About Reservoir Risk Solutions — built by petroleum engineers. reservoirrisksolutions.com DIGITAL_DELIVERY: Instant download — Excel .xlsx file
What you get
- Instant workbook access after payment in your Excel Library
- Formula-driven worksheet designed for petroleum workflows
- No recurring fees and no plugin requirements
FAQ
Is this a one-time purchase?
Yes. Each workbook is sold as a one-time purchase with no recurring subscription.
How do I access purchased files?
After checkout, your file appears in Excel Library under your account for download.
Do these templates require macros or plugins?
No. Templates are designed for Excel 2016+ and do not require VBA macros or external add-ins.
