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.

Report-34 is available as: Excel

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.
    • Do not include the filter both vendor and chargeback bills.

Example filters for Report-34

Available filters for Report-34

Required filters

  • Allowable processing days (1-400) - The first two filters work together. Allowable 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 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.
  • Days past anticipated date (1-100) - These first two filters work together. Days past anticipated date is an extra grace period added to Average processing days that determines what accounts are included as missing a bill.

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 - Filter for one or more accounts. This filter is not compatible with topmost or group filters.
  • Account number - Filter for one or more accounts. This filter is not compatible with topmost or group filters.
  • Ignore account if no bills since
  • Meter group - Filter for specific groups, to include all the group members do not set a topmost filter. TIP: You can combine with other filters if you want to refine your results.
  • Topmost cost center code - Select the topmost cost center you want to be included. When you set a topmost cost center it is the highest level of the accounting tree used, this lets you select a subset of data for reporting.
  • Topmost cost center name - elect the topmost cost center you want to be included. When you set a topmost cost center it is the highest level of the accounting tree used, this lets you select a subset of data for reporting.
  • Topmost place code - Select the topmost organization or site you want to be included. When you set a topmost organization or site it is the highest level of the facilities tree used, this lets you select a subset of data from your tree for reporting.
  • Topmost place name- Select the topmost organization or site you want to be included. When you set a topmost organization or site it is the highest level of the facilities tree used, this lets you select a subset of data from your tree for reporting.
  • Vendor code - Filter by one or more vendors, to see all vendors do not include a topmost or group filter. TIP: You can combine with other filters if you want to refine your results.
  • Vendor name - Filter by one or more vendors, to see all vendors do not include a topmost or group filter. TIP: You can combine with other filters if you want to refine your results.

Optional filters for Report-34

  • Accounts in cost center code - Filter to include accounts directly under one or more cost centers. TIP: To see all the accounts at a certain level in your hierarchy use the Topmost cost center filter. This filter is not compatible with other topmost or group filters.
  • Accounts in cost center name - Filter to include accounts directly under one or more cost centers. TIP: To see all the accounts at a certain level in your hierarchy use the Topmost cost center filter. This filter is not compatible with other topmost or group filters.
  • Bill is from external vendor - When this filter is not selected, the report includes data from both vendor (external) and chargeback (internal) bills.