Division of Interest File

Parent Previous Next

Division of Interest File

File Maintenance Structures ››

Parent Previous Next

Division of Interest File

Each Unit has many Owners.

Each Unit must have the Owners Percentage assigned to it in the Division of Interest File. 

See Oil & Gas Business for Dummies 


TIME SAVER

You can also use the Quick Copy Tool, to quickly copy DOI Owners from One Unit to Another Unit.


Select File Maintenance - Division of Interest



The Division of Interest file stores each owner’s percentage of ownership in a particular unit.  The year to date 1099 values for gross revenue and taxes along with the year to date expenses is also stored in the DOI file, under View/Adjust JIB Values.  The DOI file contains year to date cumulative  Government Form 1099 values for expense, revenue and tax for each owner on a unit.  This file is updated after each update of Operating Statements.  If you entered DOI user defined descriptions in Setup Options program under File on your tool bar, the descriptions will print on each DOI report.  Be sure to change any percents for a different owner.  You have a feature located under View button that will allow you to print, or not to print, for Inactive Wells on your DOI report.  You must check your Unit/Well file to insure that the ‘Close Unit’ field is marked before you use the ‘Print Inactive Wells’ field in the DOI.  If you do want this ‘Inactive Well’ to print, you must insure that on the Filter tab ‘Print Inactive Wells’ is marked.  If you do not, the DOI looks in the Unit/Well file for any wells marked ‘Inactive’ and does not print on the report.   


You can also use the Quick Copy Tool, to quickly copy DOI Owners from One Unit to Another Unit.


OWNERS THAT HAVE BOTH WORKING INTEREST AND A ROYALTY INTEREST MUST HAVE TWO DIFFERENT OWNER NUMBERS SET UP IN THE OWNER FILE.  The IRS requires separation of the revenue on Government Form 1099 forms at the end of the year. 


Note: In order to display all records of a file, the Filter conditions must be blank, otherwise it will only list records that were contained in the previous filter.


NOTES ON FIELDS



OWNER NUMBER: Owner number assigned in the Owner/Customer file.   


UNIT NUMBER: Well number assigned in Unit/Well file.  An owner that has an interest of revenue, tax and or expense must be assigned for each unit in the Division of Interest file to calculate their share for Operating Statements.   


COMPANY INTEREST: Used to determine if this owner has any company's interest in this unit.  Normally owner numbers from 99990 to 99999 are used for company interest.  If this field is checked the revenue, tax and expense interest for each transaction status is used to calculate the P & L report for the company interest.  Values for the Company Interest P & L report are stored in the Unit Chart of Accounts and are updated when you close the period. 


SUSPENSE:  Specifies whether or not the owner is on suspense for this unit.  If checked, revenue checks, from Operating Statements, are held in suspense and not issued to the owner until his suspense is unchecked.  An owner’s suspense status may be changed in the DOI file or in the JIB program on your tool bar under Tools for Statements.  See How to Use Suspense for more info.


NET OUT: Specifies net out condition for this owner on this unit, provided the netout field in the Owner/Customer file ="E" (each unit is to be netted on an individual basis). If the netout field in the Owner/Customer file is="E" and the netout field here in the DOI file is checked, current expenses and prior invoices for this unit are deducted from revenue for this owner on this unit.  If the netout field in the owner file is anything other than "E", this DOI netout field is not recognized and has no effect.   See How to Use NetOut's for more info.


OWNER TYPE (W/R/O): Working interest, royalty or override owner. 


ORIGINAL PRE-PAYMENT: This is the original pre-payment amount advanced for any expenses to your company.  Enter prepay balances in the JIB program on your tool bar under Tools for Statements, Add Prepayment.  This program will automatically update the DOI file, Bank file and the Transactions file.  To view an owners prepay balance view/print the prepayment report under JIB, Other Report then Prepayment.  You may also refer to the ‘Add Prepayments’ under the JIB section of the Manual.  


SUSPENSE BEGIN: When an owner is placed on suspense, you must specify a beginning suspense date.  The Non Released Suspense report can not be run without a beginning suspense date, since this date is used to gather the records from the Transaction file.  See How to Use Suspense for more info.


SUSPENSE ENDING: When an owner is released from suspense the current months first transaction date less 1 day is plugged into this field.  The date is used to print the Released Suspense report. You do not enter the suspense ending date; Derek will plug the correct date into this field when operating statements are updated.


PERCENT OF OWNERSHIP FOR EACH STATUS: These values are used to calculate the owner's share of revenue, taxes and expenses for the Owner’s Share by Unit report and when printing Operating Statements.  The percentage that will be used is determined by the status field used when entering a transaction for general ledger numbers 3xxxx, 5xxxx, 71xxx-75xxx with a unit number.  For example, if you use a status of 3 for a revenue, tax or expense transaction, then percentage level 3 (rev3, tax3, and exp3) is used for all owners under that status in the DOI file for that unit.


ADJUST OWNER 1099 VALUES



GROSS REVENUE RELEASED YTD: Reflects the gross amount of year to date revenue released for this owner on this unit.  This field is updated each time you run the Operating Statement update. 


TAX RELEASED YTD: Reflects the amount of year to date taxes - production taxes, severance taxes, (not federal or state tax withheld) released to the owner.  This field is updated each time you run the Operating Statement update. 


71 EXP YTD, 72 EXP YTD, 73 EXP YTD, 74 EXP YTD and 75 EXP YTD: General ledger numbers 71000 through and including 75999 are considered as billable expenses to owners.  Therefore, all debits and credits made to these general ledger numbers are used to determine expenses for the owners during printing of the Operating Statements.  They are categorical expense fields and are updated each time you run the Operating Statement update. 


LTD SUSPENSE NET REVENUE VALUES: This is the gross amount of revenue minus (federal backup withhold amount and or state tax withhold amount if any) and the gross taxes, for life to date.  These fields are updated during the Operating Statement update and are triggered from the field suspense in this same DOI file.  When an owner is taken off suspense, these fields are cleared and the life to date net revenue in suspense is placed in the gross revenue year to date 1099 values.  You should print the Non Released Suspense report from the JIB program on your tool bar under Other Reports and compare it to Trial Balance general ledger number 21010.  These totals should always agree.  If an owner has federal or state tax withheld, is in suspense or has minimum check amount, the federal or state tax withheld amount will be updated to gross revenue released year to date when Operating Statements are updated.  Net suspense or minimum check amount is minus federal or state tax withheld.  Federal and state tax amounts will be stored in the Owner/Customer file for 1099 printing. See How to Use Suspense for more info.


LTD SUSPENSE TAX SUSPENSE VALUES: These fields reflect an owner’s tax in suspense for life to date.  Just like the suspense revenue fields, these fields are updated during the update for Operating Statements, and are triggered from the suspense field.  When an owner is taken off of suspense, these fields are cleared and the life to date amount is added to the tax YTD 1099 Values date field.  See How to Use Suspense for more info.


PREPAY BALANCE: Reflects the Owner's balance left in Prepay.



COMMENT:  Any comment for this owner on this unit.   



Related Topics

How to Navigate the Master Files  ~  Oil & Gas Business for Dummies  ~  How to Use Suspense  ~  How to Use Net Out  ~   How to Refund a Prepayment  ~   Government Forms

Created with the Personal Edition of HelpNDoc: Generate Kindle eBooks with ease