Amortization Schedule in Seller Financing: A Guide for Private Lenders in Puerto Rico

What an amortization schedule is and why it matters for seller financing

When you sell a property and carry the financing yourself, you become the bank. The amortization schedule is the document that governs the entire loan: it tells you how much of each monthly payment goes toward principal, how much goes toward interest, and what the outstanding balance is at any given moment. Without it, you have no way to know what the borrower truly owes you at any point in time.

In a bank mortgage, the lender generates this schedule automatically and sends the borrower a year-end statement. As a private lender, that job falls to you. You need an accurate schedule from day one, and you need to keep it current every time a payment arrives, arrives late, or deviates from the original terms. Your Form 480.7A for Hacienda and your Form 1098 for the IRS are both built directly from this schedule — if the numbers are wrong, your tax forms are wrong.

How each monthly payment splits between principal and interest

Every payment in an amortized loan covers two things: the interest that accrued on the outstanding balance since the last payment, and a portion of the principal that reduces what the borrower owes. The monthly interest is calculated as the outstanding balance multiplied by the annual interest rate, divided by 12. The remainder of the fixed monthly payment goes to principal.

The key insight is that this split is not constant. In the early months of the loan, most of the payment is interest — because the balance is high and interest accrues on the full outstanding amount. As the borrower makes payments and the balance shrinks, the interest portion gradually falls and the principal portion grows. By the final payments of a long-term loan, the vast majority of each payment is principal. This is why sellers often say the borrower "barely touches the principal" in the first few years: it is a mathematical consequence of standard amortization, not a flaw in the terms.

This structure has a real implication for your tax reporting. The interest income you must report to the IRS and to Hacienda is highest in the early years of the loan and declines over time. If you are tracking interest manually and applying the same amount every month, your tax forms will be incorrect from year one.

A practical example: amortization on a Puerto Rico seller-financed property

Consider a $150,000 seller-financed mortgage at 7% annual interest, amortized over 30 years. The monthly principal-and-interest payment works out to approximately $998. In the very first payment, the interest portion is $150,000 × 0.07 ÷ 12, which equals $875. The principal portion is $998 minus $875, which is $123. The outstanding balance drops to $149,877.

By the twelfth payment, the balance has fallen modestly, so the interest portion on that payment is slightly lower, the principal portion is slightly higher, and the balance continues its slow decline. This progression continues every month for the life of the loan. Across the full amortization schedule, the lender will collect the $150,000 in principal plus a substantial amount in interest — with every single dollar accounted for in the schedule.

For a private lender in Puerto Rico, this matters in a very practical way. Every year, the interest column from your amortization schedule is what you report on Form 480.7A to Hacienda and on Form 1098 to the IRS. Those forms go to your borrower so they can claim the deduction on their own tax return. If your schedule is off, both your return and theirs will be incorrect.

Balloon payments and how they appear in the schedule

Seller-financed mortgages in Puerto Rico commonly use a balloon payment structure: the loan is amortized as if it were a 25 or 30-year mortgage, producing manageable monthly payments, but the full remaining balance becomes due at a set date — typically five to ten years from closing. This structure lets the buyer make affordable payments while giving the seller a clear horizon for recovering the principal.

In the amortization schedule, a balloon payment appears as a final entry that is far larger than any regular monthly payment. In the example above, if the loan has a 5-year balloon, the borrower makes 60 regular monthly payments of approximately $998 and then owes the full outstanding balance as a lump sum on month 61. That balance will have declined from the original $150,000 — but not by much, because standard amortization front-loads interest, and most of the first five years of payments goes toward interest rather than principal.

The balloon entry must be tracked in your schedule just like every other payment. If the borrower refinances and pays the balloon early, you need to record the date, apply any final interest that accrued since the last regular payment, and confirm the balance reaches zero. That final entry is the basis for the payoff letter, the mortgage satisfaction, and your final-year tax reporting.

What happens when a payment is late or extra principal is paid

A standard amortization schedule assumes payments arrive on exactly the right date every month. In practice, they rarely do. When a borrower pays a few days late, interest accrues for those extra days on the outstanding balance, and the principal reduction for that payment is slightly smaller than the schedule assumed. If you do not adjust for this, every subsequent payment in the schedule is slightly off. By year-end, your cumulative interest figure — and therefore your 480.7A and 1098 — will not match what actually happened.

Extra principal payments are the opposite situation. If a borrower makes a lump-sum payment toward the principal in addition to their regular payment, the balance drops faster than the schedule anticipated. From that point forward, every monthly payment generates less interest and more principal than the original schedule shows. The entire schedule must be recalculated from the date of the extra payment forward.

These adjustments are straightforward in theory but error-prone in practice, especially in a spreadsheet. One formula error in month 8 quietly corrupts every subsequent row. By the time you generate your year-end tax forms, you may not realize the numbers are wrong until your CPA flags the discrepancy.

Tracking your amortization schedule without spreadsheets

Spreadsheets are the default starting point for most private lenders, and they work reasonably well for the first few months of a straightforward loan. The problems begin the moment the loan deviates from perfect conditions: a late payment, an early extra principal payment, a partial payment in one month, or a balloon that needs to be tracked alongside regular entries. Each deviation requires manual recalculation, and manual recalculations accumulate errors.

Purpose-built tools like Lend. generate the amortization schedule automatically from the loan terms you enter at setup. When a payment arrives via ATH Móvil, Zelle, or ACH, it is matched to the correct billing period and the schedule updates accordingly. If the borrower pays late, the system accounts for the extra interest accrual. If they make an extra principal payment, the remaining schedule is recalculated automatically.

At year-end, the interest column from your schedule feeds directly into Form 480.7A for Hacienda and Form 1098 for the IRS — no manual transcription, no reconciliation between your records and what you reported last year. Your borrower gets their own portal to view the schedule and download their forms. For private lenders who want accurate records without spending hours in spreadsheets each month, that combination of automatic tracking and built-in tax compliance is the practical answer.