|
Resource Logic Client/Server Development Services
Project - Oil and Gas Joint Interest Billing and Revenue Distribution
In the early 1980's Resource Logic partnered with another company to develop a suite of
applications for a business concept we were trying out: the placement of networked minicomputers
in the basements of large buildings, with data entry stations available to clients in the upper
floors. This being Texas, one application that looked promising was Oil and Gas Joint Interest
Billing and Revenue Distribution.
There are three classes of ownership in a production oil or gas well: Working Interest, Royalty,
and Overriding Royalty. Working Interest owners pay the expenses of operating the well and
are typically paid the greatest share of the well's revenues. Royalty owners may be people
that shared the cost of the drilling but are not paying operating expenses. Overriding Royalty
owners might be the person owning the land the well is located on.
An operating company will manage several leases, each of which in turn has a variable number of
owners (usually limited to no more than 35 for 'Subchapter S Corporation' tax reasons). Some
owners will have both Royalty and Working Interest percentages of particular leases, and
many owners will own interests in several leases. The objective of the operating company (and
therefore the software application) is to keep expenses and revenues properly assigned and
distributed.
This application was paired with a General Ledger and Accounts Payable system, one for recording
the expenses and revenues and the other for printing checks. Operating Expense and Well Revenue
transactions were first recorded in the General Ledger. Transactions belonging to particular
accounts were then extracted and distributed into the Oil and Gas application.
The Joint Interest Billing component of the system splits the costs of operating the well with
the Working Interest owners. The Well Operating Expense transactions are first distributed to
the Working Interest owners, then the data is summarized by Owner, so that each owner gets one
statement, regardless of how many interests they have in various leases. Some owners operate
on a 'net' basis, which means that well revenue is applied to expenses and the difference, if it
is positive, is sent to the owner. Other owners prefer to write a check to cover well operating
expenses, and receive a separate check for their share of all revenues collected.
The Revenue Distribution side is similar, although more people are paid than are billed. All
revenue is distributed to the owners, and then the revenues per owner are summarized into
Ownership Payables. A tricky element to this at this point is the Severance Tax, which is an
exaction made by the state the lease is operating in. For Texas, this tax is normally 8.5%.
However, some owners, such as school districts or municipalities, are not taxed.
This system was developed and used from 1982 to 1986. The application was written in Datapoint
Databus and run on Datapoint 6600 computers using the RMS operating system. We had two
clients running two leases and one lease respectively. Both clients abandoned this system
in the 'oil bust' of the mid- to late-1980's.
|
|