Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

LuckyCharms

(17,444 posts)
Fri Jan 26, 2018, 11:39 AM Jan 2018

Anyone know this answer? Re: Taxes

Every January, after my first paycheck, I populate an Excel spreadsheet that computes what my income tax refund will be for the FOLLOWING January. So, the spreadsheet I have done computes the refund I will receive In January 2019, for 2018 income taxes.

The spreadsheet mimics form 1040. I get paid every 2 weeks, so the spreadsheet includes income for 26 paychecks, laid out one by one, and shows gross income, federal tax withheld, and state tax withheld. The spreadsheet includes all other income and expenses as well.

Today's paycheck reflected the new tax withholding. Therefore, my check was larger. I flowed the new numbers through to each of the remaining checks for the year.

Upon doing this my refund amount dropped from $1500 to $1000.

Therefore, even though I will be receiving $500 more per year via my paychecks, my refund amount is dropping by $500 at the end of the year.

The net cash effect of this is a zero benefit.

This doesn't seem right to me? I'm thinking that the refund should have stayed the same at $1500, and I would see an additional benefit in my paychecks of $500. Am I looking at this wrong?

I use the standard deduction, and there were no other changes in income or expenses.

Thanks very much for any replies, in advance.

17 replies = new reply since forum marked as read
Highlight: NoneDon't highlight anything 5 newestHighlight 5 most recent replies

BSdetect

(8,998 posts)
2. Seems to be what most people are saying. Its going to be a real shock for many that
Fri Jan 26, 2018, 11:43 AM
Jan 2018

their "refund" drops or disappears.

Any chance you can show where to get that spreadsheet template?

Phoenix61

(17,006 posts)
3. No, I don't believe you are
Fri Jan 26, 2018, 11:43 AM
Jan 2018

That's why they are calling it a scam. The real cut went to the Koch brother's etal.

LuckyCharms

(17,444 posts)
4. I just looked at the individual cells in the sheet.
Fri Jan 26, 2018, 11:45 AM
Jan 2018

I've adjusted for the new, higher standard deduction, and the new tax rate as it applies to my taxable income. So, those things are not a player. I'm thinking that the withholding is not accurate.

Johonny

(20,851 posts)
5. That's the result I'm getting
Fri Jan 26, 2018, 11:46 AM
Jan 2018

Not a dollar per dollar change but basically I'm robbing from Peter to pay Paul. Yes my check is up, but yeah my refund is going down too. I don't think this is the case for every income level.

LuckyCharms

(17,444 posts)
8. Oh also, mine wasn't dollar for dollar either...
Fri Jan 26, 2018, 11:51 AM
Jan 2018

but it was close.

I just used an even $500 for purposes of my OP.

LuckyCharms

(17,444 posts)
6. Here's what I think...
Fri Jan 26, 2018, 11:48 AM
Jan 2018

Most of the benefit of the increased standard deduction was wiped out by the elimination of exemptions. Couple that with withholding tables that may or may not work for my situation, and that would explain the fact that this "tax relief" does not mean jack shit in my case.

ProfessorGAC

(65,069 posts)
13. They Tried To Sell This Lemon With The "Postcard" Bit
Fri Jan 26, 2018, 12:26 PM
Jan 2018

I believe a large percentage of the population will see what you're seeing, but they made a big case over the "filing on a postcard" issues.

The thing is, an awful lot of people are using 1040 EZ or 1040 A which is already just 1 two-sided page and half the cells end up zero.

So, they tried to sell this "breakeven" thing as a tax cut and simplification when it was already super simple for 30 to 50% of taxpayers. And with tax software, even those who were itemizing found it easy and fast.

This whole thing is "swamp land in Florida".

9. In general, it is best to avoid having any refund
Fri Jan 26, 2018, 11:52 AM
Jan 2018

This is slightly OT, but it always pains me to see people eager for a refund. Getting a refund at all means you are withholding too much and giving an interest-free loan to the government. It is more to your advantage to reduce your withholding a bit and put the money into savings or into paying down debt.

LuckyCharms

(17,444 posts)
11. I adjust my withholding to hit a certain amount...
Fri Jan 26, 2018, 11:56 AM
Jan 2018

almost dead nuts every year. That amount is what I predict my property tax bill will be around the time the tax refund is received.

I understand that I am missing out on the interest this could have earned, or the debt interest this could have prevented, but logistically, this is easier for me because the amount is not that large and I always know it will be there when the property taxes come due.

In general though, you are entirely correct.

mama

(164 posts)
10. A few weeks ago, there were news articles encouraging people to re-do their W-4
Fri Jan 26, 2018, 11:54 AM
Jan 2018

to see a higher paycheck.

Same old thing... you can take less now and get a bigger refund or take more now and get a lesser refund.

Just smoke and mirrors.

fescuerescue

(4,448 posts)
12. The 1040 for 2018 is going to be much different than the 1040 for 2017
Fri Jan 26, 2018, 12:12 PM
Jan 2018

The 2017 1040 was only finalized a few weeks ago, so it's going to be awhile before we see a draft 2018 1040.

To simulate what your 2018 will be, you should update the tax rates based on your bracket, update to the new standard deduction (which doubles I believe), and then remove your exemption.

I've tried to a similar simulation for myself, and I came to the conclusion that I don't have enough information yet to know if I benefit or suffer.

In your case, you certainly won't see zero difference except by some math miracle, there is just to many variables changing. But at the same time, there isn't enough solid information yet to know if your refund rises or drops.

LuckyCharms

(17,444 posts)
15. I incorporated all of the changes you mentioned...
Fri Jan 26, 2018, 12:43 PM
Jan 2018

into the spreadsheet. I should have been more clear...the spreadsheet is fairly complicated. It doesn't "mimic" the 1040 as a I stated, but rather, it computes the tax in the same way that the 1040 does.

D_Master81

(1,822 posts)
14. imo
Fri Jan 26, 2018, 12:41 PM
Jan 2018

If you dont have kids your taxes wont change much. Standard ded doubles but with the loss of exemptions it only goes up 3000 overall. Tax rates drop from 15 to 12%. So on every $100 you keep $3 more. People with kiss who get the tax credit will see a decent bump. But if you're a working couple or single it shouldn't be drasticallydidifferent

sinkingfeeling

(51,457 posts)
17. I'm retired, on SS and a pension. My taxes will increase about $1000
Fri Jan 26, 2018, 02:23 PM
Jan 2018

because my itemized deductions exceed the new standard deduction and my state and property tax deductions are over the $10,000 cap.

So, there was no tax cut for me. Just paying more for billionaires.

Latest Discussions»General Discussion»Anyone know this answer? ...