Debt payoff spreadsheet
Free debt snowball spreadsheet template
A debt payoff spreadsheet with live formulas for Excel, Google Sheets or Numbers: download the blank template, or build it from your own debts below.
Get the blank template
An Excel workbook with live formulas: type your debts on the Debts tab and the snowball or avalanche plan, payoff dates and payment tracker fill in on their own. It opens in Excel, Google Sheets and Numbers. No sign-up.
How this works
- The workbook runs the same month-by-month math as the payoff planner: each month adds a month of interest (APR ÷ 12), pays every minimum, then puts the rest on the priority debt.
- Avalanche puts the highest APR first; snowball puts the smallest balance first. Switch between them with the dropdown on the Debts tab.
- When a debt is paid off, its minimum stays in the budget and rolls to the next debt.
- The Plan tab has one row per month with every debt's interest, payment and balance, plus totals. The Tracker tab compares what you paid with the plan.
- It assumes no new charges, fees or rate changes. Update the Debts tab when your statements change.
- The file is created in your browser; nothing is uploaded.
Sources
Awaiting expert reviewEstimates only; not financial, tax or legal advice.
Common questions
What's in the spreadsheet?
Four tabs: Start here, Debts (your balances, APRs and minimums, the extra you can pay and the payoff order), Plan (one row per month until everything is paid off) and Tracker (what you actually paid against the plan).
Do I have to enter my debts on this page?
No. The blank template downloads with example debts you replace on the Debts tab. Entering your debts here just gives you a file that's already filled in.
Does it work in Google Sheets?
Yes. Go to sheets.new, then choose File, Import, Upload and pick the file. The formulas are plain ones that work the same in Excel, Google Sheets and Numbers.
Does the spreadsheet update itself?
Yes. Change a balance, a rate, the extra payment or the payoff order on the Debts tab and the plan, your debt-free month and the tracker recalculate.
Should I pick snowball or avalanche?
Either works in the file. Avalanche usually costs less interest; snowball pays off your first debt sooner.
How many debts does it hold?
Up to 15. The plain CSV download has no limit but doesn't recalculate.
What if the plan says it won't pay off?
Your budget doesn't cover the interest. Try a bigger extra payment, or run the Debt Check to see options such as nonprofit credit counseling.
Is the information I enter saved or sent anywhere?
No sign-up is needed. Your numbers are saved only in this browser, and the other tools on the site reuse them.