Five starting points for the work after closing
These are the spreadsheets a real hard-money servicing model started from. They are useful on day one — and useful as a map of exactly where a workbook stops keeping up.
| Template | What it does well | Where it breaks |
|---|---|---|
| Monthly-close checklist | Enforces a repeatable sequence | Can't lock a closed month |
| Borrower-invoice layout | Clean interest, reserve, fee, tax lines | No dated history behind a changed rate |
| Investor-statement layout | Principal, interest, distributions per investor | Non-pro-rata shares drift out of sync |
| Interest-reserve schedule | Funded balance, draw, depletion | Manual draws desync from actual interest |
| Payoff worksheet | Itemized payoff + per diem | Per diem hand-typed, easy to mis-date |
A quick worked check
The payoff worksheet is the one to sanity-test first. On a $400,000 loan at 12.00% (Actual/365):
Calculation
$400,000 × 12% ÷ 365 = $131.51 / day
If your worksheet's per-diem cell does not return $131.51, its day-count formula is wrong — and every payoff it has ever produced is off by the same error.
$131.51 / day
The correct per diem on a $400,000 loan at 12.00% (Actual/365). If your worksheet returns anything else, its day-count formula is wrong.
Note
Use them, or use them to leave them: the templates work for a handful of loans. The day the reserve schedule, the investor shares, and a locked month all matter at once is the day a spreadsheet becomes the liability.
How to use the pack
Start with the monthly-close checklist — it sets the order everything else runs in. Use the invoice and statement layouts to standardize what borrowers and investors see, the reserve schedule to project depletion before a borrower's first out-of-pocket month, and the payoff worksheet whenever a loan exits. They share one set of assumptions, so a figure you reconcile in one carries into the next. The month you find yourself maintaining five linked workbooks by hand is the month the pack has done its real job — showing you exactly what to move into software.
Where LoanConsole fits
The templates come from the same working model LoanConsole was built from. When the spreadsheet stops keeping up, LoanConsole carries the same logic into software — with history, reconciliation, and a month that actually closes.
Note
These templates are operational examples, not legal, tax, accounting, or regulatory advice. Review them against your documents before use.