<< Click to Display Table of Contents >> Navigation:  Revenue/Billing > Special Features > Rollup settlement stmts

Produce settlement statements with Rollup feature.

 

Typical reasons to use rollup:  A) want to rollup wells into lease level report; B) Partnership or group reporting.

 

 

Option A: Rollup wells into lease level report

 

1.In Company Maintenance > Partnerships > Rollup Options, change "Rollup level" to desired Replace last "x" digit(s) of property # with *, with "x" being the last 1-7 characters  (for example, if you want to combine all funds with property of first two digits of LA or NM, select “Replace last x digits of Property # with *”).

BEST PRACTICE: all decks for a given lease/owner should have the same roll-up group.  

2.Set up property funds for Rollup in Property Maintenance (80).

3.Run a Revenue/Billing cycle.   The settlement statement information will have rollup according to setup.

 

Option B:  Partnership or group reporting:

 

1.In Company Maintenance > Partnerships > Rollup Options, change "Rollup level" to Rollup-Use Group/Partnership Code

2.Set up a Sub-Table for groups (our example is Sub-Table 105)

3.Set up each group as a Sub-Account under the created Sub-Table.

4.On the Division of Interest, enter the group in the Roll Group field.

5.Run a revenue/billing cycle.  The settlement statement information will have a rollup according to the setup

 

 

 

NOTE: The Partnership Statements (created in Revenue/Billing, #33-Partnership Statements) will create a cash flow report in that it will only include the amounts that have been paid and/or billed to the owner(s). This does not include "Held" or "Suspended" amounts. It will include the amounts paid out of suspense that could have been distributed in prior months or years. The export will output the information by state first (within the U.S.) and then for each Accounts Receivable and owner number withing each state.