Introducing the New Tiller Debt Payoff Planner Spreadsheet

Originally published at: Introducing The Tiller Debt Payoff Planner Spreadsheet  - Tiller

Debt can provide leverage for achieving your goals. Loans and credit cards can help you buy a car, house, or education that might otherwise be out of reach.

But debt can quickly become a burden on your financial and emotional health. A recent Forbes Advisor survey found 54% of U.S. adults always or often feel stressed because of debt.

Debt is stressful partly because it’s expensive. Your wealth grows slower when you have to make monthly interest payments. (No wonder 36% of Americans have more credit card debt than emergency savings.)

Over 100,000 people have trusted Tiller on their financial journey. Thousands actively participate in the Tiller Community. We listened when they asked for a tool to help manage debt. And we incorporated their feedback while we built the new Debt Payoff Planner spreadsheet.

Introducing the new Debt Payoff Planner for Google Sheets and Excel

The new Debt Payoff Planner makes tracking debt simple.

It shows all your loans and credit cards in one place. See your balances, interest rates, minimum payments and more in one dashboard. Create a custom debt payoff plan based on your goals. Track progress towards becoming debt-free.

The new Debt Payoff Planner shows:

  • Current balances on all your credit cards and loans
  • Interest rates for each liability based on your input
  • Minimum monthly payments based on your input
  • Progress toward your debt payoff goals
  • Estimated monthly interest totals
  • Projected debt payoff date (based on your inputs)
  • Total interest paid over the lifetime of the debt
  • Recommended monthly payment to reach your desired payoff date

The Debt Payoff Planner can model debt snowball, avalanche, or a custom ranking payoff strategy for up to 25 accounts for up to 30 years.

You can then see how different payoff amounts and other variables impact your debt freedom date.

About the Debt Snowball and Avalanche Methods

The debt snowball and avalanche methods are two popular strategies for paying off debt. The debt snowball method prioritizes small quick wins to stay motivated, while the debt avalanche method focuses on minimizing total interest payments over time.

About the Debt Snowball Method

The debt snowball method prioritizes paying off your smallest debt balances first, regardless of interest rate.

For example, using the snowball method you would pay off a credit card with a $1,000 balance and 10% interest rate before paying off a card with a 15% interest rate and $2,000 balance.

The advantage of this method is psychological – successfully paying off a couple small debts quickly can give motivation to keep tackling larger ones. The experience of building momentum makes the snowball method one of the most popular and successful tools for paying down debt, even though it may cost more in total interest payments over time compared to other methods.

About the Debt Avalanche

In contrast, the debt avalanche method focuses on paying off debts with the highest interest rates first, regardless of balance size.

For instance, you would pay off a high-interest credit card before paying off your auto or student loans, even if the credit card has a lower overall balance.

Mathematically the debt avalanche method will likely save you more in the long run by reducing interest payments. However, it can be less motivating if your highest interest debt is also large, and you don’t experience the quick wins of eliminating your small loans first.

Custom Payoff Ranking

The Debt Payoff planner also provides a custom ranking model. You can use this to target debts you simply want to eliminate first, regardless of any other factor.

Test various scenarios to customize your debt payoff path

The Debt Payoff Planner is flexible and doesn’t force you to commit to any single method. You can experiment with variables including monthly payment amounts and time to debt payoff to find the best payoff scenario for your situation.

Budgeting for Debt Payoff

It’s recommended to make a quick budget before making a debt payoff plan. A budget shows how much money you have to put toward debt after covering your living and other expenses.

A budget can also help you find expenses to cut, giving you more to put towards debt.

The Tiller Foundation Template includes a yearly and monthly budget. Several budgets are available at the Tiller Community Template gallery.

Combining the Debt Payoff Planner with the budgeting tools in the Tiller Foundation Template will give you a master plan for transforming your financial life.

However, while it’s recommended, a budget isn’t required to use the Debt Planner template. In fact, because it’s solely based on your account balances, you don’t even need to categorize transactions to use the Debt Planner spreadsheet.

Requirements and Installation

The Debt Payoff Planner template works with any spreadsheet powered by Tiller Money Feeds. It works best with the Tiller Foundation Template.

Install the Debt Payoff Planner using the Templates feature in the Tiller Money Feeds add-on for Google Sheets, or Tiller Money Feeds add-in for Excel.

  1. Google Sheets: Click the “Templates” option in the main sidebar and click “Install” next to the Debt Payoff Planner
  2. Microsoft Excel: Click Tools at the top of the Tiller Money Feeds sidebar then choose Manage Templates and click “Install” next to the Debt Payoff Planner - note you must be using Excel Desktop version to install. Manage Templates is not yet available for Excel Online.

Click here to learn more about how to install and use this template on the Tiller Help Center.

Join us for a free webinar

:tv: Join us for a live webinar on Feb 27, 2024 @ 3PM ET / 12PM PT to see a demo, learn more, and ask questions about the the Debt Payoff Planner.

Click here to register.

Register even if you can’t attend and we’ll send you a link to the recording.


I am thrilled! I am new, and have just finished labeling about 6 months of transactions. Something like this needed to be the next step, and I was just about to search for it— thinking that I would need to learn google sheets and get something from the community.

So thank you especially, for making this in Excel. I am getting my money’s worth here…


1 Like

Very excited for this - I started using the planner in google sheets. Unfortunately I ran into an issue. The Paid Off Month, Est Total Interest, and Recommended Payment columns are calculating incorrectly for whatever Account is ordered first. Looks like a formula issue. Happy to share more info if needed!

1 Like

Wow, I am totally impressed! Thank you guys for developing this powerful tool!

This is great! Thank you.
Is there a how to set it up file? The paid off month, set total interest, recommended payments and data visualization are not populating for me.

That’s great news @claratells so happy you’re finding it valueable and using the Excel version!

@jgallo07 A few things you can check:

  • make sure that you have the checkbox checked to “activate” the account. I kept messing that up :woman_facepalming:
  • double check the start month and if there isn’t a balance in the Balance History for the start month for that account that could be throwing things off
  • is there another account that has the exact same name? If so you’d want to nickname the accounts to be able to tell them apart

If none of those help, we’d want to dig into this via support vs here in the community as we may need some screenshots so reach out to us using the chat tool on the Tiller Console at (recommend reaching out M-F 8AM - 6PM ET so you’ll reach our team rather than just the outside office hours AI bot).

@jonesntn you’re welcome! We’re excited about this release.

@lewesandclarkbeachho you can find the instructions for setting it up on our help center:

Thanks for the tips. I will get back to you with screen shots if I still get stuck. This is a great tool.

@heather This is outstanding! I used this feature in Mvelopes very heavily to get control of our debt. While I don’t need this so much at this point the power of being able to see a debt management plan for anyone struggling to manage their debt is huge! We could never have gotten our debt under control without a feature like this. I can’t wait to play around with this and see how it works!

1 Like

This is something that I was looking for when I found Tiller just a few short weeks ago, but it hadn’t been developed yet. However, I started using Tiller and am SOOO glad I did! It’s really helping me a lot (though it does take some getting used to!) … and now Tiller has given me the last piece of the puzzle I was looking for. Already plugged in my numbers and it’s perfect for my needs! Thank you Tiller!


Am I correct in assuming that you add available feeds accounts to money feeds to bring in the current data from the debt provider? Or is this a manual operation? Does this then appear in BALANCES tab?

I was able to check the boxes and get the items to populate, but one item is not calculating the payoff date correctly.

@andy great to hear it! Glad you can appreciate a tool like this, but also hopefully you won’t need it in the future again!

@cjsbabygirl313 fantastic! Glad you found that last piece of the puzzle :jigsaw:

@tjones4852 you can add debt accounts to the Tiller Console under the Connected Account Summary then link them to your spreadsheet so they are available for tracking in this debt payoff planner.

@lewesandclarkbeachho probably better to reach out via chat at to continue troubleshooting this one if you haven’t already.

The problem with the debt planner is that it does not manage 0% interest promotions. It needs to add the date 0% ends so it can impact how you attack your debt.

I would like to be able to reference the current balance cells to the actual balance on that exists on the balance tab. Unfortunately the cell reference function disturbs the function of the Payoff column

Hi @giocalcio thanks for your feedback. We were really aiming for something simple that would address most users’ needs. This additional feature would add complexity and only apply to a limited number of users. To manage a scenario like this you’d want to just update the interest rate when the promotion ends.

@jonesntn the current balance on the Debt Payoff Planner should be referencing the same balance that the Balances sheet is using. Are you saying that these numbers are different? OR can you clarify what you’re trying to do here?

OMG! I am sooooo excited to check this out! :slight_smile:
You guys ROCK!


So excited for you to use it @Ramona ! :smiley:

Ya know … :thinking: … this would be a great sheet to incorporate current credit scores from Credit Karma or through the various reporting agencies … maybe just one box each showing current credit score?

1 Like

That’s definitely an intersting idea!