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