Transcription
1Payroll Report SamplesAppendix DThis section contains representative samples of the reports available in yourPayroll module.Samples of the following reports are included. BACK ACA Applicable Large Employee ReportEmployee DetailsTotalsEarnings Code ListingDeduction Code ListingTax Table ListingFederal ListingState ListingPayroll Data Entry Audit ReportEarnings RegisterBenefits RegisterDeduction RegisterPension Plan Deduction RegisterLabor Distribution ReportEmployer's Expense SummaryEmployer's TaxWorkers' CompensationDeposit LiabilityPre-Check RegisterCheck and StubDirect Deposit StubCheck RegisterDirect Deposit RegisterDaily Transaction RegisterEmployee ListingDetailed ListingSummary ListingEmployee Mailing LabelsEmployee MemoPayroll Report Samples
2 BACK Quarterly Tax ReportFederal TaxesFederal Taxes - Tip Earnings & EICFederal Taxes with FICA Tip DataFederal Taxes - Tip Earnings & EIC with FICA Tip DataPayroll Check History ReportQuarterly Pay Period RecapEarnings ReportDeduction ReportPerpetual Deduction History ReportConsolidated Deduction History ReportPension Plan History ReportBenefit Accrual ReportWorkers' Compensation ReportGeneral Ledger Posting RecapPerpetual History ReportPay Rate Change ReportEmployee Masterfile Audit ReportPre-Note Selection RegisterPre-Note Approval RegisterQuarterly Governmental ReportQuarterly 941 FormW-2 FormEmployee Totals VerificationThe following reports appear if the Payroll module is integrated with JobCost. Payroll Data Entry Audit ReportLabor Distribution ReportJob Cost Burden Allocation RegisterPayroll Report Samples
3ACA Applicable Large Employer ReportEmployee DetailsACA Applicable Large Employer ReportPeriod End Dates: 01/01/2014 to 12/31/2014ABC Distribution and Service Corp. (ACB) BACKEmployee 000039023-0000400Employee S,JERRY ICHARDSTORCH,MARY E.TILTON,SHERWINFRASIER,WALTERJAMIESON,ANTHONYRun Date: / /2015 10:02:10AM P/R Date: 91438988138134149978692149Page: 1Payroll Report Samples
4ACA Applicable Large Employer ReportTotalsACA Applicable Large Employer ReportPeriod End Dates: 01/01/2014 to 12/31/2014ABC Distribution and Service Corp. (ACB)TOTALSFull-Time Employee Count:FTE Employee Count:Total Full-Time FTE Employee Count:Jan Feb Mar Apr May JunJul Aug Sep Oct Nov 279362893727936383838383838383838383838Average Count for Full-Time FTE Employees: 37*FTE Full-Time EquivalentTotal Employee Count: BACKRun Date: / /2015 10:02:10AM P/R Date: 5/31/2015Page: 2Payroll Report Samples
5Earnings Code ListingABC Distribution and Service Corp.EARNINGS CODE LISTINGCD DESCRIPTIONG/L ACCOUNTT M P P WP E R D CACCRTYPESSTD.AMOUNT MULT.FEDW F F M M TATEROOMTESRRVRRRMRMMOBMATVS NS NYYYYRegularOvertimeDoubletimeHolidayTips ReportedTips DifferSick PayAdvanceBonusVacation PayPersonal DayReg-Other (PTReg SeasonalMISC EARN 1EXA 1EX 1EXA 2EX 2EX 3MISC EARN 2Tip AllocatedTips EarnedSSSSFFSSFSSSSFASASSFFF1 Y Y1 Y Y1 Y Y1 Y Y0 Y Y0 Y Y1 Y Y1 Y Y0 Y Y1 Y Y1 Y Y1 Y Y1 Y Y0 Y Y1 Y Y1 Y Y1 Y Y1 Y Y1 Y Y0 Y Y0 N N0 Y YVS PVS PVS PVS YYYYYNYYYYYYYYYYYYNY BACKSystem Date: 0 / /2015 / 10:30 am Application Date: 05/31/2015Page: 1User: JWS / jwsmithPayroll Report Samples
6Deduction Code ListingABC Distribution and Service Corp.DEDUCTION CODE LISTINGD C EQUAL TOT M EARNINGSCD DESCRIPTION01 Tips ReportedAccrual G/L Account: 665-01-00Expense G/L Account:STDAMOUNTS E 05.00DEDFREQAUTOEARN12345STANDARD LIMIT: BACK02 AdvanceAccrual G/L Account: 665-01-00Expense G/L Account:03 Health InsurAccrual G/L Account: 715-00-04Expense G/L Account:04 Credit UnionAccrual G/L Account: 245-00-00Expense G/L Account:05 SavingsAccrual G/L Account: 765-00-04Expense G/L Account: 665-01-00S A.00S A60.00S A.0012345E H5.00001234506 401k PlanAccrual G/L Account: 665-01-00Expense G/L Account:W2-BOX 12 CODE: DP PFED W/H:EMPLOYEE FICA:EMPLOYER FICA:EMPLOYEE MEDICARE:EMPLOYER MEDICARE:FED UNEMP:FB No Cash FringAccrual G/L Account: 665-01-00Expense G/L Account:Sys Date: 5/31/03 / 3:45 pmApp Date: 5/31/035.000%12345112345STANDARD LIMIT:RESET BALANCE AT YEAR END: YSTATE W/H: YSDI: YEMPLOYEE SUI: YYYYYYY1.0010,000.00STATE UNEMP: YS A.0012345Page: 1User: John SmithPayroll Report Samples
7Tax Table ListingFederal ListingABC Distribution and Service Corp.TAX TABLE LISTINGTAX CODE:FEDERALTAX ID NO:CALC STEPS:12-654322 6 7PER EXEMP ALLOWED?:PER EXEMPT EXCEED DEP EXEMPT?:EXCLUDE THIS TABLE FROM UPDATE?:ROUND WITHHOLDING TAX AMOUNT?:WITHHOLDING TAXEMPLOYEE FICAEMPLOYER FICAEMPLOYE MEDICAREEMPLOYR MEDICAREUNEMPLOYMENT TAXACCRUAL 30-01-00FILING STATUS: HHEAD OF HOUSEHOLD% FED:SUPPL %:APPLICABLE?STANDARD DEDUCTION:PERSONAL EXEMPTION:DEPENDENT EXEMPTION: BACKSTEPAT LEAST123456123456Sys Date: 5/31/03 / 9:41 amApp Date: 0000%25.00000%TYPEAAAAAFED W/H MAX:LOW LIMIT:ANNUALAMOUNT14.0000.000.00LOWERLIMIT% FED:SUPPL 00321,200.00AND OVER.APPLICABLE?AT MAXIMUM NUMBERALLOWEDBUT LESS THANFILING STATUS: .0068,500.00148,700.00321,200.00STANDARD DEDUCTION:PERSONAL EXEMPTION:DEPENDENT 00%33.00000%35.00000%0.00000%25.00000%MAXIMUM NUMBERALLOWED0.00PERCENTAGE OF EXCESSFED W/H MAX:LOW .000BUT LESS 00AND 5040,022.5086,404.000.000.00PERCENTAGE OF %35.00000%Page: 1User: John SmithPayroll Report Samples
8Tax Table ListingState ListingABC Distribution and Service Corp.TAX TABLE LISTINGTAX CODE:CATAX ID NO:CALC STEPS:CALIFORNIA123-4562 9 6475PER EXEMP ALLOWED?:PER EXEMPT EXCEED DEP EXEMPT?:EXCLUDE THIS TABLE FROM UPDATE?:ROUND WITHHOLDING TAX AMOUNT?:WITHHOLDING TAXWORKERS' COMPEMPLOYEE SDIEMPLOYEE SUIUNEMPLOYMENT TAXACCRUAL ACCT225-03-00230-03-00225-03-00230-02-00FILING STATUS: HHEAD OF HOUSEHOLD% FED:SUPPL %:APPLICABLE?STANDARD DEDUCTION:PERSONAL EXEMPTION:DEPENDENT EXEMPTION: STEP BACKAT LEAST123456% FED:SUPPL %:APPLICABLE?STEPAT LEAST123456Sys Date: 5/31/03 / 8:16 amApp Date: 44,125.0052,120.00AND OVER.FILING STATUS: MMARRIED 2 ALLOWANCESSTANDARD DEDUCTION:PERSONAL EXEMPTION:DEPENDENT 3,652.0060,596.0076,582.00AND MOUNTUPPERLIMIT0.000.000.00PERCENTAGE OF EXCESSFED W/H MAX:LOW %6.00000%18.00014.000BUT LESS UM NUMBERALLOWEDYYTYPEFED W/H MAX:LOW LIMIT:18.00014.000BUT LESS .00RATEMAXIMUM IT0.000.000.000.000.000.00PERCENTAGE OF 000%Page: 1User: John SmithPayroll Report Samples
9Payroll Data Entry Audit ReportABC Distribution and Service Corp.PAYROLL DATA ENTRY AUDIT REPORTDETAIL OPTIONDEPARTMENT NO: 11EAST - WAREHOUSEMENEMPLOYEE ENTNUMBERNO.NAME0000100THOMAS, JERRY A.1CODE DESCRIPTIONSTLOCW/CDP LABORCODEJOB NO.COST CODERATEHOURSCHECK AMOUNT:E 01 RegularWI11 000000113.850EARNINGS TOTAL:D 03 Health InsurD 04 Credit UnionD 06 401k 0FEDERAL WITHHOLDINGF.I.C.A.MEDICARE W/HSTATE WITHHOLDING18.7832.637.6325.51TAX TOTAL:00001051JENKINS, ALLEN84.55CHECK AMOUNT:E 01 RegularWI11 000000113.850EARNINGS TOTAL:D 03 Health InsurD 04 Credit UnionD 06 401k PlanWI5.000% L WITHHOLDINGF.I.C.A.MEDICARE W/HSTATE WITHHOLDING32.6032.637.6327.01TAX TOTAL: BACK00001101PHILLIPS, AVERYWI11 000000114.860EARNINGS TOTAL:D 03 Health InsurFEDERAL WITHHOLDINGF.I.C.A.MEDICARE W/HSTATE 6231.33TAX TOTAL:System Date: 05/31/10 / 10:12 amApplication Date: 05/31/10424.0260.00DEDUCTION TOTAL:FEDFEDFEDWI99.87CHECK AMOUNT:E 01 Regular316.4340.00DEDUCTION TOTAL:FEDFEDFEDWI281.75554.0040.00DEDUCTION TOTAL:FEDFEDFEDWIAMOUNT110.38Page: 1User: John SmithPayroll Report Samples
10Earnings RegisterABC Distribution and Service Corp.EARNINGS REGISTERDEPARTMENT NO:11EAST - WAREHOUSEMENEMPLOYEENUMBER NAMEHOURSAMOUNTTHOMAS, JERRY 7.52110.80EMPLOYEE TOTAL:43.25621.520000105JENKINS, ALLEN010410RegularHolidayVacation Pay24.008.008.00332.40110.80110.80EMPLOYEE TOTAL:40.00554.000000110PHILLIPS, EE 67.52340.48110.80123.251,769.92DEPARTMENT 11 RECAP01020410RegularOvertimeHolidayVacation PayREPORT RECAP01020410RegularOvertimeHolidayVacation Pay EARNINGS CODE0000100DEPARTMENT 11 TOTAL:BACKREPORT TOTAL:Sys Date: 05/31/03 / 6:20 amApp Date: 05/31/03Page: 1User: John SmithPayroll Report Samples
11Benefits RegisterABC Distribution and Service Corp.BENEFITS REGISTERDEPARTMENT NO: 55EXECUTIVEEMP NO NAMEEARNINGS CODE0000430 LEWIS, JOHN01 Regular10 Vacation PayEMPLOYEE TOTAL:0000440 SAMUELS, LESLIE01 Regular10 Vacation PayEMPLOYEE TOTAL:DEPARTMENT 55 RECAP01Regular10Vacation PayDEPARTMENT 55 TOTAL:REPORT RECAP01Regular10Vacation PayREPORT TOTAL:HOURSVACHOURS ACCRUEDSICKPersonalPAY 10.003.33.6740.3940.39AMOUNTS 0288.1857.98 BACKSys Date: 05/31/2003 / 10:31 amApp Date: 05/31/2003Page: 1User: John SmithPayroll Report Samples
12Deduction RegisterABC Distribution and Service Corp.DEDUCTION REGISTERDEDUCTION CODE:03Health InsurEMPLOYEE NUMBER/NAME11 - 000010011 - 000010511 - 0000110RATEHOURSTHOMAS, JERRY A.JENKINS, ALLENPHILLIPS, AVERY60.0060.0060.00DEDUCTION 03 TOTAL:DEDUCTION CODE:04180.00Credit UnionEMPLOYEE NUMBER/NAME11 - 000010011 - 0000105RATEHOURSTHOMAS, JERRY A.JENKINS, ALLEN06150.00401k PlanEMPLOYEE NUMBER/NAMERATE11 - 000010011 - 00001055.000%5.000%THOMAS, JERRY A.JENKINS, ALLEN DEDUCTION 06 TOTAL:DEDUCTION TOTAL:EMPLOYER CONTRIBUTION TOTAL: AMOUNT100.0050.00DEDUCTION 04 TOTAL:DEDUCTION 058.78388.78.00BACKSys Date: 05/31/03 / 6:36 amApp Date: 05/31/03Page: 1User: John SmithPayroll Report Samples
13Pension Plan Deduction RegisterABC Distribution and Service Corp.PENSION PLAN DEDUCTION REGISTERDEDUCTION CODE:06401k PlanEMPLOYEE NUMBER/NAME11 - 000010011 - 0000105GROSS WAGESTHOMAS, JERRY A.JENKINS, ALLENDEDUCTION 06 0%1,175.5258.785.0003% BACKSys Date: 05/31/03 / 6:35 amApp Date: 05/31/03Page: 1User: John SmithPayroll Report Samples
14Labor Distribution ReportABC Distribution and Service Corp.LABOR DISTRIBUTION REPORTLABOR CODE:0000001WarehousepersonEMPLOYEE NUMBER/NAMEEARNINGS 0000010000001050000105000010500001100000110THOMAS, JERRY A.THOMAS, JERRY A.THOMAS, JERRY A.JENKINS, ALLENJENKINS, ALLENJENKINS, ALLENPHILLIPS, AVERYPHILLIPS, AVERYRegularOvertimeHolidayRegularHolidayVacation 5.52118.88DEPARTMENT 11 TOTAL:123.251,769.92LABOR CODE 0000001 TOTAL:123.251,769.92REPORT TOTAL:123.251,769.92 BACKSys Date: 05/31/03 / 6:39 amApp Date: 05/31/03Page: 1User: John SmithPayroll Report Samples
15Employer's Expense SummaryEmployer's Tax BACKPayroll Report Samples
16Employer's Expense SummaryWorkers' Compensation BACKPayroll Report Samples
17Employer's Expense SummaryDeposit Liability BACKPayroll Report Samples
18Pre-Check RegisterABC Distribution and Service Corp.PRE-CHECK REGISTERCHECKNUMBERCHECKDATEEMPLOYEENUMBER # NAME11 - 000010011 - 000010511 - 0000110CHECKAMOUNT1 THOMAS, JERRY A.304.961 JENKINS, ALLEN292.511 PHILLIPS, 736.858.6234.57.0060.00TOTAL - ,769.92155.00106.0924.8198.68.00388.78REPORT TOTAL - ,769.92155.00106.0924.8198.68.00388.78 BACKSys Date: 05/31/03 / 6:43 amApp Date: 05/31/03Page: 1User: John SmithPayroll Report Samples
19Check and StubEMPLOYEESOCIAL SEC. NO.11-0000105 JENKINS, AEARNINGSPAY .918,074.57RegularOvertimeHolidayBonusGROSS EARNINGS:NET EARNINGS:ABC Distribution and Service Corp.2543 Langston StreetSuite 124Irvine, CA 92618 -1234(714) 555-1234PERIOD END13.850 HWDEDUCTIONFederal W/HFICAMedicareWI State W/HHealth InsurCredit Union401k PlanTOTAL DEDUCT:T H IR D N A T ION AL B AN K O F N OW H ER 2No.P. O. B ox 1213*THREE HUNDRED NINETEEN AND 91 / 100DATEBACK000002AMOUNT000002 CHECK NO.5/31/03P ay to theorde r ofALLEN JENKINS23155 W 15THMILWAUKEE, WI5/31/03AMOUNT*******319.91*53151A U T H OR IZE D S IG N A TU R EA000002C 1250000 247123-456789Payroll Report Samples
20Direct Deposit Stub BACKPayroll Report Samples
21Check Register BACKPayroll Report Samples
22Direct Deposit Register BACKPayroll Report Samples
23Daily Transaction Register BACKPayroll Report Samples
24Employee ListingDetailed ListingABC Distribution and Service Corp.EMPLOYEE LISTINGALL EMPLOYEE TYPESEMPLOYEE NO: 11-0000100THOMAS, JERRY A.ADDRESS: 4121 W. 35th StreetApartment 201CITY: MILWAUKEESTATE: WIZIP CODE:PHONE NO:SOC SEC NO:BIRTH DATE:HIRE DATE:TERM/INACT:REVIEW DATE: BACK531 - 2399FEDERALCAWIWORKCOM01020405070910NAME:Judy Thomas0000001WarehousepersonWIWHEXEMPT?: NA1-5 Years of 01/15/09TAXCODEFLSTATSTD HRS:PAY RATE 1:PAY RATE 2:SUI STATE:EIC CODE: MEXEMPTIONSDEPPERMMMHRS ACCRUED80.0040.00.00VACATIONSICKPersonal53151( 414 ) 884 - 5621986 - 53 - 123912/25/7601/15/09EMERGENCY NO: ( 414 )LABOR CODE:PRIM STATE:PAY CYCLE:PAY METHOD:BENEFIT CODE:SORT FIELD: THOMASMARITAL STATUS: SSEX: MSTATUTORY EMPLOYEE: NRACE CODE: CPENS/PROF SHR: YDIRECT DEP: YTransfer From Central Warehse3.0003.0003.000HRS L RSQTDYTDRegularOvertimeHolidayTips ReportedSick PayBonusVacation ealth InsurCredit Union401k PlanSSPAAPYYYSys Date: 05/31/2010 / 1:12 pmApp Date: 0.00Page: 1User: jwsmithPayroll Report Samples
25Employee ListingSummary ListingABC Distribution and Service Corp.EMPLOYEE LISTINGALL EMPLOYEE TYPESEMPLOYEE NO: 11-0000100THOMAS, JERRY A.ADDRESS: 4121 W. 35th StreetApartment 201CITY: MILWAUKEESTATE: WIZIP CODE:PHONE NO:SOC SEC NO:BIRTH DATE:HIRE DATE:TERM/INACT:REVIEW DATE: BACK531 - 2399FEDERALCAWIWORKCOM01020405070910NAME:Judy Thomas0000001WarehousepersonWIWHEXEMPT?: NA1-5 Years of 01/15/09TAXCODEFLSTATSTD HRS:PAY RATE 1:PAY RATE 2:SUI STATE:EIC CODE: MEXEMPTIONSDEPPERMMMHRS ACCRUED80.0040.00.00VACATIONSICKPersonal53151( 414 ) 884 - 5621986 - 53 - 123912/25/7601/15/09EMERGENCY NO: ( 414 )LABOR CODE:PRIM STATE:PAY CYCLE:PAY METHOD:BENEFIT CODE:SORT FIELD: THOMASMARITAL STATUS: SSEX: MSTATUTORY EMPLOYEE: NRACE CODE: CPENS/PROF SHR: YDIRECT DEP: YTransfer From Central Warehse3.0003.0003.000HRS L RSQTDYTDRegularOvertimeHolidayTips ReportedSick PayBonusVacation ealth InsurCredit Union401k PlanSSPAAPYYYSys Date: 05/31/2010 / 1:12 pmApp Date: 0.00Page: 1User: jwsmithPayroll Report Samples
26Employee Mailing Labels BACKPayroll Report Samples
27Employee MemoABC Distribution and Service Corp.EMPLOYEE MEMO PRINTINGDETAIL OPTIONEMPLOYEE:11 - 0000100MEMO: M-01THOMAS ,JERRY A.CHANGES TO /15/03Jerry has requested that the amount he is contributing to the savings plan beincreased by 25.00, effective 7/01.Also, he and his wife are expecting the arrival of their second child withintwo weeks time. Let's please increase his number of dependents right away.EMPLOYEE:11 - 0000105MEMO: M-02JENKINS ,ALLENANNUAL REVIEWAllen's annual review will be conducted by the department manager as well ashis immediate supervisor. This is due to his recent transfer from Chicago.His review should be completed no later than 10/31/03. BACKSys Date: 05/31/03 / 7:11 amApp Date: 05/31/03Page: 1User: John SmithPayroll Report Samples
28Quarterly Tax ReportFederal TaxesABC Distribution and Service Corp.QUARTERLY TAX REPORTFEDERAL TAXESDEPARTMENT NO: 44EMPLOYEEDAYS WKS44 - 0000450QTD:50YTD:7044 - 0000460QTD:50YTD:7044 - 0000470QTD:51YTD:7144 - 0000480QTD:45YTD:6544 - 0000490QTD:45YTD:65OFFICE - CLERICALGROSSWAGESLAWTON, LEWIS105,356.58147,687.36SEIFERT, CHARLES104,607.41146,588.58WILMINGTON, KEITH104,540.85146,463.74BROWN, WAYNE95,588.99138,269.38MAYTON, MARY96,275.96139,189.41DEPARTMENT 44 TOTALS:QTD: 241 4826,369.79YTD: 341 6838,198.47TAX RATES:TAX TOTALS QTD:YTD:TOTAL EMPLOYEES: 5FEDERAL TOTALS:QTD: 241 4826,369.79YTD: 341 6838,198.47TAX RATES: TAX TOTALS QTD:YTD:TOTAL EMPLOYEES: 5EMPLOYEE TAXABLE WAGESW/HFICAMEDICARE[94,200 ] [0][SSNO: 911 - 23 - 36SSNO: 112 - 34 - 58SSNO: 123 - 49 - 74SSNO: 234 - 98 - 38SSNO: 349 - 87 - 932,368.31ACTIVE EMPLOYEES: 32,368.31ACTIVE EMPLOYEES: 526,369.7938,198.471.450%EMPLOYER TAXABLE WAGESFICAMEDICAREFUTA94,200 ][0][7,000 ]TAXES WITHHELDFICAMEDICARE 36553.882,368.31553.88TERMINATED EMPLOYEES: 553.882,368.31553.88TERMINATED EMPLOYEES: 0177.79272.42INACTIVE EMPLOYEES: .42INACTIVE EMPLOYEES: 0 BACKSystem Date: 05/31/10 / 8:53 amApplication Date: 05/31/10Page: 1User: John SmithPayroll Report Samples
29Quarterly Tax ReportFederal Taxes - Tip Earnings & EICABC Distribution and Service Corp.QUARTERLY TAX REPORTFEDERAL TAXES - TIP EARNINGS & EICDEPARTMENT NO: 44EMPLOYEEDAYS WKS44 - 0000450QTD:50YTD:7044 - 0000460QTD:50YTD:7044 - 0000470QTD:51YTD:7144 - 0000480QTD:45YTD:6544 - 0000490QTD:45YTD:65OFFICE - CLERICALGROSSWAGESTIPSREPORTEDLAWTON, LEWIS105,356.58147,687.36SEIFERT, CHARLES104,607.41146,588.58WILMINGTON, KEITH104,540.85146,463.74BROWN, WAYNE95,588.99138,269.38MAYTON, 5123.9569.0069.00276.00276.00TIPS DEEMEDTO BE SNO:.00.00Y-T-D TIPSALLOCATEDEARNED INCOMECREDITFEDERALTAXES WITHHELDFICAMEDICARE911 - 23 - 4987.00112 - 34 - 9876.00123 - 49 - 8764.00234 - 98 - 764329.00349 - 87 - 6431.00DEPARTMENT 44 TOTALS:QTD:2414826,369.79YTD:3416838,198.47TOTAL EMPLOYEES: 5738.25.00738.25.00ACTIVE EMPLOYEES: 529.00TERMINATED EMPLOYEES: 0FEDERAL TOTALS:QTD:2414826,369.79YTD:3416838,198.47TOTAL EMPLOYEES: 5738.25.00738.25.00ACTIVE EMPLOYEES: 529.00TERMINATED EMPLOYEES: 69.6191.01133.25.00.004,599.476,917.41INACTIVE EMPLOYEES: 1INACTIVE EMPLOYEES: 01,550.161,970.12382.37553.88 BACKSystem Date: 05/31/10 / 8:53 amApplication Date: 05/31/10Page: 2User: John SmithPayroll Report Samples
30Quarterly Tax ReportFederal Taxes with FICA Tip DataABC Distribution and Service Corp.ABC Distribution and Service Corp.QUARTERLY TAX REPORTPAYROLL CHECK HISTORY REPORTDEPARTMENT NO: 44FEDERAL TAXESDETAIL FOR 04/01/10 THRU 06/30/10SORTED BY EMPLOYEE NUMBEROFFICE - CLERICALDEPARTMENT NO: 23 WEST - DRIVERSEMPLOYEEDAYS WKSGROSSWAGESEMPLOYEE/REGDATE LAWTON,CHK NO LEWISHOURS44CHK- 0000450QTD:50YTD:7023-000038044 - 000046004/07/10QTD:5004/14/10YTD:704404/21/10- 0000470QTD:04/28/1051YTD:05/05/107144 - 000048005/08/1045QTD:05/12/1065YTD:4405/15/10- TON,SHERWINSEIFERT, CHARLES0014710.00104,607.41001514146,588.58 0.000015550.00WILMINGTON, KEITH10001598 4,540.85 0.0014001654 6,463.74 0.00BROWN, WAYNE00403140.0095,588.99001699 8,269.38 0.0013MAYTON, 80 TOTAL:120.00DEPARTMENT44 TOTALS:QTD:24126,369.794823-0000390 FRASIER,WALTERYTD:34104/07/10001472 38,198.47 0.006804/14/10 .47738.256.200% 943.66 06.200%TAX TOTALSQTD: ANTHONY1,589.1623-0000400JAMIESON,SSN: 0TOTAL EMPLOYEES: 5ACTIVE EMPLOYEES: 6/30/10000011150.0010.003,093.75EMPLOYER TAXABLE WAGESFICA 2.88 6,414.2842.8842.88 4,416.9042.88 6,339.7945.88 5,519.9942.88 8,200.3845.0445.04 00 ][94,200 9.4145.77382.361,589.1645.77 179.15 553.88 43.46 2,322.53TERMINATED EMPLOYEES: 17.0226,369.799.89 9.89 45.7751.60382.369.89 45.7751.60553.88INACTIVE EMPLOYEES: 010.5911.509.8951.6010.39 5.26240.0022,223.64738.2537,460.22387.98 HEROTHER[7,000 ]TAXES 1 6.200%118.4442.3145.77 118.44 382.36 42.31 1,589.1645.77 118.44 553.88 42.31 2,322.53TERMINATED EMPLOYEES: 067.1045.26118.4442.3182.9626,369.79 44.43738.25 18.4438,198.47738.256.200% 118.44 1.450%68 0.0026,369.79SSN: 30.0004/21/100015560.000.00730.00TAX 2,322.5305/05/100016550.000.00730.00TOTAL EMPLOYEES: 5EMPLOYEES: 505/08/1000403240.00 L 00000390TAXTOTAL:RATES: EMPLOYEE TAXABLE WAGESFICAFICA TIPSMEDICAREGROSSFEDERAL94,200 ][94,200 ][0]WAGESSSNO:911 - 23 - 16-75-4891SSNO: 112 - 34 - 0.00740.006,588.586,414.28174.30 133.36 6,588.580.00740.00SSNO:123 - 49 - 8764 133.364,540.854,416.90123.95 133.36 4,540.850.00740.006,463.746,339.79123.95 133.36 6,463.740.00740.00SSNO: 234 - 98 - 76430.00740.0084.46 00.3869.00 133.36 8,269.38SSNO:349 - 87 - 6431 101.830.00740.006,275.965,999.96276.00 101.83 HO/T[HOURS5,356.587,687.36SSN:382.3610.17 45.7757.35553.88INACTIVE EMPLOYEES: .750.006.7527.840000400 638.34240.005,271.42DEPT 23 RT TOTAL:382.371,931.966,917.41MEDICARE XES WITHHELDFICAFICA TIPSCHECKAMOUN
Payroll module. Samples of the following reports are included. ACA Applicable Large Employee Report Employee Details Totals Earnings Code Listing † Deduction Code Listing † Tax Table Listing Federal Listing State Listing † Payroll Data Entry Audit Report † Earnings Register † Benefits Register † Deduction Register
