Several pre-programmed (canned) reports are available in the Campus Data Warehouse (CDW) providing information about unpaid charges. The following four reports are useful in monitoring the status of charges posted to the Billing and Accounts Receivable (BAR) system and should be run at the beginning of the month:
- Outstanding Charges — Allows sorting by name, University ID (UID), subcode or posting date.
- Summary of Unpaid Charges — Report displays the count and total amounts of billed, paid and unpaid charges sorted by subcode.
- Charge Detail - This Month's Write-Offs — Detail for unpaid charges that will be written off (charged back to the department's account) at the end of the current month. This report contains the same information as the Outstanding Charges report but is limited to charges that are 150 or more days old.
- Charge Detail - Next Month's Write-Offs — Detail for unpaid charges that will be written off (charged back to the department's account) at the end of next month. This report contains the same information as the Outstanding Charges report but is limited to charges that are between 120 and 149 days old.
Accessing the CDW Reports
- Log on to CDW at https://cdw.qdb.ucla.edu/
- Log in using your UCLA logon ID and password
- Click on the BAR tab at the top of the screen to display the reports menu
- Click on the report you wish to run and provide the prompted values
For access to the BAR CDW canned reports or to run ad hoc reports using BAR CDW, contact Accounting and Cash Management.
