tax tables | Schulz Consulting

Sage 100 ERP Form 941 Alignment Problem (SOLVED!)

March 29, 2013 by Wayne Schulz

Sage have just released the updated IRS form 941 for 2013 filing. This update is available for users of Sage 100 ERP on v4.30.23 and higher. In order to install the update you’ll need to download the program patch from Sage’s customer or partner site.

Partners can download the Sage 100 ERP form 941 update patch directly from – here (login required)

Why isn’t the form 941 aligning?

In some cases customers have observed that the form is not aligning properly. The cause appears to be that the computer from which they are printing the form has the default system font set to something other than 100%.

How to print Sage 100 ERP form 941 properly aligned

Please change your computers display (DPI) settings to Smaller – 100%(default).

Go to Control Panel and click Display
Select Smaller-100%(default)
Click Apply

NOTE: This will require a reboot for changes to take affect.

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

When Should You Load The MAS90 2011 Tax Table Update?

January 6, 2011 by Wayne Schulz

Several people have asked when they should load the 2011 tax table update for MAS 90 and MAS 200 payroll.

As you may know one of the hidden gotcha’s of printing W2 forms via MAS 90 and MAS 200 payroll is the system uses the current FICA/MEDICARE maximum limits for determining how much goes into each FICA/MEDICARE box. For employees over the maximum limit at which tax is assessed MAS 90 simply supplies the current maximum rate from the FED tax table.

Update 1-11-2011: New Sage ERP MAS 90 and 200 2011 Tax Tables

At first glance since there is no limit change for the FICA/MEDICARE this year many users determined that it didn’t matter when they loaded the tables (ie – Before or after preparing quarterlies and W2 forms).

Turns out according to Jim Woodhead over at DSD Business Systems that if you load the tax tables early your 941 form will show an incorrect overpaid status due to the 941 form using the NEW rate for employee FICA (4.2% for 2011). the solution is to manually change the FICA rate back to 6.2% while printing your 941 forms.

PS – Don’t forget to change it back to 4.2% when you’re done printing.

DSD Business Systems

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

Why isn’t the form 941 aligning?

How to print Sage 100 ERP form 941 properly aligned

Contact Us