Read untitled text version

SUNGARD SUMMIT 2007 | sungardsummit.com

1

Introduction to Payroll Reconciliation

Presented by: Judy Cushman, Banner Human Resources Consultant Teresa Skinner, Banner Human Resources Consultant

March 21, 2007 Course ID 885

A Community of Learning

Session Rules of Etiquette

· Please turn off your cell phone / pager · If you must leave the session early, please do so as discreetly as possible · Please avoid side conversations during the session Thank you for your cooperation!

Course ID 885

2

Introduction

This session will provide an overview of the processes used to reconcile payroll, taxes and W-2's

Course ID 885

3

Agenda

· Banner Tools

· Inquiry Forms · Reports · Processes

· Reconciliation Process

Course ID 885

4

SUNGARD SUMMIT 2007 | sungardsummit.com

5

Banner Tools

Inquiry Forms, Reports and Processes

A Community of Learning

Inquiry Forms

· PHIETIM - Web / Department Employee Time Inquiry

· Review Web / Department Time Entry · Reconcile 3rd Party Time Loaded through Mass Time Entry Table (PHRMTIM)

· PHIJOBS - History Jobs Inquiry

· View disposition by employee and position, total hours, total units

· PHITTOT - Time Sheet Totals

· View Total Hours / Units by Organization

· PHICHEK - Check Detail History

· View by employee after PHPCALC (disposition 40 or higher)

· NHIDIST - Labor Distribution Data Inquiry

· Can query Payroll Transactions, Budget Transactions, Encumbrance Transactions

Course ID 885

6

Reports

· PHRHOUR - Report of Hours

· By Employee by Organization

· PHRPREG - Payroll Register

· View Total Gross, Total Deductions, Total Net · Can be viewed after PHPCALC (disposition 40 or higher)

· PHRCISS - Check Issue Report

· View Total Checks and Net Amount

· PHRDIRD - Direct Deposit Issue Report

· View Total Direct Deposits and Net Amount

· PHRDREG - Deduction Register

· View Total Deductions by Deduction Code · Can only be viewed after PHPUPDT (disposition 60 or higher)

Course ID 885

7

Reports cont...

· PXRTDEP - Tax Deposit Report

· Can Add Additional Information to this report · Run in Original and Adjustment Mode · Run by Pay Period, Date Range or Quarter

· PXRP941 - 941 Quarterly Report

· Can run after every pay period to help balance tax deposits

· PXRW2XX ­ W2 US Report

· Can run in summary mode to help balance tax deposit and 941's

Course ID 885

8

Processes

· Each Process will list the Record Count · PHPTIME and PHPCALC will also list Employee Count · PHPCALC will also list Total Gross, Total Employee Deductions and Total Net · PHPFEXP and NHPFIN2 will list the Total Credits and Total Debits

Course ID 885

9

Table Information by Process

· PHPTIME

· Loads Employee Job Information into · PHRHIST · PHRHOUR · PHREARN · PHRJOBS · PHRELBD · PHRDEDN

· PHPMTIM

· Loads Time Entry Information into PHRHOUR, PHREARN and PHRELBD

Course ID 885

10

Table Information by Process cont...

· PHPDOCM and PHPCHKL

· Loads information into PHRDOCM

· PHPUPDT

· Updates History Tables · PERETOT · PERDTOT · PERJTOT

· PHPFEXP

· Loads NHRDIST and Temporary Table NHRFINC

· NHPFIN2

· Loads information from NHRFINC to Finance GURFEED table

Course ID 885

11

SUNGARD SUMMIT 2007 | sungardsummit.com

12

Reconciliation Process

A Community of Learning

Reconciliation Process

· Information is extracted from reports and put into Excel Spreadsheet · Every payroll event (Original and Adjustments) are listed on the Excel Spreadsheet · Spreadsheet is used to reconcile the payroll feed to Finance

· Verify the Gross Pay, Net Pay and Deductions · Verify the Debits and Credits

· Finance Processes

· FURFEED ­ compare hash totals · FGRTRNI / FGRTRNR ­ produces error report · FGAJVCD / FGIDOCR ­ can verify posting

Course ID 885

13

Reconciliation Process cont...

· Error Resolution

· Run FGRTRNR report to see if error occurred · Output lists errors by Rule Class and problem · Does not list which employee(s) the error occurred on · NHIDIST can be very helpful in determining on which employee(s) the error occurred on

Course ID 885

14

Reconciliation Process cont...

· Tax Reconciliation Reports Used

· · · · · PHRPREG - Payroll Register PHRDREG - Deduction Register PXRTDEP - Tax Deposit Report PXRP941 - 941 Quarterly Report PXRW2XX ­ W2 US Report (can be run in total by quarter or entire year)

· Information is extracted from the Payroll and Deduction Registers and entered on the Tax Reconciliation Worksheet · Use PXRTDEP to verify the totals

Course ID 885

15

Reconciliation Process cont...

· Compare the Tax Reconciliation Worksheet to the 941 Quarterly Report and the W2 US Report

· Recommend that this be done at least on a quarterly basis but can be done on a more frequent basis

· If the totals do not match, it is usually a payroll adjustment

Course ID 885

16

Questions & Answers

Course ID 885

17

Thank You!

Judy Cushman [email protected] Teresa Skinner [email protected]

Please complete the online class evaluation form Course ID 885

SunGard, the SunGard logo, Banner, Campus Pipeline, Luminis, PowerCAMPUS, Matrix, and Plus are trademarks or registered trademarks of SunGard Data Systems Inc. or its subsidiaries in the U.S. and other countries. Third-party names and marks referenced herein are trademarks or registered trademarks of their respective owners. © 2007 SunGard. All rights reserved.

Course ID 885

18

Information

untitled

18 pages

Report File (DMCA)

Our content is added by our users. We aim to remove reported files within 1 working day. Please use this link to notify us:

Report this file as copyright or inappropriate

233064