By Karmandeep Singh, Founder, Money Flow Funds •
Published: 10 November, 2026 •
Last updated: 10 November, 2026 •
Quick Answer
A debt payoff spreadsheet lists every debt — balance, interest rate (APR) and minimum payment — then shows how extra payments clear them one by one. The free Money Flow Funds spreadsheet for Canada compares the snowball and avalanche methods side by side and estimates your debt-free date.
If you owe money on more than one card or loan, a debt payoff spreadsheet is the simplest way to turn a pile of statements into one clear plan. Instead of guessing which debt to pay first, you list every balance, interest rate and minimum payment in one place, choose an order, and follow it month by month until the total reaches zero.
This guide shows you what is inside the free spreadsheet, how to download it, and how to fill it in step by step, with a full worked example on three Canadian debts so you can compare both methods on the same numbers.
⬇ Download the free Debt Payoff Spreadsheet (Excel)
Editable workbook (.xlsx) with live formulas
⬇ Download the free Debt Payoff Spreadsheet (PDF)
Publishing instruction — delete this paragraph before you publish: upload both files to Media > Add New in WordPress — “debt-payoff-spreadsheet-canada.xlsx” and “debt-payoff-spreadsheet-canada.pdf” — copy each file URL, and link the bold “Download the free Debt Payoff Spreadsheet (Excel)” line above to the .xlsx URL and the bold “Download the free Debt Payoff Spreadsheet (PDF)” line above to the .pdf URL. Do the same for the second download box in the step-by-step section below.
What is a debt payoff spreadsheet?
A debt payoff spreadsheet is a pre-built sheet where you list each debt once — who you owe, the balance, the annual interest rate (APR) and the minimum payment — and the sheet works out the rest: your total debt, your total minimums, the order to attack each debt, and an estimated debt-free date.
It works like a simple debt payoff calculator for Canada, with one advantage: the plan stays visible. A calculator gives you a single answer and disappears, while a spreadsheet keeps every month in front of you — update one number and the whole plan adjusts.
The Financial Consumer Agency of Canada (FCAC) gives the same starting advice for paying back debt: list all of your debts, check the interest rate and minimum payment on each one, and make at least the minimum payment on every debt so you protect your credit record. The spreadsheet organises those steps in one file you own — no account, no bank connection and no subscription.
- It ends the guessing. It shows the real total, so scattered balances become one number you can work on;
- It gives every dollar an order. Minimums are covered first, and only then does extra money go to one target debt;
- It makes progress visible. Each cleared debt frees a payment that rolls into the next one, so progress speeds up.
What is included in this debt payoff spreadsheet?
The free file is built in Canadian dollars and has four parts. You enter your debts once, and both payoff methods are worked out from the same numbers, so the comparison is fair.
| Sheet | What it does |
|---|---|
| 1. How to Use | Plain-English instructions for filling in the file, in order. |
| 2. Debt List | Every debt in one place: balance, APR, minimum payment, total debt and total minimums. |
| 3. Snowball vs Avalanche | Both payoff orders side by side, with the estimated debt-free month, total interest and total paid for each method. |
| 4. Payoff Tracker | A month-by-month record of payments made and balances remaining, so you can watch the total fall. |
The file comes in two formats: an editable Excel workbook (.xlsx) that Canada readers can open in Microsoft Excel, Google Sheets or LibreOffice Calc, and a printable PDF to fill in by hand. Both are free, with no sign-up.
How do you download and open the spreadsheet?
- Click the download link at the top of this article and choose your format. Both files download straight to your device.
- Open the Excel version in Microsoft Excel, Google Sheets (File > Import) or LibreOffice Calc — the formulas keep working in all three. Open the PDF in any PDF reader and print it to fill in by hand.
- Save your own copy with a clear name, for example “Debt Payoff — My Plan”, and keep the original as a clean blank copy.
- Read the How to Use sheet first. It takes about two minutes and explains every section.
How do you use this debt payoff spreadsheet, step by step?
These five steps are the whole method. The first pass takes about 20 minutes.
- Step 1: List every debt.Gather your latest statement for every debt — credit cards, store cards, lines of credit, loans and buy-now-pay-later balances. Enter the creditor, balance, APR and minimum payment for each one; the sheet totals them for you.
- Step 2: Set your extra payment.Decide how much extra you can pay each month on top of your minimums, taken from your monthly budget — even $50 or $100 changes the finish date. Your total debt payment is your minimums plus that extra amount.
- Step 3: Choose snowball or avalanche.Snowball attacks the smallest balance first, for a quick win. Avalanche attacks the highest APR first, which usually costs less interest. The sheet shows both finish dates and interest totals, so pick the order you will stick to.
- Step 4: Pay minimums plus the target.Pay the minimum on every debt, on time, and put the whole extra amount on your one target debt. Spreading extra money thinly across every debt clears none of them quickly.
- Step 5: Roll each cleared payment forward.When a debt reaches zero, add its full old payment to the next debt on your list. This rolling payment is why the last debts fall faster than the first.
⬇ Download the free Debt Payoff Spreadsheet (Excel)
⬇ Download the free Debt Payoff Spreadsheet (PDF)
Publishing instruction — delete this paragraph before you publish: link the bold Excel line above to the Media Library URL for “debt-payoff-spreadsheet-canada.xlsx” and the bold PDF line above to the Media Library URL for “debt-payoff-spreadsheet-canada.pdf”, using the same URLs as the download box at the top of this article.
What does a finished debt payoff plan look like? A Canadian example
Here is the spreadsheet filled in with three debts. The numbers are an example to show the method, not a recommendation — your balances, rates and payments will be different.
| Debt | Balance | APR | Minimum payment |
|---|---|---|---|
| Credit Card A | $1,200 | 19.99% | $35 / month |
| Store Card | $2,800 | 28.99% | $70 / month |
| Line of Credit | $5,800 | 9.99% | $115 / month |
| Total | $9,800 | — | $220 / month |
The minimums add up to $220 a month. This household adds an extra payment of $300 a month from its budget, so the total debt payment is $520 a month: $220 in minimums plus $300 aimed at one target debt at a time. That single decision turns minimum payments that drag on for years into a plan that finishes in under two years, as the next section shows. Use the minimums from your own statements, not this example — in Canada they are often a percentage of the balance and usually fall as the balance falls, while the spreadsheet keeps your payment total steady, which keeps the estimate simple and slightly cautious.
What is the difference between the debt snowball and the debt avalanche?
A debt payoff spreadsheet compares the snowball method, smallest balance first, with the avalanche method, highest rate first.[/caption]Debt snowball vs avalanche is really one question: after the minimums are paid, which debt gets the extra money? The snowball method targets the smallest balance first, whatever its rate — clearing a whole debt early gives a visible win that keeps many people going. The avalanche method targets the highest interest rate first, so the most expensive debt shrinks fastest and usually costs less interest overall.
On the example debts above, paying $520 a month, the two methods finish in the same month — but they get there in a different order and at a slightly different cost:
| Measure | Snowball (smallest balance first) | Avalanche (highest APR first) |
|---|---|---|
| Payoff order | Credit Card A (month 4), Store Card (month 12), Line of Credit (month 22) | Store Card (month 9), Credit Card A (month 12), Line of Credit (month 22) |
| Debt-free in | 22 months | 22 months |
| Total interest (about) | $1,347 | $1,267 |
| Total paid (about) | $11,147 | $11,067 |
Numbers check: $9,800 debt + $1,347 interest = $11,147 total paid (snowball). $9,800 + $1,267 = $11,067 (avalanche). Minimums $35 + $70 + $115 = $220, plus $300 extra = $520 a month.
The avalanche saves about $81 in interest in this example, because the 28.99% store card is cleared first instead of second. When both methods finish in the same month and the saving is small, the better choice is the one you will follow for 22 straight months: snowball if an early cleared debt keeps you motivated, avalanche if paying the least interest matters most. The gap grows when balances and rates are further apart, which is why the spreadsheet shows both on your own numbers.
For contrast, paying only the $220 minimums — with minimums falling as balances fall — would take about 76 months and cost about $6,721 in interest. Treat that figure as an illustrative estimate, not an exact quote: your card terms decide the real number. The $300 extra payment is what cuts roughly four and a half years, and several thousand dollars of interest, from the plan.
What are the most common debt payoff mistakes to avoid?
- Leaving a debt off the list. If a small balance is missing from the list, the plan is built on the wrong total. Include every debt, even ones you would rather not look at.
- Paying one card while spending on another. New spending quietly replaces the balance you just paid. Keep target-debt cards out of daily use, and track new purchases in your monthly budget.
- Stopping the roll. When a debt clears, it is tempting to spend its old payment. Roll it into the next debt instead — that roll is where the speed comes from.
- Setting an extra payment you cannot sustain. An extra payment that leaves no room for an emergency pushes the next surprise expense straight onto a card. Build a small emergency fund alongside the plan.
- Never updating the rates. Rates change and promotional periods end. If the sheet still shows last year’s APR, the finish date is fiction.
- Switching methods every month. Both methods work if you follow them. Switching every month clears nothing faster.
How often should you review your debt payoff plan?
Update the tracker once a month, right after your statements arrive or on the day you make your payments. Enter each new balance, check that every minimum was paid, and confirm your target debt is still the right one. It takes about ten minutes and keeps the estimated debt-free date honest.
Do a fuller review whenever something changes: a rate rises, a promotional rate ends, your income changes, or a debt is cleared. If money gets tight, lower the extra payment in the spreadsheet and see the new finish date before you decide — adjusting the plan on paper beats quietly abandoning it. If your debts feel unmanageable even on paper, free help exists in Canada: the FCAC’s paying-back-your-debt guidance on Canada.ca explains your options, and non-profit credit counselling agencies can review your full situation with you.
What are the key takeaways?
- A debt payoff spreadsheet turns scattered statements into one plan: every balance, APR and minimum in one place, with an estimated debt-free date.
- Pay the minimum on every debt, then aim your whole extra payment at one target debt at a time.
- Snowball clears the smallest balance first for motivation; avalanche clears the highest rate first and usually costs less interest. In the worked example both finish in 22 months, and the avalanche saves about $81.
- Roll each cleared debt’s payment into the next debt — that roll is what makes the later debts fall faster.
- Update the sheet monthly, and adjust the extra payment on paper rather than abandoning the plan.
What are the most frequently asked questions about a debt payoff spreadsheet?
Is this debt payoff spreadsheet really free?
Yes. It is a free download from this page, with no sign-up, in two formats: an editable Excel file and a printable PDF. Both include the same sections: How to Use, Debt List, Snowball vs Avalanche and Payoff Tracker.
Does this debt payoff spreadsheet work in Canada?
Yes. It is built in Canadian dollars, and you enter the APR and minimum payment from your own Canadian statements. It does not depend on any one bank or card provider, so it works with debts from any lender.
Do I need Microsoft Excel to use the spreadsheet?
No. The .xlsx file also opens in Google Sheets (use File > Import) and in the free LibreOffice Calc, and the formulas keep working in all three. If you prefer paper, download the printable PDF version instead and fill it in by hand.
What is the difference between a debt payoff spreadsheet and a debt payoff calculator?
A debt payoff calculator for Canada usually takes one debt, or one total, and returns a single finish date. A spreadsheet holds every debt at once, shows the snowball and avalanche orders side by side, and keeps a tracker you can update as balances change. Many people use a calculator for a quick estimate, then a spreadsheet to run the actual plan.
Should I choose the snowball or the avalanche method?
Choose the avalanche for the lowest interest cost, and the snowball if clearing a whole debt early will keep you going. In the worked example, both finish in 22 months and differ by about $81, so consistency matters more than the method. Run both orders on your own numbers and pick the plan you will follow.
What if I can only afford the minimum payments?
Pay every minimum on time first — that protects your credit record and avoids late fees. Then look for even a small extra amount in your monthly budget, because $50 a month aimed at one debt still shortens the plan. If minimums alone are not enough, the FCAC’s guidance on paying back debt on Canada.ca sets out further options, including non-profit credit counselling.
Will this spreadsheet change my interest rate or my debt?
No. It is a planning tool: it organises your debts and estimates a finish date from the numbers you enter. It does not contact your lenders, change your APR or terms, or make payments for you. Check rates and terms with each provider, and update the sheet when they change.
About the author
Karmandeep Singh — Founder, Money Flow Funds
Karmandeep Singh founded Money Flow Funds in Canada to explain budgeting, paying off debt, credit cards, borrowing and investing in plain English. Money Flow Funds publishes practical guides to help readers understand how money products work, compare their options and ask better questions before they decide.
Disclaimer
Content on Money Flow Funds is general information for educational purposes only and is not personalised financial, investment, tax or legal advice. Rates, fees and product terms change, so check details with the provider and consider speaking to a qualified professional before making financial decisions. The worked example in this article uses illustrative numbers only, and the interest and timeline figures are estimates based on the payments shown, not a guarantee of your results.
Sources and helpful resources
- Government of Canada — Managing your money: https://www.canada.ca/en/services/finance/manage.html
- Financial Consumer Agency of Canada — Paying back your debt (Canada.ca): https://www.canada.ca/en/financial-consumer-agency/services/debt/paying-debt.html
- Financial Consumer Agency of Canada — Budget Planner: https://itools-ioutils.fcac-acfc.gc.ca/BP-PB/budget-planner — the FCAC’s free online tool; use it to build the monthly budget that funds your extra debt payment.
- Government of Canada — Financial tools and calculators: https://www.canada.ca/en/services/finance/tools.html
- Money Flow Funds — home: https://moneyflowfunds.com/