Sage 100 ERP Payroll Users Are you ready for PAYROLL Year-End?

All you Sage 100 ERP Payroll users out there – this is the blog to take heed too! Here are some pointers on making sure you are ready for Payroll year-end….

The 2012 Q4 IRD will be available the week of 12/17, so keep your eyes peeled for it on the Sage 100 ERP updates page in the customer portal. Give us a call if you need assistance finding that page. The IRD (Interim Release Download) will include any year end program changes for Payroll, Accounts Payable, and Electronic Reporting modules. This update is also vital for program changes for eFiling and Reporting.

Anyone who is using the Accounts Payable module and creating 1099s needs this update! There are AP 1099 form changes that will be updated in the 2012 IRD, so the IRD is not just for the Payroll users.

The 2012 Q4 Tax Table update is available on the Sage Customer Portal for anyone who still needs that for processing their last payrolls of the year.

Remember that year end processing should be done after your 12/31 checks have been entered and updated. You do not want to go through your Period End Processing for payroll until all of your Payroll transactions have been updated.

Important steps to follow:

• Make sure that you have the correct tax tables
  • Before processing your first payroll for 2013, be sure that you have the 2013 Q1 Tax Table installed (this is not part of the 2012 Q4 IRD)
  • Backup Payroll Files
  • Make sure Payroll system date is set to last day of the calendar year
  • Verify that all checks issued using the current payroll check date have been updated
  • Print Quarterly Government Report
  • Print Quarterly 941 forms
  • Print W2 forms
  • Utilize the Federal efiling tools in Sage 100 (give us a call for more info on how to take advantage of the efile stuff)

• Run Period End Processing and select Year End Processing
• Choose the reports you want to run, ASI and Sage recommend the following
  • Quarterly Tax Report
  • Payroll Check History Report
  • Quarterly Pay Period Recap
  • Earnings Report
  • Deduction Report
  • Benefit Accrual Report
  • Worker’s Compensation Report
  • Reconcile all year to date totals on reports
  • Verify all checks have been entered and printed for the current quarter
  • Confirm all adjustments have been made
  • Complete Year-End processing
    • Keep in mind that if you answer “ yes” to the prompt “ Do you want to complete period end processing” clears all current year data files in preparation for the new year. Good reason to have EVERYTHING backed up, right? Good thing you read my previous blog about backing up your data files.

Good luck and happy year-end!

Jenn brings to ASI a unique background in accounting and business.  With not only technical and functional experience but project management skills as well, Jenn has fundamental knowledge of all the phases of an implementation project.  She has worked as an end user as well as a consultant, giving her the perspective to understand system “pain points” and know how to analyze and present solutions.  Her project expertise includes: Software Implementations and upgrades, Distribution / Inventory, Client Server Applications, Business Process Reviews and Optimization, as well as System Analysis and Design.  She also has experience in logistical project planning as well as technical experience with Crystal Reports and SQL. Part of Jenn’s upgrade experience also includes upgrading Sage 100 Providex clients to Sage 100 SQL.  To contact Jenn or find out more about what her team at ASI can do for your business visit ASISucceed