ISI Software Oil & Gas System

 

Section 3 - Sample Forms

A. Chart of Accounts Update Form 
B. Company Identification Masters Update Form 
C. Name & Address Masters Update Form 
D. Lease Masters Update Form 
E. State and County Masters Update Form 
F. Field Masters Update Form 
G. Control Records 
    1. Source Codes and Descriptions Update Form 
    2. System Generated Batch # Descriptions 
    3. Printer and Date Defaults 
        a. Enter the Work Station ID and associated Default Printer ID. 
        b. Enter the number of days for the default report date. 
    4. Options 
    5. Reserved 
    6. Accounts Receivable Account Numbers 
    7. Accounts Payable Account Numbers 
    8. Cash Account Numbers 
    9. Lease Primary Account Numbers 
    10. Name and Address Primary Accounts 
    11. Net Amount Primary Accounts 
    12. Gross Amount Primary Accounts 
    13. AFE Number Primary Account 
    14. AFE Description By Type 
    15. Plug '00000' to DV/BR# 
    16. Currency Conversion 
    17. Omit plug of DV/BR of “00000” to Cash 
    18. Overhead Co/DV/Br Billing 
    19. Type of 1099 
    20. 1099 Transmitter Record 

 

 

 

A.          Chart of Accounts Update Form

 

Account Number                __-____ (7 char)

Description                  ________________________ (24 char)

P&L Code                     _____                

Category Code           ______     1099 Code                    ___

Comments:_____________________________________

 

Category codes:

Position 1

Positions 2&3

Positions 4-6

Positions 4-6

N=Non producing

WI=Working interest

OIL=Oil income

EQP=Equipment or tangibles

P=Producing

RI=Royalty interest

GAS=Gas income

DHC=Dry hole cost

 

MI=Mineral interest

PLT=Plant products income

LOE=Lease operating expense

 

PP=Prod. payment

OTX=Oil production tax

COM=Compression Charges

 

NP=Net profits interest

GTX=Gas production tax

DHY=Dehydration Charges

 

 

PTX=Plant products tax

HDL=Handling Charges

 

 

WPT=Windfall profits tax

MSC=Miscellaneous

 

 

LHC=Leasehold costs

STR=Severance Tax reimbursement

 

 

IDC=Intangible costs

DPL=Accumulated Depletion

 

 

 

DPR=Depreciation expense for Lease/Well Equipment

 

1099 codes:

Position 1

Position 2

Position 3

C=Credit acct

M=Miscellaneous

User defined. Example:

D=Debit acct

S=Select and use the debit account

D=Dividend

A=Non-employee compensation

R=Rents

C=Non-cash dividends

D=Cash dividends

E=Stock bonus

T=Prizes, awards, travel

 


B.          Company Identification Masters Update Form

 

Company Identification #               ___-____-______

 

Company Name          _________________________________________

 

Name and Address Number          ____________

 

Fiscal Year Starting Month          _____          (MONTH 01 - 12)

 

Type of Entity                     __                           (I,P,C,F,T,E,N,O)

I = Individual                                                F = Feduciary

P = Partnership                                T = Trust

C = Corporation                                E = Estate

N = Non-profit                                O=Other (Exempt from Oklahoma Royalty Withholding Tax)

 

Date Originated                                            _____(MMDDYY)

Tax Basis Accounting Method                                                  (A,C,O)

A = Accrual (Record Income when billed)

C = Cash (Record Income when Received)

O = Other

 

Net Income GL Account                                __-____

Oil & Gas Accounting Method                _                (FC,SE)

FC = Full Cost

SE = Successful Effort

 

Payroll Wage Expense Account #                ___-____

 

Company ID to Charge

Payroll Expense (Co/Dv/Br)                           __-__-___

Revenue Application Basis(A,C,O)                _

A = Accrual (Record Income when billed)

C = Cash (Record Income when Received)

O = Other

 

Suppress sub-ledger for A/R                __ (Y/N)                A/P                __ (Y/N)

 


C.          Name & Address Masters Update Form

 

Name & Address #                                              ______________

 

Name                                                                      __________________________________

 

                __________________________________

 

                __________________________________

 

                __________________________________

 

Care of                                                                   ______________________________

 

Address                                                 ______________________________

 

City, State, Zip                                                          _______________________  _____ 

 

Phone Number  A/C, phone                     (_______) _____-________ Ext ___

 

Fax Number    A/C, phone                     (_______) _____-________

 

Insurance Date                                                     ____/____/____

 

Social Security #                                              _____________________(Negative if Fed I.D.)

 

Affiliated Co/Dv/Br                                               ___________  _____________________________

 

Bank Charge                                                   ____.__

 

Production                           (edit)                _                (digit)                _                (WPT)                _   (gas producers report)

 

Receive 1099?  __                (N=no Y=yes A=NEC 1099 R=rents T=Prizes, awards, travel)

 

Type of entity (I/P/C/F/T/E/N/O)  __  (see CO/DV/BR form)

 

Name alpha field                                        _________________________________________

 

“X” will omit printing on (OW67) Suspense by State.

 


D.          Lease Masters Update Form

 

Lease Number                                  _______

Lease Name                                      ________________________

State Code                                       __

County Code                                       ___

Operator #                                              _______

Field                                                       _____                                    No. of Wells                      __

Oil Type                                 _                                              Gas Type                       _

P = Primary                                T = Transferred

S = Secondary                                R = Regulated

 

Production Date                  __/__/__                              Date Acquired                              __/__/__

(MM/DD/YY)

Contract Date                                        __/__/__                              Lease Severance                _____

(MM/DD/YY)                                                                                     Tax Rate

Gas ID Number                  ________                           Purchaser #                         _______

User Data                                        ____                                       Old Ac. Code                       _____

                (Reserved for future use)

Fastax Number                                  ___                                         1st purchaser Oil                _(Y/N)

Gross Acres                                     _____

Prospect #                                              _____

Our Working Interest                  _.________

Our Revenue Interest                  _.________

Oil Reserves                                              _________.__

Gas Reserves                                              ___________

Total Revenue Interest                  _.________

Before Payout

Total Revenue Interest                  _.________

After Payout

 Allocatable Code                                                _

Exploratory/Development Code                _

Active/Inactive Code                                       _

 


E.       State and County Masters Update Form

 

State, County Code                       __                ___(000 county for state records)

 

Description (State or county name is automatically displayed)

 

Base Wages for

State Unemployment                     _____.__

 

State Unemployment

Tax Rate                                 ___

 

Employer's State

ID Number                                             ______________

 

General Ledger Account

for State Withholding                         ___-____

 

 

Note : No data may be changed on county records. Unemployment and withholding data is only contained in state records with 000 county codes.


 


F.       Field Masters Update Form

 

State

Field Code

Field Name or Description

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


G.          Control Records

 

1.            Source Codes and Descriptions Update Form

 

KEY                *AR00500 - One record contains all source codes.

KEY                *AR005__ - Add source code to end of key for individual source code

description records.

 

 

COLUMN                SOURCE                DESCR IN                            COLUMN             SOURCE                DESC IN

FROM TO                CODE                     COL 11-26                            FROM TO          CODE                     COL 11-26

 


1.        11-12     __     _______________

2.        13-14     __     _______________

3.        15-16     __     _______________

4.        17-18     __     _______________

5.        19-20     __     _______________

6.        21-22     __     _______________

7.        23-24     __     _______________

8.        25-26     __     _______________

9.        27-28     __     _______________

10.      29-30     __     _______________

11.      31-32     __     _______________

12.      33-34     __     _______________

13.      35-36     __     _______________

14.      37-38     __     _______________

15.      39-40     __     _______________

16.      41-42     __     _______________

17.      43-44     __     _______________

18.      45-46     __     _______________

19.      47-48     __     _______________

20.      49-50     __     _______________

21.      51-52     __     _______________

22.      53-54     __     _______________

23.      55-56     __     _______________

24.      57-58     __     _______________

25.      59-60     __     _______________

26.      61-62     __     _______________

27.      63-64     __     _______________

28.      65-66     __     _______________

29.      67-68     __     _______________

30.      69-70     __     _______________

31.      71-72     __     _______________

32.      73-74     __     _______________


Note: All source codes are placed in one record using record key *AR00500. Corresponding source code descriptions are placed in separate records. For example, the description for source code 10 is 'Cash Receipt' and is entered in columns 11-26 of a separate control record with a key of *AR00510.


 

Enter "Source Codes" in columns 101-128 to identify the records.


2.            System Generated Batch # Descriptions

 

BATCH DESCRIPTION                                                                                BATCH DESCRIPTION

KEY        COLUMNS 11 - 44                      KEY                COLUMNS 11 - 44

 


*GL00901                A/P computer checks

*GL00902                A/P hand checks

*GL00903                Payroll journal entries

*GL00904                Billing journal entries - LOE

*GL00905                Billing journal entries - A/R

*GL00906                Cash receipts

*GL00907                Revenue checks

*GL00908               Revenue minimum pay and suspense

*GL00909               Gas production tax payable

*GL00910                Revenue income Distribution

*GL00911               Oil production tax payable

*GL00912               Transfer drilling expense to DHC

*GL00913               Cleared leases from RAESUM 230/235

*GL00914               Volume allocation-operating cost

*GL00915               Generate dividend checks

*GL00916                Billing adjustment

*GL00917               Lease records rental checks

*GL00918                Lease records A/R

*GL00919                Billing suspense detail

*GL00920               Overhead and Pumping Journal

*GL00921                Allocatable Lease Billing

*GL00922                Finance Charge Income

*GL00923               Lease use and production tax

*GL00925               Lease Records Rental Checks (Prospect Level)

*GL00926               Lease Records Affiliated Companies Edit (Property Level)

*GL00927               Lease Records Affiliated Companies Edit (Prospect Level)

*GL00928               Reserved

*GL00929               Reserved

*GL00930                RAESUM reversal edit

*GL00931                RAESUM transfer edit

*GL00932                Accumulated Depletion

*GL00933                Revenue Intercompany edit

*GL00934                Depletion Edit

*GL00935               Depreciation edit

*GL00936               JIB Accrual

*GL00999               A/P balance Fwd for new year


 

The descriptions are for system generated batches and print on the Accounting Recap Report.

 

Enter "System Batch" in columns 101-128 of each record to identify the records on listings.


3.         Printer and Date Defaults

 

Key *0000020

 

a.            Enter the Work Station ID and associated Default Printer ID.

 

COLUMN    WORK STATION    COLUMN     DEFAULT

FROM-TO     ID                FROM-TO                  PRINTER ID

 

1.       10-11       __         60-61       __

2.       12-13       __         62-63       __

3.       14-15       __         64-65       __

4.       16-17       __         66-67       __

5.       18-19       __         68-69       __

6.       20-21       __         70-71       __

7.       22-23       __         72-73       __

8.       24-25       __         74-75       __

9.       26-27       __         76-77       __

10.     28-29       __         78-79       __

11.     30-31       __         80-81       __

12.     32-33       __         82-83       __

13.     34-35       __         84-85       __

14.     36-37       __         86-87       __

15.     38-39       __         88-89       __

16.     40-41       __         90-91       __

17.     42-43       __         92-93       __

18.     44-45       __         94-95       __

19.     46-47       __         96-97       __

20.     48-49       __         98-99       __

21.     50-51       __         100-101          __

22.     52-53       __         102-103          __

23.     54-55       __         104-105          __

24.     56-57       __         106-107          __

25.     58-59       __         108-109          __

 


b.            Enter the number of days for the default report date.

 

COLUMN

FROM-TO

 

110-111                   __                Days

 

The Report Date that is automatically displayed on the Date and Printer Information Screen is controlled by the number of days entered.  If 00 is entered, the default report date is the current date.  If a positive number of days are entered, the Default Report Date is the Ending Date two months prior unless the Current Day is greater than the Days entered.  If the Current Day is greater, the Default Report Date is Last Month's Ending Date.

 

Examples : #Days                    Current                Default

Date                                Date

00                                09/16/82                08/31/82

05                                09/04/82                07/31/82

05                                09/06/82                08/31/82

 

 

112-113                   __                Page Length

 

Enter "Defaults" in columns 120-128 to identify the record on listing.

 


4.            Options

 

Key ********

 

COLUMN

FROM-TO                DATA                    EXPLANATION

 

11-11                       Y/N