FP Severance Tax
Table of Contents
Overview
The Severance Tax setup is the same as the setup in Revenue/Billing.
Pak Accounting's Severance Tax feature calculates and deducts specific severance taxes from revenue distribution items. The system can create reports for several specific state agencies. See the Revenue/Billing > Reports > State/Fed Reports tab for more information on state reporting.
Special features of the calculations:
- Calculates and combines multiple taxes (production, conservation, ad valorem, etc.) for a specific property.
- Calculates taxes on variables based on ownership type, product type, and specific periods of time.
- Calculates taxes on various basis of tax (gross, net, volumes).
- Specific calculated taxes are to be displayed as separate taxes on the revenue distribution record reported to your revenue owners.
- Creates General Ledger entries to record the liabilities to any severance tax payables accounts the user desires and includes an audit trail of which tax type and sequence number generated the specific tax amount.
- Displays an estimated tax that will show on the Operator Run Statements.
The automatic calculation occurs during the Revenue disbursement cycle at the Extract Entries menu option. To determine the results of the calculations, there are four primary points of visibility to which the user can refer:
- The Extract Revenue and Billing Entries Status Listing during the extract gives the company-wide total of computed severance tax.
- The listing is accessed on the Distribute/Combine menu option (List button). Any transactions with a From (FM) status of ST is a system-generated tax calculation. This gives you visibility at the distribution level.
- The Pre-Check Reports option – Print Distribution by Property Listing gives you visibility at the property/owner level. The Print Office Copy Listing displays each tax as deducted. The After Check Reports – Owner Copies report displays the same information to the revenue owners.
The journal entries are created when the Revenue/billing cycle is updated. In these entries, the description has been expanded to include an additional line containing the following items used by the First Purchaser's system severance tax reporting.
- Property Sub-Account
- State
- Tax code and Tax code sequence number
- Volume
- Gross Amount
- Tax basis amount
Setup
There are four basic steps to create a system-generated severance tax calculation:
- Create the specific 100% Tax expense accounts in your Chart of Accounts.
- Set up the Tax Rate Maintenance screen.
- Assign the Rate to a specific property.
- Extract the calculated entries as part of the Revenue Cycle.
The link between a tax calculation and a property is the unique Tax Code for that property in a specific state. Therefore, WY-1 is a different Rate Maintenance record than TX-1.
You can have multiple Tax Codes for a specific state. For Example, in Oklahoma, new wells receive an incentive. You could have one Code for the incentive and one for the regular rate.
Multiple sequence numbers can be used for a specific Tax Code. Texas is an example state where this technique may be used.
- Sequence 1 would calculate your Oil Tax on 4.6% (tax rate=.046) of the gross dollars and
- Sequence 2 would calculate the State Cleanup Fee of 0.625% (tax rate=.00625) of the volume produced.
- The combination of the two Sequence numbers would constitute the tax calculation for that specific Tax Code.
- Another reason to have multiple sequences is if your tax rates change as of a specific date, you can add another sequence for the new rate with the new date.
For Wyoming clients with multiple Ad-Valorem tax rates, you can have one Tax Code with multiple sequences. The additional ad-valorem sequences would not have a Tax Rate setup; however, the Use Replacement Rate from Property Maintenance would be checked. Once the sequences are set up on the Property Maintenance > Sev Tax tab, the rate from the Property Maintenance will be used instead.
Also see: Allocated Flat Amount
Account Maintenance [F11]
A minimum of two accounts are needed to be set up
- Set up a separate account for each stub detail line you would like your owner to see. To make the accounts available to Revenue, it must have an “Account Type” of “R” for Revenue, it must have a “Category Name” of “TAXES,” and it must have the correct Product Code assigned. The “Applicable Interest Types” defaults to “A” for all (owners). Only change this switch if the tax is applied to Working or Non-Working (royalty) only.
- Set up a separate Liability account for each governmental entity you are responsible for remitting payments to. This account clears out when you make that payment.
Account numbers and descriptions—We recommend keeping your account descriptions as generic as possible so that all states can use the accounts. Another alternative is to set up specific accounts for each state tax.
Severance Tax Rate Maintenance
Set up the tax codes and sequence numbers for each state to compute the tax(es). The account settings you choose are how you want to display the taxes on the checks and how you need to remit to the governmental entities. In Texas, for example, there are a number of different “exemption” codes that a property can utilize.
General Tab | |
State | Two-digit state code. |
Tax Code | Twelve-character alpha/numeric code that identifies the specific tax to a property. |
Sequence Number | The four-digit number that identifies specific components of the tax calculation. You can have multiple Sequence Numbers (each a separate screen) for each Tax Code. |
Comments | Informative description for each Sequence Number. This field displays Texas Production Tax – Gas. It identifies the name of the tax on the settlement statement. |
Basis of Tax |
There are three options for this component. Depending on what the state law requires will dictate how this severance tax code is setup.
|
Deduct Other |
Deduct Other From Basis: Utilize this when the state allows deductions such as marketing fees, etc., before calculating severance tax. Again, there are multiple options, so choose carefully, as this option will directly impact the severance tax calculation.
|
Deduct Exemptions | Reduce the severance tax amount by user-defined exemptions. This is extremely rare for First Purchasers. |
Per Volume Exemption | This is used with the Deduct Exemptions box. This is extremely rare for First Purchasers. |
Adjust Basis before exemptions by multiplying by: | This is extremely rare for First Purchasers. |
Tax Rate | Eight decimal place numeric rate to apply as the tax. For instance, 7.5% is expressed as 0.07500000. This is the rate to apply against the selected basis. |
For Tax rate changes: Apply this Tax to Run Dates | This option allows certain production dates to assign to the tax rate based on a state’s tax laws for a specific production period. For instance, a tax rate of 0.0012 for production in 2021 and a rate of 0.0033 for production in 2022 could be captured by using two different Sequence Numbers for this Tax Code. |
TX Special Reporting Option | For Texas only. Use the drop-down to see options. See Texas Low Producing Oil for more information. |
Lease Exemption Type | This is specific to Texas. This is used to use for your Tax Codes exemptions. This replaces the need to use the last two digits in the Severance Tax Code to identify the exemption. |
Only Include Taxable Owners |
(Default checked) If checked, the system will go through the division of interest and accumulate only the revenue percentages that are taxable. If unchecked (this is rare for First Purchasers), and all 3 tax interest types are checked, then tax is computed on 100%. NOTES:
|
Only Owners with Interest Types | Check which Interest Types the Severance Tax applies to Working, Royalty, and/or Override. These 3 options only affect the computation of the tax at the 8/8s level and NOT the distribution of the tax. |
G/L Coding Tab | |
Severance Tax Payable Account / Sub-Account |
The specific Liability Account payable for the tax deducted. Hint: Create a different Account or Account/Sub-Account combo for each taxing authority. You must remit taxes. NOTE: If a different payable Account/Sub-Account combination is being used for a second tax sequence and this same sequence is using the same Revenue Tax Account, an error will be generated stating that there is a duplicate product tax account. If the sequences for a tax code are coded to different payable Accounts/Sub-Accounts, then the product Tax Accounts must also be different. This error will have to be corrected prior to the extract. |
Product Code/Product Tax Account | Assign a product(s) to this sequence as needed and code the correct Revenue Tax Account to that product. This screen can display multiple products when using the same Tax Code. |
Special Options tab Some severance tax calculations need special tier-based options. If a state has a different tax based on a specific market price or a specific volume level, use the 2-Tier based option. Again, this severance tax module allows for even the most complicated setup. To use the Special Options tab, the basis for the tax calculation on the General tab needs to be set to Gross/Price Per. | |
Type of Rate | Choices include a 2nd Tier Rate or a Replacement Rate. |
Based on | Base the Tiered rate on either Price Per Bbl or MCF, etc. or Daily Volume multiplied by the number of wells or the Daily Gross. |
When reaching | This allows customization of the tier-based system. Price Per would need dollar amounts down the first column and the volume selected would require the number of Bbls/MCFs broken down to represent a new tax rate. |
Use Severance Tax Adj | The default is set to “none”. (Normal selection) See Property Maint – Sev Tax tab - Tax Adj columns for the three defined rates. This is used in states where a specified rate may be adjusted up or down for a specific well. For instance, a special adjustment may be allowed for one well out of 100 because of production incentives. |
Based on Property’s First Run Date | Must be used in relation to the specific property’s Beginning Production month as defined in the Property Master. Used for states that have different rates for the first number of specific production months. For instance, if your state has one rate for the first 24 months of production (only months 0 thru 24), and a different rate for the rest of the life of the well (25 thru 9999), create two different Sequence Numbers for that Tax Code. |
Ignore if Stripper | When used with the Property Maintenance - Stripper Switch this will allow the Severance Tax sequence to be exempt from the calculations of this tax code. |
Minimum Volume Rate | This option allows for a different rate to apply when volumes reach a designated level. |
Minimum Price Per: |
This option can be used for oil contained in tank bottoms or other materials purchased from producers (Reclaimed Oil). During the Revenue cycle - Distribute and Combine menu - it will calculate taxes based on the minimum price per unit. This field is limited to 2 decimal places only. With this option, the system will take the gross amount/quantity to determine the price per unit. If the price per is below the minimum in this new field, then it will use the value in the field to calculate the tax. If above, then it will use the actual. |
Review Setup
Now that you have set up your severance tax codes, you can use the List button on the Severance Tax Rate Maintenance screen. The P-6 Severance Tax Rate Listing will allow you to see each tax code and sequence and how it is set up.
For example, the CO Tax code:
- All Revenue Tax Accounts are different so that each tax will show as separate stub detail lines on checks.
- The Severance Tax Payable Accounts are different accounts that allow for tracking Liabilities in separate G/L accounts so that you can balance your account per governmental entity.
Where the TX code above is set up differently:
- The Revenue Tax accounts are the same for gas and will show up as one stub detail line on the check.
- The Severance Tax Payable Account is also one account per State Severance Tax.
Property Maintenance - Severance Tax tab
On the Property Maintenance for each property, enter the state on the General Tab, and on the Severance Tax Tab, enter the Severance Tax Code to be used to calculate the tax.
TECH TIP: Use the effective date only if you have any date-sensitive tax needs, such as if a property has an exempt certificate for 5 years, then it becomes taxable. You are still liable for the “clean-up fee,” so you will need a tax code with just that one sequence.
Special Situation – Tax Exempt Owner.
To exempt a specific owner(s) from the Severance Tax calculation, enter "TAXES" in the exemption column of DOI Maintenance in Revenue/Billing. Also, see how to Edit a DOI.
Reviewing Severance Tax Calculation
During Run Ticket Entry
If a property has the Severance Tax set up, during ticket entry, the Estimated Taxes will show in the Daily Run Ticket Maintenance.
During the Run Statement
The estimated tax will also show on the Operator Run Statement.
During Revenue/Billing
- After you have Extracted your Revenue/Billing Cycle, on the Distribute/Combine menu item is a List button to view how Pak Accounting calculated the Severance Tax for each applicable property (Note: the “ST” in the From (FM) column below).
- After you Distribute/Combine, on the Pre-Check Reports, Print Distribution by Property, you can see the Severance Tax calculation that is being netting out of the revenue check.
- Now that you have deducted the State Severance Taxes from the distributions you can go into Revenue/Billing > Reports > States tab.
Use the Drop Down to select the state you need. - Once the state is selected, the screen will show all reports available. Click into the you need and fill out the fields accordingly.
More Information
- Training Videos can be found under Revenue/Billing > Setup
- Please see other Help Menu items such as:
- Severance Tax Error-No Accounts Have Been Defined for a Specific Product
- Texas Low Producing Oil Lease Severance Tax Credit
- Severance Tax Corrections
- Severance Tax Reporting and Filing including Rev/Billing > State/Fed Reports tab for state-specific Severance Tax Reporting
- Multi-Tax Code (NM)
- Severance Tax Anomalies