Transcription
Sage 100Payroll Report Samples
2018 The Sage Group plc or its licensors. All rights reserved. Sage, Sage logos, andSage product and service names mentioned herein are the trademarks of The SageGroup plc or its licensors. All other trademarks are the property of their respectiveowners.
Payroll Report SamplesThis document contains representative samples of the reports available in thePayroll module. Samples of the following reports are included.ACA Applicable Large Employee Reporto Employee Detailso Totals OnlyCheck and StubCheck History ReportCheck RegisterCompany Tax Group ListingDaily Transaction RegisterDeduction Code ListingDeduction RegisterDeduction ReportDirect Deposit RegisterDirect Deposit StubEarnings Code ListingEarnings RegisterEarnings ReportEmployee Audit ReportEmployee Listingo Detailedo Number and Name OnlyEmployee Mailing LabelsEmployee MemoEmployer's Expense Summaryo Deposit Liabilityo Employer's Taxeso Workers’ CompensationGeneral Ledger Posting RecapLabor Distribution ReportPay Rate Change ReportPayroll Data Entry Audit ReportPayroll Tax Update ReportPension and Cafeteria Plan RegisterPension Plan Audit ReportPension Plan History Reporto Detailedo SummaryPre-Check RegisterPre-Note Approval RegisterPre-Note Selection Register
Quarterly Pay RecapQuarterly Tax Reporto Federal Detailedo Federal Summaryo State SummaryTax Profile ListingTime Off Accrual ReportTime Off RegisterWorkers' Compensation ReportApproaching Overtime ReportAttendance WorksheetCertified Payroll WorksheetTime Track ReportEmergency Leave WorksheetEmployee Retention Credit Worksheet
ACA Applicable Large Employer ReportPeriod End Dates: 1/1/2017 to 12/31/2017ABC Distribution and Service Corp. 116DD-0000118Demotts, Lady A.Bullock, Adrienne G.Ertmann, Kayla J.Jefferson, Jane J.Dade, Richard R.Delany, Margaret M.Kendrick, Kenneth K.Lane, Laurie L.Morrison, Mel M.Henderson, Harold H.Alaia, Gale G.Johnston, Timothy R.Ortner, Owen O.Vogel, Veronica V.Driver, Daniel D.Kagel, Kelly K.Elders, Edward E.Able, Martin M.Evers, Brian 0000DecHours0000000000000000000TotalsFull Time Employee Count:Jul19Nov0Dec0FTE Employee Count:0000000001200Total Full Time & FTE Employee Count:1919191919191919191200Average Count for Full Time & FTE Employees:1519191919191919191900* FTE Full Time EquivalentTotal Employee Count:Run Date: 10/3/2017 7:02:54PMP/R Date: 10/3/201719Page: 1
ACA Applicable Large Employer ReportPeriod End Dates: 1/1/2017 to 12/31/2017ABC Distribution and Service Corp. (PR2)TotalsFull Time Employee 9Oct0Nov0Dec0FTE Employee Count:0000000001200Total Full Time & FTE Employee Count:1919191919191919191200Average Count for Full Time & FTE Employees:1519191919191919191900* FTE Full Time EquivalentTotal Employee Count:Run Date: 10/3/2017 7:04:37PMP/R Date: 10/3/201719Page: 1
ABC Distribution and Service Corp.7595 Irvine Center DriveIrvine, CA 92618(949) 555-3500PAY004668THIRD NATIONAL BANK OF NOWHERENo.P.O. Box 1213Nowhere, AZ. 56821004668*ONE THOUSAND ONE HUNDRED ONE AND 61 / 100DATEPay to theorder ofVeronica V. eDD-0000022 Vogel, VEarningsRegular HourlyOvertimeHolidayVacationSocial Security Number***-**-1132Pay Rate33.06HWPeriod End11/9/2017Check nFederal W/HSocial Security TaxMedicare TaxDental Insurance Pre-TaxHealth Insurance UH Pre-TAmount280.1197.3622.778.5060.00Gross Earnings:1,570.3555,788.75Total Deductions:468.74Net 520.0016,367.72
Check History ReportSorted by Employee NumberCheck Details for Calendar Year 2017 Quarter 4ABC Distribution and Service Corp. (PR2)Department Number:00 Department 00Employee/Check NumberPeriodEnd sSocialFederalWithholding Security 001 Demo, Lady A.00465410/13/2017 10/13/201710/13/2017 551.8598.1598.1532.1832.1810/13/2017 10/13/201710/13/2017 17 3/2017 10/13/201710/13/2017 2.9042.7842.78149.49149.4926.5526.5510/13/2017 10/13/201710/13/2017 /13/2017 10/13/2017Run Date: 10/5/2017 2:06:45PMP/R Date: .805.005.001,664.021,664.02Social Security Number: 34.9131.5531.5527.4927.490.000.0000-0000018 Henderson, Harold H.0046642,319.842,319.84Social Security Number: 554-61-112200-0000013 Morrison, Mel M.0046630.000.00Social Security Number: 368-54-112100-0000012 Lane, Laurie L.004662500.00500.00Social Security Number: 625-34-160800-0000011 Kendrick, Kenneth K.0046611,560.951,560.95Social Security Number: 398-66-123400-0000009 Delany, Margaret M.0046600.000.00Social Security Number: 554-68-112000-0000008 Dade, Richard R.004659376.19376.19Social Security Number: ***-**-245700-0000004 Jefferson, Jane J.004658CheckAmountSocial Security Number: 398-54-111100-0000003 Ertmann, Kayla J.004657OtherTaxesSocial Security Number: 423-12-111116.0016.0000-0000002 Bullock, Adrienne 81,758.68Social Security Number: e: 1
Check RegisterRegister Number:PR-000064ABC Distribution and Service Corp. (PR2)Check NumberBank EntryEmployeeNumber ng Security xesOtherDeductionsB Wells Fargo Payroll Cking11/17/2017 00-000000411/17/2017 00-000000811/17/2017 00-000000911/17/2017 00-000001111/17/2017 00-000001211/17/2017 00-000001311/17/2017 00-000001811/17/2017 00-000001911/17/2017 01-0000000D 11/17/2017 00-0000001D 11/17/2017 00-0000002D 11/17/2017 00-0000003Bank Code B Total - Manual:Printed:Run Date: 10/3/2017 8:14:47PMP/R Date: 10/3/20171Jane J. .720.00119.24Richard R. 198.83Maggie M 00151.69Kenneth K. 00.005.0084.80Mel M. 5.00277.81Harold H. .002.0035.26Timothy R. .000.001,389.571Laney A. Demotts1,560.95Direct .191Adrienne G. Bullock2,319.84Direct .001Kayla West-Ertmann2,264.87Direct 1111Laurie L. LaneGale G. Alaia090.0019,406.75Page: 1
Company Tax Group ListingABC Distribution and Service Corp. (PR2)Tax Group/Description:CA CaliforniaTax ID Number:13345671TaxG/L Account Number/DescriptionWithholding:225-03-00 State tax withheld226-00-00 SDI PayableEmployee Disability:Employee Unemployment:Employer Unemployment: 230-02-00 Accrued state unemploymentEmployer Workers' Comp: 230-03-00 Accrued workmans' comp230-04-00 Accrued Other TaxesEmployee Other:230-04-00 Accrued Other TaxesEmployer Other:TaxEffective DateCalifornia Unemployment Insurance Tax Employer Liability1/1/20173.00000California Unemployment Insurance Tax Employer Liability1/1/20162.00000Tax Group/Description:CA-SANCO-SANCT San Francisco CT, CaliforniaTax ID Number:13345671TaxG/L Account Number/DescriptionWithholding:225-04-00 Local tax withheldEmployee Other:230-04-00 Accrued Other TaxesEmployer Other:Rate230-04-00 Accrued Other TaxesTaxEffective DateRate0.00000Tax Group/Description:CO ColoradoTax ID Number:133445121TaxG/L Account Number/DescriptionWithholding:225-03-00 State tax withheldEmployee Unemployment:Employer Unemployment: 230-02-00 Accrued state unemploymentEmployer Workers' Comp:230-04-00 Accrued Other TaxesEmployee Other:230-04-00 Accrued Other TaxesEmployer Other:TaxEffective DateColorado Unemployment Insurance Tax Employer Liability1/1/20173.00000Colorado Unemployment Insurance Tax Employer Liability1/1/20162.00000Run Date: 10/6/2017 11:27:02AMP/R Date: 10/6/2017RatePage: 1
Daily Transaction RegisterABC Distribution and Service Corp. (PR2)Postings For:11/17/2017Source Journal Account NumberAccount Description/Posting CommentPR-000064Cash in bank - payrollP/R PAYROLL JOURNAL - 11/17/2017Other accrued expensesP/R PAYROLL JOURNAL - 11/17/2017FICA/Medicare taxes payableP/R PAYROLL JOURNAL - 11/17/2017Federal taxes withheldP/R PAYROLL JOURNAL - 11/17/2017State tax withheldP/R PAYROLL JOURNAL - 11/17/2017Local tax withheldP/R PAYROLL JOURNAL - 11/17/2017SDI PayableP/R PAYROLL JOURNAL - 11/17/2017Accrued Other TaxesP/R PAYROLL JOURNAL - 11/17/2017Health Insurance:Vision-VSPP/R PAYROLL JOURNAL - 11/17/2017Insurance:Met LifeP/R PAYROLL JOURNAL - 11/17/2017Health Insurance:Medical-Blue CrossP/R PAYROLL JOURNAL - 11/17/2017Health Insurance:Medical-United HthP/R PAYROLL JOURNAL - 11/17/2017401k:401k-Plan 1P/R PAYROLL JOURNAL - 11/17/2017Roth 401k:Roth-Plan aP/R PAYROLL JOURNAL - 11/17/2017Roth 401k:Roth-Plan BP/R PAYROLL JOURNAL - 11/17/2017Time Off Liability:Time Off-VacationP/R BENEFIT DPT: 00 - 11/17/2017Time Off Liability:Time Off-SickP/R BENEFIT DPT: 00 - 11/17/2017Time Off Liability:Time Off-PersonalP/R BENEFIT DPT: 00 - 11/17/2017Time Off Expense:Time Off-VacationP/R BENEFIT DPT: 00 - 11/17/2017Time Off Expense:Time Off-SickP/R BENEFIT DPT: 00 - 11/17/2017Time Off Expense:Time Off-PersonalP/R BENEFIT DPT: 00 - 11/17/2017Miscellaneous expenseP/R PAYROLL JOURNAL - 11/17/2017Salaries & WagesP/R PAYROLL JOURNAL - 11/17/2017Fed PR Tax Expense-SS/MedicarP/R PAYROLL JOURNAL - 11/17/2017State PR Tax Expense-OtherP/R PAYROLL JOURNAL - 11/17/2017Insurance expenseP/R PAYROLL JOURNAL - 11/17/2017Miscellaneous expenseP/R PAYROLL JOURNAL - 00705-00-00711-00-SM712-00-OT730-00-04765-00-04Run Date: 10/3/2017 8:16:10PMG/L Date: ,301.0441,092.002,495.4510.00732.001,201.04Journal 000064 Totals:45,213.9445,213.94Source PR Totals:45,213.9445,213.9411/17/2017 Totals:45,213.9445,213.94Report Totals:45,213.9445,213.94Page: 1
Payroll Deduction Code ListingABC Distribution and Service Corp. (PR2)DeductionCodeDescriptionTypeCalculation Amount/MethodRate000001StandardEqual EarnPensionFixed AmtTips ReportedStandard W-2 Box Pay UseLimitBox 12 Rate Ded0.00ResetBalEqual to EarningsFreq1No12345000005AutoEarningsDeduction Accrual Account:Contribution Expense Account:Tax Rule:401AMT401(k) Amt Employee Pre-Tax0.0018,000.00 12 D1Yes123450.000%18,000.00 12 D1Yes12345232-96-P1 401k:401k-Plan 1Deduction Accrual Account:Contribution Expense Account:-805002 Section 401(k) EE DeductionTax Rule:401EEP401(k) Pct Employee Pre-TaxPension% of Gross232-96-P1 401k:401k-Plan 1Deduction Accrual Account:Contribution Expense Account:-805002 Section 401(k) EE DeductionTax Rule:Based on Earnings Types:401ERARegular:YesPersonal:YesOvertime: YesVacation:YesMiscellaneous:YesExcluded from Tip Calculation: YesSick:YesFringe:Yes401(k) Employer AmtDeduction Accrual Account:Emp Contr % Deduction 50.000%18,000.00 141401AMTNo123459,000.00 141401EEPNo12345765-00-04 Miscellaneous expenseContribution Expense Account: 665-01-00 Miscellaneous expenseTax Rule:401ERP401(k) Employer PctDeduction Accrual Account:Emp Contr % Deduction 50.000%765-00-04 Miscellaneous expenseContribution Expense Account: 665-01-00 Miscellaneous expenseTax Rule:CRTILLCritical Illness Ins Post-TaxDeduction Accrual Account:CafeteriaFixed Amt0.000.001No12345Fixed
Employer's Expense Summary oDeposit Liability oEmployer's Taxes oWorkers’ Compensation General Ledger Posting Recap Labor Distribution Report Pay Rate Change Report Payroll Data Entry Audit Report Payroll Tax Update Report Pension and Cafeteria Plan Register Pension Plan Audit Report Pension Plan History Report o Detailed o Summary Pre-Check Register Pre-Note Approval Register
