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.
- Set the Average processing days.
- Set the Days past anticipated date.
- Set the filter Ignore Account if no bills since date to exclude any inactive or old accounts.
Other filters to consider for Report-34
- Do you want to include only Active accounts?
- Do you use Chargebacks and only want to see vendor bills? or only see chargeback bills? Add the filter Bill is from external vendor, otherwise you see both chargeback and vendor bills in your report.
Example filters for Report-34
