Report-33

Overdue Bills (Excel only)

Purpose

This Excel report shows account that are missing expected bills.

How it works

The report compares forecasted billing dates with actual bill records to find missing bills. It uses the following information from each account's properties page:

  • Billing frequency
  • Expected bill creation date
  • Expected statement date

If a bill was expected but not found, the account appears in the report.

Use case

Ideal for identifying accounts where bills are overdue or may have been missed due to delays or system issues.

Set your filters Report-33

To limit the amount of data returned you may want to set these filters:

  • Account is active = yes
  • Set a specific topmost 
  • Set a specific vendor

Available filters for Report-33

Recommend filters

  • Account is active
  • Account name
  • Account number
  • Meter group
  • Topmost cost center code
  • Topmost cost center name
  • Topmost place code
  • Topmost place name
  • Vendor code
  • Vendor name

Optional filters

  • Accounts in cost center code
  • Accounts in cost center name
  • Bill CAPture method