Blog
Find the money: a budget worksheet for freeing cash to pay down debt
Track a month of spending, sort it into fixed, flexible and optional, and compute how much a realistic trim adds to your card payment and the months saved.
Can you name where last month's pay went? Most people can account for rent and the big bills and then lose track of a few hundred dollars that vanished into small purchases, renewals and habits. That untracked money is the first place to look in any budget when a card balance will not go down, because it is cash you already have. This worksheet takes an hour or two. You will record thirty days of spending, sort it into three groups, trim each by a realistic percentage, and then turn the freed cash into a new card payment and a payoff date. A filled-in example for an illustrative household, Jordan, runs alongside, so you can check your arithmetic against a worked case. If you would rather start with a faster, stricter version, see how to build a bare-bones budget when every dollar goes to card debt.
Part 1: Record one month of real spending
You cannot trim what you have not measured. Use the last thirty days, or better, the last full statement cycle of each account, and collect every source:
- checking account transactions,
- every credit card statement and any debit card or payment app,
- cash, which is the part people forget; if you do not remember, estimate from your ATM withdrawals,
- bills paid by autopay that you rarely look at.
Download the transactions as a spreadsheet if your bank allows it, or copy them by hand. Assign each a category from a short list of twelve at most: housing, utilities and phone, groceries, transportation, insurance, health, debt payments, household, clothing, dining out, subscriptions, entertainment and everything else. Do not argue with the numbers or judge them. At this stage you are an accountant, not a critic. Pay particular attention to the transactions that surprise you; they are where the money is.
If thirty days is not typical because of a trip, a repair or a holiday, add a note, then use a second month if you can. a monthly budget worksheet for people who pay for most things by card gives a longer version of the tracking sheet if you want one.
Part 2: Sort every line into fixed, flexible or optional
Put each category, and each large item in it, into one of three groups by asking a single question: how much control do I have this month?
| Group | What it means | Examples |
|---|---|---|
| Fixed | Set by a contract or a bill; changing it takes a decision that is not fast | Rent or mortgage, loan payments, insurance premiums, card minimum payment amounts, a car payment |
| Flexible | Must be spent on, but the amount is yours to shape | Groceries, fuel, household supplies, personal care, clothing basics, pharmacy |
| Optional | Could stop next month with no harm to health, housing, work or credit | Dining out, subscriptions, entertainment, hobbies, extra shopping, most gifts |
Sorting forces a useful honesty. Many people find that their "essentials" include optional items, and that some of their fixed costs are not as fixed as they assumed, such as an insurance premium that can be shopped or a phone plan that can be changed.
Part 3: The worksheet
Fill in each line from your own records. The lines are lettered so the math stays clear.
- A. Monthly take-home income. What lands in your account after taxes and deductions.
- B. Fixed total. The sum of all fixed lines, including every card's minimum payment.
- C. Flexible total. The sum of all flexible lines.
- D. Optional total. The sum of all optional lines.
- E. Total spending. B + C + D.
- F. Leftover or gap. A − E. A negative number means you are spending more than you earn, and the difference is going somewhere, usually onto a card.
- G. Flexible trim. C × your chosen percentage.
- H. Optional trim. D × your chosen percentage.
- I. Freed cash. G + H.
- J. Extra payment available. I + F. If F was negative, the first dollars of freed cash close the gap, and only the rest is extra.
- K. New card payment. The card minimums plus J.
Read line F before going further, because its sign tells you what kind of problem you have.
- F is negative. You are borrowing to live. The first job of any trim is to stop adding to the balance, and a payoff plan cannot succeed until that stops.
- F is near zero. You are breaking even, and the card balance is flat because every dollar is spoken for. The trims in lines G and H are the whole extra payment.
- F is positive but the balance is not falling. Money is leaving somewhere the record missed, usually cash or an account you left out. Go back to Part 1 before trimming anything.
For percentages, start modestly. A reasonable first try is 10 percent off flexible spending and 40 percent off optional, which are illustrative planning numbers, not rules. You can adjust them after the first month shows what is realistic.
Jordan's worksheet, filled in
Jordan takes home $4,100 a month. Here is the sorted record.
| Fixed | Monthly |
|---|---|
| Rent | $1,450 |
| Utilities, phone and internet | $260 |
| Insurance | $210 |
| Car payment and fuel | $450 |
| Card minimums | $190 |
| Student loan | $120 |
| B. Fixed total | $2,680 |
| Flexible | Monthly |
|---|---|
| Groceries | $520 |
| Household supplies | $90 |
| Personal care | $60 |
| Clothing basics | $80 |
| Pharmacy | $70 |
| Car maintenance, averaged | $60 |
| C. Flexible total | $880 |
| Optional | Monthly |
|---|---|
| Dining out and takeout | $240 |
| Subscriptions and apps | $78 |
| Entertainment | $110 |
| Hobbies and shopping | $150 |
| Gifts | $60 |
| Miscellaneous cash | $112 |
| D. Optional total | $750 |
Run the lines. E, total spending, is $2,680 + $880 + $750 = $4,310. F, leftover or gap, is $4,100 − $4,310 = −$210. Jordan is spending $210 more each month than the paycheck brings in, which explains why the card balance has not fallen despite paying the minimum on time.
With a 10 percent flexible trim and a 40 percent optional trim: G is $880 × 0.10 = $88 and H is $750 × 0.40 = $300, so I, freed cash, is $388. J, the extra payment, is $388 − $210 = $178, since the first $210 of freed cash only stops the borrowing. K, the new card payment, is $190 + $178 = $368.
Check it another way. Spending after the trims is $2,680 + $792 + $450 = $3,922, and $4,100 − $3,922 = $178, which matches J.
Where the optional trim might come from
A 40 percent cut sounds like a lot until it is broken into lines. Here is one way Jordan's $300 could come from the optional group:
| Category | Now | After | Trim |
|---|---|---|---|
| Dining out and takeout | $240 | $150 | $90 |
| Subscriptions and apps | $78 | $39 | $39 |
| Entertainment | $110 | $70 | $40 |
| Hobbies and shopping | $150 | $90 | $60 |
| Gifts | $60 | $45 | $15 |
| Miscellaneous cash | $112 | $56 | $56 |
| Total | $750 | $450 | $300 |
The subscription line is where a list helps. Say Jordan's $78 is $16 streaming, $11 music, $3 cloud storage, $15 fitness app, $9 news and $24 meal kit, which adds up to $78. Keeping the streaming service, music and storage ($30) and cancelling the other three costs the household nothing it cannot replace, and the new subscription total is $30, a little under the $39 target. Each cancellation can be reversed later if it turns out to matter.
Other places money hides
Before settling for the percentages, look for savings that do not change how you live.
- Fees and charges. Overdraft fees, late fees, ATM fees and card fees show up in the record. Each is avoidable, and a late fee is a reason to look at your payment due date alignment. Many issuers let you ask to move a due date to a day just after payday.
- Rates and renewals. An insurance renewal, a phone plan or an internet bill may be cheaper if you ask, compare or switch. A single call can lower a fixed cost for the whole year.
- Bills that creep. A free trial that converted, a price increase you never noticed, a second subscription to the same service.
- Irregular costs. Annual and quarterly bills, divided by twelve, belong in the monthly plan so they do not arrive as emergencies.
- One-time money. Selling items you do not use, a refund, an overtime shift. Send it to the card as a lump sum; do not fold it into spending.
Be careful with the large moves. Pulling money out of retirement savings, borrowing against a cash advance or skipping a minimum payment looks like finding money, and each costs more than it frees. Ask a tax professional before touching retirement accounts.
Part 4: Turn the extra payment into months
Now convert the new payment into a payoff date. Say Jordan's cards total $7,400 at an illustrative average of 22 percent APR, with no new charges after the trim. The monthly interest rate is r = 22% ÷ 12 = 0.01833, and the first month's interest is $7,400 × 0.01833 = about $136. The number of months to pay off a balance B with a fixed payment P is:
months = −ln(1 − r × B ÷ P) ÷ ln(1 + r)
For P = $368: r × B = $135.67, divided by $368 is 0.3687, so the bracket is 1 − 0.3687 = 0.6313. The natural log of 0.6313 is about −0.4600, and the natural log of 1.01833 is about 0.01817. Dividing gives about 25.3, so the balance is cleared with the 26th payment. The credit card payoff calculator and the credit card interest calculator run this for you; the formula is here so you can see what drives the result.
The table compares payments for the same $7,400 at 22 percent, using a month-by-month calculation with no new charges:
| Monthly payment | Months to clear | Total interest, roughly |
|---|---|---|
| $190 (today's minimums) | 69 | $5,693 |
| $250 | 44 | $3,366 |
| $300 | 34 | $2,539 |
| $368 (Jordan's new payment) | 26 | $1,917 |
| $450 | 20 | $1,488 |
Compare the first and fourth rows. Moving from $190 to $368 shortens the payoff from 69 months to 26, 43 months sooner, and cuts interest by about $3,776 ($5,693 − $1,917). That is the reward for freeing $178 a month. Note that these first results assume Jordan stops adding to the balance. Before the trim, with $210 of new charges a month, interest of about $136 and a $190 payment, the balance was growing by about $156 a month ($210 + $136 − $190).
If your income changes from month to month
The worksheet assumes one number for line A, which is hard when pay swings. Use a floor, not an average. Take the lowest take-home month of the last six and plan the whole budget on that, then treat anything above it as extra for the cards.
Say Taylor, who works variable shifts, took home $3,350, $4,200, $3,000, $3,800, $3,100 and $3,950 over six months. The total is $21,400 and the average is about $3,567, but the lowest month was $3,000. Taylor builds the budget on $3,000. In the six months, the amount above $3,000 was $350, $1,200, $0, $800, $100 and $950, which totals $3,400 ($21,400 − 6 × $3,000), and every dollar of that goes to the highest-rate card as a lump sum. The fixed bills are covered even in the worst month, no month is a surprise, and the good months do the paying down. The risk of budgeting on the average is that two slow months in a row arrive with bills set for a higher income, and the shortfall goes onto the cards.
Keep the worksheet alive
Do this once, then re-run it monthly in fifteen minutes.
- Record actual spending against each line.
- Where a trim did not hold, either adjust the plan or find the cause; a trim that fails every month was not realistic.
- When a card is paid off, its minimum rolls into the payment on the next card; do not spend it.
- Update balances and APRs when statements arrive, since the payoff date changes with them. why your card budget should follow the statement cycle, not the calendar shows how to line the plan up with your statement dates.
- Keep a small emergency fund so a surprise does not go back on a card; how to build a credit card payoff plan you can actually stick to covers where this fits in the whole plan.
Worksheet mistakes
- Counting gross pay. You cannot spend what the employer or the tax authority already took.
- Leaving out cash. Unrecorded cash is the usual reason the totals do not match the bank.
- Trimming fixed costs by guesswork. Check the actual bill first, then ask.
- Cutting so hard it fails. A plan that cannot survive two months is worse than a smaller one.
- Forgetting the gap. If F is negative, the first trims only stop new debt; they do not reduce the balance.
If even full trims leave you short, call each issuer before missing a payment, using the number on the back of your card, and ask about hardship options; how to ask your card issuer for a hardship program, call by call walks through the call. A nonprofit credit counselor can also review your numbers at no cost.
Key takeaways
- Track a full month of real spending, including cash, before deciding what to cut.
- Sort every line as fixed, flexible or optional, then apply a modest first trim, such as 10 percent of flexible and 40 percent of optional, and adjust after a month.
- If total spending exceeds income, the first freed dollars only stop the borrowing; in the example, $388 freed minus a $210 gap leaves $178 extra.
- At an illustrative 22 percent APR, raising a payment on $7,400 from $190 to $368 cuts the payoff from 69 months to 26 and interest from about $5,693 to about $1,917.
- Re-run the worksheet monthly and roll each cleared card's minimum into the next; avoid retirement withdrawals, cash advances and skipped minimums.