Escrow Shortage & Surplus Calculator
Run the numbers for a 12-month projection.
Use resource →NEW PRACTICAL RESOURCES
Free, focused worksheets for payoff dates, account statements, escrow projections and certified payroll.
Run the numbers for a 12-month projection.
Use resource →Calculate and print with actual dated payments.
Use resource →Estimate covered wages and fringe components.
Use resource →Expanded guide library
Learn how to build loan schedules, manage private-loan payment records, track principal and interest, calculate balances, review payoff questions, and understand seller financing.
Preparing weekly certified payroll for a Davis-Bacon project? Review the WH-347 requirements, then try our Windows software for Excel/CSV import and WH-347 PDF preparation.
WH-347 certified payroll guide → · WH-347 certified payroll software & free demo →New loan workflow guides
These guides cover payment coupon books, escrow analysis, and loan reconciliation using the same practical tasks the Windows programs are designed to handle.
What to include on payment coupons and how to organize a borrower coupon book.
Read guide →Understand the 12-month aggregate trial balance, expected disbursements, and cushion.
Read guide →Rebuild a loan when actual payments differ from the original amortization schedule.
Read guide →Using coupon books for seller financing and private loans.
Read guide →How to interpret the result of an escrow analysis.
Read guide →Why the original schedule may not give the correct payoff amount.
Read guide →24 focused guides
Each guide covers one specific concept and links to calculators or software when a numerical schedule helps.
Private lending
Record actual payments, balances, principal, interest, and year-end activity after a private loan is made.
Build a dependable payment and balance record.
Know which fields belong in an auditable loan ledger.
Calculate a reproducible historical balance.
Track the payment split and year-end totals.
Know when a spreadsheet stops being enough.
Understand scheduled payments and balloon balances.
Calculate a payment and follow the first schedule rows.
Read guide →Follow the first payment and the shift from interest to principal.
Read guide →Audit rates, dates, frequencies, rounding, and extra payments.
Read guide →Compare a fixed principal simple-interest example with a declining-balance loan.
Read guide →Separate repayment mechanics from interest-on-interest growth.
Read guide →Convert a quoted nominal rate to an effective annual rate.
Read guide →Understand two rates that use different bases.
Read guide →See how day counts and actual dates change interest.
Read guide →See a loan change from one rate to another.
Read guide →Understand reset dates, indexes, caps, and recalculation.
Read guide →Separate contractual dollars from purchasing-power effects.
Read guide →See how one principal payment changes interest and payoff.
Read guide →Compare remaining principal with future interest.
Read guide →Compare monthly and accelerated biweekly structures.
Read guide →Compare the old remaining loan with proposed new terms.
Read guide →Calculate the balance due at an early maturity date.
Read guide →Learn when payments hold principal steady or let it grow.
Read guide →Track private notes, payments, and balloon balances.
Read guide →Separate taxes and insurance from principal-and-interest amortization.
Read guide →Review the branded Windows product page for version details, editing features, evaluation limits, and $49 licensing.
Review Amortization Pro →Software comparison
Review current pricing, platforms, schedule flexibility, reports, exports, and evaluation options using facts from each developer's official website.
Use the free online calculator or download the Windows evaluation.
Use all 40 free calculators for payments, extra principal, payoff, daily interest, mortgages, debt, savings, investing, balloon balances, Rule of 78, and more.
Popular daily-interest tools: Daily Interest & Per Diem · Mortgage Per Diem · Interest Between Dates · Payoff Per Diem