Create a Mortgage Statement for a Private or Seller Loan
Quick Answer: To create a mortgage statement for a private or seller-financed loan, keep a payment ledger in a spreadsheet and print a one-page statement from it each month: amount due and due date, late fee terms, how the payment splits between principal, interest and escrow, payments received this period and this year, recent transactions, principal balance, interest rate and your contact details. Federal Regulation Z sets that layout for creditors and servicers it covers, and it is a sound model even if it doesn't bind you. At year end, give the borrower the total interest paid.
If you financed the sale of a house or lent money secured by someone's home, the borrower needs a regular record of what they owe and what you've credited. A good mortgage statement comes out of a payment ledger, not a word processor: every payment is entered once, and the statement, the year-end interest figure and your own books all read from the same rows.
Drop your bank statement here
PDF or OFX · Max 4.4 MB
Uploaded over an encrypted connection. We never ask for your bank login. Privacy
Preview free with no account. Free account to download.
Do you have to send a mortgage statement as a private lender?
Possibly not under federal law, but check before you assume. Regulation Z's periodic statement rule, 12 CFR 1026.41, applies to closed-end consumer credit secured by a dwelling, and the duty falls on the "creditor, assignee, or servicer." Two definitions decide whether that is you:
- Are you a creditor at all? Under 12 CFR 1026.2(a)(17), a person "regularly extends" credit secured by a dwelling only if it did so more than 5 times in the preceding calendar year (or the current year, if it didn't meet the test last year). Separate, stricter counting applies to high-cost mortgages under section 1026.32: more than one in any 12 months, or even one arranged through a mortgage broker.
- Are you a small servicer? Section 1026.41(e)(4) exempts loans serviced by a small servicer, defined as one that services, together with affiliates, 5,000 or fewer mortgage loans, all of which it or an affiliate originated or owns.
Someone who sold one house on a note is usually outside both. A real estate investor who finances many sales a year may not be, and state law can add its own requirements for statements, escrow and payoff letters regardless of Regulation Z. If you are close to either line, or the loan is high-cost, have a real estate attorney review it.
There is a separate set of seller-financing exclusions in 12 CFR 1026.36, about whether you count as a loan originator rather than about statements. They describe terms worth building into the note anyway: a person financing three or fewer properties in 12 months must use financing that fully amortizes, is based on a good-faith determination that the buyer can repay, and has a fixed rate or one that adjusts only after five or more years. A natural person, estate or trust financing a single property in 12 months has similar conditions, with no negative amortization in place of the full-amortization and ability-to-repay tests.
What goes on each monthly statement?
Use section 1026.41(d) as your checklist. The rule groups items so the borrower finds the money figures first. Here is each group with the spreadsheet column it comes from.
| Statement section | What it shows | Where your spreadsheet gets it |
|---|---|---|
| Amount due (top of page 1) | Due date, late fee and the date it applies, amount due shown most prominently | Schedule row for the coming month; note terms |
| Explanation of amount due | Regular payment split into principal, interest and escrow; fees since last statement; any past-due amount | Schedule row plus any unpaid balance in the ledger |
| Past payment breakdown | Payments since the last statement and year to date, each split into principal, interest, escrow, fees and unapplied funds | SUMIFS over the ledger by date range |
| Transaction activity | Every credit or debit to the amount due since the last statement: date, description, amount | Ledger rows dated in the period |
| Partial payment note | What the borrower must do for held funds to be applied | Your suspense column, if not zero |
| Contact information | A phone number and, if you have one, an email address | Fixed text |
| Account information | Principal balance, current rate, next rate change date, any prepayment penalty, housing counselor contacts | Ledger balance; note terms |
| Delinquency notice | Required by the rule once a borrower is more than 45 days behind: length of delinquency, risks, six-month history, amount to bring current | Ledger history |
Items that don't apply can be left off: if the note has no prepayment penalty, you don't need that line. The rule also allows a coupon book in place of monthly statements for fixed-rate loans, provided each coupon shows the amount-due items, the book carries the account and contact details, and you make the payment breakdowns available on request; for many small lenders, a simple monthly page is easier to keep accurate.
How do you build the statement from an amortization spreadsheet?
Three sheets in one workbook keep everything consistent.
- Terms sheet. Principal, annual rate, term in months, first due date, monthly escrow if you collect it, grace period and late fee from the note. Compute the scheduled payment with Excel's PMT function:
=PMT(rate/12, months, -principal). Microsoft notes that PMT returns principal and interest only, with no taxes or reserve payments, so add escrow separately. - Schedule sheet. One row per scheduled payment: due date, beginning balance, interest, principal, ending balance. IPMT gives the interest part of any period. This is the plan, not the record.
- Ledger sheet. One row per payment actually received: date received, amount, interest applied, principal applied, escrow, late fee, unapplied funds, running balance. When payments arrive on time and in full, the ledger matches the schedule. When they don't, the ledger is the truth, and every statement reads from it.
A worked example: a $180,000 note at 7% over 30 years has a scheduled payment of $1,197.54 for principal and interest. The first payment applies $1,050.00 to interest ($180,000 × 7% ÷ 12) and $147.54 to principal, leaving $179,852.46. If you collect $300 for taxes and insurance, the amount due on the statement is $1,497.54, with the three parts shown separately.
Then build a one-page statement sheet that takes a statement date as its only input and pulls everything else with lookups and SUMIFS from the ledger. Save it as PDF each month, send it, and keep the PDF. Check the note: if it calculates interest daily rather than monthly, the interest column has to use days between payments, and your schedule will drift from the ledger whenever a payment is early or late.
How should you handle late, partial and extra payments?
These are where homemade statements usually go wrong, so decide the rules once and apply them the same way every time.
- Late payments. Charge only what the note allows, after the grace period it states, and show the fee as its own transaction with the date it was imposed.
- Partial payments. Regulation Z's commentary describes holding a short payment in a suspense or unapplied funds account until it adds up to a full payment, then applying it. If you do the same, show the held amount on the statement and tell the borrower what is needed to apply it.
- Extra principal. Apply it the day it arrives, show it as a separate line, and let the schedule recalculate from the new balance.
What year-end statement do you owe the borrower?
Form 1098 depends on why you received the interest, not on whether you are a bank. The IRS Instructions for Form 1098 say you must file if you receive $600 or more of mortgage interest in a year from an individual in the course of your trade or business, even if lending isn't your business, and the $600 test applies to each mortgage separately. The IRS example: a real estate developer who finances a home in its subdivision must file; a physician who lends money to someone buying the physician's own home does not, because the interest wasn't received in the physician's trade or business. If you file, you must also furnish a statement to the borrower.
Even when you don't file a 1098, the borrower needs the year's interest figure. IRS Publication 936 tells a buyer who paid mortgage interest to the person they bought the home from to deduct it on Schedule A line 8b and to show that seller's name, address and taxpayer identification number. The seller must provide the number, the buyer must give the seller theirs, Form W-9 can be used for the exchange, and each failure can carry a $50 penalty. Send a January summary showing total interest, principal and escrow paid, straight from the ledger's year-to-date totals, and swap W-9s at closing. The interest you received is also income to you; ask your tax preparer how to report it.
How do you keep records that hold up?
Your ledger is only as good as its match to the money. Each month, tick every payment against the deposit in your bank account. If the bank only gives you PDF statements, QuickBankConvert turns them into spreadsheet rows you can paste next to the ledger, or use the bank's own CSV export if it has one; the PDF to Excel guide compares the options. A year of reconciled deposits, the statements you sent and the year-end summary together answer most questions a borrower, buyer's lender or tax preparer will ask.
When the loan is eventually paid off or refinanced, the same ledger produces the payoff figure; our guide to mortgage payoff statements covers what those normally show.
Related guides
Frequently Asked Questions
Do I need to send monthly statements on a seller-financed mortgage?
Federal Regulation Z's statement rule usually doesn't reach someone who finances one or a few homes, because of its creditor definition and small servicer exemption. State law or the note itself may still require statements, so check with an attorney.
Is there a free mortgage statement template?
The CFPB's Regulation Z includes sample periodic statement forms in appendix H-30. Copying their section order in your own spreadsheet gives the borrower a familiar layout.
Do I have to issue a Form 1098 as a private lender?
Only if you receive $600 or more of mortgage interest on that mortgage in the course of a trade or business. An individual selling their own home on a note generally isn't required to, but should still give the buyer a year-end interest total.
What does the buyer need from me at tax time?
The total interest paid for the year plus your name, address and taxpayer identification number, which they enter on Schedule A line 8b. Exchanging Form W-9s at closing covers the numbers.
Should I calculate interest monthly or daily?
Follow the note. Monthly calculation matches a standard amortization schedule; daily calculation means each payment's interest depends on the days since the previous payment.
Ready to convert your bank statement?
Free to preview. No bank login. Results in about a minute.
Convert a statement