T-1 Report Setup

<< Click to Display Table of Contents >>

Navigation:  First Purchaser > FP Reports > State Reports Tab >

T-1 Report Setup

Railroad Commission of Texas Monthly Transportation and Storage Report (T-1)

 

Railroad Commission of Texas Monthly Transportation and Storage Report (T-1)

Ticket Date Month/Year:

Allows you to set the reporting period for the report.

Purchaser Company Code:        

Allows you to select which first purchaser activity is to be included in the report. (Pak Accounting can support multiple 1st Purchaser entities within the same Pak Accounting Company, for additional information please contact your Customer Success Team.)

Analyst Title for Report:

Allows you to define the name of the agent who is submitting the report to the RRC.

Phone#:

Allows you to define the phone number for the agent submitting the report to the RRC

Mark as Corrected Report:

Check the box if you need to file a correction report for a previously reported reporting period.

Save Report Data to CSV File Option:

If either “Save to CSV by RRC#" or "Save to CSV at Run Ticket Level” is selected, the report will create a .CSV file at the location indicated on the screen. Only Page 2 data will be captured in the file. The .CSV file that is created is intended for internal use only.

Page 1

Header

Operator:

On the Report definitions screen,  the Purchaser field should be populated with the company code. The Operator Name comes from the Sub-Account Maintenance\Name field.

Month:

This field is populated based on the “Ticket Date Month/Year” entered on the report definition screen.

Registration No:

This field is populated from the value entered under Company Maintenance\ Company\ First Purchaser tab\ Texas RRC Transporter Registration Number.

Address:

The Operator's address comes from the “Address 1, City, State, and Zip Code fields on the Sub-Account Maintenance for the Operator in the company code specified on the Report Definitions screen.

Corrected Report:

This field is defined on the report definition screen by checking the box next to “Mark as a Corrected Report”.

Inventory:

Balance Available for Movement (Beginning of Month):

This is the sum of the volumes on the first day of the reporting month for tanks on properties located in Texas and identified as "Stations" on the General tab of the Property Maintenance. For example: if the reporting month is 05/20XX, the volumes used are the barrels in the tanks on 05/01/20XX.  

Frozen Stock:

This field is not supported by Pak Accounting. Should you need to use this field, please your Customer Success Team. This field is currently populated with a “0”.

Liquid Hydrocarbons in Line:

This field is not supported by Pak Accounting. Should you need to use this field, please contact Pak Accounting Support. This field is currently populated with a “0”.

Total Stock 7 A.M. (Beginning of Month):

This field will always match the valued entered at “Balance Available For Movement”

Receipts From Leases

Receipts from Leases – Crude:

This is a calculated value that is the sum of all of the entries on Page 2 (Note page 2 may cover multiple sheets) for Leases with either an Oil or Commingle Permit # listed.

Receipts from Leases – Liquids:

This is a calculated value that is the sum of all of the entries on Page 2 (Note page 2 may cover multiple sheets) for Leases with a Gas Well Identification number listed.  

Receipts from Other Sources

 

Received From:

Will always display “SEE ATTACHED PAGE 1A” with the sum of the detailed records Displayed Under actual Receipts displayed on page 1A(Note page 1A may cover multiple sheets)

Total:

This field will always match “See Attached Page 1A” value. Total All Receipts: This is a calculated field totaling the Total line from Receipts from leases and the Total line from Receipts from other Sources.

Stock First of Period Plus Receipts:

This is a calculated field displaying the sum of “Total All Receipts” and “Total Stock 7 A.M.”

Deliveries

 

Delivered To:

Displays “SEE ATTACHED PAGE 1B” with the sum of the detailed records under "Deliveries" on page 1B. (Note: page 1B may have multiple sheets. If so, all are added together.)

Total:

This field will always match “See Attached Page 1A” value.

Overage\Shortage:

Only one of these fields will have a value if there is a value at all. The overage/shortage is the sum of the “Stock First of Period Plus Receipts” - “Total Deliveries” – “Total Stock end of Month”. If the sum is negative, the value is populated in the Overage field. If the sum is positive, the value is populated in the Shortage field.

Total Deliveries:

Calculated field where the Total (under deliveries) + shortage or – overage.

Total Stock End of Month:

Sum of the detailed records displayed on Page 3. (Note page 3 may contain multiple sheets.)

Frozen Stock:

This field is not supported by Pak Accounting. Should you need to use this field, please contact Pak Accounting Support. This field is currently populated with a "0".

Liquid Hydrocarbons in Line:

This field is not supported by Pak Accounting. Should you need to use this field, please contact your Customer Success Team. This field is currently populated with a “0”.

Balance Available for Movement (End of Month):

Will always match “Total Stock End of Month”

Signature:

Field will always be blank. A physical signature is currently required.

Date:

The date the report is generated out of Pak Accounting will be displayed.

Title:  

The title displayed will be the same value entered on the Report Definition Screen.

Telephone No:

The number listed will be the same value entered on the Report Definition Screen.

 

NOTE: For all properties that do not need to be reported: check the Exempt from State Transporter Reports box in Property Maintenance / Production tab.

 

Page 1A Receipts From Other Sources

There are three types of receipts included in this section of the report.

1.   The property on the Run Ticket Load tab is identified as a “Property (Lease)” on the (Property Maintenance\General Tab\Category). This property is located outside of Texas. The Purchaser on the report definition screen is the purchaser on the price contract and the destination property is located in Texas.  (Basically, the oil is produced outside of Texas and delivered to a property in Texas.)

2.The property on the Run Ticket Load tab is identified as a “Station” (Property Maintenance\General Tab\Category) and operated by the Purchaser specified on the report definition screen. Either the property on the Load tab or the property on the Offload tab must be in Texas.
3.The property on the Run Ticket Load tab has a Well Type (Property Maintenance\Production Tab\Well Type) is set to “Other (Skim)” and the Purchaser specified on the report definition screen is the purchaser on the price contract. Either the property on the Run Ticket Load tab or the property on the Run Ticket Offload tab must be in Texas.

Each district will be reported on a separate sheet.  The district used for reporting is determined by the destination property’s State Reporting District#. The District # is located on the Property Maintenance\ General Tab\ State Reporting District #.

Received From: The name and contact information for the Operator identified on the Property Maintenance\General Tab\Legal Operator-Gov Rpts will be listed.

Facility Name: If the originating property (Load tab of Run Ticket) is located in a state other than Texas, the state name is reported. In all other cases the Property Maintenance\ Name is reported.

RRC Number: If the property on the Run Ticket Load tab is located in Texas, the State Property Id # (Property Maintenance\General Tab\ State Property Id#) is used. If the property on the Run Ticket Load tab is not located in Texas, the report will have “Import”.  “Frac Oil” and “Other” are currently not supported. Please contact your Customer Success Team for additional information if you need to use these reporting functions.

Actual Receipts: Individual ticket volumes are consolidated and reported as a single value based on the originating property’s Property Code. .

 

Page 1B Deliveries

This section includes all run tickets included on Page 1A Receipts from Other Sources and all run tickets included in the Page 2 Detail of Receipts From Leases.

Each district is reported on a separate sheet. The district used for reporting is the State Reporting District of the property on the Run Ticket Offload tab. The District # is located on the Property Maintenance\ General Tab\ State Reporting District #.

Delivered To: The name and contact information for the operator of the property listed on the Run Ticket Offload tab.

Facility Name:  The name of the property on the Run Ticket Offload tab. Property Maintenance\Name

RRC Number: If the property on the Run Ticket Offload tab is located outside of TX, EXPORT will be displayed. If the property on the Run Ticket Offload tab is located in Texas, the State Property ID# is reported. Property Maintenance\ General Tab\ State Property ID#.

Actual Deliveries: The volumes on the Run Ticket Offload tab are consolidated at a Property level and reported as a single value. NOTE: If there is not a volume on the Run Ticket Offload tab, the volume on the Run Ticket Load tab is used.

 

Page 2 Detail of Receipts From Leases

This section includes run tickets for properties on the Run Ticket Load tab

a.located in Texas,
b.the Well Type on the Property Maintenance Production tab is Oil Well, Gas Well or Pending, and
c.the purchaser on the price contract is the reporting operator.

 

Each district is reported on a separate sheet. . The district used for reporting is the State Reporting District of the property on the Run Ticket Load tab. The District # is located on the Each district is reported on a separate sheet. . The district used for reporting is the State Reporting District of the property on the Run Ticket Load tab. The District # is located on the .

The receipts are listed grouped by Field\Operator\Lease in ascending alphabetical order for the field and operator. Leases are listed in ascending order based on the RRC number.

 EX.

 WolfCamp        

         XYZ Operating

                 Smith 1H (RRC # 14555)

                 Smith 2H (RRC #14666)

 

The Field comes from the property on the Run Ticket Load tab, (Property Maintenance\ Other Tab\ Field Reference)

The Operator name comes from the Sub-Account Name of the Operator specified on the Property Maintenance\ General Tab\“Legal Operator-Gov Rpts” field.

The Lease Name comes from the name of the property on the Run Ticket Load tab.

The “Well Type” (Property Maintenance\ Production Tab\ Well Type) of the property on the Run Ticket Load tab controls the placement of the State Property ID# into the proper column.(Property Maintenance >General Tab > State Property ID#) Note: Oil wells have a 5 digit number and gas wells have a 6 digit number. If a well number is pending, the well type should be set to “Pending” and the 6 digit drilling permit number should be populated in the State Property ID #.

A commingle Permit number will be displayed instead of a State Property ID if a number is populated on the Property Maintenance > Production Tab > Commingle Permit #. (Note: Print Permit # on State Reports” must be checked)

Receipts: individual tickets are summed together and then rounded to the nearest whole barrel.

Adjustments: This field is currently not supported by Pak Accounting. Should you need to use this field, please contact your Customer Success Team.

 

Page 3 Detail Statement of Stock on Hand

Properties identified as Stations on the Property Maintenance General tab owned by the reporting purchaser (as specified on the report definition screen) that have a gauge reading on the 1st of the month after the reporting period are included. For example: If the reporting month is October, the Stock On Hand is the sum of the volumes based on the guage readings for stations dated November 1st.

Each district is reported on a separate sheet. The district used for reporting is determined by the applicable station\property. The District # is located on the Property Maintenance > General Tab > State Reporting District #.

Type of Stock: This field will always be Crude. Other types of stock are currently not supported by Pak Accounting. Should you need to use this field, please contact your Customer Success Team.

Net Barrels: This value comes from the gauge ticket for the tank dated the first of the following reporting period. EX: For an October Report,the stock on hand is reported based on the gauge reading dated November 1st.

Tank Numbers: This field comes from the Tank number associated to the Station.

Location: The field comes from the Property Name on the Property Maintenance screen.