Archive

Category Archives for "Uncategorized"

Oil & Gas Accounting 101 – Accounting Methods

 

taxcodeMost small independent producers, who are not required to use a GAAP method of accounting, use a tax method of accounting or a hybrid of successful efforts and tax.

The rules for tax accounting are set forth in the Internal Revenue Code and the corresponding Treasury Regulations.

The general rule for accounting methods in the Internal Revenue Code states:

Taxable income shall be computed under the method of accounting on the

basis of which the taxpayer regularly computes his income in keeping his books. (IRC Sec. 466(a))

This means that your taxable income is calculated using the same method you use doing your monthly accounting. That’s what “keeping your books” means.

This code section goes on to define the permissible methods. The permissible accounting methods under IRC Sec. 466(c) are:

  • Cash receipts and disbursement method (cash method)
  • Accrual method
  • Any other method permitted under the law, and
  • Any combination of the methods permitted under the regulations

The accounting method used must clearly reflect income and be consistently applied. Treas. Reg. Sec. 1.446-1 states:

It is recognized that no uniform method of accounting can be prescribed for all taxpayers.Each taxpayer shall adopt such forms and systems as are in his judgment best suited to his needs. However, no method of accounting is acceptable unless it clearly reflects income…provided all items are treated consistently from year to year.

Cash Method

The cash method means that you recognize income when you receive payment, either for the oil & gas produced or for services performed. It also means that you recognize expense when you pay the bill for the expense.

Accrual Method

The accrual method means that you recognize income when the oil or gas is produced and expenses when the expense is incurred.  So gas produced in March would be March revenue even though you might not receive the payment from the first purchaser until May. Expenses are incurred when you receive the bill for the expense instead of when you pay the bill.

Other Methods Permitted

This generally doesn’t apply to oil & gas accounting. It deals with methods such as the “crop method of accounting” and the “long-term contract method”

A Combination of Methods

You can combine methods such as using the cash method for receivables (revenue), and the accrual method for payables (expenses).

Notice that the accounting method can be the cash method, the accrual method or a hybrid method of cash and accrual as long as you stay consistent.

 

Accounting 101 E-Book


Source: SherWare Blog

Oil & Gas Accounting 101 – Division of Interests

 

The percentages that determine the amounts paid to the different people or entities participating in the well is called the Division of Interests or Division Order. The division order is a document spelling out what the Division_orderowners in the well are to be paid and when.

The interests (percentages) that make up the division of interests are typically determined in the following manner:

Royalty Owners – paid the percentage their land makes up of the entire drilling unit. If they own 100% of the land the well is drilled on they would typically get a 12.5% royalty.

Overriding Royalty Owners – typically paid around 3%.

Working Interest Owners – pay their share of the expenses based on the amount they invested in the well. If they put up 50% of the cost of the well, they would get a 50% working interest. The working interest owner’s share of the revenue is determined by first subtracting the royalties paid from 100 and then multiplying the remainder by their working interest.

Example:
Assume a well has a 12.5% royalty and an overriding royalty of 3.0%. The royalties are paid first so this would leave 84.5% for the working interest owners.

100.0% – 12.5% – 3.0% = 84.5%

Owner Type Expense Pct Revenue Pct
Royalty 12.500%
Overriding Royalty 3.000%
Working Int 1 75.00% * 84.50% = 63.375%
Working Int 2 25.00% * 84.50% = 21.125%
Totals 100.000% 100.000%

Accounting 101 E-Book


Source: SherWare Blog

Spreadsheets Just Can’t Cut It

 

Spreadsheets have long been the go-to tool for oil and gas companies looking to track expenses and revenue because essentially everyone knows how to work a spreadsheet.

spreadsheetBut, if you’ve been using spreadsheets to track your distribution processes, you’ll have experienced at some point an error in a formula or the wrong cells copied over to the wrong column…. the possibiltiies are endless in the tiny, yet time-consuming-to-find mistakes that have been made.

Spend Less Time Fiddling with Spreadsheets

There’s a reason why spreadsheets are so popular across the business world. They’re no-frills and adaptable, so they’re a “good enough” solution for most businesses.

However, their strength is also their biggest weakness: they’re not specifically designed for any one industry.

That’s where oil and gas accounting software enters the scene to help with distributions and joint interest billing. If you’ve never considered it before, dedicated oil and gas software automates processes in a way that spreadsheets can’t match, saving you enormous amounts of time. In fact, once you get your software set up, you can track and list expenses, revenue, and distribution at the click of a button.

Or you could spend hours manually entering all of the information every month and praying the calculations were the same from the last time you opened the spreadsheet.

Keep Your Costs Low by Eliminating Mistakes

In big business, mistakes cost money. In the oil and gas industry, operator mistakes can lead to incorrectly reporting expenses and revenues, erroneously distributing incomes, or simply increasing accounting times.

All of these mistakes can be expensive. With a dedicated accounting software – unlike a spreadsheet – you can streamline the process and have in-system auditing. This ensures you don’t make mistakes, and also makes sure you keep your data safe and backed-up.

Spreadsheets, on the other hand, know nothing about your business. All they know is their own complicated formulas – so if you screw up, they won’t catch it…and neither will you, until it’s already cost you money.

Pick the Right Tool for the Job

Accounting for the oil and gas industry is a specialized beast. It takes specific tools and know-how, and it’s just not feasible for a generic spreadsheet program to give you all of the bells and whistles you need.

To read more about spreadsheet risk and some tips for using spreadsheets if you’re currently using them, check out our free Ebook: Spreadsheet Risk.

 

New Call-to-action


Source: SherWare Blog

Oil & Gas Accounting 101 – Leases

 

LeaseA mineral lease is a contract between a mineral owner (lessor) and a second party (lessee). The lessor grants to the lessee the exclusive right to drill for and produce oil and gas, or other minerals on the property described in the lease. A lease usually provides for:
  • Cash (lease bonus) payable to the lessor upon the execution of the lease and approval of title
  • A specified term of years, usually from three to ten years
  • Delay rental for each expiring year during which the lessee has not commenced drilling operations
  • Lease cancellation if the lessee does not pay the delay rental by the due date
  • The basis for division of oil and gas produced between the lessor and the lessee
  • Continuation of the contract between the lessor and lessee as long as oil or gas is produced from the property

The lessor’s share of the production is known as the royalty or landowner’s royalty. It is common for the share to be stated as a fraction of the oil and gas produced, for example 1/8. The lessee acquires the right to the oil and gas produced less the landowner’s royalty.

The lessee does not take on a specific obligation to develop the property or to pay delay rentals, but does agree that the lease will expire if the property is not developed or rentals are not paid. Normally the lessee can abandon the lease without penalty.

lease_example

When the landowner signs the lease, the owner will be given a “Bonus.” The bonus is a sum of money, agreed upon both the Lessor and the Lessee to be given on signing of the oil and gas lease. If there are producing wells near the land, the bonus is usually higher than when there is no drilling yet or none of the existing wells are not producing.

The length of time established in the oil and gas lease is called the “term.” This is the primary length of the lease. The term is usually a fixed length of time, such as one to five years.

Another part of the oil and gas lease is royalty payments. It is an agreed on percentage of the profits of the oil and gas. The lease will specify what, if anything, can be deducted from the royalty payments such as, severance taxes and/or gathering or marketing charges.

If the term of the oil or gas lease extends beyond the time that the bonus was paid, and a well was not drilled, then the Lessee is required to pay the landowner an agreed on sum. This sum could be $1.00 or more per acre. This is called a delay rental. The payment is due on or around the anniversary of the lease. Occasionally oil and gas companies pay this fee up front when an oil lease is negotiated and signed. The company’s failure to pay a delay rental on time cancels the lease.

Accounting 101 E-Book


Source: SherWare Blog

3 Reasons To Purchase Oil & Gas Software

For small or medium sized oil and gas companies, software is often an overlooked part of their business process. People often assume that software is too costly and does not provide a good return on investment (ROI). Here are some important things that aren’t always at the top of your list to consider when deciding whether to upgrade your current software systems that probably should be when dealing with oil and gas disbursement software.

1) Automation

SoftwarePurchase

If your business operates wells, tracking income and expenses is incredibly important. Without proper tracking and accounting integration, you could be setting yourself up for problems between your investors and well owners and other parts of the distribution chain – because it all comes down to one thing: accurate numbers.

If you can’t be sure that you 1) have all the pertinent bills, lease details, division of interest breakdowns and production receipts entered correctly for the month and 2) that your math to split it out evenly between 10 or 100 owners in a well is correct, then essentially the work you’re putting in is useless.

What good is it to you if you have the division of interest equations right to divvy up income flowing in, but some bills that were supposed to run through in April were entered with the wrong date and weren’t processed in April’s distribution that you just mailed checks out for?

While there are many things that software can do, the most important thing to look for in a software program is how it handles the data you enter. How much of the software is run on automated processes either you set up or are already set up within the software?

Are there checks in place to be make sure everything you’ve entered for the period you’re processing is showing up? How do you know if the division of interest has been added up correctly? Does the software automatically link bills to wells to owners or do you manually type that in? How much room for error is there?

2) Manage & Share Information

From well-specific to owner-specific information, data in your business needs to be accessible and available to interested parties. When considering a software upgrade, your data needs are nearly as important as managing distribution. The more parties which you need to interact with on a daily, weekly, quarterly or yearly basis, the more oil and gas software can produce positive results. The next thing you should consider is how easily can your data be shared with others?

What reports can be created? How quickly can they be reproduced? How will I get monthly distribution statements out? Can I email reports to investors when they call in? Can I create tailored reports for the accountant and COO to get the numbers they need?

What if I need to go back and look at reports from January? Will they still be available?

Getting answers to your questions regarding how proficient the software’s reporting capabilities are is paramount. Automation does you no good if it’s cumbersome to share the data with those asking the tough number questions.

And finally, your business’s need for information management needs to be balanced with your budgeting priorities. In order to decide when start with a new software program, you must address the price of software versus the cost of labor to manage your information without the software.

3) Profit Equation

For businesses, one of the chief ways to decide whether the cost of upgrades are worth more than the expense is through the simple accounting equation to analyze profits – income (or money saved) minus expenses (and labor) equals profit. Installing a new software system makes sense if the money saved (or earned) is worth more than the costs of installing and training on the new software.

So the final piece to look at, and the one that often is the only piece looked at, is to ask yourself, is it worth it?

How much time could be saved with new software? What personnel changes could I make with new software? Will I no longer need an accountant to handle this aspect of my business? Can my office manager finish disbursements in less time – leaving her more time to complete all the other tasks?

What costs can be saved by handling everything in one place? If I am able to handle AFEs, leases, directly deposit revenue into an owner’s account and no longer need to print and mail statements, for example, how much time, office supplies and money could I save per month?

Now the final question is does your current system for handling distributions and joint interest billing meet all of these requirements you’ve just answered for yourself?


Source: SherWare Blog

Oil & Gas Accounting 101 – Terminology

 

terminology

To be able to work effectively in Oil & Gas Accounting, you need to understand some of the terminology for the oil & gas industry. Here are some of the terms you’ll encounter…

 

  • Authorization for Expenditure (AFE) – A document shown to investors in a well that will estimate drilling and completion costs. An AFE can then be used as drilling occurs to show actual costs versus estimated costs.
  • Barrel (BBL) – The basic unit for measuring oil. A barrel is equal to 42 U.S. gallons.
  • Credit – The right side of an entry to the G/L.
    Crude Oil – Liquid petroleum as it comes out of the ground. Crude oil varies radically in its properties, such as specific gravity and viscosity.
  • Debit – The left side of an entry to the G/L.
  • Delay Rental – Paid to the lessee (person or company who leased the land to be drilled upon) to retain concession if production is not taking place on the land.
  • General Ledger – The main record keeping location for all debits and credits for the company (entity).
  • Intangible Drilling Costs (IDC) – All costs incurred in drilling a well other than equipment or leasehold.
  • Intangible Completion Costs (ICC): Costs incurred with completing a well that are nonsalvageable if the well is dry or not including labor, materials, rig time, etc.
  • Joint Interest Billing Statement – The monthly statement sent from the operator to all the working interest holder’s within an oil and gas property detailing the expenses charged each month.
  • Lease – A legal document specifying the right to the minerals in a certain piece of property.
  • Leasehold Costs – The costs associated with obtaining and keeping a lease on a parcel of land on which a well is drilled.
  • Legal Suspense – Amounts held in suspense instead of being paid to an owner. Reasons for holding the suspense could be they moved with no forwarding address, a title dispute on the lease or they haven’t reached the minimum check amount set by the operator.
  • MCF – Thousand Cubic Feet. The standard unit for measuring the volume of natural gas.;
  • Natural Gas – Hydrocarbons, which at atmospheric conditions of temperatures and pressure, are in a gaseous phase.
  • Owner Deficit – Amounts held in suspense when a working interest owner, who’s expenses are being netted from their revenue, has expenses that exceed their revenue.
  • Payout – When the costs of drilling, producing and operating a well have been recouped from the sale of the products of the well.
  • Posting – Entering transactions that debit and credit accounts in the general ledger.
  • Production Tax – A tax levied by the residing state on production in that state. Normally withheld from royalty and working interest checks.
  • Revenue Statement: The monthly statement sent from either the purchaser or operator to al the interest holder’s within an oil and gas property detailing the expenses and revenue charged or received each month.
  • Royalty – The landowner’s share of production, before the expenses of production.
  • Severance Tax – A tax on the removal of minerals from the ground. The tax can be levied either as a tax on volume or a tax on value. In Louisiana oil is taxed at 10 cents per BBL and Natural gas is taxed at 5 cents per MCF. This tax is normally withheld form royalty and working interest checks.
  • Spudding In – The first boring of the hole in the drilling of an oil well.
  • Tangible Completion Costs – Lease and well equipment costs incurred from completing a well.
  • Tangible Drilling Costs – Actual costs of drilling equipment.
  • Well – A hole drilled in the earth for the purpose of finding or producing crude oil or natural gas or providing services related to the production of crude oil or natural gas.
  • Working Interest – An interest in an oil and gas well that shares the expense associated with drilling, completing or operating a well, as well as the share in the revenue made on the well.

Accounting 101 E-Book

 


Source: SherWare Blog

Oil and Gas Accounting – Account for What?

As we’ve said in a prior post, “Accounting is Accounting”. This means that all accounting is essentially the same except for what you’re “accounting” for. What are you keeping track of? In the case of oil & gas accounting, you’re keeping track of wells that are being drilling and the products those wells produce over their lifespan.

In order to understand this accounting process, it’s good to take a look at how a well comes to be.

So how does a well get drilled? How do they determine where to drill the well? How are they sure where oil & gas will be found?

oilguys

An oil & gas operator will research different areas where oil & gas has been found in the past. But before they can begin drilling, they have to have permission to drill from the landowner and/or mineral owner where the well is to be drilled. They will need to get a Lease from the landowner and/or mineral owner in order to drill on their property. A lease is a legal document that spells out what the operator or owner of the lease will do for the landowner for the permission or right to drill wells on their property. There are also payments involved in order to get the lease. These payments consist of a lease bonus of so many $ per acre being leased.

Usually, in order to keep the lease until a well is drilled, the operator has to pay Delay Rental Payments to the landowner of so much per acre per year. This keeps the lease in effect until a well is drilled on the property.

Production from the well will be paid to the mineral owner, (hereinafter called the Royalty owner). The amount paid is typically 12.5% – 25% of the production before expenses.

Sometimes, the person who found the lease and did all the work in getting it signed, called the Landman, is paid by giving them a percentage of the production from the wells on the lease. This is called an Overriding Royalty. This percentage usually varies from 1% – 5%.

The people who provide the money to drill the well are called Working Interest owners. Their percentage is based on the amount of money they invested. Working interest owners share in the expenses incurred during the drilling and production phases of a well.

Find out more by downloading our free Oil & Gas Accounting 101 ebook below!

Accounting 101 E-Book


Source: SherWare Blog

Oil & Gas Accounting 101 – Revenue Accounting

One of the main tasks in oil & gas accounting is accounting for the revenue being produced by the wells and paid out to the owners. Here is where we start talking about debits and credits.

Before we get into debits and credits, let’s talk about the challenges of accounting for revenue in the oil & gas industry. In most other industries, the product is made, the price is set, then it’s sold and cash is received. The transaction is booked as a simple two-sided accounting entry debiting cash and crediting revenue.

revenueIn the oil & gas industry, we have to manage booking revenue for a product who’s price is a moving target and who’s inventory is mostly unknown. Oil and gas producers’ main assets are the minerals in place on the developed and undeveloped properties it holds. Most of these properties have been leased by the producers. These minerals in place are known as reserves. The accounting for oil and gas reserves requires the use of estimates made by petroleum engineers and geologists. Reserves estimation is a complex, and imprecise process.

Once properties are producing, the oil and gas reserves related to the producing properties will deplete resulting in a decline in production from the properties.

An independent oil and gas producer’s revenue consists primarily of:

  • Oil and gas revenue
  • Operating revenue
  • Income from the sale or sublease of property
  • Income from hedging transactions.

Let’s take a look at each of these.

Oil and gas revenue

For producers the majority of the oil and gas revenue will be in the form of working interest. Overriding royalties are also common, while landowner royalties are less common for exploration and production companies. Oil and gas revenue might also be in the form of a net profits interest and production payments.

Operating revenue

Some operators generate income from operating wells, supervising drilling, transporting gas, hauling and disposing salt water, and other activities incidental to their operations. Sale or sublease of property.Producers frequently sell or sublease property. Transactions include both developed and undeveloped property. Distinguishing between a sale and a sublease is critical for tax purposes.

Hedging transactions

Some exploration and production companies use derivatives in their operations to hedge risk associated with oil and gas prices. Derivatives are financial instruments whose values are derived from the value of an
underlying asset. Typically, oil and gas companies use futures, options and swaps.

Accounting 101 E-Book


Source: SherWare Blog

3 Reasons to Integrate Oil & Gas Software with QuickBooks

When considering accounting software for your oil and gas company, what makes the decision to integrate your internal software with Quickbooks® accounting software a good one?

A Quickbooks integrated software solution makes sense for your business when your accountant or bookkeeper uses Quickbooks, when Quickbooks is required for governmental reporting, or when key players use Quickbooks for their accounting needs.integration

Increase Communication

Integrating your software systems with other software programs or systems should be done when it increases communication internally (between departments, employees, etc.) and externally (between your business and your outside accounting firm). Integrating your business critical oil & gas software with QuickBooks helps with communication between you and your accountant since most accountants are familiar with QuickBooks and can actually restore your data and run the reports they need.

Increase Quality Control

The most important reason to integrate your internal accounting software with Quickbooks is to facilitate quality control processes between your business and your bookkeepers and accountants. With automatic integration, you reduce the chance of data errors or information loss between different wells, different departments and your final financial reporting for the month/quarter/year.

With the increased communication available through a Quickbooks and accounting software integration between your company and your accountant, communication gives your management tools to have accurate and real-time financial reports, manage long-term accounting problems and build predictive algorithms to predict financial returns.

Decrease Costs

Decreasing costs is every business owner’s quest. Costs are usually more under the business’s control than revenues are, so that makes cutting costs a priority. The first way that integrating your oil & gas software with QuickBooks reduces costs is in hiring. Bringing on a new employee is much easier if the accounting system is easy to learn or probably already known by the new hire. This has already been mentioned, but costs are lower when the information provided to your accountant at year-end is organized and in a format they can readily use. QuickBooks helps with this tremendously.

When to Integrate

Since the most important part of using internal software which integrates with external Quickbooks programs is improving your communication processes and systems, the most important question to ask is “Who needs the integration?”

Any software integration should promote communication, increase efficiency and decrease costs. If serving the right relationships, a Quickbooks integrated software system for your oil and gas software firm can increase quality communications.

SherWare’s Disbursement and JIB Manager Integrated Edition is the only oil & gas software that integrates directly with QuickBooks. It handles all the wells, owners and division of interests and let’s QuickBooks handle the accounting. Click the link below to learn more!

New Call-to-action


Source: SherWare Blog

Oil & Gas Accounting 101 – Chart of Accounts

Accounting for Oil & Gas requires a good set of accounts which are used to keep track of all accounting activities. This list of accounts is called the “Chart of Accounts” and will be every account needed for oil & gas operations accounting. There are two main sections of the chart of accounts, which are, Balance Sheet accounts and Income Statement or Profit & Loss accounts.

Balance Sheet accounts consist of categories such as Assets, Liabilities and chart_of_accounts Equity. Assets are items of value owned by the company. Liabilities are obligations of the company to transfer something of value, like an Asset, to another party. Equity is the value of the assets contributed by the owners of the company.

Income Statement accounts consist of categories such as Revenue, Cost of Goods Sold and Expenses. Revenues are the result of the sale of production, oil & gas, from the wells. Revenues can also result from services provided or the gains on equipment sold. Cost of Goods Sold are the costs related to the sales of production or services provided. Expenses are the costs incurred in order to operate the wells and company.

The accounts in the chart of accounts are crucial to good accounting. For every transaction in your accounting system, one account will be debited and one account will be credited. This keeps the accounting system in balance. For example, when you pay your telephone bill, you will take money from your cash account (credit) to pay the bill and you’ll recognize the telephone expense by debiting the telephone expense account for the same amount.

Account Date Debit Credit
Cash 04/23/2015 $385.90
Telephone Expense 04/23/2015   $385.90

The chart of accounts is the heart of the accounting system. Every transaction entered has to be tagged with an account so it knows where to post. Once the accounts are set up. They can be used to build the accounting system.

Accounting 101 E-Book


Source: SherWare Blog