Budget & Finance

The dashboard includes:

• Fiscal Data
• Student Data
• Facilities Data (link to external reports)
• HR Data (coming soon!)
• Research Data
• Faculty Data (coming soon!)

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.

The Accounts Receivable dashboard includes the following pages: 

• List of Reports 
• Credit Memos 
• Customer Master File
• Customer Transaction Register
• Incoming Payments (Receipts) 
• Merchant Transactions 
• Miscellaneous Receipts
• Receivables Aging Report
• SPARCM to OFC Transaction Number Link

• Provide departments with an overview of their receivables and related credit memos, customer account attributes, incoming and unclaimed cash receipts, and merchant transactions. 

Reports:

1. Expanded Project Summary

2. Project Information Lookup Panorama

3.Transaction Details

This report helps in determining the projected balance of service agreement projects net of any projected assessments that still need to be charged.  This report has 3 separate pages

1. Assessment reconciliation – showing summary section for GL balance with projected assessments ( calculated - actual ) and a detail section showing the calculations for the projected assessment used in the summary section above.
2. Revenue – Showing all the revenue associated to the project
3. Assessments – Showing all details for actual assessments associated to the project

Please note that only funds that are charged Differential Income and ASSA are included

• How much is still available to spend on service agreements
• Net of differential income assessments that won't be charged until the end of the fiscal year

The Athletics Expense Reports dashboard includes the following pages: 

• Athletics Expenses 
• Guarantees 
• Head Coaching Salaries 
• Assistant Coaching Salaries 
• Support Staff/Admin Salaries 
• Recruiting 
• Team Travel 
• Equipment, Uniforms and Supplies 
• Game Expenses 
• Fundraising, Marketing and Promotions 
• Sports Camp Expenses 
• Spirit Groups 
• Direct Overhead 
• Medical Expenses and Insurance 
• Memberships and Dues 
• Student Athlete Meals 
• Other 
• All

• Summarizes Intercollegiate Athletics expenses on a sport-by-sport basis into NCAA-required reporting categories. 
• Reported to the NCAA and Department of Education. 

The Athletics Revenue dashboard includes the following pages: 

• Athletics Revenue 
• Ticket Sales 
• Student Fees 
• Guarantees 
• Contributions 
• Programs, Concessions, Novelty Sales and Parking 
• Royalties, Licensing, Advertisements and Sponsorships 
• Sports Camp Revenue 
• Endowments and Investments 
• Media Rights 
• NCAA Distributions Including Tournament Revenue 
• Conference Distributions 
• Direct Institutional Support 
• All Transactions 
• Recharge Revenue 
• Other Ticket Sales - 1 
• Other Ticket Sales - 2 
• Other Media Rights and Programs 
• Other NCAA and Conference Distributions 
• Other Royalties, Licensing, Advertisements and Sponsorships 
• Other Sports Camp 
• All Other Revenue 

• Summarizes Intercollegiate Athletics revenue on a sport-by-sport basis into NCAA-required reporting categories. 
• Reported to the NCAA and Department of Education. 

Displays report runs and distinct user counts for BI Publisher reports.

The report includes two tabs:

• Actions: lists the actions required to prepare the projects within the award for closeout.
• Details: provides detailed information for each award to assess its readiness for closeout. 
  • Award Number drillthrough: in-depth view of the financial performance and reconciliation status for a specific award.

This dashboard includes five pages:

• Award Setup and Modification: provides insights into the lifecycle and financial status of research awards, focusing on setup, modification, and temporary extensions.
• Overspending and Underspending: provides a comprehensive overview of award financial health across VC Areas, highlighting trends and potential risks related to overspending, underspending, and inactivity. 
• Closeout: monitors the status of sponsored awards approaching or past their end date, focusing on timely project closeout.
• ECERT: provides insights into effort certification activity, enabling users to monitor compliance with federal regulations that require verification of payroll charged to sponsored projects.
• Cost Transfers: monitors the volume, timing, approval efficiency, and departmental backlog of PPM cost transfers, with a special focus on salary-related transactions and compliance risk.

Clicking on the 'Launch' button will take you to the Overspending and Underspending page.

This report leverages UC San Diego Bookstore transaction data from Ratex (for transactions between 11/20/17 and 01/31/22) and NetSuite (for transactions from 02/01/2022 to the present). It is comprised of four reports: two summary reports and two drill through reports. The parameter selection pages enable users to filter data based on parameters such as year, month, and Index PTF (Project, Task, and Funding Source).

By clicking on the reference number in a summary report, users can drill down to view more detailed transaction information. Additionally, each report includes bookstore contact details for inquiries related to the user's account.

Ratex (Recharge Summary Report Fields):

• Period_Num
• Dept Project Name
• Task Name
• Financial Unit
• Index Ptf
• Recharge Date
• Transaction Number
• Customer Name
• Transaction Total
• Expenditure Batch (Concatenated Field)
• Item Account Code Expenditure Type
• Pretax Total (Calculated Field)

Ratex (Detail Report Fields):

• Transaction Number
• Recharge Date
• Customer Name
• Task Name
• Phone
• Financial Unit
• Index Ptf
• Expenditure Type
• Item Description
• Item Serial Number
• Unit Price
• Item Quantity
• Item Extended Price
• Source Transaction
• Subtotal
• Taxtotal
• Total Charge
• Expenditure Batch (Concatenated Field)

NetSuite (Recharge Summary Report):

• Trandate
• Fin Unit
• Project Number
• Task Number
• Funding Source
• Date
• Tranid
• Customer Name
• Transaction Total
• Po
• Nspo
• Expenditure Batch (Concatenated Field)

NetSuite (Recharge Detail Report):

• Tranid
• Trandate
• Customer Name
• Customer Email
• Customer Phone
• Fin Unit
• Project Number
• Task Number
• Funding Source
• Shipping Address
• Item Display
• Serial Number
• Rate
• Quantity
• Amount
• Subtotal
• Taxtotal
• Transaction Total
• Expenditure Batch (Concatenated Field)

This report provides the user with budget, actual, carryforward balance, and budget.

This report presents Resources, Expenses, and Change in Net Position in a table format and includes the prior year’s carryforward as a beginning balance in the Resources Available Balances (Actuals) section to provide the user with a financial position at any given point in time.

This report can be run to answer the following questions:

• How is my FinUnit or Project performing compared to budget?
• Is my FinUnit or Project in net surplus or net deficit?
• What is the July 1 Beginning Net Position of my FinUnit or Project?
• What is the Current Ending Net Position of my FinUnit or Project?
• What is the amount purchased for Capital Assets for my FinUnit or Project?
• What is the amount of Resources Available for my FinUnit or Project?

The Budget vs Actual Monthly Variance Detail report presents budget and actual expense data in a table format, divided into six separate pages. The pages offer two different views: a detailed view, which includes posting-level information for Fund and Project, and a condensed view. The data is displayed across three time spans: Period, Year-to-Date (YTD), and Annual.

This report can be run to answer the following questions:

• How is my Financial Unit or Project performing compared to budget?
• What are the General Ledger (GL) transactions that make up the actual values for my Financial Unit?
• How much of my annual budget have I spent year-to-date (YTD)?

The Campus User Roles dashboard is a single-page report that includes the following details: 

• Campus User Role Report 

• Provides the OFC roles and associated Business Units, Ledgers and other security contexts for those roles.  
• Searchable by user email, username, assignment number, department and role. 

The Capital Equipment Management Report dashboard is a single-page report that includes the following details: 

• Capital Equipment Management Report 

• Lists all requisitions on items acquired where cost exceeds $5,000.  
• Includes entire requisition and auxiliary cost associated such as shipping, delivery, installation, taxes, etc. 

The Capital Projects dashboard is a single-page report that includes the following details: 

• Capital Projects PPM Expanded Project Summary 

This dashboard includes the following pages: 

• Daily Activity
• Incoming Payments (Receipts)
• Applied Receipt Register
• Unapplied Receipt Register
• SPARCM Invoice to OFC Transaction Link
• Unprocessed Transactions With Errors
  
  

• View daily activity by date detailing receipt information such as receipt number, cashier, amount, and status.
• Track receipts and review the details of applied and unapplied receipts.

The Exceptions dashboard includes the following pages: 

• List of Reports 
• Non-Sponsored Project Names Starting with SP 
• Receipts to PPM Recon 
• Revenue in Fund 13037 
• Revenue on SP Funds Not from Contracts 
• Project Transaction Controls
• PIP Transactions Not Cleared
• Misc Cost Transactions Stuck in Staging Table
• SP Revenue and AR Wrong Accounting - PPM
• SP Revenue and AR Wrong Accounting - Receivables
• SP Generate Revenue Process Errors
• GL-PPM Receivables
• 773046 Account Reconciliation
• Transactions Posted After End Date
• Revenue on Fund 13037 - Recent Accounting

Hierarchies help define structure, and provide for standard and consistent financial reporting to our various stakeholders about UC San Diego’s financial performance and financial position over a specified period of time. Chart of Accounts Panorama is designed to help you explore the UCSD Chart of Accounts and hierarchies.

The Chart of Accounts dashboard includes the following pages: 

• Entity 
• Standard Fund Hierarchy 
• FinU (Financial Unit) 
• Standard Account Hierarchy 
• Function 
• Program 
• Location 
• Project 
• Activity 
• Interentity 
• Managerial Reporting Account Hierarchy 
• Managerial Reporting Fund Hierarchy 

• Define structure 
• Provide for standard and consistent financial reporting to our various stakeholders about UC San Diego’s financial performance and financial position over a specified period  
• Explore the UCSD Chart of Accounts and hierarchies. 

Reports for Performance of Key Controls:

1. Transaction Details
2. GL-PPM Reconciliation
3. Default Project Payroll
4. Deficit Report - Operating Funds
5. Deficit Report - Sponsored Projects
6. Consolidated Exceptions Report
7. Department Exceptions Panorama

This dashboard delivers an initial suite of compensation planning reports intended to support campus business officers. They are designed to support internal position management as well as the monthly and year end variance analysis of budget vs. payroll expenses captured in the Oracle Planning and Budgeting tool and UCPath. 

The Compensation Planning Dashboard includes the following pages: 

• BDP Audit Report
• BDP Analysis Report
• Staffing List Detail Report
• BDP User Roles Report
• Budget vs Actual with Projections Report by Position ID – Monthly View
• Budget vs Actual Report: FTE, Salaries and Benefits – Year End Variance
• Budgeted Positions Report
• Search Tool for Budgeted Positions using Position ID

• Monthly reconciliation of core recurring positions
• Monthly and year end variance analysis of campus resources on payroll expenses
• Data analysis of budgeted positions

Below are just some of the business questions that can be answered by this report:

• Who in my department has delegates?
• What actions can the delegate take on my behalf in Concur?
• How many people is a person a delegate for?

1. Header Report: This report provides high-level information about the Concur Expense Report Transactions including fields such as the Expense Report ID, Report Name, Employee, Report Type, Payment Status, Approver Information, and Report Amount.
2. Entry Report: Header Report + additional line-level information for Concur Expense Report Transactions such as Expense Type, Vendor Information, and Line Amounts.
3. Allocation Report: Header Report + Entry Report + Allocation information includes COA, Project, Task, and Expenditure Type information found within Concur.

The report will help answer business questions related to the status of expense reports that require action, as well as past totals for travel, event and procurement card expenses.

Below are just some of the business questions that can be answered by this report

1. What actions do I need to take on my Concur expense reports?
2. What are all the expense reports associated to my project/financial unit?
3. What expenses associated to my project are not yet paid but should be accounted for?
4. What expense reports are currently pending financial unit approval from my department's financial unit?
5. What expense reports were approved this month?

1. Header Report: This report provides high-level information about the Concur Requests including fields such as the Request ID, Request Name, Employee, Request Type, Approver Information, and Request Amount.
2. Entry Report: Includes all information in the Header report plus additional line-level information for Concur Request lines such as Expense Type and Line Amounts.
3. Allocation Report: Includes all information in the Header report plus and Entry Report plus Allocation information includes COA, Project, Task, and Expenditure Type information found within Concur.

1. What actions do I need to take on my Concur requests?
2. What are all the requests associated to my project/financial unit?
3. What requests are currently pending financial unit approval from my department's financial unit?
4. What are all the requests someone has submitted or created over a certain time period?

The dashboard includes:

• Active Projects with Inactive Segments
• Closed Projects with GL Balance
• Costs Posted After Project Closed
• Misposted Misc Receipts on SP
• Multiple Project Roles
• Project Setup to GL Match Errors
• Salary on Fellowship Award
• Transactions on No Project

Displays summary and detailed information for award and general contract revenue, invoicing, payments, and receipts.

"The UCSD PPM Project Budget and Contract Manager JR role is required to run these reports."

The Contract Management Dashboard includes the following reports:

• Award Contract and Project Summary
• General Contract and Project Summary
• Contract Invoice and Payment Details
• Receipt Details
• Sponsored AR Aging
• Receivables Aging Report
• Generate Invoice Process Errors - Non-Sponsored
• Non-Sponsored Generate Revenue Process Errors
• Non-Sponsored Contract Lines Without Project or Task
• Non-Sponsored Contracts Without Revenue Account or Fund
• Non-SP Contract AR COA Billing Exceptions
• Non-SP Contract PPM COA Billing Exceptions
• Invoice Approval BPM
• Contract Approval BPM

• Are there invoices on my contracts that have not yet been paid?
• Have I created invoices for all of the revenue recognized on my contracts?
• What invoices have been created on a project?
• What receipts were applied to my invoices? What receipts were applied to my project? Where was a receipt applied?

• What open contracts does my Financial Unit hold in OFC Contracts?
• When do they end?
• What project and task are they on?
• How are all my department’s contracts classified? 
• What are all of my department’s newly created contracts?

This dashboard includes four pages:

• Summary
• Payroll
• Non-Payroll
• Federally Unallowable Costs

• How has the cost of operating my unit changed over time? 
• What types of costs have driven increases or decreases in the cost of operating my unit?
• Did costs go up because we hired more people, because people were promoted into higher-level positions, or because of general salary increases?
• Did the cost of the items we buy go up, or did we buy more of those items?
• What items do we buy to support our operations?

The Cost Share Reconciliation Dashboard includes following contents:

• PPM Summary
• GL Summary
• Misposted Transactions
  

• Have I over- or under-spent my cost share budget?
• Are there costs that have been coded with the wrong task or wrong funding source? 
• Have I funded cost share with resources in the General Ledger?

The Cost Sharing Report is a single-page report that includes the following details: 

• Cost Sharing 
• Funding Source Name 
• Award Org 
• Award Number 
• Principal Inv 
• Project Number 
• Unmet Percent 
• Expenditure Start Date 
• Expenditure End Date 

• Displays Awards with Cost Sharing Commitments, PPM Project Costs against those commitments, and remaining balances. 

The Concur Credit Card Transactions report provides information on all Concur-related card products, including Travel & Entertainment Cards, Procurement Cards (P-cards), and UCSD centrally billed CTS Air and Hotel Cards. This report helps users find card transactions that are both assigned or unassigned to a Concur expense report. Use this report for all your Concur credit card related needs.

1. All Credit Card Transactions: Includes UC San Diego Credit Card transactions that are assigned and unassigned to an expense report in Concur
2. Assigned Credit Card Transactions:  Includes only UC San Diego Credit Card transactions that are assigned to an expense report in Concur. Since it is assigned to an expense report in Concur, you can filter using chart of accounts from the expense report.
3. Unassigned Credit Card Transactions: Includes only UC San Diego Credit Card transactions that are NOT assigned to an expense report in Concur. No chart of account information is available as the transaction is unassigned. The only COA information is the cardholder's Payroll Profile Primary Assignment Financial Unit

The reports will help answer business questions related to the status of credit card transactions, as well as past totals.

Below are just some of the business questions that can be answered by this report

1. What credit card transactions are unassigned within my financial unit?
2. What is the total Procurement Card spend for my financial unit?
3. Have my credit card transactions been approved through Concur?
4. What are all the assigned Concur credit card transactions on my Project?

Report shows all UC San Diego card holders that have utilized their university card product.

Card products include Travel & Entertainment Cards and Procurement Cards(P-cards).

1. Please note that if a cardholder has a university card product, but has never used it, then they will not show up on this report. The Cardholder must have used the card to show up on this report.
2. Please be aware that all cardholders and their respective cards will be displayed on the report, regardless of whether the cardholder or card are currently active or inactive.

Credit Card Users: This view shows all card holders that have utilized their university card product as well as the last used date.

The reports will help answer business questions related University card holders and their last used date.

Below are just some of the business questions that can be answered by this report

1. Who are all the card holders within my financial unit?
2. Which employees have utilized their Procurement Card within my financial unit?

• 1. Debt Service Summary by Sub-VC: This tab displays annual debt service amounts for all associated specific capital projects, grouped by Vice Chancellor and Sub Vice Chancellor areas.
  2. Debt Service Summary by Debt Grouping: This tab provides a more detailed view by adding Debt Grouping granularity to the Sub-VC view. 
  3. Debt Service Raw Data: This tab displays the entire debt service upload file, which allows the user to download the raw data to excel for custom analysis.
  4. Data Glossary
  5. Project Amortization Schedule offers a detailed amortization schedule for a specific capital project. It is only accessible through drill-through links within the Specific Project column on the Debt Service by Sub-VC and Debt Service by Debt Grouping tabs.

This report answers the following questions:

• What is the amount of debt service for a capital project that falls under my Vice Chancellor this year?
• What is the percentage breakdown of debt service obligations by 'payer' (VC/Sub-VC) for a specific project?
• What is the payback schedule for specific projects in my areas?

Provides payroll details for transactions on a department default project that need to be corrected, as well as information about non-payroll transactions. It provides the information you need to complete Direct Retros, Salary Cost Transfers, or PPM Cost Transfers. Users with access to the DOPES may also access this report.

• Oracle + LL Pivot: Summarizes transactions from Oracle by default project, Original PTF, employee name, account code, and expenditure date.  Accounts appear in rows and expenditure item dates appear as columns. 
• Oracle + LL Summary: Similar to the Oracle + LL Pivot, but expenditure item dates appear as rows and accounts appear as columns. 
• Detail: This page provides all the detailed transaction information you need in order to process corrections.
• PPM Only: This page summarizes transactions by default project, Original PTF, account code, and expenditure date. Accounts appear in rows and expenditure item dates appear as columns. 
• Oracle with Names: Provides a list of transactions with all dollar amounts coming from PPM. An additional table is embedded into each row to provide all of the employee names associated with the OTR in the Labor Ledger. 
• SCT Prep: This page is provided for departments that request Salary Cost Transfers to be done by another unit. No dollar amounts are included on this page. 

Provides answers to the following questions:

• What are the names of people whose payroll has posted to the departmental default project in Oracle?
• What were the projects on funding entries in UCPath that resulted in payroll posting to the departmental default project?

The dashboard includes the following pages: 

• Transactions Incorrectly Posted to UCPath Specific Funds (CVR)
• Incorrect PPM Budget Resources
• Project and Task Transaction Controls
• Project Task Owning Org Mismatch
• Uncleared Concur AP Credit Memos

• Department Operations Dashboard

• Department fiscal managers to see overall balances
• Fiscal managers to view balances by project classifications
• Drill through to view GL transactions that makeup balances to note any irregularities
• On page prompts allow for fiscal managers to quickly toggle between different parameters to view overall balances

New report version, updated for CCoA reordering.  If you do not already have access to this report, please submit an access request for the Payroll Accounting and Reconciliation report category.

This report displays actual labor ledger payroll expenses applied for a given payroll cycle.
Report includes:

• Combined Salary & Fringe: Lists all Salary and Fringe Labor Ledger data on a single tab.  
• Condensed Column Set: Shows only the essential columns required for Project Managers and Sponsors which keeps all columns on the screen together, no horizontal scrolling required.
• Employee Summary: Totals Salary and Fringe monetary amounts for the Condensed Column Set.  Totals are grouped first by employee and then by pay and earnings periods.
• Optional Report Pages:
    ○ Salary Details: Lists only salary detail rows
    ○ Fringe Details: Lists only fringe detail rows
    ○ Stipend and Tuition Fees: Lists all related FinAH rows

Required Input

• Pay Calendar Dates
• Accounting FY-Periods

Fields

• Employee Name
• Employee ID
• Employee Record
• Pay Period End Date
• Earnings Period Start Date
• Earnings Period End Date
• Pay Check Date
• Transaction Type
• Fiscal Year
• Accounting Period Number
• Department Code
• Department
• Position Number
• Position
• Job FTE
• Job Code
• Job Description
• Pay Group Code
• Pay Group
• Earnings Code
• Earnings Type
• Pay Basis
• Job Compensation Frequency
• Employee CBR Rate Group
• Employee UCPath CBR Rate Group
• Employee UCPath CBR Rate Code
• CCOA Entity Code
• CCOA Entity
• CCOA Fund Code
• CCOA Fund
• CCOA FinU Code
• CCOA FinU
• CCOA Account Code
• CCOA Account
• CCOA Funct Code
• CCOA Funct
• CCOA Program Code
• CCOA Program
• CCOA Project Code
• CCOA Project
• CCOA Location Code
• CCOA Location
• CCOA Activity Code
• CCOA Activity
• CCOA TASK Code
• CCOA TASK
• CCOA Funding Source Code
• CCOA Funding Source
• OTC Indicator Code
• Project Manager Name Full
• Task Manager Name Full
• Salary Cap Rate
• LL Annual Rate
• Job Compensation Rate
• Employee CBR Rate
• Salary Hours
• Salary Derived Effort Percent
• Salary Total Pay Component Percent
• Monetary Amount
• Pay Run Code
• Salary Earnings Run Code
• Journal ID
• Journal Line
• GL Journal Line Number
• Journal Template Code
• Cost Transfer Code
• Original Transaction Reference Number
• Transaction Type - Account
• Project - Task
• Salary Grouped Total
• Fringe Grouped Total
• Salary and Fringe Grouped Total

This report provides a summary of EPBCS Access Group Assignments by user. The report can be filtered to narrow down user records displayed in the report.

This report answers the following questions:

• Does this user have Budget Editor Group access? If so, are they CBO, VC, or General Budget Preparers?
  • Note: CBO Budget Editors have ‘write’ access to EPBCS all year long whereas the General Budget Preparer and VC Office groups are only able to edit budget entry forms during open development cycle, they can only view data in EPBCS outside of this timeline.
• Does this user have Resource Commitment Tracking Tool (RCTT) access?
  • Note: The RCTT is open year-round to the existing user base.
• Does this user have Capital Planning access?
  • Note: only a small subset of budget preparers work in units with Capital Planning or debt service needs, so this portion of EPBCS is limited to those areas who need it.
• What Financial Unit grouping(s) is this user assigned? Do they have EPBCS access at the A, B, or C levels of the Financial Unit hierarchy?

Provides summary and detail information about a single project or task with data from both PPM and General Ledger.

• Metadata information about a project and its underlying tasks, including chartstring information and project roles.
• Total expenditures, balances, and commitments by expenditure category
• Revenue details for non-sponsored projects
• Expenditures by month
• PPM Cost Details
• Commitment Details
• Historical Payroll Details
• Payroll Projection Details
• General Ledger Transaction Details

•  View PPM expenditures, GL transactions, and UCPath payroll (DOPES) all in a single report
•  What are the transactions that have posted to a project or task in PPM and GL?
•  What are the open commitments on a project or task?
•  What people’s salaries were charged to a project or task over a given time period?
•  How much is anticipated to spend on payroll and related costs on a project or task?

Provides a dashboard for faculty and supporting users who are financially responsible for sponsored and non-sponsored projects and tasks.

Access this dashboard to:

• View projects and tasks (including award dates, where applicable) in your portfolio
• Identify money available and money spent for projects and tasks
• Analyze data for financial decision-making about your sponsored and non-sponsored projects
• View project and task payroll details

Provides a dashboard for faculty and supporting users who are financially responsible for sponsored and non-sponsored projects and tasks in the following sections:

• Sponsored Projects - For Project Managers, Principal Investigators, and Task Managers
• Non-Sponsored Projects - For Project Managers and Task Managers with both General Ledger (GL) and Project & Portfolio Management (PPM) data
• Payroll - A second tab displays rolling 12 months of payroll for the project/task portfolio

The Financial Resource Management Dashboard includes the following pages:

• Reports List
• Net Operating Results and Fund Balance
• Financial Deficit Report - Operating Funds
• Financial Deficit Report - Sponsored Projects
• Fund Summary
• GL Project Summary by Fin Unit
• Fund Balance Scorecard
• Available Fund Balance Trends
• Days Fund Balance
• Managerial Reporting Account Hierarchy
• Managerial Reporting Fund Hierarchy

• Delivers a full suite of financial management reports intended to support campus business officers.
• Designed to support internal financial management of the university finances, including use of Managerial Reporting hierarchies.

• Receipt Application Auditing: Receipt Application Statistics, Authorized Users, Applied Receipt Register, Miscellaneous Receipts, Aging Report for Receipts
• Credit Memos: Credit Memos by Customer, Credit Memo Accounting Exception Report, Overapplied Invoices, Overapplied Invoice Details, Combined List of Related Transactions
• Invoice Created By
• Customer General Information: Customer Address Information, Customer Contact Information
• Bill and Revenue Plan Details
• Invoices Needing Approval
• Foreign Payments (Receipts): Incoming Wires
• PMS to Oracle Reconciliation
• Collections
• Capital Assets and Property Reconciliation Report: CAMS Reconciliation Reporting
• Contract Errors: Non-SP Contract Lines Without Project or Task, Non-SP Contracts Without Revenue Account or Fund
• Accounting Errors: Revenue in Fund 13037, Non-SP Contract PPM COA Billing Exceptions, Non-SP Contract AR COA Billing Exceptions, AR PIP Transactions Not Cleared, Contract Line Invoice Revenue Exceptions
• Process Errors: Non-SP Generate Invoice Process Errors, Non-SP Generate Revenue Process Errors, Invoice Transaction Mismatch, Invoices Posted to 96*, Event DFF Entry Errors, Billing Events With Unrecognized Revenue and Invoice Amounts
• CEI Report
• Receivables Aging Report
• Payment Application by Customer
• Property Assessment Report - UCSD Equipment

• Identify payments received from foreign countries and the activity the payment is for.
• Quickly identify who created an invoice.
• Identify accounting errors such as COA billing exceptions, transactions not cleared, and contract line revenue exceptions.
• Compare assets in Oracle procurement/Accounts Payable and CAMS.

• Customer Satisfaction
• Performance Metrics

• View metrics related to customer satisfaction such as how quickly tickets are resolved, number of tickets each agent has resolved, and support ticket trends.
• View metrics related to payments such as how accurately we apply receipts, how many payments are received/applied/unapplied.
• How quickly are cost transfers processed and how many unprocessed costs are sitting every month?
• View how quickly we close the subledgers each month along with historical trends by application module.

• List of Reports
• Award Lookup
• Cost Transfer Approval BPM
• Project Metadata Lookup
• Project Managers
• Project Costs KPI
• Projects Without FinUnits
• Project Cost Transfers BPM
• Transaction ID to Contract Lookup Report
• Transactions Outside Budget Period
• Invoice Creation Report
• Exceptions Reports
• SR Bug Queries

• Export a list of projects by project status or project type
• Export a list of all tasks
• Determine the contract number and contract name associated with a transaction number

• Project Metrics
• Projected Cash Flow: Receipts, Next 7 Weeks
• Open Receivables: Open Receivables, Net Zero Open Receivables
• Overall Collection Health and CEI

• TBD.

The Fiscal Assistant Workload Dashboard consists of only one page, which contains a variety of workload metrics for each of the fiscal assistants in a financial unit. Workload metrics can be viewed for a given year, and up to three years simultaneously. 

This dashboard answers questions like:

• How has the workload for each Fiscal Assistant changed over time?
• What does the workload of each of the Fiscal Assistants look like and how do they compare to each other?

Financial Management Reports:

1. Department Operations Dashboard
2. GL Balances
3. Financial Resource Management Dashboard
4. Gift Fund Balances
5. Project Management Dashboard
6. Expanded Project Summary
7. Project Information Lookup Panorama

Reports for Performance of Key Controls:

1. Transaction Details
2. Distribution of Payroll Expenses Report (DOPES)
3. GL-PPM Reconciliation
4. Default Project Payroll
5. Transactions on No Project
6. Department Exceptions Panorama

The Fixed Assets Dashboard is a comprehensive tool that offers a range of reports with information from the Fixed Assets Module.

This dashboard includes four reports:

• Fixed Assets Inventory Report
• Fixed Assets Purchasing Report
• Fixed Assets Depreciation Report
• Fixed Assets Retirements and Disposals Report

• Identify assets by department, custodian, or location
• Review purchase-related details, including invoices and purchase orders linked to assets
• Tracks monthly depreciation calculations and evaluates accumulated depreciation
• Determine asset useful life and remaining life
• Review and track the value and retirement dates for assets that have been disposed of

Financial Management Reports:

1. Project Management Dashboard
2. Expanded Project Summary
3. Project Information Lookup Panorama
4. Contract Management Dashboard

Kuali Research Reports:

1. Current and Pending
2. Research Administration Activity Dashboard

Reports for Performance of Key Controls:

1. Transaction Details
2. Distribution of Payroll Expenses Report (DOPES)
3. GL-PPM Reconciliation

The Fund Monitoring and Exceptions Dashboard dashboard includes the following pages: 

• Financial Unit PPM Organization Mismatches
• Funds Descriptions With Commas

Are there any funds with commas that need to be updated in EDMCS?

• Position Number
• Vice Chancellor Code
• Vice Chancellor
• Department Code
• Department
• Employee Name Current
• Employee ID
• Employee Record
• HR Status
• Employee Status
• Job Code
• Job Code Description
• FTE
• Employee Class Code
• Employee Class
• Reports To Employee
• Reports To Work Email Address
• Reports To Position Number
• Reports To Position
• Position Class Code
• Position Class

Funding and Project End Dates Tab

• Vice Chancellor Code
• Department Code
• Department
• Employee Name Current
• Employee ID
• Employee Record
• Position Number
• Pay Group
• Pay Frequency
• Position Funding Fiscal Year
• Position Funding Earnings Type Code
• Job Expected End Date
• Job FTE
• End Dates Category
• Position Funding End Date
• Days Remaining Until Funding End Date
• Project End Date
• Days Remaining Until Project End Date
• Project Code
• Project
• TASK Code
• TASK
• Financial Unit Code
• Financial Unit
• Fund Code
• Position Funding Distribution Percent
• Job Code
• Job Code Description
• Reports To Employee
• Reports To Work Email Address
• Reports To Position Number
• Reports To Position

No Task or Funding Source Tab

• Employee Name Current
• Employee ID
• Employee Record
• Position Number
• Position Funding Fiscal Year
• Position Funding Earnings Type Code
• HR Status
• Employee Status
• Job Expected End Date
• Job FTE
• Project Code
• Project
• TASK Code
• TASK
• Financial Unit Code
• Financial Unit
• Fund Code
• Funding Source Code
• Position Funding Distribution Percent
• Job Code
• Job Code Description
• Reports To Employee
• Reports To Work Email Address
• Reports To Position Number
• Reports To Position
• Department Code
• Department
• Vice Chancellor Code
• Vice Chancellor

Report Instructions

What do you need to do?

Review each report tab and make any necessary corrections per the tab instructions below:

Tab 1: Positions without Funding Report

1. Filter the report by your Department area(s) using the "Department" column (if your department doesn''t appear, you may ignore this report)

2. Add funding for these positions in UCPath (for help, see "Resources" below)

   *Health Sciences - submit funding changes to SWAT/HHR/ARC with the new Project Number, Expenditure Organization, Expenditure Type, Task Number, Award Number & Funding Source (POETAF)

3. Process a Direct Retro (for help, see "Resources" below) or submit a DrPat request (VCAA/VCHS) for any transactions related to these positions that recorded to your FinUnit default chartstring in UCPath in prior periods

Tab 2: Funding & Project End Date Report

1. Filter the report by your Department area(s) using the "Department" column (if your department doesn''t appear, you may ignore this report)

2. Filter the "End Dates Category" column by the "End Date Past" category (if your department doesn''t appear, go to step 4)

3. Confirm if the end date relates to Position Funding or the Project

        a. For expired Position Funding requiring position termination, request that your department HR initiator terminate the position in UCPath(employee will continue to get paid until this is complete!)

      *Health Sciences - submit a ticket to ARC/HHR (employee will continue to get paid until this is complete!)

        b. For expired Position Funding where the end date needs extension, update the position funding in UCPath (for help, see "Resources" below)

      *Health Sciences - submit a ticket to ARC/HHR with an updated end date

        c. For expired Projects, update funding in UCPath (for help, see "Resources" below)

      *Health Sciences - submit funding changes to SWAT/HHR/ARC with new Project Number, Expenditure Organization, Expenditure Type, Task Number, Award Number & Funding Source (POETAF)

        d. For expired Projects pending an official modification from sponsor to extend award, submit extension to Sponsored Projects Finance (for assistance, click here); if not approved, update funding in UCPath (for help, see "Resources" below)

        e. For expired Projects getting replaced with a new one (i.e. an NIH Federal Flow Thru), update funding in UCPath (for help, see "Resources" below)

      *Health Sciences - submit funding changes to SWAT/HHR/ARC with new Project Number, Expenditure Organization, Expenditure Type, Task Number, Award Number & Funding Source (POETAF)

   **TIP: for multi-year Federal Flow Through (FFT) awards, projects are created in advance, so suggest setting up future funding with new projects once they''re available (for more info, click here)

4. Filter the "End Dates Category" column by all other categories (focusing on near term expirations first) and ensure that funding and or project updates have been made beyond the expiration date to prevent future defaults

5. Process a Direct Retro (for help, see "Resources" below) or submit a DrPat request (VCAA/VCHS) for any expired entries that recorded to your FinUnit default chartstring in UCPath in prior periods

6. Process an Oracle PPM Cost Transfer (for help, see "Resources" below) for entries that are correctly recorded in UCPath, but went to your default project in Oracle PPM

Tab 3: No Task or Funding Source

1. Filter the report by your Department area(s) using the "Department" column (if your department doesn''t appear, you may ignore this report)

2. Update funding where task and or funding source is missing (for help, see "Resources" below)

   *Health Sciences - submit funding changes to SWAT/HHR/ARC (depending on priority and complexity) with new Project Number, Expenditure Organization, Expenditure Type, Task Number, Award Number & Funding Source (POETAF)

3. Process a Direct Retro (for help, see "Resources" below) or submit a DrPat request (VCAA/VCHS) for invalid entries that were recorded to your FinUnit default chartstring in UCPath in prior periods

This panorama contains reports that pull from the General Ledger transaction tables. Designed to give you visibility into general ledger accounts, balances, transactions and activity.

The General Ledger dashboard includes the following pages: 

• General Ledger Transaction Details 
• GL Details ISIS Reconciliation 
• Journal Approval workflow 
• GL Subledger Journal Details 

• Contains reports that pull from the General Ledger transaction tables.  
• Designed to give you visibility into general ledger accounts, balances, transactions and activity. 

The Gift Fund Panorama compiles various reports and analyses into a single dashboard to help Fund Managers evaluate and make decisions regarding their gift funds.

The GL Balances report provides a summary of both cash and net position ending balances, with information from the GL and PPM.

The GL Balances report includes the following:

• Summary by Financial Unit, Project, Fund, Function, Project, Account combination selected
• Ending Balances by Month
• Ending Balances by Year

• Review balances for each month up to and including the accounting period selected within the accounting year selected
• Review balances for the accounting month selected for each accounting year up to and including the year selected
• This report is not recommended for viewing Sponsored Project balances.

Displays differences between amounts in General Ledger and amounts in PPM. A drillthrough report identifies the specific transactions that are causing the differences. Reconciliation of GL to PPM on sponsored projects is a required key control.

• Expenditures Condensed: Displays expenditure variances by project and account.
• Expenditures by Accounting Period: Displays expenditure variances by project, account, and accounting period.
• Resources: Used to determine amounts that need to be entered in PPM budgets.

• Compares costs in PPM to actuals in the general ledger by project, accounting period, and account code/expenditure type.  
• Includes only revenue, expense, and noncurrent asset (i.e. capital equipment) account codes. 
• Search by one or more financial units, one or more projects, and/or one or more accounting periods.  
• Provides greater detail on the transactions included in the GL and PPM values via a drill through report. 

The Graduate Student Funding report allows users to verify funding sources for payroll, tuition, fees, and stipends across multiple terms/years by graduate student, department, fin unit, and project.

The Graduate Student Funding combines data from three different activity hubs: Student Activity Hub (ISIS data), Financial Activity Hub (PPM subledger data), and Employee Activity Hub (labor ledger data). It has two tabs:

• Transactions Tab: Use this report to view transaction-level data associated with each student.
• Summary Tab: Use this report to view a summary of total expenses by month associated with each student.

• Use the Graduate Primary Major Department prompt to view all of your departments students and see how they were funded for a selected time period.
• Use the Fin Unit prompt to view all students paid by your Fin Unit for a selected time period.
• Use the Student PID and Name to view a particular student’s funding for a selected period of time.

The HDH Departmental dashboard includes the following pages: 

• List of Reports 
• AP Vendor Report 
• Purchasing: PO Search Invoice Detail 
• Purchasing: PO Search Payment Detail 
• UCSD Page Template 

• Lists the financial reports (BI and Cognos) used by UCSD Housing, Dining, & Hospitality (HDH). 
• Supports the HDH Finance and Budget Management team and departmental business users. 

The Accounts Receivable dashboard includes the following pages: 

• List of Reports
• Payables
• Receivables
• PPM
• General Ledger
• High Dollar Exceptions
• Universities

• Provide departments with an overview of payables, receivables, PPM, General Ledger, and high dollar exceptions for intercampus account reconciliations.

The Internal Controls and Accounting Dashboard is a set of analyses and reports intended for central office reporting and metrics. Designed to assist the ICA central office personnel with day to day management of the accounts, fiscal year close, reconciliation with UCOP and fiscal reporting requirements.

List of reports in this dashboard:

1. General Ledger Transaction Details
2. Unposted Journals
3. UCOP Reconciliation Reports
4. CFSAST Reporting
5. Financial Pivot Tools: Balance Report, Period Activity Report, Comparative Balance Report
6. Fiscal Close Journals
7. Schedule C Reports
8. GL Balance Sheet
9. GL Income Statement
10. Budget vs Actual Report
11. Trial Balance Campus
12. Trial Balance by FinUnit
13. Recharge Transactions Reconciliation
14. Cash Clearing Account Exception Report
15. GL Period Net Activity Balance by Fiscal Year
16. Non-SP Projects with DFF Exceptions

The dashboard includes:

• Default Project Status: provides a comprehensive view of default project usage at UC San Diego. It identifies positions with no associated funding source or those with expiring projects, and highlights payroll and non-payroll expenses charged to default projects.
• Reconciliation: highlights key reconciliation metrics across awards and the general ledger. It helps departments quickly identify issues such as miscodings, variances, unprocessed costs, and deficit balances to support accurate financial reporting and compliance.
• Procure to Pay (Coming Fall 2025)

 Clicking on the 'Launch' button will take you to the Reconciliation page.

• List of Reports
• LOC Accounts
• Final FER True-Up
• AR Aging - Invoice With Outstanding Balance
• AR Aging - All Records
• LOC Reconciliation - Cumulative Inception to Date
• LOC Reconciliation - Cumulative
• LOC Reconciliation - Detail
• LOC Reconciliation - Total Applied Amount
• LOC Balance Checks - Funding
• LOC Balance Checks - Expenses

Support the Compliance and Support Team. 

• Contains the detailed recharges posted to the department chart strings: Project, Task, & Funding Source in OFC.  
• The primary audience for this report are financial officers looking to reconcile the NGN recharges posted to their department ledgers. 

A dashboard dedicated to execution and error metrics for OTBI reporting within the Oracle BI tools. Tracks report executions, distinct users, most used subject areas, and more.

Provides detailed information about credit card charges from a procurement card, travel card, and centrally billed airfare/hotel cards that have not yet reached central office review in Concur or posted to Oracle. 

This report includes the following pages:

• Transactions over 365 Days – Lists all credit card charges that are over 365 past the date the charge was posted by the bank (excluding those transactions pending Central Office review).
• Unassigned Card Charges – Lists all credit card charges that have not yet been assigned to an expense report in Concur.
• Charges by Cardholder – Lists all outstanding credit card charges regardless of credit card posting date. 

• View credit card charges that require action from the cardholder/traveler or a department approver. 

This report identifies all Oracle PPM transactions for a given person and Earnings Period End Date. It identifies all UCPath source transactions, such as salary, benefits, accruals, and general liability, as well as non-UCPath source transactions, such as NGN, HSIT, and tuition.

Use the report to identify all associated transactions when PPM cost transfers of payroll are necessary, or to understand the history of payroll transfers.

The report can be used for two primary purposes:

1. Identify all of the transactions associated with a particular payroll to complete a PPM cost transfer of payroll. Note that payroll transfers should be completed in UCPath via Direct Retro or Salary Cost Transfer whenever possible. However, in some situations, moving payroll off of a default project cannot be done in UCPath and must be done via PPM cost transfer.
2. Understand all of the actions that have been taken related to a particular payroll posting, including Direct Retros and PPM cost transfers. See below for an example story.

• What Oracle PPM transactions (both UCPath and non-UCPath sourced) can be identified with a given individual?
• What are all the transactions associated with a particular payroll?
• How can I identify the actions that have been taken to a particular payroll posting?

This dashboard delivers an initial suite of planning and budgeting reports intended to support campus business officers. The reports are designed to support internal analysis against the annual budget.

This dashboard delivers an initial suite of planning and budgeting reports intended to support campus business officers. The reports are designed to support internal analysis against the annual budget.

 This EPBCS Budget Reports dashboard includes the following pages:

• Reports List
• Total Budget Summary (Final Version)
• Core Recurring Final Budget by Year
• All VC Core Recurring Expense Budget
• Total Core Expense Budgets by Fin Unit

This dashboard includes one single page titled “PPM Budget Version Comparison” and includes the following fields in the report:

• Award Number
• Project Number
• Task Number
• Budget Period Start Date
• Budget Period End Date
• Resources
• Version Number
• Version Date
• Budget Version Type (Original Baseline, Baseline, Current Baseline, Current Working)
• Burdened Cost

PPM budgets can have many versions that change over time. This report gives users a way to track how the budget changes between different versions.

The Preuss School Panorama lists the financial reports used by the Preuss School. The panorama is designed to support the school’s finance team with all external reporting requirements.

The Preuss School Financial Reports dashboard includes the following pages: 

• Balance Sheet 
• Income Statement 
• GL Transaction Detail 
• Fund Summary 
• Gift Fund Balance 
• COA Information Report 
• AP Transaction Details 

• Lists the financial reports used by the Preuss School. 
• Support the school’s finance team with all external reporting requirements. 

The Procure-to-Pay Panorama provides insights to all campus reporting needs related to Requisitions, Purchase Orders, and Invoices. This panorama offers high-level dashboard views and detailed inquiry reports for campus use.

The Procure to Pay dashboard includes the following pages: 

• Welcome! 
• Procure to Pay Action Items 
• Procure to Pay Transaction Inquiry 
• Requisition Summary 
• Requisition Inquiry 
• Purchase Orders Summary 
• PO Inquiry 
• PO Balances 
• Invoice Summary 
• Invoice Inquiry 
• Supplier Inquiry 
• PO Outstanding Commitments 
• Federal Small Business Compliance

• Provides insights to all campus reporting needs related to Requisitions, Purchase Orders, and Invoices. 

• Offers high-level dashboard views and detailed inquiry reports for campus use. 

• Cost Transfers Costed and Accounted
• Costed and Accounted by Adjustment Type

• Change to billable/non billable
• recalculate raw/burden costs (could be for new owning org, new burden schedule, etc.)
• transfer
• split
• split & Transfer

This panorama is a collection of reports designed to provide details about Project Cost transfers. Search transfers by the Original Expenditure Item transaction #, transfer dates, project, award, owning organization and more. For larger reports, use the built in scheduling feature.

The Project Cost Transfer dashboard includes the following pages: 

• Reports List 
• Cost Transfers by Date and Transaction # 
• Transfers Summary 
• Transfer by Award/Project 
• High Risk Cost Transfers 
• Transfer Approval Details 

• Provide details about Project Cost transfers. Search transfers by the Original Expenditure Item transaction #, transfer dates, project, award, owning organization and more.  
• For larger reports, use the built in scheduling feature. 

The Project Costs Detail Report dashboard is a single-page report that includes the following details: 

• Project Costs Detail Report
• Transaction Import Details

• Used to check cost details for all projects by Award number, Financial Unit, Accounting Period(s) and more.  
• Transactions match the costs found in the PPM Manage project costs screen of the Oracle User Interface(UI). 

This dashboard brings back all the projects for a Business unit, Project Organization or Project Manager and where available it provides full COA and POETAF Chart string values for these projects.

The Project Information Lookup dashboard includes the following pages: 

• Project COA Lookup 
• Award Project Task Personnel
• Expenditure Type List 
• Non-Sponsored Project Task DFFs 
• Award Personnel 

• Brings back all the projects for a Business unit, Project Organization or Project Manager and where available it provides full COA and POETAF Chart string values for these projects. 

The Project Management Dashboard provides one place to do a complete analysis of a portfolio of projects, including GL and PPM balances, variance analysis, commitments, payroll reconciliation, and expenditures over time

The Project Management Dashboard includes the following reports:

• Summary
• Commitment Details
• High-Level Variances 
• DOPES
• Payroll by Earnings Month
• Expenditures by Month

• Analyze a PI’s portfolio
• Close out expired projects
• Review a department’s operating funds
• Review all faculty startup and retention funds

The Project Overview Report includes the following pages:

• Project Overview
• Project Classifications

• What are all the projects and tasks associated with a given organization or project manager?
• How are all my department’s projects classified? 
• What project-task was an IFIS index number mapped to in Oracle?
• When did a task end?
• What are all of my department’s newly created projects?
• Does a project belong to Campus or Medical Center?

This report helps recharge administrators understand which departments are driving their recharge income and compare upcoming recharge postings with historical data to ensure consistency.

• Results display in a table with Accounting Period Range, Document, Document Entry, Expenditure Type, Financial Unit, Project-Task, Task End Date.
• Click on amounts to view transaction details.
• When searching by Document or Document Entry, the total recharge income (775000) and expense (770000) transactions should net to zero.  Non-zero amounts should be investigated.
• Projects ending in the next 90 days are highlighted in red.

• How much is my recharge facility billing departments each month?
• Who are we billing and how much are we charging them?
• Which departments are driving our recharge income?
• Are the recharges I’m about to post in line with what we’ve posted in past months? 

Financial Management Reports included:

• Contract Management Dashboard
• Department Operations Dashboard
• GL Project Balances
• Financial Resource Management Dashboard
• Project Management Dashboard
• Expanded Project Summary
• Project Information Lookup Panorama

Reports for Performance of Key Controls:

• Transaction Details
• Unprocessed Transactions with Errors

The dashboard includes the following pages:

• Summary
• PPM Revenue and Expense
• GL Revenue and Expense

• What is the balance for my recharge facility?
• How are my recharge operations performing?
• How have my income and expenses changed over time?
• Is my carryforward balance within the allowable range?

The Resource Profiles dashboard includes:

• Summary Page: Displays all metrics within Resource Profiles, aggregating the selected Units together, for the previous 5 years.
• Comparison Report: Includes two different pages
  • Financial Metrics
  • Sponsored Research Metrics

• Reviewing historical trends over the past 5 years to make new program decisions.
• Analyzing previous year Carryforward Balances to determine if extra funding is needed.
• Using Indirect Cost Recovery amounts to project future year budgets.
• Understanding Award Activity within a Unit to evaluate if more resources are required.
• Comparing how different Units are utilizing their resources.

The SPF Accountant Panorama is a collection of analyses and reports designed to assist management and oversight of sponsored projects and awards.

The SPF Accountant dashboard includes the following pages: 

• Core Report 
• Award Summary 
• Expenditures 
• IDC Reconciliation 
• Billing Summary 
• AR Aging 
• Cost Sharing 
• Award Lookup Reports
• SPARCM Reports
• Budget Versions Needing Approval
• Subaward Reconciliation
• 538000 on Non-Sponsored Funds
• Budget Approval BPM
• SP Funds Require Project Number in GL (CVR)
• Helpful Links

• Award Financials
• Award Summary
• Project Overview
• Project Cost Analysis
• Project Billing and Revenue Analysis
• SPF Cycle Time Analysis
• Award Personnel Metrics

• Determine how well my team is doing by using metrics related to number of current and closed awards.
• Quickly gain a high level overview displaying the number of awards by accountant, award status by type, and current status.
• How well is project revenue doing comparing actuals to budget and forecast?
• What are the trends in AR, cost transfers, new awards, and amendments?
• What are my actual project costs by organization and financial resource?

THe SPF Manager Dashboard includes following pages:

• Contract Line Numbers With Alpha Characters 
• Contract Lines Without Associated Project Number 
• Sponsored Projects Without Awards 
• Sponsored Projects With Multiple Awards 
• Invalid Setup - Non-Campus BUs 
• Generate Invoice Process Errors 
• Award Project Dates 
• Costs With Potential Incorrect Billable Status 

•   Is my project properly aligned to the appropriate grant contract? 
•   Do I have any violations in my contract line name?  
•   Are my dates aligned between contract, award, budget and project?   
•   Are my projects properly set-up to capture billable/non billable expenses? 

• List of Reports
• Expenses by Sponsor - Cumulative
• Expenses by Sponsor - Expenses with Details
• Expenses by Sponsor - Inception to Date Expenses with Details
• Expenses by Sponsor - Expenses Details by Fund
• Revenue by Sponsor
• Revenue by Sponsor - Revenue Summary
• Revenue by Sponsor - Revenue and Expenses
• Key Personnel

Support the Compliance and Support Team. 

The Fund Manager Workload Dashboard consists of only one page, which contains a variety of workload metrics for each of the fund managers in a financial unit. Workload metrics can be viewed for a given year, and up to three years simultaneously. 

This dashboard answers questions like:

• How has the workload for each Fund Manager changed over time?
• What does the workload of each of the Fund Project Managers look like and how do they compare to each other?
• Are payroll titles appropriate for each member given their current workload and job performance?

This dashboard includes the following pages: 

• General Ledger Transaction Details
• GL Details ISIS Reconciliation
• AP Invoices for ISIS Reconciliation
• SFS Payment Status
• SFS Refund Details
• Daily Activity
• Incoming Payments (Receipts)
• Applied Receipt Register
• Unapplied Receipt Register
• SPARCM Invoice to OFC Transaction Link
• Unprocessed Transactions With Errors

• What is the status of my student refund?
• Is my receipt applied correctly?
• What incoming payments are in the system?

• Contains the detailed recharges posted to the department chart strings: Project, Task, & Funding Source in OFC.  
• The primary audience for this report are financial officers looking to reconcile the Telecom recharges posted to their department ledgers. 

Available Prompts:

• Original Accounting Period
• Most Recent Accounting Period
• Expenditure Item Date
• Expenditure Creation Date
• High Risk Ledger Review
• PI/Project Manager/Task Manager
• MSO/DBO/CAO
• Fund Manager
• Fiscal Manager
• Financial Unit
• Project Type
• Project Number
• Project-Task
• Transaction Number
• Fund Type and Number
• Invoice Number
• Original Transaction Reference
• Expenditure Batch
• Supplier
• Transaction/Journal Source
• Account Type and Number
• Net Zero Item
• Award Owning Organization
• Award Number
• Funding Source Type
• Funding Source
• Purchase Order
• Transaction Document
• Document Entry
• Expenditure Category and Type

Select high-risk transactions for ledger review:

• High dollar invoices
• Recharges
• Equipment under dollar threshold
• Transactions posted after project end date
• Fabrication cost not on fabrication task
• Questionable expenditure type on sponsored project
• Misposted cost sharing

The Trend Analytics Dashboard includes the following:

• Five overviews: Account, Financial Unit, Fund, Project, and Project Manager
• View trends by year, quarter, or month
• Each overview includes a graph displaying ending balances and a table displaying resources, expenses, and capital assets

This report answers questions like: 

• How have my balances changed over time and what has contributed to increases or decreases?
• How has my spending on graduate support changed over time?
• How does IDC recovery compare over time for all of my PIs/Project Managers?

Identifies UCPath Labor Ledger transactions and Funding Entries where the fund used is different from the fund that should have been used based on the award and project attributes. UCPath fund numbers designate critical behaviors in payroll processing such as applying salary cap rules and allocation of general liability, which is not allowed on federal awards. 

This report has three pages: 

• Labor Ledger
• Unallowable Cap Gap Charged
• Position Funding

• Which awards have had unallowable over the cap salary charged?
• Which funding entries have the incorrect fund code and need to be updated to apply salary cap and general liability rules?

Required Input

• None for this report

Fields

• Project Name
• Project
• Task
• Financial Unit
• Account
• Accounting Period
• UCPath Amount
• Oracle Amount
• Variance (UCPath-Oracle)