Skip to main content

System Status: 

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


credit-memo_p.png


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 section below titled Understanding the Data for definitions, data includes usage rules and full description

 credit-memo_rv.png

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

    customer-account-delivery-attributes_p.png


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 section below titled Understanding the Data for definitions, data includes usage rules and full description

customer-account-delivery-attributes_rv.png

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

incoming-payments-report_p.png
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 section below titled Understanding the Data for definitions, data includes usage rules and full description

 incoming-payments-report_rv.png

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

    merchant-transaction-report_p.png


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 section below titled Understanding the Data for definitions, data includes usage rules and full description

 merchant-transaction-report_rv.png

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

    miscellaneous-receipts_p.png


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 section below titled Understanding the Data for definitions, data includes usage rules and full description

 miscellaneous-receipts_rv.png

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

    UCSD-Receivable-Aging-Report_p.png


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 section below titled Understanding the Data for definitions, data includes usage rules and full description
  • Report can be run as Summary per Financial Unit or as Detailed

 UCSD-Receivable-Aging-Report_rv.pngUCSD-Receivable-Aging-Report_rv2.png

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

    UCSD-SPARCM-Invoice-OFC-Transaction-Link-Report_p.png


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 section below titled Understanding the Data for definitions, data includes usage rules and full description

 UCSD-SPARCM-Invoice-OFC-Transaction-Link-Report_rv.png

Find answers, request services, or get help from our team at the UC San Diego Services & Support portal.