FAQs
On the sheet titled 'W4' next to "Multiple Jobs or Spouse Works" and "Exempt?" it just says "FALSE".
This is a formatting error when going from Google to Excel. These two cells (B8 and B22) should be check boxes. To correct this:
Google Sheets (on a computer) - click on the cell, click "Insert" from the menu, click "Checkbox"
Excel -
I entered my TFP for the month from my payroll report but it was way off from what I was actually paid.
Make sure you are entering your TFP value from the month prior. The January 20th paycheck is for work performed in December. So the TFP for the January check should come from the Payroll Report for December.
I put in my TFP from CrewHub but it doesn't match the amount I was paid.
Make sure you are using the "Total TFP" number from the Payroll Report on CWA. CrewHub and "Projected Credit" does not account for overrides and certain training events as well as other random pay values. Its best to wait until payroll does their final "sweep" for OGT and all audits are complete to get the most accurate number.
The Federal Tax Withholding is very accurate but my state withholding is not.
The Federal Tax Withholding is a formula based on your W4 responses on the 'W4' page. This should approximate your federal tax withholding very precisely. The State Tax Withholding is a guess made by you on Line 14 of the pay calculator page. It will not be exact based on fluctuations in pay.
I'm currently an FO but will be upgrading this year. How can I change my pay rate accordingly?
You will have to manually type in your pay rate (Line 17) for either before or after you upgrade.
Why is my January 20th check showing 2024 pay rates?
The January 20th paycheck is for the work done in December and is paid at 2024 rates.
Tips and Reminders
This sheet works best if you type in the actual numbers from each paystub on Workday throughout the year. If you type the actual numbers in as you go it will adjust the remaining numbers for the remainder of the year. Especially in regards to 401k, NEC, MBCBP and tax withholdings. I normally type the actual numbers in and then make that column bold to remind myself that its the actual numbers, not estimates. If you don't care about exact numbers and just want to get a general idea of totals for the year then you don't need to worry about that. This sheet can be as vague or precise as you want it to be.
If you fill out the W4 exactly as you have it on Workday (2020 W4s and newer) it should be very accurate in estimating your Federal Tax Withholding. This does not mean that your withholding is where it is supposed to be. It is up to you to figure out by the end of the year if your Federal Tax Withholding is sufficient for your level of income. Remember if you change your W4 on Workday to change it on this sheet as well.
The Non-Taxable LOL rate has increased a lot in 2025. If you are enrolled in Non-Taxable LOL you may want to take a close look at the amount of imputed income you will incur. You pay taxes on this imputed income. Topped out captains can easily have more than $15,000 in imputed income on this alone in 2025.