Author Topic: Federal Income Tax Spreadsheet  (Read 2839 times)

Offline ExGingi

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Nov 2015
  • Posts: 17697
  • Total likes: 7955
  • DansDeals.com Hat Tips 19
    • View Profile
  • Location: 770
  • Programs: בשורת הגאולה. From Exile to Redemption. GIYF. AAdvantage Executive PlatinumŽ
Federal Income Tax Spreadsheet
« on: December 16, 2018, 02:17:37 PM »
Trying to do some year end strategizing, I was looking for something where I could plug in various scenarios and see the results.

I came across the following website that hosts Excel spreadsheets for Federal Tax returns (including 2018 draft). I thought quite a few might find it useful, especially since there are some major new changes, so playing around with the numbers at this time of year might be beneficial.

https://sites.google.com/site/excel1040/home/2018-tax-planner-new-tax-law
I've been waiting over 5 years with bated breath for someone to say that!
-- Dan

Offline S209

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2016
  • Posts: 7549
  • Total likes: 3976
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
    • Gowns By Shevy
  • Location: Lakewood
  • Programs: Marriott Gold, Star Alliance Gold, Hyatt Explorist, Hertz PC, National EE, Rock Royalty Wild Card, Wyndham Diamond, MLife Gold, Caesars Diamond, Hilton Diamond, Uber VIP, IHG Platinum Elite, ANA Platinum, DDF Lifetime Prez Platinum Elite, AmEx Platinum
Re: Federal Income Tax Spreadsheet
« Reply #1 on: December 16, 2018, 03:20:05 PM »
Trying to do some year end strategizing, I was looking for something where I could plug in various scenarios and see the results.

I came across the following website that hosts Excel spreadsheets for Federal Tax returns (including 2018 draft). I thought quite a few might find it useful, especially since there are some major new changes, so playing around with the numbers at this time of year might be beneficial.

https://sites.google.com/site/excel1040/home/2018-tax-planner-new-tax-law
Thanks!
Quote from: YitzyS
Quotes in a signature is annoying, as it comes across as an independent post.

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 7232
  • Total likes: 1097
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: Federal Income Tax Spreadsheet
« Reply #2 on: December 16, 2018, 04:50:11 PM »
Why not just use something like TurboTax?
I just found a new supply of forks!

Offline ExGingi

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Nov 2015
  • Posts: 17697
  • Total likes: 7955
  • DansDeals.com Hat Tips 19
    • View Profile
  • Location: 770
  • Programs: בשורת הגאולה. From Exile to Redemption. GIYF. AAdvantage Executive PlatinumŽ
I've been waiting over 5 years with bated breath for someone to say that!
-- Dan

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 7232
  • Total likes: 1097
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: Federal Income Tax Spreadsheet
« Reply #4 on: December 16, 2018, 06:07:52 PM »
So is TT.
Can you say Warez?  :)
I just found a new supply of forks!

Offline ExGingi

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Nov 2015
  • Posts: 17697
  • Total likes: 7955
  • DansDeals.com Hat Tips 19
    • View Profile
  • Location: 770
  • Programs: בשורת הגאולה. From Exile to Redemption. GIYF. AAdvantage Executive PlatinumŽ
Re: Federal Income Tax Spreadsheet
« Reply #5 on: December 16, 2018, 07:03:17 PM »
Besides for the price, there's a certain convenience to using a spreadsheet, when trying to plug in various number and seeing how they affect the bottom line, rather than going through multiple screens in an interactive software.
I've been waiting over 5 years with bated breath for someone to say that!
-- Dan

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7647
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Federal Income Tax Spreadsheet
« Reply #6 on: December 16, 2018, 07:40:35 PM »
Besides for the price, there's a certain convenience to using a spreadsheet, when trying to plug in various number and seeing how they affect the bottom line, rather than going through multiple screens in an interactive software.
Maybe, but this looks basically like doing the return with a paper and pencil..you need to populate every schedule etc

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 7232
  • Total likes: 1097
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: Federal Income Tax Spreadsheet
« Reply #7 on: December 16, 2018, 07:54:34 PM »
Besides for the price, there's a certain convenience to using a spreadsheet, when trying to plug in various number and seeing how they affect the bottom line, rather than going through multiple screens in an interactive software.
That is how TT works. I enter an IRA amount and bottom line (Fed and State) changes. Also it considers all tax deductions.
I just found a new supply of forks!

Offline ExGingi

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Nov 2015
  • Posts: 17697
  • Total likes: 7955
  • DansDeals.com Hat Tips 19
    • View Profile
  • Location: 770
  • Programs: בשורת הגאולה. From Exile to Redemption. GIYF. AAdvantage Executive PlatinumŽ
Re: Federal Income Tax Spreadsheet
« Reply #8 on: December 16, 2018, 07:55:28 PM »
Maybe, but this looks basically like doing the return with a paper and pencil..you need to populate every schedule etc
Only those that matter.

For example, I have a lot of itemized deductions this year (as well as QBI) so I wanted to see how doing various amounts of ROTH conversions would affect my bottom line. This spreadsheet seems to do the job for me (though it's definitely far from perfect).
I've been waiting over 5 years with bated breath for someone to say that!
-- Dan

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 7232
  • Total likes: 1097
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: Federal Income Tax Spreadsheet
« Reply #9 on: December 16, 2018, 08:04:13 PM »
For example, I have a lot of itemized deductions this year (as well as QBI) so I wanted to see how doing various amounts of ROTH conversions would affect my bottom line. This spreadsheet seems to do the job for me (though it's definitely far from perfect).
You have confidence it is correct?
I just found a new supply of forks!

Offline ExGingi

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Nov 2015
  • Posts: 17697
  • Total likes: 7955
  • DansDeals.com Hat Tips 19
    • View Profile
  • Location: 770
  • Programs: בשורת הגאולה. From Exile to Redemption. GIYF. AAdvantage Executive PlatinumŽ
Re: Federal Income Tax Spreadsheet
« Reply #10 on: December 16, 2018, 08:33:15 PM »
You have confidence it is correct?
I am doing crude estimates for a very specific purpose. I have also have a nice size child tax credit, so it seems to work for me. And no need to install any software.
I've been waiting over 5 years with bated breath for someone to say that!
-- Dan

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 7232
  • Total likes: 1097
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: Federal Income Tax Spreadsheet
« Reply #11 on: December 16, 2018, 08:37:42 PM »
If it works for you that is all that matters.
I just found a new supply of forks!

Offline sillypainter

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2012
  • Posts: 2080
  • Total likes: 204
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
Re: Federal Income Tax Spreadsheet
« Reply #12 on: December 16, 2018, 08:45:19 PM »
Can't sue it. It asks for a password. Even though the sheet says that a password is not required I can;t get it to work....

Offline coffeebean

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2018
  • Posts: 3014
  • Total likes: 820
  • DansDeals.com Hat Tips 10
  • Gender: Male
    • View Profile
Re: Federal Income Tax Spreadsheet
« Reply #13 on: December 19, 2018, 06:23:30 PM »
Trying to do some year end strategizing, I was looking for something where I could plug in various scenarios and see the results.

I came across the following website that hosts Excel spreadsheets for Federal Tax returns (including 2018 draft). I thought quite a few might find it useful, especially since there are some major new changes, so playing around with the numbers at this time of year might be beneficial.

https://sites.google.com/site/excel1040/home/2018-tax-planner-new-tax-law
Is there a Google sheet?

Offline ExGingi

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Nov 2015
  • Posts: 17697
  • Total likes: 7955
  • DansDeals.com Hat Tips 19
    • View Profile
  • Location: 770
  • Programs: בשורת הגאולה. From Exile to Redemption. GIYF. AAdvantage Executive PlatinumŽ
Re: Federal Income Tax Spreadsheet
« Reply #14 on: December 19, 2018, 07:23:30 PM »
Is there a Google sheet?
I don't know, but there's contact information on the website. Why don't you email him.
I've been waiting over 5 years with bated breath for someone to say that!
-- Dan

Offline ExGingi

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Nov 2015
  • Posts: 17697
  • Total likes: 7955
  • DansDeals.com Hat Tips 19
    • View Profile
  • Location: 770
  • Programs: בשורת הגאולה. From Exile to Redemption. GIYF. AAdvantage Executive PlatinumŽ
Re: Federal Income Tax Spreadsheet
« Reply #15 on: December 21, 2018, 01:43:11 PM »
That is how TT works. I enter an IRA amount and bottom line (Fed and State) changes. Also it considers all tax deductions.

Since my situation is a little unusual, I decided to take your suggestion and give TT a try.

I will tell you that if one is trying to get a rough idea, the spreadsheet is BY FAR faster than TT.

TT treats this as an actual return, and doesn't let you override or force anything. So for example unless I enter a SSN for all my 10 dependents, it won't count them for Child Tax Credit.

But the biggest issue with TT for me at this point is that:


And since I have an outsized deduction there, I cannot even get close to my situation without being able to enter that information. Contrast this with the Spreadsheet which is available as a draft. And even though certain parts aren't yet ready (such as form 1099), I am able to compensate for that by entering information in other areas, and overriding certain entries. Whereas I couldn't figure out anywhere that I might enter the deductible amount that I expect to be reported on my form 1098.

OTOH, I will admit that TT seems a lot more detailed and thorough, almost to the extent that I'm thinking of ditching my CPA for the personal returns, and just letting him to my corporate returns.
I've been waiting over 5 years with bated breath for someone to say that!
-- Dan

Offline shaulyaakov

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: May 2013
  • Posts: 2794
  • Total likes: 326
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Federal Income Tax Spreadsheet
« Reply #16 on: December 21, 2018, 03:34:59 PM »
Since my situation is a little unusual, I decided to take your suggestion and give TT a try.

I will tell you that if one is trying to get a rough idea, the spreadsheet is BY FAR faster than TT.

TT treats this as an actual return, and doesn't let you override or force anything. So for example unless I enter a SSN for all my 10 dependents, it won't count them for Child Tax Credit.

But the biggest issue with TT for me at this point is that:


And since I have an outsized deduction there, I cannot even get close to my situation without being able to enter that information. Contrast this with the Spreadsheet which is available as a draft. And even though certain parts aren't yet ready (such as form 1099), I am able to compensate for that by entering information in other areas, and overriding certain entries. Whereas I couldn't figure out anywhere that I might enter the deductible amount that I expect to be reported on my form 1098.

OTOH, I will admit that TT seems a lot more detailed and thorough, almost to the extent that I'm thinking of ditching my CPA for the personal returns, and just letting him to my corporate returns.
I've used TT premier for 2 years and it's pretty helpful. Each year I had 1 question and they can just remote into the software (once you give them a password) and walk you through anything.

It saves me a couple hundred over a cpa and give me experience and education about tax laws at the same time.

Offline ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 7232
  • Total likes: 1097
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: Federal Income Tax Spreadsheet
« Reply #17 on: December 21, 2018, 03:45:08 PM »
Since my situation is a little unusual, I decided to take your suggestion and give TT a try.
My info is imported from last year so everything is on the fly. If I had to manually type in a bunch of stuff it would be a PIA.
I just found a new supply of forks!

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7647
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Federal Income Tax Spreadsheet
« Reply #18 on: December 22, 2018, 06:49:36 PM »
My info is imported from last year so everything is on the fly. If I had to manually type in a bunch of stuff it would be a PIA.
+1