In this article:

Free Debt Payoff Template for Google Sheets (2024 Update)

May 8, 2024

Google Sheets: Debt Payoff Template

Feel free to make a copy of this debt payoff template in Google Sheets. Don't request for permission to edit, simply go to File > Make a copy.

debt payoff tracker template for google sheets

How to Make a Debt Payoff Tracker in Google Sheets

Below we have outlined the steps on how to create a debt payoff tracker in Google Sheets. 

Step 1: Set Up Your Columns

In the first row, label the following columns to track your debt:

A1: Total Amount Owed

B1: Interest Rate (as a percentage)

C1: Minimum Monthly Payment

D1: Extra Payment (any additional amount you can afford to pay)

E1: Remaining Balance (to be calculated)

F1: Paid Off Date (optional, can be calculated based on payments)

google sheets debt payoff template free

Step 2: Input Your Debt Information

In the rows below (starting from row 2), enter the information for each debt you have. For example:

A2: $5,000

B2: 19.99%

C2: $150

D2: $50

google sheets debt payoff template

Step 3: Calculate Remaining Balance

In cell F2, enter the formula to calculate the remaining balance after each month. Here’s a simplified formula that subtracts the monthly payment from the total amount owed:


Copy this formula down for each row of debt.

Step 4: Track Your Progress

As you make payments, update the "Total Amount Owed" to reflect the remaining balance. You can also adjust the "Extra Payment" column as your budget changes.

debt payoff tracker template google sheets

We hope that this article has helped you and given you a better understanding of how to create a debt payoff tracker in Google Sheets. If you enjoyed this article, you might also want to check out our timesheet template and how to use the XLOOKUP function in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->