Resources
Field guides for servicing a private loan book.
How to service a private loan book — boarding to payoff, worked in detail.
Private-lending servicing templates
The spreadsheets we started from — invoice and statement layouts, a reserve schedule, a monthly-close checklist, and a payoff worksheet. Use them, or use them as a reason to leave them.
Get the templatesBuilt from a working hard-money servicing model.
LoanConsole started from a working Excel servicing model built for a hard-money lender. The guides here come from the same practical questions: how to calculate the month, preserve a change, explain a payoff, report to an investor, and know when the book is actually closed.
See how servicing works →Boarding & setup
imports · terms · reservesHow to import a private loan book from Excel without importing the mess
A practical boarding sequence for loans, borrowers, investors, reserves, payments, and opening balances — with validation before anything commits.
Actual/365, Actual/360, and 30/360: why the same rate produces different interest
One $500,000 loan under three conventions — where the daily, monthly, payoff, and effective-rate differences come from.
Interest reserves for private real-estate loans: funding, depletion, and borrower shortfall
How to distinguish the funded balance, planned draw, actual reserve movement, projected depletion, and the amount the borrower must cover.
Monthly servicing
invoicing · payments · closeThe monthly close checklist for loan servicing
A repeatable sequence for posting receipts, reviewing accruals, reconciling investor activity, working exceptions, and locking the period.
Amount due vs. accrued interest: what a private-loan statement should show
Why current amount due, unpaid billed interest, and economic accrual are different figures — and when a borrower statement should show one, two, or all three.
Late fees and delinquency: a servicing workflow for private lenders
A practical sequence for identifying an overdue amount, applying the configured grace period and fee, documenting contact, and preserving reversals.
Changes & exceptions
extensions · ownership · collateralHow to extend or work out a private loan without losing its history
A servicing framework for extensions, rate changes, forbearance, deferral, capitalization, advances, and paydowns as dated events.
Investor changes mid-loan: assignments, buyouts, advances, and recapitalizations
How to preserve ownership and capital history when investors enter, exit, transfer, or contribute on a non-pro-rata basis.
Insurance and collateral follow-up after a private loan closes
What to track about the property, coverage status, expiration, documents, and follow-up — without turning servicing software into construction management.
Reporting & close
investors · payoff · year-endInvestor reporting for private lenders: due, accrued, paid, and returned
A working statement and reporting cadence that keeps current earnings, unpaid accrual, distributions, and principal activity from collapsing into one number.
Payoff letters and the per-diem
How a payoff is itemized, and why the daily interest figure has to be exact.
Year-end records vs. tax advice
What a reconciliation package is for — and where your accountant takes over.