Program Description
This program can be found on the Payroll Reports Pay Period Reports menu (PAY-4-1-2). It calculates FICA, federal, and state taxes. It also calculates the 401K deduction dollar amount. The net pay amount is then created. This program can be run a second time if there have been records added or deleted. For every addition or deletion, the report must be run again for that particular pay period to have the taxes calculated. The Employee (EMPLD) data file is not updated in this case.
Rev 15 Changes
Payroll Tax Calculations for North Dakota (PAND102B): Beginning January 1, 2002, North Dakota will use tax tables to calculate State withholding amounts. The tax table varies on the marital status of the employee and the payroll period (i.e. weekly, biweekly, semi-monthly, or monthly). State wages are calculated by multiplying the number of dependants by the withholding allowance associated with the pay period and subtracting that amount from the gross earnings. The State wage is then used to determine withholding in the tax table. Withholding allowances per pay period and tax table figures are hard-coded into the program. The State of North Dakota does not require businesses to withhold amounts that are less than $1.00. The program is set up to withhold all amounts; however, it may be customized to only withhold amounts greater than or equal to $1.00.
Payroll Tax Calculations for Ohio (PAOH102B): The Payroll State Tax Program for Ohio was changed. The city tax deduction changed from 2% to 1.5%.
Payroll Tax Calculations for California (PACA102B): The California State Tax program was changed. Beginning January 1, 2002 California State Payroll State Disability went from 7% to 9%. Also, the maximum limit per employee went from $324.49 to $463.27. These changes have been made to the program.
Rev 14 Changes
Payroll Tax Calculations for Wisconsin (PAWI102A): Changes were made to the tax calculations for Wisconsin State Tax. The annual net wages brackets were changed at the end of the year 2000. If your company has payroll in Wisconsin, you were already sent this program previously.
Rev 13 Changes
The program logic that compares YTD Deduction 10 and YTD 401K with the max Deduction 10 and max 401K was also doing it for Cafeteria. There is no max Cafeteria field, so the program was using a spare field. Program logic was added to not do this check for Cafeteria.
Payroll Tax Calculations for Illinois (PAIL102B): Changes were made to the tax calculations for Illinois State Tax changes. Allowances that are claimed on IL-W-4 Line 1 should be stored in field 19. State Dependents in the Employee File Maintenance file (EMPLD). Allowances that are claimed on IL-W-4 Line 2 should be stored in field 50. Personal Exemptions (0/1/2) in the Employee File Maintenance (EMPLD) file. Any number can be placed in this field now. The annual allowance for line 1 is $1650.00 for 1999. The annual allowance for line 2 is $1000.
The calculation for exemption (for Illinois only) is as follows:
Exemption = (Line 1 Allowance X 1650.00) + (Line 2 Allowance X 1000)
Number of Pay Periods
The calculation for state tax is as follows:
(Total Taxable Gross - Exempt) X .03
Changes were also made to the tax calculations for Colorado State Tax. If the state tax amount is less than $.50, then the amount will round down to the nearest whole dollar. If the state tax amount is greater than or equal to $.50, then the amount will round up to the nearest whole dollar. For example, if the state tax amount calculates to $25.41, it will be rounded down to $25.00. If the state tax amount calculates to $25.50, it will round up to $26.00. If the state tax amount calculates to $25.67, it will also round up to $26.00.
Results
