Quarter Processing: Using Payroll Reports to …

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

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

3 27 Statistical Summary .. 28 PREFACE Copyright 2009 2018 ADP, LLC iv V02211834588_1NH PagePay Date :Company Code:Company OptionsMaster ControlWeekPeriod Ending :Batch :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 MEDICAL-QTDNONOYESNOYEAR ENDDEDUCTION CODE SDEDUCTION CODE SDEDUCTION CODE ANONOYESEVERY QTRYEAR ENDEVERY QTR1415181920 YESYESYESYESFLEX MEDICAL-YTDHOURS 1ER PROVIDED TRANS-TAVERMONT HOURSNONOYESNODEDUCTION CODE AHOURS

4 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 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

5 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 CODE Z47'RZQORDGNOYESDEDUCTION CODE 4 EARNINGS CODE 4 SCORP484950 NONOYEAR ENDYEAR ENDEARNINGS CODE 5 AWARDS, PRIZES.

6 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,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.))

7 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 :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

8 ADOPT-EEHSA-EE CONTRIBDOM PART MED&RGHG'HVFULSWLRQ401K DEDUCTIONGTLOM46 WDWH5 HSRUWGTLHSR INDIVIDUAL/RFDO ,QIRUPDWLRQ&KHFN 9 RXFKHUH&RGHHSA-ER5 HVXOWOMH$XWRSD\ &RGH0022110M*7/ ,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.]]]

9 The Home address 027 Glocation other than their residence and has both a mailing address and a home address,06 XX59the Mailing address is used on pay statements and tax documents (W-2s, 1099s)06 XXPAis used for tax filing purposes when the employee residence is TWP8746 Page 7 PagePay Date :Company Code:0 DVWHU &RQWURO:HHNP eriod Ending :Batch :$/%5,*+7 $17+21<'MILFORD /,CT06461)LOH Dept:Cntl:Code0 DLOLQJ +RPH $GGUHVV67 MAIN AVELWW: 52000500 FTHS'DWHVHire:Rate Calc: Sex:SSN:04/15 :Bi-WklyNWW: 32 MOn FileBirth:Ac61 TRAVE$1*(/2 0$5,$4, :Clock:Acct 1:05/12 :$25 Extra Federal TaxACTIVEBD001 XXXXXX7911 Acct 2:AcAA MTD 4 CT'LUHFW 'HSRVLWVCodeXXXXXXX8764 AcAB 401 KMarital Status: M-MARRIED03 WKFWY3 Federal:&DOF ) :4, CT SUI/DITran/ABA:DDENTS MED3, Cov 156, DENTAXXXXXXXX XAcAC State 1#1 XXXXXXXX XPartial DepositH HEALTHY , Deposit5, :Ac12 12th of MEDF iling Status 04 (Table D)To SUPPS alary:N *RDO 'HGXFWLRQV6 HSA125Ac01 CAR AAc22 TRAVEAc50 CO CA67, , State , GrossYSS4, ER PA1, , , ER PAQ GrossQSS1, , +RPH $GGUHVVBi-Wkly7, MEDYGTLQ HSA-12, GTLAc04 TRAVE428 RONALD DRIVE21 NJ SUI/DIDept:3 QFIT3, ORANGE,NJ 07052)LOH 000600%$5%$72 6$08(/Y Fringe BenRate Calc: Sex:1, :Tran/ABA:Status:SSN:Q Fringe BenMarital Status: M-MARRIED01 ExemptionsAcct 2:F0 DLOLQJ +RPH $GGUHVV42 1:XXXXX1006On FileFORT MEYERS,FL 33901)LOH X CHECK2 XXXXXX1011 Code170 OAK LALWW: 52 Dept:Cntl:'DWHV'LUHFW 'HSRVLWVWXG ross:Bi-WklyNWW.

10 32000600 FTHSXXXXXXXX XTERM2, Calc: Sex:Full DepositTran/ABA:Hourly Rate:42 FL SUI/DIMXXXXXXXX ) :SSN: DepositMarital Status: M-MARRIED02 Exemptions81BD020On File09/08/1986 Federal:Status: :AcAC 401K6C ACORN WAYDDENT24 12th of Month:Ac22 TRAVE05/02/1961 , GTL# ER PAAc44 SUPPAcAA MTD $9$//2 )5$1. /NSTKOP1Y MEDStd Hours:To Date:Ac35 ER PAAc55 PARK VILLAGES MEDQ MEDGTL Cov 93, HSA-1Ac61 TRAVE2, , , :Y GrossQSS*RDO ' ROTHAcAB 401K0 DLOLQJ +RPH $GGUHVV12, MEDICQ Gross1, Calc:3, , HOURSYFITY401 KJACKSONVILLE,FL 32225)LOH Dept:Cntl:126 475 7(671, : 52 000500FT$41Q FITQ 401 KBi-WklyNWW: 32 Status:Clock:Service Center :Ac04 TRAVEM arital Status: M-MARRIED02 Exemptions42 FL SUI/DIACTIVEBD044 :42 06 XXAc10 ) MTD 406 XX4 DDENT'LUHFW ' 12th of , MED401 KGTL Cov 89, EE SAAcAB TRANSXXXXXXXX XAc44 SUPP36, , GrossYSSY TRANS11, DENTAQ , 1 FITY MEDXXXXXXX2981Ac43 EE MEDW2, Q 401 KAc12 MEDICPage 8 PagePay Date :Company Code:0 DVWHU &RQWURO:HHNP eriod Ending :Batch :&$9$//2 )5$1.