Back to Excel templates

Multi-State Severance Tax Estimator — Oil/Gas Production Tax by State with Rate Tables

Estimate oil and gas severance tax by US state with built-in rate tables, monthly production input, and annual effective rate benchmarking.

production economicsfoundation

TITLE

Multi-State Severance Tax Estimator — Oil/Gas Production Tax by State with Rate Tables

PRICE

$59 USD — one-time purchase

TAGLINE

Estimate oil and gas severance tax by US state with built-in rate tables, monthly production input, and annual effective rate benchmarking.

WHO IT'S FOR

Production accountants and asset analysts estimating state severance tax on oil and gas volumes.

WHAT IT DOES

Applies state oil and gas severance rates to monthly production and revenue, supports exemption flags, and benchmarks effective tax rates across six states. Dedicated crossplot tabs support visual QC of model vs measured data.

TABS INCLUDED (9)

• Instructions & Legend • Production Input • State Rate Tables — TX, OK, ND, NM, LA, WY • Tax Calculation • Exemptions • Annual Summary • Tax Rate Chart — effective rate by state • Oil vs Gas Tax Chart — monthly comparison • Summary

KEY FORMULAS

Tax = volume × price × state rate; effective rate = tax/revenue

TECHNICAL SPECS

• Excel 2016+; 320+ formulas; 12-month production sample; 6 states • MDT professional color scheme throughout • Yellow cells = inputs; white cells = formulas

SHOP COPY

7-tab severance tax estimator: multi-state rates, monthly calc, annual benchmark. Includes QC crossplots with 1:1 reference lines.

SUGGESTED TAGS

severance tax, production tax, Texas, Oklahoma, state tax

ABOUT RESERVOIR RISK SOLUTIONS

Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. reservoirrisksolutions.com

ETSY LISTING

TITLE: Severance Tax Excel Estimator | Multi-State Oil Gas Production Tax Rate Tables PRICE: $59 USD — suggested; set your price in Etsy shop manager TAGS: severance tax, production tax, Texas Oklahoma, state tax calculator, oil gas accounting, Excel template, petroleum accounting, tax estimator, monthly production, digital download, energy accounting

DESCRIPTION:

Professional Excel workbook for upstream engineers. Applies state oil and gas severance rates to monthly production and revenue, supports exemption flags, and benchmarks effective tax rates across six states. Dedicated crossplot tabs support visual QC of model vs measured data.

Who it's for: Production accountants and asset analysts estimating state severance tax on oil and gas volumes.

What's included: • Instructions & Legend • Production Input • State Rate Tables — TX, OK, ND, NM, LA, WY • Tax Calculation • Exemptions • Annual Summary • Tax Rate Chart — effective rate by state • Oil vs Gas Tax Chart — monthly comparison • Summary

Technical specs: Excel 2016+; 320+ formulas; 12-month production sample; 6 states. Excel 2016+, no plugins, sample data pre-loaded.

About Reservoir Risk Solutions — built by petroleum engineers. reservoirrisksolutions.com DIGITAL_DELIVERY: Instant download — Excel .xlsx file

severance taxproduction taxTexasOklahomastate tax

What you get

  • Instant workbook access after payment in your Excel Library
  • Formula-driven worksheet designed for petroleum workflows
  • No recurring fees and no plugin requirements

FAQ

Is this a one-time purchase?

Yes. Each workbook is sold as a one-time purchase with no recurring subscription.

How do I access purchased files?

After checkout, your file appears in Excel Library under your account for download.

Do these templates require macros or plugins?

No. Templates are designed for Excel 2016+ and do not require VBA macros or external add-ins.

Multi-State Severance Tax Estimator — Oil/Gas Production Tax by State with Rate Tables
$59 + tax, where applicable · one-timeOpen Excel Library