How To Do Bill Adjustments

The bill adjustment feature in EnergyCAP is designed to help make adjustments to bills which have already been entered and saved.  The process involves the creation of two transactions as a result of the adjustment – a credit bill and a debit bill.  The adjustment can include one or all of the line items from the bill being adjusted.  Also, the GL, Accounting Period, and Control Code values can be modified for the adjustment bills.

How to Create Adjustments for a Bill

! Before making bill adjustments, please contact your EnergyCAP System Administrator to determine if creating Bill Adjustments will have any impact on financial system interfaces such as accounts payable.  You will need a good understanding of how these interfaces are set up in order to complete a successful bill adjustment. !

• If you use Batch Mode you will need to create an open batch to use the Bill Adjustment option (See Work Flow Manager for more information on Batch Mode).

• Go to Work Flow Manager and click on the Open/Close Batch button  to create a batch if you do not have one currently open.

! The name of the batch may be important since some financial system interfaces require a certain naming convention for bills intended to be paid (for accounting system purposes external to EnergyCAP) and those intended for internal adjustments (for reporting purposes in EnergyCAP) !

NOTE: You can only create bill adjustments for SAVED bills.

• Edit the bill, either from the Account Manager or the Work Flow Manager as follows:

• Highlight the bill to be adjusted from the Account Manager > Bills tab and access the edit window (Bill/Edit or right-click popup menu) OR

• highlight the bill to be adjusted in the Work Flow Manager module and access the edit window (Bill/Edit or right-click popup menu)

• From the Bill Entry / Edit window, click on the wrench icon  in the upper-right corner of the edit window. the Line Item Adjustments window will open.

• The Line Item Adjustments window is divided into four different regions:

1. Source Bill Information: Contains details about the source bill being edited.

2. Target Account / Meter: Used to select a target account and meter OTHER than the current Account / Meter to create the adjustments to.

3. Modify GL, Accounting Period, and Control Code on Adjustments: Contains the options for changing the adjusted bills’ values for these fields.

4. Source (original bill) and Target (adjusted) Bill Line Items: Contains the line items that will be used to create the adjusted bills.

• If necessary, update the values in the Target Account / Meter section to reflect the changes in the new bill.  If the adjustments need to be made to an account other than the current account, click on the Find Account button.  If the adjustments need to be made on the same account, but a different meter, click on the drop-down arrow and select the meter the adjustments are to be made on.  If the adjustments are being made to the same account /meter, leave these values alone.

• If necessary, update the G/L Record or Accounting Period Options.
  NOTE: G/L Record Options affect ONLY the adjustment bill for the target Account/Meter.
  

• Use Target Meter G/L: This option will use the G/L Record (if any) assigned to the target Account/Meter as the G/L for the adjustment bill created for the target Account/Meter.

• Same as Original Bill: This option will use the G/L Record (if any) from the source bill as the G/L for the adjustment bill created for the target Account/Meter.

• Leave G/L Record Blank: This option will simply not assign a G/L Record for the adjustment bill created for the target Account/Meter.

• Use this G/L Record: This option allows for ANY G/L Record in EnergyCAP to be assigned to the adjustment bill created for the target Account/Meter.

• Account Period Options: Affects the adjustment bills for the target and source Account / Meter

• Leave Account Period Blank: This option will leave the Account Period blank for the adjustment bill created for the target Account/Meter as well as the adjustment bill created for the source Account/Meter.

• Same as Original Bill: This option will use the Account Period (if any) from the source bill for the target Account/Meter as well as the adjustment bill created for the source Account/Meter.

• Use this Period and Year: This option allows for ANY combination of Account Period and Year to be used for the target Account/Meter as well as the adjustment bill created for the source Account/Meter.

• Control Code: Affects the adjustment bills for the target and source Account / Meter as well as updates the Control Code on the original source bill

• New Control Code / Comment: The value placed here will be used for the target Account/Meter as well as the adjustment bill created for the source Account/Meter.  Changes here will also update the value(s) in the original source bill.

• In the Source and Target Bill Line Items section, select the line items from the source bill that need to be adjusted.

  • To move all line items from Source Bill Line Items to Target Bill Line Items, click on the   button.

  • To clear all line items from Target Bill Line Items, click on the   button.

  • To move one line item at a time from Source Bill Line Items to Target Bill Line Items, click on the value you want to move and then click on the  button.

    
    NOTE: Any line item can be "copied" multiple times to the Adjustment Values pane.

• As values are moved into Target Bill Line Items, the values for each item will appear in red text.  By default, the adjustment will include the entire amount, therefore effectively zeroing out the original source bill.  Be sure to edit the values to the correct amounts.

• Verify all the values you have entered in the Line Items Adjustments dialog box, and click the Create Adjustment Bills button...

  

  ... to save the Adjustment Bills (the credt bill for the original bill and the debit bill reflecting the
  Adjustment(s).

• If you wish to cancel your changes instead, click on the Exit Without Saving button. 

• You will be returned to the Bill Edit window.  Close this window by clicking on the Close button.