unit logo
  1. Home
  2. Knowledge Base
  3. Internal Controls and Quality Assurance
  4. Tier 3 Resources
  5. Quick Guide: Spot-Checking the Payroll Reconciliation Report

Quick Guide: Spot-Checking the Payroll Reconciliation Report

Overview

This guide provides details on formatting the Payroll Reconciliation Detail in Excel to allow for easy spot checking and provides suggestions for items to look for during your checks.  If your Tier 2 person gives you the Monthly Financial Reports and there is no need to format the Excel report, please skip to the “Spot-Check” section below.

Format the Payroll Reconciliation Report

  1. Download the Payroll Reconciliation Report. myUFL Navigation: Main Menu à Enterprise Reporting > Department Reports (see Quick Guide: Obtaining Monthly Financial Reports)
  2. In the Excel file, delete all columns “A” through “S”.
    • Click on column “A” at the very top (where the “A” is) and hold down the mouse through “S”
    • Right-click and select “Delete”
  3. Add a filter to the report.
    • Go to the “Data” tab at the top and click on “Filter”

Spot-Check the Payroll Reconciliation

Sort and Spot-Check by Name

  1. Go to the “Data” tab at the top and click on “Sort”
  2. Click the drop-down next to “Sort by” and select “Name Field” and “OK.”  All other values will default.
  3. Quickly spot-check each employee for some or all of the following:
    • Employees with more or less paychecks than expected
    • “FTE” should be the same for all checks
    • “Earn %” should be the same for all checks (this is the amount of the employee’s paycheck paid out of the shown funding source in the “Cost Center Calc” column)
    • “Cost Center Calc” should be the same for all checks (this is the funding source of the employee’s paycheck)
    • Exempt employees should have the same salary amount for all checks
  4. Slight differences due to rounding are okay

Sort and Spot-Check by Accounting Date

For a very high level review of payroll activity throughout the month:

  1. Go to the “Data” tab at the top and click on “Sort”
  2. Click the drop-down next to “Sort by” and select “Accounting Date” and “OK.”  All other values will default.
  3. Go to the “Data” tab at the top and click on “Subtotal”
    • Complete the pop-up box to match the following, and click “OK”:
  4. This will quickly allow you to see the number of employees and FTEs paid each paycheck during the month.

Last Reviewed

2/10/2020: reviewed content

Training

CFO400: Fiscal Responsibility for Leaders at UF

Contacts

University Controller’s Office: (352) 392-1321

UF Computing Help Desk: (352) 392-HELP