Forecasting taxes
Forecasting taxes
I hear on this board all the time about people who use tax software to "project" their tax liability, and therefore predict how much refund they will get, and/or how much Roth conversion they should do, etc.
I would like to do this sort of thing for two reasons. One reason is to determine how much charitable giving to do this year. I would like to do charitable contributions until I'm out of the 22% tax bracket if possible. The second reason is to understand the size of my refund next year. It's important for budgeting to know if I will be getting a refund, and how big. I changed jobs and states this year, so I have a large amount of nondeductible relocation income this year.
I installed TurboTax 2019, but I don't know how to proceed without a W2 form. I need to enter all kinds of quantities that are normally on the W2 form such as Wages, Social Security Wages, Medicare Wages, etc. So now instead of forecasting taxes, I must first forecast a W2. Is there a way to estimate what the W2 will look like based on paystubs?
I have my paystubs, and they show yeartodate quantities for Regular/vacation, bonus, and relocation. There are also YTD witholding amounts for Federal and State income taxes as well as Medicare and Social Security. With only 2 more paychecks in the year, it should be easy to estimate the final YTD numbers. But I don't know how to use all these numbers to "generate" a W2 for the tax software.
I would like to do this sort of thing for two reasons. One reason is to determine how much charitable giving to do this year. I would like to do charitable contributions until I'm out of the 22% tax bracket if possible. The second reason is to understand the size of my refund next year. It's important for budgeting to know if I will be getting a refund, and how big. I changed jobs and states this year, so I have a large amount of nondeductible relocation income this year.
I installed TurboTax 2019, but I don't know how to proceed without a W2 form. I need to enter all kinds of quantities that are normally on the W2 form such as Wages, Social Security Wages, Medicare Wages, etc. So now instead of forecasting taxes, I must first forecast a W2. Is there a way to estimate what the W2 will look like based on paystubs?
I have my paystubs, and they show yeartodate quantities for Regular/vacation, bonus, and relocation. There are also YTD witholding amounts for Federal and State income taxes as well as Medicare and Social Security. With only 2 more paychecks in the year, it should be easy to estimate the final YTD numbers. But I don't know how to use all these numbers to "generate" a W2 for the tax software.
Re: Forecasting taxes
This is one of the reasons I do my taxes by hand.
Do you have last year's return? Project from that. Most of the things you're asking about for the W2 have no effect on your taxes.
Do you have last year's return? Project from that. Most of the things you're asking about for the W2 have no effect on your taxes.
Re: Forecasting taxes
Well, I have almost $60,000 of relocation expenses this year. That's definitely going to impact my taxes compared to last year. Also, as I mentioned I am planning to donate $25k+ to charity this year, which I didn't do last year. And I have a new state and new employer tax ID numbers and whatnot, so last year's information doesn't get me far. I only got 2 paychecks with my old employer.
The main things I'm missing from a W2 are the various ""wages/social security wages/medicare wages" quantities, which aren't broken out of my paystubs, and what may be in the various boxes which I don't understand such as box 14.
The main things I'm missing from a W2 are the various ""wages/social security wages/medicare wages" quantities, which aren't broken out of my paystubs, and what may be in the various boxes which I don't understand such as box 14.
Re: Forecasting taxes
Find a prior year W2 and then find the associated year end paystubs. Compare them to understand how the numbers flow from paystub year end numbers into particular line items on the W2. That's what I did. Having hard numbers that were applied in the past should instill some confidence.
Re: Forecasting taxes
ionball's advice is good.
You could also look at the first ~14 rows of the Calculations tab in the personal finance toolbox spreadsheet to see examples of what causes differences among gross, FICA, and W2 Box 1 wages.

 Posts: 26
 Joined: Sat Mar 30, 2013 10:05 am
Re: Forecasting taxes
+1 on the calculator tabFiveK wrote: ↑Mon Dec 02, 2019 4:42 pmYou could also look at the first ~14 rows of the Calculations tab in the personal finance toolbox spreadsheet to see examples of what causes differences among gross, FICA, and W2 Box 1 wages.
I built a similar spreadsheet to forecast my taxes and it was the best thing for learning and understanding how things flow onto my w2 and then affect taxes. Especially since our income varies month to month.
The full answer is more complex, but the simple answer to your question is SS is 6.2% tax and Medicare is 1.45%.
https://www.irs.gov/taxtopics/tc751
You can google and find out what gets subtracted from gross wage for each (like 401k, medical premiums, etc), and then do the multiplication. you’ll also see nuances like SS ceases after ~$132k (can’t remember exactly). And over $200k Medicare takes an extra 0.9% out.
I do that for monthly columns and then sum up each row and that effectively is like the w2 cells. Some cells arent critical to recreate in TurboTax, like employer share of healthcare payments.

 Posts: 3631
 Joined: Sun Oct 22, 2017 2:06 pm
Re: Forecasting taxes
It is easy to estimate your taxes by hand. Grab your final 2019 paystub and:
1. Find the YTD gross income number
2. Find the YTD pretax deductions number
3. Determine if you will use the standard deduction or itemized deduction, if the latter sum up the amount.
4. Subtract 2 and 3 from 1, this gives you your taxable income
5. Use tax tables to calculate your tax owed
6. Subtract any credits like Child tax credit or Electric vehicle credit
That’s it! (This ignores any nonwage income you might have, like rental income, bank interest, capital gains, and also any nonwage deductions like traditional IRA contributions)
PS: unless you moved due to military orders, moving expenses are no longer deductible
1. Find the YTD gross income number
2. Find the YTD pretax deductions number
3. Determine if you will use the standard deduction or itemized deduction, if the latter sum up the amount.
4. Subtract 2 and 3 from 1, this gives you your taxable income
5. Use tax tables to calculate your tax owed
6. Subtract any credits like Child tax credit or Electric vehicle credit
That’s it! (This ignores any nonwage income you might have, like rental income, bank interest, capital gains, and also any nonwage deductions like traditional IRA contributions)
PS: unless you moved due to military orders, moving expenses are no longer deductible
Re: Forecasting taxes
I'm well aware that relocation benefits are not deductible anymore. That's why I'm doing this whole thing. I'm a bit nervous about paying taxes on that $50k+ relocation benefit.
Without appearing ungrateful for the relocation benefit, I may ask my employer for an itemized breakdown of the actual relocation expenses. Since I'm paying taxes on them, it seems fair to audit them to make sure they are legit.
Without appearing ungrateful for the relocation benefit, I may ask my employer for an itemized breakdown of the actual relocation expenses. Since I'm paying taxes on them, it seems fair to audit them to make sure they are legit.
Re: Forecasting taxes
I am one of those doing it every year. Used to use TT, now using HRB. I run multiple scenarios for us (MFJ), plus a few for each kid.
Don't worry about exact W2 SS and Medicare numbers. I just leave them blank. Put in your earned income (box 1), and your income tax payments (box 2). Same for state (if you have state taxes). That's all.
If you have 401k, estimate your numbers in boxes below. Don't be afraid to make mistakes or change numbers  create multiple files, scenarios, backups, whatever, and then sharpen the numbers as you get closer to December 31.
Don't worry about exact W2 SS and Medicare numbers. I just leave them blank. Put in your earned income (box 1), and your income tax payments (box 2). Same for state (if you have state taxes). That's all.
If you have 401k, estimate your numbers in boxes below. Don't be afraid to make mistakes or change numbers  create multiple files, scenarios, backups, whatever, and then sharpen the numbers as you get closer to December 31.
Re: Forecasting taxes
When we relocated last year, my husband's employer paid estimated taxes on his relocation benefit for the expenses they paid directly, and "grossed up" the cash payments they made to us. We ended up with a rather substantial refund.
Definitely check with your employer  if they are a large company that regularly pays relocation benefits they likely have a policy already in place.
Definitely check with your employer  if they are a large company that regularly pays relocation benefits they likely have a policy already in place.

 Posts: 3631
 Joined: Sun Oct 22, 2017 2:06 pm
Re: Forecasting taxes
Paid relocation benefits should show up on your paystub as a separate income line item. So it would be captured in my process outlined above.28fe6 wrote: ↑Tue Dec 03, 2019 11:07 amI'm well aware that relocation benefits are not deductible anymore. That's why I'm doing this whole thing. I'm a bit nervous about paying taxes on that $50k+ relocation benefit.
Without appearing ungrateful for the relocation benefit, I may ask my employer for an itemized breakdown of the actual relocation expenses. Since I'm paying taxes on them, it seems fair to audit them to make sure they are legit.
Re: Forecasting taxes
Does anyone have a suggestion for a tax table resource online? Where I can type in taxable income and get the amount of tax owed?
I'm having to do this manually in a spreadsheet, but there must be a calculator out there. When I search, all I can find is tax brackets, but not actually tax tables.
Edit: I did find this:
https://www.irs.gov/pub/irsdft/i1040ttdft.pdf
Not exactly a calculator but it is an authoritative source and tells you how to do it. An online calculator would be nicer.
I'm having to do this manually in a spreadsheet, but there must be a calculator out there. When I search, all I can find is tax brackets, but not actually tax tables.
Edit: I did find this:
https://www.irs.gov/pub/irsdft/i1040ttdft.pdf
Not exactly a calculator but it is an authoritative source and tells you how to do it. An online calculator would be nicer.
Last edited by 28fe6 on Tue Dec 03, 2019 3:38 pm, edited 1 time in total.
Re: Forecasting taxes
My method as well ( except income changes). I keep records, it's easy to extrapolate changes and their expected impact, and from there project my EFTPS quarterly requirements. If something changes I can always schedule an additional payment or cancel and change an existing.
Re: Forecasting taxes
One can type a number into one spreadsheet cell and see the tax in another. One could type a number into a web form and see the tax displayed elsewhere. Seems equivalent but maybe different in the eyes of different beholders.
Tax will depend on filing status, type of income, etc.
Simplest spreadsheet entry seems to be the Calculations tab of the personal finance toolbox spreadsheet.
Simplest web tool may be the 2019 federal income tax estimator. See US and state income tax calculator  Bogleheads.org for more discussion.
Re: Forecasting taxes
TurboTax has a useful estimating tool called the WhatIf Worksheet. It allows you to input a more limited number of key variables to estimate your taxes instead of doing a full pro forma tax return.
To use it, go to the Forms function in TurboTax. Then, click on Open Form. In the search box, type What. Click on WhatIf Worksheet and click on Open Form. There are some limitations spelled out in Help.
To use it, go to the Forms function in TurboTax. Then, click on Open Form. In the search box, type What. Click on WhatIf Worksheet and click on Open Form. There are some limitations spelled out in Help.