What reports do I need to use for year-end processing in Sage 100

Reports to use for Payroll:

• Payroll tax reports
  • Employers Expense Summary - The Employer's Taxes and Workers Compensation reports itemize department totals for gross earnings, earnings subject to and the tax for Employer FICA/Medicare/Unemployment or Workers' Compensation. The Deposit Liability report itemizes the federal, state, and local tax liabilities reported both individually and in total. See article 49990, What information is included on the Employers Expense Summary in Payroll for more detail, linked below. This report must be printed during each payroll run prior to updating the Payroll Check Register. After the register is updated the information is removed.
  • Quarterly Tax Report - A summary of each employee's wage and tax information for the current quarter and year for each tax jurisdiction. Should be used to reconcile any federal or state tax forms prior to submitting. See article 26733, How to print the Quarterly Tax Report for federal, state or local taxes, linked below.
  • Deduction Reports - These reports are ONLY available if Retain Perpetual History check box is selected in Payroll Options at time of Check Register update.
  • • Perpetual Deduction History - Detailed listing of all payroll checks showing wages, deductions and tax information.
    • Consolidated Deduction History - User-defined detail listing of deduction amounts, earnings and hours for up to eight deduction codes.
    • Pension Plan Report - Detailed listing of deductions by Employee for up to eight deduction codes per check, check date and number, hours worked, earning per check and totals by employee number.
    • See article 49698, What information is included in Payroll Deduction Reports, for additional information, linked below.
  • Quarterly Governmental Report - Current quarter income, specific wages (such as unemployment wages), weeks worked, etc can be customized to print information for reporting.
• Affordable Care Act Reports
• • ACA Applicable Large Employer - Self-help tool to help determine hours worked and update the Employee Counts to the ACA Employer File. The employee counts will only be determined if the Payroll Option to Retain Perpetual History check box was selected at time of Check Register update. See article 62495, How do I setup Sage 100 to support Affordable Care Act (ACA) requirements, linked below.

Reports to use for Accounts Payable:

• Payment History Report - Reports all payments made to vendors.
• Accounts Payable Trial Balance Report - IF you retain invoices for the full calendar year, print this report for Paid invoices and print 1099 information for the calendar year.
• Check History Report - Displays all checks paid to vendors for the year.

How to print the Quarterly Tax Report for federal, state or local taxes
ARCHIVE: What information is included in the Quarterly Governmental Report
What information is included in Payroll Deduction Reports?
How to reconcile 1099 vendor amounts
What information is included on the Employers Expense Summary in Payroll?
How do I setup Sage 100 to support Affordable Care Act (ACA) requirements