payroll | Schulz Consulting- Part 11

2011 Sage ERP MAS 90 and MAS 200 Payroll Tax Tables Download Available

January 16, 2011 by Wayne Schulz

Sage have updated their payroll tax tables for 2011 to include the latest state tax information for Missouri as well as Puerto Rico.

You can look at what’s new in the latest Sage EPR MAS 90 or 200 payroll tax update for 2011 and consult with your tax advisor or Sage Business Partner as to whether you need to update your payroll tax tables (as well as the timing of when that should happen).

This payroll tax table update, dated 1/11/11, is available only via download and it’s only for those with a Sage Basic Maintenance plan. We strongly recommend you consult with your Sage Business Partner and Tax Professional on the application of these updates and for any required assistance with checking the tax table updates have been installed properly and taken affect.

In most cases you may want to visit the IRS site and download the latest version of their official 2011 payroll tax table guide (Publication 15 aka IRS Circular E) which is useful for verifying that your computerized payroll tax calculations match against the IRS guidelines for 2011 payroll tax withholding.

Sage ERP MAS 90 and 200 Tax Tables – 2011

IRS Payroll Tax Tables – Publication 15 (Circular E) for 2011

January 16, 2011 by Wayne Schulz

IRS Circular E Publication 15 Tax Table Guide 2011.jpg

We recommend that the IRS tax tables for 2011 be used on your first payroll run of the new year to manually verify that the tax tables you’ve uploaded to your computer system match with the official tables issued by the IRS.

Small discrepancies of a few centers are typical. If you’re seeing discrepancies of several dollars then you should check to be sure you have the proper Sage ERP MAS 90 or 200 tax tables installed .

We recommend that even after installing the Sage ERP MAS 90 or 200 tax table updates that you also go into the Circular E for 2011 and manually compute several (or all) tax withholdings for each of your employees.

Issues around incorrect tax tables are significantly easier to correct during the first payroll of the new year than if they’re discovered at year end and retroactive fixes need to be made.

When in doubt – be sure you consult with your tax progressional about proper tax treatment of both employee wages and any deductions which you are creating or continuing to use. The tax law changes frequently and it’s better to set these deductions up properly from the start than to notify employees midway through the 2011 tax year that there’s a change to their payroll withholding.

You can download the IRS tax tables from the IRS Site — http://www.irs.gov. Always check to be sure you are using the most current rates and that pending changes are included in any guides that you are using for reference. Pay attention to effective dates since some late changes may allow for adoption during the current year so long as you make adjustments. Consult your tax professional for advise on tax matters.

IRS Circular E – Publication 11 – 2011

Sage ERP MAS 90 and MAS 200 Tax Table Download For 2011 – Available New

December 22, 2010 by Wayne Schulz

Sage have just released round one of their tax table updates for 2011. Due to late breaking tax changes you may need to download additional table updates if your local (or federal) government provides additional data on rates or changes after these tables have been downloaded.

UPDATE January 1, 2013: Click here for information on the latest Sage 100 ERP 2013 payroll tax updates

Here’s what the latest tables include (all information is per Sage’s online knowledgebase and subject to change – always verify rates and rules with your tax advisor or your states tax site. Schulz Consulting is NOT in the business of rendering tax or accounting advise and disclaims all results from use of the information below. THE INFORMATION CAN CHANGE FREQUENTLY – ALWAYS VERIFY THAT YOU HAVE THE LATEST CORRECT DATA).

Changes include:

Federal Withholding tables updated as of 12/23/2010 (Tip: Always check the first payroll run manually)
Federal Dependent Exemption – $ 3,700
Federal Non-Resident Alien Wage adjustment increase – $2,100
Federal EMPLOYEE FICA rate decrease to 4.2%
Federal EIC Advance payment of earned income credit (EIC) expries 12/31/10

STATES

Hawaii – Dependent exemption increase to $1,144
Maryland – Withholding tax tables changed per rules
Maine – Revised: Nonresident alien wage adjustment for married decreases – $5,800
North Dakota – Withholding tax tables changed per rules
North Dakota – Dependent exemption increase
Oklahoma – Withholding tax tables changed per rules

Changes Implemented 12/17/2010:

Alaska – Unemployment insurance wage base increase to $34,600
Alaska – Employee UI tax rate increase to .58%
Arizona – New filing status G – .8%
California – Withholding tax tables updated as of 12/17/2010
California – Standard deduction increase – $7,340 and $3,670
California – Personal exemption increase- 108.90
California – Low income exemption increase – 24,364 and 12,182
California SDI rate increase (taxable wage base remains $93,316 and 1.2%
Hawaii Temporary disability insurance wage base decrease Annual – 45,983.08 – Week – 884.29
Hawaii UI wage base decrease 34,200
Iowa UI wage base increase 24,700
Illinois UI wage base increase 12,740
Indiana UI wage base increase 9,500
Kentucky Standard exemption increase 2,240
Maine Withholding tax tables
Maine Filing Statuses added for Nonresident Alien – Single (NRS) and Nonresident Alien – Married (NRM)
Michigan Dependent exemption increase 3,700
Minnesota Withholding tax tables
Minnesota Withholding allowance increase 3,700
Mississippi UI wage base increase 14,000
Montana UI wage base increase 26,300
North Dakota UI wage base increase 25,500
New Hampshire UI wage base increase 12,000
New Jersey UI wage base decrease 29,600
New Jersey Temporary Disability Insurance (TDI) wage decrease 29,600
New Jersey Family Leave Insurance (FLI) wage base decrease 29,600
New Jersey Family Leave Insurance (FLI) contribution rate decrease .06%
New Mexico UI wage base increase 21,900
Nevada UI wage base decrease 26,600
Oklahoma UI wage base increase 18,600
Oregon Withholding tax tables
Oregon Filling Statuses added for wages over $50,000:
M1 Married
S2 Single with less than 3 allowances
S3 Single with 3 or more allowances

Oregon Dependent exemption increase 179
Oregon Standard deduction increase Married 3,960
Single 1,980
Oregon UI wage base increase 32,300
Rhode Island Withholding tax tables
Rhode Island Dependent exemption decrease 1,000
Rhode Island Supplemental rate decrease 5.99%
Rhode Island Temporary Disability Insurance (TDI) wage base increase 58,400
Rhode Island TDI rate increase 1.3%
South Carolina UI wage base increase 10,000
South Dakota UI wage base increase 11,000
Utah UI wage base increase 28,600
Vermont UI wage base increase 13,000
Washington UI wage base increase 37,300
Wisconsin UI wage base increase 13,000
Wyoming UI wage base decrease 22,300

LINKS:

Current list from Sage of all payroll tax table changes

Instructions on downloading the tax tables for MAS 90 and MAS 200 (These updates may be used for Library Master versions 4.x and 3.72, 3.73 and 3.74).

Sage Common Payroll Announced For MAS200 SQL, MAS500, ABRA, ERP X3 and ACCPAC

October 22, 2010 by Wayne Schulz

Sage today made official that they’ll be rolling out a common payroll based on their SData communication protocol. This common payroll fills a hole in the Sage MAS 200 SQL release (due November 2010) where legacy (non 4.x standard modules which include payroll) cannot be used with the MAS 200 SQL release.

By creating a common payroll solution Sage hopes to cut down development costs that are soaring as the government continues to change employer tax laws. Each change in tax law requires Sage to update payroll (usually at the very end of the year when everyone is busiest), test the changes, and quickly distribute those upgrades to end users.

Under the Sage Common Payroll initiative the ACCPAC SQL Payroll will be used by at least four Sage products (ABRA SQL v10.1, MAS500 v7.3, ERP X3 v6.1, MAS200 SQL 4.45).

Integration levels will vary depending upon product with only Accpac and ABRA receiving level 3 or very robust integration.

Here’s Sage’s Official Announcement:

Common Payroll is the Sage ERP Accpac payroll module which has been enhanced to become a best-of-breed SQL Server-based payroll that can serve the needs of many of our Sage North America customers. With over 4000 payroll customers in the US and Canada, the Sage ERP Accpac payroll module has a strong track record of providing value to small and medium sized businesses.

Using Sage ERP Accpac payroll as the foundation and the new common sData communication protocol to facilitate connectivity, the new Common Payroll module will offer the tightest level of integration possible between payroll and all of our ERP solutions.

How will a Common Payroll support Sage’s strategy to maximize our assets and reduce redundancies? One example lies in the hundreds of new tax changes that are mandated each year. In 2009 there were more than 200 changes released and that number is expected to increase in 2010. To keep on top of these changes, Sage spends a great deal of money each year to maintain our 12 unique payroll modules, and in some cases, multiple versions for each product. Imagine how much we could accomplish by removing this redundancy of effort, provide the updates in a form that could be used by all our products, and instead leverage our resources to provide customers with greater value, such as new connected services. And because the payroll-related connected services such employee benefit services would only need to be developed once, it would mean they could be made available immediately to all our customers with little to no incremental effort required by individual product teams.

The Common Payroll initiative also supports our goal for providing an Extraordinary Customer Experience as we focus our efforts on developing a single best-of-breed solution that surpasses the functionality and ease of use found in our current payroll modules. This new, unified payroll module will not only scale as a business grows, but if a customer needs to upgrade to another Sage ERP (enterprise resource planning) product, the payroll data will seamlessly migrate.

Common Payroll integration will soon be on the roadmaps for many of our other products, so stay tuned for details. You can rest assured that the native payroll module will continue to be enhanced, sold and supported for those products where it doesn’t make sense to adopt a common payroll.

The Common Payroll integration is an important step toward achieving our objectives and providing your clients with greater value. Projects like Common Payroll not only generate substantial savings and leverage best practices, but enable us to deliver a common experience to our mutual clients.

MAS90 Payroll 941 Form Updated For Q1 2010 Changes

March 23, 2010 by Wayne Schulz

MAS 90 users can download the latest form 941 for use with Sage MAS 90 version 4.30.

New to this version:

Quarterly 941 Printing has been updated for the 2010 IRS changes to the 941 Form. The changes are only applicable to the Report Format ‘Entire Form’ and ‘Worksheet’ since the changes are in the text of the 941 Form.

Also the year has changed on the ‘Entire Form’.

The IRS has not made any changes to the Schedule B for 2010.

NOTE: The “Pre-printed Form” format has been designed based on the downloaded 941.pdf from the IRS website. If you use the “Pre-printed Form” format the alignment may need to be adjusted or the form may need to be modified.

To obtain the latest payroll form – log into your Sage online account (free to all users active under a Sage maintenance agreement) and download the update from the link below.

Sage MAS 90 updated Form 941 (3/2010)

Contact Us