IOGC Electronic Submission

Create file for the following month(s)

• Production Date: IOGC Statement will contain data for the entered production date only, regardless of whether it is the current month or an amendment month.

• Production Date and Amendments:  IOGC Statement will contain data for the entered production date, regardless of whether it is the current month or an amendment month, as well as any open amendments from all other months prior to the entered production date.

Production Date

This field defaults to the current system production date but can be changed.

Submission Type

Select either Oil Statement or Gas Statement.

Province

Select either Alberta or Saskatchewan.

Royalty Payor

This is the owner responsible for the payment and reporting of IOGC royalties.

Destination Directory

The Destination Directory is set up in Administration (System Configuration > Directories > IOGC Electronic Submission)

File Name

This filename is defaulted to include the codes for royalty payor, province, production date, and product, but can be changed. 

• Special characters such as spaces, $, etc. are not valid in the file name.

Note: Two CSV files will be created: The existing format and a new format. The file with the proposed new format will have NEWVERSION appended to the filename. The NEWVERSION file cannot be submitted to IOGC at this time, however, it is available to you when the IOGC adopts the new format. IOGC has a target Go Live date of January 2023 to start accepting the NEWVERSION files for all production dates, including amendments.

For example: 0F3FAB201406OIL or 0F3FAB201406OILNEWVERSION

Royalty Entity ID

This is the identification number assigned by IOGC to a well or unit. It must be reported exactly as provided by IOGC or the data will be rejected.

Char

7

IO01234

Production Year

This is the year associated with the submitted data. This must be a four-digit number that is equal to or less than the current year (i.e. it is not possible to submit data for future periods).

Number

4

2004

Production Month

This is the month of production. The month must be expressed as a number and must be equal to or less than the current month (within a valid production year).

Number

2

01 or 1 (Jan)
12 (Dec)

Product Entity ID

This is the identification number for the well or unit tied to the royalty entity. If the Production Entity ID does not match IOGC's records for the royalty entity, the submission will be rejected.

Well ID – Must use the DLS format:
Province WI <LE LSD SEC TWP RGE MER ES>

Unit ID – Format must be:
Province UN <Unit Government Code>

Char

30

Well ID:
AB WI 123456789123W400

Unit ID:
AB UN 0012345 

Total P/E Production Volume

The oil production for the month.

Note: Production equals sales for purposes of oil royalties.

Number

12,2

1234.56

Sale Price

The price at which the oil was sold.

Number

12,6

43.567891

Gross Royalty Amount

The gross royalty for the oil sold.

Number

12,2

23456.78

Claimed Trucking Rate

This field can only be used by royalty payors with pre-authorization to claim royalty deductions for trucking costs. Unauthorized trucking deductions will result in the rejection of the statement.

Number

12,2

12.34

Royalty Entity ID

This is the identification number assigned by IOGC to a well or unit. It must be reported exactly as provided by IOGC or the data will be rejected.

Char

7

IO01234

Production Year

This is the year associated with the submitted data. This must be a four-digit number that is equal to or less than the current year (i.e. it is not possible to submit data for future periods).

Number

4

2004

Production Month

This is the month of production. The month must be expressed as a number and must be equal to or less than the current month (within a valid production year).

Number

2

01 or 1 (Jan)
12 (Dec)

Product Entity ID

This is the identification number for the well or unit tied to the royalty entity. If the Production Entity ID does not match IOGC's records for the royalty entity, the submission will be rejected.

Well ID – Must use the DLS format:
Province WI <LE LSD SEC TWP RGE MER ES>

Unit ID – Format must be:
Province UN <Unit Government Code>

Char

30

Well ID:
AB WI 123456789123W400

Unit ID:
AB UN 0012345 

Total P/E Production Volume

Oil production for the month.

Note: Production equals sales for purposes of oil royalties.

Number

12,2

1234.56

Sale Price

The price at which the oil was sold.

Number

12,6

43.567891

Gross Royalty Amount

The gross royalty for the oil sold.

Number

12,2

23456.78

Claimed Trucking Rate

This field may only be used by Royalty Payors with pre-authorization to claim royalty deductions for trucking costs. Unauthorized trucking deductions will result in the rejection of the statement.

Number

12,2

12.34

Total Net Royalty

Total Net Royalty is required to be entered.

Number

12,2

21933.41

Confidential Well

Indicate if this Production Entity ID/Well ID is confidential.

Checkbox

1

Checked = Y
Unchecked = N or NULL

Hours Production Amt

If the well is confidential, the hours entered must be greater than zero. If the well is not confidential, no entry is required, but zero is acceptable.

Number

12,2

744.00

Royalty Entity ID

This is the identification number assigned by IOGC to a well or unit. It must be reported exactly as provided by IOGC or the data will be rejected.

Char

7

IG01234

Production Year

This is the year associated with the submitted data. This must be a four-digit number that is equal to or less than the current year (i.e. it is not possible to submit data for future periods).

Number

4

2004

Production Month

This is the month of production. The month must be expressed as a number. The month must be equal to or less than the current month (within a valid production year).

Number

2

01 or 1 (Jan)
09 or 9 (Sep)
11 (Nov)

Product Type

This is the type of gas product being reported. This is a three-character code. These are the only product codes that will be accepted by the validation process.

Char

3

GAS – Gas
ETH – Ethane
PRO – Propane        BUT – Butane             
PEN – Pentanes        
SUL – Sulphur
CON – Condensate

Production Entity ID

This is the identification number for the well or unit tied to the royalty entity. If the Production Entity ID does not match IOGC's records for the royalty entity, the submission will be rejected.

Well ID – Must use the DLS format:
Province WI <LE LSD SEC TWP RGE MER ES>

Unit ID – Format must be:
Province UN <Unit Government Code>

Char

30

Well ID:
AB WI 123456789123W400
Unit ID:
AB UN 0012345

Total Gas Sales Volume

This applies to GAS only. Leave blank if the line is not for GAS.

This field is the total of all gas sales for the production entity. It is expressed in 103m3.

Number

12.2

1234.56

Marketer or Purchaser ID

This applies to GAS only. Leave blank if the line is not for GAS.

This is a four-character code for each company to which gas sales were made. The list of valid IDs will be provided at implementation and updates will be made available on IOGC's website.

Char

4

POOL

Reported Sales Price

This is the price at which the gas or gas product was sold. Prices must be reported as follows:

• GAS: $/GJ

• BUT: $/m3

• PEN: $/m3

• CON: $/m3

• PRO: $/m3

• ETH: $/m3

• SUL: $/tonne

Number

12,6

3.891234

Heating Value

This applies to GAS only. Leave blank if the line is not for GAS.

Heating Value is the heating value of the gas sold. This is expressed in GJ/103m3 with up to seven decimal places.

Number

9,7

34.57

IOGC Volume Available for Sale

For GAS, this field is used to report the IOGC volume sold to a particular marketer/purchaser and is reported in 103m3.

Note: The sum of IOGC volumes entered must be equal to Total sales volume * IOGC percentage.

For GAS PRODUCTS, report the IOGC sales of each product for the production month using the appropriate unit of measure. 

Number

12,2

567.78

Gross Royalty Amt

This is the gross royalty for the type of product reported.

Note: Reporting GAS may require more than one line in the file, due to multiple purchasers. The gross royalty for GAS should be the total for all GAS transactions.

Number

12,2

23456.78

Royalty Entity ID

This is the identification number assigned by IOGC to a well or unit. It must be reported exactly as provided by IOGC or the data will be rejected.

Char

7

IG01234

Production Year

This is the year associated with the submitted data. This must be a four-digit number that is equal to or less than the current year (i.e. it is not possible to submit data for future periods).

Number

4

2004

Production Month

This is the month of production. The month must be expressed as a number and must be equal to or less than the current month (within a valid production year).

Number

2

01 or 1 (Jan)
09 or 9 (Sep)
11 (Nov)

Product Type

This is the type of gas product being reported. This is a three-character code. These are the only product codes that will be accepted by the validation process.

By default the MIX product code will be used for any Propane, Butane or Pentane submitted.

Char

3

GAS – Gas
ETH – Ethane
PRO – Propane
PRM - Propane Mix
BUT – Butane
BTM - Butane Mix
PEN – Pentanes
PNM - Pentane Mix
SUL – Sulphur
CON – Condensate

Production Entity ID

This is the identification number for the well or unit tied to the royalty entity. If the Production Entity ID does not match IOGC's records for the royalty entity, the submission will be rejected.

Well ID – Must use the DLS format:
Province WI <LE LSD SEC TWP RGE MER ES>

Unit ID – Format must be:
Province UN <Unit Government Code>

Char

30

Well ID:
AB WI 123456789123W400
Unit ID:
AB UN 0012345

Total Gas Sales Volume

This applies to GAS only. Leave blank if the line is not for GAS.

This field is the total of all gas sales for the production entity. It is expressed in 103m3.

Number

12.2

1234.56

Marketer or purchaser ID

This applies to GAS only. Leave blank if the line is not for GAS. This is a four-character code for each company to which gas sales were made. The list of valid IDs will be provided at implementation and updates will be made available on IOGC's website.

Char

4

POOL

IOGC volume available for sale

For GAS, this field is used to report the IOGC volume sold to a particular marketer/purchaser and is reported in 103m3.

Note: The sum of IOGC volumes entered must be equal to Total sales volume * IOGC percentage.

For GAS PRODUCTS, report the IOGC sales of each product for the production month using the appropriate unit of measure.

Number

12,2

567.78

Reported sales price

The price at which the gas or gas product was sold. Prices must be reported as follows:

• GAS: $/GJ

• BUT: $/m3

• BTM: $/m3

• PEN: $/m3

• PNM: $/m3

• CON: $/m3

• PRO: $/m3

• PRM: $/m3

• ETH: $/m3

• SUL: $/tonne

Number

12,6

3.891234

Heating value

Applies to GAS only. Leave blank if the line is not for GAS The heating value of the gas sold. This is expressed in GJ/103m3 with up to seven decimal places.

Number

9,7

34.57

Gross royalty amt

This is the gross royalty for the type of product reported.

Note: Reporting GAS may require more than one line in the file, due to multiple purchasers. The gross royalty for GAS should be the total for all GAS transactions.

Number

12,2

23456.78

Gas Cost Allowance (GCA) Deduction

If the Total gas sales volume is greater than zero, a GCA deduction must be entered. A value of zero is allowed.

Number

12,2

11110.79

Total Net Royalty

Total Net Royalty is required to be entered. The sum of all gross royalty amounts minus the GCA deduction.
Gas Cost Allowance Deduction = (Gas Marketable Sales Volume * Gas Cost Allowance Rate * Total Gross Royalty Percent) / 100

Number

12,2

12345.99

Confidential Well

This field is used to indicate if this Production Entity ID/Well ID is confidential.

Checkbox

1

Checked = Y
Unchecked = N or NULL

Hours Production Amt

If the well is confidential, the hours entered must be greater than zero. If the well is not confidential, no entry is required but a value of zero is acceptable.

Number

12,2

744.00