How to understand a loan amortization schedule
The payment-by-payment breakdown of a loan into principal and interest. It is a worksheet, not a line on the statements.
Definition
A loan amortization schedule is the table that splits each installment into principal and interest. On the books, this is a worksheet, not a statement line and not an account you post to.
Each row is one payment date. Anyone posting the installment should see how much reduces the note and how much is the cost of the money.
A cider mill uses it so a press loan is not treated as one flat expense. The note on the Balance Sheet is the remaining principal; this list is the split.
Where it shows up
Balance Sheet: Related to the note this schedule splits into current and longer-term.
P&L: Related to the interest piece of each payment.
See also: Principal Payment · Interest Expense · Debt Schedule
When you look at your Balance Sheet, you will not see this schedule as a line. You see Notes Payable and the current slice of that note, and this worksheet supports those numbers.
The profit and loss statement does not list the schedule either. The related charge is the interest the schedule assigns to this period.
A close binder or a shared spreadsheet is where the schedule usually lives. It is working paper, not a general-ledger account.
Early rows with a high interest piece usually mean the loan is still young. Later rows with a high principal piece usually mean most of the remaining payment is paying the note down.
How it works
Start with the note: amount, rate, payment, and term. The schedule then lists every installment until the remaining principal is zero.
Each row shows the payment, the interest piece, the Principal Payment, and the leftover balance. You do not invent those splits at the keyboard; you read them from this table.
The principal column is what drops Notes Payable. The interest column is the P&L cost for that period.
The next twelve months of the principal column is how you size Current Portion Of Long-Term Debt. The rest of the leftover balance stays longer-term.
If interest has built up but has not been paid yet, that leftover may sit as Accrued Interest Payable. The schedule still tells you the contractual split when the installment is due.
A Debt Schedule may list several notes. This worksheet is the payment-by-payment math for one of them.
If the rate or the payment changes, you rebuild the remaining rows going forward. You do not rewrite prior periods from this worksheet.
The leftover-balance column after the last posted row should equal the note on the books. If they disagree, a payment was skipped or posted to the wrong account.
Example
A cider mill borrows $36,000 for a new press. The loan amortization schedule puts that note on a table, with each $700 installment split into pieces.
This month's row says $200 is interest and $500 is principal. That row is how the mill sizes both halves of the check.
The mill records the interest piece:
Debit: Interest expense $200
Credit: Cash $200
Interest expense hits the P&L by $200, and cash falls by $200. The note has not moved yet.
The mill then records the principal piece:
Debit: Notes payable $500
Credit: Cash $500
Notes Payable falls by $500, and cash falls by another $500. The Income Statement has not taken the $500 as a cost.
The schedule's leftover column now shows $35,500. Next month's row will split the following $700 the same way.
Common mix-ups
A loan amortization schedule is not a Debt Schedule. The debt schedule is the portfolio of every note; this table is the payment-by-payment split for one loan.
The schedule is not Notes Payable. The note is the Balance Sheet account; the schedule is the worksheet that tells you how each check hits that account.
The schedule is not interest expense. Interest is the P&L charge; this table is the support that sizes that charge and the principal piece beside it.
Related terms
- Principal Payment: The portion of a loan payment that reduces the balance owed.
- Interest Expense: The cost of borrowing recorded for the period.
- Notes Payable: Formal loan balances owed to a bank or other lender.
- Debt Schedule: A supporting schedule tracking each loan's balance, payments, rate, and maturity.
- Current Portion Of Long-Term Debt: The slice of loan principal due within the next twelve months.
- Accrued Interest Payable: Interest that has built up on debt but has not yet been paid.
- Journal Entry: A dated record of debits and credits posted to the ledger.
- Cash Flow From Financing: Cash from borrowing, repayment, owner contributions, and distributions.