Report-18

Bill Line Item Report

Bill details grouped by Bill Line Item Caption. You can search for a specific Bill Line Item Caption or Bill Line Item Type.

Report-18 recommendations

  • The report is limited to 10,000 line items, it may be helpful to limit the report to a subset of data, set a filter such as Topmost place, Building group, Vendor, or Commodity.
  • To avoid lines with a zero or null value, set the filter, Bill line value to not equals 0 (zero).

Report-18 tip

You can use this report to see information only line items. (Info_Cost, Info_Demand, Info_Use)

Set your filters for Report-18

  1. Set the Bill line caption or Bill line item type.
  2. Set the Bill line value not equal to zero.

Other filters to consider for Report-18

  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. 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.
  3. Void bills
    Include if you want a full audit history.
    Exclude to focus only on valid financial activity.

Example filters for Report-18

Available filters for Report-18

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 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.
  • Bill line caption
  • Bill line type
  • Bill line value
  • Bill total cost
  • Commodity
  • Commodity category
  • Date range
  • Due date
  • Exported to AP
  • Exported to GL
  • Held from accounting export
  • Include accruals bills
  • Include reversed accrual bills
  • Meter code
  • Meter group 
  • Meter name
  • Meter serial name
  • Meters in site code
  • Meters in site name
  • Pay status 
  • Payment cleared date
  • Payment sent date
  • Payment type number
  • Rate schedule
  • Site group
  • Topmost cost center code
  • Topmost cost center name
  • Topmost place code
  • Topmost place name
  • Vendor code
  • Vendor name