Credit utilisation ratio is the share of your credit limit that you are using: outstanding balance divided by limit, shown as a percentage. A card with a ₹1,50,000 limit and ₹30,000 outstanding sits at 30,000 ÷ 1,50,000 = 20%. With two or more cards you can work it out card by card and also across all of them together, and the two answers can tell very different stories.
The formula in one line
Utilisation = outstanding balance ÷ credit limit × 100. Take the balance from your statement or card app and the limit from what your issuer has set. One common slip is using the available credit figure, which is the limit minus what you owe. That number is what is left, not what you have used.
A worked example with two hypothetical cards
All numbers here are made up for practice. Say Card A has a limit of ₹1,50,000 and ₹30,000 outstanding, and Card B has a limit of ₹50,000 and ₹40,000 outstanding.
| Measure | Working | Result |
|---|---|---|
| Card A alone | 30,000 ÷ 1,50,000 | 20% |
| Card B alone | 40,000 ÷ 50,000 | 80% |
| Both cards combined | (30,000 + 40,000) ÷ (1,50,000 + 50,000) = 70,000 ÷ 2,00,000 | 35% |
| Simple average of the two | (20% + 80%) ÷ 2 | 50%, which is misleading |
The simple average is wrong because it treats a ₹50,000 card and a ₹1,50,000 card as equal. The combined figure weights each card by its limit, so the bigger card counts for more. Looking at both views shows that Card B is stretched even though the overall picture looks moderate.
What changes if you pay part of Card B early?
Suppose you pay ₹20,000 towards Card B before the statement is generated. Card B's balance becomes ₹20,000, so 20,000 ÷ 50,000 = 40%. Combined, it becomes (30,000 + 20,000) ÷ 2,00,000 = 50,000 ÷ 2,00,000 = 25%. The cash you spent did not change, but the balance on the statement did. Which balance a lender or credit bureau sees, and on what day, depends on the issuer, so check your own statement and ask the issuer rather than assuming.
When in the billing cycle should a tracker record the balance?
- On the statement date: note the closing balance and the limit for each card.
- On the day you pay: note the amount, the card and the date, so the balance after payment is clear.
- Once mid-cycle: a quick look at the card app shows whether a big purchase has pushed one card far above the others.
- After any limit change: write down the new limit with the date, so old ratios are not recalculated against it.
How do you keep this in a sheet or a tracker?
A tiny sheet is enough. Put card names in A2:A3, balances in B2:B3 and limits in C2:C3. In D2 write =B2/C2 and fill down, then format the column as a percentage. For the combined figure use =SUM(B2:B3)/SUM(C2:C3). Add a date column so each month gets its own row.
If your card spends are scattered across several statements, SpendixAI can help with the other half of the job. You pick the card as the account before uploading its statement in PDF, CSV or Excel, review the rows, and each transaction keeps its card. It does not calculate utilisation or store limits, so the balance and limit still come from your statement and issuer.
A short monthly routine
- Write down each card's statement balance and limit on the statement date.
- Calculate each ratio and the combined ratio, and note which card is highest.
- If one card is much higher than the others, check whether a payment before the statement date is practical.
- Keep the limits column current, because ratios against an old limit mislead.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


