How to calculate FIT with supplemental pays and tax table pays

My federal income tax calculation is off when I add in my supplemental pay code.

• Payroll
• Payroll Start and Status
• Earnings and Deductions
• Tax Tables

Supplemental pay is taxed at the supplemental rate while the other pays are taxed using the tax table.

Determine the percentage of pay that is taxed using the tax table:

1. Access Earnings and Deductions: Payroll > Payroll Processing > Payroll Start and Status > Earnings and Deductions
2. Search for the employee and click on the Earnings tab
3. Double-click the first pay code sum together all pays with a Tax Method of Tax Table
4. Take the sum of the tax table pays, take this value and divide in by the total gross pay, note the value

Determine the percentage of pay that is taxed at the supplemental rate:

1. Access Earnings and Deductions: Payroll > Payroll Processing > Payroll Start and Status > Earnings and Deductions
2. Search for the employee and click on the Earnings tab
3. Double-click the first pay code sum together all pays with a Tax Method of Supplemental Rate
4. Take the sum of the tax table pays, take this value and divide in by the total gross pay, note the value

In Earnings and Deductions click on the Withholding tab

1. Double-click on the federal income tax deduction
2. Multiply the deduction gross by both the tax table and supplemental rate values from the previous steps
3. Deduction gross * tax table value = amount of FIT gross taxed using the tax table, apply this total to the tax table record
4. Deduction gross * supplemental rate value = amount of FIT gross taxed at the supplemental rate, multiply by this rate by the supplemental rate on the employee's tax table
5. Add the two values from steps 3 and 4 to determine the final withholding amount