Cards and UPI

Which card is due when? Four statement dates in a euro spreadsheet

Build a small spreadsheet that shows the next due date and days remaining for each of your four credit cards, with formulas that work in Excel and Sheets.

Editorial illustration for Which card is due when? Four statement dates in a euro spreadsheet

A small spreadsheet can tell you, for each of four cards, the next due date and how many days are left. Enter the due day of the month once, and two formulas do the rest. It works the same in Excel and in Google Sheets, and it replaces the guessing about which card is due next.

How should the sheet be set up?

  • Column A: card name.
  • Column B: statement day of the month (a number such as 12).
  • Column C: due day of the month (a number such as 5).
  • Column D: next due date (a formula).
  • Column E: days left (a formula).
  • Column F: latest balance in euros.

Which formulas do you use?

For the next due date, put this in D2 and fill down:

  • =IF(DAY(TODAY())<=C2, DATE(YEAR(TODAY()),MONTH(TODAY()),C2), DATE(YEAR(TODAY()),MONTH(TODAY())+1,C2))
  • Days left in E2: =D2-TODAY()
  • Total balance across cards: =SUM(F2:F5)

The first formula says: if today's day is on or before the due day, use this month; otherwise use next month. DATE accepts a month number of 13 and rolls over into January of the next year. Format column D as a date and column E as a number. For a due day of 29, 30 or 31, short months will roll into the following month, so choose 28 or lower if you can.

What does it look like filled in?

CardStatement dayDue dayBalance
Blue61€420
Green149€88
Red2116€1,140
Grey3025€260

The balances total €1,908 (420 + 88 + 1,140 + 260). If today is the 12th, the Green card shows the 9th of next month, because this month's 9th has already passed. That is why a formula is better than memory, because it never offers you a date that has already gone.

How do you use the sheet each week?

  1. Open the sheet and sort by days left.
  2. Pay any card with fewer than seven days left.
  3. Update the balance column from the newest statement.
  4. Check that no due day has changed.
  5. Save a copy at month end if you want a history.

How can you extend the sheet?

Once the basics work, add two more columns. In G, put the date you last paid; in H, a formula that warns you when a due date is close. For example, =IF(D2-TODAY()<=3, "Pay now", "") shows a message when the due date is within three days. Compare it with G before you pay, so a card you have already paid is not paid twice. Keep it simple; a flag that fires too often gets ignored.

  • Colour the days-left cell red when it is below three.
  • Sort by days left each time you open the sheet.
  • Keep the balance column as text if you prefer typing the € sign.
  • Save a dated copy each quarter.

A note on the day-of-month approach: it assumes each card's due day stays fixed. If a provider moves a date, the formula keeps pointing at the old one until you change column C. Make it a habit to check the due day printed on every new statement against the sheet, and correct the cell straight away. That single check keeps the whole sheet honest.

Do you need an app instead?

Not for four cards. A sheet like this is enough. If you later want purchases categorised as well, SpendixAI is a tracker for India and INR, and so not meant for euro cards; the lesson is only that a tool should keep payments and spending separate.

SPENDIXAI JOURNAL

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

Explore your reports