Bill import lets you import multiple utility bills at one time. It's recommended to import your bills into their own batch. This lets you delete the batch and bills if you have an error.

Importing bills varies from simple to complex depending on the granularity of information.

How to import bills

Two methods for importing bills:

• Bill Import File Format (used to import a bill file from a vendor).
• Bill Import Advanced Format (configure the file specifically to match UtilityManagement's format).

Bill Imports page

The Bill Imports page provides:

• Ability to add a comment to the import.
• Option to download the import file.
• Download a kickout (error) spreadsheet of failed import bills.
• Bill list of all the bills imported in the batch.
• Bill list of the bills flagged during the import.
• Batches filtered by date, import user, or import status.

After you import your bills, the bill is saved, analyzed and then flags are assigned. A new icon appears while a bill is being analyzed. 

Service effective dates for accounts also affect your ability to import bills.

Import

To import a bill, the begin and end dates for the bill must fall on or within the service effective dates of the account. A kickout (error) spreadsheet is created if the bill is outside the specified date range.

For example, service effective dates for an account of 6/24/19 to 7/25/19 produce the following results during bill import.

Manual entry

If you try to manually enter a bill outside of the service dates, a yellow banner is displayed stating your bill is outside the specified date range.

Effective date for linked account meter

Import

During the bill import process the effective date for the linked account meter relationship does not prevent a bill from being imported.

Manual entry

If you attempt to manually enter a bill outside of the effective date for the linked account meter, only account charges can be entered.