Revenue/Billing Tab (Owner Maintenance)
Table of Contents
Owner Setup - See Sub-Account Maintenance for more information on setting up the Name and Address fields. Also, for common tabs and options.
Owner Maintenance is very similar to Sub-Account Maintenance and contains all necessary information to distribute revenue to and/or pay an owner. The Revenue / Billing tab, in particular, dictates the Payment Code, Payment Method, 1099 Options, and whether the owner will be netted or not. This information ensures that the owner’s interest is processed correctly in a cycle and that the 1099s are correct at the end of the year.
Two sub-tabs are used. The first is the Summary tab, which gives an overview of different settings, including company settings. The General tab is where changes can be made to the Owner setup.
Revenue/Billing Tab:
Summary sub-tab
- If the owner has the same TaxID as another owner, a message will show at the top of the Summary Screen. Use the Duplicate Tax ID Rpt button to the right to print a report. It will default to the current owner you are on for you. If there is no duplicate, the button will not show.
- This will show the last 2 checks for this owner and display whether the check has been cleared, voided, or is still outstanding. Use the Pmt/Billing History button to the right for more extensive information.
- The owner’s minimum payment amount option will be shown from the General tab.
- If the owner has a minimum payment code that indicates the owner’s suspense was sent to the state (Unclaimed Property/Escheat), then this will be indicated. Use the Sent to State/Unclaimed button on the right for more information; it will default to the current owner you are on for all of the applicable settings. If this owner has not been escheated, this button will not show.
- Shows the owner’s netting and payment options set on the General tab.
- Shows all AR accounts as defined in the AR range, including current suspense balances and AR balances. Use the Suspense Maint button to the right to print an extensive detailed report; it will default to the current owner you are on for all of the applicable settings.
- Shows active DOI(s) for the owner and the current Pay/Legal status. Use the DOI List/Edit button on the right for more extensive information; it will default to the current owner you are on for you with all of the applicable settings.
- This shows the last two Changes for this owner. Use the View Change History to show changes made to the owner's Sub-Account maintenance for the full-time frame in which the owner is considered active.
- Shows company options that affect Netting and Payments. These can also be found in the Revenue Billing > Company Maintenance > 90 Company/Pty Susp Net tab and Partnerships Tab.
- Company DOI List: This will only be visible if it is licensed for Consolidation.
- DOI Chg Log: Use the DOI Change Log button to see any changes for this owner. It will default to the current owner you are on for all applicable settings.
- Suspense Change Log: Use the Suspense Change Log button to see any changes for this owner. It will default to the current owner you are on for all applicable settings.
- Extra Owner Info and Division Orders: Used with the Division Order Process.
- Print/Email: create a printable view of the Summary that can be printed or emailed.
General sub-tab
Payment Code D 1…3 P U |
This is a one-character code used to indicate the minimum payment amount for the owner. If the total amount payable for the owner is less than the minimum payment amount, the amounts payable for the owner are temporarily placed in petty suspense. The cycle can also use this to pay or suspend certain owners. Don't Pay - the owner will not get a check. Any amounts for this owner will be placed in petty suspense, regardless of the dollar amount. Pay code amounts 1 thru 3 as specified in the Revenue/Billing Company Master > Pty Susp/Net Tab. The minimum amount to test for petty suspense items. If the revenue cycle is run with the Flush Petty flag on, this value is ignored, and the owner is treated, for this run only, as if they were coded with the "minimum check amount when flushing petty suspense." Pay always. The owner is written a check if the net amount due is positive. U - Submitted to Unclaimed Property. A "U" on the owner master means that the owner has already had funds escheated once (possibly outside the system). When the Pay Code is changed to "U," a message will appear if there are checks that need to be voided prior to changing the pay code. |
Withholding | Select the Fed/State Withholding for this owner. |
Deduct |
W = Deduct Working Interest Revenue only against A/R Balance; Yes = Net Everything, Deducts all revenue against A/R balance; No = No Netting, deduct nothing against A/R balance; O = Net Working and Override, deduct Working and Override interest against A/R balance from the owner's check. |
Refund credit AR Balances | This option works similar to the owner netting option. The radio button on this screen and the check box on the cycle extract screen "Refund Credit AR..." must both be checked in order for the credit balance in an AR account to be refunded to the owner. |
Exempt from "Other" / "Taxes | Checking one or both of these options will auto-populate these exemptions on the Division of Interest when the owner is added to the DOI. NOTE: Owner level correction utilities till not be impacted by this. They will still look to the history and any exemptions in the history will still be transferred to the new owner(s). |
Payment Method |
Designate the payment method as Check, Direct Deposit, Wire, or Credit Acct.
|
Tax ID Type | Click the indicator for either SSN, EIN or ITIN to select the appropriate Tax ID Type. |
Tax ID |
Enter the 11-digit tax ID number to be used on the 1099. For example, a Social Security number is entered as 440-15-1234, and a federal tax ID number is entered as 75-1234567. NOTES:
|
Tax Class |
Select the TAX ID type: Individual/Sole Prop/Single LLC, C Corporation, S Corporation, Partnership, Trust/Estate, LLC-Corp, LLC-S Corp, LLC-Partnership, Other or Exempt. The default is Sole Proprietor. The Tax Class designation determines aspects of how the 1099 will be produced. |
Has W-9 | Check this box if the owner has a W-9 on file. This is informational only. If you have the scanning add-on you can scan the signed W-9 into the Documents tab. |
Extract to 1099 | This should be checked by default. However, if this owner should not pull into the 1099 system, uncheck this box. |
Check Memo Description | Information entered in this field will print on the owner's check. |
Addresses sub-tab
This screen allows you to define a different address for the check to be mailed to and/or for the tax information to be mailed to.
Address: Pay, Tax | 1 digit code: 1, 2 or 3. The code represents the address to be used for the given function. Normally all three address types are the same and you would use a 1. If different, change here and the click on then related address Edit button. NOTE: The address under the owner is considered Sub-Table 101 and will always be the Settlement Statement address. If you want the check to go to a different address, enter a new address in Sub-Table 102 and change "Pay" to go to #2. You also have the ability to code an additional email address for the Pay address. This will allow the billing and revenue statements to be emailed to different addresses but will only be honored if Revenue cycles are run separately from Billing cycles. |
Other sub-tab
Owner Master - Other Tab | |
Quick Pay | (Checkmark and rate)—This is used to identify which owners are to be paid when starting a Quick Pay Revenue Cycle. The rate is the penalty per BBL that the owner is charged for getting paid their share early. Note: a special Property—Quick Pay setup must be set up with a Rev Deduct for the system to know how to code the Quick Pay deduction. |
Pay Group codes | This can be used to restrict which owner(s) are getting paid on a Revenue cycle. Define an alphanumeric code for each group needed. There can be only one pay group code per owner. |
Deduct G/L Balance from net check amt options |
Sometimes, it is required to deduct a certain percentage of a revenue owner’s net check each cycle. Net check would be after all other deductions, including federal/state backup withholding or deductions for netting of JIB (accounts receivable). You may be allowing a working interest owner to pay off a notes receivable created by an IRS code section 1031 like-kind exchange or perhaps for general business reasons. Use the Fund Deducts feature to create an owner-level reserve for future drilling activities. |
Reporting sub-tab
You must be authorized for Project Reporting to see this tab.
Enter reporting options. Also, see Financial Rep/Broker to send the report to a third party and Royalty Reporting for state royalty reporting.
Statement sub-tab
Print on Paper |
Select the circumstances in which you would like a paper check to print.
|
Upload to Connect | Works in conjunction with the Connect Add-On. Gives the option to upload owner statements to the Connect owner relations system. |
Send Via E-mail | See E-Mail Statements (creates a .pdf file owner copy) |
Print each property billing detail on a New Page | When the option is checked, the system will print a settlement statement, followed by Billing Detail (unless detail is set to no for this owner), then followed by all the revenue. |
Print Billing Summary by Category | Prints a recap of the owner's billing by category to the end of the settlement statement. |
Print Revenue Detail Separate from Billing | Selecting this option will print the revenue detail on the settlement statements separate from the billing detail for the owner. Check this box prior to running a revenue and billing cycle together. Doing so will enable you to simultaneously run cycles for revenue/billing and the system will print the revenue detail separate from the settlement statement. Typically, this feature is used to send billing and revenue to two different departments so that each can later be processed separately. |
Print Detail | Included detail printed settlement statements without the detail in Rev/Bill After Check Reports > Settlement statement only |
No detail | Excludes detail printed settlement statements without the detail in Rev/Bill After Check Reports > Settlement statement. Note: Non Working Interest owners will receive revenue detail always. |
Sum by acct | Instead of printing detail prints a summary of the detail by account number. |
(Note - regardless of the method selected above, historical cycle PDF copies retain detail always)