The simplest card EMI calendar is a grid of months across the top and your EMIs down the side, with each cell showing the instalment due in that month. The bottom row gives your monthly EMI load, so you can see which month it drops and plan a bigger payment before the due date.
Why a grid instead of reminders?
Reminders tell you what is due today. A grid tells you what the next six months look like, which is what you need when you consider a new purchase. If the load falls sharply in March, you might wait for March; if it does not fall for a year, you will know that too.
A six-month grid with invented EMIs
Say you have three EMIs on cards from November onward: an air conditioner at ₹4,100 for 4 more months, a tablet at ₹2,250 for 3 more months, and a course fee at ₹1,500 for 5 more months.
| Item | Nov | Dec | Jan | Feb | Mar | Apr |
|---|---|---|---|---|---|---|
| Air conditioner | 4,100 | 4,100 | 4,100 | 4,100 | 0 | 0 |
| Tablet | 2,250 | 2,250 | 2,250 | 0 | 0 | 0 |
| Course fee | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 0 |
| Month total | 7,850 | 7,850 | 7,850 | 5,600 | 1,500 | 0 |
Check the totals both ways. By month: 7,850 + 7,850 + 7,850 + 5,600 + 1,500 + 0 = 30,650. By item: 4,100 × 4 = 16,400; 2,250 × 3 = 6,750; 1,500 × 5 = 7,500; and 16,400 + 6,750 + 7,500 = 30,650. If your two totals disagree, a cell is wrong.
Reading the grid: the load drops by 2,250 in February and by 4,100 in March, and in April the card EMIs are gone. That is the moment you can decide how much of the freed money goes to savings and how much to a new commitment.
How do I make the grid fill itself?
- Put month start dates in row 1 as real dates, for example 1-Nov-2026 in B1, then =EDATE(B1,1) to its right.
- In columns beyond the table, or to the left, keep each EMI's first billed month in column K, the number of instalments left in column L and the EMI amount in column M.
- In B2: =IF(AND(B$1>=$K2, B$1<=EDATE($K2,$L2-1)), $M2, 0), then fill right and down.
- Month total in B5: =SUM(B2:B4).
The formula says: if this month is on or after the first billed month and not later than the last billed month, show the EMI; otherwise zero. It works in Excel and Google Sheets.
What dates go on the calendar itself?
- The statement day for each card, repeating monthly.
- The due date for each card, with a reminder a few days earlier.
- The first month an EMI ends, so you check that the next statement drops it.
Use the dates printed on your own statement; they differ between cards and can change.
When a grid is not enough
A grid is built by hand, so it is only as good as the EMI list behind it. SpendixAI takes card statements as PDF, CSV or Excel, so the actual EMI debits are imported and reviewed rather than retyped, and the bills feature on Pro can hold a due date. It will not know how many instalments remain; that count stays in your grid.
Next steps
- List each EMI with its first billed month and instalments left.
- Fill the grid and check the two totals.
- Add statement and due dates to your calendar.
- Review the grid once a quarter or when a new EMI starts.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

