ProConnect HelpIntuit HelpIntuit

Understanding Excess Home Mortgage Interest for Individual federal Schedule A in ProConnect Tax

by Intuit1 Updated 8 months ago

This article will help you apply home mortgage interest rules, calculate mortgage interest deductions and their limitations, and input excess mortgage interest amounts into Schedule A in Intuit ProConnect.

  • The excess mortgage rules apply when the taxpayer's home acquisition debt exceeds $1,000,000 ($500,000 if Married Filing Separately) or the taxpayer's home equity debt exceeds $100,000 ($50,000 if Married Filing Separately).
    • The existence of grandfather debt (pre-1987) affects the determination of excess home acquisition debt.
  • When the taxpayer has mortgage interest of $50,000 or more, a diagnostic is currently issued informing the preparer that the home mortgage limitations may apply and that amounts may need to be manually limited.
    • Input fields are provided at the bottom of the Schedule A screen for calculating amounts.
      • Click on the Check Return tab at the top of the screen
      • Under Forms, select Worksheets
  • For information regarding a refinanced home, see Entering a Refinance in the Excess Mortgage Interest section in the Itemized Deductions screen.
  • For more information on home mortgage interest rules, see Publication 936, Part II, Limits on Home Mortgage Interest Deduction.
  • When the taxpayer is subject to excess mortgage limitations, points are subject to limitation as well.
    • The percentage on line 11 of the Worksheet to Figure Qualified Loan Limit and Deductible Home Mortgage Interest should be applied to points as well.
    • When points are entered in the excess mortgage input section, a worksheet prints out showing the calculation of deductible and excess points.
  • Calculating amortized points as part of deductions:
    1. To enter amortized points:
      1. From the left of the screen select Deductions and then Depreciation.
      2. Click on the Form field and choose Schedule A (points) from the dropdown menu.
    2. The otherwise deductible amount of points is multiplied by the ratio on line 11 of the Pub 936 worksheet.
    3. The result is included on Schedule A, line 12.
    4. An informational diagnostic is generated informing the user that the amortized points were subjected to the percentage.
    5. If the amounts don't flow correctly:
      1. Click on Itemized Deductions to the left of the screen
      2. Under the worksheet Excess Mortgage Interest, if an override is entered in the Average Balance field, the amounts won't flow correctly. Remove any override in that field.
  1. From the left of the screen, select Deductions and choose Itemized Deductions (Sch A).
  2. From the top of the screen, select the Interest section.
  3. In the Excess Mortgage Interest section, enter information for up to 4 loans.
    • The input within the program is currently limited to 4 loans. To input more than 4 loans, see Schedule A Excess Home Mortgage Interest with More Than Four Loans below.
  4. Check the Worksheets only checkbox to have ProConnect Tax calculate the Excess Mortgage Worksheet for the amounts of allowed deductible interest and expense and NOT carry the amounts to the respective forms or schedules.
  5. To enter a payoff, include any principal paid before the payoff, plus the entire payoff amount, in the field Total principal paid.
  6. The field Lump sum principal payment (if paid off) should include only the payoff amount.
    • In a payoff situation, ProConnect Tax prints the payoff amount as the ending balance, if entered properly. The formula to compute the average balance of a loan is [(beginning balance + ending balance)/2 x the number of months outstanding/12].

Schedule A Excess Home Mortgage Interest with More Than Four Loans

You should start off by printing the Excess Mortgage Worksheet to manually calculate all loans (including the additional loans). From there:

  1. Go to Input Return Deductions Itemized Deductions. (Sch A)
  2. Scroll down to the Interest section.
  3. Report the total of all loans in the field Home Mortgage interest & Points on Form 1098 [A].

It is important to note that the program does not generate any additional columns in excess of four mortgage loans.

Follow these steps to enter information to calculate the excess mortgage:

  1. Go to the Input Return tab.
  2. From the left of the screen, select Deductions and choose Itemized Deductions (Sch A).
  3. From the top of the screen, select Interest.
  4. Scroll down to the Excess Mortgage Interest section.
  5. Enter the following fields:
    • Lender's name
    • Form (Click on arrow to select from list)
    • Activity name or number
    • 1=taxpayer, 2=spouse, blank=joint
    • Interest paid
    • Total principal paid
  6. Locate the applicable Home Acquisition Debt (proceeds used to buy, build or improve home) or Home Equity Debt (proceeds not used to buy, build or improve home) subsection.
    • Home Acquisition Debt is used when the loan was used for purchase/improvement of home.
    • Home Equity Debt is used when the loan was used for other things. If you use this subsection, enter the Percentage that benefits the home (.xxxx).
  7. Enter the Beginning of year in the applicable section.

Mortgage-related deductions entered iwithin the Excess Mortgage Interest section shouldn't be entered elsewhere. If using this input section, remove mortgage-related deductions from the regular interest section of this screen, from the Business Use of Home (8829) screen, and from any vacation homes or owner-occupied rentals entered in on the Rental and Royalty Income (Sch E) screen.

What is the Excess Mortgage worksheet?

The Excess Mortgage worksheet in the Individual module is based off the IRS Worksheet To Figure Your Qualified Loan Limit and Deductible Home Mortgage Interest for the Current Year from Pub 936. 

This worksheet is calculated using the amounts you enter in the Excess Mortgage Interest section.

  1. From the left of the screen, select the Itemized Deductions section
  2. From the top of the screen, select the Interest section
  3. Under Excess Mortgage Interest, complete all of the applicable input fields

How does ProConnect Tax calculate the Excess Mortgage worksheet?

I. Average Balance & Allocated Interest Worksheet

First, the program will complete the Average Balance & Allocated Interest Worksheet for each loan entered under Excess Mortgage Interest.

DescriptionInput field(s)
Beginning BalanceThis is the amount entered in Beginning of year field.
Borrowed in 2020This is the amount entered in Borrowed in 2020 field.
Principal AppliedThis is the Total principal paid, or the difference between the Total principal paid and the Lump sum principal payment (if paid off).
Ending Balance(Beginning Balance + Borrowed in 2020) - Principal Applied = Ending Balance
Average Balance([Beginning Balance + Ending Balance] ÷ 2)(Months outstanding) ÷ 12 = Average Balance
Allocated InterestView the Allocation of Interest to Type of Debt and Forms/Schedules worksheet for details.

II. Worksheet To Figure Your Qualified Loan Limit and Deductible Home Mortgage for 2023 (IRS Pub 936)

Once the program calculates the client's Average Balance & Allocated Interest Worksheet, it calculates the Worksheet To Figure Your Qualified Loan Limit and Deductible Home Mortgage for 2023 (IRS Pub 936).

Part I - Qualified Loan Limit

WorksheetDescriptionInput field(s)
1Average balance of pre-Oct 14, 1987 debtThis was calculated in the previous worksheet using the entry for Home Acq & pre-October 14, 1987 debt on date last debt secured.
2Average balance of home acquisition debt incurred prior to December 16, 2017This was calculated in the previous worksheet using the entries for the Home Acquisition Debt (proceeds used to buy, build or improve home) subsection.
3Enter $1,000,000 ($500,000 if married filing separate)N/A
4Enter the larger of line 1 or line 3N/A
5Add the amounts on line 1 and 2N/A
6Enter the smaller of line 4 or line 5

If you have no home acquisition debt incurred after December 15, 2017, or the amount on line 6 is greater than or equal to the line 8 limit, line 6 is your qualified loan limit. Enter this amount on line 11 and go to Part II, line 12. If you have home acquisition debt incurred after December 15, 2017, go to line 7.
N/A
7Average balance of home acquisition debt incurred after December 15, 2017This portion of the worksheet only appears if you entered a 1 in the 1=debt incurred after 12/15/17 field.
8Enter $750,000 ($375,000 if married filing separate)N/A
9Enter the larger of line 6 or line 8N/A
10Add the amounts on line 6 and 7N/A
11Qualified loan limit (smaller of line 9 or line 10)N/A

How to generate Part I of the Qualified Loan Limit and Deductible Home Mortgage Interest worksheet using the Excess Mortgage worksheet in ProConnect Tax.

Part II - Deductible Home Mortgage Interest

WorksheetDescriptionInput field(s)
12Total average balances of all mortgages from lines 1, 2, and 7 on all qualified homesThis is the total of average balance for Home Acq & pre-October 14, 1987 debt on date last debt secured and Home Acquisition Debt (proceeds used to buy, build or improve home).

If line 11 is equal to or more than line 12, all of the interest on all the mortgages included on line 12 is deductible as home mortgage interest on Schedule A.
13Total amount of interest paid on the loans from line 12This is the total Interest paid entered.
14Divide the amount on line 11 by the amount on line 12N/A
15Multiply line 13 by line 14. This is deductible home mortgage interest N/A
16Subtract line 15 from line 13. This is not home mortgage interestN/A

How to generate Part II of the Qualified Loan Limit and Deductible Home Mortgage Interest worksheet using the Excess Mortgage worksheet in ProConnect Tax.

III. Allocation of Interest to Type of Debt and Forms/Schedules

This section shows the total interest, excess home mortgage interest (HMI), and interest deductible as HMI, as well as where you reported the amounts.

IV. Allocation of Interest to Type of Debt and Forms/Schedules

This section shows the total points, excess points, and deductible points, as well as where you reported the amounts.

This section explains why ProConnect Tax overstates a loan on a refinanced home when calculating a taxpayer's average mortgage balance.

The overstatement occurs when:

  1. Excess Mortgage Interest inputs are added to the Itemized Deductions screen to calculate the average mortgage balance on a refinance.
  2. The program totals the loans, causing it to overstate a loan on a refinanced home.

How ProConnect Tax calculates average mortgage balance

The program calculates the average mortgage balance on more than one loan by using the "Average of first and last balance method."

  • It averages the first loan amount, averages the second loan amount, and then totals these loans to arrive at the average mortgage balance.
  • The total appears in the "Worksheet to Figure Qualified Loan Limit and Deductible Home Mortgage Interest For the Current Year (IRS Pub 936)."

Using the "interest paid divided by interest rate" method

However, with a refinance or in a situation where a home was sold and a new home purchased, the "Average of first and last balance" method won't correctly average the mortgages.

  • In this situation, the "Interest paid divided by interest rate method" should be used.
    • The calculation divides the interest paid in the year by the lowest interest rate for the year, resulting in the average balance for the year for loan one.
  • Do the same for each additional loan.
    • Enter each amount in the respective "Average balance [Override]" field.
    • The program will total these amounts and enter them in the worksheet.

Mr. Blue had a loan on his main home of $1,000,000 at an interest rate of 6% (0.06). He refinanced the home after the first four months of the year. During that time, he paid interest of $20,000 on the loan.

  • His average balance using the "Interest paid divided by interest rate method" method is $333,333, figured as follows:
    1. Enter interest paid: $20,000
    2. Enter the annual interest rate on the loan agreement: 0.06
    3. Divide the amount on line 1 by the amount on line 2: $333,333

The new refinanced loan is for $1,200,000 at an interest rate of 5% (0.05). The interest paid on this loan for the rest of the year (8 months) was $40,000. The average balance for this loan is $800,000.

  1. Enter interest paid: $40,000
  2. Enter the annual interest rate on the loan agreement: 0.05
  3. Divide the amount on line 1 by the amount on line 2: $800,000

These average balances are entered in the override field for each respective loan. The total of the two loans now equals $1,133,333, as reflected on the worksheet.

  • Use the same formula for a home sold during the year and a new home loan.
ProConnect Tax

Sign in now for personalized help

Ask questions, get answers, and join our large community of Intuit Accountants users.

Dynamic AdsDynamic Ads