EDI Viewer - GL Upload

EDI Viewer - GL Proration - Annual Method

EDI Viewer can prorate Corporate Charge Codes: 080 Annual Capital Cost Adjustment, 090 Annual Custom Fee Processing Adjustment and 095 Annual Operating Cost Adjustment to a stream level on a year by year basis.

How is annual proration calculated using net royalty dollars?

Stream percentage of total yearly Net Royalty multiplied by CCA subtract total previous monthly and annual charges booked.
Stream dollars = ((Stream Net Royalty/total Net Royalty for year) x CCA) - (Total previous Monthly and Annual CCA booked)
$ 2000.00 = ( ( 33,415.24 / 510,980.83 ) x 44,729.35) - 925.05
Annual prorating entries are booked to the last month of the year your prorating to (i.e. prorating for year "1999" then GL date "31-DEC-1999")

Annual 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.
You should use the same option that was used for the monthly proration

The screen should now look like this:

You should see amounts in the Invoice Amounts table
The table at the bottom left should have the sum of all monthly prorations for the year, but nothing for annual yet
If this is your first annual proration for the year, the Adjusted Amounts table will be blank

You can now enter your Deduction Amounts:

The first time the Annual Proration is run for a production year, it will reverse the monthly proration estimates for that year, creating reversing entries for December 31 of that year. Then the Annual proration amounts will be calculated using the actual volumes/dollars for that year. This should give you more accurate prorated amounts.
Any subsequent annual prorations should be the difference between the previous invoice amount and the current invoice amount.

You are now prepared to run the Proration:

Pressing the Prorate Annual 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
When the proration is done, you will see the Monthly Amounts in the bottom left table are now zeroes, and The Deduction Amounts entered are now in the table in a new row annual with the year chosen.

The rows in red are rows that were not prorated to. This could be due to them having no Deduction Amounts entered, or being empty in the right-most columns which are used as the proration denominator

More details from the proration can then be viewed in the GL Reports tab:

Checking the Monthly Proration Details report shows the monthly amounts that were reversed out:
The Annual Proration Details 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 Deduction Amount gives the amount prorated to each well