Download bill options

The Download option is visible after you select one or more bills.

bill list download options

Bill import file *

The bill import file helps you correct multiple errors at one time. You can download a bill import file, correct any errors on the bills, and upload into UtilityManagement.

* Use this option with caution. When you upload the bill import file, the original bills are deleted as well as bill history, flags, etc. This process creates new bills with the import file and the bill line item order matches the column order of the spreadsheet.

  1. Configure your filters.
  2. Select the bills from the bill list.
  3. Click Downloads, and then Bill Import File. The Excel file is downloaded to your computer.
  4. Update your billing information and save.
  5. Upload the file by using bill import.

Steps to export and import existing bills

For example, you want to fix dates that are keyed incorrectly on multiple bills.

Review the options for uploading bills (A/C/E and V/P/R) and what actions to take on the original bill (void or preserve).

  1. On the Bills tab of the meter.
  2. Check the box next to the bills you want included in the bill import file, use the checkbox in the header if you want to select all the bills.
  3. Click Downloads.
    download menu
  4. Choose the Bill Import File option. This generates an Excel file with all the bill data of the selected bills.
  5. Update the Excel file as needed and save to your computer.
  6. Click Create and choose Import Bills.
  7. In the Upload dialog box, choose Advanced as the Import Format.
  8. Use the open batch or create a new one. A best practice is to create a new batch, this lets you undo the import easily if you have a problem.
  9. Click Import.
    upload form
  10. Review the results in Bill Imports.
    bill import log

PDF of Selected Bills

This option creates one PDF file of the bills.

  1. Configure your filters.
  2. Select the bills from the bill list.
  3. Click Downloads and then PDF of Selected Bills.
  4. The file is saved to your computer.

Bill list to Excel

Turn your bill list into an Excel spreadsheet.

  1. Configure your filters.
  2. Use the Actions menu for the bill list.
  3. Choose Download Bill List to Excel.
  4. The file is saved to your computer.