Verify payroll funding ahead of year-end with these HR/GL payroll reporting tools [1]
Each payroll cycle, the funding for payroll is applied during post-processing. It creates accounting lines that are sent to the PeopleSoft Finance System (FIN) in a payroll journal. Payroll Expense Transfers (PETs), which are used to make payroll funding changes after payroll has been processed, are sent to FIN in a single batch two times per day (with a few exceptions when other processes overlap).
Use the following HCM payroll queries to confirm payroll and PET details within HCM. These are available as soon as payroll or the PET is complete.
- HCM Payroll Register Acct Detail: Returns payroll earnings and funding sources.
- HCM Paycheck Distribution: Returns payroll earnings and employer-paid taxes, deductions and funding sources.
Find PETs from the Pay Actions tile, selecting the HRGL Request General Search option from the CU PETs and Funding dropdown menu.
Use mFIN reports to verify the HCM payroll data in CU-Data the day after payroll and PE CU PETs and Funding Ts complete. Here are several CU Data mFIN reports to help you.
- m-Fin Compensation Summary: Returns the total compensation by employee for each position by month detailed by SpeedType, salary, benefits and PETs.
- m-Fin Payroll Transactions: Returns pay and benefits for an employee over a range of accounting periods. The final page displays the Compensation Summary.
- m-Fin Outstanding Encumbrances: Returns an itemized list of committed but not yet incurred payroll by SpeedType.
- m-Fin Financial Detail: Returns an itemized list of all transactions for a SpeedType which can be filtered for payroll account codes.
- m-Fin SpeedType Summary: Confirms the details of active SpeedTypes.
- m-FIN Operating Summary: Provides details for projects, including budget periods.
- m-Fin Account Tree List: Returns the hierarchy of account codes, including those for payroll.
- m-Fin PET: Returns the details of a Payroll Expense Transfer (PET). You can search PETs by fiscal year, PET Operator, and PET Date.
- Journal Entries: PETs created before December 2015 are found using their own individual PET journal ID.
Need extra help?
Learn more about payroll processing in this recording of the HRGL Payroll Reporting webina [3]r the third option under the Budget and Funding header or check out the resources below.
- Use the HRGL page [4]. Under the “Configuration Resources” to find account code mapping: Earning Account Mapping [5], Deduction Account Mapping [6] and Tax Account Mapping [7].
- Use CU-Data to find mFIN reports.
- Office of the University Controller [8] has information on account codes.
- Find HR/GL training for Department Budget Table, Payroll Expense Transfers and other HRGL resources through the training section of the HCM Community website [3].
- Email hcm_community@cu.edu [9] or System.HRGL.Team@cu.edu [10] for additional help.
And you can find HCM queries here:
- Log into the employee portal [11].
- Open the CU Resources dropdown menu and click Business Tools.
- Select the HCM tile and choose HCM Community Users from the drop-down menu.
- Click the HCM WorkCenter tile.
- Select the Resources tab and click the query you desire.
Find CU-Data queries from here:
- Log into the employee portal [11].
- Open the CU-Data tile.