 |
EDI
Viewer - AC Restriction Proration Window
|
EDI Viewer can prorate corporate Charge Code 101 Annual Allowable Cost Restriction Adjustment to a stream level on a year-by-year basis:
How is allowable costs restrcition proration calculated using net royalty dollars?
- Stream percentage of total yearly Net Royalty multiplied by ACR Adjustment subtract
ACR charges already booked.
- Stream dollars = ((Stream Net Royalty/total Net Royalty for year) x
ACR Adjustment) - (Total previous ACR Adjustment booked)
- $ 2000.00 = ( ( 33,415.24 / 510,980.83 ) x
44,729.35) - 925.05)
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 also see the AC Restriction Adjustment amount next to your Invoice Number below this drop-down.
- Next, click the Retrieve icon. If you have imported the Allowable Cost Restriction Summary file, you will see a prompt which allows you to use the file to
fill in the Adjustment Amounts by Facility:
- If you clicked Yes, you will see the 'Adjustment Amounts entered for this Invoice' column on the left of the window populated with data, which will balance to the Invoice Amounts
table above. You should also see the Adjustments match the amount on the bottom right of the window on a year-to-year basis.
- If you clicked No, the Adjustment Amounts on the right side of the window will all be zero, and you will be able to manually enter
your desired adjustments.
- When your adjustments are entered, and you're ready to prorate, click the 'Prorate Annual' button. The following confirmation message
will appear:
- Clicking Yes will run the proration procedure. When complete, you will see the amount prorated in the bottom-left of the window:
- If the amount prorated doesn't match the invoiced amount at the top-left of the window, clicking the 'Show Facilities
Can't Be Prorated' button will show which facilties are causing the imbalance. Typically, these are facilities with a
denominator of 0. These amounts can be manually added to other facilities. Continue running the proration until your
prorated amounts table at the bottom of the window balances to the Invoiced Amount.
- You can see a detailed breakdown of the proration by going to the GL Reports tab and Retrieving the Annual AC Restriction
Proration Details Report:
