Quarter Processing: Using Payroll Reports to Prepare for ...

1 Quarter processing : Using Payroll Reports to Prepare for Quarter End Reports Manual Need support after training? To exchange tips and best practices with fellow users, get on The Bridge an online community built exclusively for ADP clients. V02211834588_1NH Copyright 2009 2018 ADP, LLC ADP Trademarks ADP , the ADP logo , ADP A more human resource , The Bridge Sponsored by ADP & Bubble Talk Design , and ADP Workforce Now are registered trademarks of ADP, LLC. All other trademarks and service marks are the property of their respective owners. Copyright 2009 2018 ADP, LLC.

2 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.

3 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 programs described in this publication at any time without notice. Published by ADP Enterprise Learning February 2018 PREFACE Copyright 2009 2018 ADP, LLC iii V02211834588_1NH Contents Master Control .. 5 Payroll Summary .. 16 Personnel Change report .. 26 Unused Deduction report .. 27 Statistical Summary .. 28 PREFACE Copyright 2009 2018 ADP, LLC iv V02211834588_1NH PagePay Date :Company Code:Company OptionsMaster ControlWeekPeriod Ending :Batch.

4 002003004005006 Number001 DEDUCTION CODE 4 Tax Exemption GridDEDUCTION CODE 26 XEARNINGS CODE CEARNINGS CODE LEARNINGS CODE MXNumberXXXXXEARNINGS CODE 5 Special Accumulators0102 DescriptionXXXXXYESF ederal TaxXXXXXD escriptionCAR ALW 100% REIMBURWASHINGTON HOURSS tate 1 TaxXXXXXA ccumulation OfDEDUCTION CODE FHOURS FIELD 1,2,3,4 Local 1 TaxXXXXXC learingYEAR ENDEVERY QTR0304 SUI/SDI TaxXXXXAMCYESNOEE BUSINESS EXPENSETRAVEL CLUB-QTDS tate 2 TaxXXXL ocal 2 TaxXXCheck/VoucherYESNODEDUCTION CODE BDEDUCTION CODE J05 FUTA TaxableDownloadNOYEAR ENDEVERY QTREDUCATIONAL ASSIST I0607 SUI/SDI TaxableYESYESDEDUCTION CODE TDEPENDENT CARE BENDEPEND FSA-QTD0809 Soc SecYESNOYEAR ENDEARNINGS CODE CDEDUCTION CODE CDEPEND FSA-YTDEVERY QTRM edicareNONOYESYEAR ENDEVERY QTRDEDUCTION CODE CDENTAL PLAN-QTD10 YESYESYESYEAR ENDDEDUCTION CODE DDENTAL PLAN-YTD111213 NOYESNOYESYESDEDUCTION CODE DMEDICAL-QTDMEDICAL-YTDFLEX

5 MEDICAL-QTDNONOYESNOYEAR ENDDEDUCTION CODE SDEDUCTION CODE SDEDUCTION CODE ANONOYESEVERY QTRYEAR ENDEVERY QTR1415181920 YESYESYESYESFLEX MEDICAL-YTDHOURS 1ER PROVIDED TRANS-TAVERMONT HOURSNONOYESNODEDUCTION CODE AHOURS FIELD 1 DEDUCTION CODE ZHOURS FIELD 1,2,3 NONONOYEAR ENDYEAR ENDYEAR ENDEVERY QTROVERTIME HOURS21 YESYESYESYESHOURS FIELD 2 CODED HOURS22232425 YESNOYESNOYEAR ENDHOURS FIELD 3 TRAVEL CLUB-YTDADOPT-EE-QTDYEAR ENDNONONONOYESYEAR ENDDEDUCTION CODE JDEDUCTION CODE 1 ADOPT-EE-YTDNOYESYEAR ENDEVERY QTRDEDUCTION CODE 1 ADAER-YTD262728 NONOYESYESYESDEDUCTIONCODE2 ADAER-QTDMSAEE-YTDMSAEE-QTDNOYESNOYESYEA RENDDEDUCTION CODE 2 DEDUCTION CODE 3 DEDUCTION CODE 3 NONONOYESEVERY QTRYEAR ENDEVERY QTR29303132 YESYESYESYESLTDW2-EXCL-RELOCATIONEBESTOC K OPTION EXERCIS33 YESNOYESNOEARNINGS CODE LEARNINGS CODE MMEMO CODE EEARNINGS CODE

6 NYESYESYESYEAR ENDYEAR ENDYEAR ENDYEAR ENDER PAID HEALTH SAVIN34 YESYESYESYESMEMO CODE HSTOCK OPTION EXERCIS3536 NOS QTR TESTNOYESYESYESYEAR ENDEARNINGS CODE NER PAID HEALTH SAVINEE PAID HEALTH SAVINYESYESNONOYESEVERY QTRMEMO CODE HDEDUCTION CODE 5 AQNYESYESEVERY QTRYEAR ENDS ervice Center :NONOYESYES997 NONOYES8178-99706/30/20 XXNONO06/30/20XX126 Page 5 PagePay Date :Company Code:&RPSDQ\ 2 SWLRQV0 DVWHU &RQWURO:HHNP eriod Ending :Batch :3839404142434437 HSA-125 PLAN-YTD6 SHFLDO $FFXPXODWRUVEE PAID HEALTH SAVINDEDUCTION CODE 6 HSA-125 PLAN-QTDER PAID NON-TXBL SIC1 XPEHUDEDUCTION CODE 5 YEAR ENDDEDUCTION CODE 6 EARNINGS CODE DER PAID NON-TXBL SICYES'HVFULSWLRQEVERY QTRYESEVERY QTRYEAR ENDEARNINGS CODE DEE SAL REDUC PARK/TR$FFXPXODWLRQ 2 IYESYESYESYESEVERY QTRDEDUCTION CODE 8EE SAL REDUC PARK/TR&OHDULQJNONONOYESYESYEAR ENDDEDUCTION CODE 8 SUPP WAGES + $1 MIL$0&NONONONOYESEVERY QTRSUPPLEMENTAL WAGES4546&KHFN 9 RXFKHUNONOYESYEAR END409A DEF W2 CODE Y409A INC W2

7 CODE Z47'RZQORDGNOYESDEDUCTION CODE 4 EARNINGS CODE 4 SCORP484950 NONOYEAR ENDYEAR ENDEARNINGS CODE 5 AWARDS, PRIZES, GIFTTFB-PRIZES-EARNINGSNOYESYESYEAR ENDDEDUCTION CODE PEARNINGS CODE PCO CAR-PERS USE EARN54 YESYESYESYEAR ENDYEAR ENDEARNINGS CODE FROTH UNDER 401(K) PL5557 NONOYESYESYESYEAR ENDDEDUCTION CODE 24 ROTH UNDER 401(K) PLEVERY QTRNOYESNOYESYEAR ENDDEDUCTION CODE 24 TXB HTH BEN VAL FED5859 NONOYESYESEVERY QTRDEDUCTION CODE 26 TXB HTH BEN VAL FEDER SS JOB CREDITNOYESYESYESDEDUCTION CODE 26 RESERVED61626364 NONONOYEAR ENDNEVERTRAVELTRANSIT CHECKEDUCATION ASSISTRESERVEDNONOYESYESDEDUCTION CODE JDEDUCTION CODE 8 DEDUCTION CODE TQ12010 ER SSCR WAGEYESNOQTR 2,4 QTR 2,4 QTR 2.

8 4 NEVER659596 AAABNONOYESYESYESYESHEALTH COVERAGE VALUMEDICARE SURTAX YTDEVERY QTRNONONONOMEMOCODE ADEDUCTION CODE 65 MEDICARE SURTAX QTDMTD 401K401 KNONONONOYEAR ENDYEARENDDEDUCTIONCODE 65 DEDUCTION CODE KYEAR ENDYESNONOGROUP 1 DEDUCTION CODE KACCACC(DUQLQJV /LWHUDOVNONONOYESYES401 KCOBRA CREDIT AMOUNTCOBRA CREDIT COUNT&RGHNONONONONODEDUCTION CODE KRESERVEDRESERVED5 HSRUWBNONOEVERY QTRYEAR ENDEVERY QTRYESYESYESNONONO&KHFN 9 RXFKHUEBETAXFN4*OT126 475 7(67 NONONOSTKOP1409 AIN$41&RGHEBE TAXABLECO CARNON-STAT STOCK409A INCOMES ervice Center :5 HSRUW &KHFN 9 RXFKHU*RG 06 XX&RGHCCO CAR06 XX25 HSRUWDEPEND 6&KHFN 9 RXFKHUDEPEND CARE&RGHD5 HSRUWNTSICKHP5&KHFN 9 RXFKHUNON TAX SICKHOLIPRIZESSCORPEHOLIDAYTFB-PRIZESSCO RPBONUSLS26 BONUSLTDSICKDOMPARLONG TERM DISSICKDOM PAR ERMV*DTQMOVEXVACAQUAL MOV EXPVACATIONPage 6 PagePay Date :Company Code:&RPSDQ\ 2 SWLRQV0 DVWHU &RQWURO:HHNP eriod Ending :Batch.))

9 EKPX2665'HGXFWLRQ /LWHUDOVAEBENON401 KPRIZESCHECK2 ADA-ERHSA125#FSAEBE NON-TAXABLE401K&RGHFLEX MEDICALTFB-PRIZESCHECKING 2 ADOPT-ERHSA-125 PLANMEDST5 HSRUW%=CALC FACTOR0 HPR /LWHUDOVAP&KHFN 9 RXFKHU#=MEDICARE SURTAX&RGHHLTHVL&RGH5 HSRUWHLTH PLAN VALUE5 HVXOW5 HSRUWBMEDICARE SURTAX&KHFN 9 RXFKHU&KHFN 9 RXFKHUEBETAX&RGHEBE TAXABLEFL6 SHFLDO &DOFXODWLRQV5 HSRUWCCO CARLOANSY38&RGH&KHFN 9 RXFKHUDEPENDCO CAR-PERS USELOANMEDSAV1 MSATRANS81&RGHDEPEND FSAHMMEDICALSAVINGS 1 MSATRANSIT CHECK%5 HSRUWDHEALTH1099TZ424401K5 HSRUW&KHFN 9 RXFKHUDENTHEALTH BENOTHER COMPEDUCERTRS409 ADFR401K401 K PLANDENTAL PLANJNEDUCA ASST INCLERPROVIDED TRAN409A DEFERRALROTH IRA 401 KTRAVSTKOP1W1526&KHFN 9 RXFKHUE'HVFULSWLRQTRAVELNON-STAT STOCKCHECK1 ADA-EEHSA-EETXHFED5 HVXOWDCKCHECKING 1 ADOPT-EEHSA-EE CONTRIBDOM PART MED&RGHG'HVFULSWLRQ401K DEDUCTIONGTLOM46 WDWH5 HSRUWGTLHSR INDIVIDUAL/RFDO ,QIRUPDWLRQ&KHFN 9 RXFKHUH&RGHHSA-ER5 HVXOWOMH$XWRSD\ &RGH0022110M*7/.

10 QIRUPDWLRQ5 HSRUWHSA-ER CONTRIB'HVFULSWLRQHSA ER CONTRIBOM41 DPH RI /RFDOLW\0130&KHFN 9 RXFKHUHSR FAMILY LIMITOHEPR5 HVXOWNY'HVFULSWLRQOMK7D[ 6 HUY &RGHNEW YORK CITSPRINGFIELD&RYHUDJH &DOF ' ER MATCH36740 LVFHOODQHRXVOM1$XWRSD\ &RGH33016 WDQGDUG + HAS QUALIFIED PENSION$41 OUTPUT MEMO FOR 401K6 WDWH%HQHILW )DFWRU500,000 DATE 1 is HIRE date126 475 7(671 DPH RI /RFDOLW\0033140P&RYHUDJH /LPLWDATE 2 DATE 2 is BIRTH dateService Center :7D[ 6 HUY &RGH0159$XWRSD\ &RGHNYPA%LUWKGDWH /RFDWLRQ 6 WDWHNEW YORK CITFRANKLIN TWP Home & Mailing address is used on pay statements and tax documents (W-2s, 1099s)1 DPH RI /RFDOLW\33037786for postal delivery, and for tax filing purposes when the employee residence is [ 6 HUY &RGHWhen an employee receives mail at afor postal delivery.]]]