Credit utilisation is the balance on a card divided by its limit, shown as a percentage, and you track it by recording each card's limit and statement balance every month and dividing. Track each card and the combined total, since both can look different from each other.
What is utilisation, in plain terms?
If a card has a limit of ₹1,00,000 and shows a balance of ₹40,000, utilisation is 40,000 divided by 1,00,000, which is 40 percent. A bureau such as CIBIL looks at the balances and limits that your issuers report. How a given level affects your score is for the bureau and your report to say; do not rely on a rule of thumb you read elsewhere without checking its source.
Which balance gets reported, and when?
This is the practical question, and it depends on the issuer. Some report the statement balance, some report at another point in the cycle. Ask your issuer when and what it reports, and compare it with the date on your credit report. Then you know which day matters for paying down.
A worked example with invented limits
Say you have two cards and these are the figures on the latest statements.
| Card | Limit (₹) | Statement balance (₹) | Utilisation |
|---|---|---|---|
| Card A | 1,50,000 | 60,000 | 40.0% |
| Card B | 80,000 | 52,000 | 65.0% |
| Combined | 2,30,000 | 1,12,000 | 48.7% |
Check: 60,000 / 1,50,000 = 0.40. 52,000 / 80,000 = 0.65. Combined limit 1,50,000 + 80,000 = 2,30,000, combined balance 60,000 + 52,000 = 1,12,000, and 1,12,000 / 2,30,000 = 0.487, about 48.7 percent.
Now suppose you pay ₹30,000 on Card B before its statement day. Its balance becomes 22,000, and 22,000 / 80,000 = 27.5 percent. Combined: 60,000 + 22,000 = 82,000, and 82,000 / 2,30,000 = about 35.7 percent. That is the kind of comparison the tracker lets you make before spending any money.
How do I set up the tracker?
- Columns: Card, Limit, Statement date, Statement balance, Utilisation, Planned payment, After payment.
- Utilisation in E2: =D2/B2. Format as a percentage.
- After payment in G2: =(D2-F2)/B2.
- Combined row: =SUM(D2:D5)/SUM(B2:B5), with the range covering all your cards.
- Update on every statement date.
What can I do about a high figure?
- Pay part of the balance before the day your issuer reports, if that is possible for you.
- Spread spending across cards when it makes sense, rather than loading one.
- Ask the issuer whether a limit review is available; it is their decision.
- Avoid opening new cards just to change the ratio, since an application can have its own effect.
Where does a tracker app help?
The limit lives in your sheet, but the balances come from statements. SpendixAI lets you upload card statements as PDF, CSV or Excel, review the rows, and see the monthly card spend. It does not fetch your limit or your credit score, so keep those in the sheet.
How often should I look at the figures?
Monthly is enough for most people: on each statement date, update balances, and a few days later check how the issuer's app shows the figure. Once a quarter, compare your sheet with the bureau report. If you plan to apply for a loan, look a couple of months ahead so you have time to adjust balances rather than rushing in the final week.
A closing checklist
- Limits copied from statements or the card app.
- Balance recorded on each statement date.
- Per-card and combined percentages calculated.
- Payment planned before the reporting day.
- Credit report compared once a quarter.
For personal advice about your credit profile, ask a qualified adviser.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

