Overview

---

These reports are found on the reports dashboard of the Business Analytics Hub (BAH) > HR/Payroll Tab > Payroll Accounting and Reconciliation. If you do not already have access to these reports, please submit an access request for the Payroll Accounting and Reconciliation report category. You can find instructions on getting access to the BAH and general steps on running BAH reports on KBA: Critical UCPath Reports in the Business Analytics Hub 

Intended Audience: Fund Managers, UCPath transactors

Types of Reports

---

DOPE Reports

There are three different versions of the UCPath Labor Ledger-DOPE Report:

1. DOPE Ancillary Report: The purpose of this version of the DOPE report is to isolate GAEL expenses and to provide a Vacation Accounting Report on additional tabs. GAEL expenses have been removed from the Fringe tab because GAEL doesn’t post to salary or fringe benefits. They are now presented on the Ancillary Costs tab. Vacation credits previously on the Fringe tab are now on the Salary tab to align with the account code classification. This report configuration allows the salary and fringe GL postings to match the corresponding DOPE report totals and support reporting requirements for sponsored project administration purposes.
2. DOPE Sponsor Report: This DOPE report version focuses on sponsored research reporting to meet sponsors' financial report and invoice back-up documentation requirements. Similar to the DOPE – Ancillary Report, GAEL expenses have been removed from the Fringe tab and are now presented on the Ancillary Costs tab. Vacation credits previously on the Fringe tab are now on the Salary tab to align with the account code classification and to match the totals by category on the invoices submitted to sponsoring agencies. Only columns relevant to agency requirements with regards to invoice back-up documentation remain. 
3. DOPE Report: This report update has added new and enhanced prompt filters and report options. This report displays actual labor ledger payroll expenses applied for a given payroll cycle. Report includes:
   1. Combined Salary & Fringe: Lists all Salary and Fringe Labor Ledger data on a single tab.  
   2. 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.
   3. Condensed 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.
   4. Report Additional Page Options:
      1. Salary Details Tab : Lists only salary detail rows
      2. Fringe Details Tab: Lists only fringe detail rows
      3. Stipend and Tuition Fees Tab: Lists all related FinAH rows
   5. Report Additional Column Options:
      1. Employee Class
      2. Reports To Name and ID Columns 
      3. Project Nickname
      4. Project Department Reporting Category  

Payroll Reconciliation Reports

There are two different versions of the Payroll Reconciliation Report:

1. UCPath-Oracle Salary Reconciliation Report: The UCPath-Oracle Salary Reconciliation report enables users to identify discrepancies between transactions in the UCPath Labor Ledger (DOPE) and Oracle PPM/GL. Oracle amounts for projects come from PPM, while amounts for chartstrings without projects come from the GL. The drill through includes data from UCPath, Oracle PPM, and Oracle GL, with original transaction reference numbers in all three segments. A second drill through report enables the user to identify transactions in the labor ledger and Oracle ledgers based on the original transaction reference number.
   1. Most useful to departmental financial managers, as best results are obtained when searching by financial unit: use this report if you need to see Fund number.
   2. Allows comparison of salary amounts on funding chartstrings in the UCPath Labor Ledger-DOPE to salary amounts posted to chartstrings in the Oracle General Ledger to quickly identify differences.

For more information on reconciling payroll in Oracle only, please visit GL-PPM Reconciliation on Blink to understand how to use the data and to view answers to frequently asked questions.