Spreadsheet for 2018 W-4 adjustments?

Non-investing personal finance issues including insurance, credit, real estate, taxes, employment and legal issues such as trusts and wills
Post Reply
leftcoaster
Posts: 327
Joined: Mon Jul 23, 2007 4:04 pm

Spreadsheet for 2018 W-4 adjustments?

Post by leftcoaster » Fri May 18, 2018 10:10 am

I'd like to tune up my W-4 withholding and am wondering if anyone has a spreadsheet that does a good job of this beyond what the W-4 itself will do. Besides W-2 income, I have dividends, interest, capital gains/losses, cafeteria benefits, and so on.

User avatar
Ice-9
Posts: 1312
Joined: Wed Oct 15, 2008 12:40 pm
Location: Rockville, MD

Re: Spreadsheet for 2018 W-4 adjustments?

Post by Ice-9 » Fri May 18, 2018 11:08 am

I used the IRS' withholding calculator.
https://www.irs.gov/individuals/irs-wit ... calculator
Results told me how much additional to take from each paycheck the rest of the year.

I wish my state had something similar.

User avatar
FiveK
Posts: 5569
Joined: Sun Mar 16, 2014 2:43 pm

Re: Spreadsheet for 2018 W-4 adjustments?

Post by FiveK » Fri May 18, 2018 11:10 pm

leftcoaster wrote:
Fri May 18, 2018 10:10 am
I'd like to tune up my W-4 withholding and am wondering if anyone has a spreadsheet that does a good job of this beyond what the W-4 itself will do. Besides W-2 income, I have dividends, interest, capital gains/losses, cafeteria benefits, and so on.
The IRS calculator Ice-9 mentioned is good. You could also use the personal finance toolbox spreadsheet (see cell A57 on the 'Instructions' tab). If you get the same answer from both, then it's probably correct (given the inputs...).

manedark
Posts: 242
Joined: Sun Apr 22, 2018 2:05 pm

Re: Spreadsheet for 2018 W-4 adjustments?

Post by manedark » Sat May 19, 2018 12:06 am

leftcoaster wrote:
Fri May 18, 2018 10:10 am
I'd like to tune up my W-4 withholding and am wondering if anyone has a spreadsheet that does a good job of this beyond what the W-4 itself will do. Besides W-2 income, I have dividends, interest, capital gains/losses, cafeteria benefits, and so on.
I am interested to know the same as well. I just made a back of the envelope calculation but it would be great to use a software - do you think a 2018 Tax Software can do it better?

User avatar
FiveK
Posts: 5569
Joined: Sun Mar 16, 2014 2:43 pm

Re: Spreadsheet for 2018 W-4 adjustments?

Post by FiveK » Sat May 19, 2018 12:15 am

manedark wrote:
Sat May 19, 2018 12:06 am
I am interested to know the same as well. I just made a back of the envelope calculation but it would be great to use a software - do you think a 2018 Tax Software can do it better?
Both the IRS calculator and the spreadsheet previously mentioned contain a form of 2018 tax software. Not "filing quality" but probably sufficient for withholding calculations for the vast majority of folks.

manedark
Posts: 242
Joined: Sun Apr 22, 2018 2:05 pm

Re: Spreadsheet for 2018 W-4 adjustments?

Post by manedark » Sat May 19, 2018 12:32 am

Thank I will take a look.

Post Reply