Report-41

Bill and Batch Spreadsheet (Excel only)

An Excel report provides bill-by-bill details grouped by batch code, entered by, cost center, vendor, or entry date.

Report-41 tip

Use the Include filters to add more columns to your spreadsheet.

Set your filters for Report-41

  1. Group by
    Select what type of bills you want to view.
  2. Include account charges
    Decide whether to include one-time or periodic charges.
    These are not linked to use or demand on the bill.
  3. Date range
    Set the time period for the report.

Other filters to consider for Report-41

  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. Void bills
    Include if you want a full audit history.
    Exclude to focus only on valid financial activity.
  3. 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-41