Debt

Tracking balances across several credit cards in one sheet

A simple sheet to track balances across several credit cards: columns, formulas for total outstanding and due-soon alerts, with an invented example.

Editorial illustration for Tracking balances across several credit cards in one sheet

To track several credit cards in one sheet, give each card a row and keep the same eight columns: card, limit, statement date, due date, balance, minimum due, amount paid and notes. Add a few small formulas for what is still unpaid, days left to the due date and the total outstanding across all cards. The layout below works in Excel and Google Sheets.

What columns should the sheet have?

Put the headings in row 1 and one card per row from row 2. Here is a made-up four-card example. The card names are placeholders and every figure is invented.

A: CardB: LimitC: Statement dateD: Due dateE: BalanceF: Minimum dueG: Amount paidH: Notes
Card A₹1,50,0005 Nov25 Nov₹32,400₹1,620₹32,400Paid in full
Card B₹80,00012 Nov2 Dec₹18,750₹940₹5,000Part paid
Card C₹60,00018 Nov8 Dec₹9,200₹460₹0Pay after salary
Card D₹1,00,00025 Nov15 Dec₹0₹0₹0No spends this cycle

Keep the date columns as real dates, not text. That lets the formulas below work, and it lets you sort by due date.

Which formulas does it need?

Fill these in for row 2 and drag them down. They assume your four cards sit in rows 2 to 5.

  • Still unpaid (column I): =E2-G2
  • Days to due date (column J): =D2-TODAY()
  • Status (column K): =IF(G2>=E2,"Paid",IF(G2>=F2,"Minimum met",IF(G2>0,"Short of minimum","Unpaid")))
  • Pay-soon flag (column L): =IF(AND(I2>0,J2<=5,J2>=0),"Pay soon","")
  • Total outstanding: =SUM(I2:I5)
  • Total limit: =SUM(B2:B5)

In the example, Card A shows ₹0 unpaid, Card B shows ₹13,750 (18,750 minus 5,000), Card C shows ₹9,200 and Card D shows ₹0. The total outstanding is 0 + 13,750 + 9,200 + 0 = ₹22,950.

How do you stop it going out of date?

A tracker only helps if it matches the statement. Pick one day a week, say Sunday evening, and spend five minutes on it. When a new statement arrives, overwrite the balance, minimum and due date for that card and clear the amount-paid cell. Do not delete old rows; instead copy each cycle's figures to a second sheet called History so you can see the pattern later.

  1. Download or open each card's latest statement.
  2. Update statement date, due date, balance and minimum.
  3. Reset amount paid to zero.
  4. After you pay, type the amount and the date in Notes.
  5. Sort the sheet by due date so the nearest one is on top.

Can you see everything on one screen?

Add conditional formatting to column J: select J2:J5, choose a rule that highlights cells less than or equal to 5 and colour them amber. Add another that highlights cells less than 0 in red. Both Excel and Google Sheets can do this from the formatting menu, though the menu names differ a little between versions.

When does a sheet stop being enough?

A sheet is good for balances and due dates but it does not know what you spent each card on. If you want each card's transactions in one place, SpendixAI lets you pick the card as the account before importing its statement as PDF, CSV or Excel, so every transaction keeps that card against it. You still review rows before they are saved. Until then, the sheet above does the job.

Before you close the file

  • Every card has a limit, statement date and due date filled in.
  • The pay-soon flag is on and showing for any card due within five days.
  • Your total outstanding matches the sum of what each statement says you still owe.
  • You have a reminder in your calendar for the earliest due date.
SPENDIXAI JOURNAL

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

Explore your reports