To see what carrying a credit card balance really costs, make a sheet with one row per month: the balance carried, the interest or finance charge printed on the statement, any late fee, and a running total for the year. Six rows in, the total stops being abstract. The example below uses invented figures.
Which columns does the sheet need?
- Month: the statement month, such as June.
- Balance carried: the part of the previous bill you did not pay in full, as shown on your statement.
- Interest or finance charge: the line on the statement that shows what was charged for carrying that balance.
- Late or other fee: any separate fee line, kept in its own column so you can see it.
- Total cost this month: interest plus fee.
- Running total: everything charged since the start of the sheet.
Copy the figures from the statement itself. Do not work them out from a rate you remember, because issuers differ in how they calculate charges, and some statements show tax on charges as a separate line. If yours does, give it its own column or add it to the fee column, and note which you chose.
What does a six-month example look like?
These numbers are made up to show how the sheet works. They are not typical, and the charges on your own card will differ.
| Month | Balance carried | Interest or finance charge | Late fee | Cost this month | Running total |
|---|---|---|---|---|---|
| June | ₹25,000 | ₹900 | ₹0 | ₹900 | ₹900 |
| July | ₹22,000 | ₹790 | ₹0 | ₹790 | ₹1,690 |
| August | ₹18,500 | ₹650 | ₹0 | ₹650 | ₹2,340 |
| September | ₹15,000 | ₹520 | ₹0 | ₹520 | ₹2,860 |
| October | ₹9,000 | ₹310 | ₹0 | ₹310 | ₹3,170 |
| November | ₹4,000 | ₹140 | ₹0 | ₹140 | ₹3,310 |
Over six months, ₹3,310 of charges came from carrying a balance that fell from ₹25,000 to ₹4,000. Seeing ₹3,310 in one cell often changes how a person thinks about the next ₹5,000 purchase, without anyone having to lecture them.
Which formulas keep the sheet tidy?
With the headings in row 1 and the first month in row 2, put these in Excel or Google Sheets. Columns are A month, B balance carried, C interest or charge, D late fee, E cost this month, F running total.
- In E2: =C2+D2, then copy it down.
- In F2: =SUM($E$2:E2), then copy it down. The fixed start cell makes it a running total.
- In a spare cell, =SUM($E$2:$E$13) totals twelve months once the year is filled in.
- In G2 (optional): =C2/B2, formatted as a percentage, shows the charge as a share of the balance for that month.
The last formula is a useful sanity check. If the share jumps from one month to the next without a reason, read that statement again.
Why is the interest column better than the total bill?
The bill mixes spending, repayments and charges. The interest and fee lines show the cost of borrowing on the card, and nothing else. Isolating it also shows whether the cost is falling as your balance falls, as it does in the example, or whether new spending is refilling the balance each month.
What do you do when the sheet shows a high number?
You can do three things, in this order. Pay more than the minimum when you can, since the minimum usually leaves most of the balance in place. Stop adding new spending to that card while a balance is carried. And if the amount is large, ask your issuer what options it offers for repayment, and compare any offer's total cost, not just the monthly amount.
When the sheet is not enough, SpendixAI lets you import the card statement as a PDF, CSV or Excel file, pick the card as the account and review the rows, which makes the monthly charge easy to find among the other transactions.
A monthly routine
- When the statement arrives, copy the carried balance, interest and fee lines into the sheet.
- Check the running total and the share of balance.
- Write one line of what you will do differently next month, such as a specific extra payment on a specific date.
- Review the total each quarter, not each day.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

