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 is available as: PDF, Excel

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.
    • Do not include the filter both vendor and chargeback bills.
  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 - Set an end date for the report.
  • Group by - Select the meter option if you want more details such as accrual start date, accrual end date, and estimated accrual amount.
  • Only "Include in Accrual" accounts - Select yes or no.

Optional Filters

  • Account name - Filter for one or more accounts. This filter is not compatible with topmost or group filters.
  • Account number - Filter for one or more accounts. This filter is not compatible with topmost or group filters.
  • Accounts in cost center code - Filter to include accounts directly under one or more cost centers. To see all the accounts at a certain level in your hierarchy use the Topmost cost center filter. This filter is not compatible with other topmost or group filters.
  • Accounts in cost center name - Filter to include accounts directly under one or more cost centers. To see all the accounts at a certain level in your hierarchy use the Topmost cost center filter. This filter is not compatible with other topmost or group filters. 
  • Batch - Filter to include bills from one or more batches, to include all the bills in the batch, do not set a topmost, Date range, or other specific filters. TIP: You can combine with other filters if you want to refine your results.
  • Bill entered by - Filter to one or more bills. To see all the bills do not set a topmost, Date range, or other specific filters.
  • Bill entry date - Filter to one or more bills. To see all the bills do not set a topmost, Date range, or other specific filters.
  • Bill has been split - Bill splits are configured on the account. This type of chargeback splits the entire bill to destination meters.
  • Bill import verified  - deprecated filter.
  • Bill is approved - Select approved or not 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 - Select one or more commodities to include in the report. This filter is not compatible with the commodity category filter.
  • Commodity category - Select one or more commodity categories to include in the report. This filter is not compatible with the commodity filter.
  • Exported to AP - Select yes or no.
  • Exported to GL - Select yes or no.
  • Held from accounting export - Select yes or no.
  • Meter code - Filter to one or more meters. This filter is not compatible with topmost filters.
  • Meter group - Filter for specific groups, to include all the group members do not set a topmost filter. TIP: You can combine with other filters if you want to refine your results.
  • Meter name - Filter to include one or more meters. This filter is not compatible with topmost or group filters.
  • Meter serial number - Filter by one or more meters. To include all results do not set a topmost, group, or other filters.
  • Meters in site code - Filter to include meters directly under one or more sites. TIP: To see all the meters at a certain level in your hierarchy use the Topmost place filter. This filter is not compatible with other topmost or group filters.
  • Meters in site name  - Filter to include meters directly under one or more sites. TIP: To see all the meters at a certain level in your hierarchy use the Topmost place filter. This filter is not compatible with other topmost or group filters.
  • Paid date - Select one or more dates.
  • Pay status - To include all the matching bills do not set other filters such as Billing period, Accounting period, or topmost filters.
  • Payment initiated date - Formerly called Payment Check Date.
  • Payment type number - Formerly called Payment Check Number.
  • Rate schedule - Filter to one or more rate schedules, to see all results do not include a topmost or group filter. TIP: You can combine with a topmost filter to further refine your results.