Receivables & Cash Operations Panoramas
Find out about business scenarios, data selection, report view options, and data definitions for Receivables & Cash Operations Panoramas available under Budget & Finance in the Business Analytics Hub (bah.ucsd.edu).
Accounts Receivable Panorama
Accounts Receivable Panorama is a collection of reports that provide departments with an overview of their receivables and related credit memos, customer account attributes, incoming and unclaimed cash receipts, and merchant transactions
Credit Memo Report
Business Scenarios
-
List of Transactions against which Credit Memo was applied
-
What are all of the transactions that have Credit Memos applied against them?
-
Who is the Customer that received the issued Credit Memo?
- When did this happen and what was the amount?
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a table of 8 columns, with the ability to export the result set into a file
- Additional columns are available for users to add to the report
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Customer Account Delivery Attributes
Business Scenarios
-
Provides Customer Account information related to the Invoice delivery method of email or print options
-
What is the preference for the Customer Account when it comes to invoice delivery, printed copy that can be delivered by the department or the auto-generated copy that will be automatically emailed to the Customer?
-
What is the latest physical address for the Customer I am looking to Invoice?
- Who is the point of contact at this Customer and do we have their contact information, such as email or phone number?
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Additional columns are available for users to add to the report
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Incoming Payments (Receipts) Report
Business Scenarios
- List of Incoming Payments, applied and unapplied for both Receivables and Non-Receivables transactions
- How can I look up if a Payment was received for the outstanding Invoice?
- Customer claims they sent out the payment, I still see an open Invoice, where can I check of the Payment has arrived?
- I found the received Payment, now I can claim it against the open Invoice with the appropriate supporting documentation
Data Selection and View Options
- Use these parameters to filter for the data you want to see
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Additional columns are available for users to add to the report
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Merchant Transaction Report
Business Scenarios
-
Provides subledger detail transactions to assist with credit card reconciliation
-
What are all of the transactions for the credit card account?
-
We are a Merchant, how can we view all of activity during the particular time period?
- I am interested in a specific activity for my Financial Unit, can I see the information that way?
Data Selection and View Options
- Use these parameters to filter for the data you want to see
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Additional columns are available for users to add to the report
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Miscellaneous Receipts
Business Scenarios
-
Detailed information of non-standard Receipts
-
What are all of the Transactions that hit each subledger for my Project?
-
What Transactions hit the GL directly?
- Something hit the General Ledger, where did this come from?
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Additional columns are available for users to add to the report
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Receivables Aging Report
Business Scenarios
-
Provides visibility into Unpaid Invoice Balances along with the duration for which they’ve been outstanding
-
Report can be filtered by Financial Unit and can be detailed or summary
-
What are the Customers that have not paid us?
-
How long are the outstanding bills due?
- What is the best way to gain an insight on who owes us how much and are they current or past due, and if so by how far the past due date?
Data Selection and View Options
- Use these parameters to filter for the data you want to see
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with subtotal by Project
- Additional columns are available for users to add to the report
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
- Report can be run as Summary per Financial Unit or as Detailed
SPARCM Invoice OFC Transaction Link Report
Business Scenarios
-
Translates Invoice number from Oracle to SPARCM and vice versa, and links payments to Invoices
-
What is the Sponsored Project Invoice equivalent in OFC?
-
For the Award on the Contract, what are the outstanding Invoices in OFC?
- I have the Oracle Invoice, what is that equivalent in SPARCM?
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Additional columns are available for users to add to the report
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules