What is loan amortization meaning in accounting, and how does it differ from depreciation?

Loan amortization describes how a fixed-payment loan splits each installment between interest expense and principal reduction over time, with interest calculated on the declining outstanding balance each period. Depreciation applies to physical assets and often uses accelerated methods that front-load expense recognition, while loan amortization follows the same straight-line payment structure every period. The practical rule for bookkeepers: a debit against a physical asset is depreciation; reducing a loan liability balance is amortization.

What's the fastest way to build a loan amortization schedule without Excel formula errors?

The fastest approach is a purpose-built loan amortization tool that auto-calculates the principal and interest split, posts the journal entries directly to your general ledger, and keeps the schedule matched to your Loan Payable balance throughout the close. Spreadsheet-based schedules carry real failure modes: a dragged formula overwrites a fixed rate cell, or the file lives in a preparer's personal folder with no audit trail. Double's Accruals and Prepaids Management feature handles loan amortization schedules directly inside the close workflow, calculating recognition amounts and posting interest-adjusting journal entries automatically so the GL-to-schedule reconciliation runs without a manual line-by-line comparison each month.

How do I match a loan payable GL balance to the amortization schedule during month-end close?

Pull the schedule's ending balance for the period and compare it against the Loan Payable GL balance before marking the close complete. Trace any variance back to the specific journal entry, checking that the interest and principal split matches the schedule's columns for that period exactly. Document the root cause on the reconciliation workpaper, and treat any uncleared gap left open past the current close as a required escalation before the next period's interest calculation runs. Carrying a variance forward compounds the error in every subsequent period.

Amortizing loan vs. non-amortizing loan: which journal entries are different?

With an amortizing loan, each payment generates two debits: one to Loan Payable for the principal portion and one to Interest Expense for the interest portion, offset by a single credit to Cash. With an interest-only line of credit, the full payment goes to Interest Expense with no debit to Loan Payable, so the liability balance stays flat. Balloon loans follow the standard amortization split for periodic payments but require a final line item in the schedule for the lump-sum payoff; missing that line leaves Loan Payable overstated right up to maturity.

Can a free amortization calculator replace a dedicated close tool for managing multiple loans?

A free amortization calculator generates a payment schedule, but it stops there. It has no connection to your general ledger, no audit trail, and no mechanism to flag when the GL balance drifts from the schedule mid-close. For a single loan, a standalone calculator may be enough. For firms managing multiple clients each carrying several debt obligations, the manual reconciliation step repeats across the entire portfolio every close period, turning amortization into a recurring source of delays. A close tool with native loan amortization support, like Double, handles the schedule creation, journal entry preparation, and GL-to-schedule verification in one workflow.

What is the loan amortization formula, and how do you convert an annual rate for monthly calculations?

The periodic payment formula is M = P × [r(1+r)^n] / [(1+r)^n - 1], where P is the principal, r is the monthly interest rate, and n is the total number of payments. The most common setup error is plugging an annual rate directly into the formula — divide the annual rate by 12 first to get r, and confirm n reflects months, not years. Getting those two conversions right before solving prevents every downstream schedule error.

How does a personal loan amortization calculator differ from a car loan amortization calculator?

The underlying math is identical — both apply the same fixed-payment formula splitting each installment between interest and principal. The practical difference is in how each schedule gets used: car loan amortization calculators often include a down payment field and may factor in sales tax or dealer fees before calculating the financed amount, while personal loan calculators typically start from the disbursed principal. For bookkeeping purposes, what matters is the financed balance and the rate — not the loan label.

When should you record a period-end interest accrual versus waiting for the next payment?

Record an interest accrual whenever a loan payment date falls outside the current reporting period and interest has accrued but remains unpaid by close. Debit Interest Expense and credit Interest Payable for the days of interest earned in the period, even though no cash has moved yet. Skipping this entry understates liabilities and misstates interest expense for the period — a common error that shows up in GL-to-schedule reconciliation when the Loan Payable balance appears correct but Interest Payable is missing.

What does a monthly loan amortization schedule with extra payments look like in the general ledger?

Each extra payment reduces the Loan Payable balance by the additional principal amount only — there is no additional interest expense because the extra payment goes entirely toward principal. In the general ledger, you debit Loan Payable and credit Cash for the extra amount, then recalculate the remaining schedule from the new lower balance. If the schedule is not updated to reflect the prepayment, every subsequent period's interest calculation will be overstated, and the GL-to-schedule reconciliation will show a growing variance.

Can I build a free amortization schedule in Excel that posts directly to QuickBooks without manual re-entry?

A spreadsheet can generate an accurate amortization schedule with fixed monthly payments, but it has no mechanism to post the resulting journal entries to QuickBooks Online directly — that step remains manual. The risk compounds across a client portfolio: a dragged formula overwrites a rate cell, or the file lives in one preparer's folder with no audit trail. Double's loan amortization feature calculates the principal and interest split automatically, posts the interest-adjusting journal entries directly to the ledger, and keeps the Loan Payable balance matched to the schedule without a separate spreadsheet.

How do you handle a loan amortization schedule in Excel when there is a moratorium period at the start?

A moratorium period — where no principal payments are required for an initial stretch — means the schedule needs a separate section before amortization begins. During the moratorium, each row records only the accrued interest with no principal reduction, leaving the Loan Payable balance flat. When the amortization period begins, recalculate the fixed payment using the original principal (since it has not changed), the remaining term, and the periodic rate. In the GL, moratorium-period entries debit Interest Expense and credit Interest Payable or Cash, with no debit to Loan Payable until principal payments start.

What is the right GL account structure for loan amortization — should long-term debt sit in one account or split between current and non-current?

Best practice is to split the Loan Payable balance at each year-end into a current portion (principal due within 12 months) and a long-term portion (the remainder), reflecting the correct balance sheet classification under accrual accounting. You calculate the current portion by summing the principal column of the amortization schedule for the next 12 payment periods. Mid-year, the full balance can sit in one Loan Payable account, but a reclassification journal entry at period-end ensures the balance sheet presentation meets standard reporting requirements.

How does amortization definition in accounting apply differently to intangible assets versus loan principal?

In accounting, amortization refers to the systematic allocation of a cost over time — but the mechanics diverge sharply depending on what is being amortized. For intangible assets, amortization spreads the acquisition cost across the asset's useful life with no residual value assumed and almost always uses the straight-line method. For loan principal, amortization describes the process of reducing the outstanding liability through scheduled payments, where the split between interest expense and principal repayment shifts each period as the balance falls. Both use the word amortization, but only the loan version creates a liability reduction on the balance sheet alongside an income statement charge.

Should I use a simple interest loan calculator payment schedule or a standard amortizing loan calculator for my client's line of credit?

Use a simple interest schedule only if the loan agreement explicitly states interest accrues on the outstanding daily balance without compounding — common for some revolving lines of credit. A standard amortizing calculator assumes compound periodic interest and a fixed payment that fully retires the balance by the final period. For bookkeeping purposes, confirm the loan agreement's interest method before building any schedule, because using the wrong calculator produces an incorrect principal-interest split from the first payment forward, and the error compounds through every subsequent period.

What journal entry fixes a Loan Payable balance that does not match the amortization schedule after several months of posting?

Start by identifying the first period where the GL balance and schedule balance diverged, then trace each subsequent entry to isolate whether the error was in the interest split, the principal amount, or a missed payment. Once the source period is confirmed, post a correcting journal entry in the current open month — debit or credit Loan Payable for the difference, with the offsetting entry to the account that was misstated (Interest Expense, Cash, or a prior-period adjustment account depending on materiality). Document the root cause on the reconciliation workpaper so the same error does not repeat, and update the schedule to reflect the corrected ending balance before the next period's interest calculation runs.

Loan Amortization Accounting Guide August 2026

Take any fixed loan payment and it's quietly doing two things at once: paying down interest and chipping away at the principal. The ratio between those two pieces changes every single month, which is why a loan amortization schedule exists in the first place. Once you understand the formula behind it, the journal entries and the reconciliation checks that follow start to make a lot more sense.

TLDR:

Each loan payment splits into interest and principal portions, with the interest share shrinking every month as the balance falls.
Three journal entries carry a loan through its life: initial receipt, monthly payment split, and period-end interest accrual.
Your Loan Payable GL balance should match the schedule's ending balance every close; any gap requires a same-period correction.
Amortizing, interest-only, and balloon loans require different bookkeeping treatments, and getting the loan type wrong at setup compounds every month.
Double's Accruals and Prepaids Management feature handles loan amortization schedules inside the close workflow, calculating recognition amounts and posting journal entries automatically.

What Is Loan Amortization in Accounting

Loan amortization is the process of systematically reducing a loan liability on the books by allocating each fixed payment between interest expense and principal repayment over the life of the debt. Every time a payment goes out, the outstanding Loan Payable balance on the balance sheet drops by the principal portion, and Interest Expense on the income statement picks up the interest portion, producing two distinct GL impacts from a single cash transaction. The split is not arbitrary: interest is calculated on the remaining balance each period, so the interest slice shrinks month after month as the balance falls and the principal slice grows by exactly the same amount. That shifting ratio is why you cannot simply divide the total loan cost evenly across periods and call it done. For bookkeeping purposes, the amortization schedule is the source document that tells you exactly how much of each payment belongs to which account, and the Loan Payable GL balance must match the schedule's ending balance at every close.

The Loan Amortization Formula

The fixed monthly payment (M) comes from the loan's principal, its periodic interest rate, and the number of payments:

M = P[r(1 + r)ⁿ] / [(1 + r)ⁿ − 1]

P: the loan principal, the amount borrowed
r: the periodic interest rate (annual rate divided by 12 for monthly payments)
n: the total number of payments over the loan term

The formula's real value shows up once you separate the two conversion steps from the calculation itself. Getting r and n wrong before you solve is the most common source of amortization errors, especially when someone plugs an annual rate directly into the equation instead of dividing by 12 first.

Each period's payment splits into two pieces:

Interest portion: the outstanding balance multiplied by r, the monthly rate
Principal portion: whatever remains of M after subtracting that period's interest

As the balance shrinks, the interest slice shrinks with it, so more of each fixed payment goes toward principal over time. This is the mechanic behind every amortization schedule with fixed monthly payment.

Key Components of an Amortization Schedule

An amortization schedule is a row-by-row ledger of a loan's life. Per the Corporate Finance Institute, it provides both loan and payment details for a reducing term loan. Each row lets a bookkeeper check where a loan stands in any given month without recalculating anything by hand, which is a core task in the month-end close process.

Column	What It Shows
Payment number	Sequence position in the loan term
Payment date	When that installment is due
Payment amount	The fixed total (M) paid that period
Interest portion	Outstanding balance times the periodic rate
Principal portion	Payment amount minus the interest portion
Remaining balance	Prior balance minus that period's principal

Interest ties back to the balance left after the prior payment. Principal is whatever remains once interest is covered. Every other column follows from those two numbers.

For monthly close work, remaining balance matters most. It should match the loan payable balance on the general ledger, which is a standard check in general ledger reconciliation. When it doesn't, something likely posted out of sequence.

Worked GL Example: A $120,000 Term Loan

A $120,000 term loan at 6% annual interest over 60 months carries a fixed monthly payment of $2,319.49. Running that payment through the formula for the first three months produces this schedule:

Month	Payment	Interest	Principal	Balance
1	$2,319.49	$600.00	$1,719.49	$118,280.51
2	$2,319.49	$591.40	$1,728.09	$116,552.42
3	$2,319.49	$582.76	$1,736.73	$114,815.69

Each payment splits into two general ledger entries: a debit to interest expense for that month's interest portion and a debit to loan payable for the principal portion, both offset by a single credit to cash for the full $2,319.49 payment. As the outstanding balance shrinks each month, the interest expense line drops while the principal repayment line grows, even though the total payment never changes.

Journal Entries for Loan Amortization

Three distinct entries carry a loan through its life, and each responds to a different trigger: origination, payment, and the calendar.

1. Initial loan receipt

When the loan funds, debit Cash and credit Loan Payable for the same amount, recording the liability the schedule will draw down.

2. Monthly payment entry

Split each payment as the schedule does: debit Loan Payable for principal, debit Interest Expense for interest, and credit Cash for the full amount. Bank feeds usually handle the cash side; getting the principal and interest split right is the real work.

3. Period-end interest accrual

When a payment date falls outside the reporting period, debit Interest Expense and credit Interest Payable for interest accrued but unpaid. This follows the same logic as an accrued expenses journal entry. Interest belongs to the accrual period, and skipping this entry is a common client accounting error.

How to Match the Loan Payable GL Balance to the Amortization Schedule

Any uncleared variance between Loan Payable and the schedule should be flagged the same month it appears, not carried forward. This is the foundation of reconciliation in finance. One starting point is to treat any gap left open past the current close as a required escalation to whoever owns the reconciliation, with the entry corrected before the next period's interest calculation runs.

To keep this check from turning into a recurring fire drill, build it into your month-end close checklist and standing close routine:

Pull the schedule's ending balance for the period and compare it against the Loan Payable GL balance before the close is marked complete
Trace any variance back to the specific journal entry, checking the interest and principal split against the schedule's columns for that period
Document the root cause on the reconciliation workpaper so the same error doesn't repeat next month

This is the type of recurring, judgment-heavy check that a close automation tool can flag automatically. Firms looking into how to automate financial close often start here. Double's Accruals and Prepaids Management feature handles loan amortization schedules directly inside the close workflow, calculating recognition amounts, preparing the journal entries, and posting them so the Loan Payable balance stays matched to the schedule without a manual line-by-line comparison each month.

Amortizing Loans vs. Non-Amortizing Loans

Not every loan draws down the way the term loan in the earlier example does. Before setting up any schedule, you need to identify which structure you're looking at, because the bookkeeping treatment diverges sharply depending on the answer.

An amortizing loan is the standard case: equal payments, a principal balance that declines every period, and an interest to principal ratio that moves in the borrower's favor over time. Non-amortizing structures don't behave this way, and two common variants show up constantly in client books.

Interest-only lines of credit

During the interest-only period, the payment covers interest and nothing else. The journal entry debits Interest Expense and credits Cash for the full payment amount. There's no debit to Loan Payable, so the liability balance stays flat until principal payments begin or the line converts to an amortizing structure.

Balloon loans

A balloon loan makes small, regular payments that chip away at only a fraction of the principal, then requires the remaining balance in one lump sum at maturity. The periodic entries look like a normal amortization split, principal and interest both move, but the amortization schedule needs a final line item for the balloon payment itself. Missing that line is a common setup error, since it leaves the Loan Payable balance overstated right up to maturity when it should clear to zero in a single payment.

Getting the loan type wrong at setup carries forward every month until someone catches it in a reconciliation. The same risk applies to liability accounts like deferred revenue that also require careful period-by-period recognition.

Amortization vs. Depreciation in Accounting

Loan amortization and intangible amortization share a name but diverge in mechanics once you dig into the accounting treatment.

Salvage value

Depreciation schedules typically account for salvage value, the amount an asset is expected to be worth at the end of its useful life, and only depreciate the difference between cost and that residual value. Amortization of intangible assets typically does not assume any residual value. A patent's value usually runs to zero once its legal protection lapses, so the full cost gets expensed over the useful life.

Method flexibility

Depreciation supports accelerated methods, like double-declining balance, that front-load expense recognition for assets that lose value faster early on. Intangible-asset amortization, according to AccountingTools, almost always uses the straight-line method, spreading the cost evenly across every period regardless of how the asset's usefulness actually declines.

For bookkeeping purposes, the practical distinction to hold onto is asset type. A debit against a physical asset is depreciation (see the depreciation journal entry guide for worked examples). A debit against an intangible is amortization. Reducing a loan balance also carries the amortization label, but the balance sheet impact and the underlying schedule look nothing like either of the other two.

How Firms Handle Loan Amortization Today

Most firms still run loan amortization the same way they did a decade ago: a standalone Excel file per loan, built once and reused every month until something breaks it. This pattern is covered in depth for anyone looking to stop managing accruals manually in Excel. Someone pulls the schedule, reads off that period's principal and interest split, and keys both figures into QuickBooks Online or Xero by hand.

A dragged formula overwrites a fixed rate cell, and the split comes out wrong for months before anyone notices.
Schedules live in a preparer's personal folder instead of a shared workpaper, leaving no audit trail of who built it or when it last changed.
Reconciliation stays manual: someone pulls the Loan Payable balance from the general ledger, compares it against the spreadsheet's ending balance, and chases down any gap by hand.

For a firm managing dozens of clients carrying multiple loans each, that same risk repeats across the portfolio every close, turning amortization into a recurring source of close delays that month-end close automation is designed to eliminate.

That setup friction starts earlier than most firms realize: configuring each loan schedule individually is itself a manual bottleneck when you're onboarding several clients at once. Ask Double, the practice-wide AI assistant built into the Double system, lets you create loan amortization schedules directly from conversational chat, so you can configure terms, map GL accounts, and queue up multiple schedules without navigating away from the workflow. Available on Core, Plus, and Scale plans for QuickBooks Online practices, Ask Double handles the setup step that precedes every automated recognition run, giving the Accruals module accurate schedules to post against from day one.

Loan Amortization Inside the Close with Double

Double's Accruals and Prepaids Management feature handles loan amortization schedules directly inside the close workflow. You configure the loan terms once, including principal, rate, term, and the GL accounts for Interest Expense, Loan Payable, and Cash, and Double calculates the principal and interest recognition for every period automatically, with a real-time amortization preview before you post anything. From there, Double prepares the interest-adjusting journal entries and supports bulk posting across multiple loans in a single step, so you are not repeating the same manual entry for each debt obligation every close. The cash side of each payment stays in your general ledger via bank feeds or manual entries as usual; Double's role is to calculate and post the correct interest allocation that supplements those transactions. When you reach the reconciliation step, Double compares your Loan Payable GL balance against the schedule balance maintained in the platform and surfaces any discrepancy inline, eliminating the manual spreadsheet cross-check. Every action, including schedule creation, edits, and postings, is logged in the firm-level Activity Log with a timestamp and the team member who made it, giving you a complete audit trail without any additional documentation steps.

Final Thoughts on Loan Amortization Accounting and Close Accuracy

Loan amortization accounting comes down to one repeating check: does your Loan Payable balance match the schedule? When it does, you move on. When it doesn't, you trace the variance back to the specific entry and fix it before the next period's interest calculation runs. That check is straightforward when you have one loan and manageable when you have a few, but it scales into a real close risk across a full client portfolio. Book a demo with Double to see how amortization schedules calculate, post, and stay matched to the GL inside the close without a standalone spreadsheet.

Loan Amortization Accounting: Definition and Examples (August 2026)