Report-34

Anticipated Bills Not Yet Processed (Excel only)

This Excel report helps you identify expected bills that have not yet been processed, based on historical billing trends.

Key Benefits

  • Spot current anticipated bills before they’re overdue.
  • Reduce or eliminate late fees by ensuring timely processing.

Tip

Use Report-17 to locate missing historical bills that may be affecting trends or projections.

Set your filters for Report-34

The first two filters work together. Average processing days is how many days after the last bill’s end date does it typically take to enter the next bill. This number plus Days past anticipated date (an extra grace period) determines what accounts are included as having a missing a bill. TIP: This report identifies bills where the next anticipated bill has not yet been received. Use Report-17 if you want to find missing bills.

  1. Set the Average processing days. 
  2. Set the Days past anticipated date.
  3. Set the filter Ignore Account if no bills since date to exclude any inactive or old accounts.

Other filters to consider for Report-34

  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.

Example filters for Report-34

Available filters for Report-34

Required filters

  • Allowable processing days (1-400)
  • Days past anticipated date (1-100)

Recommended filters for Report-34

  • Account is active - If this filter is not included, includes both active and inactive accounts are including in the report.
  • Account name
  • Account number
  • Ignore account if no bills since
  • Meter group
  • Topmost cost center code
  • Topmost cost center name
  • Topmost place code
  • Topmost place name
  • Vendor code
  • Vendor name

Optional filters for Report-34

  • Accounts in cost center code
  • Accounts in cost center name
  • Bill is from external vendor - When this filter is not selected, the report includes data from both vendor (external) and chargeback (internal) bills.