Setup Basic Allocations
Written by Brandy Burch
Updated at January 17th, 2025
Table of Contents
Setup - Property Maintenance
In this example, we will set up a new facility (TX1000 – Wallace Tank Battery) and enter a Commingle Permit Number.
Commingle Permit # is entered to activate the Commingle Maint. button. Remember to uncheck the “Print Permit # on State Reports” for the Commingled property when reporting at the property level. The check mark must be on the Allocated Properties, not the Commingle Property.
NOTE: If you enter a temporary or dummy Commingle Permit number, you may also leave the Print Permit # unchecked.
The next step is to create the Allocated Properties. The properties that belong to the Commingle will need to be added into the system as an Allocation. You will notice that since these examples are reporting at the property level, the option to Print Permit # on State Reports is checked for the Allocated properties.
Setup - Commingled Facility Maintenance
Once the allocation properties have been added, return to the Commingle Property and click the Commingle Maint button. The Commingle Maint button on the Property Maintenance > Production tab will be found. Add the properties in the Commingle that have an allocation percentage.
An example of the Factor Title header is set as Percentage.
| Commingled Facility Maintenance | |
|---|---|
|
Cross-Ref by Sub-Account: |
Click on this button to get a list of all the allocations a Sub-Account is in. |
| Decimals | Sets the number of decimal positions in the allocation. |
|
Factor Title Token Title |
This is typically the percentage of volume or BBLs based on how you receive allocations from the operator. |
| Effective Date Option: |
Fixed (no date): This option is not date-sensitive. This is typically used if the percentages for each property do not change. Exact Match: The date field will appear for you to enter the exact date. You must have a specific Production Month for the allocation to work. Latest Set: Will allocate based on this set until a new one is created. |
| View Date | This field is used with the Exact Match and Latest Set Effective Date Options. |
| Property | These are the properties to which the entry will be allocated. The properties you enter here must already be set up in Property Maintenance. |
| Computed Pct | Computer calculated - read-only field |
|
Factor (Column Header will reflect what was entered in the Factor Title field above) |
Use the factor field to specify how you want the entries to be allocated. The allocation ratio will be based on the individual Property factor divided by the total factor. |
Notes:
- The system corrects for rounding errors, so the sum of the allocated property totals always equals the commingled property totals.
- The Import Set within the Utilities button allows you to import your allocations. If the allocation already exists, the Allocation Description, Basis Title, and Token Title will not be required and can be left blank.
- The View Date will default to the last reporting month for all options except Fixed (No Date), regardless of the date of the record being viewed.
Example: Today’s date is 07/15/2023; when I go into Facility Maintenance to view the record, it will ask if I want to create a new set as of 06/2023. The middle of the screen will show the date being viewed
The List button on the Commingle Facility Maintenance allows you to view the allocations based on the Commingle permit number, effective date, and operator.
Allocation
During ticket entry, the Commingle property is used. Then, as previously discussed, the system will reallocate production from Commingled Properties to Allocated Properties (also called a recalculation).
Recalculations can be done at any time. A cycle does not need to be in progress to see the reallocated breakout. The following are ways to trigger a recalculation:
- Using menu item #14 Recalculate Tickets
- Generating Operator Run Statements
- Using menu item #22, Extract Tickets to GL/Rev
Viewing Allocations
Several reports show the recalculation. However, we will cover the two most common.
Reports > Statements tab > Operator Run Statements
- On the General tab, ensure the Force Recalculate Prior to Printing Report option is checked. This will trigger the recalculation.
- On the Special tab at the top, check the box for Allocation (Detail) Level. This will allow you to see the details for each allocated property.
Reports > Tickets tab > Run Ticket Views.
Make sure the box for either Allocation (Header) Level or Allocation (Detail) Level is selected on this screen. The Header option will show the Commingle property, while the Detail option will show the individual properties.
Please see Grid View for more information on working on these screens.
See Allocation Examples for more information.