Report-09 and 9a

Report-09 Bill PDF

A PDF report that creates "utility bills" designed to look like a typical bill. The bill PDF is similar to viewing the bill in UtilityManagement. It includes charts, with calendarized use, cost, and unit cost.

It may be helpful to set a topmost place or topmost cost center, and a billing period to create only a subset of bills. This report is limited to 1,000 pages. Use Report-09a to create a PDF of chargeback bills to send to internal customers.

Report-09 tip

Do you want a single bill PDF? Use the View Generated PDF from any bill list.

Set your filters for Report-09

  1. Set a Billing period or Accounting period.
  2. Select a Topmost place, Site group, or Commodity.

Other filters to consider for Report-09

  1. Active accounts only
    Decide whether to include only active accounts.
    If this filter is not applied, your report includes both active and inactive accounts.
  2. Void bills
    Include if you want a full audit history.
    Exclude to focus only on valid financial activity.
  3. Bill is from external vendor
    If not selected, includes data from both vendor and chargeback (internal) bills.

Report-09a Bill PDF Invoice Format

A PDF report designed to look like a bill from a utility company. This is helpful for customers as they don't need to learn UtilityManagement terminology. Use or cost is graphed with an overlay of the meter's weather data.

Report-09a is useful for chargeback bills sent to customers. Bills can be created internally from submeter readings or percentage splits. It may be helpful to set a topmost place or topmost cost center and billing period to create only a subset of bills. This report is limited to 1,000 pages.

You can combine this report with Report Distribution and have bills sent automatically on a regular schedule.

Customize your Report-09a

You can add a logo and an invoice disclosure to your report. 

Create two custom fields for the rate schedule and vendor.

  1. Use the Vendors and Rates module menu and select Custom Fields for Rate Schedules.

    -Click the plus to add a new custom field.
    -Select Formatted text as the type of custom field.
    -Name the field INVOICE DISCLOSURE.
  2. Use the Vendors and Rates module menu and select Custom Fields for Vendors.

    -Click the plus to add a new custom field.
    -Select image as the type of custom field.
    -Name the custom field INVOICE LOGO.
  3. Populate the custom fields for the vendor and the rate schedule.
  4. Generate a report and review.

Sample Report-09a

Set your filters

  1. Chart data type lets you decide if you want cost or use displayed in the report graphics.
  2. Set a Billing period or Accounting period.
  3. Select a Topmost place, Site group, or Commodity.

Other filters to consider

  1. Do you want to include only Active accounts?
  2. Include or not include void bills?
  3. Include Bill is from external vendor? 
  4. Decide if you want to Show bill notes.

Available filters for Report-09

Recommended filters for Report-09

  • Cost recovery
  • Flag assigned to me
  • Flag assignee
  • Flag issue
  • Flag status
  • Flag type
  • Flag unassigned

Optional filters for Report-09

  • Account is active - If this filter is not included, includes both active and inactive accounts are including in the report.
  • Account name
  • Account number
  • Accounting period
  • Accounts in cost center code
  • Accounts in cost center name
  • Batch
  • Bill entered by
  • Bill entry date
  • Bill has been split
  • Bill ID
  • Bill import verified
  • Bill is approved
  • Bill is from external vendor - When this filter is not selected, the report includes data from both vendor (external) and chargeback (internal) bills.
  • Bill is void - If this filter is not included both void and not void are included.
  • Billing period
  • Exported to AP
  • Exported to GL
  • Held from accounting export
  • Include accrual bills
  • Include reversed accrual bills
  • Meter code
  • Meter group - Lets you filter the report to a specific group of meters.
  • Meter name
  • Meter serial number
  • Pay status
  • Payment cleared date
  • Payment sent date
  • Payment type number
  • Site group - Lets you filter the report to a specific group of sites.
  • Topmost cost center code - When you use this filter you are selecting the topmost cost center you want to be included. When you set a topmost cost center it is the highest level of the accounting tree used, this lets you select a subset of data for reporting.
  • Topmost cost center name - When you use this filter you are selecting the topmost cost center you want to be included. When you set a topmost cost center it is the highest level of the accounting tree used, this lets you select a subset of data for reporting.
  • Topmost place code - Select the topmost organization or site you want to be included. When you set a topmost organization or site it is the highest level of the facilities tree used, this lets you select a subset of data from your tree for reporting.
  • Topmost place name - Select the topmost organization or site you want to be included. When you set a topmost organization or site it is the highest level of the facilities tree used, this lets you select a subset of data from your tree for reporting.
  • Vendor code
  • Vendor name