Owner Financed Notes Tracker | Seller Financing Loan Spreadsheet (Excel & Google Sheets)

Track Owner-Financed Loans, Monitor Payments, and Keep Principal and Interest Organized

Designed for real estate investors, property owners, and private lenders who are the lender on owner-financed notes. Easily keep track of 20 Owner Financed Notes plus Loans you make to Yourself

See Individual Notes and your Complete Portfolio. Available in Excel & Google Sheets.

✅KEY FEATURES

• 20 individual Note tabs

• Notes Dashboard - bird's eye view of complete Portfolio

• Notes Income & Expenses summary by month and YTD

• Notes Profit & Loss Statement - Printable - great to hand to accountant/banks/investors

• Principal Summary

• Principal vs. Interest tracking

• Payment tracking

• Note-level income and expense tracking

• Owner Loan Tracker (Loans that you make to yourself)

✅ OWNER-FINANCED NOTE TRACKING

Each note can be used to track:

• Borrower information
• Property/collateral information
• Original Principal and Outstanding balance
• Principal & Interest payments
• Payment history
• Days Overdue, Missed Payments, Late Fees
• Automatic Color coded alerts for Payment Statuses - Paid, Partial, Late, Missed, Scheduled, Paid Off
• Automatically records expected Principal and Interest payments
• Override feature if Principal or Interest payment is different from expected
• Automatic warnings for negative balances, past-due notes, and payments that don't reconcile

✅ NOTES DASHBOARD

Bird's eye view of all your notes.

• Original principal
• Current principal outstanding
• Principal collected
• Interest collected
• Total payments received
• Note status
• Payment information

✅ PRINCIPAL PAYMENT TRACKING

The workbook keeps principal and interest separate.

Principal Summary tab helps you review principal collected across your notes.

✅ NOTES INCOME & EXPENSES

The Notes Income & Expenses tab automatically pulls in all Note related income and also allows you to record expenses associated with your notes.

Track items such as:

• Legal/document preparation
• Collection costs
• Recording fees
• Loan servicing fees
• Other note-related expenses

✅ NOTES Profit & Loss Statement

Automatically generated and printable

✅ OWNER LOAN / OWNER ADVANCES

Very useful when owner makes a loan or advance to himself, another account, or another entity he owns.

Track:

• Date
• Description
• Money advanced
• Money repaid
• Interest, if applicable
• Running balance
• Notes

This activity is kept separate from the owner-financed note P&L.

✅ WHAT'S INCLUDED

✔ 20 Owner-Financed Note tabs
✔ Notes Dashboard
✔ Notes Income & Expenses Summary
✔ Principal Summary
✔ Notes Profit & Loss Statement
✔ Owner Loans & Advances
✔ Excel & Google Sheets workbook. Contains no macros.

✅WHO IS THIS FOR?

This spreadsheet is useful for:

• Real estate investors carrying seller-financed notes
• Property owners providing owner financing
• Sellers who finance the sale of a property
• Private lenders
• Investors holding multiple notes
• Individuals tracking notes receivable
• Investors who need to separate principal from interest income

-------------------
SUPPORT
------------------

- I will be happy to provide support, answer questions and provide any customizations you may need.

The spreadsheet can be formatted as you like.
You will get both the Excel and Google Sheets files. You will get a file with sample data for reference and a blank file.
Download Instantly and use

This is copyrighted to MoneyUsage and is for your own personal use. It cannot be sold, shared or otherwise redistributed.