Credit Card Percentage Calculator: Utilization Ratio

Quick Answer: Your credit utilization ratio is the balance on a card divided by its credit limit, shown as a percentage. Work it out per card (=Balance/Limit) and overall (=SUM(balances)/SUM(limits)). Three cards with $1,850, $600 and $0 owed against limits of $5,000, $12,000 and $3,000 give 37%, 5% and 0% individually and 12.25% overall. Use the balance on each statement, since that is usually the figure the issuer reports.

A credit card percentage or ratio calculator usually means credit utilization: how much of your available credit you are using. It takes two numbers per card, both printed on the statement, and one division. A spreadsheet adds the useful part, the per-card and overall figures side by side, tracked month after month, so you can see how a single large balance moves the total.

What is the formula for credit utilization?

For one card:

utilization = balance ÷ credit limit

For all your cards together:

overall utilization = sum of all balances ÷ sum of all credit limits

The CFPB describes the idea in one line: part of your score is based on "the amount of credit you're using, divided by the total amount you have available" (does closing a credit card hurt my credit?). FICO's explanation of amounts owed calls the same figure the credit utilization ratio on revolving accounts, the percentage of your available credit you are using.

Neither source publishes a target percentage, and this article does not promise what any particular ratio does to a score. Scoring models weigh it together with everything else in your report.

Building the calculator: one row per card

Set up a sheet with these columns:

Below the cards, an overall row:

• C6: =SUM(C2:C4)
• D6: =SUM(D2:D4)
• E6: =IFERROR(C6/D6,0)

The IFERROR guards against a card whose limit you have not filled in yet, which would otherwise show #DIV/0!. Do not average column E to get the overall figure; that weights a $500-limit card the same as a $15,000 one.

A worked example with three cards

Two observations come straight out of the table.

First, overall utilization can look low while one card is heavily used. The everyday card is at 37% even though the total is 12.25%. A lender reading your credit report sees each card's balance and limit, not only the total, which is why the sheet keeps both.

Second, the zero-balance store card still matters. Its $3,000 limit is part of the denominator. Remove it, as happens if the account is closed, and the same $2,450 of balances sits against $17,000 of limits: 14.4%. The CFPB makes the same point, that closing a card can raise your utilization ratio. That is arithmetic, not a recommendation to keep any particular account open.

Which balance should you use: statement or current?

Use the statement balance. Many issuers report the account to the credit bureaus around the statement closing date, so the balance on the statement is generally what a lender later sees, even if you pay it in full a few weeks afterwards. Paying on the due date clears the debt and avoids interest, but it happens after the balance has already been reported.

That timing is why two people who both pay in full every month can show very different utilization. Someone who charges $4,000 every month on a $5,000 card and pays it all on the due date shows about 80% on that card each month. If they paid $3,000 a few days before the closing date instead, the statement balance and the reported figure would be closer to $1,000, or 20%.

Issuers' reporting dates vary, and some report more than once a month; ask yours if precision matters. The mechanics of which charges land on which statement are covered in the credit card closing date guide, and the gap between the two balances in your app is explained in statement balance vs current balance.

Working backwards: what balance gives a chosen ratio?

Sometimes the useful question is the reverse one: how much would I need to pay before the closing date to bring a card down to a level I have picked? Add a Target cell (say 20%) and a column F:

=MAX(0, C2 - Target*D2)

For the everyday card, $1,850 − 20% × $5,000 = $850. For the travel card the result is 0, because it is already below the target. The same idea works for the total: =MAX(0, C6 - Target*D6) tells you how much of the combined balance would need to go before the overall ratio reaches the target. The target is your choice; the formula only shows the amount, not whether that ratio is worth aiming for.

How do you track utilization month by month?

One snapshot tells you little. A year of statements shows whether utilization is creeping up and which card drives it. Turn the sheet into a long table, one row per card per statement:

A pivot table with statement month in rows, card in columns and the sum of Balance and Limit as values gives you each month's overall ratio with one more calculated field: balance ÷ limit. Adding a line chart of the overall column makes trends obvious.

Collecting balance and limit is quick: both are in the account summary near the top of each statement, which how to read a credit card statement points out. If you want the transactions as well, for example to see which purchases pushed a month to 46%, QuickBankConvert reads a credit card statement PDF and returns the transactions as rows, with the statement period and closing balance shown above the preview. The upload is processed on our servers; a free account can download CSV or Excel files, and credit card statement to Excel explains the output.

Common mistakes in utilization calculations

• Using available credit instead of the limit. Available credit is the limit minus the balance. Dividing by it inflates the ratio.
• Mixing dates. A balance from one statement and a limit from an older one gives a wrong figure if the limit changed in between.
• Including installment loans. Utilization applies to revolving accounts. A car loan or an EMI plan's original amount does not belong in the denominator, although a card EMI that blocks part of your card limit does reduce what is available.
• Forgetting authorized-user or business cards. Whether they count depends on how the account is reported; check your credit report rather than guessing.
• Reading a percentage as a rule. The sheet tells you where you are. What a lender does with that figure depends on its own model.

Checking the figure against your credit report

Your free credit reports list each revolving account with a reported balance and limit. Comparing them with your sheet is a good monthly habit: a limit missing from the report, or a balance that looks higher than any statement, is worth querying with the bureau or the issuer. The CFPB's credit card resources cover your rights if something on a report or statement is wrong.

Related guides

• Credit card interest calculator in Excel
• Credit card payoff calculator spreadsheet
• Annual credit card spending report