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
- Group by
Select what type of bills you want to view. - Include account charges
Decide whether to include one-time or periodic charges.
These are not linked to use or demand on the bill. - Date range
Set the time period for the report.
Other filters to consider for Report-41
- Active accounts only
Decide whether to include only active accounts.
If this filter is not applied, your report includes both active and inactive accounts. - Void bills
Include if you want a full audit history.
Exclude to focus only on valid financial activity. - 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.