The Integra Operating Company Solution provides oil and gas exploration, development and producing companies with an integrated suite of software components to manage the accounting and reporting needs of their organization. Integra is a configurable software system designed to meet the needs of small independents and individual operated property owners as well as enterprise-class organizations. Integra’s scaleable database architecture is offered in four editions that can meet the needs of one to hundreds of concurrent users with local and remote site processing.
The integrated nature of the Integra solution components allows our clients to configure a software solution to meet their individual needs and to enhance their solution as needs change. Efficient data entry allowing user, purchaser, & vendor sensitive screen configurations supports rapid entry of line item revenue and expense detail while capturing both gross and company share data for both operated and non-operated wells. CDEX & JIB interfaces provide an eCommerce alternative to manual data entry of revenue and expense line item detail. Integra’s integrated Database Explorer provides a unique management tool with drill-down capability to all master database and historical information retained by the system. Support for inter-company posting, document imaging, field capture, data exchange interfaces and electronic funds transfer add significant capabilities to your company’s information infrastructure.
The Integra General Ledger is a comprehensive financial management and reporting system that provides flexibility in recording and analyzing corporate financial activity. The General Ledger application is fully integrated with all Integra Energy Management System solutions and forms the core of Integra's financial & management information system. Integra General Ledger retains all detail financial transactions as well as account balance information on a fiscal or calendar year basis.
Organizations chart of accounts can be shared by more than one business entity using the system. Integrated financial reporting allows you to produce standard financial reports such as the Statement Of Operations, Cash Flow and Balance Sheet reports. Integra General Ledger provides flexibility in financial analysis reports with features such as the inclusion of comparative period information with percentage change or 6 and 12 month Profit and Loss and Balance Sheet comparative reporting.
Historical activity is maintained for all detail transactions and account and sub-ledger balances for any defined period of time allowing unlimited retention of prior period financial records. Integra incorporates on-line inquiry of financial balances by account and sub ledger with integrated drill-down to detail level transactions for any time period.
Eliminating archaic requirements to print paper reports and perform monthly "summarizations" or "closings" are benefits of the open period design of Integra's general ledger database. By customizing the chart of accounts and associated financial code "printing instructions" the system can generate financial reports with multiple levels of detail.
Integration with Integra's Oil & Gas Property Ledger application as well as organization-defined Cost Center and Subsidiary Ledger posting allows Integra General Ledger to perform accounting functions that meet your organizations unique needs. By encompassing basic financial data retention and standard financial reporting as well as comprehensive comparative and consolidated financial reporting, Integra General Ledger can meet your most demanding needs.
- Detail General Ledger Reporting
- Detail Account Inquiry
- Account Balance Inquiry
- No Monthly Closing Required
- Consolidated Financial Reporting
- Comprehensive Financial Reporting
The Integra Property Ledger provides financial reporting capability on a property (lease and/or lease/well) level. Information is automatically posted to the Integra Property Ledger system when entering transactions in other Integra Oil & Gas Accounting applications.
The Integra Property Ledger system works in conjunction with, and as a special sub-ledger to, the Integra General Ledger. Property trial balances are maintained and provide since inception reporting on a property level basis for the owner's share. As a sub-ledger of the Integra General Ledger system, the property ledger is open for all years of history in open item detail format for posting and reporting purposes. The system allows on screen inquiry by property to each detail transaction coded in the system or to the property ledger balances by month and year.
The system optionally allows you to maintain detail and/or summary information online for as many years as you need for future analysis. The historical periods are not immediately available for direct posting or reporting options but on screen inquiry provides quick access to this data. The Integra Property Ledger system produces several cash flow reports and financial property management reports. Property income and expense reporting is available and summary and detail property ledger reports may be produced. The Integra Revenue Entry & Validation application will work in conjunction with the Integra Property Ledger system to produce Net Comparative Lease Operating Reports.
The Integra Joint Interest Billing and Integra Revenue Distribution modules will interface to allow 100% comparative reporting options. State property ledger reporting is available to help prepare tax returns for owners who have production income and expenses in different states. The system allows multiple reporting options and generous selection criteria for extracting reports. Comprehensive audit trails are included as well as password security features to protect your records from unauthorized access.
- On-Demand Reporting & Inquiry Detail Property Ledger Reporting
- Consolidated Property Reports
- 100% Lease Operating Report
- Net Lease Operating Report
The Bank Reconciliation application is designed to automate the process required for reconciling bank accounts maintained within the Integra Energy Management System. This application allows for multiple bank accounts to be set up and maintained within the system. The system allows users the ability to either manually clear checks through the system or alternatively electronically clear checks processed through the system. Users that can receive statement information from their banks via electronic media (i.e. diskette, download file) have the ability to set up multiple data formats for receiving and processing this information. These formats define the data and its structure to the system allowing the user to electronically clear items in the system, greatly reducing the amount of time spent manually clearing the items. Generally the only information available from the bank on electronic media is cleared check detail.
The Bank Reconciliation application will interface with the Accounts Payable application, the Revenue Distribution application, the Land Management application, the Payroll application and the General Ledger application. When final processing is completed for a check and/or posting process in each of these integrated applications, the items are transferred to the Bank Reconciliation application and stored in a detail items file for clearing and account reconciliation. Other types of items in the detail items file would be entries such as, deposits, interest/other credits, service/other charges, generic debits or credits and wire transfers.
The system maintains a current checkbook balance which is updated as checks are final processed in the system and deposits and other items are recorded in the Bank Reconciliation system. The items are cleared in the system either through an electronic or manual process and a reconciliation procedure is performed when the physical statement arrives from each bank for each account. The reconciliation process is performed at the statement and checkbook level. The system provides multiple reports with many options providing the user the ability to review the clearing process, the reconciliation process and the detail items as necessary for analysis functions.
- Unlimited Bank Number of Bank Accounts
- Electronic Clearing of Transactions
- MICR Check Printing
- ACH/EFT Transaction Capability
The Integra Accounts Payable application provides for the management and control of accounts payable functions. The system provides for entry and posting of payable invoices and manual checks and interfaces to the Integra Joint Interest Billing for billing of joint billing expenses.
Integra Accounts Payable is an open-item invoice system with an internal vendor detail history file for duplicate invoice checking and invoice history analysis. Aged accounts payable reporting of open invoices in detail or summary format by vendor, due date and other criteria may be produced as well as past due invoice reports and cash requirement analysis. Detail Payment history file maintenance allows for detail analysis of vendor payments and proper reporting for 1099's. Summarization options allow for yearly summary procedures for maintaining prior year balance information and current year detail.
Selection of open item invoices for payment is available by picking invoices by vendor number, type, due dates, invoice dates, amount ranges, invoice number, line item number, or other method or combination of all available options. Discounts will be computed and deducted and can be either amount or percentage based with due dates automatically controlling application of discounts at payment time, with an option to manually override the process and force discount application. Integra Accounts Payable allows transaction entry by batch and provides editing for each batch of entries before posting is allowed to your cumulative open-item payable file and detail history file. Integra Accounts Payable will optionally generate general ledger accounting entries for your transactions and at invoice payment time will generate general ledger accounting entries for invoices paid and discounts taken.
Integra Accounts Payable application supports an automated accounts payable check voiding function. This allows the user to void checks that have been printed and posted as payments in the historical files. When the checks are voided the original invoice is re-created in the open-item file allowing the system to remit payment at a later date or a credit transaction may be entered and posted to clear the item. The Accounts Payable application will integrate with other Integra applications or you may run the system as a stand-alone operation. Comprehensive audit trails are included as well as a sophisticated password security feature to protect your records from unauthorized access
- Duplicate Invoice Detection
- Data Entry Screen Tailoring
- Flexible Check Selection Options
- Spreadsheet Invoice Upload
- Void Check Processing
- Separate Vendor Checks Feature
- Manual/Hand Check Processing
- Multiple Addresses/Vendor Allowed
- Vendor/Invoice Exception Detection
- MICR Checks/EFT
Joint Interest Billing
The Integra Joint Interest Billing system provides for entry, posting and tracking of joint billing expenses, joint owner invoice payments and owner pre-payments. The system is a comprehensive billing and invoicing system with an integrated accounts receivable application providing aged owner statements and accounts receivable analysis reporting. Integrated minimum billing and JIB suspense capabilities are included.
A flexible division-of-interest file allows multiple effective date divisions of interest decks per property with no limit on the number of owners per deck and incorporating a direct owner billing feature that allows invoicing owners directly without allocation via the decks.
Flexible owner pre-payment tracking is provided with automatic application of pre-payments to current owner invoices. The system maintains open item invoice detail and will produce owner statements showing open item detail or balance forwards that include opening balance, current payments, invoices and a new owner balance. The Integra Joint Interest Billing system maintains Billing Allocation Groups for distribution of charges between properties with multi-level allocation processing. Direct decimal percentage allocations or basis factor allocations are supported.
The Integra JIB system maintains a 100% billed item history database. The Integra Joint Interest Billing system is designed to allow deleted interest ownership in the joint interest billing system. This feature allows paying items for the actual amount, but lets the system "gross up" these charges to an actual 8/8's amount for 100% comparative reporting.
A flexible division-of-interest file allows multiple effective date division of interest decks per property. There is no limit on the number of owners per deck and incorporating a direct billing feature allows invoicing owners directly without allocation via the decks.
The system supports affiliate inter-company transaction processing for affiliate entity books setup within the Integra Energy Management System. Comprehensive audit trails are included as well as a sophisticated password security system to protect your records from unauthorized access.
- Effective Dated Billing Decks
- Inter-Co Affiliate Processing
- Multiple Invoice Formats
- Multiple Statement Formats
- Transaction Spreadsheet Upload
- Owner Pre-Payment Management
- Multi-Tier Allocation Handling
- Global Ownership Transfers
- Collated Statements, Invoices, Prepayments
- Ability to Email Invoices & Statements
- JIB Owner Netting Options,
The Integra AFE Tracking and Reporting application provides for budgeting and control of producing property capital costs and expenses from drilling through completion. The system integrates with Integra Accounts Payable and Integra Joint Interest Billing modules to track billable well expenses by category. Additional integration with Integra General Ledger provides non-property based "General" AFEs for tracking capital costs and expenses by general ledger account.
The Integra AFE module is a comprehensive expense budgeting and tracking system with flexible cost (expense vs. budget) categories for property level AFEs. General AFE information is tracked in the Integra General Ledger detail databases and may be accessed via integration with the Integra AFE application. Information relating to spud date, casing-point date, completion date, depth, etc. are maintained for each property based AFE.
Several major AFE cost categories are identified within the system as follows: Intangible Drilling, Tangible Drilling, Intangible Completion, Tangible Completion, Leasehold, Intangible Workovers, Tangible Workovers, Plug & Abandon. Each of these major cost categories may have multiple subsidiary cost categories for tracking budget and actual cost information. You may maintain primary and secondary budgets for each AFE category within the system. The integrated well history feature allows tracking detail historical cost information for each property via the Integra Joint Interest Billing system.
By defining AFE cost category relationships with corresponding JIB billing categories, automatic posting of property costs to the AFE balance databases will occur and corresponding well history databases will be posted via Integra Joint Interest Billing and Integra Accounts Payable.
Integra's AFE pre-budget posting and capture feature will track cost detail information prior to cost category budget setup. This feature will insure that no AFE costs will be missed during the pre budget period and you may specify the budget information after cost tracking has begun.
The system can produce multiple management and operational level status reports showing detail or summary budget vs. cost comparisons with over and under variance amounts and percentages by primary or secondary budget. You may print for mailing each AFE with a breakdown by Working Interest partner or investor with each participant's share of the AFE printed along with a signature block for AFE approval via integration with Integra Joint Interest Billing.
- Unlimited Active AFEs per Property
- Configurable AFE Category Codes
- Drilldowns to Transaction Level Detail
- AFE Variance Reporting
The Integra Revenue Entry & Validation application provides oil and gas revenue verification and flexible reporting options to help oil & gas property owners verify they have been paid properly and book income and deductions. The system is capable of identifying division order records with no income received because each division order record keeps track of the last payment date per interest type. The division order payment date is updated once information has been fully processed for a month.
Users can enter oil and gas sales directly from the purchaser check stub in the format reported by the purchaser, either gross or net share. The system allows you to customize and save an input screen to match the information given by each purchaser's check stub. This will allow you to enter into the system only the information reported to you on the purchaser's check stub in the order that it is reported. The module has an on-screen verification feature for cash received based on your interest in each property. Your share of revenue and deductions are posted to the cumulative oil and gas sales history files where current and historical data is saved and may be retrieved for reporting purposes. If you have Integra CDEX (Check Stub Data Exchange) installed, you may download your revenue detail items and the information can be fed directly into Integra Revenue Entry.
Integra Revenue Entry & Validation produces a wide variety of oil and gas sales reports with detail by production or accounting date as well as summary and detail reports by property or purchaser. Flexible reporting dates and options, including interest types and products, are available for reporting. This provides access to the information stored in your historical oil & gas sales file. Recap reports are available by production or accounting date showing a twelve-month analysis of information stored in the system. Integra Revenue Entry & Validation will generate general ledger accounting entries for your oil and gas revenue items and deductions through the Integra General Ledger. Comprehensive audit trails are included as well as a password security system feature to protect your accounting records from unauthorized access.
The Integra Revenue Entry & Validation application interfaces to the Integra Revenue Distribution system for distribution & allocation processing functions. The system allows for combined entry of direct and distributable information and will process the transactions and send the information to the appropriate module for further posting or processing. The Integra Revenue Entry & Validation module incorporates enhanced revenue verification functions that allow for the entry and maintenance of proper 8/8's information in situations where there are gas balancing or exempt ownership problems related to the verification and processing of sales transactions
- Purchaser Specific Entry Screens
- On-Screen Verification of Revenues
- Revenue Accrual Capability
- No Income Received Reporting
- CDEX (Check Stub Data Exchange)
- Accounting/Production Date Handling
- Revenue History Inquiry
- Receipt Decimal Validation
- Purchaser Cross Reference - Division Order File
- Diverse Reporting Options
Integra Revenue Distribution provides for entry, editing and distribution of received revenues and related deductions on oil and gas properties. The system can verify and distribute gas and oil revenues based on receipt decimal interests that may not reflect the legal interest owned in the property.
Distribution processing allows effective date and scaled deck distributions so each owner's interest can be automatically inflated or deflated based on the nature of the transaction. Out of Pocket Tax and Out of Pocket Royalty payments may be entered and processed in advance of actual check receipt for Federal and State Entitlement Royalty owners where there is a requirement to pay the owner by a set time. Integra manages proper distribution when the Royalty Burden is not proportionate to the working interest ownership. Suspense processing and Owner Payment functions are separate from the distribution phase enabling owner payments via Check, EFT or Wire Transfer on demand with multiple payment selection capabilities.
The system supports a production tax rate file for 8/8 production tax calculation by component with historical production tax tracking. State level minimum pay limits with owner overrides per State and legal suspense and minimum pay suspense capabilities, reclassification of legal, minimum and force pay items and automated transfer and reallocation of suspense between owners is included.
Date effective division of interest decks allows multiple divisions of interest per property with no limit on the number of owners per deck. Owner exemptions for production tax, windfall tax and other charges are provided. A deleted interest processing is incorporated to facilitate distribution of revenue when less than 100% of the gross revenue is being distributed. Ownership interest transfer and division order preparation capabilities allow mass-changing ownership decks to reflect new ownership when a sale, assignment or death occurs.
Comprehensive batch revenue item entry & verification is provided as well and integration with the Integra Revenue Entry application. Integra's financial system integration generates general ledger entries for distributed revenue, production tax and operator's share of revenue. Company net and distributed owner revenue records and 8/8 revenue history are retained by the system. Comprehensive inter-company posting supports affiliate company processing and allows for multi-level distribution capabilities so affiliate companies can re-distribute income received from a parent company.
- Effective Date Ownership Decks
- Global Ownership Transfers
- Global Suspense Transfers
- Division Orders Generated
- Void Check/1099 Processing
- MICR Checks/EFT
- Multi Level Allocations
- Escheat Handling
- Spreadsheet Upload Interface
- Flexible Distribution Select Options
The Integra Payout Reporting application is designed to provide payout information by property and phase. The Payout application allows identification, tracking and reporting of payout recovery information. Integra Payout extracts information from the Revenue Distribution and Joint Interest Billing applications for calculation, on screen inquiry and partner reporting.
Integra Payout allows for balance forward data entry and extraction of historical information based on the Payout Phase setup. These options allow users to implement the system and capture the payout data for prior periods. The system allows for extraction by Property/Phase, Property ranges, date ranges and by Property Groups. These flexible extraction criteria allow prior period information to be re-extracted if adjustments for revenue or expenses are processed by the system.
Payout Phase setup criteria allow selection of income and expense information based on user defined date range options. Per Payout Phase detail information also includes the NRI decimal to be applied to the net 8/8's revenue information to determine the Payout Recovery Net Revenue to be applied to Penalty Adjusted development and/or operating expenses for proper payout recovery calculations. The system allows for multi-phase payout calculation and processing where there are multiple payout conditions for the same property.
Owner detail information is maintained to allow tracking of owner before and after payout net revenue and net working interest information. This information will be useful in re-establishing correct billing and distribution deck ownership once payout recovery is reached. Owner payout schedules may be produced on demand for all owners designated to receive payout schedules. Owner level schedules are printed by property/phase with owner address information included to facilitate mailing.
A comprehensive Payout Balance database is maintained to allow you to query and review both the "activity" payout status and the "published" payout status. The differences between the "activity" balance information and the "published" reporting period information represents prior period adjustments to revenue and expenses. This ability to track "activity" balance information based on the receipt of transaction information versus the "published" owner information allows Integra Payout to provide a consistent owner reporting capability while maintaining your ability to review actual payout activity balance information. On screen inquiry allows review of the monthly and cumulative payout information for either the owner published balance information or the actual "activity" balance information.
- Payout Tracking by Property/Phase
- Multiple Payouts per Property
- Extraction of Revenues & Expenses
- Flexible Penalty Provisions
- Date-Sensitive Net Revenue Factors
- Activity & Published Payout Tracking
- Prior-Period Extraction Capability
Integra Depletion provides comprehensive calculation and reporting of both cost and percentage depletion and may be used in conjunction with Integra General Ledger and Integra Revenue Entry applications or as a stand-alone application.
Cost depletion is defined as the process of expensing leasehold costs incurred on a lease, at a rate based on the amount of oil and/or gas produced each year. Percentage depletion is a statutory deduction currently defined as a fixed percentage (i.e. 15%) of gross income from oil or gas sales, and may be limited to 100% of the net income from the oil and gas produced. If the average daily production of the lease is less than or equal to a specified per barrel limit (i.e.15 barrels), then the lease qualifies as "stripper" and may be eligible for a higher depletion factor.
Integra Depletion also manages state depletion factors, as they often vary from the federal percentages. Each depletion calculation is computed on a type interest basis at the federal and state levels. The deductible amount allowed is the higher of the cost or percentage depletion. When Integra Depletion is integrated with Integra General Ledger and Integra Revenue Entry, volumes and amounts can be imported and transferred directly from the Revenue and General Ledger applications. These imported values are stored in the Integra Depletion master database and maintain information for each depletion income and expense category on a per lease basis.
The system will allow you to combine multiple properties to a single Depletion Property number for calculation and reporting. The system will produce cross-reference lists for you to coordinate your property roll-up scenarios. Depletion Account number and Property classifications are codified in the General Ledger and Revenue Entry systems so that the proper values may be extracted into the Depletion database for calculation and reporting. General Ledger and Revenue Entry data import interfaces facilitate the depletion calculation processes by importing data from those applications. Overhead cost accounts identified in the Chart of Accounts may also be extracted and apportioned to the leases with several overhead allocation methods available. Once all depletion related data are imported or entered and overhead allocated, both cost and percentage depletion can then be computed and is available for subsequent inquiry and reporting.
- Cost and Percentage Depletion
- Marginal Prod. Depletion Feature
- 1,000 Barrel Per Day Allowance
- Federal/State Reporting
- General Ledger
- Property Ledger
- Bank Reconciliation
- Accounts Payable
- Revenue Entry