Report totals change with the date filter, not only with your spending. Calendar month, last 30 days, a card statement period and a financial year each cover a different set of days, so the same account can honestly produce four different totals. Know which filter you used before comparing numbers.
Four common filters side by side
| Filter | What it covers | Typical trap |
|---|---|---|
| Calendar month | 1 to 30 November | Cleanest for budgets, but a month-to-date view looks low early in the month |
| Last 30 days | The 30 days ending today | Slides every day and mixes two months |
| Statement period | For example 16 October to 15 November | Does not line up with calendar months or salary dates |
| Financial year | 1 April to 31 March | A calendar-year filter splits it into two parts |
Calendar month versus last 30 days
Say it is 20 November. Calendar month to date covers 1 to 20 November, 20 days, and shows ₹26,000. Last 30 days covers 22 October to 20 November, which adds 10 October days. If you spent ₹14,000 over 22 to 31 October, including ₹9,000 of festive purchases, the last-30-days total is 26,000 + 14,000 = ₹40,000. Neither is wrong. They answer different questions.
Why does my card statement total not match my November total?
Because the statement period is not a calendar month. If the statement runs from 16 October to 15 November, a ₹6,500 purchase on 16 November belongs to the next statement but to November in a calendar view. Salary-cycle budgets have the same problem if pay arrives on the 28th. Pick one frame for budgeting and stay with it.
Financial year filters
In India the financial year runs 1 April to 31 March. A ₹5,000 payment on 2 April and another ₹5,000 on 28 March are in the same financial year but different calendar years. Choose a calendar-year filter and you split the year in the middle, so your annual total for fees, insurance or donations will not match the records you keep for your CA.
What are the end-date and time edges?
Two quiet mistakes sit at the boundaries.
- End date left out. If a tool treats the end date as the very start of that day, the 30th is excluded. With ₹52,000 spent in November and ₹2,800 of it on the 30th, you would see ₹49,200.
- Time zones. A ₹1,250 UPI payment at 12:10 am on 1 December in India is 18:40 on 30 November in UTC. A tool that groups by UTC date could place it in November. It is worth checking against a late-night payment of your own.
How do you check a total quickly?
- Write the start date and end date next to every figure you note down.
- Pick one boundary payment, such as one from the last day or first day of a month, and see which period it falls in.
- Compare with the bank statement for the same dates, not the same month name.
- If two reports disagree, change both to the same custom range before comparing anything else.
What about salary-cycle months?
If salary arrives on the 28th, a calendar month can feel wrong, because the money for November was received in October. A custom range from 28 October to 27 November lines spending up with the pay that funded it. A ₹3,000 payment on 28 October then falls in the November cycle. Choose a cycle once, write it down, and use it every month, otherwise comparisons across months will not hold up.
A short checklist before you trust a total
Confirm the filter name, the start date, the end date, the account selection, and whether the figure is gross or net of refunds. When you set a period in the SpendixAI Report builder, the same habit applies: write the dates beside the number so you can reproduce it later.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


