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