Debt Payoff Planner Template (Free, With Excel Formulas)

A debt payoff planner template is a simple table that lists every debt you owe (balance, interest rate, minimum payment) and shows the order you will pay them off and the month each one should hit zero. You can build one free in Excel, Google Sheets or on a printed page in about 30 minutes, and it does the same job as most paid planner apps.

Below is a copy-ready template, how to fill it in, the two formulas that make it work in a spreadsheet, and what to check before you trust any planner app with your numbers.

The debt payoff planner template

Copy this into a spreadsheet or onto paper. One row per debt.

Add two lines above the table:

• Total minimums: the sum of every minimum payment.
• Extra each month: the amount above your minimums that you can reliably put toward debt. Even $25 counts.

Your total monthly debt payment is those two numbers added together. The whole planner rests on one rule: that total stays the same every month until you are done, even as individual debts disappear.

How to use a debt payoff planner

1. List every debt. Credit cards, store cards, personal loans, medical bills, anything in collections. Pull the exact balance, APR and minimum from your latest statement or app, not from memory.
2. Choose an order. The debt snowball goes smallest balance first, which gives you quick wins. The debt avalanche goes highest interest rate first, which costs less overall. Either works if you stick with it. A debt payoff calculator will show you both orders side by side with your own numbers.
3. Set the target payment. Every debt except the first gets its minimum. The first debt gets its minimum plus your extra amount.
4. Roll the payment forward. When debt one is paid off, add its whole payment to the minimum of debt two. That growing payment is what makes the plan speed up without you finding a single new dollar.
5. Fill in expected payoff months. Use the spreadsheet formula below or a calculator. Being a month off is fine. The point is to see when each win is coming.
6. Update it monthly. Once a month, enter the new balances. Once a quarter, rerun the payoff dates and compare them to last time.

If you do not yet know how much extra you can spare, work that out first with a budget calculator. A planner built on a payment you cannot keep up will only produce a date you miss.

Building it in Excel or Google Sheets

You do not need macros or a downloaded file. Two built-in formulas do almost everything.

How many months will this debt take?

=NPER(APR/12, -payment, balance)

For a $4,200 card at 24.99% paying $200 a month, =NPER(0.2499/12, -200, 4200) returns about 28 months. At $126 a month it is about 58 months. Seeing that difference in one cell is often the moment the plan clicks.

If the formula returns an error, your payment does not even cover the monthly interest, so the balance would never reach zero. Raise the payment until the error goes away.

What payment finishes by a date I choose?

=PMT(APR/12, months, -balance)

For the same card finished in 18 months, =PMT(0.2499/12, 18, -4200) returns roughly $282 a month. Use this when you have a deadline, like a promotional rate ending or an apartment application coming up.

For a month-by-month view across several debts, make one column per debt and one row per month. Each cell is the previous balance plus a month of interest minus the payment, wrapped in MAX(0, ...) so balances never go negative. When a column hits zero, move its payment to the next debt's column.

A worked example

Tasha owes $22,550 across five debts, with $676 in total minimums. She finds $300 extra a month, so her total payment is $976. She picks the snowball.

In months 1 to 3 she sends $335 to the store card. Once it is gone, that $335 joins the medical bill's $50, so $385 goes there. Then $511 goes to Card A, $731 to the personal loan, and finally the full $976 to Card B.

Her payment never changes. It is $976 in month one and $976 in month thirty. Total interest comes to about $5,969. Paying only minimums without rolling them forward would have taken around 71 months and roughly $12,554 in interest. The planner did not find her new money. It just stopped freed-up payments from drifting back into spending.

Printable, spreadsheet or app, and is an app safe?

• Printable: best if you like writing things down and checking off progress. Many people color in a box for every $100 paid. The downside is recalculating dates by hand.
• Spreadsheet: best balance of flexibility and cost. It is free, it is private, and the formulas update as you change numbers.
• App: convenient if you want reminders and charts on your phone. Worth it if the convenience keeps you consistent, not worth it if you would stop opening it after a month.

The method matters more than the format. People get out of debt with a sheet of paper on the fridge. If you do pick an app, check a few things before entering your numbers:

• Does it require linking your bank or card accounts? A planner only needs balances, rates and minimums. You can type those in yourself. Prefer tools that work without account linking.
• What does the privacy policy say about selling or sharing data? Read the section on third parties.
• Does it push loans or balance transfer offers? Some free tools make money by steering you toward new credit. A new loan can help in some cases, but the decision should be yours, not a banner's.
• Can you export or delete your data? If not, keep a copy of your plan somewhere else.

Read recent reviews in your phone's app store for complaints about billing, data or accuracy, and check whether a free version covers what you need before paying for a subscription.

Common mistakes with debt payoff planners

• Letting the total payment shrink. When a debt closes, people quietly spend its old payment. Keep the total fixed.
• Spreading extra money across every debt. Splitting $300 five ways means no debt disappears quickly. One target at a time.
• Using a promotional rate forever. If a 0% rate ends in eight months, enter the real rate from that month on, or the plan will look better than it is.
• Forgetting new charges. If you keep using a card you are paying off, the planner's dates are fiction. Remove paid-off cards from your wallet and saved payment settings.
• Missing minimums on non-target debts. Set autopay for every minimum so a late fee or penalty rate does not wipe out your progress.

If your planner shows you cannot cover even the minimums, the plan has to start with lowering payments or raising income rather than speed. A nonprofit credit counselor can review hardship options with you, and for serious cases a consultation with a bankruptcy attorney or legal aid office is a legitimate step. For the day-to-day side, see how to stop living paycheck to paycheck.

Common questions

Is there a free debt payoff planner?

Yes. A spreadsheet in Google Sheets or Excel using the template above is free and does everything most paid planners do. Many online payoff calculators are also free, and the better ones do not ask for your email or bank login.

Is a debt payoff planner app worth it?

It is worth it if reminders, charts and notifications keep you making payments on time. If you are comfortable with a spreadsheet or paper, an app adds convenience but not a better method. Try the free version first and only pay if it is actually changing your behavior.

Should I use the snowball or avalanche in my planner?

The avalanche (highest rate first) saves the most interest. The snowball (smallest balance first) gives faster early wins, which helps many people stay with it. If your rates are close together, the difference is small, so pick the one you will follow.

How often should I update my debt payoff planner?

Enter new balances once a month, ideally right after payments post. Rerun your payoff dates every three months. If the date moved closer, good. If it slipped, look at why and adjust, because a slipped date is information, not failure.