DR 21-W Withholding Form With Detail - REV230

This report prints DR 21-W forms for Colorado properties, showing gross royalties, ad valorem, and Colorado severance tax withheld for all owner interests. In addition, the gross and ad valorem tax is broken out by cash or accrual and stripper production. A form prints (for all Colorado wells) whether or not any ad valorem and Colorado severance taxes were withheld during the year. You must run the Transfer Paid/Released Transactions To History - REV215 program prior to running this program.

The REV230 process creates a Substitute DR21-W form that includes one form per page.

Detail Sales History items are selected for this process for Colorado properties as determined by the state code entered in the Well Master - LLR100 program. All payments in the specified year accumulate in the Cash Basis column and items with a sale date in the specified year accumulate in the Accrual Basis column. Any detail sales items in suspense for any sale date are not included on the form.

Stripper well oil production is determined from the Stripper text box in the Purchaser Property - REV100A program.

This program prints products that are oil and gas, and owners having a check date with the specified year.

If the REV125 Component Codes program “Print Flag” is unchecked then the component is excluded in REV230, REV830, and COM450 Gross calculations.  If the same Component is entered into the Excluded Components grid, the component is only deducted once.

You must enter all ad valorem and severance tax components. You can print one form per owner or one form per Colorado lease. If you choose the Lease option at the Form Type field, each well being taxed must have a state lease number, which is entered in the Well Statistics - LLR100 program.

Verify the DR 21-W Detail Sales report in the DR 21-W Detail Sales - REV830 program before running this process. Supporting detail prints by this process for each owner and it can be sent it to the owner with their copies of the DR 21-W.

The output can be created as a text file and/or sent to the _HOLD_ file (not printed). Report Manager is used to print the HOLD files. The detail report prints at default printer setup.

Text files must follow specifications set by the state of Colorado. These specifications include:

• Each recipient must be entered on their own line.

• The .txt file must be comma delimited.

• Non-numeric fields may not use periods or decimals.

• Dashes and hyphens must be omitted from numeric fields.

• Special characters may not be used.