Understanding UCPath Payroll Transactions on the TDR and DPE Reports

This guide outlines how to understand UCPath Payroll Transactions on the Transaction Detail Report (TDR) and the Distribution of Payroll Expense (DPE) by Account and Alt Account Reports.

 

Common Differences between the General Ledger (GL) and the Distribution of Payroll Expense by Account (DPE)

Two payroll processes commonly result in differences between the General Ledger (as viewed in the MyReports Transaction Detail Report or TDR and the MyReports Distribution of Payroll Expense by Account or Distribution of Payroll Expense by Alt Account or DPE):

Payroll Process Displayed in GL (TDR) Displayed in DPE Resolution Example(s)
  1. Attempted posting to an Invalid chartstring

 

Fails PeopleSoft combo edit when the payroll journal is edited at month-end.
Routed to payroll suspense account.

No

Yes

Campus

  • Campus departments will enter salary cost transfers directly into UCPath.

UCSF Health

  • UCSF Health departments will submit the new PeopleConnect Salary Cost Transfer Management Action form.  UCSF Health Human Resources will enter the salary cost transfer in UCPath.
  • A salary cost transfer is used to reverse payroll expenses (salary and benefits) charged to the invalid chartstring and re-post to a new chartstring.
  1. Payroll expenses created by Central Payroll via financial journal rather than the payroll system

 

Cannot be processed through payroll system or payroll system is unable to identify a fund source to charge for the expense.  Posts directly to the ledger.

Yes

No
  • Cannot be “corrected”; different values will exist between the GL and DPE
  • Salary and benefit accruals for financial reporting purposes, including biweekly payroll accruals.

Tips on Filtering Payroll Transactions in the MyReports Transaction Detail Report (TDR)

  1. You can limit your report to display only Payroll transactions by using the “Transaction Type” section of the Report Specific Filters . To select only Payroll transactions, click the Payroll option ; the other items (all selected by default) are automatically deselected.

 

 

 

 

 

  1. In addition to suppressing the other transaction types, you can customize the report output to display the Journal ID and Journal Preparer columns. Select the check boxes for “Journal ID” and “Journal Preparer” in the Display Columns picklist on the filter page , or in the report view , and then click “Refine Display Columns” , select the check boxes for “Journal ID” and “Journal Preparer” and then click the “Update” button .

Understanding How UCPath Payroll Transactions are Displayed in the TDR and DPE Reports

Expenses processed through UCPath display with Journal ID LL########. The following example shows how these transactions are displayed:

Additional Information & Assistance

  • If you have questions regarding payroll differences between the GL and DPE, please contact [email protected] with a detailed description.

Give Us Your Feedback