● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Debt & Loans›Auto Loan Payoff Tracker
Auto Loan Payoff Tracker hero image showing the car loan payoff workbook
DEBT & LOANS

Auto Loan Payoff Tracker

Two car payments can make the finish line feel like it keeps moving away from you. This auto loan payoff tracker puts every vehicle loan in one workbook, picks your attack order for you and shows the exact date you will be done.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

A payoff plan that shows you the finish date

You start by listing each loan once: lender, type, original and current balance, interest rate, minimum payment and due day, for up to 4 vehicle loans. From those basics the workbook calculates monthly interest, months to payoff, the total interest and a debt-free date per loan. Then you pick your method on the Start Here tab, where you also set an extra monthly payment and a goal date, and the Payoff Plan tab ranks the attack order for you.

Snowball and avalanche suit different people. Snowball clears the smallest balance first, so a whole loan disappears sooner and momentum builds. Avalanche targets the highest interest rate first, so you pay less interest overall. The plan shows both ranks for every loan, and switching method takes a moment. If money is tight, the tracker still works on minimums alone: set the extra payment to zero and add one later whenever life allows, and the plan updates itself.

Each payment you log, up to 40 of them, is split into interest and principal automatically, and the loan's remaining balance falls with it. The dashboard keeps what you still owe, what you have paid off, your weighted rate, total monthly payment and planned debt-free date in one view. Before selling or trading in, the Trade-In Equity tab compares value against balance, flags underwater loans and estimates the months needed to break even. Payoff figures are estimates, so check the final number with your lender.

Inside the workbook: 8 tabs

What you receive

  • Google Sheets Access PDF with a one-click link that copies the tracker into your own account
  • BLANK Excel workbook, clean and ready for your own car loans
  • EXAMPLE Excel workbook filled with two realistic car loans and four logged payments
  • Quick Start Guide PDF covering setup, your monthly routine and troubleshooting
  • Separate files, no ZIP to unpack

Good to know

  • Runs in Microsoft Excel, and in Google Sheets through the included copy link, on any device
  • Works for new, used, refinanced and lease buyout loans, up to 4 in total
  • Payoff dates and interest are estimates based on your numbers: check the final figure with your lender
  • A planning tool only: it does not move money and is not financial advice
  • Questions after purchase? Message us on Etsy and we will help you get set up

Questions about this template

The things buyers ask us most.

What is the difference between snowball and avalanche?

Snowball pays the smallest balance first, so you clear a whole loan sooner and get the motivation of an early win. Avalanche pays the highest interest rate first, so you pay less interest in total over the plan. The Payoff Plan tab shows both ranks for every loan, so you can compare the two orders before choosing.

What if I can only afford the minimum payments?

The tracker still works for you. Set the extra monthly payment to zero on the Start Here tab and every loan is planned on its minimum alone, with payoff dates calculated from that. When money frees up later, add an extra amount and the attack order, months to payoff and your planned debt-free date all update automatically.

What does it mean if my car loan is underwater?

It means you owe more on the car than it is worth. On the Trade-In Equity tab, equity is the trade-in value minus the loan balance, so a negative figure flags the loan as underwater. The tab also shows the cash you would need to cover the gap before selling or trading in, and roughly how many months of payments close it.

Can I use it for a personal loan as well?

Yes. Any fixed rate loan with a balance, a rate and a minimum payment fits the same columns, so a personal loan can sit on the Loans tab alongside your car loans and join the same snowball or avalanche plan. You can also rename lenders and loan types on the Settings and Lists tab to match your situation.

More in Debt & Loans

All templates in this category →

Three more workbooks from the same shelf.

Debt Payoff Tracker

List every debt, pick snowball or avalanche, and watch your debt free date move closer.

$22.50 $9.00
View on Etsy
Debt Free Planner Bundle

A payoff plan with your debt-free date, plus budget, savings and net worth tools.

$25.00 $10.00
View on Etsy
Debt Snowball Planner

Smallest balance first, freed payments rolled on, debt-free date included.

$7.50 $3.00
View on Etsy
View on Etsy · $3.00