Cards and UPI

Calculating credit utilisation across several cards

Work out credit utilisation across several cards with a three-card example: each card's ratio, the combined figure and which card drives it.

Editorial illustration for Calculating credit utilisation across several cards

To calculate utilisation across several cards, work out each card's ratio, then add all the balances and divide by all the limits for the combined figure. The combined figure is not the average of the individual ratios, because a large card counts for more than a small one.

What does the three-card example look like?

Take three cards with made-up numbers. The statement balance is divided by that card's limit.

CardLimitBalanceUtilisation
Card A₹2,00,000₹30,00015%
Card B₹1,00,000₹45,00045%
Card C₹50,000₹5,00010%
All three₹3,50,000₹80,00022.9%

The last row: total balances ₹30,000 + ₹45,000 + ₹5,000 = ₹80,000, total limits ₹2,00,000 + ₹1,00,000 + ₹50,000 = ₹3,50,000, and ₹80,000 ÷ ₹3,50,000 = 0.2286, which is about 22.9 percent.

Why is the combined figure not a simple average?

If you average the three ratios, (15 + 45 + 10) ÷ 3, you get 23.3 percent. That is close here but not equal to 22.9, and the gap can widen when limits differ a lot. The combined figure weighs each card by its limit, which is why a ₹2,00,000 card moves it more than a ₹50,000 one.

Which card drives the number?

Card B holds ₹45,000 of the ₹80,000 total, which is 56.25 percent of all the balance, even though its limit is only 28.6 percent of the total limit (₹1,00,000 ÷ ₹3,50,000). That mismatch is the signal. One card carries most of the balance relative to its size.

  • Card A: 15 percent utilisation, 37.5 percent of the balance.
  • Card B: 45 percent utilisation, 56.25 percent of the balance.
  • Card C: 10 percent utilisation, 6.25 percent of the balance.

What happens if I pay down the high card?

Say you pay ₹20,000 towards Card B before its statement. Card B becomes ₹25,000 ÷ ₹1,00,000 = 25 percent. The combined balance falls to ₹60,000, so the combined figure is ₹60,000 ÷ ₹3,50,000 = 17.1 percent. Moving the same ₹20,000 off Card A instead would leave Card A at ₹10,000 ÷ ₹2,00,000 = 5 percent, Card B still at 45 percent and the combined figure the same 17.1 percent. The combined number is identical, but the individual ratios look very different, so decide which one you care about.

Redo the sums every month, because balances and limits both move. Keeping three or four months side by side shows whether Card B is a one-off or a pattern.

What if I add a new card or a limit changes?

The combined figure changes even if you spend exactly the same. Suppose you add a fourth card with a limit of ₹1,50,000 and no balance. The balances stay at ₹80,000, but total limits become ₹5,00,000, and ₹80,000 ÷ ₹5,00,000 is 16 percent, down from 22.9 percent. Nothing about your spending changed. That is why the log should record the limits month by month, so a drop in the ratio is not mistaken for better habits.

The reverse happens when an issuer reduces a limit, or when a card is closed: the same balances then look heavier against a smaller total. Note the date of each change.

How do I do this in a spreadsheet?

  1. List one card per row: card name in A, limit in B, statement balance in C.
  2. For each card, put =C2/B2 in column D and format it as a percentage.
  3. For the combined figure, use =SUM(C2:C4)/SUM(B2:B4) in a separate cell.
  4. For each card's share of the balance, use =C2/SUM($C$2:$C$4).
  5. Add a new set of rows each month, so you can see change over time.

The sheet is fine for a handful of cards. If you also want to see the transactions behind each balance, SpendixAI can hold each card as an account after you import its statement, while the limit stays in your sheet.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports