Reports to use for year-end processing in Sage 100

Reports to use to provide data for year-end forms for Payroll and Accounts Payable tax reporting (Aatrix)? Reports to run before closing the year in General Ledger?

Reports to use for Payroll:

• Payroll tax reports

  • Employers Expense Summary -
    • Employer's Taxes and Workers Compensation reports itemize department totals.
      • 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. 
    • Refer to the article: What information is on the Employers Expense Summary in Payroll? 
    • TIP:

      Print this report during EACH payroll run BEFORE YOU UPDATE the Payroll check Register.  After you update the register, the system removes the information.

       

       
  • Quarterly Tax Report
    • A summary of each employee's wage and tax information for the current quarter and year.
      • Prints for each tax jurisdiction.
    • Use this report to reconcile any federal or state tax forms before submitting.
    • Refer to the article: How to print the Quarterly Tax Report for federal, state or local taxes?
  • Deduction Reports
    • ONLY available during the Check Register update with the correct setup.
      • Select the Retain Perpetual History checkbox in Payroll Options.
    • 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.
      • Includes check date and number, hours worked, earnings per check and totals by employee number.
    • Refer to the article: What information is in the Payroll Deduction Reports?
  • Quarterly Governmental Report
    • You can customize current quarter income, specific wages (such as unemployment wages), weeks worked, etc. 

• Affordable Care Act (ACA) Reports

  • ACA Applicable Large Employer Report
    • A Self-help tool to help determine hours worked and update the Employee Counts to the ACA Employer File.
    • The employee count calculates during the Check Register update if you chose the Payroll Option to Retain Perpetual History checkbox.
    • Refer to the article: How do I set up Sage 100 to support the Affordable Care Act (ACA) requirements?

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
  • Select to Print 1099 information for the calendar year
• Check History Report - Displays all checks paid to vendors for the year
• Refer to the article: How to reconcile 1099 vendor amounts