AUDIT PAYROLL TRANSACTIONS#
Processing Information#
All batches and transactions (Pay Detail and Sundry) must be audited before UPCALC will process them.The audit process will prepare the pays by creating lines for any attendance or benefit lines for the period, organizes the transactions by pay point, picks up sundry lines for this period and calculates per period premiums.
The Audit Payroll Transactions (UPAUDT) allows you to mass update more than one batch at a time, which will produce a detailed report of the transactions.
After the transactions have been generated or entered into IPPH (Pay Header) they must be audited through UPAUDT (Audit payroll transactions).
The audit process prepares pays for calculations by performing the following tasks:
- Set Toggles
- Evaluate the period and then set the First Pay in Month toggle
- Evaluate the period and then set the First Pay in Period toggle
- Checks for both a Work Jurisdiction and Home Jurisdiction on each pay header
- If any pay headers are missing one or both of these Jurisdictions they will be listed in the report output and the batch will not be Balanced
- Pick up all Sundries
- Create pay lines for all qualified sundry transactions
- Create pay lines for all qualified arrears. (e.g. pick up areas from prior pays)
- One Time Sundry Items are created as pay lines and removed from the sundry table
- Declining balances are reduced for sundries with NO element
- Premiums
- All ‘Per Period’ premiums are calculated and attached.
- Process Pay Points
- Insert pay lines for all tasks on the associated pay point set of the pay header.
- Pay lines are connected to the appropriate pay point set as determined by the pay category on the pay header.
- Establish FLSA Tasks
- Create a pay line for each FLSA period ending in the pay period.
- Insert ‘UserCalc’ Pay Lines
- Insert an additional pay line for any transaction that invokes a UserCalc.
- Insert Begin and End Pay Lines for UPCALC
- These two are not from the Pay Point Set and must be inserted separately.
- Expire Sundry for Termination Pays
- Expire all remaining sundry lines for a termination pay.
- Batch Balancing
- Compute the totals from all pay lines of a batch and a balance to the element amount in the Control tab of IPBE, if provided.
- Physically Remove ‘Cancelled’ Pays
- UPAUDT will physically remove ‘cancelled’ pay headers, pay lines, pay line details that are marked for deletion.
If this process is completed, the Audited and Balanced toggles in IPBE will be turned on. In addition, the system marks the pay headers (IPPH) in that batch so that the Stage field displays “Audit’ and that both the Audit and Preparation toggles are ON.
Before marking a batch as 'Balanced', UPAUDT ensures that there are no pays in the batch for employees with Unaudited Cancelled pays in other batches. In this situation, the UPAUDT process will NOT mark the batch as 'Balanced', and issue will an exception messages for the Audit Report.This edit ensures that there are no cancelled pays for an employee during UPCALC.
This is required since these cancelled pays may have associated leave lines that MUST be removed before the employee can be calculated.
Report Parameters & Filters#
| Report Parameters | |
|---|---|
| Entity | Mandatory, LOV available |
| Payroll | Mandatory, LOV available |
| As of Date | Mandatory, Date, LOV available |
| Eligible Batches | Optional, LOV available Not Eligible or Eligible or Both |
| Sort Employees by | Optional, LOV Available |
| Report Heading | Optional Descriptive Field |
| Print Pay Headers | Optional, LOV Available |
| Print Pay Lines | Optional, LOV Available |
| Include Changes ONLY | Optional, LOV Available |
| Print Transaction G/L | Optional, LOV Available |
| Print Total Page | Optional, LOV Available |
| Include EE Changes | Optional, LOV Available |
| Run ADP Garn | Optional, LOV Available (Yes/No) - Default is No. If Yes, will do ADP GARN validation |
| Exception Level | Mandatory, LOV available ‘0 – 0’ available |
| Report Filters | |
|---|---|
| User Name | Optional, Multiple selections, LOV available |
| Batch Number | Optional, Multiple selections, LOV available |
