Guide

How to Track a Seller-Financed Loan

When you sell a property and carry the note yourself, you become the record keeper. This guide covers what to track, how to keep both sides on the same page, and how to be ready for tax time.

Start with the terms in one place

Everything downstream depends on the terms from your promissory note: the amount financed, annual interest rate, term length, payment amount, first payment date, any down payment, grace period, late fee (fixed or percentage), and any prepayment penalty. Write them down in one authoritative place — not scattered across emails and closing documents. Every dispute you avoid later starts with clear terms recorded now.

Build the amortization schedule

The amortization schedule is your source of truth: it lists every payment for the life of the loan and splits each one between interest and principal. That split matters more than most new note holders expect — interest is income to you, principal is not, and the ratio shifts every single month. You can generate a complete schedule with our free amortization calculator — no account needed.

Record every payment as you receive it

Payments in seller financing move directly between buyer and seller — a check in the mail, a bank transfer, however you two arranged it. The bookkeeping burden is on you: for each payment, record the date received, the amount, and mark it against the scheduled payment it covers. Do it when the payment arrives, not months later from memory. Partial payments deserve special care: note the shortfall so it doesn't silently disappear.

Handle late payments consistently

Decide your grace period and late fee policy up front (it should already be in the note), then apply it the same way every time. Consistency protects the relationship — a fee applied to one late payment but waived on the next, with no record of why, breeds resentment. Whatever you decide, the record should show the original amount due, the fee applied, and what was actually received.

Keep both sides looking at the same numbers

Most friction between a note holder and a buyer isn't bad faith — it's two spreadsheets that disagree. If your buyer can see the same schedule, the same payment history, and the same remaining balance you see, most disagreements never start. Whether that's a shared document or a borrower portal, a single shared record is the cheapest peace of mind available to a private lender.

Be ready for tax time

At year-end you'll need your total interest received for the calendar year — grouped by when payments were actually received, not when they were due. If the sale was structured as an installment sale, your preparer may also need the principal received to calculate gain recognition. Keep those running totals as you go and January becomes a formality. (LoanLoop provides informational summaries, not tax advice — which forms apply to you is a question for your CPA.)

Spreadsheet or software?

A spreadsheet genuinely works for a single loan, if you're disciplined about updating it. Its weaknesses show over time: one formula typo compounds silently for years, a forgotten payment entry becomes a dispute, and the buyer has no visibility into what you've recorded. Purpose-built tracking removes those failure modes — the schedule is generated, payment records are timestamped, and both parties see the same numbers.