debt snowball tracker template

Personal Debt Elimination Tracker

This system is designed to accelerate debt repayment by prioritizing balances from smallest to largest, regardless of interest rate. By focusing on one liability at a time while maintaining minimum payments on others, you create a "snowball" effect. Update this sheet monthly, immediately following your [Monthly Budget Review Date].

Column Definitions

• Debt Name: Text. The specific name of the creditor or account.
• Current Balance: Currency. The remaining principal owed as of the last statement.
• Minimum Payment: Currency. The mandatory monthly payment required to stay in good standing.
• Interest Rate: Percentage. The Annual Percentage Rate (APR) applied to the balance.
• Payoff Priority: Integer. The order in which debts are being attacked (1 = smallest balance, 2 = next smallest, etc.).
• Status: Dropdown. Options: [Active], [Paid Off], [On Hold].

Essential Formulas

Monthly Debt Service Calculation: Sum of all minimum payments required to avoid penalties: =SUM(C2:C5)

Remaining Total Debt: Sum of all current balances remaining: =SUM(B2:B5)

Snowball Amount (Extra Payment): Calculate how much extra you have to apply to your priority debt after minimums: =[Total Monthly Debt Budget] - SUM(C2:C5)

Formatting and Validation Rules

1. Data Validation (Status Column): Select the Status column range. Go to Data > Data Validation > Criteria: List of items. Enter: Active, Paid Off, On Hold.
2. Conditional Formatting (Paid Off): Select the entire row. Go to Format > Conditional Formatting. Custom formula: =$F2="Paid Off". Set background color to Light Green and strike-through text.
3. Conditional Formatting (High Priority): Select the "Payoff Priority" column. Use Color Scale formatting (Green to Red) to visually highlight which items are currently being targeted for accelerated repayment.