ProConnect HelpIntuit HelpIntuit

Understanding excess home mortgage interest for individual federal Schedule A in Lacerte

by Intuit1 Updated 2 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.

Calculating excess home mortgage interest deductions

  • 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. Go to Screen 22, Depreciation.
      2. Under the section Asset Information, 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. Go to Screen 25, Itemized Deductions
      2. Under the section 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.

Entering excess home mortgage interest into Schedule A

  1. Go to Screen 25, Itemized Deductions.
  2. From the left sections, select Excess Mortgage Interest.
  3. Enter information for up to 4 loans.
  4. Check the Worksheets only checkbox to have Lacerte 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. In the field Total principal paid, enter the amount of principal paid on this loan in 2023. The entry is used to compute the ending balance of the loan, which is then used to compute the average balance of the loan. The average balance of the loan is needed for the respective types of debt on lines 1, 2, 7, and 12 of the Worksheet to Figure Qualified Loan Limit and Deductible Home Mortgage Interest.

Note: If the loan was paid off during the year, or was paid off through refinancing, enter the final lump sum principal amount paid in Lump sum principal payment (if paid off). Also enter the total amount of principal paid in Total Principal Paid and the number of months that this particular loan was outstanding in Months Outstanding (if not 12). When computing the average balance on a loan that was paid off, the program adds the beginning balance of the loan plus the lump sum principal payment, divides by two, and them multiples by the fraction represented by the number of months outstanding divided by 12.

Example:

Beginning Balance: $1,000,000

Total Principal Paid: $1,000,000

Lump Sum Principal Payment: $980,000

Months Outstanding: 6

The average balance is computed as ($1,000,000 + $980,000) / 2 x 6 /12, or $495,000.

What is the Excess Mortgage worksheet?

The Excess Mortgage worksheet in the Individual module of Lacerte 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 of Screen 25, Itemized Deductions. You should complete all of the applicable input fields.

How does Lacerte 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 in the Excess Mortgage Interest section of Screen 25, Itemized Deductions.

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 Lacerte.

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 Lacerte.

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.

These worksheets can't be e-filed. If you want to enclose the information on a statement, go to Screen 47, Notes and enter the appropriate information.

  • 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.
  • For more information on home mortgage interest rules, see Publication 936, Part II, Limits on Home Mortgage Interest Deduction.
Lacerte Tax 2017Lacerte Tax 2018Lacerte Tax 2019Lacerte Tax 2020Lacerte Tax 2021Lacerte Tax 2022Lacerte Tax 2023

Sign in now for personalized help

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

Dynamic AdsDynamic Ads