What multi-entity consolidation means in oil and gas

Multi-entity consolidation combines the financial results of related companies without counting transactions between them twice. For example, an exploration and production operator records its well costs and production revenue, while an associated midstream company charges the operator for gathering gas. Each company maintains its own books, but the parent company requires a consolidated report.

The fact that ownership is involved makes the report more complicated; for instance, if the operator spends $100,000 on the well and bills the outside working-interest owners $40,000 through joint interest billing (JIB), it has to record the full expense, the amount that the outside owners owe, and its own share of $60,000; revenue is calculated according to the division-of-interest records which the owners receive when they get the product, including the royalty owners and any affiliates with an interest.

The consolidated accounts would include amounts due from or to outside owners but exclude charges between the operator and its affiliates. Otherwise, the gathering fee would appear as revenue for one group company and as an expense for another. Records must link each amount to the well, property, owner, and legal entity so both company-level results and the group total.

 

How Providence connects entity accounting in one platform

Avatar Systems calls Providence a cloud-native platform with single-instance architecture. The homepage notes that its general ledger supports a shared chart of accounts for multiple entities,  accounts across entities without translating structures, but it doesn't automatically reconcile or eliminate intercompany balances.

Check the current status of consolidated reporting. While the homepage lists consolidated financial reporting as a general ledger feature, the Providence General Ledger page labels "consolidated reports across entities" as coming soon. Clarify with Avatar Systems which consolidated reports are actually available now.

Providence’s open-period design eliminates the need for a rigid month-end close and lets you drill down to individual transactions for any period. Rather than relying on closed-period summaries, you can review adjustments directly from the transactions.

Integrated JIB and revenue modules in Providence reduce data handoffs between applications. If you use external production, land, or accounting systems, check how their data flows into Providence and when those entries show up in reports.

How JIB allocations reach the general ledger

A well expense posts to the general ledger under the entity that incurred it. Avatar Systems says Providence allocates JIB costs when transactions post to the GL, so you can run JIB without waiting for month-end processing. If a $10,000 expense is fully billable and a partner holds a 40% interest, the allocation identifies a $4,000 partner share. The JIB page says JIB integrates with the general ledger and accounts receivable but does not show the journal entries a billing creates.

DOI decks support multiple effective dates, so ownership terms can follow changes over time. The Property Ledger, a sub-ledger to the GL, keeps since-inception balances and transaction history for each property and supports consolidated property reports and 100% and net lease operating reports. Financial reports can be run by transaction date, production date, entry date, invoice date, or JIB date, which helps you investigate why a prior-period well cost appears in a current billing run without treating the two dates as the same accounting event.

How revenue distribution handles owners and affiliates

Providence uses date-effective division-of-interest decks to calculate owner revenue shares for each period. Avatar Systems keeps records of scaled decks and owner-level revenue histories. If an owner's interest changes, you can check past distributions against the interest that was in effect at the time.

Revenue Distribution links with Revenue Entry and the general ledger. Avatar Systems also tracks inter-company processing and multi-level distribution across affiliated entities. For wells with both outside and affiliated owners, these features help you track revenue movement through the ownership structure before preparing entity or group reports.

Distribution across affiliates doesn’t clarify how Providence handles consolidation eliminations. Affiliate transactions may need offsetting entries to prevent double counting in consolidated reports. Since Avatar Systems doesn’t document automatic eliminations for revenue distribution, ask how Providence records affiliate amounts and how to remove them from consolidated reports.

What to verify about intercompany eliminations and close timing

Avatar Systems documents inter-company revenue processing and consolidated reporting, but its published material does not explain how Providence handles elimination entries. Ask for a demonstration using an affiliate charge that creates a receivable in one entity and a payable in another. Have Avatar Systems show both entity ledgers, the resulting consolidated report, and any elimination entries. Confirm who creates those entries, where they post, and how Providence handles reversals.

Account mapping needs a separate check. Ask Avatar Systems to map your chart of accounts and entity hierarchy to a consolidated statement, especially if affiliates use different account codes. Then compare reports before and after a transaction. Providence documents an open-period ledger and current financial reporting, but those descriptions do not establish when eliminations appear in a consolidated report or whether your close requires another step.

Finally, test a prior-period JIB or revenue correction with your own data. Compare the original and corrected entity balances and consolidated totals. Ask how you can trace the correction and whether the affected period’s elimination entries need adjustment.

Walk through a two-entity example

Suppose Entity A operates a well, Entity B is an affiliate with a 25% interest, and outside owners hold another 25%. The following amounts and entries are hypothetical. Entity A records a $10,000 well expense, including $2,500 attributable to Entity B and $2,500 attributable to outside owners. Providence allocates JIB costs when transactions post to the general ledger, so the operator can examine the well expense and the owners’ billed shares without waiting for a month-end JIB run.

Now suppose the well earns $20,000 in distributable revenue and its revenue interests match those expense shares. Entity A’s share is $10,000, Entity B’s is $5,000, and outside owners receive $5,000. Providence documents owner-level revenue histories, intercompany processing, and distribution across affiliated entities. Those capabilities connect the owner calculation to the accounting records, but the example does not assume that Providence settles the amounts automatically.

For a consolidated report, you would need to count both affiliates’ shares while excluding balances and transactions between Entity A and Entity B. Under the example’s assumptions, their combined share is $15,000 in revenue and $7,500 in well expense. Ask to see the actual ledger entries and elimination treatment in a demo. Avatar Systems does not document an automatic elimination mechanism on its site.

Questions to bring to a Providence demo

Bring a well with activity involving two legal entities, ownership records, a JIB expense, an affiliate transaction, and a prior-period correction. Ask Providence to use your account mapping and reporting hierarchy for the entire demo.

  • Can you trace the well expense from its source record through GL posting, JIB allocation, and the entity report? Avatar Systems says JIB allocations happen as transactions post to the GL. Request to see the underlying transactions, not just summary totals.
  • How does Providence record and report affiliate transactions? Have the presenter show any elimination entry, who creates it, and its impact on the consolidated balance. Don’t assume eliminations are automatic.
  • After a prior-period change, when do entity, property, and consolidated reports reflect the correction? Ask to compare reports before and after the change, and trace the revised amount back to its posting.

Conclusion

Providence is worth assessing if you need to connect well and property activity with entity accounting and financial reporting. Avatar Systems documents a single-instance, native SaaS platform with general ledger, JIB, revenue distribution, and reporting capabilities. Ask Avatar Systems to demonstrate a transaction using your entity structure, then trace its posting through the relevant reports. Have the demonstration cover affiliate transactions, elimination entries, and report timing so you can verify how Providence would support your close.