Credit Card Bill Tracker in Excel: Due Dates, Pending Amount and Credit Utilisation

By Ravindra Bagale · Last updated: 17 October 2026

Download the template: credit-card-bill-tracker-template.xlsx: example data with real formulas. Yellow cells are inputs you can type over; green cells hold formulas; blue rows are headers and totals. Replace the example data with your own and everything recalculates.

Made-up data: every name, amount, shop and date on this page is made up for practice. Cities are used only to make the examples feel real.

1. The example

Amir's cards on 17 October 2026 (made-up values):

Total still to pay: ₹62,300. ₹42,300 of it is due within 5 days. Card C is already 2 days late. Overall utilisation is ₹97,500 ÷ ₹3,80,000 = 25.7%, but Card B alone is at 39.0%.

2. Build it step by step

Step 1. Type the cards

1. In A5:I5 type the headers Card, Credit limit, Due date, Total due, Paid so far, Pending, Days to due, Utilisation, Status.
2. Type each card in rows 6 to 9. Limit, due date, total due and paid are yellow inputs.
3. In B3 type the as-of date (=TODAY() in your own copy).

Step 2. Pending and days left

1. In F6 type =D6-E6: ₹42,300 still to pay.
2. In G6 type =C6-$B$3: 3 days. Dates are numbers, so subtracting them gives days (date functions).
3. Copy F6:G6 down to row 9.

Step 3. Utilisation

1. In H6 type =D6/B6 and format as %: 28.2% of Card A's limit is used.
2. In H10 type =D10/B10 for all cards together: 25.7%.

Step 4. Status

1. In I6 type =IF(F6=0,"Paid",IF(G6<0,"Overdue",IF(G6<=5,"Pay now","Upcoming"))) (nested IF).
2. The order matters: a paid card is Paid even if its date has passed.

Step 5. Totals and summary

1. In B10, D10, E10 and F10 use =SUM(...) of rows 6 to 9.
2. In L8 type =SUMIF(I6:I9,"Pay now",F6:F9): ₹42,300 needed this week (SUMIF).
3. In L9 type =INDEX(A6:A9,MATCH(MAX(H6:H9),H6:H9,0)): Card B has the highest utilisation (INDEX and MATCH).
4. In L11 type =COUNTIF(H6:H9,">"&L10) to count cards above the limit in L10 (30%).

Step 6. Colours

1. Select A6:I9 > Conditional Formatting > New Rule > Use a formula: =$I6="Overdue" red, =$I6="Pay now" amber, =$I6="Paid" green (formula rules).
2. Select H6:H9 > Highlight Cells Rules > Greater Than =$L$10 with red text.

3. Formulas used

Every formula above is written in the template, so you can click a cell and see it in the formula bar. All values on this page were recalculated in the file.

4. Common mistakes

1. Typing the minimum due instead of the total due. Paying only the minimum leaves the rest to attract interest. Track the total due and aim to clear it.
2. Using the statement date as the due date. The due date comes a few weeks after the statement date. Copy the due date printed on the statement.
3. Forgetting to update Paid. Status only turns green when column E matches the total due. Type every payment.
4. Checking only overall utilisation. Overall 25.7% looks fine, but one card at 39.0% can still be high. Look at both.
5. Typing the due date as text. If G shows #VALUE!, the date is text. Retype it as a real date such as 20-10-2026.

5. More real examples

Example 1: One card only. Keep one row and add a row per month instead. The status column becomes a payment history.

Example 2: Shared cards in a home. Add an Owner column (Ravindra, Shraddha) and use SUMIF to see each person's pending amount.

Example 3: Auto-debit cards. Type the auto-debit date in a new column and add a rule that turns the row amber if the bank balance cell is lower than the pending amount.

Quick revision cards

Englishमराठीहिंदी

Quick revision

Each card shows formulas from this page, each with an example and its answer from the template. Scan the QR code on a card to open this lesson. All names and numbers are made up for practice.

More cards: Ravi Sir's Cards.

6. Frequently asked questions

How do I calculate days left to a credit card due date in Excel?

Subtract today from the due date: =C6-$B$3, where B3 holds =TODAY(). A negative number means the date has passed.

What is credit utilisation?

The share of your credit limit you are using: total due ÷ credit limit. ₹42,300 ÷ ₹1,50,000 = 28.2%.

What utilisation is good for my credit score?

Lenders and finance writers commonly suggest keeping it at or below about 30%, and lower is better. CIBIL itself only says to keep utilisation low.

How do I show Overdue automatically?

Use a nested IF on pending and days left: =IF(F6=0,"Paid",IF(G6<0,"Overdue",...)).

Can I track several months?

Yes. Keep one sheet per month, or add a Month column and use SUMIFS by month.

7. Quick quiz

Ten questions on this page. Sign in to save your score.