OPEN SYSTEMS FEDERAL TAX UPDATE

Effective for all payrolls paid on or after January 1, 2010, the federal tax tables need to be updated. Follow the procedure outlined below. Only perform this update AFTER you have performed your Year-End periodic maintenance in Payroll for ALL companies.

There are two EIC tables. Use the one table that matches your table some site have a 4 column table while others have a 6 column table.

The 2010 wage base limit for social security (FICA) does NOT change, it remains $106,800.

You should perform this maintenance AFTER you have done your Year-End Maintenance in payroll for all companies, and you should be in the current year when you do it. This should be done before you calculate your first check of the New Year. These changes only need to be done in one company. (Tax Tables are shared among companies.)

1. Choose File Maintenance from the Payroll Menu.

2. Choose Tax Tables from the File Maintenance Menu.

3. Enter the table ID FEDM, FEDS, FICA, EIC, one at a time. The FICA table does not change unless your minimum wage changes.

4. Enter the appropriate table data found below.

5. After making changes, press <PgDn> or <OK> to save changes to each table.

JANUARY 2010 ANNUAL TAX TABLES

FEDM

*---------------------------------- PATX -------------------------------------*

| Table ID FEDM Description Federal Income Tax: Married Table |

| Number of Cols 3 Column Length 12 Type N |

| Over --- Base + % Over |

|------------ ------------ ------------ |

| .00 .00 .00 |

| 13750.00 .00 10.00 |

| 24500.00 1075.00 15.00 |

| 75750.00 8762.50 25.00 |

| 94050.00 13337.50 27.00 |

| 124050.00 21437.50 25.00 |

| 145050.00 26687.50 28.00 |

| 217000.00 46833.50 33.00 |

| 381400.00 101085.50 35.00 |

| 99999999.99 3650.00 .00 |

| .00 .00 .00 |

| .00 .00 .00 |

| |

*- Company 1 -----------------------------------------------------------------*

FEDS

*---------------------------------- PATX -------------------------------------*

| Table ID FEDS Description Federal Income Tax: Single Table |

| Number of Cols 3 Column Length 12 Type N |

| Over --- Base + % Over |

|------------ ------------ ------------ |

| .00 .00 .00 |

| 6050.00 .00 10.00 |

| 10425.00 437.50 15.00 |

| 36050.00 4281.25 25.00 |

| 67700.00 12193.75 27.00 |

| 84450.00 16716.25 30.00 |

| 87700.00 17691.25 28.00 |

| 173900.00 41827.25 33.00 |

| 375700.00 108421.25 35.00 |

| 99999999.99 3650.00 .00 |

| .00 .00 .00 |

| .00 .00 .00 |

| |

*- Company 1 -----------------------------------------------------------------*

FICA

*---------------------------------- PATX -------------------------------------*

| Table ID FICA Description OASDI and Medicare Tables |

| Number of Cols 6 Column Length 12 Type N |

| Employee FICA Employer FICA Min. Wage DCB Limit |

|------------ ------------ ------------ ------------ ------------ ------------|

| 6.20 106800.00 6.20 106800.00 7.25 5000.00|

| 1.45 99999999.99 1.45 99999999.99 .00 .00|

| .00 .00 .00 .00 .00 .00|

| .00 .00 .00 .00 .00 .00|

| .00 .00 .00 .00 .00 .00|

| |

*- Company 1 -----------------------------------------------------------------*

NOTE: if your state minimum wage is higher than the federal minimum, then you should replace the 7.25 in the min. wage column with your state minimum.

EIC (4 column table)

*---------------------------------- PATX -------------------------------------*

| Table ID EIC Description Earned Income Credit |

| Number of Cols 4 Column Length 12 Type 3 |

|Over Single % or Amount Over Both % or Amount |

|------------ ------------ ------------ ------------ |

| .000 20.400 .000 20.400 |

| 8970.000 1830.000 4485.000 915.000 |

| 16450.000 9.588 10730.000 9.588 |

| 9999999.999 .000 9999999.999 .000 |

| .000 .000 .000 .000 |

| .000 .000 .000 .000 |

| |

*- Company 1 -----------------------------------------------------------------*

EIC (6 column table)

*---------------------------------- PATX -------------------------------------*

| Table ID EIC Description Earned Income Credit |

| Number of Cols 6 Column Length 12 Type 3 |

|Single % or Amount Married W/O % or Amount Married With % or Amount|

|------------ ------------ ------------ ------------ ------------ ------------|

| .000 20.400 .000 20.400 .000 20.400|

| 8970.000 1830.000 8970.000 1830.000 4485.000 915.000|

| 16450.000 9.588 21460.000 9.588 10730.000 9.588|

| 9999999.999 .000 9999999.999 .000 9999999.999 .000|

| .000 .000 .000 .000 .000 .000|

| .000 .000 .000 .000 .000 .000|

| .000 .000 .000 .000 .000 .000|

| |

| |

*- Company 1 -----------------------------------------------------------------*