Rollup settlement Statements
Table of Contents
Produce settlement statements with the Rollup feature.
Typical reasons to use rollup: A) want to roll up wells into lease level report; B) Partnership or group reporting.
Option A: Rollup wells into a lease-level report
- In Company Maintenance > Partnerships > Rollup Options, change Rollup level to desired. Replace the last x digit(s) of the property number with *, with x being the last 1-7 characters (for example, if you want to combine all funds with the property of the first two digits of LA or NM, select Replace last x digits of Property number with *).
BEST PRACTICE: all decks for a given lease/owner should have the same roll-up group. - Set up property funds for Rollup in Property Maintenance (80).
- Run a Revenue/Billing cycle. The settlement statement information will have a roll-up according to setup.
Option B: Partnership or group reporting:
- In Company Maintenance > Partnerships > Rollup Options, change Rollup level to Rollup-Use Group/Partnership Code.
- Set up a Sub-Table for groups (our example is Sub-Table 105).
- Set up each group as a Sub-Account under the created Sub-Table.
- On the Division of Interest, enter the group in the Roll Group field.
- 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 generate 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 consist of 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 within each state.