Debt Payoff Spreadsheet Template: Build One in Excel

How-to basics · Updated November 21, 2026

A debt payoff spreadsheet template can be built in Excel with one row per debt and columns for the balance, APR, minimum payment, extra payment, estimated interest, and ending balance. For a simple monthly estimate, calculate interest as starting balance × APR ÷ 12, then subtract the payment; the setup and formulas below make the tracker reusable while showing where lender terms may differ.

What a debt payoff spreadsheet tracks

A useful spreadsheet turns several account statements into one clear monthly view. It helps you record what you owe, see how interest affects balances, and compare possible payment priorities. It is a planning and tracking tool, not a statement from a lender: use your current account information and verify payment amounts, rates, due dates, and payoff figures with each creditor.

Set up a worksheet with these columns in row 1:

  • A: Debt: A short account name, such as Card A or Auto loan.
  • B: Month: The statement period or payment month.
  • C: Starting balance: The balance at the start of the period.
  • D: APR: The annual percentage rate, entered as a percentage such as 18%.
  • E: Minimum due: The required payment shown by the creditor.
  • F: Extra payment: Any planned amount above the minimum.
  • G: Total payment: The amount the model applies to the account.
  • H: Estimated interest: A simplified estimate for the period.
  • I: Ending balance: The model’s projected balance after interest and payment.

Use one row per debt per month. Keep each account’s rows together so that the next month’s starting balance can refer to the previous month’s ending balance. You can add due date, account type, or notes columns if they help you maintain the sheet, but avoid storing full account numbers or passwords.

Build the first month in Excel

In Excel for Microsoft 365 on Windows, enter the headers in row 1 and account details in row 2. Enter the starting balance, APR, minimum due, and planned extra payment as values. Format the APR column as Percentage and the money columns as Currency or Accounting using the options in Home > Number. For a more readable worksheet, select the header row and choose Home > Format as Table; a table can make filtering and sorting easier. On Mac, the same ribbon options are available, though the layout can vary slightly.

Suppose row 2 describes a card with a $2,400 starting balance, an 18% APR, a $100 minimum, and $50 extra planned. With the starting balance in C2 and APR in D2, enter this formula in H2 to estimate one month of interest:

With the starting balance in C2 and the annual APR in D2, =C2*D2/12 returns $36 for this example.

With estimated interest in H2, the minimum in E2, and extra payment in F2, enter this formula in G2 to cap the payment at the amount due in the model:

=MIN(C2+H2,E2+F2) returns $150: the planned $100 minimum plus $50 extra is less than the $2,436 balance after estimated interest.

With the starting balance in C2, interest in H2, and total payment in G2, enter this formula in I2:

=MAX(0,C2+H2-G2) returns $2,286, because $2,400 plus $36 interest minus $150 paid equals $2,286. MAX prevents the projected balance from going below zero if the planned payment exceeds the modeled amount owed.

For the next month of the same account, copy the row beneath it, update the month and payment inputs, and set C3 to the prior month’s ending balance. With the previous ending balance in I2, =I2 returns $2,286 as the next starting balance. This direct link carries the projection forward; replace the projected balance with the actual statement balance when you update the sheet.

Choose a payoff order: snowball or avalanche

The spreadsheet can support different payoff approaches, but it does not choose the right approach for you. In the debt avalanche method, you generally direct extra payments toward the debt with the highest interest rate while paying required minimums on other accounts. This approach can reduce interest compared with prioritizing a lower-rate debt, assuming the rates, balances, payment timing, and total amount paid remain comparable.

In the debt snowball method, you generally direct extra payments toward the smallest balance first, while continuing minimum payments elsewhere. Clearing a small balance may make progress more visible, but it does not necessarily minimize interest. A spreadsheet can make either order visible by adding a priority column and marking the current target. If a rate is promotional or variable, note its end date or terms rather than assuming today’s APR will apply throughout the payoff period.

Whichever order you compare, do not treat the extra-payment column as money available if it is needed for bills, savings, or other obligations. The model can show scenarios, but it cannot determine whether a payment amount fits your circumstances.

Make the monthly tracker practical

Update the worksheet on a consistent schedule, such as after statements arrive or after payments post. Record actual balances and payments separately from estimates when possible. A useful convention is to keep the planned extra payment in the input column and add a notes field for the amount actually paid or for an unusual event, such as a fee or a rate change. This makes it easier to identify why the real balance differs from the projection.

To see the combined projected balance for a month, use a summary cell and include only the ending-balance rows for that month. For example, if rows 2 through 4 are three debts for the same month and their ending balances are in I2:I4, =SUM(I2:I4) returns their total. If those example ending balances were $2,286, $900, and $4,500, the result would be $7,686. Avoid summing rows from multiple months together, because that would count the same debt repeatedly.

Use a separate row for each month rather than overwriting old values if you want a history. You can then compare projected and actual balances, note changes in APR, and see whether a payment was missed or posted later than expected. A simple chart is optional; the central value of the tracker is having consistent inputs and a clear record.

Understand the limits of interest estimates

The formula above divides annual APR by 12 and applies that monthly rate to the starting balance. It is a convenient estimate, not a universal lender calculation. Credit-card interest may be calculated using a daily periodic rate and an average daily balance, and payment timing, new purchases, fees, grace periods, and account-specific rules can affect the amount charged. Installment loans may use an amortization schedule or other contractual terms. A spreadsheet using a simplified monthly estimate can therefore differ from a statement even when its arithmetic is correct.

For a closer projection, use the balance, payment, and interest information supplied by the lender and follow the account’s stated method. Do not assume that the displayed APR alone reveals the exact next interest charge. Check the lender’s terms or ask the lender how interest and payments are applied. For questions about your own financial, tax, or legal situation, consult a qualified professional; this template is general information, not financial, tax, investment, or legal advice.

Common spreadsheet errors to avoid

  • Entering 18 instead of 18%: If the cell contains 18 as a plain number, the monthly-interest formula treats it as 1,800% annually. Enter 18% or 0.18 and format the cell as Percentage.
  • Confusing the statement balance with a payoff amount: A payoff quote may include interest through a particular date or other amounts. Use the creditor’s quoted figure when paying off an account.
  • Forgetting fees or new charges: These can raise the real balance beyond the projection. Record them or replace the estimate with the updated statement balance.
  • Using a total payment that is below the required minimum: The formula model cannot ensure an account stays current. Enter the actual minimum due and verify payment requirements with the creditor.
  • Carrying estimates forward indefinitely: Reconcile the sheet with actual statements regularly. An incorrect starting balance can make every later projection less useful.
  • Counting a payment twice: Make clear whether the balance is before or after the payment, and use the same convention for every month and account.

Privacy and workbook maintenance

A debt tracker contains sensitive financial information. Use account nicknames rather than full account numbers, and do not put login credentials, security answers, or card verification codes in cells or comments. If the workbook is stored in a cloud account or shared folder, review its access permissions and use the account’s available security settings. A password on a file should not be treated as a substitute for careful sharing and secure storage.

Keep a clean copy of the blank template before entering personal data. If you use formulas, check that copied rows refer to the intended cells and that each month’s starting balance follows the correct account. Spreadsheet results depend on the inputs and formulas; they do not make payments, contact lenders, or confirm that a debt has been paid off.

Frequently Asked Questions

Is there a free debt payoff spreadsheet template in Excel?
You can create a basic template directly in a blank Excel workbook using the columns and formulas above. Microsoft also provides workbook templates through its template gallery, but check any downloaded template’s formulas and assumptions before relying on its projections.

Should I pay off the highest-interest debt or the smallest balance first?
The avalanche approach prioritizes the highest APR, while the snowball approach prioritizes the smallest balance. Their results can differ, and a promotional rate or changing account terms can affect comparisons. The spreadsheet can display scenarios, but the choice depends on your priorities and circumstances.

Why does my spreadsheet balance differ from my credit-card statement?
A simple monthly estimate may not match a card issuer’s daily interest calculation. New transactions, fees, payment posting dates, grace-period rules, and changes in APR can also affect the statement balance. Compare the model with the account terms and use the lender’s figures for actual payments.

Can Excel calculate exactly when I will be debt-free?
A projection can estimate a payoff timeline only if its assumptions remain accurate, including rates, payment dates, minimums, and future charges. The simple tracker here does not calculate an exact lender payoff date. Treat a projected date as an estimate and verify any payoff amount and date with the creditor.

Should I include every debt in the same worksheet?
Usually, keeping all accounts in one worksheet makes total balances and payment priorities easier to review. Use separate rows for each account and month, label accounts clearly, and avoid mixing balances from different periods in a single total. You can add another sheet if a particular loan needs a more detailed schedule.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.