Pay estimator doohickey
 

So I'm a numbers nerd and I've been making an excel sheet to ballpark my pay each cycle. What I'm struggling with, is the taxable and nontaxable items each month to get the numbers close. 401k, nt pd, fsa contribution....what else?


Just to be sure I'm not reinventing the wheel before I continue bearing my head against the wall trying to get it all figured out, does anybody have something like this already?

PM sent.
.

I built one too, but it's not that hard to reverse engineer.

Healthcare , Dental, FSA's, HSA, Vision and 401K are all tax exempt deductions. NT PD (Non Taxable Per Diem) is also not subject to tax.

Voluntary Life (Vol Life), Spouse Life (SP Life) and Long Term Disability (LTD) are non tax deductible deductions.

In a very simple case take your pay rate, multiply it by hours on the check. Add any Taxable Per Diem and Special Items (Parking Allowance for example). That will be Taxable gross pay. Excluding NT Per Diem multiply that by 1.9%; those are your ALPA dues.

Medicare is 1.45% of taxable (plus 401K which IS subject to Medicare tax).

Social Security is 6.2% of taxable ( again plus 401K which is subject to SS tax). If it applies to you, SS tax stops being collected at $128,400, so any earnings in 2018 in excess of that aren't subject to SS tax.


Alright, looking back that wasn't a very simple explanation. Hopefully HighFlight explained it better, or sent you a spreadsheet.

You da man

That was exa fly the breakdown I was looking for. I was losing my patience trying to math out which of the deductions were tax deductible.

Thank you