The next Research Administration (RA) Town Hall will take place on Tuesday, December 10, 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.
The Controller’s Office is pleased to announce the upcoming launch of a new Tableau interface for the Financial/Payroll Codes and Data Lookup tool. An essential resource for the UCSF community, this tool allows users to look up key information, such as chart of accounts elements, award information, payroll codes, and department functional roles.Set to launch in November 2024, searching for financial and payroll codes will transition to UCSF’s Tableau platform. This shift is designed to enhance the user experience and ensure support for ongoing maintenance.Look for more details in the November edition of the Controller’s Office Newsletter, including training on how to access and download results in Tableau.
Based on joint proposals from UCSF Global Programs and the Controller’s Office Accounting and Reporting team, an income statement report (Statement of Comprehensive Income Report), and a balance sheet report (Statement of Financial Position Report) are now available to further assist with the reconciliation of foreign transactions related to operations in foreign countries.Both reports aggregate transactions by account level, and users will be able to drill into the Foreign Affiliate Transaction Detail Report from the report output to review transaction details. Authorized users can run both reports by fund, dept id, and other chartstring attributes. Users can further customize the report output by including or excluding transactions from the open accounting period.Intended only for use by UCSF Global Programs accounting teams, MyReports users with the Foreign Affiliate role can access the new reports from the Foreign Affiliate tab. Users may need to clear their web browser cache for the new reports to appear.To learn more, review the new Statement of Comprehensive Income Report job aid and Statement of Financial Position Report job aid in the MyReports section of the Controller's Office website.Contact the Controller's Office Solution Center if you have questions about MyReports or to report a potential issue.
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 ask a question in PeopleConnect (opens in new window).
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.
