Skip to content
The title slide and first slides of the Loan Payment Tracker template

Loan Payment Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Difficulty
Beginner
Updated
November 16, 2026

Every slide (6)

Overview

A loan balance falls more slowly than the payments suggest, because part of each payment is interest. Enter each loan with the balance on the day you start logging, the rate from your statement and the amount you pay each month. Then use the Payments tab to log each one with the interest part from the statement. The sheet works out the principal, the balance now, the percent paid and an estimate of the months left.

The Balance tab shows how much you owe across all loans, the principal paid, the interest paid and the number of payments logged, with a bar chart of the starting balance against the balance now for each loan. The four sample loans include an auto loan, a student loan, a personal loan and an interest-free medical payment plan.

Useful for

  • See how much of your payments went to interest
  • Track several loans in one place
  • Check the effect of extra payments

What's included

  • 4 tabs: Loans, Payments, Balance, How to use
  • Loans: a table
  • Payments: a table
  • Balance: a dashboard with 4 summary figures
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Loans tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I track loan payments in a spreadsheet?

Enter the loan with its starting balance, then log each payment with the interest portion from your statement. The sheet subtracts the principal part from the balance.

Where does the months-left figure come from?

It estimates how many payments remain if the rate and payment stay as they are. Your lender payoff quote is the figure to trust.

Can I log extra payments?

Yes. Add a row with the extra amount, a zero or small interest part and the how paid set to Extra. The principal part reduces the balance.

  • #bill-tracker
  • #loan-payment-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More bill tracker templates

See all 13

Also in Finance

All finance templates
Get this template

Preparing your template…