To track statement dates across several cards, keep one row per card with its statement day and due day, then let a formula work out the next due date and the days left. Sort by days left and the card that needs attention first is always at the top.
What is the difference between the dates?
- Statement (closing) date: the day the cycle ends and the balance is fixed for the bill.
- Due date: the day by which the payment should arrive.
- Posting date: the day your payment actually shows on the card, which can be later than the day you pressed pay.
Your tracker needs the first two for every card, and your payment record should show the third.
How do I set up the sheet?
| Column | Content | Example |
|---|---|---|
| A | Card name | Travel card |
| B | Statement day of month | 3 |
| C | Due day of month | 28 |
| D | Next due date | Formula |
| E | Days left | Formula |
| F | Balance on last statement ($) | Typed |
| G | Paid? | Yes or No |
Next due date in D2: =IF(DAY(TODAY())<=C2, DATE(YEAR(TODAY()), MONTH(TODAY()), C2), DATE(YEAR(TODAY()), MONTH(TODAY())+1, C2)). Days left in E2: =D2-TODAY(). Both work in Excel and Google Sheets. DATE rolls month 13 into January of the next year, so December is handled.
One limit: if a due day is 31 and the month is shorter, DATE moves into the next month. Use 28 as a safe due day in the sheet only if your card allows, or adjust that card by hand.
A worked example for three cards
Say today is 15 November 2026. The numbers are invented.
| Card | Statement day | Due day | Next due | Days left |
|---|---|---|---|---|
| Card A | 3 | 28 | 28 Nov | 13 |
| Card B | 12 | 7 | 7 Dec | 22 |
| Card C | 20 | 15 | 15 Nov | 0 |
Card A: the due day 28 is still ahead this month, so 28 November, 13 days away (28 minus 15). Card B: day 7 has passed, so it rolls to 7 December, which is 15 days left in November plus 7 equals 22. Card C: day 15 is today, which the formula treats as still due, so it shows 0 days: pay today.
How do I make it impossible to miss?
- Select column E and add conditional formatting: red for 3 or fewer, amber for 4 to 7.
- Sort the table by column E each time you open it.
- Put a repeating calendar event on each due day, with an alert a few days before.
- Keep the Paid column honest: set it to No on each statement day and Yes after payment posts.
What about autopay?
Autopay helps, but check what amount it pays and which account it draws from. Keep the tracker anyway, since it tells you if a payment failed and lets you plan cash for the day.
Scope of this guide
This covers the spreadsheet method in dollars. Rules on grace periods or fees depend on your card and where you live, so use your card agreement. SpendixAI is built around India and INR and is not intended for dollar cards.
What if I add a new card or close one?
Add a row the day the card arrives, with the statement and due days from its first paperwork, since the first cycle can be shorter. When you close a card, set Paid to Closed and move the row to a second tab instead of deleting it, so your history stays. Review the sheet whenever a card issuer changes your due date, which usually comes with a notice you should keep.
Checklist
- Statement and due day for every card typed from the statement.
- Formulas filled down.
- Colour flags on.
- Payment posting dates noted.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

