This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Banking Information#

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)

---

General Ledger Information#

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.

• Payroll Information (IPPR)
• Define Pay Calendars (IPCL)
• List Pay Calendars (RPCL)
• Define Pay Points (IPPP)
• Pay Categories
  • Define U.S. Pay Categories (IPPGU)
  • List U.S. Pay Categories (RPPGU)
  • Define Canadian Pay Categories (IPPGC)
  • List Canadian Pay Categories (RPPGC)
• Processing Frequencies (IPPF)
• List Processing Frequencies (RPPF)
• Pay Component Usages (IPCU)
  • List Pay Component Usages (RPCU)
• Pay Components
  • Define Pay Components (IPPC)
  • List Pay Components (RPPC)
• Maintain User Variables (IMVR)
• Pay Elements
  • Define Pay Elements (IPPE)
  • List Pay Elements (RPPE)

---

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)

---

Employee Payroll Information#

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
  1. 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.
  2. 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.
  3. The code sequence on IMCS must be set up for Pay Run Number by entity.
  4. The code sequence on IMCS must be set up for Batch Number by entity.
  5. An ARREARS frequency must be set up on IPPF.
  6. Check numbers must be set up on IPPR.
• Payroll Batches (IPBE)
  • List Batches (RPBE)
  • Cancel a Batch (UPCBAT)
• Generate Pay Headers (UPCPAY)
• Load Pay Transactions
  • Load External Data (LMTD)
  • Maintain Loaded Pay Lines (IPTL)
  • Load Pay Lines (UPTL)
  • Generate Pay Transactions (UPTG)
  • Maintain Pay Transactions (IPTR)
  • Maintain Employee Pay Transactions (IPTRE)
  • Balance Pay Transactions (IPTRB)
  • 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.

• Calculate Payroll (UPCALC)
  • Re-Calculate Pay (UPAGAIN)
• Current Pay Register (RPREGC)
• UnDo Pay Preparation (UPUNPREP)
• Pull an Employee (UPPULL)
• Undo a Pay Run (UPUNDO)
• Close a Pay Run (UPCLOZ)

---

Analyze Pay Information#

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.

• Disburse Pays (UPDISB)
  • View Disbursements (IPDS)
  • Print Check List (RPCH)
  • Print Deposit List (RPDP)
  • Generate Deposit File (UPDTB)
  • Generate Check/Deposit Interface File (UPDIF)
  • Print Pay Checks (UPSTUBC or UPSTUBCW)
  • Print Deposit Slips (UPSTUBD or UPSTUBDW)
• Check Reconciliation Process
  • Manage Loaded Cleared Checks (IPCFB)
  • Load Cleared Checks (UPCFB)
  • Reconcile O/S Checks (IPCR)
  • Report Check Reconciliation (UPREC)
  • Positive Pay (UPPOSPAY or UPPOSPAYW)
  • Maintain Checks (IPCH)

---

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)
  • UNDO Transaction/Labor GL (UPLGUNDO)
• Journalize Pays (Post-Payroll) (UPGL)
  • Report Payroll Journal Entries (RPGL)
  • Report Journal Entries By Employee (RPGE)
  • Report Journal Entries By Segment (RPGS)
  • G/L Interface File (UPGLF)
  • Accounts Payable Interface (UPVEND)
  • Undo a Vendor Run (UPUNVEND)

---

Optional Payroll Cycles#

In addition to running ‘regular’ pays there are times when other types of processing may be required.

• Retroactive Pay (UPRETRO)
• Vacation Pay (UPCVAC)
• Reversal Pays
• Adjustment Pays
• Manual Pay
• Manual Check
• Hand Checks
• Future Pays