Income Tax Withholding Assistant for Employers

Calculate Income Tax Withholding

Download this Microsoft Excel sheet to calculate your income tax withholding.

Document [xlsx]

Download: PDF | xlsx

					(For use with both 2020 and earlier Forms W-4)
Pay frequency:		Weekly				RESULT
Employee's taxable wage or salary amount this paycheck:						Amount of Federal income tax to withhold from this paycheck:	$0
Which version of Form W-4 did the employee use?		2020 or later				Withhold no federal income tax if on the Form W-4 the employee claimed to be exempt from withholding.
Please enter the W-4 information in the fields below.
Information from the employee's most recent Form W-4 if used 2020 or later version					Information from the employee's most recent Form W-4 if used a 2019 or earlier version
Step 1.	c. Filing status:	Single			3	Filing status:	Single
Step 2.	Did the employee check the box in (c)?	No			5	Number of withholding allowances:
Step 3.	Total amount on line 3				6	Additional amount to withhold:
Step 4.	Other adjustments
	a. Other income amount:
					This Assistant implements the 2020 IRS Publication 15-T, Federal Income Tax Withholding Methods. Enter the three items requested in the upper left corner, then fill in the relevant information from the employee's Form W-4. The amount of Federal income tax to withhold from this paycheck is provided in the upper right corner. You may save a separate copy of this calculator for each employee (to avoid having to re-enter the W-4 information each pay period).
	b. Deductions amount:
	c. Extra withholding amount:

File Type

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet