Owner financing payment ledger template
If you sold a property with owner financing, the payment ledger is the record of the note: every payment, the day it arrived, and how it was applied. Here is a free template to keep it in, and the mistakes that make a ledger fall apart over the years.
The file is a blank ledger with the column headings filled in. Open it in Excel, Numbers or LibreOffice, or in Google Sheets with File, then Import, then Upload. Save a copy for each note; one ledger should never hold two notes.
The columns, and how to fill them
| Column | What goes in it |
|---|---|
| Due date | The installment this payment is for, from the note's schedule. |
| Date received | The day the money actually arrived, not the date on the check. Interest is date-sensitive, so this is the date that matters. |
| Amount received | Exactly what came in, even if it is short or more than the scheduled payment. |
| Type | "Payment" for a regular installment, "Extra principal" for money meant to pay the balance down. |
| Method | Check, bank transfer, cash, money order. |
| Memo | A check number or a short note. Write down anything you agreed to, such as a waived late fee. |
| Late fee | The part of this payment applied to a late charge, if the note allows one. |
| Interest | The part applied to interest accrued since the last payment. |
| Principal | The part that reduced the balance. |
| Escrow | The part set aside for property taxes or insurance, if the note has escrow. |
| Balance after | The principal still owed once this payment is applied. |
Late fee, interest, principal and escrow should add up to the amount received. The order you fill them in is not up to you: it is set by the note, usually late fees first, then interest, then principal, then escrow. See why payment application order changes the balance.
Where spreadsheet ledgers go wrong
The arithmetic of one month is rarely the problem. What goes wrong is the record drifting over years, one small inconsistency at a time:
- Short payments applied differently each time. A partial payment in March goes to interest first; one in October gets split evenly. Each choice changes the balance, and nobody notices until a payoff request.
- Interest copied from the original schedule. The amortization schedule assumes every payment arrives on its due date. When payments arrive late or early, and the note accrues on actual days, the interest in each row has to come from the real dates.
- Waived late fees with no record. You let one slide, but the ledger still shows it owed, or the formula still charges it. Write the waiver in the memo column.
- Escrow mixed into principal. Money collected for taxes and insurance is not a payment on the loan. Keep it in its own column so the balance stays right.
- A formula that breaks silently. One row pasted as a value instead of a formula, or a range that stops one row short, and every balance after it is off. Check the balance against a fresh calculation once a year.
To check a balance as of a date, run the terms and the payments through the payoff calculator. To see what the schedule should look like, use the seller financing calculator.
What the ledger has to stand up to
A ledger is fine until someone else needs it: a title company asking for a payoff, a refinancing lender, a note buyer, a borrower who disputes the balance, or a court. Each of them will want a payment history that shows every payment, its date and how it was applied. See what a certified payment history is. In January your buyer may also need the year's interest total; see Form 1098 reporting for individual note holders.
When the spreadsheet stops being enough
OwnerNote does the work this template leaves to you. You log each payment as it arrives, and it applies every one the same way, keeps the balance current, produces payoff quotes good through any date, totals the year's interest, and prints statements for any period. If you have already kept a ledger, import it: OwnerNote reads the date received, amount received and type columns from this template and recalculates interest and principal from the note's terms, so you can compare its balance with yours. Rows that are only a late fee or escrow are not imported as payments.