Rounding Robin

Home › Templates › Loan Amortization Schedule Template

Loan Amortization Schedule Template

A monthly amortization schedule for a fixed-rate loan of up to 40 years, with optional extra principal, a summary of interest saved, and the accounting entries that go with it.

Download the Excel template

Free. Excel .xlsx format, no macros, no registration.

Contents

TabPurpose
InstructionsPurpose, steps, a guide to each tab, the colour key and a list of every built-in check with its result.
InputsCompany details, dates and the source data. All entry cells are shaded.
ScheduleOne row per payment: opening balance, interest, scheduled payment, extra principal, principal paid, closing balance and cumulative interest.
Journal EntryThe entry produced from the schedule, with a check that debits equal credits.
ReconciliationSchedule balances compared with the general ledger, with differences flagged.
ListsAccount mappings and dropdown values, editable to match your chart of accounts.

Features

Instructions

  1. On the Lists tab, enter the five general ledger accounts.
  2. On the Inputs tab, enter the period end date and the loan terms.
  3. Enter any extra principal: a recurring amount on the Inputs tab, or one-off amounts on the Schedule tab.
  4. Review the summary and the schedule.
  5. Post the entries on the Journal Entry tab that apply to the period.
  6. Enter lender and ledger balances on the Reconciliation tab.

Notes

Assumes a fixed rate and monthly payments. Accrued interest uses actual days over 365; confirm the day-count basis in the loan agreement.

Related calculators

More accounting templates

Need a version built for your process? Request a custom template quote.

To report an error or request a calculator or template, send feedback.

Templates are provided for general information. They are not accounting, tax or legal advice. Review the formulas and results before relying on them.