Report-20

Estimated Accruals by Commodity

A data table, grouped by commodity, fills in the gap with an estimated value from the end date of the most recent bill to a user-defined end date (typically the end of an accounting period or fiscal year). Uses a simple average daily cost extrapolation method.

For a meter to be included in the report, the most recent bill's end date must be within 15 months before the end date specified in the End Date filter. If the most recent bill's end date is greater than 15 months before the specified end data, it is excluded from the report.

You can use the filter Group by and choose meter or place.

Report-20 tip

The meter report contains more details such as, accrual start date, accrual end date, days, average daily cost, and estimated accrual amount.

Set your filters for Report-20

  1. Set your End date for the report.
  2. Decide if you want to Group by meter or place.

Other filters to consider Report-20

  1. 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.
  2. Void bills
    Include if you want a full audit history.
    Exclude to focus only on valid financial activity.
  3. Report to a subset of data
    Set a filter such as Topmost place, Site group, or Commodity.

Available filters for Report-20

Required filters

  • End date
  • Group by
  • Only "Include in Accrual" accounts

Optional Filters

  • Account name
  • Account number
  • Accounts in cost center code
  • Accounts in cost center name
  • Batch
  • Bill entered by
  • Bill entry date
  • Bill has been split
  • 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.
  • Commodity
  • Commodity category
  • Exported to AP
  • Exported to GL
  • Held from accounting export
  • Meter code
  • Meter group
  • Meter name
  • Meter serial number
  • Meters in site code
  • Meters in site name
  • Pay status
  • Payment cleared date
  • Payment sent date
  • Payment type number
  • Rate schedule