payroll | Schulz Consulting

How’s The Accuracy Of The New MAS90 – MAS200 CT Payroll Tax Tables?

August 2, 2011 by Wayne Schulz

I have completed about half a dozen MAS90 payroll upgrades for clients with Connecticut employees.

So far I’ve received feedback that the computations need to be manually reviewed and in some cases adjusted (be sure to read the instruction sheet that I left because Sage indicates that with the update you may not longer simply add an additional amount to CT withholding but instead should force the ENTIRE computed CT withholding).

If you need this, here is a link to the tax table update as well as the important instructions on configuring CT tax withholding.

http://infosource.sagesoftwareonline.com/sw_attach/sso/mas90/90ttu.htm

Please let me know how you are finding the computation of CT tax and if you’re encountering any issues.

Connecticut Payroll Tax Table Changes for Sage ERP MAS 90 and MAS 200

June 16, 2011 by Wayne Schulz

It appears the Connecticut payroll tax TABLE changes are effective August 1, 2011 – that is the changes (including catch-up amounts) are incorporated into rate tables that Connecticut indicates should be put into place on August 1, 2011

(View Information About Connecticut Tax Table Changes for August 2011: http://goo.gl/ABI8V ) .

Sage is planning to include these changes (which seem to also require some programming updates) in the version 4.5 release of MAS90/200 – as well as free program patches for versions 4.2 to 4.4.

(Link: http://goo.gl/eiJnx )

In July we will be able to download a program update for users of MAS90/200 payroll on version 4.2, 4.3 and 4.4.

If users are presently on a version BELOW version 4.20 (which hopefully is not many people) they’ll need to plan an upgrade in order to take advantage of payroll program updates.

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).

Contact Us