1846689
turbotax icon
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Attend our Ask the Experts event about Tax Law Changes - One Big Beautiful Bill on Aug 6! >> RSVP NOW!
Close icon
Do you have a TurboTax Online account?

We'll help you get started or pick up where you left off.

turbo tax not properly calculating refi average mortgage balance

I had a home loan starting in 2019.
on Jan 1, 2020 the loan balance was $751,392.29
on 11/3/2020 this loan had a balance of $741,230.02 and was paid in full (refinanced)
loan 1 had an average balance of (751,392.29+741,230.02)/2 = 746,311.15 over 10 months

on 11/2/2020 my refinance loan was originated at $749,000
on 12/31/2020 the balance of the refi was $746,426.17
loan 2 had an average balance of (749,000 + 746,426.17)/2= 747,713.08 over 2 months

Turbo tax is saying my average mortgage balance for the year is $1,494,024 and therefore saying I can only deduct 50.2% of my interest paid.  Is this correct? My Understanding is that my average for the year should be under $750,000.  It seems like its calculating as if I had both loans concurrently, the whole year.  Searching online it seems like this was an issue last year as well... HELP?

x
Do you have an Intuit account?

Do you have an Intuit account?

You'll need to sign in or create an account to connect with an expert.

32 Replies

turbo tax not properly calculating refi average mortgage balance

I am also interested in a response to this question.  Thank you.

turbo tax not properly calculating refi average mortgage balance

It seems like it may be time to find a new tax preparation option.  From my reading this was an issue last year as well, and it doesn't seem like they care to address it.  This is a pretty big issue...

turbo tax not properly calculating refi average mortgage balance

We are aware of this issue.

Please sign up for email notifications of when an update related to this issue is available here.

turbo tax not properly calculating refi average mortgage balance

But from what I have found on these forums from last year the issue existed then as well. Do you plan to fix the issue?

PattiF
Expert Alumni

turbo tax not properly calculating refi average mortgage balance

Some TurboTax customers are experiencing an issue with their Home Mortgage Average Balance. This can cause the Home Mortgage Interest to be incorrectly limited.

If you're experiencing  the issue above,  please go here to receive email notifications when any updates related to this issue become available.

**Say "Thanks" by clicking the thumb icon in a post
**Mark the post that answers your question by clicking on "Mark as Best Answer"

turbo tax not properly calculating refi average mortgage balance

has this issue been resolved? I am having the same issues.

DaveF1006
Expert Alumni

turbo tax not properly calculating refi average mortgage balance

This is still an ongoing issue. Please sign up here for an update when the issue has been resolved.

**Say "Thanks" by clicking the thumb icon in a post
**Mark the post that answers your question by clicking on "Mark as Best Answer"

turbo tax not properly calculating refi average mortgage balance

My Workaround. 

 

**I am not a tax professional.  My approach seems logical but I am not a tax expert.**

 

Issue – I refinanced my mortgage in November and turbo tax calculated my mortgage interest deduction based on the wrong average balances for my initial and refinanced loans.

 

What happened –

My initial loan balance in January was ~$307K and it was ~$289K in November when I refinanced my loan.  Turbo Tax calculated my average balance to be ~$298K, but it really should have been ~$274K.

 

For my new, refinanced loan (which was effective in December for ~$312K), turbo tax calculated my average balance to be ~$312K, but it really should have been ~26K.  Table below captures my approach to reaching that conclusion.

 

Initial Loan
Balance

Refinanced Loan
Balance

January

$307,424.65

$0.00

February

$305,826.44

$0.00

March

$304,223.57

$0.00

April

$302,616.02

$0.00

May

$301,003.78

$0.00

June

$299,386.84

$0.00

July

$297,765.19

$0.00

August

$296,140.75

$0.00

September

$294,511.57

$0.00

October

$292,877.64

$0.00

November

$289,625.46

$0.00

December

$0.00

$312,040.00

 

 

 

Average Balance

$274,283.49

$26,003.33

 

To correct the average balance error, I manually changed the calculations that turbo tax derived and I entered the values that I calculated above.  To do this I entered the “Forms” view (Click "View" from the Header Menu, next to "File" and "Edit", and then click "Forms").

 

Once in the “Forms” view I selected the “Deductible Home Mortgage Interest Worksheet”.  I right clicked on the Months loan outstanding and selected override to change my initial loan value from 12 to 11 months and my new loan value to 1 month.

 

I then right clicked on the average balances and selected override to enter the average balance numbers shown in the table above.

 

The impact of these changes propagated through most of my other worksheets, but my Schedule A line 8A was still not correct.  I had to override line A2 on the “Tax and Interest Deduction Worksheet” with the value found on line 16 of the “Deductible Home Mortgage Interest Worksheet” to correct the issue on Schedule A line 8A.

 

If you have a similar problem and you can’t wait for TurboTax to correct this issue, then I hope this helps you out.

 

As a reminder, “I AM NOT A TAX PROFESSIONAL, but the math makes sense to me.”

turbo tax not properly calculating refi average mortgage balance

Thanks! I tried to edit the forms and I couldn't, but maybe I didn't go into it the right way. I'm debating if I should do this, or just get my money back, and go to a tax prep software that does things correctly. I have used Turbo Tax for years, it's pretty disappointing that they don't seem to care. 

turbo tax not properly calculating refi average mortgage balance

I also have this issue. It is extremely frustrating. I can't believe TurboTax hasn't fixed it yet. I am waiting to file. Please TurboTax, get this fixed ASAP!

Cynthiad66
Expert Alumni

turbo tax not properly calculating refi average mortgage balance

Some TurboTax customers are experiencing the following error message when running the Federal Error Check

 

Check This Entry:

Tax and Interest Deduction Worksheet: Limited Interest and Points must be entered

 

If you're experiencing  the error above,  please go here to receive email notifications when any updates related to this issue become available.

 

However, we have received this work around if you would like to try it or you can wait for the fix.

 

If your total home debt is under $375,000 ($250,000 for married filing separate) there is nothing new for you to do in 2020. Enter each 1098 as you normally would.

Home Debt Over $375,000

Under tax law, you are limited on the amount of home interest you can deduct. The limit is based on the loan amount and date of the origination of debt. We want to make sure we calculate this correctly for you. 

If you refinanced last year, you’ll have a Form 1098 from your previous lender and one from the lender you refinanced with. You’ll need both forms. 

Follow these steps to enter your mortgage information:

  1. Gather all of your 1098 forms related to your refinance (the form from your original lender and the form from your new lender)
  2. Grab a calculator and add together the box 1 amount from each form. Enter the total in TurboTax as Box 1 Mortgage interest.
  3. Add the Box 5 amount from each form and enter the total as Box 5 Mortgage insurance premiums. (If you weren’t required to pay mortgage interest, these boxes will be blank on your forms and you won’t enter anything.)
  4. Add the property tax paid from each form and enter it in the Property (real estate) taxes box.

Next, finish adding info for boxes 2, 3, 7, and 11 using Form 1098 for the original loan.

What if I have more than two 1098s?

You should combine all of the 1098s directly related to the refinance and enter it as one 1098.  An example of this is if you refinanced two loans into one loan. Any 1098s not directly related to the refinance should get entered separately.

What if I paid points?

Points on Loans Paid Off in 2020: Enter the points on your 1098 you have started and mark you paid off the loan when promoted.

Points on Loans on New Loans: You will want to enter a separate 1098 to cover these points paid. When prompted, enter 0.00 for Boxes 1, 2, 5, and the Property (real estate) taxes box, and checkbox 7, as you’ve already entered the details on your first 1098. For Box 3, add the date in 2020 when the loan originated.

https://digitalasset.intuit.com/IMAGE/A70qODYjW/Refinance-home-debt-1.png

On the Tell us about any points paid to bank screen, answer in regards to the new loan when asked about points.

On the Tell us about any points paid to bank screen, answer in regards to the new loan when asked about points.

**Say "Thanks" by clicking the thumb icon in a post
**Mark the post that answers your question by clicking on "Mark as Best Answer"

turbo tax not properly calculating refi average mortgage balance

Thanks Cynthia for the information. I have 3 1098s from this year. We refi'd, so 2 are from the original mortgage on the house (one purchase and one HELOC used for home improvements). The third 1098 is the refi that paid off both of the first two loans and gave us some extra $ for more home improvements. I can add them together as per your instructions, but what do I do with the names of the banks? The way I read your instructions I would report all three 1098s as one in TurboTax. Is that ok to only report one bank name, even though I have 1098s from 3 banks?

turbo tax not properly calculating refi average mortgage balance

Hi Cynthia,

  Now that I have reread your answer I'm still confused. The issue some of us are having is that TurboTax is not correctly reporting the average balance of our mortgages. This is my problem - I refinanced a loan, but TurboTax is showing my mortgage balance as the total of the loans instead of the average, thereby cutting my deductible mortgage interest in half. Wouldn't adding all of the 1098s together result in the same problem?

JoannaB2
Expert Alumni

turbo tax not properly calculating refi average mortgage balance

No.  You need to report all 1098 Mortgage Interest Statements on your income tax return. The mortgage interests may be deductible and are entered on Scheduled A (Itemized Deduction).

 

See, what do I do if I have multiple 1098's from refinancing, link.

Unlock tailored help options in your account.

message box icon

Get more help

Ask questions and learn more about your taxes and finances.

Post your Question