EDI Viewer - GL Upload

EDI Viewer - GL Proration - Monthly

EDI Viewer can prorate Corporate Charge Codes: 030 Monthly Capital Cost Deduction, 040 Monthly Custom Processing Fee Deduction and 044 Monthly Operating Cost Deduction to a stream level.

How is monthly proration calculated?
Stream percentage of total monthly volumes multiplied by the monthly charge code dollars.
Stream dollars = (Stream Volume Percentage / Total Monthly Volumes) x Monthly CCA
$827.33 = ( ( 3894.65 / 210,563.2 ) x 44,729.35)

Monthly Proration Walkthrough:

The first step is to choose your Proration Method:

To the right of the drop-down menu, you may also decide to have the proration include All Products or Gas by itself.
If possible, it is highly recommended you use the Previous Yr data, as this is what the monthly estimate on the invoice is based upon

Your screen should now look similar to this:

The next step is to fill in the Deduction Amounts:

If you already have numbers in the Deduction Amounts table, you may want to begin by resetting any previous deductions, using the Reset Deductions button
Clicking Retrieve with no data on screen will give you an option to copy deduction amounts from another invoice.
You can now select which invoice to copy from:
Choosing Yes will take you through the following Confirmation window:
If No is chosen, the option to copy deduction amounts from an imported Allowable Costs Monthly Deduction CSV file is presented:
If the deduction amounts are left blank, it is possible to prorate at an invoice level, although this is less accurate
Deduction amounts can also be entered in manually

You should now have Deduction Amounts on screen:

Next, you may want to choose which wells are included in the proration:

Click the Show Streams button:
Uncheck the Include in Proration box for any wells that should not be included in proration:
Click the Save icon
Click the Show Facilities button:
Click Retrieve to update the numbers in the right-most column (this is the denominator the proration uses)

You are now prepared to run the Proration

Pressing the Prorate Monthly button will trigger a window confirming the numbers to be prorated.
Clicking yes will run the proration, which may take a few minutes
In the bottom left corner of the window you should see text explaining what the program is doing
The Totals row below the Deduction Amounts should match the numbers in the Invoice Amounts table on the left side of the screen. The amounts that were prorated will appear in the Prorated Amounts table on the left side of the screen
The Delete Prorated Entries button will remove any previous prorations. This can be confirmed by looking at the Prorated Amounts table on the left side of the screen -- if there are no previously prorated entries the table will be blank. Clicking the Retrieve icon will return the screen to the Deduction Amounts

After the proration has finished:

The red numbers signify wells that were not prorated to due to, due to having zeroes in the right-most denominator number, or in the deduction amounts. This can happen if wells are bought or sold but still appear on the invoice
You may also notice that the numbers in the Invoice Amounts and Prorated Amounts tables do not balance

The Final Step is to make everything balance

Clicking the Show Facilities not Prorated button will show all the red facilities that were not used in the proration. Again, you can see that either the right-most column, or the deduction amounts have zeroes. The number in the Totals row at the bottom of the screen should be the difference between the Invoice Amounts and the Prorated Amounts tables.

This difference can either be entered manually to the Deduction Amounts, or it can be entered in the Corporate Amounts table. This will add a one line entry to your GL Batch file for the difference. The sums at the bottom of the Corporate Amounts table should match the Invoice Amounts table
It is important to click the Show All Facilities button before the next step

At this point, run the proration again.

If you entered Corporate Amounts, you will now see them in the Prorated Amounts table.
The numbers in the Prorated Amounts table should now match the Invoice Amounts

More details from the proration can then be viewed in the Monthly Proration Details Report in the GL Reports tab:

This report provides an audit trail showing where the prorated amounts come from:

Each individual well's total is used as the numerator, with the facility total being the denominator
Dividing the well total by the facility total gives the prorated %
Multiplying this percentage by the facility total CCA/CP/UOC Deduction Amount gives the amount prorated to each well

If you used Corporate Amounts, they WILL NOT appear on this report. However, they will be included in the GL File you later create.