Pay estimator doohickey
#1
Gets Weekends Off
Thread Starter
Joined APC: Mar 2008
Position: Ca. CRJ 200
Posts: 348
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?
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?
#3
Gets Weekends Off
Joined APC: Jan 2008
Posts: 888
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.
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.
#4
Gets Weekends Off
Thread Starter
Joined APC: Mar 2008
Position: Ca. CRJ 200
Posts: 348
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.
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.
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
Thread
Thread Starter
Forum
Replies
Last Post