Upload Formats

Tax Form: G1D file upload format.

Field #	Name	Start	End	Length	Type	Description
1	Product Code (20)	1	2	2	Numeric	Product Code
2	Tax ID	3	12	10	Numeric	Ten digit Louisiana Tax Number.
3	Severance Account Number	13	18	6	AlphaNumeric	Producer or transporter code (up to 6 digits) assigned by Conservation or reporting co. # assigned by LDR. For 4 and 5-digit codes, pad with a leading
4	Tax Period	19	22	4	Numeric	Period for which tax is due.
5	Parish Code	23	24	2	Numeric	Parish where production occured.
6	Field	25	28	4	Numeric	Four digit code assigned by Louisiana Office of Conservation.
7	Producer Code	29	34	6	AlphaNumeric	Producer code assigned by Louisiana Office of Conservation that may be up to six digits. For 4 and 5-digit codes, pad with a leading zero(s).
8	Lease Code	35	40	6	Numeric	Six digit code assigned by Louisiana Office of Conservation. Number must be 6 digits.
9	Conservation Well Serial Number	41	46	6	Numeric	A code assigned by Louisiana Office of Conservation that may be up to six digits. Number can be less than 6 digits.
10	Plant Code	47	51	5	AlphaNumeric	Plant code assigned by Louisiana Office of Conservation that may be up to five digits.
11	Taxpayer Code	52	57	6	AlphaNumeric	Producer or transporter code (up to 6 digits) assigned by Conservation or reporting co. # assigned by LDR. For 4 and 5-digit codes, pad with leading
12	Tax Rate Code	58	59	2	AlphaNumeric	Code assigned by the Louisiana Department of Revenue to designate applicable tax rate per MCF by category.
13	Gross Gas Production (MCF)	60	70	11	Numeric	Producer must report all production for each property as reported on the OGP to the Louisiana Office of Conservation.
14	Ex Code 1	71	71	1	AlphaNumeric	Code for Gas Volume. Lawfully Exempt From Tax
15	Ex Vol 1	72	82	11	Numeric	Volume for Gas Volume. Lawfully Exempt From Tax
16	Ex Code 2	83	83	1	AlphaNumeric	Code for Gas Volume. Lawfully Exempt From Tax
17	Ex Vol 2	84	94	11	Numeric	Volume for Gas Volume. Lawfully Exempt From Tax
18	Ex Code 3	95	95	1	AlphaNumeric	Code for Gas Volume. Lawfully Exempt From Tax
19	Ex Vol 3	96	106	11	Numeric	Volume for Gas Volume. Lawfully Exempt From Tax
20	Total Amount Due	107	119	13	Decimal(12,2)	G1D: Net taxable MCF times applicable tax rate equals amount of tax due.

Note: The Net Taxable MCF column on the paper version of the return is automatically calculated on the Severance App. It is not keyed by the taxpayer. Therefore, it was not included in the G1D format instructions shown above.

Record Length: 119

Note:
Decimals should be given an explicit decimal point. Example: Decimal(12,2) = xxxxxxxxxx.xx which is 13 places.
There should always be two numbers to the right of the decimal. Use zeros if necessary.
Pad numeric types with leading spaces.
Place negative sign before first signicant digit of numeric types.
COMMA DELIMITED: Follow same order as fixed-length file. Place comma between fields.