Mastering Loan Amortization: PMT, IPMT & PPMT

Loans are more than a single monthly payment. To correctly record interest expense and principal reduction in your books, you must break that payment apart.

The Essential Trio

Every loan payment has two parts: Interest (the cost of borrowing) and Principal (the reduction of the debt). Use these functions to build your schedule:

The Logic of an Amortization Schedule

To record payroll or loan entries, you need a schedule where the interest expense declines each month as the principal is paid down:

PeriodPaymentInterestPrincipalBalance
1$500$100$400$9,600
2$500$96$404$9,196

Accounting Implementation

When you make the payment, your journal entry is:

Debit: Interest Expense (IPMT result)
Debit: Notes Payable (PPMT result)
Credit: Cash (PMT result)

Common Mistakes

Build your own loan amortization schedule here.