The Banking Information area defines the banking information required for the pay process for your
organization and its employees.
- Define Bank Locations (IPBL)
- Define Bank Accounts (IPBA)
If a General Ledger Interface is going to be used between Wiki and your general
ledger system, then there are several forms and concepts that must be completed and
reviewed.
- General Ledger Company (IDGC)
- General Ledger Segments (IDGS)
- General Ledger Accounts (IDGA)
- List G/L Accounts (RDGA)
Payroll Structure#
The Payroll Structure area defines the policies surrounding the payroll procedures within your company.
Government Requirements#
The Government Requirements area defines the government registrations and taxation policies for your
company.
- Government Registrations (IDGV)
- U.S. Taxation
- Canadian Taxation
- Maintain Canadian Claim Codes (IPCC)
- Maintain Canadian Tax Rates (IPCT)
- Workers' Compensation (IPWC)
- Report On Total Earnings Per WCB Class (RPWC)
The Employee Payroll Information area defines the employee’s taxation rules, payment method and maintains the employee’s recurring transactions.
- U.S. Pay Rules (W4) (IPRLU)
- Canadian Pay Rules (TD1/TP1015.3V) (IPRLC)
- Payment Method (IPPM)
Batches and Transactions#
The Batches And Transactions area maintains the payroll batches, employee transactions, and batch audit update.
- Set Up
- A Pay Component with a pay component usage of ‘5’ (Advanced Recovered) must be set up in order to process Insufficient Earnings + Negative Deductions. This PC must be placed in the ‘Total Deductions’ element of IPPE.
- A Pay Component with a pay component usage of ‘4’ (Employee Advanced) must exist to handle situations where there are insufficient earnings to cover a deduction and the client wishes to ‘Advance’ funds to the employee rather than "Underdeduct". This Pay Component would contain the amount of the advance/shortage. This PC must be placed in the ‘Gross Pay’ element in IPPE.
- The code sequence on IMCS must be set up for Pay Run Number by entity.
- The code sequence on IMCS must be set up for Batch Number by entity.
- An ARREARS frequency must be set up on IPPF.
- Check numbers must be set up on IPPR.
- Payroll Batches (IPBE)
- Generate Pay Headers (UPCPAY)
- Load Pay Transactions
- Load External Data (LMTD)
- Maintain Loaded Pay Lines (IPTL)
- Load Pay Lines (UPTL)
- Pay Transactions (IPTR)
- Generate Pay Transactions (UPTG)
- Pay Transactions (IPTR)
- Print Pay Transactions (RPTR)
- Time Rules (IDWR)
- Process Time Rules (UPRL)
- Transfer Pay Transactions (UPTBATCH)
- Process Pay Transactions (UPTR)
- Employee Pays(IPPH)
- Sundry Pay / Deductions (IPSN)
- Print Sundry Transactions (RPSN)
- Pre-Calc Exception Report (RPEXCP)
- Audit Payroll Transactions (UPAUDT)
Payroll Cycle#
The functions listed below are controls for the payroll calculation cycle.
After a payrun has been created you may view payrun information to determine that stage/status of the payrun.
- Pay Run Information (IPVP)
- View Employee Pay Totals (IPVT)
- Print Pay Profile (RPPH)
- Pay Totals Register (RPREGT)
- Period Pay Register (RPREGP)
- Pay History Register (RPREGH)
Disburse Pays#
After a payrun is closed, pays may be disbursed according to the Net Pay Split completed
during the Payroll Calculation. At any time after pays have been disbursed the detail of what was done for each employee may be viewed. If your organization is printing check stubs, then a list of the checks should be run to audit against. If your organization is printing deposit notices, then a list of the deposits
should be run to audit against.
Distribute Pays#
Payroll G/L distribution is used to account for all costs and expenses associated with Payroll, including labor if the labor distribution process is not required. Payroll G/L distribution may be run on the same cycle as the payroll process, or may be performed based on G/L fiscal period (e.g. once a month).
- Set Up
- Prior to running any of the GL update functions ensure all G/L setup is done accordingly to the following screens:
- IDEN Set up G/L Company for the entity
- IDGC Set up G/L Company
- IDGS Set up G/L Segments
- IDGA Set up G/L Accounts
- IDPS Set up distribution for positions if necessary
- IDJB Set up distribution for jobs if necessary
- IEAS Set up distribution for employees
- IPPC Set up DR or CR G/L Account Codes for eligible pay components
- Journalize Pay Transactions (UPGLPTR)
- Journalize Pay Lines (UPGLPPL)
- Journalize Labor (Pre-Payroll) (UPLG)
- Journalize Pays (Post-Payroll) (UPGL)
Optional Payroll Cycles#
In addition to running ‘regular’ pays there are times when other types of processing may be required.