debt snowball tracking sheet

Financial Liability Reduction and Amortization Tracking Protocol

Document Control

• Document ID: SOP-FIN-042
• Version: 1.0.0
• Effective Date: [__________]
• Review Cycle: Quarterly

1. Purpose & Scope

This procedure establishes the methodology for systematically tracking and eliminating outstanding liabilities using the acceleration repayment model. This protocol applies to all personal or household financial obligations identified by [Full Legal Name].

2. Prerequisites

• Tooling: A spreadsheet application (e.g., [Software Name]) or a physical ledger.
• Data Access: Read-only access to all current loan statements, credit card portals, and interest rate schedules.
• Materials: A consolidated list of all creditors, current balances, minimum monthly payments, and annual percentage rates (APR).

3. Roles & Responsibilities

4. Step-by-Step Procedure

Phase I: Data Aggregation and Normalization

• List all debts in the template under the "Liability" column.
• Input the "Current Balance" for each line item as of [Date].
• Record the "Minimum Monthly Payment" for each obligation.
• Sort the list by "Current Balance" from lowest to highest.

Phase II: Execution of Acceleration Strategy

• Identify the "Target Liability" (the debt with the lowest balance).
• Allocate the total "Surplus Capital" amount of [__________] to the Target Liability.
• Execute the minimum payment for all other liabilities.
• Update the "Remaining Balance" column immediately following each payment confirmation.

Phase III: Iterative Reconciliation

• Upon retirement of the Target Liability, reallocate the total payment amount (previous minimum + surplus) to the next debt on the list.
• Conduct a monthly audit to ensure zero missed payments across all accounts.
• Document the "Date of Liquidation" for each account to track progress velocity.

5. Quality Assurance, Pro-Tips, & Common Pitfalls

• Quality Assurance: Monthly reconciliation must match bank statement debits to the spreadsheet balance.
• Pro-Tip: Automate minimum payments via creditor portals to avoid late fees, while manually triggering the "Surplus Capital" payment to ensure it is applied to the principal.
• Common Pitfall: Failing to account for variable interest rates. Review APRs every 90 days to ensure the prioritization logic remains optimal.

6. FAQs

Q: Should I prioritize debts by interest rate or balance size? A: This protocol utilizes the balance-based acceleration model to maximize psychological momentum. Prioritizing by balance size is recommended to ensure early "wins" that sustain long-term adherence.

Q: What happens if I have an unexpected expense? A: If an emergency requires the use of surplus capital, pause the acceleration phase, maintain minimum payments only, and resume the protocol once the contingency fund is replenished.