Calculating Excess Wages

Please see the following table for an example of how to calculate excess wages.

Employee	1st Qtr	2nd Qtr	3rd Qtr	4th Qtr	Total
John Excess Wages	$12,250.00 $0.00	$12,250.00 $0.00	$12,250.00 $0.00	$12,250.00 $0.00	$49,000.00 $0.00
Mary Excess Wages	$24,500.00 $0.00	$24,500.00 $0.00	$24,500.00 $22,800.00	$24,500.00 $24,500.00	$98,000.00 $47,300.00
Sue Excess Wages	$1,000.00 $0.00	$1,000.00 $0.00	$1,000.00 $0.00	$1,000.00 $0.00	$4,000.00 $0.00
Total Wages	$37,750.00	$37,750.00	$37,750.00	$37,750.00	$151,000.00
Excess Wages	$0.00	$0.00	$22,800.00	$24,500.00	$47,300.00
Taxable Wages	$37,750.00	$37,750.00	$14,950.00	$13,250.00	$103,700.00

* Contributions (taxes) are not paid on wages in excess of $50,700.00 for each employee.