590 likes | 706 Views
20 th Annual IL Statewide APA Conference. August 23, 2013 Session 1. Hard Knocks of Payroll Calculations. Billy Meyerkorth , CPP Sr. Payroll Analyst bjm@americancentury.com 816-340-7109. The Chores. Regular Rate of Pay Overtime Tax Calculations Gross-up GTL Child Support
E N D
20th Annual IL Statewide APA Conference August 23, 2013 Session 1
Hard Knocks of Payroll Calculations Billy Meyerkorth, CPP Sr. Payroll Analyst bjm@americancentury.com 816-340-7109
The Chores • Regular Rate of Pay • Overtime • Tax Calculations • Gross-up • GTL • Child Support • Garnishments • Tax Levies 20th Annual IL Statewide APA Conference – August 22-23, 2013
Regular Rate of Pay • What is it? What is it used for? • Complexities surrounding it • What is included • Base, shifts, nondiscretionary bonuses, retro, etc • Hours • Workweek • Payroll Conversions • 2080 hrs FT equivalent 20th Annual IL Statewide APA Conference – August 22-23, 2013
Regular Rate of Pay • How do you calculate it? Total pay for the workweek Total hours worked 20th Annual IL Statewide APA Conference – August 22-23, 2013
Regular Rate of Pay • Employee paid $12.00 per hour • Workweek Sunday-Saturday Works Mon-Wed – 8 hrs/day, Thurs 9 hrs & Fri 10 hrs Regular Pay = 12.00*43=516.00 516.00/43 = 12.00 RRP 20th Annual IL Statewide APA Conference – August 22-23, 2013
Regular Rate of Pay • Employee paid $12.00 per hour • Workweek Sunday-Saturday Works Mon-Wed – 8 hrs/day, Thurs 9 hrs & Fri 10 hrs • Production Bonus = $500.00 for the week Regular Pay = 12.00*43=516.00 Bonus = 500.00 516.00+500.00=1016.00 1016.00/43 = 23.63 RRP 20th Annual IL Statewide APA Conference – August 22-23, 2013
Regular Rate of Pay • Employee paid $12.00 per hour • Workweek is Sunday-Saturday Works Mon-Wed – 8 hrs/day, Thurs 9 hrs & Fri 10 hrs • Piecework Pay = $1.00 each item (100 made) Regular Pay = 12.00*43=516.00 Piecework = 1.00*100=100.00 516.00+100.00=616.00 616.00/43 = 14.33 RRP 20th Annual IL Statewide APA Conference – August 22-23, 2013
Overtime Premium • Employee paid $12.00 per hour • Workweek Sunday-Saturday Works Mon-Wed – 8 hrs/day, Thurs 9 hrs & Fri 10 hrs Regular Pay = 12.00*43=516.00 516.00/43 = 12.00 RRP 12.00*0.5=6.00 Overtime Premium Rate 3 hrs *6.00=18.00 Overtime Premium Pay 20th Annual IL Statewide APA Conference – August 22-23, 2013
Overtime Premium • Employee paid $12.00 per hour • Workweek Sunday-Saturday Works Mon-Wed – 8 hrs/day, Thurs 9 hrs & Fri 10 hrs • Production Bonus = $500.00 for the week Regular Pay = 12.00*43=516.00 Bonus = 500.00 516.00+500.00=1016.00 1016.00/43 = 23.63 RRP 23.63*0.5=11.82 OT Premium Rate 11.82*3=35.46 OT Premium Pay 20th Annual IL Statewide APA Conference – August 22-23, 2013
Gross Pay • Employee paid $12.00 per hour • Workweek Sunday-Saturday Works Mon-Wed – 8 hrs/day, Thurs 9 hrs & Fri 10 hrs Regular Pay = 12.00*43=516.00 516.00/43 = 12.00 RRP 12.00*0.5 = 6.00 OT Premium Rate 6.00*3 = 18.00 OT Premium Pay 516.00+18.00=534.00 Gross Pay 20th Annual IL Statewide APA Conference – August 22-23, 2013
Gross Pay • Employee paid $12.00 per hour • Workweek is Sunday-Saturday Works Mon-Wed – 8 hrs/day, Thurs 9 hrs & Fri 10 hrs • Production Bonus = $500.00 for the week Regular Pay = 12.00*43=516.00 Bonus = 500.00 516.00+500.00=1016.00 1016.00/43 = 23.63 RRP 23.63*0.5 = 11.82 OT Premium Rate 11.82*3 = 35.46 OT Premium Pay 1016.00+35.46 = 1051.46 Gross Pay 20th Annual IL Statewide APA Conference – August 22-23, 2013
Regular RateOvertimeGross Pay • Other Sample Calculations • Review 20th Annual IL Statewide APA Conference – August 22-23, 2013
Wage-Bracket Method • The quickest &easiest method • Publication 15 - Circular E • Generally, use the percentage method for wages in excess of table
Marital Status Pay Frequency Number of Allowances Wages
Percentage Method • The formula method • Most payroll systems use this • Publication 15 - Circular E • Little more work than wage-bracket method 20th Annual IL Statewide APA Conference – August 22-23, 2013
Percentage Method • Based on Form W-4 information • Steps: • 1 – calculate taxable pay • 2 – calculate deductible value of allowances • 3 – formula to calculate tax withholding amount from Percentage Method tables 20th Annual IL Statewide APA Conference – August 22-23, 2013
Pay Period Frequency Amount per Allowance
Marital Status Pay Frequency Taxable Wages Amount of federal tax withholding
Percentage Method Step 1: Value of allowances Step 2: Gross – allowances = Adjusted wages Step 3: Use Percentage Method table
Percentage Method Step 4: Adjusted wages – threshold = excess amount Step 5: Amount of tax + (excess amount x percentage) = FITW
Supplemental Wages • Regular wages • Tied to time defined under FLSA • Supplemental wages • Not tied to time – additional taxable items • Overtime & tips may be treated as regular
Supplemental Methods • Optional Flat Rate Method • Aggregate Method • Mandatory Flat Rate Method
Supplemental Methods • Optional flat rate - 25% • Multiply supplemental wages by optional rate
Supplemental Methods • Aggregate • Combine with regular wages & tax the total • If paid separately, subtract tax already withheld from regular wages
Supplemental Methods • Aggregate method • If no income tax withheld from regular wages during current year or preceding year
Supplemental Methods • Mandatory flat rate – 39.6% • When year-to-date supplemental wages exceed $1,000,000 • May use for payments that cross the $1,000,000 threshold
Social Security & Medicare • Medicare wages > $200,000 • Additional Medicare tax of 0.9%
Tax Calculaions • Other sample tax calculations for practice
Grossing-Up Desired Net Payment 100% - Total Tax Percentage
Grossing-Up • Special circumstances • Gross-up causes year-to-date wages to cross the social security wage base
Grossing-Up • Reasons for Gross-Up • Guarantee net pay • Paying taxes for employee on certain expenses • Did not withhold social security and Medicare taxes for group-term life insurance • Failed to withhold taxes from wages
Gross-up • Employee receives $5,000.00 relocation (net) • YTD wages = $50,000.00 • No state income taxes • $5,000.00/(100%-(25%+6.2%+1.45%)) = $5,000.00/(100%-32.65%) = $5,000.00/0.6735 = $7,423.90 gross
Gross-up The long way • $5,000.00*.3265 = $1,632.50 • $1,632.50*.3265 = $533.01 • $533.01*.3265 = $174.03 • $174.03*.3265 = $56.82 • $56.82*.3265 = $18.55 • $18.55*.3265 = $6.06 • $6.06*.3265 = $1.98 • $1.98*.3265 = $0.65 • $0.65*.3265 = $0.21 • $0.21*.3265 = .$0.07 • $0.07*.3265 = $0.02 $1,632.50+$533.01+$174.03+$56.82+$18.55+$6.03+$198+$.65+$.21+$.07+$.02=$2,423.90 $5,000.00 + $2,423.90 = $7,423.90 grossed-up amt
Gross-up Crossing SS wage base • Determine social security tax needed for payment • Add tax % (except social security) • 100% - Total tax % = Net % • Add payment SS tax together, divide by Net % = Gross earnings • Check by calculating gross to net pay
Group Term Life • Taxability is based on: • Excess coverage amount over $50,000.00 • Based on age at end of year • Amount from Uniform Premium Coverage table • Amount EE pays with after tax dollars (if any)
GTL • Employee born Dec 6, 1946 • Value of GTL = $75,000.00 • $75,000.00 - $50,000.00 = $25,000.00 • Employee = 67 years old • GTL factor from table = $1.27 per $1,000.00 • $25,000.00/$1000.00 = 25 • 25*$1.27 = $31.75 per month
GTL • Subtract the amount employee pays with after-tax dollars • Same Example: • Employee pays $5.00 per month • $31.75 - $5.00 = $26.75 per month taxable
GTL • Dependent GTL • $2,000.00 – tax-free • Over $2,000.00 – entire amount taxed • Same calculation
Child Support • Disposable Pay Gross Pay – deductions required by law (taxes) = Disposable Pay
Child Support • Employee has following: • Regular pay $5,000.00 • FITW $500.00 • Social Security $302.56 • Medicare $70.76 • 401(k) 10% of Regular • Café health prem $100.00 • Dental $20.00
Child Support • Gross Pay – deductions required by law = disposable pay • $5000.00-$500.00(FITW)-$302.56(SS)-$70.76=$4,126.68 Disposable Pay
Child Support Limits * State limits may be lower
Child Support • Same employee example but Child Support Order received • Employee–not more than 12 weeks in arrears • Employee-does not support another family • Order says to deduct $1,250.00 • Max we to deduct is 60%
Child Support • Dispoable Pay = $4,126.68 • Max to deduct - $4,126.68 * 60% = $2,476.01 • Order less than max so we deduct order of $1,250.00
Child Support • Net Pay = $5,000.00 (gross) - $500.00 (FITW) - $302.56 (SS) - $70.76 (medicare) - $500.00 (401(k)) - $100.00 (medical) - $20.00 (dental) - $1,250.00 (child support) = $2,256.69 Net
Garnishments • Also uses disposable pay • Look at state rules • 25% max or 30 times minimum wage