Cards and UPI

Seeing total outstanding across all your cards in one place

See your total credit card outstanding in one place by adding billed and unbilled balances for each card and listing the due date next to every one.

Editorial illustration for Seeing total outstanding across all your cards in one place

To see what you owe across all your cards, list each card with two numbers, the billed amount from the latest statement and the unbilled spends since then, add them up, and put the due date beside each card. The billed part is the amount due by the due date shown on the statement. The unbilled part is already owed, but will appear on the next statement.

What is the difference between billed and unbilled?

The billed amount is the total on the last statement. The unbilled amount is what you have spent after the statement date, and it will be on your next bill. Many people look at only the billed amount, which makes their real debt look smaller. The sum of both is your true outstanding at any moment.

What does the one-page view look like?

CardStatement dateBilled (₹)Due dateUnbilled (₹)Total owed (₹)
Card A5th12,40025th3,10015,500
Card B12th4,8001st6,20011,000
Card C20th010th2,3502,350
All cards-17,200-11,65028,850

These are invented numbers. Check the arithmetic: 12,400 + 3,100 is 15,500; 4,800 + 6,200 is 11,000; 0 + 2,350 is 2,350. The totals are 12,400 + 4,800 + 0 = 17,200 billed and 3,100 + 6,200 + 2,350 = 11,650 unbilled, together ₹28,850.

Where do I find each number?

  • Billed amount and due date: the latest statement from each card issuer, in its app or email.
  • Statement date: the same statement. Cycles differ by card, so note them separately.
  • Unbilled spends: add up your own records of purchases since the statement date, or look at the unbilled section in your card's app if it shows one.
  • Payments you have already made after the statement: subtract these from the billed amount.

Do not rely on a quick glance at the available limit as a substitute. It can reflect holds and recent payments differently from your own list.

How do I do this in a spreadsheet?

Put one card per row. With billed in column C and unbilled in column E, the total owed in F2 is =C2+E2, and the grand total is =SUM(F2:F10). To see which card is due first, sort by the due date column, or flag cards due within a week using =IF(D2-TODAY()<=7,"Due soon","") in column G, provided column D holds real dates rather than text.

How often should I update it?

Refresh it when a new statement arrives and once in the middle of each cycle. Twice a month is enough to avoid surprises, and it takes about ten minutes once the sheet exists. Also update it when you make a large payment or purchase.

What should I do with the number?

  1. Compare the total owed with the balance you have in your bank accounts for the next few weeks.
  2. Pay the billed amounts by their due dates, in order, so none is late.
  3. If the number is bigger than you expected, look at the unbilled column first. It is the part you can still influence.
  4. Check each card's terms for how the minimum due and interest work, rather than guessing.

If paying in full is hard, work out in advance which card to pay first and talk to the issuer early. This article cannot say what is best for your situation, so ask your bank or a financial counsellor if you are worried.

Where a tracker helps

If you record each card as an account and import statements into SpendixAI, you can see spending by account without adding it up by hand. It does not show your card's live outstanding or sync with your bank, so keep the billed and due-date figures from the statement in your own note, and use the tracker for the unbilled spends since the last statement date.

Quick checklist

  • One row per card with statement and due dates.
  • Billed plus unbilled equals total owed.
  • Sorted by the nearest due date.
  • Reviewed twice a month.
SPENDIXAI JOURNAL

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

Explore your reports