The Reports tab on the main Billing Manager form displays the available Billing Manager reports for the selected module. From here, you can run the various reports available to you as a part of the Billing Manager. The Reports tab may be accessed from the Billing Manager form by clicking on the tab, or by typing ALT+R. The reports themselves are stored in the ReportQueries table in the database. These report queries should NOT be edited. Reports can be exported into xls, html, txt, or xml files by clicking the Export Data button.
In the Billing Manager, both beginning and end date values of a date range are inclusive. For example, billing for the month of May would be for 5/1/2014 - 5/31/2014.
When the Generate Report button is clicked, the Billing Manager uses Rave Reports (RAV) files in the same location as the BillingManager.exe, to create the report from the queries in the ReportQueries table.
Borrowing Reports
- 30 Days Overdue Letter: Displays a formal letter to the Borrowing patron for every Invoice that is 30 to 59 days overdue.
- 60 Days Overdue Letter: Displays a formal letter to the Borrowing patron for every Invoice that is 60 to 89 days overdue.
- 90 Days Overdue Letter: Displays a formal letter to the Borrowing patron for every Invoice that is 90 days or more overdue.
- Borrowing Aging Report: Displays any unpaid Borrowing invoices and their associated balances, ordered by Invoice Number.
- Borrowing Customer Register: Lists all Borrowing customers with invoices in the system and the current status of those invoices.
- Borrowing Receivables Report: Displays every payment received during the specified date range. It is intended as a means to reconcile recorded payments against checks, receipts, or any other records of payment.
- Customer Balance Summary: Displays a list by customer of any invoices for that customer and the outstanding balance on those invoices.
- Top Customers by Amount Billed: Displays invoices in descending order by the amount billed and the customers associated with those invoices.
Document Delivery Reports
- 30 Days Overdue Letter: Displays a formal letter to the Borrowing patron for every Invoice that is 30 to 59 days overdue.
- 60 Days Overdue Letter: Displays a formal letter to the Borrowing patron for every Invoice that is 60 to 89 days overdue.
- 90 Days Overdue Letter: Displays a formal letter to the Borrowing patron for every Invoice that is 90 days or more overdue.
- Customer Balance Summary: Displays a list by customer of any invoices for that customer and the outstanding balance on those invoices.
- Doc Del Aging Report: Displays any unpaid Doc Del invoices over 30 days old and their associated balances, ordered by Invoice Number.
- Doc Del Customer Register: Lists all Doc Del customers with invoices in the system and the current status of those invoices.
- Doc Del Receivables Report: Displays every payment received during the specified date range. It is intended as a means to reconcile recorded payments against checks, receipts, or any other records of payment.
- Photodup Charges: Displays a list by account of total photoduplication charges for that account and the number of transactions comprising the total charges.
- Top Customers by Amount Billed: Displays invoices in descending order by the amount billed and the customers associated with those invoices.
Lending Reports
- 30 Days Overdue Letter: Displays a formal letter to the Borrowing institution for every Invoice that is 30 to 59 days overdue.
- 60 Days Overdue Letter: Displays a formal letter to the Borrowing institution for every Invoice that is 60 to 89 days overdue.
- 90 Days Overdue Letter: Displays a formal letter to the Borrowing institution for every Invoice that is 90 days or more overdue.
- Customer Balance Summary: Displays a list by customer of any invoices for that customer and the outstanding balance on those invoices.
- Lending Aging Report: Displays any unpaid Lending invoices over 30 days old and their associated balances, ordered by Invoice Number.
- Lending Customer Register: Lists all Lending customers with invoices in the system and the current status of those invoices.
- Lending Receivables Report: Displays every payment received during the specified date range. It is intended as a means to reconcile recorded payments against checks, receipts, or any other records of payment.
- Top Customers by Amount Billed: Displays invoices in descending order by the amount billed and the customers associated with those invoices.
EFTS Reports
This section will only display if the EFTSActive key is set to Yes in the ILLiad Customization Manager.
- Generate EFTS FIle: Using this button creates a .txt file displaying EFTS Sites, Records and the Total payment received during a specified date range. These reports can be sorted by date order so most recent items can be displayed at the top of the report.
- EFTS Participating Libraries: This report displays a list of all libraries that are EFTS Participating Libraries.