Report-41

Bill and Batch Spreadsheet (Excel only)

An Excel report provides bill-by-bill details grouped by batch code, entered by, cost center, vendor, or entry date.

Report-41 tip

Use the Include filters to add more columns to your spreadsheet.

Set your filters for Report-41

  1. Group by
    Select what type of bills you want to view.
  2. Include account charges
    Decide whether to include one-time or periodic charges.
    These are not linked to use or demand on the bill.
  3. Date range
    Set the time period for the report.

Other filters to consider for Report-41

  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. Chargebacks or Vendor Bills
    Use the Bill is from external vendor filter:
    • Select yes to show only vendor bills.
    • Select no to show only chargeback bills.
    • Leave blank to include both.

Example filters for Report-41

Available filters for Report-41

Required filters

  • Group by - decide how you want your report grouped.
  • Include account charges - Account charges are separate from meter charges and not used in calculating unit cost. (For example, late fees, connection charges, or deposits)

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 account custom fields
  • Include audit custom fields
  • Include payment columns - Includes pay status, exported for payment, funds withdrawn date, payment sent date, payment cleared date, payment amount
  • Include status columns
  • Include tracking columns
  • Meter group
  • Site group
  • Topmost cost center code
  • Topmost cost center name
  • Topmost place code
  • Topmost place name
  • Vendor code
  • Vendor name

Optional Filters

  • Account is activeIf 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
  • Held from accounting export
  • 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