Debt Tracker in Google Sheets: Free Payoff Template
A debt tracker in Google Sheets is a simple spreadsheet that lists every debt with its balance, interest rate and minimum payment, then shows the balances shrinking as you pay. If you searched for a google sheets debt payoff template free to copy, our site's free debt payoff spreadsheet has the columns already set up. It is an Excel file that also works when uploaded to Google Sheets. You can also build your own in about twenty minutes with the layout below.
What a debt tracker in Google Sheets does
People who search for a debt tracker google sheets layout usually want three things: one place to see every debt, a running total that goes down, and a clear order for which debt gets extra money next. A spreadsheet does all three, and because it lives online you can open it on a phone or a laptop.
- One list: every card, loan and medical bill on a single screen, so nothing gets forgotten.
- Interest made visible: a formula shows how many dollars of each payment go to interest, not just the percentage.
- Progress: each month you add a new balance, and the total column becomes a record of how far you have come.
A spreadsheet is one of several options. You can compare it with calculators, printable sheets and dashboards on our overview of debt payoff tools.
The columns a google sheets debt payoff template needs
A google sheets debt payoff template does not need to be fancy. These columns cover what most people track:
| Column | What goes in it | Simple formula |
|---|---|---|
| A: Debt name | Card or loan nickname | Typed by you |
| B: Balance | What you owe today | Typed from your statement |
| C: Interest rate (APR) | Yearly rate as a decimal, such as 0.24 | Typed from your statement |
| D: Minimum payment | The required monthly amount | Typed from your statement |
| E: Monthly interest | Rough dollars of interest this month | =B2*C2/12 |
| F: Payment made | What you actually paid | Typed each month |
| G: Total owed (summary cell) | Sum of all debt balances; place this formula in a summary cell outside the debt-entry rows | =SUM(B2:B10) (adjust the last row to match your debts) |
The monthly interest formula is an estimate. Card issuers usually work from an average daily balance, so your statement can differ by a few dollars. Our guide on how credit card interest is calculated explains why.
How to set it up, step by step
- Open a blank spreadsheet and type the column headings from the table above into row 1.
- Add one row per debt, copying the balance, rate and minimum from your latest statements.
- Type the interest formula into column E and drag it down to every row.
- Put the total-balance formula in a summary cell outside the debt rows, or add a total row below the last debt and use a SUM formula covering only the debt rows. Do not include the total row itself in the summed range.
- Pick a payoff order. The snowball method sorts by smallest balance; the avalanche method sorts by highest rate. Use the sort tool on column B or column C to line them up.
- Each month, copy the tab, rename it with the month, and update the balances. The old tabs become your history.
If you would rather start with the work done, our free debt payoff spreadsheet has a "My debts" sheet that calculates each debt's interest this month, months to pay off, snowball order and avalanche order, plus a "Payment log" sheet. Upload it to Google Sheets to use it there.
A worked example with three debts
Example: Suppose you have $500 a month for debt and these three balances. The rates here are made up for the example.
- Card A: $2,000 at 24%, minimum $60. Interest: $2,000 × 0.24 ÷ 12 = $40.
- Card B: $1,000 at 18%, minimum $35. Interest: $1,000 × 0.18 ÷ 12 = $15.
- Car loan: $5,000 at 6%, minimum $150. Interest: $5,000 × 0.06 ÷ 12 = $25.
Total interest for the month is $40 + $15 + $25 = $80. The minimums add up to $60 + $35 + $150 = $245, which leaves $500 minus $245 = $255 extra.
Using the snowball order, the extra goes to Card B, the smallest balance. Its payment becomes $35 + $255 = $290. The new balance is $1,000 plus $15 interest minus $290, which equals $725. Using the avalanche order instead, the $255 would go to Card A, the highest rate. Both orders pay the minimums on everything else.
A spreadsheet shows one month at a time unless you build more rows. To see the full payoff date and total interest in seconds, try the snowball versus avalanche comparison calculator with the same numbers.
Spreadsheet, printable or dashboard: the trade-offs
A spreadsheet suits people who like seeing the formulas and adjusting things by hand. It also has limits worth knowing:
- Manual updates: balances only change when you type them in.
- Formula mistakes: one dragged cell in the wrong place can quietly throw off a total.
- Harder scenarios: a balance transfer, a car loan with a set term or a mortgage takes extra columns and some care.
If you prefer paper, a printable tracker works the same way without formulas. Some people use the site's Clearora™ Debt Payoff Dashboard instead: an online dashboard with tabs for credit cards, balance transfers, car loans, personal loans and mortgages, plus a save and load feature. It comes with a manual, a video and a private Skool community called Get Out of Debt Club. You can read what is included on the Clearora dashboard and community page. Whichever tool you pick, the numbers you type in are what drive the results.
Keeping the tracker useful month after month
I have found that a tracker only helps if it gets opened. A few habits make that easier:
- Pick one day each month, such as the day after payday, to update it.
- Add a column for the date each debt was paid off, so wins stay on the screen.
- Note any rate change right away; a promotional rate ending can change your order.
- Keep the sheet private. Sharing settings in Google Sheets control who can view it.
FAQ
Is a google sheets debt payoff template free to use?
Google Sheets itself works with a Google account, and the spreadsheet on this site is a free download with no account needed. Upload the .xlsx file to Google Sheets to store and edit your copy in your Google account; access depends on your sharing settings and Google's data-handling practices.
Does the spreadsheet calculate interest exactly like my statement?
Not exactly. The simple formula multiplies the balance by the yearly rate and divides by 12. Lenders often use daily balances, so expect small differences and use your statement as the final word.
Which payoff order works with a debt tracker?
Any order works. The snowball method targets the smallest balance first, and the avalanche method targets the highest rate first. The avalanche usually costs less interest; the snowball gives quicker early wins. A calculator can show both side by side for your own numbers.
Can I track a mortgage or car loan in the same sheet?
Yes, as rows with their balance, rate and payment. Fixed loans follow a set schedule, so the simple interest formula is only a rough guide for them. A dedicated loan calculator gives a closer picture of the payoff date.
How often should the tracker be updated?
Many people update once a month when statements arrive. Updating more often is fine, but once a month is enough to see the trend and keep the payoff order current.