A one-sheet due-date calendar for three credit cards needs one row per card per month, with columns for the statement date, due date, amount due, amount paid, date paid and a status formula. Sorted by due date, the sheet shows which bill is next, and a conditional format flags anything due within a week.
The layout below works in Excel and in Google Sheets. All figures are made up to show how it fills in.
The columns
| Column | Heading | What goes in it |
|---|---|---|
| A | Card | A nickname for each card |
| B | Statement date | The date the bill was generated this month |
| C | Due date | The last day to pay |
| D | Amount due | Total due from the statement |
| E | Amount paid | What you actually paid |
| F | Date paid | Leave blank until paid |
| G | Status | A formula, see below |
| H | Days to due or days early | A formula, see below |
What does it look like filled in?
Here is a hypothetical November, sorted by due date.
| Card | Statement date | Due date | Amount due (₹) | Amount paid (₹) | Date paid | Status |
|---|---|---|---|---|---|---|
| Card A | 5 Nov | 25 Nov | 14,200 | 14,200 | 22 Nov | On time |
| Card B | 10 Nov | 30 Nov | 6,850 | 6,850 | 30 Nov | On time |
| Card C | 18 Nov | 8 Dec | 21,400 | 0 | blank | Pending |
The formulas
Status, in G2, filled down. Dates in C and F must be real dates, not text:
=IF(F2="","Pending",IF(F2<=C2,"On time","Late"))
Days to due for unpaid rows, or days early for paid rows, in H2:
=IF(F2="",C2-TODAY(),C2-F2)
For an unpaid row, the result is the number of days left; a negative number means overdue. For a paid row it is days early; a negative number means paid late.
Total still to pay across all cards, assuming amounts due in D and paid in E down to row 100:
=SUM($D$2:$D$100)-SUM($E$2:$E$100)
How do I flag what is due soon?
Select the data rows and add a conditional formatting rule with a custom formula. In Excel this is under Conditional Formatting, New Rule, Use a formula; in Google Sheets it is Format, Conditional formatting, Custom formula. Enter this, which colours any unpaid row due within seven days:
=AND($F2="", $C2-TODAY()<=7)
Why not just use reminders?
Reminders tell you a date is near; the sheet shows all three cards together, who is unpaid and how early you usually pay. Use both: the calendar for alerts, the sheet for the overview. The Date paid column is also your audit trail if a late fee ever shows up.
Setting up the sheet in five steps
- Type the headings from the table into row 1 and freeze the row.
- Add three rows for the current month, one per card, with a nickname in column A.
- Format the date columns as dates, so formulas can compare them.
- Paste the status and days formulas into row 2 and fill them down.
- Add the conditional formatting rule, then sort by due date each month.
Reading the November example
- Card A was paid on the 22nd against a due date of the 25th, so the days formula gives 3 days early.
- Card B was paid on its due date, so the result is 0 and the status is still On time. A zero is your cue to pay earlier next month.
- Card C is pending. If today were the 1st of December, the formula would show 7 days left, and the highlight rule would colour the row.
Because Card C's statement date is the 18th, its due date falls in the next month. Do not work out due dates by adding a fixed number of days yourself: copy each one from the statement, since the gap can differ between cards.
When a sheet stops being enough
If you add more cards or want the spending next to the due dates, a tracker helps. SpendixAI keeps each card as its own account, imports statements as PDF, CSV or Excel with rows reviewed before saving, and Pro has bills and budgets. The sheet still works well as a simple payment log.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

