Free Monthly Debt Budget Tracker Excel (2026)
Free Excel template integrating income, expenses, and credit card payoff into one monthly budget with debt-to-income ratio output.
Try the calculator
Advanced settings
Your debt-free date
Strategy comparison
Save up to $1,295 · 5 mo difference| Strategy | Months | Interest | Fees | Total cost |
|---|---|---|---|---|
| AvalancheYours | 26 | $1,310 | - | $6,310 |
| Snowball | 26 | $1,310 | - | $6,310 |
| Balance transferCheapest | 21 | $14 | - | $5,014 |
| Hybrid | 26 | $1,310 | - | $6,310 |
Show month-by-month timeline (first 24 months)
Behavior-aware Payoff Coach
Turn the math into 3-5 actions you can take this week.Not financial advice. Calculations are estimates based on the inputs you provide. Consult a non-profit credit counselor (NFCC member) or licensed financial advisor before making major debt-management decisions.
Free monthly debt budget tracker Excel, income, expenses, and credit card payoff in one workbook
Reviewed by CC Payoff Calc Editorial Team. Last verified May 13, 2026.
The monthly debt budget tracker Excel template is a free workbook that integrates income, expenses, and credit card payoff into one zero-based monthly budget with debt-to-income ratio output. Unlike standalone payoff templates, this tracker shows how much cash is realistically available for debt each month after fixed expenses. The DTI calculation (front-end and back-end ratios) tells the user where they stand relative to the 36 percent mortgage qualification threshold used by Fannie Mae and the Federal Housing Administration. Released under Creative Commons Attribution 4.0 (CC BY 4.0). Excel 2016+, Microsoft 365, LibreOffice compatible.
License: CC BY 4.0 (free to share, remix, repost with attribution to ccpayoffcalc.com).
Download: Download .xlsx (42 KB). Copy to Google Sheets.
Embed on your blog: <iframe src="https://ccpayoffcalc.com/embed/monthly-debt-budget-tracker-excel/" width="100%" height="640" frameborder="0"></iframe>
Plan
The workbook has six tabs: Income, Expenses, Debt Roster, Debt Payoff Allocation, DTI Summary, and Settings. Income has rows for W-2, 1099, rental, investment, Social Security, pension, alimony, and other. Expenses has rows for housing (rent or mortgage, property tax, insurance, utilities, HOA), transportation (car payment, fuel, insurance, maintenance), food, healthcare, debt minimums, and discretionary. Debt Roster lists credit cards plus other recurring debt (auto, student, personal loans). Debt Payoff Allocation distributes any income-minus-expenses surplus across debts using the chosen strategy.
The zero-based logic uses Excel’s SUM and IF functions: =SUM(income_range) - SUM(expense_range) - SUM(debt_minimums_range) - SUM(savings_allocation) should equal zero in a balanced budget. If the result is positive, the surplus is allocated automatically to the chosen debt-payoff target. If negative, the budget is over capacity and the template flags which categories exceed typical benchmarks.
Front-end DTI formula: =housing_total / gross_monthly_income. Back-end DTI formula: =(housing_total + minimum_debt_payments + auto + student_loans) / gross_monthly_income. Fannie Mae’s Selling Guide sets the qualifying back-end DTI at 36% to 50% depending on loan program. The FHA’s Single Family Housing Policy Handbook sets qualifying back-end DTI at 43% to 57% depending on compensating factors. The template’s conditional formatting flags red above 43%, yellow 36 to 43%, green under 36%.
Sample scenario: Gross income $7,500/month. Housing $2,100. Transportation $800. Food $850. Healthcare $400. Credit card minimums $385. Auto loan $385. Student loan $230. Total expenses plus debt minimums: $5,150. Savings target $750. Surplus available for extra debt payoff: $1,600. Front-end DTI: 28% (acceptable). Back-end DTI: 41% (above 36% threshold, in qualifying range but suboptimal).
The Debt Payoff Allocation tab distributes the $1,600 surplus to the chosen target card (highest APR if avalanche, smallest balance if snowball). When that card clears, its minimum payment rolls into the next target plus the recurring $1,600 surplus. Microsoft’s SUMIFS function documentation covers the conditional aggregation.
Calculator
The budget tracker pairs with the pillar payoff calculator to deliver complementary answers. The calculator answers “given X extra payment, how long until debt-free?” The budget tracker answers “what is the realistic X extra payment given my income and expenses?”
| Need | Pillar calculator | Budget tracker |
|---|---|---|
| Quick months-to-zero scenario | Best | Indirect |
| Realistic monthly debt-payment capacity | No | Yes |
| Debt-to-income ratio | No | Yes |
| Mortgage pre-application qualification check | No | Yes |
| Track income vs expense by category | No | Yes |
| Compare snowball vs avalanche math | Yes | Implied |
A complete workflow: enter income and expenses in the budget tracker, observe the surplus available for debt. Use that surplus value as the extra payment in the pillar calculator. The calculator outputs months-to-zero and total interest. Update the tracker’s Debt Payoff Allocation with the calculator-confirmed extra payment. The two files complete the planning loop.
Decision tree for budget tracker usage:
- If your back-end DTI is over 43%, the priority is bringing DTI down before optimizing payoff order. Score improvement from utilization changes comes faster than from total balance reduction.
- If your back-end DTI is 36 to 43% and you plan to apply for a mortgage in 6 to 12 months, allocate aggressively to debt payoff until DTI is under 36%.
- If your back-end DTI is under 36%, the budget tracker confirms you have capacity; focus on optimizing snowball or avalanche.
- If you have no plan to apply for a mortgage in the next 5 years, DTI matters less; focus on interest savings via the payoff calculator.
A realistic DTI optimization scenario: Starting state DTI 47% (over qualifying), gross income $6,200/month, total monthly debt payments $2,914. Goal: under 36% in 8 months for an FHA mortgage application. Required total debt reduction: $688/month in debt payments. The template projects which card payoffs would reduce monthly minimums fastest (smaller balances clear first, freeing their minimums). Card A ($1,800 at 26%): $36 minimum, clears in month 3 if all surplus directed there. Card B ($2,400 at 24%): $48 minimum, clears in month 5. Card C ($3,600 at 22%): $72 minimum, clears in month 8. Total minimum reduction by month 8: $156. The user still has work to do; the tracker exposes this gap explicitly so the user can renegotiate the timeline or seek additional income.
Strategies
The budget tracker delivers value by enforcing realism. Most debt-payoff plans fail because the user assumed surplus that does not exist in actual monthly cash flow. The tracker exposes the gap.
Customization tips:
Setting expense category benchmarks. Settings tab D8 through D20 carry typical expense ratios as published by the Bureau of Labor Statistics’ Consumer Expenditure Survey. Housing 30 to 33% of pretax income. Food 12 to 14%. Transportation 14 to 17%. Healthcare 7 to 9%. The conditional formatting flags categories that exceed the benchmark by more than 5 percentage points. Outliers are not always wrong (high-cost-of-living regions push housing higher), but the flag prompts the user to verify.
Variable income handling for freelancers. The Variable Income tab accepts 12 months of historical 1099 income and computes the average plus the lower-fence value (average minus one standard deviation). The budget uses the lower-fence value, not the average. This conservative approach ensures debt commitments are met in below-average months. The CFPB’s self-employed financial planning guide recommends planning to the lower fence.
Modeling a windfall (tax refund, bonus). Insert a Windfall row in the Income tab with a one-time amount in the month it lands. The Debt Payoff Allocation routes the windfall to the current target card. For a $3,200 tax refund directed to a $4,400 card balance, the card balance drops to $1,200 and the next month’s payment plus rolled minimum clears the card. This is the “tax refund pivot” pattern that accelerates payoff by 4 to 6 weeks on a typical 4-card scenario.
Tracking a debt management plan (DMP). If you enroll in a non-profit DMP through an NFCC member agency, the DMP combines all credit card minimums into one monthly payment to the counseling agency. Move all credit card minimums from Expenses to one DMP Payment row in Debt Roster. The single payment is typically lower than the sum of individual minimums because the DMP negotiates lower APRs (often 6 to 10%). The NFCC publishes typical DMP terms annually.
Building an emergency fund alongside debt payoff. The Settings tab carries an Emergency Fund Target cell. Default: 3 months of essential expenses (housing, food, transportation, healthcare). The Debt Payoff Allocation splits surplus 80/20 (debt/emergency) until the emergency fund hits 1 month, then 50/50 until the fund hits 3 months, then 100% to debt. The split prevents the common debt-payoff failure mode of clearing debt then re-charging it after the next unexpected expense.
Quarterly review checklist. The Notes tab carries a quarterly review schedule: re-enter the latest 3 months of actuals, recompute averages, update DTI, compare to plan. Adjustment cycles of 3 months let users catch income or expense drift before it derails the payoff timeline. Most debt-payoff plans need quarterly adjustment after the first 6 months as life changes (rent increases, job changes, new expenses) accumulate.
Modeling a mortgage application timeline. Set Settings cell D24 to the target mortgage application month (e.g. 8 months from now). The DTI Summary tab plots projected DTI month-by-month based on the current plan. The line should cross under 36% (or 43% for FHA) at least 2 to 3 months before the application month, allowing the bureau-reported DTI to fully reflect the improvement. The CFPB’s mortgage qualification guide documents the DTI thresholds across loan programs.
Resources
Authoritative sources
- Microsoft, SUMIFS function documentation
- Consumer Financial Protection Bureau, Owning a Home
- Bureau of Labor Statistics, Consumer Expenditure Survey
- Federal Housing Administration, Single Family Housing Policy Handbook
- Federal Reserve, Consumer Credit G.19 statistical release
Sibling templates
- Credit card payoff Excel template
- Multi-card payoff tracker Excel
- Credit utilization tracker Excel
- Google Sheets version
Related tools
FAQ
Frequently asked questions
How is this different from a regular budget template?
Regular budget templates show income minus expenses equals savings. This template integrates credit card debt as a third major category and computes debt-to-income (DTI) ratio, which is the metric mortgage lenders use to qualify applicants. The Debt Payoff Allocation tab also auto-rolls cleared-card minimums into the next-target card, mirroring the snowball or avalanche cascade within the budget worksheet.
What income categories does the template support?
W-2 salary, 1099 self-employment, rental, investment income (dividends and interest), Social Security, pension, alimony or child support, and an Other row. Each carries its own row with monthly amount and notes column. The W-2 row supports gross and net entry with auto-computed deductions (federal income tax, Social Security, Medicare, state income tax) using the marginal bracket entered on Settings tab.
Does the template handle variable income (freelance or commission)?
Yes. The Variable Income tab takes 12 months of historical income and computes average plus standard deviation. The budget is built on the average minus one standard deviation (a conservative income floor) to ensure debt commitments can be met in below-average months. The CFPB’s guide for self-employed budgeting recommends this conservative-floor approach.
What is debt-to-income ratio and why does it matter?
DTI is monthly debt payments divided by gross monthly income, expressed as a percentage. Under 36 percent is typically the threshold for mortgage qualification per Federal Housing Administration and Fannie Mae guidelines. Under 28 percent is considered low-risk. The template computes both front-end DTI (housing only) and back-end DTI (housing plus credit cards plus auto plus student loans), which are the two ratios mortgage lenders evaluate.
Can I link this to my bank account?
Not directly. The template is a manual-entry budget. The Import CSV tab accepts standard bank-statement CSV format if you prefer to import rather than retype. The advantage of manual entry is data control (no third-party API connection, no credential sharing). The disadvantage is the recurring time cost of monthly entry.
How this fits with the four strategies
The card-stack calculator above models avalanche, snowball, balance transfer, and hybrid strategies in parallel. Switch the strategy pill to see how the numbers move for your specific input.
Related calculators
Quick answers
How is this different from a regular budget template?
Regular budget templates show income minus expenses equals savings. This template integrates credit card debt as a third major category and computes debt-to-income (DTI) ratio, which is the metric mortgage lenders use to qualify applicants. The Debt Payoff Allocation tab also auto-rolls cleared-card minimums into the next-target card, mirroring the snowball or avalanche cascade within the budget worksheet.
What income categories does the template support?
W-2 salary, 1099 self-employment, rental, investment income (dividends and interest), Social Security, pension, alimony or child support, and an Other row. Each carries its own row with monthly amount and notes column. The W-2 row supports gross and net entry with auto-computed deductions (federal income tax, Social Security, Medicare, state income tax) using the marginal bracket entered on Settings tab.
Does the template handle variable income (freelance or commission)?
Yes. The Variable Income tab takes 12 months of historical income and computes average plus standard deviation. The budget is built on the average minus one standard deviation (a conservative income floor) to ensure debt commitments can be met in below-average months. The CFPB's guide for self-employed budgeting recommends this conservative-floor approach.
What is debt-to-income ratio and why does it matter?
DTI is monthly debt payments divided by gross monthly income, expressed as a percentage. Under 36 percent is typically the threshold for mortgage qualification per Federal Housing Administration and Fannie Mae guidelines. Under 28 percent is considered low-risk. The template computes both front-end DTI (housing only) and back-end DTI (housing plus credit cards plus auto plus student loans), which are the two ratios mortgage lenders evaluate.
Can I link this to my bank account?
Not directly. The template is a manual-entry budget. The Import CSV tab accepts standard bank-statement CSV format if you prefer to import rather than retype. The advantage of manual entry is data control (no third-party API connection, no credential sharing). The disadvantage is the recurring time cost of monthly entry.