The problem
Tracking payments and balances in a spreadsheet, and re-doing the math by hand every time a buyer pays early or short.
Amortization + payment waterfall
The integer-cents engine builds the full schedule and applies every payment across principal, interest, escrow, fees, and suspense in the order set for the loan. Extra principal shortens the note automatically; a short payment re-projects the remaining schedule from the real balance.