Report-11

Bill Transfer Format (Excel only)

This report exports detailed bill data to an Excel file with minimal formatting. It's designed to make the data easy to use in tools like Excel or for further transformation.

Key Features

  • Detailed data: Includes all the bill-level information (e.g., account, vendor, amounts, dates).
  • Plain format: No special styles or formatting — ideal for custom use cases like:
    • Filtering
    • Pivot tables
    • Uploading into third-party tools

⚠️ Important Notes

  • Not import-ready: This file does not match EnergyCAP’s Utility Management bill format.
  • You cannot use it to import bills back into EnergyCAP.
  • Think of it as an export-only tool — for reporting, analysis, or transferring data to other systems.

Report-11 recommendations

When you are reporting on Cost Avoidance, remember to run Cost Avoidance -> Calculate Savings first.

Filters that will include more columns in Report-11

This filter Include quick check columns the following columns are added to your spreadsheet:

  • Meter serial number
  • Native unit cost (meter use unit)
  • Common (rollup) unit cost
  • Load factor %
  • Hours in BP
  • Due date
  • Statement date
  • Invoice number
  • Control code

When you select the filter Include bill status information the following are added to your spreadsheet:

  • Use Per Day
  • Cost Per Day
  • Acquisition Method
  • Received
  • Sent for Processing 
  • Return from Processing
  • Processing Complete
  • Exported to AP
  • Exported to GL
  • Created Date
  • Created By
  • Modified Date
  • Modified By
  • Bill Note

When you select Include payment information the following columns are added to your spreadsheet:

  • Pay status
  • Exported for payment
  • Funds withdrawn date
  • Payment sent date
  • Payment cleared date
  • Payment amount

Set your filters for Report-11

  1. Display options
    Decide if you want to see codes, names, or both.
  2. Billing period or Accounting period.
    Billing period is based on actual bills. Accounting period is based on your organization's fiscal calendar.

Other filters to consider for Report-11

  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. Bill is from external vendor
    If not selected, includes data from both vendor and chargeback (internal) bills.
  3. Void bills
    Decide whether to include or exclude void bills in your report.

Available filters for Report-11

Required filters

  • Data type - Can be calendarized, billing period, or normalized.
  • Display codes, names, or both? - Select how you want the report formatted.

Recommended filters

  • Bill is void - If this filter is not included both void and not void are included.
  • Billing period
  • Cost recovery
  • Flag assigned to me
  • Flag assignee
  • Flag issue
  • Flag status
  • Flag type
  • Flag unassigned
  • Include audit custom fields
  • Include bill status information
  • Include Cost Avoidance fields
  • Include demand columns
  • Include estimated column
  • Include parent place
  • Include quick check columns
  • Include use and demand units
  • Meter group - Lets you filter the report to a specific group of meters.
  • 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

Optional Filters

  • 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 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.
  • Billing period year
  • Commodity
  • Commodity category
  • Date exported to AP
  • Date exported to GL
  • Exported to AP
  • Exported to GL
  • Held from accounting export
  • Include accrual bills - If this filter is not included the report include accrual bills.
  • Include reversed accrual bills
  • Meter code
  • Meter name
  • Meter serial number
  • Meters in site code
  • Meters in site name
  • Pay amount
  • Pay status
  • Payment cleared date
  • Payment sent date
  • Payment type number
  • Rate schedule