Most debt payoff spreadsheets and apps assume a tidy world: a balance, an interest rate, a payment every month. Then real life happens — a job loss, a medical stretch, a return to school — and a loan goes into forbearance or deferment. The payments stop, but on most loans the interest doesn’t, and a tracker that ignores that will quietly show you numbers that are wrong.
This guide walks through building a tracker — in Google Sheets or Excel — that models paused payments honestly.
Forbearance vs. Deferment: What Your Tracker Must Know
The two terms get used interchangeably, but the difference decides whether your balance grows during the pause:
| Forbearance | Deferment | |
|---|---|---|
| Payments required? | Paused or reduced | Paused |
| Interest accrues on subsidized federal loans? | Yes | No (government covers it) |
| Interest accrues on unsubsidized federal loans? | Yes | Yes |
| Interest accrues on private loans / mortgages? | Yes (terms vary by lender) | Yes (terms vary by lender) |
| Unpaid interest can capitalize afterward? | Often | Often (unsubsidized) |
Two takeaways for your tracker. First, “paused” almost never means “frozen” — for most loan types, the balance keeps growing. Second, capitalization is the expensive part: if accrued interest gets added to principal when the pause ends, you start paying interest on that interest for the rest of the loan. Your lender’s terms (or your federal loan servicer’s page) will say whether and when capitalization happens — read that before you model anything.
Set Up the Core Tracker
Create a sheet with one row per debt and these columns:
| Column | Example entry (illustrative) |
|---|---|
| Debt name | Unsubsidized student loan |
| Current balance | $30,000 |
| Interest rate (APR) | 6.0% |
| Minimum payment | $333 |
| Status | Forbearance |
| Pause start / end | 2026-07-01 to 2027-06-30 |
| Accrued unpaid interest | =balance × rate ÷ 12 × months paused |
| Capitalizes at end? | Yes |
The “Status” and “Accrued unpaid interest” columns are what generic trackers lack. For a simple monthly accrual estimate, the formula is:
= Balance * (APR / 12) * Months_PausedUsing the example numbers above: $30,000 × 0.5% × 12 months ≈ $1,800 of interest accrued during a one-year forbearance. If that capitalizes, your post-pause balance is about $31,800 — and your tracker’s payoff date should be computed from that number, not the old one. (This simple formula ignores compounding during the pause; most federal student loans accrue simple daily interest, so it’s close. For exact figures, use your servicer’s posted accrual.)
Model the Pause, Not Just the Payments
With the columns in place, three practices keep the tracker honest:
1. Log accrued interest monthly, even at $0 payments. Add a row per month (or a small table per paused loan) showing the growing accrued-interest figure. Watching that number climb is genuinely motivating — it turns an invisible cost into a visible one, and it tells you exactly what a small voluntary payment would neutralize.
2. Recalculate your payoff date when the pause ends. If interest capitalized, your effective balance jumped. Rerun your amortization math on the new balance. A spreadsheet NPER() formula does this cleanly:
=NPER(rate/12, -payment, new_balance)That returns the number of months to zero at your planned payment.
3. Decide in advance what happens to the freed-up cash. If a $333 payment is paused for a year, that money either becomes emergency-fund breathing room (often the right call — pauses usually happen because of hardship) or voluntary payments against accruing interest. Either is defensible; drifting into lifestyle spending is the failure mode. Put a row in the tracker for “pause cash plan” so the decision is written down.
Prioritizing Debts When Some Are Paused
The avalanche rule — extra money to the highest APR — still applies, but a pause changes the effective ranking:
- A subsidized loan in deferment accrues nothing. It drops to the bottom of the priority list for the duration; paying extra on it during the pause is literally the least efficient use of money in your plan.
- An unsubsidized loan in forbearance keeps accruing at full rate. If its APR is your highest, it stays your top target — voluntary payments during the pause go entirely toward keeping accrued interest at zero, which also prevents any capitalization hit later.
- Credit cards never pause (outside rare hardship programs), and at typical card APRs they usually outrank paused installment loans anyway.
So the working rule: rank by APR among debts that are actually accruing, and treat non-accruing paused debt as temporarily rate-zero.
Apps vs. Spreadsheet for This Job
Honest assessment: forbearance modeling is where budgeting apps are weakest. YNAB, Monarch Money, Rocket Money, Copilot Money, and Empower Personal Dashboard will all sync your loan balances and show the trend, which is useful — the balance creeping up during forbearance shows up automatically. But none of them let you model “payments paused for 12 months, interest capitalizes at month 13, then payments resume” as a first-class scenario.
A practical hybrid works well: use an app for live balances and your overall budget, and keep the pause math — accrual, capitalization, recalculated payoff dates — in the spreadsheet described above. The spreadsheet is maybe 30 minutes of setup and it’s the only tool in the stack that will answer “what will I actually owe when payments resume?”
Common Tracker Mistakes During a Pause
Three errors show up constantly in paused-loan tracking:
- Freezing the balance. Copying last month’s number forward for a loan in forbearance understates what you owe a little more every month. Accrue the interest even if you don’t pay it.
- Forgetting the capitalization event. The pause ending is a date your tracker should flag loudly — that’s when accrued interest may roll into principal and when your required payment may change.
- Treating the pause as permanent. Build the resumed payment back into your budget a month or two early. The single hardest month in any pause is the first one after it ends, and a tracker that shows the resume date and new payment amount removes the shock.
The Bottom Line
A pause in payments is not a pause in debt. Build your tracker so that forbearance and deferment periods show up as what they are — months where the balance usually grows — and you’ll come out of the pause with a plan instead of a surprise. Set up the status and accrued-interest columns today, before you need them; the worst time to build this tracker is mid-hardship.