Skip to main content

Journal Detail Report

What is a Journal Detail Report?

  • A journal detail report is a report housed in PeopleSoft HRIS that allows one to view payroll expenses (earnings, deductions and taxes) by payroll general ledger journal ID or cost center
  • A journal detail report is particularly useful in viewing payroll expenses prior to the release of the current month BOB report

Information Displayed on the Journal Detail Report

  • Cost center (fund-department-program-project)
  • Payroll general ledger journal ID
  • Payroll general ledger journal ID date
  • Payroll expense account
  • Paycheck number (Journal Line Reference column)
  • Employee name
  • Amounts of itemized earnings, deductions and taxes

How to Run a Journal Detail Report

Navigation path:

PeopleSoft HR > Main Menu > UHS HRMS Payroll > Reports > Journal Detail Rpt

On the “Find an Existing Value” tab, click “Search” to select a Run Control ID

To add a new run control, select “Add a New Value” on the top-right. Enter a name for the run control then click “Add”

 

The Journal Detail Report can be run with a variety of parameters selected by the user. The two versions that will be provided as examples:

1) Running Journal Detail Report by Date Range

This version can be run if the user would like to view payroll across a specific timeframe and/or the payroll general ledger journal ID is unknown.

2) Running the Journal Detail Report by Journal ID

This version can be run if the user knows what the payroll general ledger journal ID is known.

 

1) Running Journal Detail Report by Date Range

  • Parameters
    • Journal Select Option: Select by Journal Date
    • From/Thru Dates: Choose date range relevant to data sought
    • Journal Data to Include: Payroll Only
    • Journal Rpt Sort Option: Cost Center, Journal ID

 

  • Additional Parameters tab
    • The search can be narrowed down by specifying a cost center. If not, at minimum, a department ID should be entered
    • The search can also be narrowed down by specifying a specific payroll account such as “50180 P&A Staff Salaries, Exempt”
    • Leave “HR Business Unit” and “GL Business Unit” blank
  • Once all parameters are chosen, click “Run” on the top-right corner
  • A second page will appear. Click “OK” in the bottom-left corner
  • Then click “Process Monitor” in the top-right corner and wait until the run status shows “Success” and the Distribution Status shows “Posted”
  • Once the report is successfully posted, click “Details”, then “View Log/Trace” and open the report in PDF or Excel format
  • Payroll information is displayed for all employees within the selected parameters
  • The journal detail report is in order by cost center then journal ID
  • The “Journal Line Reference” displays the paycheck number for each employee
  • In June, the May BOB will be available for review, which will include payroll data for the journal dated 05/31/2026

2) Running the Journal Detail Report by Journal ID

  • The journal ID can be found on the revenue/expense transactions page of the 1074 report
  • Parameters
    • Journal Select Option: Select by Journal ID
    • GL Journal ID: Journal ID should start with “HR”
    • Journal Data to Include: Payroll Only
    • Journal Rpt Sort Option: Journal ID
  • Additional Parameters tab
    • The search can be narrowed down by specifying a cost center. If not, at minimum, a department ID should be entered
    • The search can also be narrowed down by specifying a specific payroll account such as “50180 P&A Staff Salaries, Exempt”
    • Leave “HR Business Unit” and “GL Business Unit” blank
  • Once all parameters are chosen, click “Run” on the top-right corner
  • A second page will appear. Click “OK” in the bottom-left corner
  • Then click “Process Monitor” in the top-right corner and wait until the run status shows “Success” and the Distribution Status shows “Posted”
  • Once the report is successfully posted, click “Details”, then “View Log/Trace” and open the report in PDF or Excel format
  • Payroll information is displayed for all employees within the selected parameters
  • The journal detail report is in order by cost center
  • The “Journal Line Reference” displays the paycheck number for each employee
  • In June, the May BOB will be available for review, which will include payroll data for the journal dated 05/31/2026