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.
Example filters for Report-41
Available filters for Report-41
Required filters
- Group by - decide how you want your report grouped.
- Include account charges - Account charges are separate from meter charges and not used in calculating unit cost. (For example, late fees, connection charges, or deposits)
Recommended filters
- Bill is void - If this filter is not included both void and not void are included.
- Billing period
- Cost recovery
- Flag assigned to me
- Flag assignee
- Flag issue
- Flag status
- Flag type
- Flag unassigned
- Include account custom fields
- Include audit custom fields
- Include payment columns - Includes pay status, exported for payment, funds withdrawn date, payment sent date, payment cleared date, payment amount
- Include status columns
- Include tracking columns
- Meter group
- Site group
- Topmost cost center code
- Topmost cost center name
- Topmost place code
- Topmost place name
- Vendor code
- Vendor name
Optional Filters
- Account is active - If this filter is not included, includes both active and inactive accounts are including in the report.
- Account name
- Account number
- Accounting period
- Accounts in cost center code
- Accounts in cost center name
- Batch
- Bill entered by
- Bill entry date
- Bill ID
- Bill import verified
- Bill is approved
- Bill is from external vendor - When this filter is not selected, the report includes data from both vendor (external) and chargeback (internal) bills.
- Billing period year
- Commodity
- Commodity category
- Date exported to AP
- Date exported to GL
- Held from accounting export
- Include accrual bills
- Include reversed accrual bills
- Meter code
- Meter name
- Meter serial number
- Meters in site code
- Meters in site name
- Pay amount
- Pay status
- Payment cleared date
- Payment sent date
- Payment type number
- Rate schedule