Google Sheets Student Loan Repayment Tracker (Free Template & Format)

If you prefer to track your student loans manually in Google Sheets, you can use this structured loan repayment planner to stay organized and plan your payoff strategy effectively.

How to Use This Google Sheets Loan Tracker

✅ Track loan balances, interest rates, and payments in one place.
✅ Calculate monthly payments & total interest paid.
✅ Choose between Debt Avalanche or Debt Snowball methods.
✅ Update payments each month to track progress toward becoming debt-free.

Free Google Sheets Loan Tracker Template:
Click Here to Access the Loan Tracker (Make a copy to edit!)

Google Sheets Loan Tracker Format

Sheet 1: "Loan Overview" (Summary of Loans)

| Loan Name | Lender | Loan Type | Original Balance | Current Balance | Interest Rate (%) | Monthly Payment | Due Date | Status |
|-----------|--------|-----------|------------------|-----------------|------------------|----------------|---------|--------|
| Federal Loan 1 | Navient | Direct Subsidized | $5,000 | $4,500 | 4.5% | $50 | 15th | Active |
| Private Loan 1 | SoFi | Private | $10,000 | $8,900 | 7.2% | $120 | 10th | Active |
| Federal Loan 2 | Great Lakes | Direct Unsubsidized | $7,000 | $6,500 | 5.2% | $75 | 20th | Active |
| TOTAL | | | $22,000 | $19,900 | | $245 | | |

Update this sheet each month to track balance reductions.
Highlight highest-interest loans to focus on first (for the Debt Avalanche method).

Sheet 2: "Payment Tracker" (Track Monthly Payments)

| Month | Loan Name | Payment Made | Extra Payment | New Balance |
|--------|------------|--------------|--------------|--------------|
| Jan 2024 | Federal Loan 1 | $50 | $10 | $4,440 |
| Jan 2024 | Private Loan 1 | $120 | $20 | $8,780 |
| Jan 2024 | Federal Loan 2 | $75 | $5 | $6,420 |
| Total Paid | | $245 | $35 | |

This sheet tracks every payment you make toward your loans.
The "Extra Payment" column helps you see how additional payments reduce debt faster.

Sheet 3: "Debt Payoff Plan" (Choose Avalanche or Snowball Method)

| Loan Name | Interest Rate | Balance | Rank (Avalanche) | Rank (Snowball) |
|-----------|--------------|---------|------------------|----------------|
| Private Loan 1 | 7.2% | $8,900 | #1 | #2 |
| Federal Loan 2 | 5.2% | $6,500 | #2 | #1 |
| Federal Loan 1 | 4.5% | $4,500 | #3 | #3 |

Debt Avalanche: Pay off highest-interest loans first to save the most money on interest.
Debt Snowball: Pay off smallest loan first for quick wins & motivation.
Choose your strategy and prioritize your extra payments accordingly.

Sheet 4: "Loan Calculator" (Estimate Payoff Date & Interest Savings)

Use Google Sheets formulas to calculate:
Loan Payoff Date = =A2-(B2*C2) (based on balance, payment amount, and interest rate)
Total Interest Paid = =(Loan Balance * Interest Rate * Loan Term) / 100
Extra Payment Impact – See how additional payments reduce loan term & total interest.

How to Customize Your Loan Tracker

✔ Add color coding – Highlight paid-off loans & overdue payments.
✔ Use dropdowns – Add a “Status” column (Active, Paid Off, In Forbearance).
✔ Set reminders – Use Google Calendar to track payment due dates.
✔ Create charts – Visualize your debt payoff progress with a loan balance graph.

Ready to Take Control of Your Loans?

Get the Free Google Sheets Loan Tracker Here:
Click to Copy & Use

Next: Read 1200+ student guides covering all aspects of student life.

❤ If you liked all this, consider supporting us by checking out Tiny Skills - 250+ Top Work & Personal Skills Made Easy