The only Google Sheets debt payoff system engineered specifically for single-inc
Personal Finance / Spreadsheet Tools

The only Google Sheets debt payoff system engineered specifically for single-income households that turns one unpredictable paycheck into a precise, automated debt-destruction machine — no budgeting apps, no complex software, just a spreadsheet that actually works when money is tight.

Designed for: Single-income households earning $35K–$75K annually (single parents, one-earner couples, freelancers with variable income) who carry $15K–$80K in mixed debt (credit cards, car loans, medical bills, student loans), have tried budgeting apps like YNAB or Mint but abandoned them, feel overwhelmed by competing financial advice, and desperately want a clear visual system they control — not another subscription. They're intermediate with Google Sheets (can enter data, use basic formulas) but don't know how to build financial models. Their core frustration: every debt payoff plan assumes two incomes or stable surplus cash, and they feel like the system wasn't built for them.

Transformation: From staring at 4–7 debt accounts with no clear priority order and making scattered minimum payments that feel pointless → To operating a single, self-updating Google Sheets dashboard that shows your exact debt-free date, auto-calculates your optimal payment order each month, and adapts in real-time when your income fluctuates — with a proven path to eliminating $20K+ in debt 14–23 months faster than minimum payments alone.

---

---

You've probably opened a budgeting app, entered all your debt balances with a kind of grim determination, and then quietly stopped using it three weeks later. That didn't happen because you lack discipline — it happened because the system assumed you had money left over at the end of the month to allocate.

---

The Debt Landscape Audit™

Before you can attack debt strategically, you need a complete, honest picture of what you're actually dealing with — not a rough mental estimate, but a documented inventory that reveals the hidden mechanics of why your money disappears before your debts do.

The Debt Landscape Audit™ is a five-step diagnostic process. It doesn't just list what you owe. It maps the timing, cost, and drag of every debt against your single income stream — exposing the specific bottlenecks that make generic payoff plans collapse for households like yours.

Step 1: Complete the Full Debt Inventory

Pull every statement, log into every account portal, and capture these eight data points for each debt:

Most people skip the due date and payment type columns. Those two fields are where single-income timing gaps live.

Step 2: Map Your Income Timing

Write down your exact pay dates for the next three months. If you're a freelancer or gig worker, write down your expected pay dates and your realistic worst-case pay dates — these are often two different calendars. Now lay your debt due dates against your pay dates. You're looking for clusters: multiple bills due in the same 5-day window, or due dates that fall 3–10 days before your paycheck lands.

This is a timing gap. It's not a budgeting failure. It's a structural mismatch that no app fixes by default.

Step 3: Calculate Your Income Volatility Score

Take your last six months of take-home income. Find the difference between your highest month and your lowest month. Divide that difference by your average monthly take-home. Multiply by 100.

**Volatility Score = ((Highest Month − Lowest Month) ÷ Average Monthly Income) × 100**

Most single-income households score between 18–42%. Most debt payoff plans are built for a volatility score of zero.

Step 4: Run Your Surplus Reality Check

Take your average monthly take-home income. Subtract your total fixed expenses (rent/mortgage, utilities, insurance, groceries, transportation). Subtract your total minimum debt payments. What's left is your real surplus — the only money available for accelerated payoff.

If that number is negative, or under $150, you have a surplus constraint problem. The fix isn't to cut more aggressively — it's to sequence your payoffs so that eliminating one debt frees up cash to attack the next. That sequencing is what this entire system is built around.

Step 5: Calculate Your Debt Drag Ratio

Add up every minimum monthly debt payment. Divide by your average monthly take-home income. Multiply by 100.

**Debt Drag Ratio = (Total Monthly Minimum Payments ÷ Average Monthly Take-Home) × 100**

The national average Debt Drag Ratio for households in the $35K–$75K income range sits around 18–22%. If your ratio is above 28%, you're in the high-drag zone — meaning more than one in four dollars you earn is already spoken for before you buy a single grocery item. Above 35% is critical drag territory, where even small income disruptions cascade into missed payments.

Knowing your ratio doesn't just tell you how bad things are. It tells you exactly how much relief each eliminated debt account will deliver — and which one to eliminate first.

---

Real-World Example

Scenario: Maria is a single mother in Phoenix earning $52,000 per year as a dental hygienist. Her take-home is approximately $3,450/month. She has five debt accounts: a Discover card ($6,200 at 24.99% APR, $124 minimum, due the 8th), a Capital One card ($2,800 at 19.99% APR, $56 minimum, due the 3rd), a car loan ($11,400 at 7.9% APR, $287 fixed, due the 15th), a medical bill on a payment plan ($1,900 at 0% APR, $75 minimum, due the 1st), and a private student loan ($18,500 at 9.5% APR, $210 minimum, due the 22nd).

Her total minimum payments: $752/month.

Her Debt Drag Ratio: $752 ÷ $3,450 = 21.8% — right at the national average, which feels manageable until you look at the timing.

Three of her five due dates (the 1st, 3rd, and 8th) cluster in the first eight days of the month. Her paycheck lands on the 5th and the 20th. That means her Capital One payment and her medical bill are due before her first paycheck of the month, and her Discover payment lands three days after — right when her account is at its lowest. She's been covering those early-month payments by leaving money in her account from the previous paycheck, but when any unexpected expense hits in the last week of the month, she's short. She's not bad with money. She's fighting a timing gap that compounds every single month.

After completing the Debt Landscape Audit™, Maria identifies that shifting her Discover due date (a 5-minute phone call to Discover's customer service line) to the 12th eliminates the early-month cluster entirely. That one change — before she makes a single extra payment — stops the cascade that's been causing her to occasionally pay late and triggering penalty APR reviews.

Her volatility score is low (she's a salaried employee), so her surplus reality check shows she has approximately $310/month in real surplus after fixed expenses and minimums. That $310 becomes the engine of her entire payoff plan.

---

Worksheet: The Debt Landscape Audit Sheet

Tab 1: Debt Inventory Table

Copy this structure into your Google Sheet. Each row = one debt account.

| Column | Field | What to Enter |

|--------|-------|---------------|

| A | Creditor Name | e.g., "Chase Sapphire" |

| B | Account Type | Credit Card / Auto / Medical / Student / Personal |

| C | Current Balance | Pull from today's statement |

| D | APR (%) | Interest rate — check the fine print |

| E | Minimum Payment ($) | Required monthly minimum |

| F | Due Date (Day of Month) | e.g., "7" or "22" |

| G | Payment Type | Fixed or Revolving |

| H | Account Status | Current / Late / Collections |

| I | Auto-Pay? | Yes / No |

| J | Severity Score | Formula auto-fills (see below) |

Severity Score Formula (paste into Column J):

```

=IF(D2>24, "🔴 Critical", IF(D2>18, "🟠 High", IF(D2>10, "🟡 Moderate", "🟢 Low")))

```

Tab 1 Summary Calculations (place below your table):

```

Total Balance: =SUM(C2:C[last row])

Total Min. Payments: =SUM(E2:E[last row])

Debt Drag Ratio: =(SUM(E2:E[last row])/[Your Monthly Take-Home])*100

Monthly Debt Service: =SUM(E2:E[last row])

```

---

Tab 2: Income & Timing Analysis

| Field | Your Numbers |

|-------|-------------|

| Average Monthly Take-Home | $_______ |

| Highest Month (last 6 months) | $_______ |

| Lowest Month (last 6 months) | $_______ |

| Volatility Score | _______ % |

| Pay Date 1 (day of month) | _______ |

| Pay Date 2 (if applicable) | _______ |

| Timing Gap Accounts (due before payday) | _______, _______, _______ |

---

Tab 3: Previous Attempts Log

For each past payoff attempt, complete one row. This is not about shame — it's diagnostic data.

| Attempt # | Method Used | Start Date | How Long It Lasted | What Specifically Broke It Down |

|-----------|-------------|------------|-------------------|--------------------------------|

| 1 | e.g., YNAB | _______ | _______ weeks | e.g., "Income dropped in month 2, couldn't adjust" |

| 2 | | | | |

| 3 | | | | |

Breakdown Categories to Choose From: Income shortfall | Unexpected expense | Timing gap/overdraft | Lost motivation after no visible progress | Plan too rigid for variable income | Didn't account for irregular bills | Emotional spending after stressful period | Other: _______

---

Quick Checklist

You've already mapped what you owe. Now comes the part that actually determines whether your debt payoff plan survives contact with real life — figuring out when money moves through your account and why certain weeks always feel like a financial emergency.

---

The Paycheck Timing Blueprint™

Most debt payoff systems treat your income like a steady river. For single-income households, it's more like a series of rain bursts — predictable in pattern, but brutal if you haven't built the right channels to direct the flow. The Paycheck Timing Blueprint™ is a four-step process for mapping your exact income timing against your bill due dates, identifying the weeks where outflows outpace available cash, and restructuring your due dates to eliminate those crunch points before they cause overdrafts or late fees.

Step 1: Classify Your Income Pattern

Your income type determines how you configure everything downstream. There are four patterns common to single-income households:

Write down your pattern before moving to Step 2. If you have a hybrid (say, a part-time W-2 plus freelance clients), classify the larger income source as your primary and treat the secondary as a variable supplement.

Step 2: Plot Your Income Deposits on a 31-Day Grid

Using the Cash Flow Timing Map worksheet (detailed below), mark every expected income deposit on the calendar grid. Use actual deposit dates, not pay period end dates — these can differ by 1–3 days depending on your bank and employer, and that gap matters when a bill auto-drafts at midnight.

Step 3: Cluster Your Bill Due Dates

Now plot every recurring bill and minimum debt payment on the same grid. What you're looking for is clustering — groups of bills that fall within the same 3–5 day window. For most single-income households, clustering happens in two predictable zones: the 1st–5th of the month (rent/mortgage, subscriptions that reset monthly) and the 15th–20th (credit cards, car loans, utilities). If your single paycheck lands on the 15th and your rent is due on the 1st, you're already operating in a structural deficit for two weeks every month.

Step 4: Identify and Eliminate Dead Zones

A dead zone is any period where your account balance is projected to go negative — or within $200 of zero — before your next deposit. Mark these on your grid in red. These are not budgeting failures. They are structural timing mismatches that no amount of willpower fixes. The solution is due date migration: moving bill due dates to align with your deposit schedule so cash is always present when payments draft.

---

Real-World Example

Maria is a single mother earning $52,000 per year as a hospital billing coordinator. She gets paid biweekly on Fridays. Her Debt Landscape Audit (from Chapter 1) revealed $34,000 in mixed debt across four accounts.

When she plotted her 31-day grid, the problem became immediately visible. Her rent auto-drafts on the 1st. Her car payment is due the 3rd. Her two credit cards are due on the 7th and the 10th. Her student loan drafts on the 15th. Her paycheck lands on the 2nd and the 16th.

The dead zone: Days 1–2 of every month, her rent and car payment draft before her paycheck clears. She's been covering this with a $400 buffer she mentally calls her "safety cushion" — but it's actually a permanent loan to herself that never gets repaid, and it's why she can never build momentum on debt payoff.

After running Step 4, Maria called her car lender and moved her due date from the 3rd to the 5th (two days after her deposit clears). She moved one credit card from the 7th to the 8th. These two changes cost her nothing and eliminated her dead zone entirely. She didn't earn more money. She just stopped letting the calendar steal from her.

---

Worksheet: The Cash Flow Timing Map

Instructions: Copy this template into a new tab in your Google Sheets debt dashboard. Fill in every row. Use the color-coding guide at the bottom to identify danger zones.

---

SECTION A — Income Pattern Classification

| Field | Your Answer |

|---|---|

| Primary income type (W-2 biweekly / monthly salary / freelance variable / gig-stacked) | |

| Primary deposit day(s) of month | |

| Average net deposit amount | |

| Secondary income source (if any) | |

| Secondary deposit day(s) of month | |

| Average secondary deposit amount | |

| "Three-paycheck months" this year (biweekly only — list the months) | |

---

SECTION B — 31-Day Cash Flow Grid

Create a row for each day 1–31. For each day, fill in three columns:

| Day | Expected Income (+) | Expected Outflow (−) | Running Balance |

|---|---|---|---|

| 1 | | | |

| 2 | | | |

| 3 | | | |

| ... | | | |

| 31 | | | |

Formula for Running Balance (Day 3 example):

`=D2+B3-C3`

Copy this formula down the entire column. Your starting balance in Day 1 should be your actual account balance on the 1st of the month.

Color-coding rule: Conditional format the Running Balance column — red if below $200, yellow if $200–$500, green if above $500.

---

SECTION C — Due Date Migration Tracker

| Creditor | Current Due Date | Target Due Date | Phone Number | Date Called | Outcome | New Due Date Confirmed |

|---|---|---|---|---|---|---|

| | | | | | | |

| | | | | | | |

Phone script for due date change requests:

*"Hi, I'm calling to request a due date change on my account. I'm on a single income and my paycheck deposits on [DAY]. I'd like to move my due date to [TARGET DATE] to avoid any accidental late payments. Can you process that change today?"*

Most credit card issuers (Chase, Capital One, Citi, Discover) allow one free due date change per year. Car lenders vary — some require a written request. Medical bill payment plans are almost always flexible. Ask specifically for the date, confirm it in writing, and note the representative's name.

---

SECTION D — Before/After Cash Flow Comparison

| Metric | Before Migration | After Migration |

|---|---|---|

| Number of dead zones per month | | |

| Lowest projected balance in month | | |

| Days below $200 buffer | | |

| Number of bills at risk of late payment | | |

---

Quick Checklist

---

Common Mistakes

---

Your Action Plan

---

You've already mapped every debt you owe in your Debt Landscape Audit. Now comes the question that actually determines how many years of your life you spend paying off that debt: which one do you attack first?

The Problem With "Pick One Method"

Every personal finance article frames this as a binary: snowball (smallest balance first) or avalanche (highest interest rate first). Both methods were designed for people with predictable surplus cash — someone who can reliably throw an extra $300 at debt every month without blinking. That's not your reality.

On a single income, your surplus fluctuates. A slow freelance month, a sick kid, a car repair — and suddenly your "extra payment" evaporates. When that happens with a pure avalanche strategy, you've been grinding at a $14,000 student loan for six months with nothing to show for it. Motivation collapses. You stop paying extra entirely. The debt sits there collecting interest while you feel like a failure.

Pure snowball fixes the motivation problem but ignores the math. Paying off a $400 medical bill while carrying a 24.99% APR credit card is costing you real money — money you don't have to waste.

The Momentum-Math Hybrid Method™ solves both problems simultaneously by scoring each debt across three dimensions and generating a ranked attack order that's neither purely emotional nor purely mathematical.

---

The Momentum-Math Hybrid Method™

This framework produces a single composite score for each debt. The highest-scoring debt gets attacked first with every dollar above minimum payments. When that debt is eliminated, the system recalculates and reassigns your attack focus automatically.

The Scoring Formula:

**Hybrid Score = (Interest Rate Weight × 0.4) + (Balance-to-Minimum Ratio × 0.35) + (Psychological Friction Score × 0.25)**

Each component is scored on a 1–10 scale, then weighted and summed. Here's how to calculate each one:

---

Component 1: Interest Rate Weight (40% of score)

Normalize your interest rates across all debts on a 1–10 scale. Your highest APR gets a 10; your lowest gets a 1. Everything else scales proportionally.

Formula: `((Debt APR − Lowest APR) / (Highest APR − Lowest APR)) × 9 + 1`

This ensures high-interest debt gets serious priority without completely overriding the other factors.

---

Component 2: Balance-to-Minimum Ratio (35% of score)

This is the efficiency metric — it measures how much debt you can eliminate relative to the minimum payment you're already making. A debt with a $400 balance and a $40 minimum has a 10:1 ratio. A debt with a $12,000 balance and a $200 minimum has a 60:1 ratio.

Lower ratios score higher because they represent debts you can close out quickly, freeing up that minimum payment to redirect elsewhere.

Score it: Calculate the ratio for each debt (Balance ÷ Minimum Payment). The debt with the lowest ratio gets a 10; the highest ratio gets a 1. Scale proportionally using the same normalization formula above.

---

Component 3: Psychological Friction Score (25% of score)

This is the factor every spreadsheet ignores — and it's the one that determines whether you actually follow through. Rate each debt from 1–10 on how much mental and emotional weight it carries. Use these criteria:

Be honest. A debt that's quietly destroying your motivation to stay on plan is costing you more than the interest rate suggests.

---

Calculating Your Final Score

Once you have all three component scores for each debt, plug them into the formula. The debt with the highest composite score gets your attack focus. When it's paid off, delete it from the sheet — the remaining debts automatically rerank.

---

Real-World Example

Maria is a single mom in Phoenix earning $52,000 annually as a dental hygienist. After completing her Debt Landscape Audit, she has five debts:

| Debt | Balance | APR | Min Payment |

|---|---|---|---|

| Credit Card A | $3,200 | 24.99% | $75 |

| Credit Card B | $890 | 19.99% | $35 |

| Car Loan | $11,400 | 6.9% | $287 |

| Medical Bill | $1,100 | 0% | $50 |

| Student Loan | $18,500 | 5.8% | $203 |

Scoring Credit Card B ($890, 19.99% APR, $35 minimum):

Card B Hybrid Score: (8.2 × 0.4) + (7.4 × 0.35) + (9 × 0.25) = 3.28 + 2.59 + 2.25 = 8.12

After scoring all five debts, her attack order comes out: Credit Card B → Credit Card A → Medical Bill → Car Loan → Student Loan.

Under pure avalanche, she'd attack Credit Card A first (highest APR), spending months grinding at a $3,200 balance before getting a win. Under pure snowball, she'd hit Credit Card B first anyway — but only because of balance, not because of the combined math. The Hybrid method confirms Credit Card B is correct and explains why, which matters when motivation wavers at month four.

Projected comparison for Maria (with $150/month extra payment available):

| Method | Total Interest Paid | Debt-Free Date |

|---|---|---|

| Minimum Payments Only | $9,847 | 11.2 years |

| Snowball | $6,203 | 6.8 years |

| Avalanche | $5,891 | 6.5 years |

| Momentum-Math Hybrid™ | $5,744 | 6.1 years |

The Hybrid beats avalanche by $147 in interest and four months in time — not because the math is radically different, but because it keeps Maria engaged through the early months when motivation is fragile.

---

Worksheet: The Debt Attack Sequencer

Copy this table into your Google Sheets tracker. Use one row per debt.

```

DEBT ATTACK SEQUENCER

| Column A | Column B | Column C | Column D | Column E | Column F | Column G | Column H | Column I |

|--------------|----------|----------|--------------|-----------------------|----------------------|-----------------------|----------------|-----------------|

| Debt Name | Balance | APR | Min Payment | Interest Rate Score | Bal/Min Ratio Score | Psych Friction Score | Hybrid Score | Attack Rank |

| | | | | (1–10, normalized) | (1–10, normalized) | (1–10, self-rated) | (auto-calc) | (auto-rank) |

| [Debt 1] | $ | % | $ | | | | | |

| [Debt 2] | $ | % | $ | | | | | |

| [Debt 3] | $ | % | $ | | | | | |

| [Debt 4] | $ | % | $ | | | | | |

| [Debt 5] | $ | % | $ | | | | | |

```

Google Sheets Formulas to Enter:

Assuming your data starts in row 2 with balances in column B, APRs in column C, minimums in column D:

Interest Rate Score (Column E):

```

=((C2-MIN($C$2:$C$6))/(MAX($C$2:$C$6)-MIN($C$2:$C$6)))*9+1

```

Balance-to-Minimum Ratio Score (Column F):

First calculate raw ratio in a helper column: `=B2/D2`

Then normalize and invert (lower ratio = higher score):

```

=((MAX($B$2:$B$6/$D$2:$D$6)-(B2/D2))/(MAX($B$2:$B$6/$D$2:$D$6)-MIN($B$2:$B$6/$D$2:$D$6)))*9+1

```

Hybrid Score (Column H):

```

=(E20.4)+(F20.35)+(G2*0.25)

```

Attack Rank (Column I):

```

=RANK(H2,$H$2:$H$6,0)

```

Payoff Comparison Section (add below your debt table):

```

PAYOFF METHOD COMPARISON

Method | Total Interest Paid | Months to Debt-Free | Interest Saved vs. Minimums

------------------------|---------------------|---------------------|-----------------------------

Minimum Payments Only | [calculate] | [calculate] | —

Snowball Order | [calculate] | [calculate] | $

Avalanche Order | [

You built the plan. You entered every account, calculated your payoff order, and felt that rare moment of clarity. Then a slow month hit — fewer hours, a cancelled contract, an unexpected expense — and the whole system collapsed because it assumed the same number every month.

That's not a discipline problem. That's a design problem. This chapter fixes it.

---

The Flex Payment Protocol™

The Flex Payment Protocol™ is a pre-built decision system that eliminates the guesswork when your income swings. Instead of staring at your accounts in a panic and making reactive, gut-feel decisions, you'll have three pre-calculated payment scenarios already loaded into your spreadsheet — and your dashboard will automatically tell you which one to execute based on the income number you enter that month.

The protocol has four components: your Minimum Viable Payment (MVP), your three payment tiers, your income thresholds, and the conditional formatting that activates the right tier automatically.

Step 1: Calculate Your Minimum Viable Payment (MVP)

Your MVP is the absolute floor — the total dollar amount that keeps every single account current with zero late fees, zero penalty APR triggers, and zero negative credit reporting. This is not your comfortable payment. This is your "the building is on fire and I can only grab one thing" payment.

For each debt account from your Debt Landscape Audit, pull the minimum payment required. Add them together. That sum is your MVP. Write it down. This number is sacred — it's the one payment you protect above everything else, including groceries if it comes to that, because a single missed payment can trigger penalty interest rates that undo months of progress.

Step 2: Define Your Three Payment Tiers

Step 3: Set Your Income Thresholds

Your thresholds are personal and must be calculated from your actual income history — not from what you think you earn or what you wish you earned. You'll do this in the worksheet below using your 12-month income history. The output will give you three clean numbers: your Survival ceiling, your Standard range, and your Accelerator floor.

Step 4: Build the Conditional Formatting Triggers

In your Google Sheet, create a single cell labeled "This Month's Income." When you enter your income, the entire dashboard shifts. Cells turn red in Survival Mode, yellow in Standard Mode, and green in Accelerator Mode. The payment column for each creditor auto-populates the correct dollar amount for that tier. You don't calculate anything. You enter one number and execute the instructions your spreadsheet gives you.

The formula logic uses nested `IF` statements tied to your threshold values. For example, if your Survival ceiling is $2,800 and your Accelerator floor is $3,400, your payment cell for a credit card with a $45 minimum and a $120 Standard payment might read: `=IF(B2<2800, 45, IF(B2<3400, 120, 185))` — where B2 is your income cell. Every creditor gets a formula like this. You build it once.

---

Real-World Example

Maria is a medical billing specialist and single mother of two in Phoenix. She earns roughly $52,000 annually, but her take-home varies between $2,600 and $4,100 per month depending on overtime availability. She carries five accounts: two credit cards ($6,200 and $3,800), a car loan ($11,400), a medical bill on a payment plan ($1,900), and a personal loan ($8,500). Her total MVP — the sum of all minimums — is $487.

After completing the 12-month income history analyzer in her Flex Payment Calculator, her volatility percentage comes out to 31% — high enough that the worksheet recommends a buffer of at least $340 above her MVP before she escalates to Standard Mode. Her thresholds land at: Survival below $2,900, Standard between $2,900 and $3,500, Accelerator above $3,500.

In March, a slow overtime month, she earns $2,740. Her dashboard turns red. She pays $487 total — minimums only — and moves on without guilt or second-guessing. In April, she earns $3,200. Dashboard turns yellow. She pays minimums on four accounts and sends $210 to her credit card with the highest interest rate (her current target). In June, she picks up two extra shifts and earns $3,850. Dashboard turns green. She sends $487 in minimums plus an additional $310 to her target card — a $797 total payment that month that shaves two months off her payoff timeline.

Maria never had to decide anything in real time. She built the system once and followed the colors.

---

Worksheet: The Flex Payment Calculator

Tab 1: Income History Analyzer

| Month | Gross Income | Take-Home Income |

|-------|-------------|-----------------|

| Month 1 | $_______ | $_______ |

| Month 2 | $_______ | $_______ |

| Month 3 | $_______ | $_______ |

| Month 4 | $_______ | $_______ |

| Month 5 | $_______ | $_______ |

| Month 6 | $_______ | $_______ |

| Month 7 | $_______ | $_______ |

| Month 8 | $_______ | $_______ |

| Month 9 | $_______ | $_______ |

| Month 10 | $_______ | $_______ |

| Month 11 | $_______ | $_______ |

| Month 12 | $_______ | $_______ |

---

Tab 2: MVP Calculator

| Creditor | Account Type | Minimum Payment | Current Balance | Interest Rate |

|----------|-------------|----------------|----------------|---------------|

| ________ | __________ | $_______ | $_______ | ____% |

| ________ | __________ | $_______ | $_______ | ____% |

| ________ | __________ | $_______ | $_______ | ____% |

| ________ | __________ | $_______ | $_______ | ____% |

| ________ | __________ | $_______ | $_______ | ____% |

Total MVP (sum of all minimums): $_______

---

Tab 3: Three-Tier Payment Planner

Define your thresholds first:

| Creditor | Survival Payment | Standard Payment | Accelerator Payment |

|----------|-----------------|-----------------|---------------------|

| ________ | $_______ | $_______ | $_______ |

| ________ | $_______ | $_______ | $_______ |

| ________ | $_______ | $_______ | $_______ |

| ________ | $_______ | $_______ | $_______ |

| ________ | $_______ | $_______ | $_______ |

| TOTAL | $_______ | $_______ | $_______ |

Conditional formatting color codes to apply:

---

Quick Checklist

---

Common Mistakes

You've built four powerful tools across the last four chapters — and right now they're sitting in separate tabs, doing their jobs in isolation. This chapter connects everything into a single command center that tells you, at a glance, exactly where you stand, what to do next, and how far you've come.

---

The 10-Minute Monthly Ritual™

The reason most debt trackers get abandoned isn't complexity — it's friction. When updating your system takes 45 minutes of cross-referencing, you skip a month. Then two. Then you're back to guessing.

The 10-Minute Monthly Ritual™ solves this by creating one master input sequence: a specific order of data entry, in specific cells, that auto-propagates through every connected tab. You enter numbers in one place. Everything else updates itself.

Here's how to build it.

---

Step 1: Create the DASHBOARD Tab

Add a new tab to your existing workbook and name it `DASHBOARD`. This becomes the first tab you see every time you open the file — your financial cockpit.

Set up the following named sections using bold headers in merged cells:

Step 2: Build the Summary Metrics Block

In cells B4 through B7, enter these formulas that pull live data from your existing tabs:

| Cell | Label (Column A) | Formula (Column B) |

|------|-------------------|--------------------|

| B4 | Total Debt Remaining | `=SUM(Audit!D2:D20)` |

| B5 | Total Interest Saved (vs. minimums) | `=Sequencer!H2` |

| B6 | Projected Debt-Free Date | `=Sequencer!I2` |

| B7 | Months Until Debt-Free | `=DATEDIF(TODAY(),B6,"M")` |

Your `Sequencer` tab (built in Chapter 3) already calculates your payoff order and projected timeline. Cell `I2` on that tab should contain your final payoff date based on the Momentum-Math Hybrid Method. If you haven't locked that formula in yet, go back to Chapter 3's worksheet and confirm it's outputting a date, not a number.

Step 3: Build the Debt-Free Countdown Timer

In cell D4, enter:

```

="🎯 " & B7 & " months to freedom"

```

In cell D5, enter a dynamic urgency line:

```

=IF(B7<=12,"You're in the final stretch.","Every extra dollar cuts this number.")

```

This isn't decoration — it's a psychological anchor. When your Flex Payment Protocol kicks in and you throw an extra $80 at debt in a variable-income month, this cell updates immediately to show you the new countdown.

Step 4: Connect the Flex Tab

Your `FLEX` tab from Chapter 4 contains your variable surplus calculations. Pull the current month's available flex payment into the dashboard:

| Cell | Label | Formula |

|------|-------|---------|

| B9 | This Month's Flex Payment | `=FLEX!C2` |

| B10 | Target Account This Month | `=Sequencer!A2` |

| B11 | Minimum Payments Total | `=SUM(Audit!F2:F20)` |

Now your dashboard tells you not just where you stand, but exactly what to do this month — which account gets the flex payment, and how much.

Step 5: Build the Month-Over-Month Progress Chart

In a separate section starting at row 12, create a running log table with these columns:

`Month | Total Debt | Debt Paid This Month | Months Remaining`

You'll manually enter the month and total debt figure once per month (this is the only manual entry in the entire system). The other columns calculate automatically:

Once you have 2+ months of data, select the Month and Total Debt columns, insert a Line Chart, and title it "Debt Destruction Timeline." Set the Y-axis minimum to your end goal ($0) and maximum to your starting total debt. Watching that line descend toward zero is more motivating than any app notification.

Step 6: Build the Wins This Month Auto-Section

In row 22, create a section that auto-populates based on thresholds you set. Use IF statements to generate plain-English wins:

```

=IF(B10-B4>0, "✅ Paid $" & TEXT(B10-B4,"$#,##0") & " toward " & B11 & " this month", "")

=IF(B7<DASHBOARD_PREV!B7, "✅ Cut your timeline by " & (DASHBOARD_PREV!B7-B7) & " month(s)", "")

=IF(Audit!D2<Audit_PREV!D2*0.9, "✅ One account now below 90% of its starting balance", "")

```

(Note: `DASHBOARD_PREV` refers to a simple archive tab you create by copying last month's dashboard values into a static reference tab each month — this is part of the Monthly Ritual below.)

Step 7: Set Up the Monthly Input Zone

This is the only section you touch each month. In rows 28–32:

| Cell | What You Enter |

|------|----------------|

| A28 | Today's date |

| A29 | Each account's current balance (one per row, matching Audit tab order) |

| A30 | This month's take-home income (from your most recent paycheck) |

| A31 | Any extra money available beyond minimums |

When you enter these four data points, every formula in the dashboard, sequencer, and flex calculator updates automatically. That's the system working for you.

---

The Monthly Ritual Card (10 Minutes, Every Month)

Pin this to your fridge or save it as a phone screenshot:

Do this on the same day each month — payday works best.

Total time: under 10 minutes. Total decisions required: zero. The system made them already.

---

Real-World Example

Scenario: Maria is a single mom in Phoenix earning $52,000 annually as a dental office manager. She has five debts: two credit cards ($4,200 and $9,800), a car loan ($11,400), a medical bill ($1,900), and a student loan ($22,000). Total: $49,300.

Before building the dashboard, Maria was logging into five separate accounts, making minimum payments, and had no idea whether she was making progress. She'd tried Mint but stopped using it after three months because it couldn't account for the months her hours got cut.

After completing Chapters 1–4, Maria had her Audit tab, Timing Blueprint, Sequencer (targeting the medical bill first via Momentum-Math Hybrid), and Flex Calculator set up.

In Chapter 5, she spent 90 minutes building the DASHBOARD tab on a Sunday afternoon. When she finished and entered her current balances, here's what her Summary Metrics Block showed:

The countdown timer read: "28 months to freedom. Every extra dollar cuts this number."

The following month, Maria had a slow week at work and only cleared $180 above minimums instead of her usual $300. She entered the number. The Flex tab routed the full $180 to the medical bill. The dashboard updated. Her projected payoff date moved by one month — but didn't collapse. The system adapted. She didn't have to.

By month four, her progress chart showed a clear downward slope. The medical bill was gone. The wins section read: "✅ Cut your timeline by 2 months. ✅ One account fully eliminated."

She hadn't opened Mint in six months.

---

Worksheet: The Master Dashboard Build Guide

Use this numbered instruction sheet to build your DASHBOARD tab from scratch. Work through it in order — each step depends on the previous one being complete.

---

PRE-BUILD CHECKLIST

Before starting, confirm these tabs exist in your workbook:

---

DASHBOARD BUILD SEQUENCE

BLOCK 1: Summary Metrics

```

Cell A4: "Total Debt Remaining"

Cell B4: =SUM(Audit!D2:D20)

Cell A5: "Total Interest Saved"

Cell B5: =Sequencer!H2

Cell A6: "Projected Debt-Free Date"

Cell B6: =Sequencer!I2

→ Format this cell

You've built your debt attack sequence, mapped your paycheck timing, and set up your flex payment protocol. Now comes the question every single-income household eventually hits: where does the extra money actually come from?

The answer is almost always already in your spending — just leaking out through seven specific holes that nobody told you to check.

---

The Surplus Extraction Scan™

This framework is a structured audit of the seven most common single-income money leaks. It's not about cutting lattes or canceling Netflix. It's about recovering dollars you're already spending on things you either don't use, overpay for, or could be reimbursed for — and auto-routing every recovered dollar directly to your debt attack sequence from Chapter 3.

Each leak has a realistic monthly recovery range based on income bracket ($35K–$55K and $55K–$75K annually). Work through all seven before deciding which ones apply to you. Most people find recoverable cash in at least four.

---

Leak 1: Subscription Stacking

Expected monthly recovery: $18–$65

Subscription creep is the single most common leak in this income range. The average household has 12–15 active subscriptions; most people can name seven. The rest are billing quietly.

Action steps:

---

Leak 2: Insurance Overpayment

Expected monthly recovery: $25–$90

Auto and renters/homeowners insurance rates are not fixed. They're negotiated — and most single-income households haven't renegotiated in 2–4 years. Rates change. Your risk profile changes. Competitors want your business.

Action steps:

---

Leak 3: Grocery Timing Waste

Expected monthly recovery: $30–$75

This isn't about couponing. It's about the gap between what you buy and what you actually consume before it expires. For single-parent households especially, buying in bulk without a consumption plan is a guaranteed money leak.

Action steps:

---

Leak 4: Utility Rate Neglect

Expected monthly recovery: $15–$45

Most utility providers offer budget billing, time-of-use rate plans, or low-income assistance programs that customers never request because they don't know to ask.

Action steps:

---

Leak 5: Bank Fee Tolerance

Expected monthly recovery: $12–$35

Monthly maintenance fees, out-of-network ATM fees, and overdraft fees are not inevitable. They're optional charges you've accepted by default.

Action steps:

---

Leak 6: Unused Benefit Gaps

Expected monthly recovery: $20–$80

Employer benefits, government programs, and credit card perks you're paying for but not using represent some of the cleanest money recovery available — because you've already "paid" for them.

Action steps:

---

Leak 7: Cashback Non-Optimization

Expected monthly recovery: $15–$50

If you're spending on a debit card or a non-rewards credit card, you're leaving money on the table on purchases you're already making.

Action steps:

---

Real-World Example

Maria is a single mother of two in Ohio, earning $52,000/year as a dental office manager. She carries $34,000 in mixed debt — two credit cards, a car loan, and a medical bill — and has been making minimum payments for 14 months. She completed Chapters 1–5 and identified her debt attack sequence. Her problem: she has roughly $80/month in flex payment capacity, but her avalanche target needs $200/month in extra payments to meaningfully accelerate.

She runs the Surplus Extraction Scan:

Total monthly recovery: $164/month.

Combined with her existing $80 flex capacity, Maria now has $244/month in extra payments — enough to eliminate her highest-interest credit card 11 months ahead of schedule and move her debt-free date forward by 16 months.

---

Worksheet: The Surplus Extraction Worksheet

Copy this tab into your Google Sheets tracker. For each section, enter your current cost, follow the reduction prompt, and enter your new projected cost. The sheet auto-calculates your total monthly recovery and feeds it into your debt attack sequence.

---

SECTION 1: SUBSCRIPTION AUDIT

| Subscription Name | Monthly Cost | Used in Last 30 Days? (Y/N) | Action (Cancel / Downgrade / Keep) | New Monthly Cost |

|---|---|---|---|---|

| _________________ | $_______ | _______ | _________________ | $_______ |

| _________________ | $_______ | _______ | _________________ | $_______ |

| _________________ | $_______ | _______ | _________________ | $_______ |

| _________________ | $_______ | _______ | _________________ | $_______ |

| _________________ | $_______ | _______ | _________________ | $_______ |

Section 1 Recovery = SUM(Current Costs) − SUM(New Costs) = $________

---

SECTION 2: INSURANCE AUDIT

| Policy | Current Monthly Premium | Competitor Quote 1 | Competitor Quote 2 | Competitor Quote 3 | New Monthly Premium |

|---|---|---|---|---|---|

| Auto | $_______ | $_______ | $_______ | $_______ | $_______ |

| Renters/Home | $_______ | $_______ | $_______ |

You built the system. You ran the numbers. You know your payoff order, your flex payment protocol, your timing map. And somewhere around month three, it all starts to feel like you're shoveling sand against the tide.

This chapter is about making sure that never happens — by engineering accountability directly into the spreadsheet you've already built.

---

The Visible Progress Engine™

Most debt payoff systems treat motivation as a personality problem. "Just stay disciplined." "Remember your why." That advice fails single-income households specifically because your financial stress is structural, not attitudinal. When you're managing one paycheck against five debt accounts, motivation doesn't collapse because you're weak — it collapses because the feedback loop is broken. You make a $200 extra payment on your Capital One card and the balance drops from $4,847 to $4,647, and it looks exactly the same as it did last month. Nothing feels real.

The Visible Progress Engine™ fixes the feedback loop. It's a four-component system built inside a dedicated tab in your Google Sheet that makes every dollar of progress impossible to ignore.

Step 1: Build the Debt Thermometer Chart

For each debt in your payoff sequence, create a visual progress bar using a simple formula. In your Progress Visualization Tab, set up a row for each debt with these columns: Debt Name, Original Balance, Current Balance, Percent Paid, and a Progress Bar column.

In the Percent Paid column, enter: `=(Original Balance - Current Balance) / Original Balance`

In the Progress Bar column, use this formula to generate a visual fill:

`=REPT("█", ROUND(Percent_Paid 20, 0)) & REPT("░", 20 - ROUND(Percent_Paid 20, 0))`

This creates a 20-character bar that fills with solid blocks as your balance drops. When you update your current balance each month (which you're already doing from the Debt Landscape Audit sheet), the bar fills automatically. No manual updates. No extra work. Just a visual that changes every single time you make a payment.

Step 2: Install Milestone Triggers

In a column next to each thermometer, add a milestone prompt formula:

`=IF(Percent_Paid>=1,"🎉 DEBT KILLED — Add to your Debts Killed Counter!", IF(Percent_Paid>=0.75,"⚡ 75% DONE — Final push. You've paid $"&TEXT(Original_Balance*0.75,"$#,##0")&" on this debt.", IF(Percent_Paid>=0.5,"🔥 HALFWAY — Interest is losing. Keep the pressure on.", IF(Percent_Paid>=0.25,"✅ 25% — Momentum is real. This is working.", "Keep going."))))`

These aren't decorations. They're pattern interrupts. When you open your sheet on a Tuesday night after a long shift and see "🔥 HALFWAY," your brain registers a win before you've consciously processed anything.

Step 3: Set Up the 'What If I Quit' Column

This is the most powerful tool in the entire chapter. In a column labeled "Cost of Quitting Today," enter a formula that calculates how much additional interest you will pay if you revert to minimum payments from today's date forward.

The formula uses your current balance, your interest rate, and your minimum payment to project total interest remaining under minimum-only payments — then subtracts the total interest remaining under your current accelerated plan.

`=((Current_Balance / Min_Payment_Rate) Monthly_Rate Current_Balance) - (Projected_Interest_Accelerated)`

You don't need to build this from scratch — a simplified version uses your existing data from the Flex Payment Calculator in Chapter 4. The number this column produces is the price of giving up. If that number reads $3,847 on your student loan, that's what quitting costs you. Not in some abstract future — in dollars you will actually hand to a lender.

Step 4: Build the Debts Killed Counter and Interest Saved Tracker

At the top of your Progress Visualization Tab, add two summary cells:

These two numbers are your scoreboard. They update automatically. They are the proof that the system is working even when your bank account doesn't feel like it.

---

Real-World Example

Maria is a single mom in Phoenix earning $52,000 as a dental hygienist. She has four debts: a $6,200 credit card at 24.99%, a $9,400 car loan at 7.9%, $18,000 in student loans at 5.8%, and a $2,100 medical bill with no interest. She built her payoff sequence in Chapter 3 using the Momentum-Math Hybrid Method — medical bill first for the quick win, credit card second because of the brutal interest rate.

By month three, she's paid off the medical bill and knocked $800 off the credit card. On paper, she's made real progress. But her credit card balance still shows $5,400, her car loan hasn't moved much, and she's exhausted. This is the exact moment most plans die.

She opens her Progress Visualization Tab. Her credit card thermometer reads: ██████░░░░░░░░░░░░░░ — 29% Paid. The milestone trigger fires: "✅ 25% — Momentum is real. This is working." Her Debts Killed counter reads 1. Her Cost of Quitting column on the credit card shows $2,340 — the extra interest she'd pay by reverting to minimums.

She also sees her Future Self Letter at the top of the tab, which auto-surfaced this week because she's at day 91. She wrote it on day one: "Maria — you were terrified you couldn't do this alone. Look at the thermometer. You killed one debt. You're almost 30% through the hardest one. Don't stop now."

She doesn't stop.

---

Worksheet: The Progress Visualization Tab

Set up a new tab in your Google Sheet titled "Progress Engine." Build the following sections:

---

SECTION 1: Debt Thermometers

| Debt Name | Original Balance | Current Balance | % Paid | Progress Bar | Milestone Prompt | Cost of Quitting |

|---|---|---|---|---|---|---|

| _____________ | $________ | $________ | [formula] | [formula] | [formula] | $________ |

| _____________ | $________ | $________ | [formula] | [formula] | [formula] | $________ |

| _____________ | $________ | $________ | [formula] | [formula] | [formula] | $________ |

| _____________ | $________ | $________ | [formula] | [formula] | [formula] | $________ |

---

SECTION 2: Scoreboard

| Debts Killed | Total Interest Saved to Date | Plan Start Date | Days Active |

|---|---|---|---|

| [COUNTIF formula] | $[formula] | _____________ | [TODAY()-Start] |

---

SECTION 3: Future Self Letter

In a merged cell block below your scoreboard, type your letter on Day 1. Title the cell range "OPEN ON DAY 91." Add conditional formatting to highlight this section in yellow when `=TODAY()-Start_Date >= 91`.

Write your letter here — minimum 5 sentences. Answer these prompts:

Your letter (write directly in the cell):

_______________________________________________

_______________________________________________

_______________________________________________

_______________________________________________

_______________________________________________

---

SECTION 4: What If I Quit Calculator

| Debt | Current Balance | Interest Rate | Min Payment | Months Remaining (Min Only) | Total Interest (Min Only) | Total Interest (Your Plan) | Cost of Quitting |

|---|---|---|---|---|---|---|---|

| _____________ | $________ | ____% | $________ | ________ | $________ | $________ | $________ |

| _____________ | $________ | ____% | $________ | ________ | $________ | $________ | $________ |

| TOTAL COST OF QUITTING | | | | | | | $________ |

---

Quick Checklist

---

Common Mistakes

You've spent months — maybe years — treating debt payments as the enemy. Now that the finish line is in sight, the biggest financial mistake you can make is not having a plan for the morning after your final payment clears.

The Payment Redirect Waterfall™

Most people who eliminate debt don't stay debt-free. They absorb the freed-up cash back into lifestyle spending within 90 days, then finance the next car, appliance, or emergency on credit — and the cycle resets. The Payment Redirect Waterfall™ is the structural answer to that trap. It takes the exact dollar amount you were sending to debt each month and routes it — automatically, sequentially — into a three-stage financial foundation before you ever have a chance to spend it.

The core principle: your payment habit is already built. You've been sending $400, $600, $800 a month to creditors. That muscle memory is an asset. The Waterfall keeps the same cadence and redirects the flow.

---

Stage 1: The $1,500 Emergency Buffer (Target: 30–60 days)

This is your firewall against rebound debt. Before you invest a single dollar, before you open a brokerage account, you need $1,500 sitting in a separate high-yield savings account labeled "Emergency Only." Not your checking account. Not a savings account you've dipped into before. A separate account with no debit card attached.

Why $1,500 specifically? Because it covers the most common single-incident emergencies for single-income households — a car repair, an ER copay, a broken appliance — without requiring you to reach for a credit card. This isn't your full emergency fund. It's your rebound-debt shield.

In your Google Sheet, add a column in your debt tracker called "Buffer Progress." Use this formula to track it:

```

=MIN(SUM(buffer_contributions), 1500)

```

When this cell hits 1,500, your sheet flags Stage 1 as complete and automatically unlocks Stage 2 calculations.

---

Stage 2: The 3-Month Income Reserve (Target: 3–9 months)

Once your buffer is funded, your full freed-up payment amount redirects to building a true income reserve — three months of your take-home pay. For a single-income household earning $45,000 annually, that's roughly $8,250 to $9,000 in accessible savings.

This stage takes longer, and that's intentional. You're not investing yet. You're building the cushion that prevents you from ever needing to borrow against an emergency again. Every month, your sheet calculates:

```

=ROUNDUP((income_reserve_target - current_savings) / monthly_redirect, 0)

```

This gives you a live "months remaining" countdown — the same motivational mechanic that made your debt payoff tracker work in Chapters 1 through 3.

---

Stage 3: Investment Auto-Calculation (Ongoing)

When Stage 2 is fully funded, your monthly redirect amount moves into investment contributions. Your sheet calculates a suggested split based on whether you have access to an employer 401(k) match (always capture the full match first), then routes remaining funds to a Roth IRA or taxable brokerage account.

The formula calculates your projected balance at retirement using a conservative 7% annual return:

```

=FV(0.07/12, months_to_retirement, -monthly_investment, -current_balance)

```

For a 34-year-old redirecting $520/month after debt payoff, this projects to approximately $612,000 by age 65 — from money that was previously disappearing into interest payments.

---

Real-World Example

Scenario: Maria, 38, single mother, $52K annual income, home health aide

Maria spent 22 months using the Momentum-Math Hybrid Method from Chapter 3 to eliminate $31,400 in mixed debt — two credit cards, a car loan, and medical bills. Her total monthly debt payment at peak was $740.

The week her final credit card balance hit $0, she opened the Payment Redirect Planner tab in her Google Sheet. It auto-populated her freed-up amount: $740/month.

Fourteen months after her last debt payment, Maria had $8,450 in savings and $1,480 in investment contributions. More importantly, when her car needed a $1,100 transmission repair in month 8, she paid cash — and never opened a credit application.

---

Worksheet: The Payment Redirect Planner

Tab Name: `Post-Debt Redirect`

---

Section 1: Your Freed-Up Payment Amount

| Field | Your Entry |

|---|---|

| Total monthly debt payments (at payoff) | $ ________ |

| Date of final debt payment | ________ |

| Redirect start date | ________ |

This number auto-populates from your debt tracker tab using:

```

=SUMIF(debt_status_range,"PAID",monthly_payment_range)

```

---

Section 2: Stage 1 — Emergency Buffer Tracker

| Field | Your Entry |

|---|---|

| Buffer target | $1,500 |

| Current buffer balance | $ ________ |

| Monthly contribution | $ ________ |

| Months to completion | (formula calculates) |

| Target completion date | (formula calculates) |

Formula for completion date:

```

=TODAY()+ROUNDUP((1500-current_buffer)/monthly_redirect,0)*30

```

---

Section 3: Stage 2 — Income Reserve Tracker

| Field | Your Entry |

|---|---|

| Monthly take-home pay | $ ________ |

| 3-month reserve target | (=take-home × 3) |

| Current reserve balance | $ ________ |

| Months to completion | (formula calculates) |

---

Section 4: Stage 3 — Investment Projection

| Field | Your Entry |

|---|---|

| Monthly investment amount | $ ________ |

| Current age | ________ |

| Target retirement age | ________ |

| Projected balance at retirement | (FV formula calculates) |

---

Section 5: Should I Take On This Debt? Calculator

Use this before financing anything — car, appliance, medical procedure, home repair.

| Field | Your Entry |

|---|---|

| Purchase price | $ ________ |

| Quoted interest rate | ________ % |

| Loan term (months) | ________ |

| Total cost with interest | (PMT formula calculates) |

| Monthly redirect amount available | $ ________ |

| Months to save-then-buy | (=purchase price / redirect) |

| Difference: borrow vs. save | (=total with interest − purchase price) |

The sheet flags any purchase where the interest cost exceeds 15% of the purchase price with a red cell and the note: "Consider saving first — you'll reach this in [X] months."

---

Quick Checklist

---

Common Mistakes

---

Your Action Plan

---

---

🗂️ Ready-to-Use Templates

---

Template 1: Monthly Variable Income Allocation Sheet

```

MONTH: _____________ | PAYCHECK DATE: _____________

TOTAL INCOME RECEIVED THIS MONTH: $___________

STEP 1 — FIXED NON-NEGOTIABLES (pay these first, no exceptions)

┌─────────────────────────────────┬──────────┬──────────┐

│ Expense │ Due Date │ Amount │

├─────────────────────────────────┼──────────┼──────────┤

│ Rent/Mortgage │ │ $ │

│ Utilities (electric, water, gas)│ │ $ │

│ Groceries (estimated) │ │ $ │

│ Transportation (gas/transit) │ │ $ │

│ Insurance (health/car/renters) │ │ $ │

│ Childcare / School fees │ │ $ │

│ TOTAL FIXED │ │ $ │

└─────────────────────────────────┴──────────┴──────────┘

STEP 2 — MINIMUM DEBT PAYMENTS (non-negotiable floor)

┌─────────────────────────────────┬──────────┬──────────┐

│ Creditor Name │ Due Date │ Minimum │

├─────────────────────────────────┼──────────┼──────────┤

│ 1. │ │ $ │

│ 2. │ │ $ │

│ 3. │ │ $ │

│ 4. │ │ $ │

│ 5. │ │ $ │

│ TOTAL MINIMUMS │ │ $ │

└─────────────────────────────────┴──────────┴──────────┘

STEP 3 — AVAILABLE ATTACK MONEY

Total Income: $___________

Minus Fixed: − $___________

Minus Minimums: − $___________

─────────────────────────────────

ATTACK MONEY: $___________

STEP 4 — THIS MONTH'S TARGET DEBT (from your Priority Tab):

Debt Name: _________________________ | Extra Payment: $___________

NOTES / INCOME IRREGULARITIES THIS MONTH:

___________________________________________________

___________________________________________________

```

---

Template 2: Debt Account Master Profile Card

(Complete one card per debt account — 7 cards maximum)

```

DEBT ACCOUNT PROFILE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Creditor Name: _______________________________

Account Type: [ ] Credit Card [ ] Medical Bill

[ ] Car Loan [ ] Student Loan

[ ] Personal Loan [ ] Other: ______

Account Number (last 4): ____

Customer Service Phone: ____-____-________

Online Portal URL: _______________________________

Login Username: _______________________________

CURRENT BALANCES & TERMS

Current Balance: $_______________

Interest Rate (APR): ________%

Monthly Minimum Payment: $_______________

Payment Due Date: ______ of each month

Promotional Rate Expires: _______________ (if applicable)

NEGOTIATION HISTORY

┌────────────┬──────────────────────┬──────────────────┐

│ Date Called│ Rep Name / ID │ Outcome │

├────────────┼──────────────────────┼──────────────────┤

│ │ │ │

│ │ │ │

│ │ │ │

└────────────┴──────────────────────┴──────────────────┘

PAYOFF GOAL

Target Payoff Date: _______________

Payoff Priority Rank: #___ (from your Priority Tab)

Total Interest Saved

vs. Minimum Payments: $_______________

NOTES:

___________________________________________________

___________________________________________________

```

---

Template 3: Irregular Income Smoothing Planner

(For freelancers and commission-based earners — use this when income swings more than $500 month-to-month)

```

INCOME SMOOTHING PLANNER

Month: _____________ | Year: _______

LAST 6 MONTHS OF ACTUAL INCOME

┌─────────────┬──────────────┬──────────────────────────┐

│ Month │ Gross Income │ Notes (big client, slow?) │

├─────────────┼──────────────┼──────────────────────────┤

│ │ $ │ │

│ │ $ │ │

│ │ $ │ │

│ │ $ │ │

│ │ $ │ │

│ │ $ │ │

│ 6-MO TOTAL │ $ │ │

└─────────────┴──────────────┴──────────────────────────┘

MY CONSERVATIVE MONTHLY BASELINE:

(6-Month Total ÷ 6, then subtract 15% safety buffer)

$__________ ÷ 6 = $__________ × 0.85 = $__________

↑ USE THIS NUMBER

INCOME TIER DECISION RULES (fill in once, use every month):

If I earn BELOW $__________ this month:

→ Pay fixed expenses + minimums ONLY

→ Freeze all extra debt payments

→ Action: _______________________________________

If I earn $__________ to $__________ this month:

→ Pay fixed + minimums + $__________ extra to target debt

→ Action: _______________________________________

If I earn ABOVE $__________ this month:

→ Pay fixed + minimums + $__________ extra to target debt

→ Put $__________ into Income Buffer Account

→ Action: _______________________________________

CURRENT INCOME BUFFER BALANCE: $___________

BUFFER TARGET (1 month of fixed expenses): $___________

BUFFER STATUS: [ ] Building [ ] Funded [ ] Depleted — Refilling

```

---

Template 4: Creditor Call Prep & Outcome Log

(Complete before every creditor phone call — takes 5 minutes, saves hundreds)

```

PRE-CALL PREPARATION SHEET

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

DATE OF CALL: _____________ | TIME: _____________

CREDITOR: ________________________________

PHONE NUMBER DIALED: ____-____-________

ACCOUNT #: ____________________________

MY CURRENT SITUATION (have this ready to state clearly):

Current Balance: $_______________

Current APR: ________%

On-Time Payment Streak: _______ months

Hardship Reason (if applicable):

[ ] Reduced hours [ ] Job loss [ ] Medical [ ] Divorce

[ ] Single income household [ ] Other: _______________

WHAT I'M ASKING FOR TODAY (check one primary goal):

[ ] Interest rate reduction — Target rate: ________%

[ ] Late fee waiver — Fee amount: $___________

[ ] Due date change — New preferred date: _______ of month

[ ] Hardship plan / payment pause — Duration: _____ months

[ ] Settlement offer — My offer: $_________ (___% of balance)

MY WALK-AWAY POSITION:

If they say no, I will: ________________________________

Competing offer I can reference: ______________________

CALL NOTES — REAL TIME

Rep Name: _______________ | Rep ID: _______________

Time on Hold: _______ min | Total Call Time: _______ min

What they offered:

___________________________________________________

___________________________________________________

Counter I made:

___________________________________________________

FINAL OUTCOME:

[ ] Got exactly what I asked for

[ ] Got partial win: _______________________________

[ ] Denied — Reason given: ________________________

[ ] Escalated to supervisor — Outcome: _____________

[ ] Called back — New rep: ________________________

DOLLAR VALUE OF THIS CALL: $___________

(interest saved + fees waived + payment reduction × months)

FOLLOW-UP REQUIRED:

[ ] Confirmation letter/email requested? [ ] Yes [ ] No

Expected by: _____________

[ ] Update Google Sheets dashboard with new rate/terms

[ ] Schedule next call: _____________

```

---

Template 5: Debt-Free Date Celebration & Accountability Contract

(Sign this, photograph it, tape it inside your debt tracker folder)

```

MY SINGLE-INCOME DEBT DESTRUCTION CONTRACT

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

I, _________________________, am starting this system on

_____________ with the following debts:

DEBT INVENTORY ON START DATE

┌────────────────────────┬──────────┬────────┐

│ Creditor │ Balance │ APR │

├────────────────────────┼──────────┼────────┤

│ 1. │ $ │ % │

│ 2. │ $ │ % │

│ 3. │ $ │ % │

│ 4. │ $ │ % │

│ 5. │ $ │ % │

│ 6. │ $ │ % │

│ 7. │ $ │ % │

│ TOTAL DEBT TODAY │ $ │ │

└────────────────────────┴──────────┴────────┘

MY PROJECTED DEBT-FREE DATE: _____________________

MONTHS FASTER THAN MINIMUM PAYMENTS: ____________

TOTAL INTEREST I WILL SAVE: $____________________

MY THREE NO

---

The only Google Sheets debt payoff system engineered specifically for single-income households that turns one unpredictable paycheck into a precise, automated debt-destruction machine — no budgeting apps, no complex software, just a spreadsheet that actually works when money is tight.

This product was designed for: Single-income households earning $35K–$75K annually (single parents, one-earner couples, freelancers with variable income) who carry $15K–$80K in mixed debt (credit cards, car loans, medical bills, student loans), have tried budgeting apps like YNAB or Mint but abandoned them, feel overwhelmed by competing financial advice, and desperately want a clear visual system they control — not another subscription. They're intermediate with Google Sheets (can enter data, use basic formulas) but don't know how to build financial models. Their core frustration: every debt payoff plan assumes two incomes or stable surplus cash, and they feel like the system wasn't built for them.

Your transformation: From staring at 4–7 debt accounts with no clear priority order and making scattered minimum payments that feel pointless → To operating a single, self-updating Google Sheets dashboard that shows your exact debt-free date, auto-calculates your optimal payment order each month, and adapts in real-time when your income fluctuates — with a proven path to eliminating $20K+ in debt 14–23 months faster than minimum payments alone.