Blog
A monthly budget worksheet for people who pay for most things by card
Fill in take-home pay, bills and one statement's categories to find what is really left, then reconcile it with the card balance. Example figures are invented.
If most of your spending goes through a card, your statement is already a good record of where the money went. What it does not tell you is what is left. A bank balance can look healthy in the middle of the month because the card bill has not come due yet, and a card balance can look manageable because the minimum payment is small. This worksheet builds one number you can trust: what remains after fixed bills, card spending and interest, and then checks it against what happened to the card balance. You will need your last statement, your last pay stub or deposit record and about thirty minutes.
All the figures in the example are invented for a person named Jamie. They are illustrations, not typical incomes or prices. Replace them with your own, line by line.
Step 1: write down your take-home income
Use the money that lands in your account, after taxes and payroll deductions, not the salary figure. If you are paid every two weeks, multiply a paycheck by 26 and divide by 12 to get a monthly average, since some months contain three paychecks. If pay varies, use the lowest of your last three months, and treat anything above it as extra for the month it arrives.
Jamie's take-home pay is $4,200 a month. (An example: two deposits of $2,100 would be $4,200 in a month that has two paychecks.)
| Line | Your number |
|---|---|
| Take-home pay | $ ______ |
| Other regular income (child support, side work, benefits) | $ ______ |
| Total monthly income | $ ______ |
Leave out one-time money such as a tax refund or a gift. That money has a better use as a cushion or as extra payment on a balance than as part of the monthly plan.
Step 2: list the fixed bills that do not go on a card
Fixed bills are the ones whose amount is about the same every month and that you pay from your bank account. For Jamie:
| Bill | Amount |
|---|---|
| Rent | $1,350 |
| Utilities | $210 |
| Car insurance | $140 |
| Student loan payment | $180 |
| Phone | $65 |
| Internet | $60 |
| Total fixed bills | $2,005 |
Check the arithmetic: 1,350 + 210 = 1,560; + 140 = 1,700; + 180 = 1,880; + 65 = 1,945; + 60 = 2,005.
If one of your fixed bills goes on a card instead, do not list it here, or you will count it twice. It belongs in Step 3. The rule for the whole worksheet is that every dollar appears in exactly one place.
Bills that come once or twice a year, such as an insurance premium, vehicle registration or tuition, are fixed bills too. Divide them by twelve and include the monthly share here, even if you pay them in one lump. A sinking fund is an account where that monthly share is set aside, and the post how to pay annual and irregular bills by card without wrecking a month shows how to run one.
Step 3: sort one statement's purchases into categories
Open your most recent card statement. Add up the purchases by category. Ignore payments, credits and interest for now. Most issuers' apps and statements will already group purchases, but their categories rarely match how you think about spending, so sort them yourself if it is quicker. Write each charge on one line, then total.
Jamie's statement shows these purchase totals:
| Category | Amount |
|---|---|
| Groceries | $520 |
| Dining out | $240 |
| Gas | $160 |
| Shopping | $190 |
| Health and pharmacy | $85 |
| Subscriptions | $54 |
| Entertainment | $75 |
| Everything else | $110 |
| Total purchases | $1,434 |
The check: 520 + 240 = 760; + 160 = 920; + 190 = 1,110; + 85 = 1,195; + 54 = 1,249; + 75 = 1,324; + 110 = 1,434.
If you use more than one card, do this for each and add them. If you spend cash or debit for anything, add a line for it, because the aim is every dollar you spent.
Two cautions. First, a statement covers a billing cycle, which rarely matches a calendar month. Use whichever statement you are working from consistently, and read why your card budget should follow the statement cycle, not the calendar for why mixing the two double counts some weeks. Second, charges that were still pending when the statement closed will show on the next one. Do not worry about the overlap if you do the worksheet every month; the gaps average out.
For a line-by-line review of the statement itself, including fees and unfamiliar merchants, use a monthly statement review worksheet, line by line, in about 15 minutes. For the subscription line, a subscriptions audit worksheet for the recurring charges on your cards shows how to audit it.
Step 4: add interest and fees
If you carry a balance, the finance charge on your statement is a cost of last month's spending. Write it in. Jamie carries a balance from the previous month of $2,100 at an illustrative APR of 21.6 percent, so the monthly interest is about $2,100 × 0.216 ÷ 12 = $37.80, which we round to $38. A real statement uses a daily rate and your average daily balance, so your number will differ slightly. To see how, read work out one month of card interest by hand with average daily balance.
Add any fees (annual, late, foreign transaction) the same way. Jamie had none, so the total for this step is $38.
Step 5: find the number that matters
Now subtract:
Income − fixed bills − card purchases − interest and fees = what is really left
Jamie: $4,200 − $2,005 − $1,434 − $38 = $723.
Check: 4,200 − 2,005 = 2,195; − 1,434 = 761; − 38 = 723.
That is the amount Jamie has available each month for everything not yet in the budget: saving, extra card payments, irregular costs, fun. It is a number made of real spending, because it comes from the statement and not from memory.
Step 6: reconcile it with the card balance
This step catches the mistake that most budgets miss. A budget that says $723 is left should leave the card balance flat or falling if the $723 is truly kept aside. Check by writing the card's balance equation:
new balance = old balance + purchases + interest − payments
Jamie's old balance was $2,100. Purchases were $1,434 and interest $38. Suppose Jamie made payments of $1,100 during the cycle. Then:
New balance = 2,100 + 1,434 + 38 − 1,100 = $2,472.
The balance rose by $372. Here is how that squares with the $723 figure. The money that left Jamie's bank account for the card was $1,100, and the bank bills were $2,005, so the bank view looks like this:
- Income $4,200 − bank bills $2,005 − card payment $1,100 = $1,095 still in the bank.
That $1,095 looks like comfortable room. But the true amount left was $723, and the difference, $1,095 − $723 = $372, is exactly the amount the card balance grew. The bank account looks richer than Jamie is, because $372 of this month's spending was put on credit and has not been paid for yet.
| View | Calculation | Result |
|---|---|---|
| Bank view | 4,200 − 2,005 − 1,100 | $1,095 |
| Spending view | 4,200 − 2,005 − 1,434 − 38 | $723 |
| Difference | Card balance growth | $372 |
If the difference on your worksheet is not equal to the change in your balance, something is missing: an unrecorded charge, a refund, a payment you forgot or a fee. Find it before going on.
The lesson is general. When a card does the paying, the bank balance is a delayed signal of spending. The statement is the real-time one.
Step 7: set targets by category
Now decide what you want each category to be next month. Use last month as a baseline and change only the lines you have a reason to change. Do not cut everything at once; a plan that requires heroic restraint fails in the second week.
Jamie decides to move $300 a month toward the card balance and keep $200 as a cushion, leaving $223 unassigned. To fund it, Jamie sets these targets:
| Category | Last statement | Target |
|---|---|---|
| Groceries | $520 | $500 |
| Dining out | $240 | $180 |
| Gas | $160 | $160 |
| Shopping | $190 | $140 |
| Health and pharmacy | $85 | $85 |
| Subscriptions | $54 | $40 |
| Entertainment | $75 | $60 |
| Everything else | $110 | $90 |
| Total | $1,434 | $1,255 |
Savings from the targets: $1,434 − $1,255 = $179. That frees $179 more per month, on top of the $723.
Interest should also fall as the balance shrinks. If Jamie pays $300 more than before and keeps spending at target, the balance falls instead of rising. The credit card payoff calculator can show how many months a given payment takes at your rate.
Step 8: choose how you will watch it
The worksheet is a monthly snapshot. A card makes it easy to overspend between snapshots, so add a lightweight check:
- A weekly look. Ten minutes on the same day each week: open the card app, glance at the category totals so far, compare to the targets.
- Alerts. Most issuers let you set transaction or balance alerts. A notification when spending in a day passes an amount you choose is a cheap guardrail.
- A pay-it-down habit. Pay the card in the middle of the cycle as well as at the end. It keeps the balance lower and reduces the surprise when the statement comes.
- autopay for the minimum at least, so a missed date never makes a late fee or a mark on your record. Do not rely on autopay for the full plan unless you have checked the money will be in the account.
Variations and common gaps
When your income is not steady
The example assumed the same paycheck every month. Many people do not have that: hourly workers whose hours move, people with commissions, gig drivers and freelancers. The worksheet still works if you change two habits.
First, base the plan on a low month, not an average one. Look at your last six months of take-home pay and use the lowest, or the second lowest if the lowest was truly unusual. Suppose a delivery driver, Marcus, took home $3,100, $3,600, $2,800, $3,900, $3,300 and $3,500 over six months. The lowest is $2,800 and the average is (3,100 + 3,600 + 2,800 + 3,900 + 3,300 + 3,500) ÷ 6 = 20,200 ÷ 6 = $3,367. Planning on $2,800 means that in five of the six months there is extra money, and the plan never depends on a good month arriving.
Second, run a buffer in the bank account. Budgets built on a low month still break when a month comes in under that. A small cushion, even a few hundred dollars at first, keeps the card from filling the gap. The post when gig income dips: use a card as a buffer or build a cash reserve? works through that trade-off.
For the overflow months, decide ahead of time where extra money goes, in order: the cushion until it reaches the amount you chose, then any card balance that carries interest, then savings goals. Writing the order down once prevents spending the surplus by default.
A second household: two people, two cards
The worksheet changes a little when two adults share expenses. Take an invented couple, Dana and Chris, whose combined take-home pay is $6,800 a month. They have two cards: Dana's carries groceries, dining and gas, and Chris's carries subscriptions, shopping and entertainment. Their fixed bills from the bank total $3,450.
Step 3 for two cards means one table per card, then a combined total:
| Dana's card | Chris's card | Combined | |
|---|---|---|---|
| Groceries | $710 | $0 | $710 |
| Dining out | $320 | $40 | $360 |
| Gas | $210 | $0 | $210 |
| Shopping | $60 | $280 | $340 |
| Subscriptions | $0 | $95 | $95 |
| Entertainment | $30 | $120 | $150 |
| Total | $1,330 | $535 | $1,865 |
Check: Dana's column 710 + 320 + 210 + 60 + 0 + 30 = 1,330; Chris's 0 + 40 + 0 + 280 + 95 + 120 = 535; together 1,865.
Suppose neither carries a balance and interest is zero. What is left: $6,800 − $3,450 − $1,865 = $1,485. The reconciliation is also simpler when both pay in full: each card's payment equals its purchases, so the bank view and the spending view agree.
The risk with two cards is double counting and blind spots: Dana may think Chris's card covers a charge that landed on hers, and the combined view has to be built by someone every month. The post Should I use one card or several to keep my budget under control? weighs one card against several for exactly this reason.
The most common gaps in a card budget
If your reconciliation in Step 6 does not match, look for these first:
- A recurring charge you forgot. Annual subscriptions, insurance that bills a card, a gym that charges quarterly. They show up as one-off large charges in some months.
- A refund or credit. Returns lower the balance without being payments. Count them as negative purchases.
- Cash back or statement credits. A reward posted as a credit will lower the balance too, and it is easy to confuse with a payment.
- A payment made after the statement closed. It will appear on the next statement. Use the dates, not the amounts, to decide which month it belongs to.
- Interest on a cash advance or balance transfer that sits at a different rate than the purchase balance. The finance charge line may be a blend.
- A joint or authorized-user card whose charges you forgot to include.
If something looks wrong that is not on this list, check for a charge you do not recognize. That is a different problem and the statement review post covers it.
A blank worksheet to copy
Print or copy this and fill it in with your own numbers. Every dollar appears once.
- Take-home pay this month: $ ______
- Other regular income: $ ______
- A. Total income: $ ______
- Fixed bills paid from the bank, total: $ ______ (list each below)
- Card purchases by category, total: $ ______ (list each below)
- Interest and fees on the card: $ ______
- B. Total outflow (4 + 5 + 6): $ ______
- A − B = what is really left: $ ______
- Card balance at the start of the cycle: $ ______
- Card payments made: $ ______
- Card balance at the end: $ ______
- Check: line 9 + line 5 + line 6 − line 10 should equal line 11. Differences to chase: $ ______
Keep each month's copy. After three months you will see which categories move and which do not, and you can set targets from your own pattern instead of a guess.
Reading your result
What your own number means:
- Left is positive and the card balance fell or stayed flat. The plan is sound. Decide where the leftover goes: a cushion first, then extra payment on any balance that carries interest.
- Left is positive but the card balance rose. Something is unrecorded. Redo Step 3 and Step 6.
- Left is zero or negative. You are spending more than you earn, and the card is covering the gap. Look at the biggest lines, starting with the ones you can change soonest. If minimum payments are out of reach this month, the post I can not make my card payments this month. What are my options? covers what to do, and a nonprofit credit counselor, such as an agency affiliated with the NFCC, can review the whole picture. Never skip a minimum payment to cover something else.
- Left is positive and there is no balance at all. Good. Decide a saving target and keep using the worksheet quarterly.
If you find a charge you do not recognize while doing this, call the number on the back of your card, and the CFPB complaint process is available if the issuer does not resolve it.
Key takeaways
- Build the budget from a statement and your take-home pay, with every dollar counted once: fixed bills in one place, card purchases in another.
- The number that matters is income minus fixed bills, card purchases and interest. Jamie's was $723.
- Reconcile with the card equation new balance = old balance + purchases + interest − payments. A gap between the bank view and the spending view equals the change in your balance.
- Set category targets from last month's actuals, change a few lines and check weekly instead of monthly.
- If the leftover is negative, address the gap before it grows, and ask a nonprofit credit counselor for help rather than skipping minimum payments.