UCPath Themes for Contracts & Grants Accounting Research - - PowerPoint PPT Presentation

ucpath themes for contracts grants accounting
SMART_READER_LITE
LIVE PREVIEW

UCPath Themes for Contracts & Grants Accounting Research - - PowerPoint PPT Presentation

UCPath Themes for Contracts & Grants Accounting Research Administration Forum August 26, 2020 PRESENTERS Susan McCutcheon, Program Manager, Administrative IT Kristen Pereira, Business Analyst, Administrative IT AGENDA The role


slide-1
SLIDE 1

UCPath Themes for Contracts & Grants Accounting

Research Administration Forum August 26, 2020

slide-2
SLIDE 2

2

PRESENTERS

 Susan McCutcheon, Program Manager, Administrative IT  Kristen Pereira, Business Analyst, Administrative IT

AGENDA

 The role of the UC Path Center in finance functions  Getting the right FAU  Direct Retro Salary Cost Transfer Known Issues  Differences between Cognos and FIS DS  Q&A

slide-3
SLIDE 3

3

The role of the UC Path Center in finance functions

UC Davis

  • Enter/Approve

Funding Entry

  • Enter/Approve

Cost Transfers

  • Request

Configuration

  • Report Defects
  • Request Change

Requests

UCPC

  • Post Labor Ledger
  • Run Cost Transfer

Process

  • Enter

Configurations

  • Resolve Defects
  • Program Change

Requests

slide-4
SLIDE 4

4

Getting the right FAU

Funding Entry

  • Enter and Approve

by Pay Confirm date found on the payroll calendar Redirects

  • Email

ucpath@ucdavis.edu

  • CBR & Leave
  • Tuition Remission
  • GAEL

Cost Transfers

  • Salary Cost

Transfers

  • Benefit Cost

Transfers – by request

slide-5
SLIDE 5

5

Direct Retro – known issues

Timing

It may take days or weeks for the fully approved transfer to appear in reporting

Assessment amounts differ

UCPath backs out assessments by calculation, not amount

Benefit Cost Transfer (BCT) may be needed

Account end dates

Direct Retro cannot be performed if Account end date has passed

Update end date in KFS, then perform transfer

Email ucpath@ucdavis.edu if dates are not automatically updated in UCPath

Work Study award not applied

If award is $0 at time of transfer the split will not be applied

A second Direct Retro transfer is needed

Capped Funding restrictions

Limitations causing the inability to transfer certain earnings codes on capped funding

We are working with the UCPC on a Change Request

slide-6
SLIDE 6

6

Differences between Cognos & FIS DS

Transaction processed in UCPath Data posted to Data Warehouse Data posted to Cognos Data posted to FIS DS

 Differences are largely due to the timing of Direct Retros.

 The ledgers reconcile over time, but may have discrepancies in a specific month due to a

Direct Retro appearing in a different accounting month

 A discrepancy in the 339 Payroll Expenditure Report was resolved

 The report was under reporting expenses in the July timeframe

slide-7
SLIDE 7

7

Questions