session #: fot-02 adp reporting for the payroll … fot 02 adpr for the payroll practitioner -...

Copyright © 2015–2017 ADP, LLC. Proprietary and Confidential. 1

Session #: FOT-02ADP Reporting for the Payroll Practitioner (REPEAT)

Diane Arcuri, ADPMarch 18, 2017 8:30 AM – 12:00 PMMarch 21, 2017 1:45 PM – 5:15 PM


Copyright and TrademarksThe ADP® logo and ADP® letters are registered trademarks of ADP, LLC. ADP A more human resource.SM is a service mark of ADP, LLC.All other trademarks and service marks are the property of their respective owners.

Copyright © 2015–2017 ADP, LLC. ADP Proprietary and Confidential - All Rights Reserved. These materials may not be reproduced in any format without the express written permission of ADP, LLC. Any repurposing, reposting, or other use of this content (including, but not limited to, YouTube® or any other social media) is expressly prohibited.

ADP provides this publication “as is” without warranty of any kind, either express or implied, including, but not limited to, the implied warranties of merchantability or fitness for a particular purpose. ADP is not responsible for any technical inaccuracies or typographical errors which may be contained in this publication. Changes are periodically made to the information herein, and such changes will be incorporated in new editions of this publication. ADP may make improvements and/or changes in the product and/or the programs described in this publication at any time without notice.


Thank You for joining us at the ADP Meeting of the Minds 2017! FOT 02 will introduce you to some intermediate and advanced reporting functionality that will help you create more effective and useful payroll reports.

Visit the Partner Pavilion to see complementary solutions that can help you achieve your goals.

Participate in Focus On Training sessions to experience hands-on solutions that can help your workforce and business thrive.


Session Objectives

• Prepare to create payroll reports• Create a report using coded amounts• Explore advanced data grouping• Describe dynamic joins• Understand matched and unmatched joins• Examine effective dates and keys


Preparing to Create Payroll Reports


File Relational Diagram: HR/Payroll


Writing Reports Using Coded Amounts


Coded Amounts


Using Advanced Data Grouping


Report Totals and Subtotals


How Do I Create Summary Reports?


Creating Dynamic Joins


What Are Dynamic Joins?


Understanding Matched and Unmatched Joins


Personal Dta

Empl Id Name

10000 Howard,Moe

10001 Fine,Larry

10002 Howard,Curly

CheckView Dta

Empl Id Check# Check Date Gross

10000 90001 01/16/2015 500.00

10000 90102 01/30/2015 500.00

10001 90011 01/16/2015 400.00

Matched Join Results

Empl Id Name Check# Check Date Gross

10000 Howard,Moe 90001 01/16/2015 500.00

10000 Howard,Moe 90102 01/30/2015 500.00

10001 Fine,Larry 90011 01/16/2015 400.00

The matched joining of personal data and check view data produces a row for only those employees that have check data.

Understanding Matched and Unmatched Joins


You must use an unmatched join if you want all employees, regardless of whether they have a paycheck.

Personal Dta

Empl Id Name

10000 Howard,Moe

10001 Fine,Larry

10002 Howard,Curly

Checkview Dta

Empl Id Check# Check Date Gross

10000 90001 01/16/2015 500.00

10000 90102 01/30/2015 500.00

10001 90011 01/16/2015 400.00

Unmatched Join Results

Empl Id Name Check# Check Date Gross

10000 Howard,Moe 90001 01/16/2015 500.00

10000 Howard,Moe 90102 01/30/2015 500.00

10001 Fine,Larry 90011 01/16/2015 400.00

10002 Howard,Curly

Understanding Matched and Unmatched Joins (cont.)


Personal DtaEmpl Id Name10000 Howard,Moe

10001 Fine,Larry

10002 Howard,Curly

Checkview DtaEmpl Id Check# Check Date Gross10000 90001 01/15/2016 500.00

10001 90011 01/16/2016 400.00

Checkview DeductionsEmpl Id Check# Deduction Amount10000 90001 401 50.0010000 90001 MED 40.00

CheckView Hours/EarnsEmpl Id Check# Earn Code Amount10000 90001 REG 300.0010000 90001 OT 200.0010001 90011 REG 400.00

Unmatched Join ResultsEmpl Id Name Check# Check Date Gross Deduction Amount Earn Code Amount

10000 Howard,Moe 90001 01/2016/16 500.00 401 50.00 REG 300.00

10000 Howard,Moe 90001 01/16/2016 500.00 MED 40.00 OT 200.00

10000 Howard,Moe 90001 01/2016/16 500.00 401 50.00 REG 300.00

10000 Howard,Moe 90001 01/16/2016 500.00 MED 40.00 OT 200.00

10001 Fine,Larry 90011 01/16/2016 400.00 REG 400.00

10002 Howard,Curly

If you have more than one child associated with a parent, be aware that duplicate data may be displayed on rows.



Personal DtaEmpl Id Name10000 Howard,Moe

10001 Fine,Larry

10002 Howard,Curly

Checkview DtaEmpl Id Check# Check Date Gross10000 90001 01/15/2016 500.00

10001 90011 01/16/2016 400.00

Checkview DeductionsEmpl Id Check# Deduction Amount10000 90001 401 50.0010000 90001 MED 40.00

CheckView Hours/EarnsEmpl Id Check# Earn Code Amount10000 90001 REG 300.0010000 90001 OT 200.0010001 90011 REG 400.00

Unmatched Join ResultsEmpl Id Name Check# Check Date Gross Deduction Amount Earn Code Amount

10000 Howard,Moe 90001 01/2016/16 500.00 401 50.00 REG 300.00

10000 Howard,Moe 90001 01/16/2016 500.00 MED 40.00 OT 200.00

10001 Fine,Larry 90011 01/16/2016 400.00 REG 400.00

10002 Howard,Curly

However, the use of coded fields helps to eliminate some of the duplicate rows appearing, as in the example below.



Using Effective Dates and Keys


Effective Dates

Dates

Current Data History Data Future Data

The Effective Date field is flagged with a calendar icon.


How ADP Reporting Retrieves Data from Effective-Dated Files

Job Dta

• Employee ID• Effective Date


Additional Payroll-Specific Report Strategies


Set Effective Date Keys


Set Effective Date Keys (cont.)


Effective Parameters

Date

Sequence

Status


Don’t forget! Download your Continuing Education Certificates from the Conference App!

• View, download, and email your CE certificate right from the ADP MOTM Conference app.

• Select CE Certificates from the app’s main menu.

• Available CE certificates will appear after your session attendance. Email them to yourself straight from the app!

• Don’t have a smartphone? Use the web app instead – http://www.apd.com/motmmobile

• Certificates will be available for two (2) months after the conference.


Client-Specific Questions

Visit the Solutions Lab, where ADP associates are available to work with you. Their hours are as follows: • Sunday, March 19: 2 p.m. – 7 p.m.• Monday, March 20: 7:00 a.m. – 6:30 p.m.• Tuesday, March 21: 7:45 a.m. – 4:30 p.m.• Wednesday, March 22: 8:30 a.m. – 12:30 p.m.


Thank You

Session #: FOT-02ADP Reporting for the Payroll Practitioner (REPEAT)

Diane ArcuriLearning Specialist III

ADP Enterprise Learning

DON’T FORGET TO COMPLETE THE SESSION EVALUATION ON THE ADP MOTM CONFERENCE APP.

session #: fot-02 adp reporting for the payroll … fot 02 adpr for the payroll practitioner -...

Documents