The following new features are now available in the Proposal and Award Metrics Dashboard (PAMDash). These enhancements reflect the continued collaboration between Contracts and Grants Accounting and UCSF’s research administration community to provide self-service access to extramural funding metrics.New dashboard page:A new Diversity Supplement dashboard page shows monthly, yearly, and cumulative funding amounts for awards with diversity supplements.New metrics and data elements:Expense Budget Balance: A new column on the Data: Award Funding & General dashboard page is the difference between the expense budget amount and the total expense amount.NIH Prorated Funding: Upon filtering the Funding Amount, Top Sponsors, NIH Mechanism, and Diversity Supplement dashboard pages to the Funding Type value “Prorated Funding”, all metrics will show the prorated monthly or yearly funding amount where the total award modification funding is allocated equally between the funding period begin date and end date.New data filters for the following:Proposal Status: A new filter in the Proposal Summary, Proposal Amount, and Data: Proposal Detail Data By Year dashboard pages allows users to view proposals based on their status: Awarded (proposals that generated an award); Not Funded (proposals where the Sponsor communicated the proposal will not be funded or where one year has passed since the proposal was submitted); In Progress (proposals submitted to the sponsor and we await a response).Funding Type: Added to the Top Sponsors, NIH Funding Mechanism, and Data: Award Funding Detail Data by Year dashboard pages, use this filter to view award dollars by Funding Added (default) or Prorated Funding.Action Type: Use this new filter on the Data: Award Funding Detail Data By Year dashboard page to limit funding entries by specific award modification action type (e.g., New, Diversity Supplement, Transfer In).RSA Name: Available on all dashboard pages, use to limit proposal and award data to the Research Services Analyst (RSA) assigned.A link to help and contact information is available from all pages.How To Get StartedLog into PAMDash (opens in new window) to experience the new features (MyAccess login and UCSF network/VPN connection required).Join CGA for an upcoming demonstration session to see the new features, walk through common scenarios for using the dashboard, and get answers to your questions:October 16, 2024, 11 a.m. to noonMark your calendars and click here at the start of the session to join (opens in new window) (UCSF authentication is required).PAMDash is managed by the Project and Data Team within CGA. If you have any questions about PAMDash, email the CGA Service Desk.
The Controller’s Office Student Accounting team regularly conducts training to guide administrators through every aspect of the non-payroll stipend process. New employees responsible for submitting non-payroll stipend requests are encouraged to attend. The training is also a good refresher for all employees who submit these requests.The following sessions are open and available for registration:August 14, 2024, 12:30 - 2 p.m.September 9, 2024, 10 - 11:30 a.m.October 22, 2024, 10 - 11:30 a.m.November 13, 2024, 10 - 11:30 a.m.Attendance is limited, and registration is required. Log into the UC Learning Center (opens in new window) to register. This training is presented via Zoom; meeting details will be emailed to registered students prior to the class.If you have any questions about using the UC Learning Center, contact Controller's Office Training Manager Michael Burgess.
Effective July 1, 2024, payment processing for Graduate Student Researchers (GSR) Fellows and Trainees transitioned from the Controller's Office student stipend desk to UCPath. As part of this transition, UCPath has been configured so that Composite Benefit Rate (CBR) assessments will not be calculated for payments to GSRs in the following job codes:003142 GSR-FELLOW-PAID DIR-NO REM003143 GSR-FELLOW-PAID DIR-TUIT REM003144 GSR-FELLOW-NO REM003145 GSR-FELLOW-TUIT REM003152 GSR-TRAINEE-PAID DIR-NO REM003153 GSR-TRAINEE-PAID DIR-TUIT REM003154 GSR-TRAINEE-NO REM003155 GSR-TRAINEE-TUIT REMThe Budget and Resource Management website (opens in new window)provides more information about CBR assessments. If you have questions about the GSR transition to UCPath, contact HR Shared Services (opens in new window) or contact your HR Representative.
As part of the July 2024 release, UCPath introduced enhanced features that align with the University of California Gender Recognition and Lived Name (GRLN) policy. These updates support our diversity initiatives and are designed to better represent and respect gender identity, sexual orientation, and pronouns across our university system.Upon your first login to UCPath on or after July 15, 2024, you will be directed through a process to verify and update your personal identification preferences. Employees must update their selections or decline self-identification before accessing self-service features in UCPath.For detailed information on these changes, please refer to the recent HR news announcement (opens in new window).
Beginning August 1, 2024, the Controller’s Office Unclaimed Payments folder in Box now includes transaction detail files for Electronic Funds Transfer (EFT) deposits into the Contracts and Grants Accounting (CGA) and Department Accounts Receivable (Dept AR) bank accounts. EFT image files can be found in a subfolder titled, “EFTs (ACH wires)”. EFT files for Student Services and Auxiliary accounts will be added later, pending bank implementation. This addition aids in faster identification and claiming of all payments by enabling departments to view ACH statements alongside the current lockbox files.Claiming Payments Sent to Incorrect Bank AccountsAs we continue to notify customers of new remittance details, some payments intended for the new bank accounts may be remitted to the former main depository account. Departments should first check for expected payments on the Unclaimed Payments file corresponding to their respective bank account (Dept AR, Auxiliary, or Student Services). If a non-sponsored payment is not found, review deposits to the former main depository bank account, now identified on the “CGA” tab. If a payment belonging to your department is identified in the CGA account, you must first claim the payment and then process the journal entry against the CGA Account 10110.To access the Unclaimed Payments folder in Box or for detailed instructions on claiming payments, see Identifying and Handling Unclaimed Payments.Answers to Common QuestionsPlease review the answers to common questions below. If you have additional questions or need assistance, contact the Cash and Controls team at [email protected] we need to change our location numbers on new deposit stamps?No, location numbers will not change. The only change on deposit slips will be a new bank account number.Can we use current deposit slips until we receive new deposit slips?Yes, please continue to use existing deposit slips until new slips arrive. We do not want to hold up deposits. New orders typically require 7 to 10 business days for the bank to process.How do we handle customer ACH/Wire registrations with our new accounts?Your customers may require bank verification for the new accounts. Please submit their forms to [email protected] for completion and phone/callback verification if requested.I still have unclaimed payments in the main depository account. With the switch in bank accounts, will I still have access to claim payments from the main depository account?Yes, the unclaimed file has four separate tabs – one for each account. You can continue to claim payments in the old bank account until all your customers have transitioned to the new assigned bank account.
In July, UCPath changed how benefits expenses are recorded for retroactive pay. This change impacts the "Earn End Date" values you will see in the Distribution of Payroll Expense (DPE) reports in MyReports.BackgroundPreviously, retroactive charges for benefits - including consolidated benefit rates (CBRs), vacation leave assessments (VLA), and General Automobile and Employee Liability (GAEL) insurance - were incorrectly associated with the earnings period in which they were processed rather than the earnings period in which they were generated. This made it challenging for departments to accurately reconcile benefit costs back to the correct earnings period.What's Changed?Effective with the July 2024 payroll processing periods, the "Earn End Date" on the DPE for benefits expenses for retroactive pay will reflect the period in which the corresponding pay was originally earned. This change facilitates more accurate reconciliation and reporting.UCPath will not update earnings dates for retroactive benefits expenses processed before the July implementation.If you have questions, please contact the Controller's Office Solution Center.
Based on input from the MyReports Campus Advisory Group, a new Sponsored Awards Accounts Receivable Report is now available to assist in reviewing accounts receivable open invoices for sponsored awards. The report will allow users to view aging invoices, invoice details, and invoices by the sponsor, with data updated nightly.This report complements the recently-announced AR Invoice Inquiry Report available to authorized users in the Research Administration System (RAS). MyReports users without RAS access can run the new report, including Principal Investigators and department administrators with the MyReports Financial Role.Users will find this new report under the Faculty Portfolio tab and may need to clear their web browser cache for the new report to appear.Review the job aid in the MyReports section of the Controller's Office website to learn more. Contact the Controller's Office Solution Center if you have questions about MyReports or to report a potential issue.
The next Research Administration (RA) Town Hall will take place on Thursday, September 26, from 10 a.m. to noon via Zoom.We will communicate further details about the Town Hall through the Research Administration forum on Microsoft Teams. We use Teams to communicate agendas, the Zoom webinar link, and any technical issues or updates during the Town Hall meetings. You can also use Teams to submit topic requests for upcoming Town Hall meetings.Instructions to join the Research Administration forum on Microsoft Teams are also available on the Controller's Office website.
At the start of Fiscal Year 2024-25, the Contracts and Grants Accounting Payments Desk implemented a new feature in RAS to streamline the application of payments to open invoices.Known as the Payment Predictor, this functionality automatically applies payments directly to invoices when the payment amount falls within a specific dollar threshold of the invoice amount. A payment within the threshold will automatically write-off any minor overpayment or underpayment. The RAS Invoice/Payment Reconciliation screen will indicate the write-off with a WU (write-off underpayment) or WO (write-off overpayment) entry and a zero balance.Payments that exceed the threshold established by the Payment Predictor will not be applied directly and will result in a payment status of “worksheet,” indicating that CGA needs further review.Key Benefits for Research AdministratorsThe Payment Predictor will eliminate the need to generate small balance invoices or adjust and re-enter invoices due to minor payment discrepancies.When payment is applied to an invoice within this threshold, the system creates a WU or WO on the invoice payment reconciliation and zeroes out the balance due. For payments over the threshold amount, RAS will no longer create an AO (overpayment) or AU (underpayment) AR item. RAS will generate a payment worksheet indicating that the CGA Payments Desk needs further review. If deemed necessary, CGA will apply the payment to the invoice. This will create either an overpayment or underpayment; however, it will not create an AO or AU entry. If you have questions regarding any of our collection and payment processes, email [email protected].
Contracts and Grants Accounting (CGA) is pleased to share a new report within the PeopleSoft Financials Research Administration System (RAS) to further aid research administrators in identifying and reconciling open invoices. This enhancement is part of the CGA Support Team’s ongoing efforts to streamline sponsored research collections and payment processes, improve transparency, and strengthen internal controls.The Department AR Invoice Inquiry report replaces the weekly RAS A/R Aging Report posted on the Controller’s Office website, which will no longer be updated starting September 1, 2024. RAS users can access this self-service tool to identify in real time open invoices where payment has not been received or not yet applied.The new report will further assist department research administrators who need to perform research on AR aging items. Several filter options are available to search for open invoices.Key Features of the Department AR Invoice Inquiry ReportFor open invoices where payment has not been applied and received, the report provides the following information not available in the former RAS A/R Aging Report:Select the Include Child Departments checkbox to return all invoices for child departments under your selected Department ID.Selecting Dept ID “999999” will search across all departments in UCSF’s Dept ID tree.In order to search for Letter of Credit (LOC) invoices, you must enter an Award ID.Use the Accounting Date From and/or Accounting Thru Date filters to search for open invoices within a specific accounting date range.The RAS A/R Aging Report did not provide the Award PI, RSA, and CGA Service Team member assigned to an invoice. The new report allows you to search by the ID of the PI, RSA, and CGA Service Team member. Click the magnifying glass in each field to look up an ID value if needed.Click the hyperlinked Award ID in the results area to open the FSR/INV Documents tab in a separate browser window in order to view processed invoices.In addition to researching open invoices, checking Include Closed Invoices will also return invoices where payment has been applied for the specified search criteria.Getting Started with the Department AR Inquiry ReportDepartments should begin using the new report immediately. The former RAS A/R Aging Report will no longer be updated. For step-by-step instructions on running the new report, see the How to Run the Department AR Inquiry Report in PeopleSoft training guide.During the month of August, CGA will host the following demonstration sessions to review the features of the new report and answer related questions:Wednesday, August 14, 11 a.m. to noonWednesday, August 28, 11 a.m. to noonMark your calendars and click here at the start of either session to join (UCSF authentication is required).If you need help researching a payment or have other questions about our collection and payment processes, email [email protected].
