A calendar year runs from January to December, while the financial year in India runs from April to March. Both are simply ways of grouping twelve months. For your records, the useful move is to pick the year your CA and your return follow, set that as the start of your year in your tracker, and group every report by it.
What is the difference between the two?
Both cover twelve months. The calendar year starts on 1 January. The financial year in India starts on 1 April and ends on 31 March, and it is named by the two calendar years it touches, for example 2025-26. Personal tax and business accounts here are usually kept by financial year, so most Indian records are easiest to use when grouped that way.
Where does a bill on the boundary go?
The two systems disagree most for bills near the start of a year. Consider these made-up bills.
| Bill date | Amount (₹) | Calendar year | Financial year (April to March) |
|---|---|---|---|
| 15 January 2026 | 12,000 | 2026 | 2025-26 |
| 28 March 2026 | 8,000 | 2026 | 2025-26 |
| 3 April 2026 | 9,500 | 2026 | 2026-27 |
The bills of 28 March and 3 April are only six days apart, yet they belong to different financial years, while both fall in the same calendar year. That is why the choice of year matters whenever you total up a period.
Which date decides the year: the bill date or the payment date?
Pick one rule and use it always. Many people go by the bill date, because it marks when the cost arose. Others go by the payment date, because it marks when the money moved. A bill dated 28 March and paid on 10 April lands in two different years under the two rules. Write your rule at the top of your sheet, and mention it to your CA.
How do you set the year in a spreadsheet?
To label each date with its financial year, with the date in A2, use this formula in a helper column.
- =IF(MONTH(A2)>=4, YEAR(A2)&"-"&RIGHT(YEAR(A2)+1,2), (YEAR(A2)-1)&"-"&RIGHT(YEAR(A2),2))
- For 3 April 2026 it returns 2026-27, and for 28 March 2026 it returns 2025-26.
To total spending for one financial year, with dates in A, amounts in C and the year's first day in E1, use =SUMIFS($C$2:$C$500, $A$2:$A$500, ">="&$E$1, $A$2:$A$500, "<="&EDATE($E$1,12)-1). It adds everything from the first day up to the day before the next year begins. EDATE works in Excel and Google Sheets.
Another everyday case: a vendor bill dated 31 March for a service you received in April. Under a bill-date rule it falls in the old year, though the work belongs to the new one. Do not agonise over it. Pick your rule, record the item once, and add a short note beside it, so that your CA can see you made a choice rather than a slip.
What should you check in a tracker?
- Look for a setting for the start of your year, or a date range filter you can set from April to March.
- Check that reports are grouped by the year you chose, not by default calendar months.
- Make sure the first and last days of the year are included, not missed by one.
Where a tracker fits in
If you use SpendixAI, the Report builder lets you filter by a date range and group your spending, so you can set April to March as your range and see one financial year at a time.
Last, keep the first and last day of each year visible at the top of your sheet. When a total looks off by one entry, the cause is very often a date sitting on the wrong side of 31 March or 1 April, and a visible boundary makes it quick to spot.
A year-start checklist
- Decide whether you follow the bill date or the payment date.
- Start a fresh sheet or folder for each April.
- Move any March bills still unpaid into the new year's notes.
- Keep last year's closing figures in view for comparison.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


