What information is included on the Employers Expense Summary in Payroll?
Description

The Employer's Taxes section:

The Deposit Liability section:

Cause
Resolution

Important Note: This report can only be printed while Payroll Data Entry is in progress, it is NOT available to print after payroll checks have been updated. You must print the Employer's Expense Summary before updating the Payroll Check Register; this information is cleared when the payroll check register is updated.

  1. After entering all payroll data entries and running Payroll Tax Calculation
  2. Open Payroll, Main, Employers Expense Summary
  3. Print report to know how much your tax deposit amounts should be and to assist in reconciling your quarterly tax reports/forms
    • TIP: See related article below, How to setup Paperless Office

Use Employer's Expense Summary to print the Employer's Taxes, Workers' Compensation, and Deposit Liability reports. This report will help you reconcile the liability amounts on Form 941 Schedule B, Form 940, and applicable State and Local tax reports. This report will also assist in reconciling some of the amounts on your Payroll Daily Transaction Register (payroll journal entry that updates to the G/L)

The Employer's Taxes and Workers' Compensation reports itemize department totals for gross earnings, earnings subject to Employer FICA /Medicare/Unemployment or Workers' Compensation, and the amount of Employer FICA/Medicare/Unemployment/Workers' Compensation taxes accrued for this payroll period. **See screen shot below for example

Note: Accrual amounts will post to the G/L account selected in Company Tax Group Setup. Expense amounts will postp to the G/L account selected in Department Maintenance. If the unemployment tax amounts are not correct, verify the unemployment tax rates and effective dates are correct on the Tax Rates tab in Company Tax Group Setup.

The Deposit Liability report itemizes the federal, state, and local tax liabilities reported both individually and in total; the net check amount total; cash required for the current Payroll period; Employee and Employer FICA/Medicare withheld; Employee Additional Medicare withheld and the total of all FUTA, state tax liabilities and total tax liabilities.

Note:

  • For employers reporting tip wages, Social Security (FICA) tip wages and Social Security (FICA) tip tax will print separately on the Employer's Taxes page of the summary.

  • For Massachusetts employees, the Employer Medical Assistance Contribution (MAC) is included with the unemployment tax.

For more informaiton on reconciling your quarterly and annual payroll tax forms/reports, please see Related Article below

DocLink: How to print the 941 and Schedule B forms in Sage 100
DocLink: How to Setup Paperless Office to save/print your Period/Year-End Reports in Sage 100
DocLink: How do I reconcile Payroll tax forms & reports?
Defect ID
Steps to duplicate
Related Articles