Year End Closing Tips for Sage 100 ERP (formerly MAS 90) – Special Newsletter

December 6, 2012 by Wayne Schulz

Our special year end newsletter for Sage 100 ERP (formerly known as MAS90 or MAS200) users is now available. In this issue we explore tips and tricks for closing every module – including the order in which they should be closed.

Are you following best practices by creating year-end archive companies? If not – we will show you how to use the built-in features that allow Sage 100 ERP to quickly create backup copies of your live data. These copies of data are especially helpful for anyone using the payroll module since you can refer back to the archived companies throughout the year as your employees request copies of W2 and other forms which they may have lost.

This issue also has information on the payroll tax updates and provides information about when and how to apply them to your system to meet new IRS and state tax guidelines.

Sage 100 ERP Year In Review – 2012 Closing Tips (PDF)

Sage ERP MAS 90 and 200 2011 Year End Frequently Asked Questions (W-2, 1099, Tax Tables, IRD)

November 7, 2011 by Wayne Schulz

Sage have just released their MAS90 and MAS200 2011 frequently asked year end questions.

This list of 24 common questions about year end processing reveals several interesting bits of information:

1099 Reporting with MAS90 and MAS200

For AP 1099 Reporting, there are no changes, so no IRD is required. If you performed 1099 reporting last year, using Sage ERP MAS 90 or Sage ERP MAS 200 you should have all the programs you need to process 1099 reporting this year. The following are the minimum versions you must be running for 1099 filings

Versions 4.40.0.1 and lower must have last year’s IRD (Interim Release Disk) installed

Is an IRD required to print 2011 W2 forms with MAS90 or MAS200?

Yes. Customers running Payroll must install the 2011 year-end IRD. The following list contains the minimum versions
required. If you are not at least on the minimum version, you must add the required product update to get to the
minimum before installing the year-end IRD.

I am running payroll on MAS90 or MAS200 4.5 – do I need to download the IRD?

No. All of the program changes included in the IRD are also included in 4.5. However, you will still need to download and install the Q1 2012 Tax Table Update before processing your first payroll for 2012.

Do I need to download the MAS90 2011 IRD if I’m using the Federal and State eFiling and Reporting feature?

Yes, if you choose to use Sage ERP MAS 90 and 200 version 4.3 or 4.4 Federal and State eFiling and Reporting, you will need to apply the IRD.

When will the year-end Sage ERP MAS 90 and 200 Federal and State eFiling and Reporting updates be available?

On December 20, 2011, you will be able to access Federal and State eFiling and Reporting within the Payroll module
to update your W-2s. Also using eFiling and Reporting, you’ll be able to update your 1099s for year-end 2012 within
the Accounts Payable module. Simply access eFiling and Reporting within Sage ERP MAS 90 and 200 after December
20, and the system will prompt you to apply the online automated update.
Throughout the year, quarterly updates for Federal and State eFiling and Reporting are generally available on the
twentieth of the last month of each quarter unless that date falls on a weekend. If it falls on a weekend, they will be
made available on the last business date before the twentieth.

When will the year-end Tax Table Update (TTU) and Interim Release Download (IRD) for Sage ERP MAS 90 and 200 be made available?

It will be available as a download from Sage Online, Sage ERP MAS support section; access it by using the upper right
corner “Log On” from www.SageMAS.com. This download will ensure that you will have the most up-to-date tax rates for
the new tax year. Since Sage must wait for states to announce tax rate changes before we can create the new tax tables,
and legislative tendency is for last-minute changes, we’ll also update as necessary through January 2012. Subsequent
quarterly TTU releases will be posted in the same location

How can I obtain the TTU or IRD if I do not own a current Sage Business Care Plan?

You must be a customer with a current Sage Business Care plan, a business partner with a current Sage Business
Partner agreement, or a Sage Accountants Network member with a current membership agreement in order to access
Sage Online, Sage ERP MAS Support. Click there by using the upper-right corner “Log On” from www.SageMAS.com
and download the TTU or IRD. If your plan or agreement has expired, please contact our Sage Business Care department
for customer renewals at 866-709-2432, Business Partner renewals at 800-854-3415, and Sage Accountants Network
enrollment at 866-565-2726.

I’ve never been to Sage ERP MAS support, and I don’t know if anyone else from my company has either. What do I do
to get a logon and access the information I need?

If you do not have a current logon to Sage ERP MAS support, go to the following URL and click on the Register Now link:
www.sagesoftwareonline.com/eServices. You’ll need your Sage account number to register. Please note that to access
the support tools of Sage ERP MAS support, you must have a current agreement or subscription plan with Sage. If you
have issues with obtaining a logon, please email us at tools.na@sage.com for assistance.

Previously, I’ve filed employees W-2s through Magnetic Media. Are there any changes

The Social Security Administration will not accept W-2 information from employers on any type of magnetic media. Instead,
it requires electronic filing of W-2 information. Sage ERP MAS 200 for SQL version 3.74 Magnetic Media module and Sage
ERP MAS 90 and 200 versions 4.2, 4.3, and 4.4 Electronic Reporting module will allow you to create an EFW2 format file for
uploading to the SSA’s website (www.ssa.gov/employer). The EFW2 file is formatted to the SSA’s Electronic Filing specifications
provided the applicable IRD has been downloaded from Sage Online and properly installed on your system. The file will be
created in directory EFW2/”company code” as file name “W2REPORT.TXT.”
Some states may still accept magnetic media filings; please check the information your state has provided to you for its
policies. If your state accepts magnetic media filings and uses the Federal EFW2 format, you can use the Electronic Reporting
module to create the media for your state filing.

Does the IRD contain changes to Payroll to support the Cost of Employer-sponsored health coverage reporting?

Yes. Although reporting this information is not mandatory for employers until filing reports for 2012, the ability to include Code
DD on Form W-2 Box 12 is included in this IRD.

Does the IRD contain changes to Payroll to support Designated Roth Contributions under Governmental Section 457

Yes. The ability to include Code EE on Form W-2 Box 12 is included in this IRD.

I am running Sage ERP MAS 90 or 200 version 4.2 or Sage ERP MAS 200 SQL v 3.74. Is there anything else I need to
know regarding Payroll support?

The Q1 2012 Tax Table Update and Year-End IRD are that last ones that will be available for versions 3.74 and 4.2. You must
upgrade to a more current version of software in order to receive future TTUs. Please see the Sage ERP MAS 90 and 200
Supported Versions listing posted on Sage Online. Log onto Sage Software Online, click the link to Sage ERP MAS 90 and 200
Support. In the Compatibility section, click the Support Versions link

Will I be required to print my W-3 on the red, preprinted form when using Federal and State eFiling and Reporting?

The Federal W-2s and W-3s are not required to be printed on the official form. We have incorporated an approved substitute
that can be printed on plain paper with an inkjet or laser printer. It should not be printed on red paper. You can identify the
approved form by looking for the numbers 0000/1048 under “year” on the W-2 form and in the For Official Use Only box on
the W-3. These forms are approved for use by the Social Security Administration and conform to the IRS Publication 1141 as
required.

MAS90 and MAS200 Year End 2011 FAQ – Payroll, Accounts Payable, W2, 1099

Sage ERP MAS 90 & MAS 200: 2010 Year End FAQ – Payroll, 1099

November 16, 2010 by Wayne Schulz

Sage Software have just published their 2010 year end frequently asked questions about payroll and 1099 processing. This 6 page guide contains answers to the following questions:

1. Do I need to download the 2010 Interim Release Download (IRD)?

2. Do I need to download the 2010 IRD if I’m using the Federal and State eFiliing and Reporting feature?

3. When will the year end Sage EPR MAS 90 and MAS 200 Federal and State eFiling and Reporting updates be available?

4. When will the year end Tax Table Update (TTU) and Interim Release Download (IRD) for Sage MAS 90 and MAS 200 be available?

5. Will I be required to print my W-3 on the red, preprinted form when using Federal and State eFiling and Reporting?

6. How will the year end Tax Table Update (TTU) and Interim Release Download (IRD) for Sage ERP MAS 90 and MAS 200 be made available to Customers, Business Partners or Sage Accountants Network members?

7. I do not have access to the Internet from my Sage ERP MAS 90 or MAS 200 server. How can I obtain the year end Interim Release Download program update and TTU to install them on my server?

8. How can I obtain the TTU or IRD if I do not own a current Subscription plan?

9. I’ve never been to Sage MAS Supprot, and I don’t know if anyone else from my company has either. What do I do to get a login and access the information I need?

10. After I downloaded the TTU and IRD, do I install it on my workstation or on my server?

11. We file Local Withholding Tax on our W-2s and we’re using Federal and State eFiling and Reporting, what extra steps do I need to take?

12. What changes were applied to the Electronic Reporting Module?

13. Previously, I’ve filed employees W-2’s via Magnetic Media. Are there any changes?

14. I’m supposed to electronically file my W-2s in the EFW2 format, so why does Sage ERP MAS 90 and MAS 200 show a MMREF-1 format?

15. For companies who must print 1099 forms, are changes required this year?

16. I was formerly required to file Form 1099’s via Magnetic Media, but now need to file 1099’s via Electronic Reporting using the Internet. What do I need to know?

17. Where can I find information on how to do year end processing for any module?

18. Where can I purchase W-2 and 1099 forms 100% compatible with my Sage ERP MAS 90 and MAS 200 software?

19. I have an Extended Solution enhancement. Will I need to update it after installing the 2010 Interim Release Download?

20. I am using Sage ERP MAS 200 SQL 4.45 and need to file 1099s. What do I need to do?

21. Does the IRD contain changes to Payroll to support the Qualified Employee Reporting as allowed by the HIRE Act?

22. What is new in eFiling and Reporting this year?

23. Will the IRD be included in a Product Update or Service Update?

Sage MAS 90 and 200 2010 Year End FAQs 11-15-10

Sage eFiling FAQ – August 2010

September 7, 2010 by Wayne Schulz

An updated list of Sage’s Frequently Asked Questions about their eFiling service.

This convenience service is included in all versions of Sage ERP MAS 90 and MAS 200 version 4.3 and higher. It enables the printing of many tax forms to plain paper and for an added fee Sage will electronically file many of your payroll tax forms.

MAS90 and MAS200 Year End FAQ – 2009

December 11, 2009 by Wayne Schulz

Sage have just posted their annual MAS 90 and MAS 200 Year End Frequently Asked Questions guide. This 6 page report outlines the date when an IRD (Interim Release Disk) will be available (12/18) as well as the day you’ll be able to go online to download next years’ tax table update (aka TTU – 12/14/09).

If you use the Payroll module you can install the Q1 2010 TTU and 2009 IRD with Sage MAS 90 or 200, versions 3.71, 4.0, 4.05, 4.10, 4.2 and 4.3, and with Sage MAS 200 for SQL versions 3.71, 3.72, 3.73 and 3.74.

One interesting note from the FAQ – The Federal W-3 is not required to be printed on the official form. Sage incorporated an approved substitute that can be printed on plain paper with an inkjet or laser printer. It should not be printed in Red. You can identify the approved form by looking for the numbers 0000/1048 under “year” on the form.

Sage MAS 90 and 200 ERP 2009 Year End FAQs

Payroll Tax Table Update, Electronic Reporting, & Accounts Payable
Revised December 7, 2009